Aircraft Variants
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 | |||
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) |