Aircraft Registration query

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 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

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

Handling category

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

CAT02 | MTOW 3 - 6

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

Manufacturer

Aircraft type’s manufacturer for the registration. See Manufacturers (Administration).

Cessna

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)

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