...
DATA ELEMENT OR BUTTON | DESCRIPTION |
MARK | Current aircraft tail mark (Y02,Y93) |
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 |
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 |
MODIFY |
or 2. SELECT AME -OR- AME by a document number search 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 |
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. |
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 : | |
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.
|
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. |
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
...