Manual preparation of WSDRS-FAA data

Manual tasks to perform if the batch file does not work for you or anybody on the team:

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

 Note: Never download from the FIXED WIDTH section of the page, the FAA code introduced an error causing corruption on these files, sometime in 2017. FAA SDR management is aware of the issue.

Download the Tab Delimited Data sdr zip files (lower list of files on the screen)from 2015 to 2030, from https://av-info.faa.gov/dd_sublevel.asp?Folder=%5cSDRS

unzip the zip files:

unzip sdr2018a.zip sdr2018a.txt
unzip sdr2018g.zip sdr2018g.txt
unzip sdr2019a.zip sdr2019a.txt
unzip sdr2019g.zip sdr2019g.txt
unzip sdr2020a.zip sdr2020a.txt
unzip sdr2020g.zip sdr2020g.txt
unzip sdr2021a.zip sdr2021a.txt
unzip sdr2021g.zip sdr2021g.txt
unzip sdr2022a.zip sdr2022a.txt
unzip sdr2022g.zip sdr2022g.txt
unzip sdr2023a.zip sdr2023a.txt
unzip sdr2023g.zip sdr2023g.txt
unzip sdr2024a.zip sdr2024a.txt
unzip sdr2024g.zip sdr2024g.txt
unzip sdr2025a.zip sdr2025a.txt
unzip sdr2025g.zip sdr2025g.txt
unzip sdr2026a.zip sdr2026a.txt
unzip sdr2026g.zip sdr2026g.txt
unzip sdr2027a.zip sdr2027a.txt
unzip sdr2027g.zip sdr2027g.txt
unzip sdr2028a.zip sdr2028a.txt
unzip sdr2028g.zip sdr2028g.txt
unzip sdr2029a.zip sdr2029a.txt
unzip sdr2029g.zip sdr2029g.txt
unzip sdr2030a.zip sdr2030a.txt
unzip sdr2030g.zip sdr2030g.txt

concatenate the zip files to create DATA.TXT

type sd*.txt > DATA.TXT

Delete the unneeded zip and txt files.

DEL SD*.TXT
DEL SD*.ZIP

Manual tasks to perform if the batch file does not work:

1. Download and unzip the zip files:

   unzip sdr2015a.zip sdr2015a.txt
   unzip sdr2015g.zip sdr2015g.txt
   unzip sdr2016a.zip sdr2016a.txt
   unzip sdr2016g.zip sdr2016g.txt
   unzip sdr2017a.zip sdr2017a.txt
   unzip sdr2017g.zip sdr2017g.txt
   unzip sdr2018a.zip sdr2018a.txt
   unzip sdr2018g.zip sdr2018g.txt
   unzip sdr2019a.zip sdr2019a.txt
   unzip sdr2019g.zip sdr2019g.txt
   unzip sdr2020a.zip sdr2020a.txt
   unzip sdr2020g.zip sdr2020g.txt
   unzip sdr2021a.zip sdr2021a.txt
   unzip sdr2021g.zip sdr2021g.txt
   unzip sdr2022a.zip sdr2022a.txt
   unzip sdr2022g.zip sdr2022g.txt
   unzip sdr2023a.zip sdr2023a.txt
   unzip sdr2023g.zip sdr2023g.txt
   unzip sdr2024a.zip sdr2024a.txt
   unzip sdr2024g.zip sdr2024g.txt
   unzip sdr2025a.zip sdr2025a.txt
   unzip sdr2025g.zip sdr2025g.txt
   unzip sdr2026a.zip sdr2026a.txt
   unzip sdr2026g.zip sdr2026g.txt
   unzip sdr2027a.zip sdr2027a.txt
   unzip sdr2027g.zip sdr2027g.txt
   unzip sdr2028a.zip sdr2028a.txt
   unzip sdr2028g.zip sdr2028g.txt
   unzip sdr2029a.zip sdr2029a.txt
   unzip sdr2029g.zip sdr2029g.txt
   unzip sdr2030a.zip sdr2030a.txt
   unzip sdr2030g.zip sdr2030g.txt

2. concatenate the zip files to create DATA.TXT

   type sd*.txt > DATA.TXT

3. Delete the unneeded zip and txt files.

   DEL SD*.TXT
   DEL SD*.ZIP

4. Character replacements
   

Save the DATA.TXT file to c:\DATA\FAA

Open the DATA.TXT file in excel

These three steps are the quickest way to open the DATA.TXT the same way the batch file does:

• Go to a command prompt (does not have to be as an admin).

• cd \Program Files (x86)\Microsoft Office\root\Office16

• run the command: excel C:\DATA\FAA\DATA.TXT

The data in DATA.txt will now look similar to this. Notice the ENTRY_DATE is our leftmost value.