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 Name | Sample Description |
---|---|
operator_contacts_bizjets.csv | Subset for business jets |
operator_contacts_comav.csv | Subset for commercial aviation |
operator_contacts.csv | Sample data for commercial aviation and business jets |
Contact ID | int(11) | Unique ch-aviation created contact ID | Operator Contacts | Primary | ||
---|---|---|---|---|---|---|
Operator Name | varchar(255) | Operator name | Operator Contacts | |||
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. | Operator Contacts | Foreign | Operators | Operator ch-a Code |
Legal Name | varchar(255) | Operator legal name | Operator Contacts | |||
IATA | char(2) | Operator IATA two-character code | Operator Contacts | |||
ICAO | char(3) | Operator ICAO three-character code | Operator Contacts | |||
Operator 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) | Operator Contacts | |||
Operator 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) | Operator Contacts | |||
Operator Status | varchar(255) | Operator status: Active, Start-Up, Restarting, Not Launched, Out of Business, Rebranded, Merged | Operator Contacts | |||
Location | varchar(255) | Location airport name (closest airport if not based at airport itself) | Operator Contacts | |||
Location ID | int(11) | Location ID (assigned by ch-aviation) | Operator Contacts | Foreign | Airports | Airport ID |
Country | varchar(255) | Country name | Operator Contacts | |||
Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Operator Contacts | Foreign | Countries | Country ISO |
EU Country | char(3) | European Union country: Yes / No / (NULL) | Operator Contacts | |||
Title | char(2) | Mr / Ms | Operator Contacts | |||
Firstname | varchar(48) | First name | Operator Contacts | |||
Lastname | varchar(48) | Last name | Operator Contacts | |||
Job Group | varchar(48) | Job Group description (for filtering purposes) | Operator Contacts | |||
Job Title | varchar(127) | Job title | Operator Contacts | |||
varchar(255) | E-Mail address (masked in sample data) | Operator Contacts | ||||
Social Media | varchar(255) | Social media URL | Operator Contacts |