CAWIS 5008 FILE MAINTENANCE

DATA ELEMENT

FIELD NAME

TABLE(s)

DESCRIPTION

REGISTRATION MARK

AIRCRAFT_MARK_ID

Y02_AIRCRAFT_HISTORY

allocated by CCARCS, can be changed by the aircraft owner through a CCARCS process, or a new tail mark is allocated when a previously registered aircraft, re-registers.

All Canadian tail marks are prefixed with “CF”,”CG”, or “CI” (CI is for ultralights only) .

The “C” prefix is omitted throughout CAWIS.

A Tail Mark can only occur ONCE on the current aircraft register, but can be seen occurring multiple times on deregistered aircraft.

Tail mark is unchangeable in CAWIS.

AIRCRAFT ID

AIRCRAFT_ID

Y01_AIRCRAFT

a 7 digit numeric identifier allocated by CCARCS.

An Aircraft tail mark may change over time, but its aircraft_id remains the same throughout its existence in CCARCS and CAWIS

NOTE: There is no field on this page, which indicates to the user if an aircraft resides on the current register or if it has been deregistered and archived (aircraft id exists on Y93_CCARCS_PREVIOUS_DAY) . [ER]The users need a registered/deregistered indicator somewhere at the top of the screen

COFR ISSUE DATE

DATE_C_OF_R_ISSUE_DTE

Y02_AIRCRAFT_HISTORY

Certificate of Registration date is allocated by CCARCS, on any new aircraft registry or after an ownership change

AIRCRAFT CATEGORY

AIRCRAFT_CATEGORY_CD

Y62_PRODUCT_MAKE_MODEL

Determined by the aircraft manufacturer / model

1-AEROPLANE
2-HELICOPTER
3-GLIDER
4-GYROPLANE
5-BALLOON
6-AIRSHIP
7-ORNITHOPTER
8-POWERED PARACHUTE

This field controls some editing aspects of the 5008 file (examples: Helicopters cannot have propellers, Gliders do not have engines or propellers)

This field can only be altered using the mfg/model facility in the admin module

Manufacturer/Model Maintenance

FILE ENTERED 

DATE_CURRENT_DTE

Y01_AIRCRAFT

The date this aircraft first appeared in CAWIS.

YEAR MANUFACTURED

YEAR_OF_MANUFCTURE_NBR

Y01_AIRCRAFT

Acquired from CCARCS. Can be altered by CAWIS users.
No other date related element in the 5008 file can be earlier than the year of manufacture. (examples: flight hours, inspections)

LAST UPDATED

LAST_MOD_TIMESTAMP_DTE

Y02_AIRCRAFT_HISTORY

Date of last modification to this file

UPDATED BY

LAST_MOD_BY_USER_ID

Y02_AIRCRAFT_HISTORY

Userid of person or batch job that last modified this file

OWNER NAME

Y56.NAME_COMMON_NM

-OR-

Y55.NAME_LAST_NM +

Y55.NAME_FIRST_NM +

Y55.NAME_MIDDLE_NM

Y56_ORGANIZATION

-OR-

Y55_INDIVIDUAL

OWNER/OPERATOR NAME - allocated by CCARCS, unchangeable in CAWIS. If a company has a Trade_name in CCARCS, this is appended onto y56.name_common_nm in CAWIS.

If an aircraft on the current register is “sale reported” - or - “invalid address” they are assigned unknown ownership until such time that these flags are removed in CCARCS

Party_id 9999999 = UNKNOWN

FILE LOCATION REGION

TC_REGION_CD

Y02_AIRCRAFT_HISTORY

Region where the hardcopy file for this aircraft resides
1-PACIFIC
3-PNR
4-ONTARIO
5-QUEBEC
6-ATLANTIC
7-NCR

FILE LOCATION TCC 

TCC_OFFICE_FILE_LOCATION_CD

Y02_AIRCRAFT_HISTORY

Transport Canada Center (TCC) within the file location region, where the file for this aircraft resides

CAWIS CODE TABLES

AAIR SUBMISSION ALLOWED

n/a

M01_AIRCRAFT_AAIR_REPORT

