The MakeModel report needs to be extracted at regular intervals for Continuing Airworthiness. A copy of this report can be found at :
( https://tcmarin.atlassian.net/wiki/download/attachments/2338258951/MAKEMODEL.xlsx )
Note : the terms MAKE and MANUFACTURER are used interchangeably
Contents
TAB1 - The Mfg/model report - list of all mfg/models and their relationships throughout CAWIS
TAB2 - NAPATCDS - a list of all NAPA Type Certificate holders (V_CAW_TC_HOLDER_NAPA@NNPRODC.WORLD) and their relationship back to CAWIS
TAB3 - MFG - a list of all manufacturers used in CAWIS with counts indicating where they get used
TAB4 - GROUP - these codes tie together similar models, and are used in BII reports for trend monitoring
TAB1 - The Mfg/model report
COLUMN | DESCRIPTION |
PRODUCT | PRODUCT TYPE CODE (A,E,P,Q,F,S) |
ACTIVE | MODEL ACTIVE/INACTIVE (INACTIVE WILL NOT APPEAR ON AD WEB) |
COUNTRY | COUNTRY OF TYPE CERTIFICATE HOLDER / STATE OF DESIGN |
MANUFACTURER | MANUFACTURER NAME |
MODL | MODEL NAME |
GROUP_CODE | GROUP CODE (USED IN BII) |
CAWIS_TATC | TYPE APPROVAL / TYPE CERTIFICATE (TATC) ASSIGNED TO THIS MFG/MODEL (TC EXCEPTIONS - NOT, NOT CERTIFICATED, NOT IDENTIFIED, NO TATC ) |
FOREIGN_TATC | ANY POSSIBLE FOREIGN ASSIGNED TYPE CERTIFICATE FOUND IN NACIS |
MFG_ALIASES | MANUFACTURER ALIASES? DOES THIS MODEL/TATC COMBINATION EXIST UNDER ANOTHER MODEL ? |
MDKNT | MODEL COUNT - HOW MANY TIMES DOES THIS PRODUCT/MODEL OCCUR ON THE TABLE ? (NOTE: TATC HAS TO MATCH FOR IT TO BE CONSIDERED A MODEL ALIAS) |
REGD_ACRFT | HOW MANY CURRENTLY REGISTERED AIRCRAFT DOES THIS PRODUCT/MANUFACTURER/MODEL OCCUR ON ? |
REGD_COMMERCIAL_ACRFT | HOW MANY CURRENTLY COMMERCIALLY REGISTERED AIRCRAFT DOES THIS PRODUCT/MANUFACTURER/MODEL OCCUR ON ? |
REGD_PRIVATE_ACRFT | HOW MANY CURRENTLY PRIVATELY REGISTERED AIRCRAFT DOES THIS PRODUCT/MANUFACTURER/MODEL OCCUR ON ? |
AWDS | HOW MANY AIRWORTHINESS DIRECTIVES DOES THIS PRODUCT/MANUFACTURER/MODEL OCCUR ON ? |
PROJECTS | HOW MANY PROJECTS DOES THIS PRODUCT/MANUFACTURER/MODEL OCCUR ON ? |
CFSDR | DOES MFG/MODEL OCCUR ON A CANADIAN SDR ? |
FRGNSDR | DOES MFG/MODEL OCCUR ON A FOREIGN SDR ? |
CATGRY | CATEGORY OF AIRCRAFT OR ENGINE. DEFAULTS ASSIGNED FOR PROPELLER, FLOAT, SKI, EQUIPMENT - are - PROPELLER, FLOAT, SKI, EQUIPMENT |
AVG_WGT | AVERAGE MAX TAKEOFF WEIGHT POUNDS FOR THIS AIRCRAFT MANUFACTURER/MODEL |
PERS | CAW TC INSPECTOR RESPONSIBLE FOR THIS PRODUCT/MANUFACTURER/MODEL |
NACIS_TCHOLDER | TYPE CERTIFICATE HOLDER ORGANIZATION IN NACIS (TATC MATCH) |
SDR_TCH_ORG | NAME OF SDR TYPE CERTIFICATE HOLDER (TCH) ORGANIZATION (NOTE : IN SOME CASES THERE ARE MORE THAN 1 - DATA CLEANUP REQUIRED ) |
SIG_MFG | SIGS TCH ASSOCIATED TO THIS MFG/MODEL (NOTE : IN SOME CASES THERE ARE MORE THAN 1 ) |
ENGINES_OR_AIRFRAME | THE ENGINE MODEL TYPES FOUND ON THIS AIRFRAME - OR - THE AIRFRAMES THIS ENGINE APPEARS ON |
COMPVAL | COMPRESSED MODEL - USE THIS COLUMN TO SEARCH WHEN UNCERTAIN OF HOW A MODEL IS PUNCTUATED |
FAA SDR STANDARD | MAKE MODEL STANDARD FOR THIS MODEL ON THE FAA SDR WEBSITE |
NOTES | ANY NOTES FOUND ENTERED ON THAT MODEL |
MFGID | NUMERIC MANUFACTURER ID |
REGISTERED TAIL MARKS | OCCURRENCES OF THIS PRODUCT MAKE/MODEL ON CURRENTLY REGISTERED AIRCRAFT |
DE-REGISTERED TAIL MARKS | OCCURRENCES OF THIS PRODUCT MAKE/MODEL ON DE-REGISTERED AIRCRAFT |
PRD | PRODUCT TYPE CODE |
LASTMOD | DATE MODEL WAS LAST MODIFIED |
RUNDATE | DATE THIS REPORT WAS PRODUCED |
TAB2 - NAPATCDS
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 (side 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 |
TAB3 - CAWIS MANUFACTURERS
COLUMN | DESCRIPTION |
|---|---|
MFG_ID | Numeric Manufacturer_id on Y60_manufacturer |
COUNTRY_TCH | Type_certificate_holder and/or State_of_Design country code for this manufacturer |
MANUFACTURER | Manufacturer name |
AIRCRAFT | number of aircraft models associated with this manufacturer |
ENGINE | number of engine models associated with this manufacturer |
PROP | number of propeller models associated with this manufacturer |
SKI | number of ski models associated with this manufacturer |
FLOATS | number of float models associated with this manufacturer |
EQUIP | number of equipment models associated with this manufacturer |
AD | Is this manufacturer associated with any Airworthiness Directives ? |
COMPVAL | compressed Manufacturer - spaces and punctuation removed |
RUNDTE | date this report was produced |
TAB4 - GROUP CODES
COLUMN | DESCRIPTION |
|---|---|
GROUP_ID | GROUP CODES assigned to “similar” models by the CAW TI’s |
0 Comments