AAIR CLIENT SUBMISSIONS EXTERNAL

Step 1 SELECT AAIR LOGIN

Step 2 AAIR LOGIN

Owner logs in with AAIR User_id (Client-id from y50) and AAIR Password (provided on the last paper form sent to this client - or - user selected from “Forgot User_id or Password option”)

Step 2b Acquire Userid and/or Create new password, where necessary

User provides an email address. An email providing client id and a link to reset the password is sent to the client

Step 3 AAIR LOGIN

Step 4 AIRCRAFT SELECTION LIST

The owner is then presented with a full list of aircraft associated with the client id used for login

DATA ELEMENT OR BUTTON	DESCRIPTION
Due	Yes - aircraft has not yet submitted for the current reporting year (Current-year - 1) No - an AAIR has been received (M01 table) -or- The Aircraft is listed as having been built during the current year (Y01 table) and is automatically deemed to have not flown in the last calendar year
Mark	Aircraft tail mark. Prefix “CF” or “CG” . (Y02 table). Operator selects an aircraft for submission by clicking the tail-mark link.
make/model	Aircraft manufacturer and model (Y04 table)
owner	Aircraft owner, operator, Lessor or in cases of group ownership, selected primary owner. (Y53 table)
Due date	Due date for AAIR submission. Approximately 3 months notice is given. Currently the only permitted values are 30-March (98% of all AAIR eligible operators) -or- 30-May

Step 5 AAIR DATA ENTRY

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
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	SELECT AME -OR- AME by a Name search 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. 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 VII	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 :	Non updatable. Total Time Since New (TSN) for this aircraft (Q02 table where flying hours type code = 1) from the most recently received AAIR is provided here for reference. Client issues with this figure should be placed in the owner notes for any data repair required by the Publications unit.
Total Hours flown from January 1st to December 31st YYYY	Total hours flown by this aircraft in the reporting year (Current year - 1) Cannot exceed 8760 hours (24 hours * 365 days in a year)
Total Hours flown since new up to December 31st YYYY	Total time since new (TSN) for this Aircraft up to 31-December of the reporting year. This value must be greater than or equal to the TSN provided above
TRAINING	Any training related (Operating rule 406) performed during this reporting period. Must be less then or equal to Hours flown in that year
OTHER AERIAL WORK	Any “other” related performed during this reporting period. Must be less then or equal to Hours flown in that year (Note: this data element and Training hours were added by management request in the late 90’s but are very rarely filled in ) [ER] There exists an ongoing request from the AVSTATS group to breakdown flight hours for all aircraft by operating rule. This would entail 1) adding these codes to TR34_flying_hours_type, 2) recoding the AAIR and the 5008 page with these 7 extra columns 3) redesigning the paper form 4) reconciling the Historical data from Y02, which does provide a PRIMARY-OPERATING-RULE for any given year and breaking down the existing Annual hours flown on Q02 by some agreed upon percentile
REPORTING PERIOD	Show the client previous years for which this aircraft has submitted a report (non-updatable) Any discrepancies should be reported in the owner notes field. (There are frequently disagreements in the logbooks, when ownership changes for the aircraft) This data element will display Reporting-period/hours-flown for ALL years in which this aircraft reported an AAIR. Notes: AAIR was only saved historically beginning in 1994 AAIR data cannot exist prior to the aircraft year of manufacture (Y01)
HOURS FLOWN DURING REPORTING PERIOD	ANNUAL HOURS FLOWN (from Q02 table where flying hours type code = 2) for the reporting period
MANUFACTURER COMMON NAME	Aircraft manufacturer - Y04 table - acquired from CCARCS Not updateable by client All mfg/model discrepancies should be reported in the owner notes field.
CCARCS DESIGNATION	CCARCS legal name for this manufacturer (Y01 -or- Y93) Not updateable by client
MODEL	Aircraft model - Y04 table - acquired from CCARCS Not updateable by client
SERIAL NUMBER	Aircraft serial number - Y04 table - acquired from CCARCS Not updateable by client
TYPE CERTIFICATE	NAPA TATC code from Y62 table matching this aircraft manufacturer/model Not updateable by client
EMPTY WEIGHT LAST ACTUAL	optional - must be less than or equal to MAX take-off - pounds only
ON L/G	optional - values
DATE	date required if a new EMPTY LAST ACTUAL provided
EMPTY WEIGHT LAST AMENDED	optional - must be less than or equal to MAX take-off - pounds only
ON L/G	optional
DATE	date required if a new EMPTY WEIGHT LAST AMENDED provided
MAX TAKE OFF WEIGHT	acquired from CCARCS, updatable by CLIENT
ON L/G	optional
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

FIELD_ID	DESCRIPTION
204	AAIR - OWNER NOTES
28	AIRCRAFT BASED AIRPORT
25	AIRCRAFT BASED COUNTRY
27	AIRCRAFT BASED MUNICIPALITY
29	AIRCRAFT BASED OTHER LOCATION
26	AIRCRAFT BASED PROVINCE
16	AIRCRAFT DAMAGED DATE
17	AIRCRAFT ERTS DATE (expected return to service)
21	AIRCRAFT EXOS CODE (exempt/out of service reason)
1	AIRCRAFT ID (default for when no other Y05 records are created on submission)
189	AIRCRAFT MAX TO LANDING GEAR
19	AIRCRAFT REPAIRED DATE
22	AIRCRAFT TC REGION BASED
191	AIRCRAFT WEIGHT POUNDS
174	ANNUAL INSPECTION DATE
89	ENGINE1 MANUFACTURER
90	ENGINE1 MODEL ID
91	ENGINE1 SERIAL NO.
106	ENGINE2 MODEL ID
107	ENGINE2 SERIAL NO.
122	ENGINE3 MODEL ID
123	ENGINE3 SERIAL NO.
139	ENGINE4 SERIAL NO.
161	FLOAT MANUFACTURER
162	FLOAT MODEL ID
97	PROPELLER1 MANUFACTURER
98	PROPELLER1 MODEL ID
99	PROPELLER1 SERIAL NO.
114	PROPELLER2 MODEL ID
115	PROPELLER2 SERIAL NO.
130	PROPELLER3 MODEL ID
131	PROPELLER3 SERIAL NO.
146	PROPELLER4 MODEL ID
147	PROPELLER4 SERIAL NO.
153	SKI MANUFACTURER
154	SKI MODEL ID
183	WEIGHT EMPTY ACTUAL L/G (landing gear)
185	WEIGHT EMPTY ACTUAL POUNDS
184	WEIGHT EMPTY ACTUAL START DTE
186	WEIGHT EMPTY AMENDED L/G (landing gear)
188	WEIGHT EMPTY AMENDED POUNDS
187	WEIGHT EMPTY AMENDED START DTE

NOTE: MODIFY allows the submitter to go back into the AAIR and revise most data from the original submission with the exception of Flight hours and inspection dates