Airlines

Column Data Type Data description Package required Key Data Set Join On
Airline Name varchar(255) Operator name Airlines
Airline ch-a Code varchar(3) Operator ch-aviation code (assigned by ch-aviation) Airlines Primary
Legal Name varchar(255) Operator legal name Airlines
Manufacturer char(3) Indication if the operator is an aircraft manufacturer: yes / no / (NULL) Airlines
Location varchar(255) Location airport name (closest airport if not based at airport itself) Airlines
Location ch-a Code varchar(6) Airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code) Airlines
Location ID int(11) Location ID (assigned by ch-aviation) Airlines Foreign Airports Airport ID
Continent varchar(255) Continent name Airlines
Subdivision varchar(255) State description Airlines
Subdivision Code char(2) ISO 3166-2 Alpha-2 subdivision code (used for states) Airlines Foreign States State ISO
Metro Group varchar(255) Metro group name Airlines
Metro Group IATA char(3) Metro group three character IATA code Airlines Foreign Metro Groups Metro_Group
Country varchar(255) Country name Airlines
Country ISO char(2) ISO 3166-1 Alpha-2 country code Airlines Foreign Countries Country ISO
Country_IASA_Status char(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) Airlines
IATA varchar(2) Airline IATA two-character code Airlines
ICAO varchar(3) Airline ICAO three-character code Airlines
Type varchar(255) Description of operator’s primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Business/Private Carrier, Government, Manufacturer, Supplier) Airlines
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 Airlines
Status varchar(255) Operator status: Active, Start-Up, Restarting, Not Launched, Out of Business, Rebranded, Merged Airlines
Airline Info varchar(255) Free text remarks Airlines
IOSA Certified char(3) IOSA certification: yes / no / (NULL) Airlines
Offers ACMI Leases char(3) Operator actively offers ACMI leases: yes / no / (NULL) Airlines
Alliance varchar(255) Alliance name Airlines
Alliance ch-a Code char(2) Alliance ch-aviation code (assigned by ch-aviation) Airlines Foreign Alliances Alliance_Code
Parent varchar(255) Parent name Airlines
Parent ch-a Code varchar(4) Parent operator ch-aviation code (assigned by ch-aviation) Airlines Foreign Airlines Airline ch-a Code
Merged into varchar(255) Operator name this operator was merged into/rebranded to (only filled if carrier has Rebranded or Merged status) Airlines
Merged into ch-a Code varchar(4) 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) Airlines Foreign Airlines Airline ch-a Code
Charter Availability tinyint(1) Offers charter flights (only filled for carriers with Scheduled status): 0 -no / 1 – yes Airlines
Cargo Carrier Type Code char(1) Cargo carrier type (only filled for operators with Type Cargo Carrier): C – Charter / S – Scheduled / (NULL) Airlines
Cargo Carrier Type varchar(9) Cargo carrier type (only filled for operators with Type Cargo Carrier): Charter / Scheduled / (NULL) Airlines
Address varchar(512) Address description Airlines
City varchar(255) City description Airlines
Address Country varchar(255) Address country name Airlines
Address Country ISO char(2) Address country ISO 3166-1 Alpha-2 country code Airlines Foreign Countries Country ISO
EU Country char(3) European Union country: Yes / No / (NULL) Airlines
Phone Country ISO char(2) Phone country ISO 3166-1 Alpha-2 country code Airlines Foreign Countries Country ISO
Phone Country Code varchar(255) Phone country dialling code Airlines
Phone Number varchar(255) Switchboard phone number Airlines
Email varchar(255) Generic e-mail address Airlines
Charter Email varchar(255) Generic charter e-mail address Airlines
Website varchar(255) Website URL Airlines
Linkedin varchar(255) LinkedIn profile URL Airlines
Facebook varchar(255) Facebook profile URL Airlines
Twitter varchar(255) Twitter profile URL Airlines
Stock Ticker varchar(255) Stock market ticker URL Airlines
Start-Up Info varchar(255) Start-up information free text Airlines
Start-Up added date Date the start-up was added to the ch-aviation database Airlines
Start-Up last updated date Date the start-up status was last updated Airlines
Launch Year int(4) Year the operator was launched Airlines
Planned Start-up varchar(255) Planned start-up quarter (formatted yyyy/qq) Airlines
Termination Year int(4) Year the operator stopped operations Airlines
Total Seats in Fleet decimal(10,0) Number of total seats of all aircraft operated by the operator Fleets
Number of Aircraft bigint(20) Number of aircraft operated by the operator Fleets
Aircraft on Order decimal(10,0) Number of aircraft on order by the operator Fleets
Number of Engines decimal(10,0) Number of engines fitted to aircraft operated by the operator Fleets
Reservation System varchar(255) Name of the reservation system used by the operator PSS