From the CAWIS main menu, go to
main menu → Code table Admin → Make-Model
Available functions :
search (model or model substring)
Advanced Search
New model
Basic Search Example :
Note : this function should be made to search Data_compression(input_value) like %Data_compression(model_id)% when returning results
Advanced Search
Note : the default radio button should be set to ALL in both sections
From this page, the user can search by Product_type & Manufacturer (+ optional Model Substring)
The Type-Certificate section of the page shows the NAPA / NICO a type approval code list in the dropdown. Selecting one or more codes, maps those Type-approval codes back to all the MFG/models in CAWIS holding those codes.
Search Results page
column | description |
|---|---|
ACTIVE/INACTIVE | a mfg/model is set to Active if there are instances of it on currently registered aircraft. A model is set to INACTIVE when all instances of it, leave the Canadian register. This flag determines which mfg/models will appear in the dropdowns on the Airworthiness Directive page, as INACTIVE models do not appear, and are not monitored for new AD’s |
TYPE | product type (A-aircraft, E-engine, P-propeller, Q-equipment, F-float, S-skis) |
MANUFACTURER | manufacturer of this product |
MODEL | model as it appears on the type certificate data sheet |
TATC CODE | Type Approval - or - Type Certificate code from NICO associated with this product. Can also include TC Exceptions |
COUNTRY | Type Certificate Holder - or - State of Design for this product |
A/C COUNT | Number of Aircraft on the current register using this mfg/model |
Modifying a model
1 - SEARCH
2 - SELECT FROM LIST - then click on the manufacturer (or click the Modify button at the bottom)
The View button - a read-only display of the info for this model
The Delete button - will only work if this model is not in use anywhere in the system (WSDRS, SIGS, TSB, PTS, AD, 5008)
3 - THE MODIFY PAGE
DATA ELEMENT OR FEATURE | DESCRIPTION / FUNCTIONALITY |
|---|---|
NAME (or Common Name) | Manufacturer name The Manufacturer is “selectable” during an ADD, but unchangeable during a modify. When errors are found, where the wrong manufacturer, a backend data cleanup is required as outlined here : CAWIS RE-ASSIGNING EXISTING MODELS TO A NEW MANUFACTURER There is no function to do this task. |
LEGAL NAME | The Legal name is auto-assigned during an ADD (tied to Common Name on y56) It is unchangeable during a model ADD or MODIFY. This can only by altered under the Manufacturer maintenance option on the Administration menu. |
COUNTRY | Type Certificate Holder - or - State of Design assigned to this manufacturer. This can only by altered under the Manufacturer maintenance option on the Administration menu. |
PRODUCT TYPE | Product types , A-aircraft, E-engine, P-propeller, Q-equipment, F-float, S-ski. Can only be assigned to a mfg/model during an ADD. It is unchangeable after that. |
MODEL | 20 character limit. Defaults : 1 - A default model called “FLOAT” exists for every FLOAT manufacturer 2 - A default model called “SKI” exists for every SKI manufacturer 3 - A default model called “PROPELLER” exists for every PROPELLER manufacturer 4 - When the Product Type is Q , the model is always Equipment and there is always 1 equipment record for every manufacturer on y60 5 - All Owner Maintenance (flight authority C ) have models that are suffixed with “X” ( This is a business rule from the 1990’s) Hidden function A model can be altered after being established. Changing 7AB, to 7ABCD, will alter every occurrence of value-1 to value-2 throughout ALL CAWIS subsystems. This is a highly useful tool, in that when bad models are identified, they can be consolidated with another existing model (ie: value-1 is deleted and all instances of it are altered to value-2) |
AIRCRAFT CATEGORY | |
ENGINE CATEGORY | |
GROUP CODE | |
PERSONNEL CODE | |
ACTIVE | |
ASSOCIATED ADS | |
ADD | |
ADD FROM PRODUCT | |
REMOVE | |
TC CODE | |
TC EXCEPTION | |
CAST ICAO | |
SEARCH CAST/ICAO | |
NOTES |
Add Comment