Was this aircraft sent an AAIR request (M01 record exists) for the current reporting year (current year - 1) and is the Received date null ? If yes, AAIR submission is allowed.

LAST AAIR NOTIFICATION SENT BY TC

DATE_REPORT_ISSUE_DTE

M01_AIRCRAFT_AAIR_REPORT

Date that the most recent AAIR notification was sent to the owner of this aircraft (Allocated during the EDM process)

COFA ANNIVERSARY (MM/DD)

DATE_C_OF_A_ISSUE_DTE

Q01_AIRCRFT_FLGHT_ATHTY

[ER] Please remove this field, from this page.

The Certificate of Airworthiness anniversary date was only used for AAIR scheduling under the old AAIR distribution system, when forms were printed and mailed out weekly

DUE DATE

DATE_AAIR_DUE_ALT_DTE

Y02_AIRCRAFT_HISTORY

The column name, DATE_AAIR_DUE_ALT_DTE is misleading in that it used to be used for special/alternate AAIR due dates on owner request under the old weekly distribution system.

It is now ONLY used as the sole due-date for a given aircraft.

There are only 2 due dates presently permitted

30-MARCH - this is the default

30-MAY - manually allocated by the publications section on Owner request.

Any aircraft that has not filed an AAIR by 30-MAY is considered Overdue and is re-contacted during the overdue EDM processes

FLEET NUMBER

FLEET_ID

Y02_AIRCRAFT_HISTORY

Fleet Numbers are allocated through the AAIR subsystem by operator request. They cannot be altered on the 5008 page.

A fleet number ties several aircraft together for AAIR reporting purposes.

Aircraft having a Fleet number are not processed by the EDM notification system.

Fleet owners are emailed a spreadsheet containing all the tombstone information for their aircraft, which they fill in or alter then send back to TC with their flight hours.

Fleets are maintained MANUALLY by the Aircraft Certification publications unit, though a reference table of Fleet-numbers and client-id’s for each fleet exists in Z980_TERM_CONVERSION where term_type_cd = ‘FLEET’

FLEET NAME

NAME_COMMON_NM

Y59_FLEET,

Y56_ORGANIZATION

Owner/operator of this fleet. Name is allocated by the CAW publications unit under AAIR maintenance.

USER ID

CLIENT_ID

Y50_PARTY

An AAIR “userid” is actually a CCARCS client_id associated with this owner/operator. Allocated by CCARCS, unchangeable in CAWIS

CLIENT_ID / HASHED(PARTY_ID) is the default userid/password for entering the external AAIR submission page (unless the operator has allocated a user selected password)

SALE REPORTED

SALE_REPORTED

Y93_CCARCS_PREVIOUS_DAY

If the sale reported indicator is “Y” on Y93, the ownership of this aircraft is changed to “Unknown”

This indicates that the last known owner of the aircraft, reported a sale, but the new owner has not identified themselves to TC. This happens often in the case of destroyed aircraft, where the insurance company takes possession, the aircraft is unsalvageable, and no one follows through with the deregistration procedure in CCARCS

INVALID ADDRESS

ACTIVE_FLAG

Y93_CCARCS_PREVIOUS_DAY

Values in CCARCS are, “A” active, “I” inactive.

If an aircraft (address) is marked Inactive on Y93, the ownership of this aircraft is changed to “Unknown” until such time as the addressing info can be corrected.

MULTIPLE OWNER

MULTIPLE_OWNER_FLAG

Y93_CCARCS_PREVIOUS_DAY

Values in CCARCS are, “Y” / “N”

This field is provided for informational purposes only.

An aircraft can be shared by multiple owners. However the owners select a “primary” owner, used for all correspondence.

CAWIS only imports the information for the primary owner.

Full ownership of an aircraft having multiple owners can be viewed here:

https://wwwapps.tc.gc.ca/Saf-Sec-Sur/2/CCARCS-RIACC/

CLIENT ID

CLIENT_ID

Y50_PARTY

CCARCS CLIENT_ID for this owner/operator. Unchangeable in CAWIS - [ER] Repeated from USERID, please remove

OWNER NAME

Y56.NAME_COMMON_NM

-OR-

Y55.NAME_LAST_NM +

Y55.NAME_FIRST_NM +

