Master data: Equipment record layout & descriptions

Refer to the below for a list of field names and its corresponding description in the Master data: Equipment table.

Field Name

Name in Database

Type

Description

Aircraft key

AIRCRAFT_KEY

VARCHAR (16777216)

Unique combination of the IATA, ICAO AND FAA aircraft types

IATA Aircraft Type

IATA_AIRCRAFT_TYPE

VARCHAR (16777216)

IATA 3-character designator for the aircraft/equipment type code. E.g. CR1

ICAO Aircraft Type

ICAO_AIRCRAFT_TYPE

VARCHAR (16777216)

ICAO 4-charater designator for the aircraft/equipment type code. E.g. CRJ1. There are some exceptions where the code is three characters.

denotes surface equipment for which ICAO will not assign codes

*denotes multiple ICAO equipment types relating to one IATA code

blank ICAO not yet assigned a code or it is a surface type for which ICAO doesn't assign codes.

FAA Aircraft Type

FAA_AIRCRAFT_TYPE

VARCHAR (16777216)

FAA 4-charater designator for the aircraft/equipment type code. E.g. CRJ1

OAG Aircraft Type

OAG_AIRCRAFT_TYPE

VARCHAR (16777216)

OAG recommendation for the aircraft/equipment type code

IATA Manufacturer Name

IATA_MANUFACTURE_NAME

VARCHAR (16777216)

IATA name for the aircraft manufacturer e.g. Canadair (Bombardier)

IATA Model Name

IATA_MODEL_NAME

VARCHAR (16777216)

IATA name for the aircraft model. E.g Regional Jet 100

IATA Aircraft Group

IATA_AIRCRAFT_GROUP

VARCHAR (16777216)

IATA 3-character designator code for the aircraft/equipment group

IATA Aircraft Category Code

IATA_AIRCRAFT_CATEGORY_CODE

VARCHAR (16777216)

IATA designator code that denotes the Aircraft Category

IATA Aircraft Category Description

IATIA_AIRCRAFT_CATEGORY_DESCRIPTION

VARCHAR (16777216)

Description of the aircraft/equipment category. E.g Turboprop-engined aircraft

ICAO Aircraft Category Code

ICAO_AIRCRAFT_CATEGORY_CODE

VARCHAR (16777216)

ICAO designator code that denotes the Aircraft Category

ICAO Engine Count

ICAO_ENGINE_COUNT

VARCHAR (16777216)

The number of engines of the aircraft

ICAO Engine Type

ICAO_ENGINE_TYPE

VARCHAR (16777216)

The type of engine. E.g. Piston

ICAO Aircraft Description

ICAO_AIRCRAFT_DESCRIPTION

VARCHAR (16777216)

A description of the aircraft/equipment. E.g. Landplane

IATA Aircraft Body Code

IATA_AIRCRAFT_BODY_CODE

VARCHAR (16777216)

Denote the aircraft/equipment body type. E.g. N = Narrow-body and W = wide-body

IATA Aircraft Body Description

IATA_AIRCRAFT_BODY_DESCRIPTION

VARCHAR (16777216)

Description for the aircraft/equipment body type. Narrow-body

FAA Aircraft Category Class

FAA_AIRCRAFT_CATEGORY_CLASS

VARCHAR (16777216)

Denotes the aircraft/equipment category class e.g. Amphibian, fixed-wing,

ICAO Aircraft Specification

ICAO_AIRCRAFT_SPECIFICATION

VARIANT

ICAO aircraft/equipment spec. Multiple values exist for this field. E.g.

[

{

   "ICAO_MANUFACTURER": "AERO (2)",

   "ICAO_MODEL_NAME": "DELFIN",

   "ICAO_MODEL_NUMBER": "L-29",

   "ICAO_WTC": "L",

   "ICAO_WTG": "G"

},

{

   "ICAO_MANUFACTURER": "AERO (2)",

   "ICAO_MODEL_NAME": "DELFIN",

   "ICAO_WTC": "L",

   "ICAO_WTG": "G"

}

]

FAA Aircraft Specification

FAA_AIRCRAFT_SPECIFICATION

VARIANT

FAA aircraft/equipment spec. Multiple values exist for this field. E.g

[

{

   "FAA_AIRCRAFT_CATEGORY": "2P/S+",

   "FAA_MANUFACTURER": "GRUMMAN",

   "FAA_MANUFACTURER_NAME": [

     {

       "VALUE": "GRUMMAN AIRCRAFT ENGINEERING CORPORATION (UNITED STATES)"

     },

     {

       "VALUE": "GRUMMAN CORPORATION (UNITED STATES)"

     }

   ],

   "FAA_MODEL": "G-73 MALLARD",

   "FAA_WTC": "LIGHT",

   "FAA_WTG": "F"

},

{

   "FAA_AIRCRAFT_CATEGORY": "2P/S+",

   "FAA_MANUFACTURER": "GRUMMAN",

   "FAA_MANUFACTURER_NAME": [

     {

       "VALUE": "GRUMMAN AIRCRAFT ENGINEERING CORPORATION (UNITED STATES)"

     },

     {

       "VALUE": "GRUMMAN CORPORATION (UNITED STATES)"

     }

   ],

   "FAA_MODEL": "MALLARD",

   "FAA_WTC": "LIGHT",

   "FAA_WTG": "F"

}