| Column |
Data Type |
Data description |
Package required |
Key |
Data Set |
Join On |
| ID |
int(11) |
Unique ch-aviation created aircraft code ID |
Fleets |
Primary |
|
|
| IATA |
char(3) |
Aircraft three character IATA code (ch-aviation assigns dummy IATA codes to types for which IATA has not designated a code) |
Fleets |
Unique |
|
|
| Aircraft Class |
char(3) |
Aircraft class three character IATA code (ch-aviation assigns dummy IATA codes to types for which IATA has not designated a code) |
Fleets |
|
|
|
| Description |
varchar(255) |
Aircraft description |
Fleets |
|
|
|
| Short Description |
varchar(32) |
Abbreviated aircraft description |
Fleets |
|
|
|
| Equipment Type |
varchar(255) |
Equipment type description (Helicopter, Jet-engined aircraft, Piston-engined aircraft, Turboprop-engined aircraft) |
Fleets |
|
|
|
| Min Cockpit Crew |
int(11) |
Minimum cockpit crew |
Fleets |
|
|
|
