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.

ColumnData TypeData descriptionPackage requiredKeyData SetJoin On
Operator Namevarchar(255)Operator nameOperators
Operator ch-a Codevarchar(5)Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.OperatorsPrimary
Legal Namevarchar(255)Operator legal nameOperators
Manufacturerchar(3)Indication if the operator is an aircraft manufacturer: yes / no / (NULL)Operators
Locationvarchar(255)Location airport name (closest airport if not based at airport itself)Operators
Location ch-a Codevarchar(6)Airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code)Operators
Location IDint(11)Location ID (assigned by ch-aviation)OperatorsForeignAirportsAirport ID
Continentvarchar(255)Continent nameOperators
Subdivisionvarchar(255)State descriptionOperators
Subdivision ch-a Codechar(2)ISO 3166-2 Alpha-2 subdivision code (used for states)OperatorsForeignStatesState ISO
Metro Groupvarchar(255)Metro group nameOperators
Metro Group IATAchar(3)Metro group three character IATA codeOperatorsForeignMetro GroupsMetro_Group
Countryvarchar(255)Country nameOperators
Country ISOchar(2)ISO 3166-1 Alpha-2 country codeOperatorsForeignCountriesCountry ISO
Country IASA Statuschar(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
IATAvarchar(2)Operator IATA two-character codeOperators
ICAOvarchar(3)Operator ICAO three-character codeOperators
Typevarchar(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 Codechar(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
Statusvarchar(255)Operator status: Active, Start-Up, Restarting, Not Launched, Out of Business, Rebranded, MergedOperators
Operator Infovarchar(255)Free text remarksOperators
IOSA Certifiedchar(3)IOSA certification: yes / no / (NULL)Operators
Offers ACMI Leaseschar(3)Operator actively offers ACMI leases: yes / no / (NULL)Operators
Alliancevarchar(255)Alliance nameOperators
Alliance ch-a Codechar(2)Alliance ch-aviation code (assigned by ch-aviation)OperatorsForeignAlliancesAlliance_Code
Parentvarchar(255)Parent nameOperators
Parent ch-a Codevarchar(4)Parent operator ch-aviation code (assigned by ch-aviation)OperatorsForeignOperatorsOperator ch-a Code
Merged intovarchar(255)Operator name this operator was merged into/rebranded to (only filled if carrier has Rebranded or Merged status)Operators
Merged into ch-a Codevarchar(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.OperatorsForeignOperatorsOperator ch-a Code
Charter Availabilitytinyint(1)Offers charter flights (only filled for carriers with Scheduled status): 0 -no / 1 – yesOperators
Cargo Carrier Type Codechar(1)Cargo carrier type (only filled for operators with Type Cargo Carrier): C – Charter / S – Scheduled / (NULL)Operators
Cargo Carrier Typevarchar(9)Cargo carrier type (only filled for operators with Type Cargo Carrier): Charter / Scheduled / (NULL)Operators
Addressvarchar(512)Address descriptionOperators
Cityvarchar(255)City descriptionOperators
Address Countryvarchar(255)Address country nameOperators
Address Country ISOchar(2)Address country ISO 3166-1 Alpha-2 country codeOperatorsForeignCountriesCountry ISO
EU Countrychar(3)European Union country: Yes / No / (NULL)Operators
Phone Country ISOchar(2)Phone country ISO 3166-1 Alpha-2 country codeOperatorsForeignCountriesCountry ISO
Phone Country Codevarchar(255)Phone country dialling codeOperators
Phone Numbervarchar(255)Switchboard phone numberOperators
Emailvarchar(255)Generic e-mail addressOperators
Charter Emailvarchar(255)Generic charter e-mail addressOperators
Websitevarchar(255)Website URLOperators
Linkedinvarchar(255)LinkedIn profile URLOperators
Facebookvarchar(255)Facebook profile URLOperators
Xvarchar(255)Twitter profile URLOperators
Stock Tickervarchar(255)Stock market ticker URLOperators
Start-Up Infovarchar(255)Start-up information free textOperators
Start-Up addeddateDate the start-up was added to the ch-aviation databaseOperators
Start-Up last updateddateDate the start-up status was last updatedOperators
Launch Yearint(4)Year the operator was launchedOperators
Planned Start-upvarchar(255)Planned start-up quarter (formatted yyyy/qq)Operators
Termination Yearint(4)Year the operator stopped operationsOperators
Total Seats in Fleetdecimal(10,0)Number of total seats of all aircraft operated by the operatorFleets
Number of Aircraftbigint(20)Number of aircraft operated by the operatorFleets
Aircraft on Orderdecimal(10,0)Number of aircraft on order by the operatorFleets
Number of Enginesdecimal(10,0)Number of engines fitted to aircraft operated by the operatorFleets
Reservation Systemvarchar(255)Name of the reservation system used by the operatorOperators
Reservation System ch-a Codechar(4)Reservation system ch-aviation code (assigned by ch-aviation)PSSForeignPSSSystem ch-a Code