The MakeModel report needs to be extracted at regular intervals for Continuing Airworthiness. A copy of this report can be found as an attachment on the main page of this article ( CAWIS MANUFACTURER/MODEL TABLE STANDARDS at :
( https://tcmarin.atlassian.net/wiki/download/attachments/2338258951/MAKEMODEL.xlsx )
Note : the terms MAKE and MANUFACTURER are used interchangeably
...
COLUMN | DESCRIPTION |
CW_CN | Type-Certificate Holder and/or State of Design Country Code mapped to this CAWIS Manufacturer |
CAWISMFG | CAWIS manufacturer mapped to TC Holder by CAWIS-TATC = NAPA_TC_CODE or CAWIS-TATC = FOREIGN_NUM or CAWIS-MFG = NAPA_FROM_TXT (on Z980_TERM_CONVERSION) |
TCHOLDER | From NAPA (uppercased and special characters removed) |
NAPA_CN | Type-Certificate Holder and/or State of Design Country as shown in NAPA |
DESIGN_RESP | Civil Aviation Authority from NAPA (sidenoteside note: there are many discrepancies here) |
TC_CODE | Canadian Type approval number for this TC Holder from NAPA |
FOREIGN_NUM | Foreign Type Approval number for this TC Holder from NAPA |
TC_CODE_MFGS | Any Alternate CAWIS Manufacturers associated to the TC Holder by way of aliased models. An aliased model is any model occurring under more than 1 manufacturer, having the same Napa TATC code (no TC exception codes) |
RUNDTE | Date this report was produced |
TCHOLDER | TC holder in its original format, lowercased etc |
...