Aircraft Registration query

The Aircraft Registration query is used to export the aircraft registration data, showing each registration per row. 

The FBO location is needed to display the default Operator, Debtor, Trip Support Provider and Handling Catergory for that location. These settings can be different per aircraft administration.

You can download the aircraft registrations using the default ‘Aircraft Registrations' report.

Contents

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

Fbo location

Filters on FBO location showing registrations available to the location. Single or multiple FBO locations can be selected.

If multiple FBO locations are selected, then all must use the same aircraft administration.

YES

Data provider settings

The following ‘Data provider settings’ can be set in Reports (Administration) for the query, if not specified the default applies. All settings must be separated by a semi-colon ';'.

Setting

Type

Default

Description

Setting

Type

Default

Description

sortorder

String

BLANK

Defines the sort order of the registration rows. If BLANK (not set), the output is sorted by ‘Registration code’. Possible options:

  • aircraftregistrationid - Sorts by ‘Aircraft registration Id’

Columns

Name

Description

Example

Aircraft registration Id

Aircraft registration’s unique ID in GUID format.

1997f0d2-9989-419d-aa78-28eb44e157f7

Aircraft administration

FBO location’s Aircraft administration for default contacts. See 'Aircraft administration' field in FBO Location (Fields)

FBO

Aircraft type

Aircraft registration’s aircraft type ‘Shortname’.

CJ525-1

Aircraft type Id

Aircraft registration’s type unique ID in GUID format.

7d32dec1-6bd3-4de3-aaac-c8eb2c617850

Aircraft type remarks

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

Park flat

Debtors

Default debtor contact for the registration.

Note: If multiple debtors are added, each will be separated by a semi-colon ;

AP Executive AMS

De-ice category

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

 

Disable payment cards on file

Indicates if payment cards on file can be stored against this registration. See 'Disable keeping payment cards on file' field in registration.

FALSE

Exclude from AOC

If the aircraft AOC should be excluded and tax charged for the registration. See GST / VAT Calculators

FALSE

Export values

The aircraft registration and aircraft type custom values combined. Each custom value is separated by a comma.

Noise cat AMS(EHAM): B, Noise cat AMS 2019(EHAM): S5, Noise factor (L)(JNED): 0.44

Export values from registration

Custom values applied to the aircraft registration only. Each custom value is separated by a comma.

Noise cat AMS(EHAM): B, Noise factor (L)(JNED): 0.44

Export values from type

Custom values applied to the aircraft type of the aircraft registration only. Each custom value is separated by a comma.

Noise cat AMS(EHAM): B, Noise cat AMS 2019(EHAM): S5, Noise factor (L)(JNED): 0.40

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 registration’s handling category. See Handling categories (Administration).

CAT02 | MTOW 3 - 6

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 for the registration. See List of aircraft type designators.

CJ1

ICAO code

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

C525

Is active

Indicates if the aircraft registration is marked as active. See How to make an aircraft registration inactive.

TRUE

Length 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 Manufacturers (Administration).

Cessna

Max fuel capacity in liter

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

568

Max fuel capacity in USG

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

150.05

Model name

Aircraft type’s ‘Model name’ for the registration.

CitationJet CJ1

MTOW in US Pounds

Aircraft registration’s maximum takeoff weight in US pounds.

10609

MTOW kg

Aircraft registration’s maximum takeoff weight in kilograms.

4812

MTOW kg (from registration)

Aircraft registration’s maximum takeoff weight in kilograms if specified in the ‘Specific MTOW’ field of the registration.

4800

MTOW kg (from type)

Aircraft type’s maximum takeoff weight in kilograms specified in the ‘Default MTOW’ field of the aircraft type.

4812

MTOW taken from type

Indicates if the maximum take off weight for the registration is taken from the aircraft type's ‘Default MTOW’ (TRUE) or the registration’s ‘Specific MTOW’ (FALSE).

FALSE

MTOW ton

Aircraft registration’s maximum takeoff weight in ton (rounded up).

5

Noise chapter

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

 

Number of engines

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

2

Number of seats

The seat count for the registration.

7

Number of seats (from registration)

Aircraft registration’s seat count if specified in the ‘Specific Seats’ field of the registration.

7

Number of seats (from type)

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

6

Number of seats taken from type

Indicates if the seat count for the registration is taken from the aircraft type's ‘Default Seats’ (TRUE) or the registration’s ‘Specific Seats’ (FALSE).

FALSE

Operators

Default operator contact for the registration.

Note: If multiple operators are added, each will be separated by a semi-colon ;

AP Executive AMS

QRCode

Allows generating a QR code using data from other columns, see https://amsterdam.jira.com/wiki/spaces/MAN/pages/2445049868.

Example shown:

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

  • Columns: Registration code, ICAO code, Model name, MTOW kg (column format: # kg), Number of seats (column format # seats)

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

Registration code

Registration code for the aircraft.

FHRSC

Registration code with dash

Registration code for the aircraft with country specific dash. See ‘Registration prefix’ field in Countries (Administration).

F-HRSC

Remarks

Free-text remarks added against the registration.

former D-IWBL

Serial number

Registration’s specified ‘Serial number’.

525A0355

Trip support providers

Default trip support provider contact for the registration.

Note: If multiple trip support providers are added, each will be separated by a semi-colon ;

Sprouts GMBH

Wing area in m2

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

122.6

Wing area in square feet

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

1319.66

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.

50.82

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.

15.49