Operator Contacts

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.

Sample File NameSample Description
operator_contacts_bizjets.csvSubset for business jets
operator_contacts_comav.csvSubset for commercial aviation
operator_contacts.csvSample data for commercial aviation and business jets
Contact IDint(11)Unique ch-aviation created contact IDOperator ContactsPrimary
Operator Namevarchar(255)Operator nameOperator Contacts
Operator ch-a Codevarchar(5)Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.Operator ContactsForeignOperatorsOperator ch-a Code
Legal Namevarchar(255)Operator legal nameOperator Contacts
IATAchar(2)Operator IATA two-character codeOperator Contacts
ICAOchar(3)Operator ICAO three-character codeOperator Contacts
Operator 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)Operator Contacts
Operator 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)Operator Contacts
Operator Statusvarchar(255)Operator status: Active, Start-Up, Restarting, Not Launched, Out of Business, Rebranded, MergedOperator Contacts
Locationvarchar(255)Location airport name (closest airport if not based at airport itself)Operator Contacts
Location IDint(11)Location ID (assigned by ch-aviation)Operator ContactsForeignAirportsAirport ID
Countryvarchar(255)Country nameOperator Contacts
Country ISOchar(2)ISO 3166-1 Alpha-2 country codeOperator ContactsForeignCountriesCountry ISO
EU Countrychar(3)European Union country: Yes / No / (NULL)Operator Contacts
Titlechar(2)Mr / MsOperator Contacts
Firstnamevarchar(48)First nameOperator Contacts
Lastnamevarchar(48)Last nameOperator Contacts
Job Groupvarchar(48)Job Group description (for filtering purposes)Operator Contacts
Job Titlevarchar(127)Job titleOperator Contacts
Emailvarchar(255)E-Mail address (masked in sample data)Operator Contacts
Social Mediavarchar(255)Social media URLOperator Contacts