Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

The FAA Aircraft registry website is at :

  1. http://registry.faa.gov/aircraftinquiry

and the FAA SDR database query site is here

  1. http://av-info.faa.gov/sdrx/Query.aspx

and the public FAA SDR data download site at :

  1. https://av-info.faa.gov/dd_sublevel.asp?Folder=%5CSDRS

 

So we begin by going to the FAA SDR download site. This website is auto-updated by the FAA every Sunday. All record layouts are identical going back to around 2010 - not a problem, we already have the data going back to about 1974.

Each FAA datafile is suffixed with either
'a' - Commercial Aviation - or -
'g' - General Aviation.

However, this distinction has no relevance to the upload procedure. We consolidate all the data and process it as one batch.

The FAA accepts SDR reports in a "Preliminary" format. This means it can often take months/years for a given report to finally appear on the FAA ftp website, until such time as the report has been marked "reviewed" by a Technical inspector. ( They frequently contact the submitter with supplemental questions, and that exchange can take an extended period )

The FAA data files themselves are compiled by Date_of_Occurence_Year, but the entry date of any given record can be current year.

Note: In January of any given year, it may take a few weeks for "current year" data to appear on the website. Contact FAA SDR management if the issue persists into February.


So to ensure we’re not skipping recently reveiwed reports, we always download the most recent 5 years of data from the FAA site.
Notes:

The FAA does not process any incident older than 5 years back, but there can by "newly posted" data anywhere within that 5 years.

We only upload new data into WSDRS, we do not update previously imported data

We use the Tab-Delimited Zipped Data files from the lower left-hand corner of the download page.

Note: Never download from the FIXED WIDTH section of the page, the FAA code introduced an error causing spacing corruption on these files, sometime in 2017

So in this example, we would download 10 Tab-Delimited Zip files
sdr2017a.zip sdr2017g.zip
sdr2018a.zip sdr2018g.zip
sdr2019a.zip sdr2019g.zip
sdr2020a.zip sdr2020g.zip
sdr2021a.zip sdr2021g.zip

And save them to C:\data\FAA

  • No labels