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