...
EITHER DETERMINE THE MFG FROM THE FAA WEBSITE by tail mark/serial number lookup
OR –
BY LOOKING AT THE MODEL, then the CAWIS make model tables
...
' WHERE SDR_NUMBER_NUM = ''' || SDR_NUMBER_NUM || ''';' UPD1 , --- MFG CAN BE DETERMINED DETERMINED
' UPDATE M70_SDR_TRANSIT SET SDR_TEXT_TXT = SDR_TEXT_TXT || ( AC-MODEL: ''' ||
...
' WHERE SDR_NUMBER_NUM = ''' || SDR_NUMBER_NUM || ''';' UPD2 --- MFG CANNOT BE DETERMINED
FROM M70_SDR_TRANSIT
WHERE TRIM(AIRCRAFT_MANUFACTURER) IS NULL
...
' WHERE SDR_NUMBER_NUM = ''' || SDR_NUMBER_NUM || ''';' UPD1 , --- MFG CAN BE DETERMINED DETERMINED
' UPDATE M70_SDR_TRANSIT SET SDR_TEXT_TXT = SDR_TEXT_TXT || ( ENG-MODEL: ''' ||
...
' WHERE SDR_NUMBER_NUM = ''' || SDR_NUMBER_NUM || ''';' UPD2 --- MFG CANNOT BE DETERMINED DETERMINED
FROM M70_SDR_TRANSIT
WHERE TRIM(ENGINE_MANUFACTURER) IS NULL
...
' WHERE SDR_NUMBER_NUM = ''' || SDR_NUMBER_NUM || ''';' UPD1 , --- MFG CAN BE DETERMINED DETERMINED
' UPDATE M70_SDR_TRANSIT SET SDR_TEXT_TXT = SDR_TEXT_TXT || ( PROP-MODEL: ''' ||
...
' WHERE SDR_NUMBER_NUM = ''' || SDR_NUMBER_NUM || ''';' UPD2 --- MFG CANNOT BE DETERMINED DETERMINED
FROM M70_SDR_TRANSIT
WHERE TRIM(PROPELLER_MANUFACTURER) IS NULL
...
' WHERE SDR_NUMBER_NUM = ''' || SDR_NUMBER_NUM || ''';' UPD1 , --- MDL CAN BE DETERMINED DETERMINED
' UPDATE M70_SDR_TRANSIT SET SDR_TEXT = SDR_TEXT || '' ( AC-MFG: ' ||
...
' WHERE SDR_NUMBER_NUM = ''' || SDR_NUMBER_NUM || ''';' UPD2 --- MDL CANNOT BE DETERMINED
FROM M70_SDR_TRANSIT
WHERE TRIM(AIRCRAFT_MANUFACTURER) IS NOT NULL
...
' WHERE SDR_NUMBER_NUM = ''' || SDR_NUMBER_NUM || ''';' UPD1 , --- MDL CAN BE DETERMINED DETERMINED
' UPDATE M70_SDR_TRANSIT SET SDR_TEXT = SDR_TEXT || '' ( ENG-MFG: ' ||
...
' WHERE SDR_NUMBER_NUM = ''' || SDR_NUMBER_NUM || ''';' UPD2 --- MDL CANNOT BE DETERMINED
FROM M70_SDR_TRANSIT
WHERE TRIM(ENGINE_MANUFACTURER) IS NOT NULL
...