Y55.NAME_MIDDLE_NM

Y56_ORGANIZATION

-OR-

Y55_INDIVIDUAL

OWNER/OPERATOR NAME - allocated by CCARCS, unchangeable in CAWIS.

If a company has a Trade_name in CCARCS, this is appended onto y56.name_common_nm in CAWIS.

If an aircraft on the current register is “sale reported” - or - “invalid address” they are assigned unknown ownership until such time that these flags are removed in CCARCS

Party_id 9999999 = UNKNOWN, used for sale-reported/invalid address

Party_id 1 = Owner Unknown - For the purposes of producing Flight hours reports. This Party_id is used to backfill Historical ownership down to the earliest year of AAIR reporting (CAWIS does not have access to CCARCS history)

ADDRESS LINE 1

ADDRESS_LINE1_TXT

Y90_PARTY_CONTACT,

A90_ADDRESS

ADDRESSING DATA - allocated by CCARCS, unchangeable in CAWIS.

ADDRESS LINE 2

ADDRESS_LINE2_TXT

Y90_PARTY_CONTACT,

A90_ADDRESS

ADDRESSING DATA - allocated by CCARCS, unchangeable in CAWIS.

CITY/TOWN

CITY_TXT

Y90_PARTY_CONTACT,

A90_ADDRESS

ADDRESSING DATA - allocated by CCARCS, unchangeable in CAWIS.

COUNTRY

COUNTRY_CD

Y90_PARTY_CONTACT, A90_ADDRESS, TR21_COUNTRY

ADDRESSING DATA - allocated by CCARCS, unchangeable in CAWIS.

POSTAL CODE

POSTAL_CODE_ID

Y90_PARTY_CONTACT,

A90_ADDRESS

ADDRESSING DATA - allocated by CCARCS, unchangeable in CAWIS.

PROVINCE STATE

PROVINCE_CD

Y90_PARTY_CONTACT,

A90_ADDRESS , TR01_PROVINCE

ADDRESSING DATA - allocated by CCARCS, unchangeable in CAWIS.

PHONE

ADDRESS_PROPERTY_TXT

A92_ADDRESS_PROPERTY

ADDRESS_PROPERTY_TYPE_CD = 1, Ordinal_nbr = 1

Acquired from CCARCS, but updateable in CAWIS.

As the first step of the nightly sync, CCARCS will pull CAWIS contact data (phone/fax/email) and apply it to the matching client_id on the CCARCS side, if the Update date on the CAWIS side is LATER than the one found in CCARCS.

Therefor in step 2, ALL of the most up to date contact data is then exported into the CCARCS view CARS_DAILY_CAIS_MASTER.

So all of the CONTACT data differences found on the CCARCS side, are then pulled into CAWIS as they are deemed to be the most “recent”

NOTE: the CCARCS/CAWIS exchange of contact data uses Y50.CLIENT_ID to pull the newest data for each owner. However, in CAWIS a single CLIENT_ID can be tied to any number of PARTY_IDs (based on differences in company spelling, trade names and addressing) Its important to note that the same contact data must be applied to ALL addressing records linked to each party_id for a single client_id for the data exchange to function properly

FAX

ADDRESS_PROPERTY_TXT

A92_ADDRESS_PROPERTY

ADDRESS_PROPERTY_TYPE_CD = 2

see contact data exchange rules under “PHONE”

AAIR PREFERRED COMMUNICATION METHOD

PREFER_NOTIFICATION_METHOD_CD

Y50_PARTY

Values 1-EMAIL, 2-FAX, 3-MAIL

This field is only used by the EDM module. The FAX portion of the EDM is currently not being executed. All aircraft set to 3-mail will be ignored by the email section of the EDM
A client must have a valid email address if option is set to “1”.

AAIR PREFERRED LANGUAGE

LANGUAGE_CD

Y50_PARTY

Values - E-English , F-French ,B-Bilingual , U-unknown

For information only. Not acknowledged by the EDM code - ALL transmissions/mailings are bilingual

EMAIL

ADDRESS_PROPERTY_TXT

A92_ADDRESS_PROPERTY

ADDRESS_PROPERTY_TYPE_CD = 3

