Operator Name | varchar(255) | Operator name | Airline Contacts | | | |
Operator ch-a Code | varchar(3) | Operator ch-aviation code (assigned by ch-aviation) | Airline Contacts | Foreign | Airlines | Airline ch-a Code |
Legal Name | varchar(255) | Operator legal name | Airline Contacts | | | |
IATA | char(2) | Airline IATA two-character code | Airline Contacts | | | |
ICAO | char(3) | Airline ICAO three-character code | Airline Contacts | | | |
Operator Type | varchar(255) | Description of operator’s primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Business/Private Carrier, Government, Manufacturer, Supplier) | Airline Contacts | | | |
Operator Type Code | char(1) | Operator type code: S – Scheduled Carrier, V – Virtual Carrier, D – Division, C – Cargo Carrier, B – Business/Private Carrier, G – Government, M – Manufacturer, U – Supplier | Airline Contacts | | | |
Operator Status | varchar(255) | Operator status: Active, Start-Up, Restarting, Not Launched, Out of Business, Rebranded, Merged | Airline Contacts | | | |
Location | varchar(255) | Location airport name (closest airport if not based at airport itself) | Airline Contacts | | | |
Location ID | int(11) | Location ID (assigned by ch-aviation) | Airline Contacts | Foreign | Airports | Airport ID |
Country | varchar(255) | Country name | Airline Contacts | | | |
Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Airline Contacts | Foreign | Countries | Country ISO |
EU Country | char(3) | European Union country: Yes / No / (NULL) | Airline Contacts | | | |
Title | char(2) | Mr / Ms | Airline Contacts | | | |
Firstname | varchar(48) | First name | Airline Contacts | | | |
Lastname | varchar(48) | Last name | Airline Contacts | | | |
Job Group | varchar(48) | Job Group description (for filtering purposes) | Airline Contacts | | | |
Job Title | varchar(127) | Job title | Airline Contacts | | | |
Email | varchar(255) | E-Mail address (masked in sample data) | Airline Contacts | | | |
Social Media | varchar(255) | Social media URL | Airline Contacts | | | |