Sept 2021 : NOTE - all required code for this process is found at :
simply copy and place into your preferred SQL tool
...
In order to later insert records into the M73_SDR_PRODUCT_MAKE_MODEL table, the minimum requirement is :
...
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
...
AIRCRAFT_MODEL, AIRCRAFT_SERIAL_NUMBER,
‘UPDATE 'UPDATE M70_SDR_TRANSIT SET AIRCRAFT_MODEL = ''XXX''' ||
' 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 || ''';' ||
‘UPDATE 'UPDATE M70_SDR_TRANSIT SET AIRCRAFT_MANUFACTURER = NULL' ||
' 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
...