Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Next »

Main Articles

CAWIS-EDM CAWIS-EDMv2

Background

In 2016, the AAIR Electronic Distribution Module (EDM) replaced the old weekly, hardcopy-only distribution method (form #24-0059), allowing the Continuing Airworthiness Section to contact the majority of AAIR reporters by Email, rather than postal mailing.

SCHEDULE

The Hardcopy/postal distribution method was based on the anniversary of Certificate of Airworthiness date, for each individual aircraft. This created a large postage expense, and many aircraft were skipped in annual distributions due to ownership changes.

Currently, the EDM process is run 4 times annually , using the following schedule :

  1. First run - 1st week of January each year for operators having a 30-March due date (this covers 98% of all operators)

  2. Second run - 1st week of March for operators having a 30-May due date

  3. First Overdue run - 1st week of June for all operators that have not yet reported

  4. Second Overdue run - 1st week of September for all operatCuors that have not yet reported

EDM STEPS

  1. EMAIL - this step can take anywhere from 48 hours to 20 minutes in more recent runs (for about 25,000 emails ). The Exchange server is under shared services and may behave differently on each run. Also, this part of the process has been extremely sensitive to Exchange server changes or Outlook upgrades.

  2. FAX (this method is no longer used)

  3. FTP TO CSV FILE FOR HARD COPY PRINTING and MAILING

Special Note : The EDM should NOT be run on or near the end of any given month. If the email portion is not completed by 12:00am on the 1st of the next month, double emailing can occur.

EXCEPTIONS to Distribution

An EDM run gathers aircraft-owner-contact-info where the aircraft data meets the following criteria :

All currently registered aircraft having an AAIR due date (y02 table) that falls within 3 months of the EDM run date (Note: any given “run-date” can be input into the EDM routine, the default is current date )

It will reject the aircraft displaying the following conditions

  1. Ultralight aircraft (flight authority “H”,”I” on the Q01 table) Not required to report.

  2. Aircraft ALREADY having completed an AAIR for the current-reporting-year. (an M01 record already having a report-received-date for the current reporting year)

    1. Current-reporting-year is always Current-year - 1 (year calendar number on M01)

    2. Many operators submit their AAIR reports beginning on January 1st of each year, without being notified

    3. Out of service aircraft where the out-of-service period begins earlier than the reporting year have M01 records with recd dates auto-inserted and Zero flight hours auto-recorded (Q02).

3. Any aircraft that are members of a Fleet ( has a fleet number on Y02 table ) - These are dealt with through Fleet management ( AAIR CONSOLIDATED FLEET REPORTING )

4. Any aircraft that is marked SALE-REPORTED -or- INVALID-ADDRESS (sale-reported = “Y” and/or active-flag = “I” on the Y93 table) (Note: most “sale reported” aircraft have either been damaged beyond repair, or have been exported without notifying TC)

5. Any aircraft listed as having been built during the current year, cannot have flown last year (Y01 table)

6. Any aircraft listed as having been imported during the current year are exempted (y02 table) despite the possibility that it existed on the Canadian register last year, was exported, then re-imported during the current year

The EDM will then action the remaining aircraft and produce diagnostic messages (AA0003 table) for the following conditions :

  1. any operator with a preferred-notification-method (PNM) of MAIL (email address ignored due to user preference ) (y50 table) The preferred notification code dictates which clients specifically asked for hardcopy delivery of the AAIR form (PNM=3/mail) The FAX option PNM=2/fax is not permitted on Y50 since FAX EDM distribution is currently no longer used. PNM=1/email is the default (NOTE : preferred notification method has NO effect on the MDM portion of CAWIS)

  2. any operator where PNM=1/email but the client has no email (A92)

  3. any operator where PNM=1/email but the email bounced back - The email-failure data is uploaded as part of the FTP extract procedure for operators requesting hardcopy.

Success/fail data is available on the AAIRDATA-yyyy-mm-dd.xlsx report described here:

https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2195357866/Transport+Canada+Continuing+Airworthiness+Web+Information+System+CAWIS+Weekly+Annual+Airworthiness+Information+Report+AAIR+Data+Extract+Procedure

  • No labels