| Airport | varchar(255) | Airport Display Name (combination of City Name and Airport Name) | | | |
| Airport IATA | char(3) | Airport three character IATA code | Foreign | Airports | Airport IATA |
| Airport ICAO | char(4) | Airport four character ICAO code | Foreign | Airports | Airport ICAO |
| Continent | varchar(255) | Continent name | | | |
| Subdivision | varchar(255) | State name | | | |
| Subdivision ISO Code | char(2) | ISO 3166-2 Alpha-2 subdivision code (used for states) | Foreign | States | State ISO |
| Metro Group | varchar(255) | Metro Group name | | | |
| Metro Group IATA | char(3) | Metro Group three character IATA code | Foreign | Metro Groups | Metro_Group |
| Country | varchar(255) | Country name | | | |
| Country ISO Code | char(2) | ISO 3166-1 Alpha-2 country code | Foreign | Countries | Country ISO |
| Airframe MRO Name | varchar(255) | Name of the MRO provider | | | |
| Airframe MRO ch-a Code | varchar(5) | MRO provider ch-aviation code (2-5 characters) | Foreign | Entities | Entity ch-a Code |
| Airframe MRO Subsidiary Name | varchar(255) | Name of the MRO subsidiary (if applicable) | | | |
| Airframe MRO Subsidiary Code | varchar(5) | MRO subsidary ch-aviation code (if applicable) (2-5 characters) | Foreign | Entities | Entity ch-a Code |
| Operator In | varchar(255) | Operator name upon arrival at the MRO facility | | | |
| Operator In ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation) upon arrival at the MRO facility. Operator ch-aviation codes can be 2, 3, or 5 characters. | Foreign | Operators | Operator ch-a Code |
| Operator In IATA | varchar(2) | Operator IATA two-character code upon arrival at the MRO facility | | | |
| Operator In ICAO | varchar(3) | Operator ICAO three-character code upon arrival at the MRO facility | | | |
| Operator Out | varchar(255) | Operator name upon departure from the MRO facility | | | |
| Operator Out ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation) upon departure from the MRO facility. Operator ch-aviation codes can be 2, 3, or 5 characters | Foreign | Operators | Operator ch-a Code |
| Operator Out IATA | varchar(2) | Operator IATA two-character code upon departure from the MRO facility | | | |
| Operator Out ICAO | varchar(3) | Operator ICAO three-character code upon departure from the MRO facility | | | |
| Flight ID In | varchar(255) | Spire internal unique flight ID in ADS-B data for inbound flight to the MRO facility. Random UUIDv4 sequence | Foreign | Flights | flight_id |
| Flight ID Out | varchar(255) | Spire internal unique flight ID in ADS-B data for outbound flight from the MRO facility. Random UUIDv4 sequence | Foreign | Flights | flight_id |
| Date In | date | Date the aircraft arrived at the MRO facility | | | |
| Date Out | date | Date the aircraft departed from the MRO facility | | | |
| Days | int(11) | Total number of days the aircraft spent at the MRO facility (calculated as date_out - date_in) | | | |
| Airframe MRO Event Type | varchar(255) | Type of the MRO event (Base, Completion, Conversion, Delivery, Induction, Lease Return, Line + A, Modifications, Paint, Part-Out, Production, Repairs, Storage, Transition) | | | |
| Aircraft ID | int(11) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation) | Foreign | Aircraft | Aircraft ID |
| Aircraft Variant In | varchar(255) | Aircraft Variant designation (i.e. A321-200N) upon arrival at the MRO facility | | | |
| Aircraft Variant Out | varchar(255) | Aircraft Variant designation (i.e. A321-200N) upon departure from the MRO facility | | | |
| C/N | varchar(16) | Construction/Line Number | | | |
| MSN | varchar(16) | Manufacturer Serial Number | | | |
| Registration In | varchar(16) | Aircraft registration number upon arrival at the MRO facility | | | |
| Registration Out | varchar(16) | Aircraft registration number upon departure from the MRO facility | | | |
| Engine Manufacturer | varchar(255) | Engine manufacturer name | | | |
| Engine Manufacturer ch-a Code | varchar(4) | Engine manufacturer ch-aviation code (assigned by ch-aviation) | Foreign | Entities | Entity ch-a Code |
| Engine Family | varchar(16) | Engine family (i.e. JT9D) | | | |
| Engine Master Series | varchar(32) | Engine master series designation (i.e. JT9D-7R4) | | | |
| Engine Type | varchar(16) | Engine type designation (i.e. PW JT9D) | | | |
| Engine Subtype | varchar(32) | Engine subtype designation (i.e. PW JT9D-7R4H1) | | | |
