vAMSYS Logo

Data

Exporters

WherePermission
Orwell -> Data -> ExportersCan See Export

vAMSYS provides several exporters to help you manage and analyze your Virtual Airline data. For a general overview of using exporters, please refer to the Introduction.

Aircraft Exporter

ColumnDescriptionExample
IDUnique identifier123456
NameAircraft nameFlight of Fancy
RegistrationAircraft registration numberG-LUJA
SelcalSELCAL codeAC- BD
Fin NumberAircraft fin numberG-LUJA
HexcodeHexadecimal codeAE586C
Fleet TypeAssociated fleet type ID6
PAXPassenger capacity180
FreightFreight capacity0
Container UnitsNumber of container units0
SimBrief Airframe IDSimBrief airframe ID349674_1719351837546
SB OFP FormatSimBrief OFP formatlido
CatAircraft categoryM
EquipmentEquipment codesSDFGHIJ1RWY
TransponderTransponder codeLB1V1
PBNPerformance-based navigation codesA1B1C1D1L1O1S2T1
RemarksAdditional remarksCOM/CPDLC DAT/VM RVR/075 OPR/LULU PER/C RMK/ACASII EQUIPPED CALLSIGN LULU TCAS
OEWOperating empty weight93.500
MZFWMaximum zero fuel weight134.482
MTOWMaximum takeoff weight162.040
MLWMaximum landing weight142.198
Max FuelMaximum fuel capacity41.897
PerformancePerformance categoryC
PaxwgtAverage passenger weight163
BagwgtAverage baggage weight33
Climb ProfileClimb speed profile250/300/84
Cruise ProfileCruise speed profile78/250/250
Descent ProfileDescent speed profile84/290/250
ETOPSExtended-range twin-engine operational performance standards120
Fuel FactorFuel factor for adjustmentsP02
ContpctContingency fuel percentage5
ResvruleReserve fuel rule30
MinfobMinimum block fuel0
Minfob UnitsUnits for minimum block fuelmin
MinfodMinimum arrival fuel1500
Minfod UnitsUnits for minimum arrival fuelwgt
MelfuelMEL fuel amount0
Melfuel UnitsUnits for MEL fuelmin
DeletePlaceholder for delete action

Airport Exporter

ColumnDescriptionExample
IDUnique identifier123456
NameAirport nameLondon Stansted
World Airport IDWorld airport ID5678
ICAOICAO codeEGSS
IATAIATA codeSTN
BaseIndicates if the airport is a base1
CategoryAirport categoryCat A
PAX LFPassenger load factor ID15
Luggage LFLuggage load factor ID16
Cargo (Weight) LFCargo weight load factor ID17
Cargo (Volume) LFCargo volume load factor ID20
ContainerssAssociated container IDs8, 16, 3, 18, 35, 658, 78, 35168
Taxi In MinutesAverage taxi-in time in minutes5
Taxi Out MinutesAverage taxi-out time in minutes7
DeletePlaceholder for delete action

Container Exporter

ColumnDescriptionExample
IDUnique identifier658
NameContainer nameMail
TypeContainer typeULD-40
SizeContainer size1
WeightContainer weight200
NotesAdditional notesRoyal Mail
Incompatible ContainersIDs of incompatible containers6558, 6559
DeletePlaceholder for delete action

Fleet Exporter

ColumnDescriptionExample
IDUnique identifier55
Fleet NameName of the fleetMy Fleet
Fleet CodeCode for the fleetB737
Fleet TypeType of fleetpax-cargo
Callsign ParametersAssociated callsign parameter IDs15, 23, 86
Scoring GroupScoring group ID15
Max PaxMaximum passenger capacity183
Max FreightMaximum freight capacity0
Container UnitsNumber of container units0
SimBrief Airframe IDSimBrief airframe ID349674_1719351837546
SB OFP FormatSimBrief OFP formatlido
CatAircraft categoryM
EquipmentEquipment codesSDFGHIJ1RWY
TransponderTransponder codeLB1V1
PBNPerformance-based navigation codesA1B1C1D1L1O1S2T1
RemarksAdditional remarksCOM/CPDLC DAT/VM RVR/075 OPR/LULU PER/C RMK/ACASII EQUIPPED CALLSIGN LULU TCAS
OEWOperating empty weight93.500
MZFWMaximum zero fuel weight134.482
MTOWMaximum takeoff weight162.040
MLWMaximum landing weight142.198
Max FuelMaximum fuel capacity41.897
PerformancePerformance categoryC
PaxwgtAverage passenger weight163
BagwgtAverage baggage weight33
Climb ProfileClimb speed profile250/300/84
Cruise ProfileCruise speed profile78/250/250
Descent ProfileDescent speed profile84/290/250
ETOPSExtended-range twin-engine operational performance standards120
Fuel FactorFuel factor for adjustmentsP02
ContpctContingency fuel percentage5
ResvruleReserve fuel rule30
MinfobMinimum block fuel0
Minfob UnitsUnits for minimum block fuelmin
MinfodMinimum arrival fuel1500
Minfod UnitsUnits for minimum arrival fuelwgt
MelfuelMEL fuel amount0
Melfuel UnitsUnits for MEL fuelmin
DeletePlaceholder for delete action

