Transport Canada Continuing Airworthiness Web Information System (CAWIS) Monthly Annual Airworthiness Information Report (AAIR) Data Extract Procedure

Owned by kurt.martin
Last updated: May 02, 2022
1 min read

Transport Canada

Continuing Airworthiness Web Information System (CAWIS)

Monthly Annual Airworthiness Information Report (AAIR)

Data Extract Procedure

Kurt Martin - 2021-08-03

 

PBI #112722 - produce monthly report
PBI #172651 - add this report to the CAWIS menu

 

######################

Overview 

 

A data extract provided to the Aircraft Certification publications section on or about the first business day of each month.

Step 1

go to

\\ncrfs345\GROUPS\AARD\AARD Public\CAWIS-REPORTS\AAIR-REPORTS\02-MONTHLY-REVISIONS

 Step 2

Take a copy of last month’s report , AAIR-202106-JUNE.xlsx, for example to your C:\ drive

Rename it to AAIR-202107-JULY.xlsx (note, we’re always extracting data for the previous month just ended)

Purge the data from the spreadsheet

Note : a sample copy of this report is provided in the attachment section

Step 3

Execute this code – SEE ATTACHMENT

Please note : this code will always extract Y05 log data for the PREVIOUS month, for the Current reporting year (where reporting-year = current-year -1)

 

Step 4 –

Export the data to a text file. Import that text file to the new spreadsheet, save a copy to the archive (where you got the original xlsx) and notify the requestor via DevOps

Note : it is perfectly normal that much less data appears in this report as the year progresses, as more operators have already reported

 

REQUIREMENTS FOR TASK

1 TOAD or SQL Developer installed on the submitter’s machine ( with connect strings to CAWIS PROD )

2 access to the the server location   \\ncrfs345\GROUPS\AARD\AARD Public\CAWIS-REPORTS