FOS Airport Update Instructions (3.12 and greater)

FOS Airport Update Instructions (3.12 and greater)

As of release 3.12.1, the FOS airport data source is changing from Universal to ARINCDirect. Below are the steps for the new airport update process. Step 1-2 only needs to be completed one-time, subsequent updates only require step 3. The airport update process now includes airports, DST, and APIS all in one.


Step 1: Running the 3.12.1 installer to create the new directory
  1. After running the 3.12.1 Installer, within the FOS executable directory a new folder called “ARP_SYNC” will be created. (Default Directory is C:\FOS) 
    1. Within the ARP_SYNC Folder will be two files listed below 
      1. ClearIncorrectICAOs.csv 
      2. UpdateToCorrectICAOs.csv 
  2. If both the new folder and 2 .CSV files are present proceed to the next step. 
  3. If the folder or files are not present reach out to FOS Tech Support 



Step 2: Running the convert (initial)
  1. Run the “Convert.exe” file found in the executable directory of FOS 
  2. On the 3.12 tab, run the 3.12.0.0 convert labeled “apinfo.btr” 
    1. Running this convert will prepare the airport database to be aligned with the new ARINCDirect data format 


  1. Once the convert is completed, the button will be grayed out and it will display the word “DONE” at the top of the window 
    1. Within the “ARP_SYNC” folder, an ARP_SYNC Convert log will be generated 


Step 3: Downloading the Airport File
  1. Connect to the Collins SFTP Site and retrieve the latest ARINCDirect Update 
    1. The File will be located within /FOS Customers/FOS Downloads/Airports/FOS Version 3.12 and Higher. (See Example Below) 
    2. Reach out to the FOS Team for the SFTP Login Information 


  1. Download the .SQLITE File and move it into the “ARP_SYNC” Folder 


  1. Run the “Convert.exe” file found in the executable directory of FOS. 
    1. On the Updates tab, select “Sync Airport/DST with ARINC” 
    2. When the update is complete, the word “DONE” will appear at the top of the window 

  1. Validating the airport update
    1. In the “ARP_SYNC” Folder 
      1. A sub folder called “ARP_SYNC_Archive_DB will be created, old SQLITE files will be moved here. 
    2. ARP_SYNC_Update.log file will be created 


    • Related Articles

    • Updating FOS

      Updating Flight Operations System (FOS) (Only for FOS systems that are under a current support contract) Before running the FOS Installer, you will need to uninstall the FOS Vendor Alliance Program on the server. If your company has FOS Mobile, the ...

    • Airport Tab

      The airport data in FOS is composed of information from a third party vendor. The information is updated on a quarterly basis. Fields in blue throughout the Airport Database note the fields that are imported from the third party database. If the ...

    • Airport Module Overview

      Accessing the Airports Module To access under the Aircraft Module select the Operations Tab and then the Airports button: The FOS Airport Database is a rather large database and is updated quarterly with data provided from a third-party. Updating the ...

    • Required Fields to add an Airport

      The required information to add an airport into FOS are: Name City State and Zip Country ICAO Prefix Airport ID ICAO IATA City Latitude Longitude Time zone

    • Airport Tab

      The “Airport” Tab contains options specific to using airports in the Operations module. Airport ID ID - This option will default airport identifiers to appear as the airport ID, specified in the airport record, on the schedule board. Airport ID field ...