Airworthiness Directives - ADD/Modify Mode
- kurt.martin
Fig 1 - New AD (ADD mode)
DATA ELEMENT OR BUTTON | DESCRIPTION |
AD NUMBER | Airworthiness Directive Number Canadian Format : CF-YYYY-NN (CF-YY-NN for 20th century issued ADs, unless revised after 1999) All other numbers : Not entirely standardized. The AD number is provided by the issuing authority. All countries format their AD numbers differently. The USA and Brazil use the same format (YYYY-MM-NN) and can only be differentiated by country code
|
REVISION NUMBER | Default is Zero. Alternately there can be any number of revisions issued for any given AD. (The current maximum found is 9) |
YEAR | Year of issuance of the original AD. Does not appear on external website. |
COUNTRY | Issuing authority Country (TCH or State of Design) |
ENTRY DATE | Default is current date. The Technical Inspectors (TI) will occasionally back date an AD when “old” ADs are being entered for a “newly acquired product” on the Canadian register |
ISSUING AUTHORITY | These are found in the SIGS module, where SIG_TYPE = 'Airworthiness Authority” by country_code match |
LAST UPDATED (DATE) | Default is current date. |
UPDATED BY (USERID) | CAWIS user that entered the AD |
ADD (MODELS) | see fig 2 Click ADD, goes to a new screen where Mfg/models are selected to apply to this AD. Will allow any combination of Mfg/Models. Inspectors can allocate New manufacturers for Equipment types |
SERVICE BULLETINS OR REFERENCE | Service bulletins (SBs) are issued by the manufacturer against specific models, so not ALL SBs necessarily apply to EVERY model against as AD. Once models have been applied to the AD, the SB titles are entered as freeform text, the user clicks a checkbox beside the desired models and the SB note is applied to those models on the C10 table |
CANCELLED OR SUPERSEDED | Has this AD been cancelled or superseded ? All of the “doc available” flags are to be unchecked , removing links to any documents on the public website. A cancelled AD is to appear on the search page without links, with a subject indicating its current disposition.
|
ATA CODE | see fig 3 - Inspector selects an ATA code, default is 00 ATA (aka JASC) codes refer to the section of the aircraft being examined https://wwwapps.tc.gc.ca/Saf-Sec-Sur/2/AWD-CN/documents/SDRCODE.TXT |
ISSUE DATE | Default is current date. The Inspectors will occasionally back date an AD |
EFFECTIVE DATE | Must be current date or greater |
AD SUBJECT (ENGLISH) | Freeform text - normally prefixed with “ATA Code”. Cancelled AD’s should state “Cancelled” and the AD country/number that superseded it. |
AD SUBJECT (FRENCH) | Freeform text. French provided for Canadian ADs only |
APPLICABILITY (ENGLISH) | Freeform text describing Mfg/models affected by this AD |
APPLICABILITY (FRENCH) | Freeform text. French provided for Canadian ADs only |
MAKE LIVE TO WEB | When data entry is completed, and the corresponding AD documents are on the web, this value is set to yes. For cancelled/superseded ADs, the flag is set to “No”, and the subject should be altered to reflect the status of this AD |
ENG HTM DOC AVAILABLE | Is there an English htm available ? (initial AD web was setup with HTM documents only, beginning back in 1996. New HTM publication was discontinued in 2015.) |
FRE HTM DOC AVAILABLE | Is there a French htm available ? |
ENG PDF DOC AVAILABLE | Is there an English pdf available ? |
FRE PDF DOC AVAILABLE | Is there a French pdf available ? French docs are only provided for Canadian ADs |
TRANSPORT CANADA NOTES | Freeform text, any desired background notes pertaining to the AD entered by the TI. This does not appear on the public website. |
PROJECT NO | For Canadian ADs only. A Canadian AD is normally the end-product of a Project (PTS module) (though, there is NOT a project for every “old” pre-CAWIS Canadian AD) |
PUBLICATION TYPE | The Publication type will always be Airworthiness Directive - redundant to show it on this screen |
ORIGINATOR OPI | Name of CAWIS user that opened this project |
PRIORITY | Priority of this AD - values H-HIGH, L-LOW, N-NORMAL |
NAME | Project name from M10_PROJECT |
SAVE | save changes |
BACK | go back without save |
fig 2 - ADD MODELS to AD
DATA ELEMENT OR BUTTON | DESCRIPTION |
TYPE CERTIFICATE HOLDER | (TCH) TC_HOLDER from V_CAW_TC_HOLDER_NAPA@NNPRODC.WORLD
This applies to Aircraft, engine, propeller type models only |
SELECT MANUFACTURER | Alternately, instead of looking up a TCH, the user can simply select a manufacturer directly from the CAWIS y62 table which will populate the model selection windows below |
AND MODEL OF AIRCRAFT | Select aircraft model to apply to this AD. CNTL,select allows the user to select multiple models |
OR ENGINE | Select engine model(s) to apply to this AD. |
OR PROPELLER | Select propeller model(s) to apply to this AD. |
MANUFACTURER (EQUIPMENT) | This applies to Equipment ADs only. Find a matching manufacturer on y62 where product_type_cd = 'Q', this searches on substring as well. |
SELECT ITEM | Select desired equipment manufacturer. |
OTHER | see : Manufacturer Maintenance under “Other Sources” |
APPLY | Apply the models selected on this page to the AD being entered (writes records to the C10 table) |
BACK | go back to the AD entry page without save |
CLEAR | clear all model selections |
fig 3 - Select ATA code
Select ATA code pertaining to this AD. Allows allows for keyword search of ATA code descriptions.
fig 4 - Modify mode
MODIFY MODE differences
DATA ELEMENT OR BUTTON | DESCRIPTION |
AD NUMBER | Ad number cannot be modified here. If necessary, Go to Ad number Quick search, enter the AD number, select the AD, click the “Revise AD number/country” button. This is used often when revising 20th century Canadian AD formats to the 21st century format during a revision
|
REVISION NUMBER | update of revision number is allowed |
YEAR | updatable but should remain at the Year of issuance of the original AD. |
COUNTRY | same rules as for AD number. Can only be changes with the “Revise AD number/country” option |
ENTRY DATE | can be altered to any date selected by the user |
ISSUING AUTHORITY | non updateable, unless the “Revise AD number/country” is used, then the issuing authority (on SIGS) will update to match any potential new country code. Does not appear on the external website.
|
LAST UPDATED (DATE) | auto updated on save |
UPDATED BY (USERID) | auto updated on save |
ADD (MODELS) | any models can be added or removed as desired |
SERVICE BULLETINS OR REFERENCE | SB’s can be updated or removed as desired |
CANCELLED OR SUPERSEDED | fully updatable. Yes or No |
ATA CODE | fully updatable |
ISSUE DATE | fully updatable |
EFFECTIVE DATE | fully updatable |
AD SUBJECT (ENGLISH) | fully updatable |
AD SUBJECT (FRENCH) | fully updatable |
APPLICABILITY (ENGLISH) | fully updatable |
APPLICABILITY (FRENCH) | fully updatable |
MAKE LIVE TO WEB | fully updatable |
ENG HTM DOC AVAILABLE | fully updatable |
FRE HTM DOC AVAILABLE | fully updatable |
ENG PDF DOC AVAILABLE | fully updatable |
FRE PDF DOC AVAILABLE | fully updatable |
TRANSPORT CANADA NOTES | fully updatable |
PROJECT NO | not updatable. AD-number/Project-id relationships and all project related fields below, are handled in the PTS module. Project related fields will only appear if the AD number is referenced in the PTS module |
PUBLICATION TYPE | non updatable |
ORIGINATOR OPI | non updatable |
PRIORITY | non updatable |
NAME | non updatable |
SAVE | save changes |
BACK | go back without save |