See contact data exchange rules under “PHONE”

FLIGHT AUTHORITY

TYPE_OF_AUTHORITY_CD

Q01_AIRCRFT_FLGHT_ATHTY , TR12_TYPE_OF_AUTHORITY

Acquired from CCARCS, changeable by CAWIS users

A-C-OF-A
B-RESTRICTED
C-OWNER MAINT
D-LIMITED
E-EXHIBITION
F-AMATEUR BUILT
G-EXPERIMENTAL
H-ULTRA-LIGHT
I-ADV ULTRA-LIGHT
J-SPECIFIC PURP
K-SPECIAL PURPOSE
L-NON-TYPE CERTIFIED

Flight Authority controls how a 5008 file is edited, whether that aircraft must comply with Airworthiness Directives (AD) and if that aircraft must submit an AAIR.

Types A,B,D,E,G,J,K,L (Category A) are treated as Type_approved aircraft

Types C,F,H,I (Category B) are all treated as non-type approved aircraft and do not have to comply with AD’s

Types C&F must submit an AAIR, H&I do not.

TATC - Type Approval/Type Certfificate TC Exceptions

FLIGHT AUTHORITY ISSUED

DATE_C_OF_A_ISSUE_DTE

Q01_AIRCRFT_FLGHT_ATHTY

This is better known as CERTIFICATE OF AIRWORTHINESS date. It is filled in by the regional PMI’s as they are acquired.

ALTERNATE FLIGHT AUTHORITY 1

TYPE_OF_AUTHORITY_CD

Q01_AIRCRFT_FLGHT_ATHTY , TR12_TYPE_OF_AUTHORITY

Optional, has no effect on aircraft editing. Category A and Category B flight authorities cannot be intermixed. Rarely filled in.

ALTERNATE FLIGHT AUTHORITY 2

TYPE_OF_AUTHORITY_CD

Q01_AIRCRFT_FLGHT_ATHTY , TR12_TYPE_OF_AUTHORITY

Optional, has no effect on aircraft editing. Category A and Category B flight authorities cannot be intermixed

YEAR IMPORTED

YEAR_OF_IMPORT_NBR

Y02_AIRCRAFT_HISTORY

Allocated by CCARCS, updateable by CAWIS users. Cannot be earlier than year of manufacture or greater than current year. Current year imported aircraft are NOT sent AAIR notification.

TYPE OF REGISTRATION

AIRCRAFT_PURPOSE_CD

Y02_AIRCRAFT_HISTORY , TR10_AIRCRAFT_PURPOSE

Allocated by CCARCS, unchangeable by CAWIS users

Values

1-PRIVATE
2-COMMERCIAL
3-STATE
4-UNKNOWN
9-MILITARY

COUNTRY(BASED)

COUNTRY_CD

Y02_AIRCRAFT_HISTORY , TR21_COUNTRY_CD

CAWIS CODE TABLES

Based country.

99.9% are listed as Canada.

Acquired from CCARCS, updateable by CAWIS users

PROVINCE(BASED)

PROVINCE_CD

Y02_AIRCRAFT_HISTORY , TR01_PROVINCE

CAWIS CODE TABLES

Based province

Acquired from CCARCS, updateable by CAWIS users

MUNICPALITY(BASED)

MUNICIPALITY_TXT

Y02_AIRCRAFT_HISTORY

Free form text entry by CAWIS users

AIRPORT

AIRPORT_TXT

Y02_AIRCRAFT_HISTORY

Acquired from CCARCS, updateable by CAWIS users

OTHER

OTHER_LOCATION_TXT

Y02_AIRCRAFT_HISTORY

Free form text entry by CAWIS users

TC REGION

TC_REGION_CD

Y02_AIRCRAFT_HISTORY

This is a repeat of the field FILE LOCATION REGION

LAST TC INSPECTION

DATE_INSPECT_DTE

C07_AIRCRAFT_INSPECTION, TR20_INSPECTION_TYPE

Inspection Type 1 - TC inspection

Cannot be earlier than year of manufacture. Does not appear on the AAIR page. Entered by CAWIS users.

LAST ANNUAL OR 100 HOUR INSPECTION

