Column |
Data Type |
Data description |
Package required |
Key |
Data Set |
Join On |
ID |
int(11) |
Unique ch-aviation created aircraft data ID |
Fleets |
Primary |
|
|
Aircraft 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/Foreign |
Aircraft Codes |
IATA |
Aircraft ICAO |
varchar(32) |
Aircraft four character ICAO codes, separated by “/” (since this data is built around IATA codes, there is a one-to-many relationship) |
Fleets |
|
|
|
Manufacturer |
varchar(3) |
Aircraft Manufacturer ch-aviation code (assigned by ch-aviation) |
Fleets |
Foreign |
Entities |
Entity ch-a Code |
Delivery Location |
varchar(255) |
Delivery location ch-aviation airport codes, separated by commas |
Fleets |
Foreign |
Airports |
Airport ch-a Code |
Production From |
varchar(255) |
Production start year |
Fleets |
|
|
|
Production To |
varchar(255) |
Production end year |
Fleets |
|
|
|
Production Line |
varchar(9) |
Production Line designation (i.e. A320) |
Fleets |
|
|
|
MTOW (kg) |
int(11) |
Maximum take-off weight for the highest MTOW variant in kilograms |
Fleets |
|
|
|
MTOW (lb) |
int(11) |
Maximum take-off weight for the highest MTOW variant in pounds |
Fleets |
|
|
|
Free Text |
varchar(255) |
Free text remarks |
Fleets |
|
|
|
Fleet Data |
tinyint(1) |
Indicator if fleet data is available: 1: yes, 0: no |
Fleets |
|
|
|
Fleet Data Incomplete |
tinyint(1) |
Indicator that fleet data is available but incomplete: 1: incomplete, 0: not applicable |
Fleets |
|
|
|
Avg HR Charter Cost |
int(11) |
Average hourly charter cost in USD |
Fleets |
|
|
|
Market Group ID |
int(11) |
Market group ID (assigned by ch-aviation) |
Fleets |
|
|
|
Market Group Name |
varchar(255) |
Market group (Widebodies, Narrowbodies, Regional Jets, Regional Turboprops, Military Aircraft) |
Fleets |
|
|
|
Engine Number |
int(11) |
Number of engines |
Fleets |
|
|
|
Maxpax |
varchar(255) |
Maximum number of passengers |
Fleets |
|
|
|
Speed (km/h) |
varchar(255) |
Cruising speed in kilometres per hour (km/h) |
Fleets |
|
|
|
Speed (mph) |
varchar(255) |
Cruising speed in miles per hour (mph) |
Fleets |
|
|
|
Noisecat |
char(1) |
ICAO Noise Category Stage: 1 / 2 / 3 / 4 / 5 |
Fleets |
|
|
|
First Flight |
varchar(255) |
First flight date |
Fleets |
|
|
|
Cockpit Crew |
varchar(255) |
Number of cockpit crew required |
Fleets |
|
|
|