STEP 19 UPDATE MANUFACTURER TEXT

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

simply copy and place into your preferred SQL tool

/*

Here we update the Text manufacturer to match any changes made by the assignment of manufacturer_id's in the previous 3 steps. This would have been caused by manufacturer-aliasing, where we managed to identify a model, but under a different one than shown in the FAA data.

We don’t need the text-manufacturers in CAWIS, but it makes debugging much easier, if necessary later on.

We're also clearing out serial numbers on any Amateur built aircraft reports so that they do not get assigned Aircraft_id's from Y04, later in this procedure

*/

UPDATE M70_SDR_TRANSIT SET AIRCRAFT_SERIAL_NUMBER = NULL WHERE AIRCRAFT_MODEL = 'AMTR';

UPDATE M70_SDR_TRANSIT SET AIRCRAFT_SERIAL_NUMBER = NULL WHERE AIRCRAFT_MANUFACTURER_ID = 146;

UPDATE M70_SDR_TRANSIT SET AIRCRAFT_MANUFACTURER = GET_MANUFACTURER_NAME(AIRCRAFT_MANUFACTURER_ID);

UPDATE M70_SDR_TRANSIT SET ENGINE_MANUFACTURER = GET_MANUFACTURER_NAME(ENGINE_MANUFACTURER_ID);

UPDATE M70_SDR_TRANSIT SET PROPELLER_MANUFACTURER = GET_MANUFACTURER_NAME(PROPELLER_MANUFACTURER_ID);

COMMIT;

/*