Regional Carriers
Column | Data Type | Data description | Package required | Key | Data Set | Join On |
---|---|---|---|---|---|---|
Airline Name | varchar(255) | Operator name | Airlines | |||
Airline Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Airlines | Primary | Airlines | Airline ch-a Code |
Rel Subsidiary | varchar(48) | Regional brand under which the operator operates | Airlines | Primary/Foreign | Regional Subsidiaries | Rel Subsidiary |