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