Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

DATA ELEMENT OR BUTTON 

DESCRIPTION

MARK

Current aircraft tail mark (Y02,Y93)
Note : An aircraft tail mark can change at any time by request of the owner/operator. Occasionally this occurs between issuance of AAIR notification (EDM email or Hard copy mailing) In these instances, an AAIR is required for “this specific aircraft” identified by by model and serial number, regardless of the tail mark noted in the email or on the form.

AAIR DUE

March-30 - or - May-30

LAST AAIR FORM RECEIVED BY TC

Date last AAIR was received/recorded on the M01 table

LAST NOTIFICATION SENT BY TC

Date M01 record for the current reporting year was created (date current dte)

OWNER NAME

Owner name from Y53 table

ADDRESS LINE-1

owner address line-1 (A90)

ADDRESS LINE-2

owner address line-2 (A90)

CITY/TOWN

owner city (A90)

PROVINCE/STATE

owner province_cd (A90)

COUNTRY

owner country_cd (A90)

POSTAL CODE

owner postal cd (A90)

FAX

owner fax number (A92)

PHONE

owner phone number (A92)

AAIR PREFERRED LANGUAGE

values - currently not actioned in any way - all transmissions are bilingual

OWNER EMAIL

owner email address (A92)

FLIGHT AUTHORITY

potential values - unchangeable by the submitter (ultralights H,I not included)

TYPE OF REGISTRATION

potential values - unchangeable by the submitter. Data provided by CCARCS

BASED COUNTRY

Anything from TR21_country table - though 99.9% are listed as Canada

PROVINCE/STATE

Anything from the TR01_province table - includes Canadian provinces and US States

MUNICIPALITY

Freeform text

AIRPORT

Acquired from CCARCS by can be changed by the submitter - freeform text

OTHER

Freeform text

TC REGION

Denotes the physical location of the aircraft’s 5008 file. Region is provided by CCARCS. Not updateable by the Client

Image Added

LAST 100 HOUR INSPECTION

The Client/User provides the Date of their most recent 100 hour inspection for this aircraft. If the user inadvertently provides a date LOWER than the most recent date already on file (C07 table) and submits the AAIR, they would need to contact TC and/or describe the error in the owner notes. Data cleanups of this nature are to be handled by the Publications Unit (see also PBI: #115120) Re-entering the completed AAIR in edit mode will only display the most recent date of inspection found on C07 for this aircraft-id

INSPECTED BY

AME/AMO or Owner/Other

Image Added

MODIFY

  1. SELECT AME -OR- AME by a Name search

Image Added

or

2. SELECT AME -OR- AME by a document number search

Image Added

or

3. CLIENT selects Owner/Other. Owners name is auto filled into INSPECTED-BY field, but can be altered (freeform text) example: instances where the AMO/AME could NOT be located under options 1 or 2

Image Added

AMO/AME NAME

Will contain AMO / AME or Owner-Other name

LICENSE NUMBER

License number of AMO/AME - this field does not appear when OWNER/OTHER is selected.
NOTE: Inactive AMO & AME numbers should always appear in both lists (AMO_INFO, AME_INFO) since the inspection date being entered can potentially be several years old

Aircraft operated pursuant to CAR IV or CAR VIICAR-IV   CAR-V

Not a database element. Simply a radio button that overrides the requirement to put in an Annual inspection date.

Details on the Canadian Aviation regulations are here :

Canadian Aviation Regulations (CARS)  

Has Aircraft been damaged since last report

The Client provides Date damage occurred (Y02_table). Cannot be earlier than year of manufacture or greater than current date.

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, 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 of Repair certification

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 TC users/inspectors might review and/or make corrections

The Last reported Total Time Since New is

Total Hours flown from January 1st to December 31st 2020

Total Hours flown since new up to December 31st 2020

TRAINING

OTHER AERIAL WORK

REPORTING PERIOD

HOURS FLOWN DURING REPORTING PERIOD

MANUFACTURER COMMON NAME

CCARCS DESIGNATION

MODEL

SERIAL NUMBER

TYPE CERTIFICATE

EMPTY WEIGHT LAST ACTUAL

ON L/G

DATE

EMPTY WEIGHT LAST AMENDED

ON L/G

DATE

MAX TAKE OFF WEIGHT

ON L/G

DATE

MODIFY (ENGINE)

REMOVE (ENGINE)

MANUFACTURER 

MODEL

SERIAL NUMBER

TATC CODE

MODIFY (PROPELLER)

REMOVE (PROPELLER)

MANUFACTURER 

MODEL

SERIAL NUMBER

TATC CODE

SKI MANUFACTURER

SKI MODEL

MODIFY

FLOAT MANUFACTURER

FLOAT MODEL

MODIFY

THE AIRCRAFT IS CURRENTLY OUT OF SERVICE

OUT OF SERVICE START DATE

EXPECTED RETURN TO SERVICE DATE

OUT OF SERVICE REASON

OWNERS NOTES

SUBMIT

BACK

INSTRUCTIONS

https://wwwappstest.tc.gc.ca/Saf-Sec-Sur/2/AwD-CN/documents/AAIR_INSTRUCTIONS.pdf

THE AAIR LOG FILE

NOTE : MOST (but not ALL) changes made to the 5008 file during AAIR submission by the CLIENT are recorded to the Y05_AIRCRAFT_AAIR_UPDATES table. Notable exceptions are Email address and hours flown. Changes made by TC user are NOT recorded to Y05

A monthly report of revisions recorded on the Y05 log is produced each month for the publications unit, and is described in detail here : Monthly AAIR revision report

...