DATE_INSPECT_DTE

C07_AIRCRAFT_INSPECTION, TR20_INSPECTION_TYPE

Inspection Type 2 - Other

Cannot be earlier than year of manufacture.

Only the most recent inspection date appears onscreen. Errors cannot be corrected.

[ER] The users need to be able to delete incorrect inspect dates (a frequent occurence) and be able to view them all onscreen in a grid format

See PBI 115120
https://dev.azure.com/transport-canada/DSD-CIVAV%20Support/_workitems/edit/115120

New format Jan 2022

Open

INSPECTED BY AMO/AME

INSPECTED_BY_CD

C07_AIRCRAFT_INSPECTION, TR27_INSPECTED_BY

Radio button

VALUES

1-AME
2-AMO
3-OWNER

AME/AMO will prompt the user for a number after clicking “modify”.

OWNER will fill the OTHER_NAME field with owner name, which the user can update, if desired.

INSPECTED BY NAME

INSPECTOR_NAME_OTHER_NM

C07_AIRCRAFT_INSPECTION, AMO_info, AME_info

AME name or AMO company name associated to type/number provided

APPROVAL/LICENCE NUMBER

INSPECTOR_AME_LICENSE_NUMBER_I

-or-
INSPECTOR_AMO_LICENSE_NUMBER_I

C07_AIRCRAFT_INSPECTION, AMO_info, AME_info

AME or AMO number (numeric characters only)

OTHER NAME

INSPECTOR_NAME_OTHER_NM

C07_AIRCRAFT_INSPECTION

Owner name or name of any inspecting person/organization that could not be found on AME/AMO tables

DAMAGED SINCE LAST AAIR

Radio button - Yes/no.

Yes, Allows entry of a new damaged date.

DATE DAMAGED

DATE_DAMAGED_DTE

Y02_AIRCRAFT_HISTORY

Cannot be earlier than year of manufacture or greater than current date.

The Client provides Date damage occurred (Y02_table) during AAIR submission. If a Damaged date was provided in a previous reporting year, but NO repair date was ever provided, that Damaged date will continue to appear each year on the AAIR page, until such time as the operator provides a Repaired-date.

When a Y02 record is found to have both a DAMAGED date and a REPAIRED date, the overnight job (beginning 3rd week of December of any given year) will insert a NEW Y02 record having NULLS in both the damaged and repaired date fields, so the damaged date will come up null for the next reporting year.

NOTE: the CLIENT can also NULL out a damaged date without providing a repair date. This gets recorded to the Y05 log file

DATE REPAIR CERTIFIED

DATE_REPAIRED_DTE

Y02_AIRCRAFT_HISTORY

Cannot be earlier than year of manufacture or greater than current date.

Must be greater than or equal to Damaged date.

[ER] Historical Damaged and Repaired dates need to appear in a grid format on the 5008 page so the TC user might review and/or make corrections

REPORTING YEAR

YEAR_CALENDAR_NBR

M01_AIRCRAFT_AAIR_REPORT

Collection year for flight hours. There will be 1 row for every year that AAIR notification was sent (M01 records)
The latest AAIR collection year is always CURRENT_year - 1

Note: Rows for reporting years only appear when AAIR notifications have been issued (M01 table) Therefor, ultralights or any aircraft built during the current year will not display AAIR data

AAIR RECEIVED

DATE_AAIR_RECEIPT_DTE

M01_AIRCRAFT_AAIR_REPORT

Date AAIR was received for a given collection year. Null in this field where Reporting-year < Current-year - 2, -or- due-date for this year has passed, indicates an overdue reporter

HOURS FLOWN

HOURS_FLOWN_NBR

Q02_AIRCRFT_LCNS_TYP_HR, TR34_FLYING_HOURS_TYPE

Flying hours type Code = 2 , Flying hours for this collection year

TRAINING HOURS

HOURS_FLOWN_NBR

Q02_AIRCRFT_LCNS_TYP_HR, TR34_FLYING_HOURS_TYPE

Flying hours type Code = 3 , Training hours for this collection year (aka Operating rule: 406 hours ) Very rarely filled in. This data element has NO relationship to the License_type_cd (aka: Operating Rule) column on Y02_aircraft_history from which operating rule breakdowns are provided to TC requestors.