Hub Exporter

ColumnDescription
IDUnique identifier12345
NameHub nameLondon
DefaultIndicates if the hub is the default1
AirportsAssociated airport IDs123456
DeletePlaceholder for delete action

Load Factor Exporter

ColumnDescription
IDUnique identifier123456
NameLoad factor namePassenger - Summer
TypeLoad factor typepax
DefaultIndicates if it is the default load factor0
MinMinimum load factor percentage80
MaxMaximum load factor percentage100
BiasLoad factor bias0.8
DeviationStandard deviation of the load factor0.1
DeletePlaceholder for delete action

Route Exporter

ColumnDescriptionExample
IDUnique identifier988
Departure IDDeparture airport ID182803
Departure CodeDeparture airport codeEGSS
Arrival IDArrival airport ID183136
Arrival CodeArrival airport codeEHAM
CallsignRoute callsignHTA16H
Flight NumberRoute flight numberHT1141
FleetsAssociated fleet IDs88,322,6
AltitudeCruising altitude
CICost indexAUTO
RouteRoute details
Departure TimeScheduled departure time
Arrival TimeScheduled arrival time
Flight LengthEstimated flight time01:15
Flight DistanceFlight distance (nm)256
Start DateRoute start date2024-07-18 14:50
End DateRoute end date
RemarksAdditional remarks
TypeRoute typescheduled
TagRoute tagsSummer 2024, Winter 2024
Departure Stand GroupAssociated departure stand group
Arrival Stand GroupAssociated arrival stand group
PAX LFPassenger load factor ID15
Luggage LFLuggage load factor ID16
Cargo (Weight) LFCargo weight load factor ID17
Cargo (Volume) LFCargo volume load factor ID18
ContainersAssociated container IDs
FlightrulesFlight rulesi
FlighttypeFlight types
ContpctContingency fuel percentage
ResvruleReserve fuel rule
TaxifuelTaxi fuel amount
MinfobMinimum block fuel
MinfodMinimum arrival fuel
MelfuelMEL fuel amount
AtcfuelATC fuel amount
WxxfuelWeather fuel amount
AddedfuelAdditional fuel amount
TankeringTankering fuel amount
Minfob UnitsUnits for minimum block fuelmin
Minfod UnitsUnits for minimum arrival fuelmin
Melfuel UnitsUnits for MEL fuelmin
Atcfuel UnitsUnits for ATC fuelmin
Wxxfuel UnitsUnits for weather fuelmin
Addedfuel UnitsUnits for additional fuelmin
Tankering UnitsUnits for tankering fuelmin
Addedfuel LabelLabel for additional fuelhold
DeletePlaceholder for delete action

Scenery Exporter

ColumnDescriptionExample
IDUnique identifier123456
AirportAssociated airport ID56
TypeType of sceneryPayware
SimulatorSimulator compatibilityMSFS2024
DeveloperScenery developer nameIn-House
URLDownload link for the sceneryhangar.to
DeletePlaceholder for delete action

Stand Exporter

The Stands exporter includes an option to 'Exclude Global Stands provided by vAMSYS,' enabled by default. This exports only VA Custom Stands. Disabling it will include the full vAMSYS Stand database, resulting in over 63,000 rows.

ColumnDescriptionExample
IDUnique identifier123456
World Airport IDWorld airport ID123456
NameStand nameA1
LatitudeLatitude of the stand120.000000
LongitudeLongitude of the stand80.0000000
CustomIndicates if the stand is custom (Yes/No)Yes
DeletePlaceholder for delete action

Stand Group Exporter

ColumnDescriptionExample
IDUnique identifier123
Airport IDAssociated airport ID123456
NameStand group nameWidebody
DefaultIndicates if it is the default stand group0
StandsAssociated stand IDs18, 23, 58, 88, 65, 125, 135, 156
DeletePlaceholder for delete action

Changelog

DateNotes

2024-07-18

Initial Release

Previous
Introduction