Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Sept 2021 : NOTE - all required code for this process is found at :

FAA DATA IMPORT PROCEDURE.TXT

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 :

...

Unfortunately, the FAA frequently sends us posts incomplete configuration data.

...

  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  

...