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 category for that location. These settings can be different per aircraft administration.
Report example:
You can download the aircraft registrations using the default ‘Aircraft Registrations' report.
Contents
Filters
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 |
---|---|---|---|
sortorder |
String |
BLANK |
Defines the sort order of the registration rows. If BLANK (not set), the output is sorted by ‘Registration code’. Possible options:
|
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. 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. 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. |
C525 |
Is active |
Indicates if the aircraft registration is marked as active. |
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 How to add a QR code to a report. Example shown:
|
|
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 |
Comments
0 comments
Please sign in to leave a comment.