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 )
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 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 |
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 |
Add Comment