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 |
|
|
|