Sept 2021 : NOTE - all required code for this process is found at :
simply copy and place into your preferred SQL tool
...
Non mandatory - the Carrier code is the Owner/Operator of the aircraft listed in the SDR at that point in time. We check for integrity and possibly Add new CARRIER codes to TR91, if necessary.
...
Though the FAA does not always keep this list up to date (ie: you’ll find carrier codes in the data that are not on this list – FAA SDR management is aware of the issue)
Sample (columns 1-4 = CARRIER_CD, columns 5-55 = OWNER/OPERATOR/CARRIER NAME
...
If we encounter a CARRIER code we dont have, we can possibly grab it from this list, and add it into CAWIS - manually updating the CARRIER code table
...