Operators
To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.
To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| Operator Name | varchar(255) | Operator name | Operators | |||
| Operator ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Operators | Primary | ||
| Legal Name | varchar(255) | Operator legal name | Operators | |||
| Manufacturer | char(3) | Indication if the operator is an aircraft manufacturer: yes / no / (NULL) | Operators | |||
| Location | varchar(255) | Location airport name (closest airport if not based at airport itself) | Operators | |||
| Location ch-a Code | varchar(6) | Airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code) | Operators | |||
| Location ID | int(11) | Location ID (assigned by ch-aviation) | Operators | Foreign | Airports | Airport ID |
| Continent | varchar(255) | Continent name | Operators | |||
| Subdivision | varchar(255) | State description | Operators | |||
| Subdivision ch-a Code | char(2) | ISO 3166-2 Alpha-2 subdivision code (used for states) | Operators | Foreign | States | State ISO |
| Metro Group | varchar(255) | Metro group name | Operators | |||
| Metro Group IATA | char(3) | Metro group three character IATA code | Operators | Foreign | Metro Groups | Metro_Group |
| Country | varchar(255) | Country name | Operators | |||
| Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Operators | Foreign | Countries | Country ISO |
| Country IASA Status | char(1) | Country International Aviation Safety Assessment program status (assigned by FAA): 0 – not assessed / 1 – Category 1 (meets ICAO standards) / 2 – Category 2 (does not meet ICAO standards) | Operators | |||
| IATA | varchar(2) | Operator IATA two-character code | Operators | |||
| ICAO | varchar(3) | Operator ICAO three-character code | Operators | |||
| Type | varchar(255) | Description of operator's primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Passenger Charter, Business/Private Charter Government, Manufacturer, Supplier, Private operators, Flight Departments, Ferry Flight Provider) | Operators | |||
| Type Code | char(1) | Operator type code: S - Scheduled Carrier, V - Virtual Carrier, D - Division, C - Cargo Carrier, P -Passenger Charter, B - Business/Private Charter, G - Government, M - Manufacturer, U - Supplier, O - Private operators, T - Flight Departments, R - Ferry Flight Provider) | Operators | |||
| Status | varchar(255) | Operator status: Active, Start-Up, Restarting, Not Launched, Out of Business, Rebranded, Merged | Operators | |||
| Operator Info | varchar(255) | Free text remarks | Operators | |||
| IOSA Certified | char(3) | IOSA certification: yes / no / (NULL) | Operators | |||
| Offers ACMI Leases | char(3) | Operator actively offers ACMI leases: yes / no / (NULL) | Operators | |||
| Alliance | varchar(255) | Alliance name | Operators | |||
| Alliance ch-a Code | char(2) | Alliance ch-aviation code (assigned by ch-aviation) | Operators | Foreign | Alliances | Alliance_Code |
| Parent | varchar(255) | Parent name | Operators | |||
| Parent ch-a Code | varchar(4) | Parent operator ch-aviation code (assigned by ch-aviation) | Operators | Foreign | Operators | Operator ch-a Code |
| Merged into | varchar(255) | Operator name this operator was merged into/rebranded to (only filled if carrier has Rebranded or Merged status) | Operators | |||
| Merged into ch-a Code | varchar(5) | Operator ch-aviation code of operator this operator was merged into/rebranded to (assigned by ch-aviation) (only filled if carrier has Rebranded or Merged status). Operator ch-aviation codes can be 2, 3, or 5 characters. | Operators | Foreign | Operators | Operator ch-a Code |
| Charter Availability | tinyint(1) | Offers charter flights (only filled for carriers with Scheduled status): 0 -no / 1 – yes | Operators | |||
| Cargo Carrier Type Code | char(1) | Cargo carrier type (only filled for operators with Type Cargo Carrier): C – Charter / S – Scheduled / (NULL) | Operators | |||
| Cargo Carrier Type | varchar(9) | Cargo carrier type (only filled for operators with Type Cargo Carrier): Charter / Scheduled / (NULL) | Operators | |||
| Address | varchar(512) | Address description | Operators | |||
| City | varchar(255) | City description | Operators | |||
| Address Country | varchar(255) | Address country name | Operators | |||
| Address Country ISO | char(2) | Address country ISO 3166-1 Alpha-2 country code | Operators | Foreign | Countries | Country ISO |
| EU Country | char(3) | European Union country: Yes / No / (NULL) | Operators | |||
| Phone Country ISO | char(2) | Phone country ISO 3166-1 Alpha-2 country code | Operators | Foreign | Countries | Country ISO |
| Phone Country Code | varchar(255) | Phone country dialling code | Operators | |||
| Phone Number | varchar(255) | Switchboard phone number | Operators | |||
| varchar(255) | Generic e-mail address | Operators | ||||
| Charter Email | varchar(255) | Generic charter e-mail address | Operators | |||
| Website | varchar(255) | Website URL | Operators | |||
| varchar(255) | LinkedIn profile URL | Operators | ||||
| varchar(255) | Facebook profile URL | Operators | ||||
| X | varchar(255) | Twitter profile URL | Operators | |||
| Stock Ticker | varchar(255) | Stock market ticker URL | Operators | |||
| Start-Up Info | varchar(255) | Start-up information free text | Operators | |||
| Start-Up added | date | Date the start-up was added to the ch-aviation database | Operators | |||
| Start-Up last updated | date | Date the start-up status was last updated | Operators | |||
| Launch Year | int(4) | Year the operator was launched | Operators | |||
| Planned Start-up | varchar(255) | Planned start-up quarter (formatted yyyy/qq) | Operators | |||
| Termination Year | int(4) | Year the operator stopped operations | Operators | |||
| Total Seats in Fleet | decimal(10,0) | Number of total seats of all aircraft operated by the operator | Fleets | |||
| Number of Aircraft | bigint(20) | Number of aircraft operated by the operator | Fleets | |||
| Aircraft on Order | decimal(10,0) | Number of aircraft on order by the operator | Fleets | |||
| Number of Engines | decimal(10,0) | Number of engines fitted to aircraft operated by the operator | Fleets | |||
| Reservation System | varchar(255) | Name of the reservation system used by the operator | Operators | |||
| Reservation System ch-a Code | char(4) | Reservation system ch-aviation code (assigned by ch-aviation) | PSS | Foreign | PSS | System ch-a Code |