OTHER AERIAL WORK

HOURS_FLOWN_NBR

Q02_AIRCRFT_LCNS_TYP_HR, TR34_FLYING_HOURS_TYPE

Flying hours type Code = 4 , Other hours for this collection year. Very rarely filled in.

TIME SINCE NEW

HOURS_FLOWN_NBR

Q02_AIRCRFT_LCNS_TYP_HR, TR34_FLYING_HOURS_TYPE

Flying hours type Code = 1 ,

Total hours (TSN) on this aircraft at the end of the collection year

Cannot be less than hours flown for that year or less than the TSN for the previous year.

CYCLES SINCE NEW

HOURS_FLOWN_NBR

Q02_AIRCRFT_LCNS_TYP_HR, TR34_FLYING_HOURS_TYPE

Flying hours type Code = 6 ,

Rarely filled in. Accessible by TC users only. This field does not appear on the web AAIR form or the paper form.

OWNER NAME

Y56.NAME_COMMON_NM

-OR-

Y55.NAME_LAST_NM +

Y55.NAME_FIRST_NM +

Y55.NAME_MIDDLE_NM

Y53_PARTY_LIST,

Y55_INDIVIDUAL, Y56_ORGANIZATION

Owner/Operator of this aircraft during this reporting year

(Note : this party_id is also available in the run_id column of M01 for reporting purposes)

COMMON NAME

Y04.MANUFACTURER_ID,

Y56.COMMON_NAME

Y04_AIRCRAFT_CONFIGURATION + Y60_MANUFACTURER + Y56_ORGANIZATION

Aircraft manufacturer - acquired from CCARCS, possibly revised by Z980_term_conversion. Can be altered by CAWIS users and sent to the NOT report for TI review

Manufacturer Maintenance

CCARCS DESIGNATION

NAME_LEGAL_NM

Y01_AIRCRAFT

Acquired from CCARCS fields :

ID_PLATE_MANUFACTURERS_NAME -or-
ULTRA_AMATEUR_BUILT_MANUFACTUR

Unchangeable in CAWIS

MODEL

MODEL_ID

Y04_AIRCRAFT_CONFIGURATION

Aircraft model. Acquired from CCARCS, matched to approved models on Y62 -or- added as a new model to TR24/Y61/Y62

SERIAL NUMBER

SERIAL_ID

Y04_AIRCRAFT_CONFIGURATION

Acquired from CCARCS.

TATC CODE

TATC_CD

Y62_PRODUCT_MAKE_MODEL

For display only - TATC code from Y62 table based on aircraft mfg/model match. Can only be altered from the mfg/model maintenance page

Manufacturer/Model Maintenance

PRESSURIZED?

PRESSURIZED_IND

Y01_AIRCRAFT

CAWIS stopped receiving this data element from CCARCS many years ago. Not populated or reviewed

EMPTY WEIGHT LAST ACTUAL LBS

WEIGHT_NBR, WEIGHT_TYPE_CD

Y03_AIRCRFT_TKFF_WGHT

type 1 - entered by TC user or Client. Cannot exceed max-takeoff.

EMPTY WEIGHT LAST ACTUAL KGS

Y03_AIRCRFT_TKFF_WGHT

for display only. All weights are stored in pounds

ON LG

UNDERCARRIAGE_TYPE_CD

Y03_AIRCRFT_TKFF_WGHT, TR39_UNDERCARRIAGE_CONFIG

Optional. Default is “unknown”

Values are

1-WHEELS
2-SKIS
3-FLOATS
4-UNKNOWN
5-SKIDS

DATE

DATE_WEIGHT_START_DTE

Y03_AIRCRFT_TKFF_WGHT

date EMPTY WEIGHT LAST ACTUAL was entered. Cannot be less than year of manufacture or greater than current date

EMPTY WEIGHT LAST AMENDED LBS

WEIGHT_NBR, WEIGHT_TYPE_CD

Y03_AIRCRFT_TKFF_WGHT

type 2 - entered by TC user or Client. Cannot exceed max-takeoff.

EMPTY WEIGHT LAST AMENDED KGS

