Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

 NoteNote: 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.

We use the Tab-Delimited Zipped Data files from the lower part the page.

Download the Tab Delimited Data sdr zip files (lower list of files on the screen) from 2015 to 2030, from for the last 5 years 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

...