Aircraft Orders
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.
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| Customer ch-aviation code | varchar(5) | Operator (2an, 3an, 5an) or Entity (4an) ch-aviation code (assigned by ch-aviation). | Fleets | Foreign | Entities/Operators | Entity ch-a Code/Operator ch-a Code |
| Customer | varchar(255) | Customer name of ordering party (either an entity or operator) | Fleets | |||
| Customer IATA | char(2) | Operator IATA two-character code | Fleets | |||
| Customer ICAO | char(2) | Operator ICAO three-character code | Fleets | |||
| Continent | varchar(255) | Continent name | Fleets | |||
| Country | varchar(255) | Country name | Fleets | |||
| Country ISO | varchar(255) | ISO 3166-1 Alpha-2 country code | Fleets | Foreign | Countries | Country ISO |
| Market Group | varchar(255) | Market group (Business Jets - Airliners, Business Jets - Large Jets, Business Jets - Light Jets, Business Jets - Midsize Jets, Business Jets - Super Midsize Jets, Business Jets - Ultra Long-Range Jets, Business Jets - Very Light Jets, Commercial Aviation - Military Aircraft, Commercial Aviation - Narrowbody Jets, Commercial Aviation - Regional Jets, Commercial Aviation - Turboprops, Commercial Aviation - Widebody Jets) | Fleets | |||
| Manufacturer | varchar(255) | Aircraft Manufacturer Name | Fleets | |||
| Manufacturer Code | varchar(3) | Aircraft Manufacturer ch-aviation code (assigned by ch-aviation) | Fleets | Foreign | Operators | Operator ch-a Code |
| Engine Manufacturer | varchar(255) | Engine manufacturer name | Fleets | |||
| Engine Manufacturer ch-a Code | varchar(4) | Engine manufacturer ch-aviation code (assigned by ch-aviation) | Fleets | Foreign | Entities | Entity ch-a Code |
| Engine Family | varchar(16) | Engine family (i.e. JT9D) | Fleets | |||
| Engine Master Series | varchar(32) | Engine master series designation (i.e. JT9D-7R4) | Fleets | |||
| Engine Type | varchar(16) | Engine type designation (i.e. PW JT9D) | Fleets | |||
| Engine Subtype | varchar(32) | Engine subtype designation (i.e. PW JT9D-7R4H1) | Fleets | |||
| Aircraft Family | varchar(255) | Aircraft Family designation (i.e. A320N) | Fleets | |||
| Aircraft Variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | Fleets | Foreign | Aircraft Variants | variant_text |
| Aircraft on Order | int(11) | Number of aircraft on order | Fleets |