Y03_AIRCRFT_TKFF_WGHT

for display only. All weights are stored in pounds

ON LG

UNDERCARRIAGE_TYPE_CD

Y03_AIRCRFT_TKFF_WGHT, TR39_UNDERCARRIAGE_CONFIG

Optional. Default is “unknown”

Values are

1-WHEELS
2-SKIS
3-FLOATS
4-UNKNOWN
5-SKIDS

DATE

DATE_WEIGHT_START_DTE

Y03_AIRCRFT_TKFF_WGHT

date EMPTY WEIGHT LAST AMENDED was entered. Cannot be less than year of manufacture or greater than current date

MAX TAKEOFF WEIGHT LBS

WEIGHT_NBR, WEIGHT_TYPE_CD

Y03_AIRCRFT_TKFF_WGHT

type 3 - entered by TC user or Client.

MAX TAKEOFF WEIGHT KGS

Y03_AIRCRFT_TKFF_WGHT

for display only.

All weights are stored in pounds

ON LG

UNDERCARRIAGE_TYPE_CD

Y03_AIRCRFT_TKFF_WGHT, TR39_UNDERCARRIAGE_CONFIG

Optional. Default is “unknown”

Values are

1-WHEELS
2-SKIS
3-FLOATS
4-UNKNOWN
5-SKIDS

MAX TAKEOFF WEIGHT ALTERNATE LG LBS

WEIGHT_NBR, WEIGHT_TYPE_CD

Y03_AIRCRFT_TKFF_WGHT

type 4 - entered by TC user or Client.

MAX TAKEOFF WEIGHT ALTERNATE LG KGS

Y03_AIRCRFT_TKFF_WGHT

for display only. All weights are stored in pounds

ON LG

UNDERCARRIAGE_TYPE_CD

Y03_AIRCRFT_TKFF_WGHT, TR39_UNDERCARRIAGE_CONFIG

Optional. Default is “unknown”

Values are

1-WHEELS
2-SKIS
3-FLOATS
4-UNKNOWN
5-SKIDS

NUMBER OF ENGINES

COUNT_ENGINES_NBR

Y01_AIRCRAFT

Number of engines is dictated by the number of engine rows found for this aircraft on Y04

ENGINE CATEGORY

ENGINE_CATEGORY_CD

Y62_PRODUCT_MAKE_MODEL

Determined by Engine MFG/MODEL #1 lookup on Y62

values

A-RECIPROCATING
B-TURBO JET
C-TURBO PROP
D-TURBO FAN
E-NO ENGINE
F-TURBO SHAFT
Y-NOT DEFINED

ENGINE MANUFACTURER 1

Y04.MANUFACTURER_ID,

Y56.COMMON_NAME

Y04_AIRCRAFT_CONFIGURATION + Y60_MANUFACTURER + Y56_ORGANIZATION

Engine manufacturer.

Entered by CAWIS users (PMI) and clients. There is no limit to the number of Engine Mfg/models that can be assigned to an aircraft.

Note: aircraft category Glider cannot have engines (input field does not appear)

Manufacturer Maintenance

ENGINE MODEL 1

MODEL_ID

Y04_AIRCRAFT_CONFIGURATION

Engine model. Entered by CAWIS users. 1 for every Engine manufacturer

ENGINE SERIAL 1 

SERIAL_ID

Y04_AIRCRAFT_CONFIGURATION

Engine serial number. Entered by CAWIS users. 1 for every Engine manufacturer

ENGINE TATC CODE 1

TATC_CD

Y62_PRODUCT_MAKE_MODEL

For display only - TATC code from Y62 table based on aircraft mfg/model match. Can only be altered from the mfg/model maintenance page

Manufacturer/Model Maintenance

PROPELLER MANUFACTURER 1

Y04.MANUFACTURER_ID,

Y56.COMMON_NAME

Y04_AIRCRAFT_CONFIGURATION + Y60_MANUFACTURER + Y56_ORGANIZATION

Propeller manufacturer. Entered by CAWIS users and clients. Propeller manufacturer count must match Engine row count.

aircraft categories : Glider and Helicopter do not have propellers (input field does not appear)

Manufacturer Maintenance

