Airline Contacts

Contact ID int(11) Unique ch-aviation created contact ID Airline Contacts Primary    
Airline Name varchar(255) Operator name Airline Contacts      
Airline 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      
Airline 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      
Airline 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      
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