Aircraft Variants
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 | Key | Data Set | Join On |
---|---|---|---|---|---|
id | int(10) | Auto increment aircraft variant ID | Primary | ||
variant_code | char(7) | ch-aviation assigned unique aircraft variant code | |||
variant_text | varchar(255) | Aircraft variant name | Unique | ||
aircraft | varchar(255) | Aircraft type grouping the aircraft variant belongs to | |||
default_iata_code | char(3) | Typical aircraft IATA code for the variant | Foreign | Aircraft Codes | IATA |
aviation_segment_code | char(3) | Aviation Segment (CMC = Commercial Aviation, BZA = Business Jets) |