Original WSDRS FAA Data Import Instructions

Instructions

STEP 1 Empty the temp data table M70
STEP 2 Download the FAA data files
STEP 3 Extract the text files
STEP 4 Concatenate the Text files into a single file
STEP 5 Character replacement
STEP 6 EXCEL Processing
STEP 7 Make INSERT statements
STEP 8 Perform the Inserts
STEP 9 Parsing the Data
STEP 10 Allocating Standard CAWIS format SDR numbers
STEP 11 Text field Cleanups
STEP 12 Check for NON-American tail marks
STEP 13 INCOMPLETE MANUFACTURER/MODEL DATA
STEP 14 AIRCRAFT MANUFACTURER/MODEL
STEP 15 AIRCRAFT SERIAL NUMBER
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2183266327
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2183036974
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2183266347
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2182873177
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2183168093
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2182938753
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2186215431
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2186346516
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2186280971
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2185822249
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2186477583
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2182774967
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2186543150
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2182938828
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2186281020
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2186215557
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2186477622
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2185822307