PROPELLER MODEL 1

MODEL_ID

Y04_AIRCRAFT_CONFIGURATION

Propeller model. Entered by CAWIS users. 1 for every Propeller manufacturer.

PROPELLER SERIAL 1 

SERIAL_ID

Y04_AIRCRAFT_CONFIGURATION

Propeller serial number. Entered by CAWIS users. 1 for every Propeller manufacturer

PROPELLER TATC CODE 1

TATC_CD

For display only - TATC code from Y62 table based on aircraft mfg/model match. Can only be altered from the mfg/model maintenance page

Manufacturer/Model Maintenance

SKI MANUFACTURER

Y04.MANUFACTURER_ID,

Y56.COMMON_NAME

Y04_AIRCRAFT_CONFIGURATION + Y60_MANUFACTURER + Y56_ORGANIZATION

Ski manufacturer.

Entered by CAWIS users and clients.

Manufacturer Maintenance

SKI MODEL

MODEL_ID

Y04_AIRCRAFT_CONFIGURATION

Ski model.

Entered by CAWIS users. Default for unknown model is SKI

FLOAT MANUFACTURER 

Y04.MANUFACTURER_ID,

Y56.COMMON_NAME

Y04_AIRCRAFT_CONFIGURATION + Y60_MANUFACTURER + Y56_ORGANIZATION

Float manufacturer. Entered by CAWIS users.

Manufacturer Maintenance

FLOAT MODEL

MODEL_ID

Y04_AIRCRAFT_CONFIGURATION

Float model.

Entered by CAWIS users. Default for unknown model is FLOAT

OUT OF SERVICE

Y02_AIRCRAFT_HISTORY

checkbox to allow entry of Out-of-service period

EFFECTIVE DATE OUT OF SERVICE

OUT_OF_SERVICE_START_DTE

Y02_AIRCRAFT_HISTORY

Beginning of Out-of-Service (OOS) period. If the beginning of the OOS period, falls within the current year, the operator is obliged to file an AAIR for this year during the next AAIR issuance cycle beginning in January (zero hours or otherwise)

When this column was added in 2018, the default for this date was the earliest Y02 start date where the Estimated Return to Service date was found.

If the OOS date range covers an entire calendar year, AAIR’s are inserted with received dates, and zero flight hours recorded for the OOS years

ESTIMATED RETURN TO SERVICE

DATE_EXPECTED_RETURN_DTE

Y02_AIRCRAFT_HISTORY

End of Out-of-Service period. Must be greater than EFFECTIVE DATE OUT OF SERVICE.

Must be greater than Current date.

Must encompass a full calendar year ( if youre out-of-service beginning this year, and returning to service next year, the aircraft is still obliged to report for the 2 reporting years )

When an ESTIMATED RETURN TO SERVICE is passed, the system will insert a new Y02 record with nulls in all of the out of service fields.

If an aircraft is returned to service early ( this feature only appears under AAIR maintenance )
1-DATE_RETURED_TO_SERVICE_DTE becomes sysdate

2-ESTIMATED RETURN TO SERVICE becomes sysdate

3-the overnight batch job inserts a new Y02 record with nulls in the out of service fields

OUT OF SERVICE REASON

EXOS_CD

Y02_AIRCRAFT_HISTORY, TR08_EXOS_CODE

values

1-OTHER/UNKNOWN
2-MODS
3-STORAGE
4-DAMAGED
5-MISSING
6-RETIRED
7-MAINT INSTRUCTION
8-MUSEUM
9-RESTORATION

ESTIMATED RETURN TO SERVICE DATE UNKNOWN

Y02_AIRCRAFT_HISTORY

checkbox which allocates the maximum expected return to service date (5 years)

TRANSPORT CANADA NOTES

TC_NOTES_TXT
TC_NOTES2_TXT
TC_NOTES3_TXT
TC_NOTES4_TXT

Y01_AIRCRAFT

All TC user entered notes for this aircraft

OWNER NOTES

TC_AAIR_NOTES_TXT

M01_AIRCRAFT_AAIR_REPORT

Notes from Client during AAIR submission. Concatenated year to year from newest to oldest. Not updateable by TC users