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
STEP 16 AIRCRAFT MANUFACTURER AND MODEL CONVERSION
STEP 17 ENGINE MANUFACTURER AND MODEL CONVERSION
STEP 18 PROPELLER MANUFACTURER AND MODEL CONVERSION
STEP 19 UPDATE MANUFACTURER TEXT
STEP 20 EQUIPMENT/COMPONENT DATA CONVERSION
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2182938753
STEP 22 REGION CODE
STEP 23 ATA/JASC CODES
STEP 24 NATURE CODES
STEP 25 ACTION TAKEN CODES
https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2186477583
STEP 27 CARRIER CODES
STEP 28 AIRCRAFT-ID
STEP 29 REVIEW ALL MODELS
STEP 30 SDR TEXT
STEP 31 SDR INSERT ROUTINES
STEP 32 DATA VERIFICATION
STEP 33 BACKOUT ?