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 7 Next »

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

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 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

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

  1. Character replacements

AMPERSAND

& BECOMES PLUS SIGN +

QUOTE

' BECOMES BACKPICK (Accent Grave)

DOUBLE QUOTE

" BECOMES BACKPICK (Accent Grave)

SEMICOLON

; BECOMES COMMA

VERTICAL BAR

| BECOMES SPACE/BLANK

SQUARE BRACKET

[ BECOMES ROUND BRACKET (

SQUARE BRACKET

] BECOMES ROUND BRACKET )

DOUBLE SPACE

BECOMES SINGLE SPACE (this is just to reduce file size - do this 3-4 times)


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.

  • No labels