Column |
Data Type |
Data description |
Package required |
Key |
Data Set |
Join On |
Airline Name |
varchar(255) |
Operator name |
Fleets Summary |
|
|
|
Airline ch-a Code |
varchar(3) |
Operator ch-aviation code (assigned by ch-aviation) |
Fleets Summary |
Primary |
Airlines |
Airline ch-a Code |
Aircraft Variant |
varchar(255) |
Aircraft Variant designation (i.e. A321-200N) |
Fleets Summary |
|
|
|
Active |
decimal(10,0) |
Number of active aircraft |
Fleets Summary |
|
|
|
Inactive |
decimal(10,0) |
Number of inactive aircraft |
Fleets Summary |
|
|
|
Wet-leased In |
decimal(10,0) |
Number of wet-leased in aircraft |
Fleets Summary |
|
|
|
Total |
decimal(10,0) |
Number of total aircraft |
Fleets Summary |
|
|
|
To be delivered |
decimal(10,0) |
Number of to be delivered aircraft |
Fleets Summary |
|
|
|