Aircraft Types query

You can download the aircraft types using the default ‘Aircraft Types’ report.

Contents

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

Fbo location

Filters on FBO location showing types available to the location.

A single FBO location can be chosen only.

The FBO location is used to display the correct Handling Category for that specific location.

YES

Data provider settings

There are no data provider settings for this query.

Columns

Name

Description

Example

Aircraft type Id

Aircraft type’s unique ID in GUID format.

c8677661-b320-41b7-afcd-d7e909837031

De-ice category

This column is no longer used. See De-ice categories (Administration).

 

Export values

The aircraft type’s custom values combined. Each custom value is separated by a comma.

Park Flat: Yes

Footprint in m2

The aircraft type’s footprint area in meters squared. See How to setup a unit price based on a formula to use footprint for unit price calculation for parking.

Footprint value is generated from multiplying Wing span by Length.

374.42

Footprint in square feet

The aircraft type’s footprint area in feet squared. See How to setup a unit price based on a formula to use footprint for unit price calculation for parking.

Footprint value is generated from multiplying Wing span by Length.

4030.23

Fuel process

The fuel process type assigned to the aircraft type. See ‘Fuel process type’ field in type. See Fuel process types (Administration).

Pressure

Fuel type

The fuel type assigned to the aircraft type. See ‘Fuel type’ field in type. See Fuel types (Administration).

If using the fuel module, incorrect fuel warnings will show for the type if fuel services of other fuel types are added to an order.

Jet Fuel

Ground power type

The ground power type assigned to the aircraft type. See ‘Ground power’ field in type. See Ground power types (Administration).

115V/AC - 220V/DC

Handling category

Aircraft type’s handling category. See Handling categories (Administration).

Band I

Hanger category

This column is no longer used. See Hangar categories (Administration).

 

Height in feet

Aircraft type’s height in feet. See ‘Height’ field in type.

19.19

Height in meter

Aircraft type’s height in meters. See ‘Height’ field in type.

5.85

IATA code

Aircraft type's IATA code. See ‘IATA code’ in type. See List of aircraft type designators.

CNJ

ICAO code

Aircraft type's ICAO code for the registration. See ‘ICAO code’ in type. See List of aircraft type designators.

C680

Lenght in feet

Aircraft type in feet. See ‘Length’ field in type.

Length is used to calculate the aircraft footprint.

63.48

Length in meter

Aircraft type in meter. See ‘Length’ field in type.

Length is used to calculate the aircraft footprint.

19.35

Manufacturer

Aircraft type’s manufacturer for the registration. See ‘Manufacturer’ field in type. See Manufacturers (Administration).

Cessna

Max fuel capacity in liter

The maximum fuel amount in liters for the type. See ‘Max fuel capacity’ field in type.

6435

Model name

The official aircraft type’s ‘Model name’. See ‘Model name’ field in type.

Citation Sovereign - C680

MTOW in US Pounds

Aircraft registration’s maximum takeoff weight in US pounds. See ‘Default MTOW’ field in type.

30300

MTOW kg

Aircraft type’s maximum takeoff weight in kilograms. See ‘Default MTOW’ field in type.

13744

MTOW ton

Aircraft type’s maximum takeoff weight in ton (rounded up). See ‘Default MTOW’ field in type.

14

Noise category

This column is no longer used. See Noise categories (Administration).

 

Noise chapter

This column is no longer used. See Noise chapters (Administration).

 

Number of engines

The engine count for the aircraft type. See ‘Number of engines’ field in type.

2

Number of seats

The seat count for the aircraft type. See ‘Default Seats’ field in type.

8

QRCode

Allows generating a QR code using data from other columns, see How to add a QR code to a report.

Example shown:

  • Settings: ShowBarCodeOnEveryRow=true; MultipleValuesSeparator=" | "

  • Columns: Model name, ICAO code, Manufacturer, Fuel type, MTOW kg (column format: # kg)

Range in km

Aircraft type’s range in kilometers. See ‘Range’ field in type.

5222

Range in miles

Aircraft type’s range in miles. See ‘Range’ field in type.

3244.81

Remarks

Free-text remarks added against the type. See ‘Remarks’ field in type.

Parked flat for fuel

Short name

Aircraft type’s operational short name. See ‘Shortname’ field in type.

C680

Wing area in m2

The aircraft type’s wing area in meters squared. See ‘Wing area’ field in type.

47.4

Wing area in square feet

The aircraft type’s wing area in feet squared. See ‘Wing area’ field in type.

510.21

Wing span in feet

The aircraft type’s wing span in feet. See ‘Wing span’ field in type.

Wingspan is used to calculate the aircraft footprint.

63.48

Wing span in meter

The aircraft type’s wing span in meter. See ‘Wing span’ field in type.

Wingspan is used to calculate the aircraft footprint.

19.35