Aircraft Codes
To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.
To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.
Sample File Name | Sample Description |
---|---|
aircraft_codes.csv | Sample data |
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 |