Page Comparison

...

The Public AAIR data view should look something like this :

SEE ATTACHMENT : FLIGHT-HOURS-VIEW.TXT

The CAWIS data elements currently available with BII are seen here:

ATTACHMENT : BII-CAWIS UNIVERSE LAYOUT.PDF

DATA DESCRIPTIONS

AIRCRAFT_ID	UNIQUE NUMERIC IDENTIFIER FOR THIS AIRCRAFT ON THE CANADIAN REGISTER ALLOCATED BY CCARCS (Canadian Civil Aircraft Register)
MARK	AIRCRAFT TAIL MARK DURING THIS REPORTING YEAR - BEGINS WITH 'F' OR 'G' ( 'I' is not included ultralights do not report flight hours ) An aircraft may change its tail mark many times over its lifetime
REPORTING_YEAR	REPORTING YEAR - 2010 THRU CURRENT YEAR - 1. THIS REPORT ONLY INCLUDES AIRCRAFT FOR WHICH A REQUEST TO REPORT WAS ISSUED BY TC FOR REPORTING OF THAT CALENDAR YEAR - THE CURRENT "REPORTING YEAR" IS ALWAYS = CURRENT YEAR - 1 . DATA FOR THE CURRENT REPORTING YEAR IS NOT CONSIDERED COMPLETE UNTIL 31-DECEMBER OF THE FOLLOWING YEAR (aka THE COLLECTION YEAR)
AIRCRAFT_ENTRY_DATE	ENTRY-DATE - INDICATES THE FIRST APPEARANCE OF THIS AIRCRAFT IN CAWIS (A DEFAULT DATE OF 1994 WAS USED FOR MUCH OF THE LEGACY DATA TAKEN FROM THE OLD MAINFRAME APP, CAIS)
ACTIVE_IND	ACTIVE INDICATOR - IS THIS AIRCRAFT ON THE CURRENT REGISTER ?
SR/IA	SALE REPORTED - OR - INVALID ADDRESS - THESE AIRCRAFT/OPERATORS ARE UNCONTACTABLE - THERE EXISTS AN INDICATION THAT AAIR WAS REQUESTED BUT NONE WAS RECEIVED. MANY SALE REPORTED AIRCRAFT HAVE BEEN DESTROYED, AND OWNERSHIP WAS TAKEN OVER BY INSURANCE COMPANIES, WHO DO NOT IDENTIFY THEMSELVES TO TC. MANY OTHER OF THESE AIRCRAFT APPEAR ON FOREIGN REGISTRIES.
YEAR_MFG	YEAR OF MANUFACTURE - NOTE - AN AIRCRAFT LISTED HAVING BEEN CONSTRUCTED DURING THE CURRENT YEAR WILL NOT BE ISSUED A REQUEST FOR FLIGHT HOURS
YEAR_IMPORT	YEAR OF IMPORT - NOTE - AN AIRCRAFT LISTED HAVING BEEN IMPORTED DURING THE CURRENT YEAR WILL NOT BE ISSUED A REQUEST FOR FLIGHT HOURS, DESPITE THE POSSIBLITY IT MAY HAVE BEEN ON THE REGISTER UNDER OTHER OWNERSHIP DURING THE PREVIOUS YEAR
FLIGHT_AUTHORITY	FLIGHT_AUTHORITY CODE DESCR ---- -------------------- A C-OF-A B RESTRICTED C OWNER MAINT D LIMITED E EXHIBITION F AMATEUR BUILT G EXPERIMENTAL H ULTRA-LIGHT - DOES NOT REPORT I ADV ULTRA-LIGHT - DOES NOT REPORT J SPECIFIC PURP K SPECIAL PURPOSE L NON-TYPE CERTIFIED
PURPOSE	AIRCRAFT_PURPOSE DURING THE GIVEN REPORTING YEAR CODE DESCR ----- -------------------- 1 PRIVATE 2 COMMERCIAL 3 STATE 4 UNKNOWN 9 MILITARY
OPERATING_RULE	PRIMARY OPERATING RULE DURING THE REPORTING YEAR (ONLY THE NUMERICALLY HIGHEST OP RULE IS SAVED TO THE DATABASE) CODE DESCR ---- -------------------- 406 FLIGHT TRAINING UNIT 604 PRIVATE-OP PASSENGER 701 FOREIGN AIR OPS 702 AERIAL WORK 703 AIR TAXI OPS 704 COMMUTER OPS 705 AIRLINE OPS 999 UNDEFINED
MAX_TAKEOFF_LBS	MAXIMUM TAKE OFF WEIGHT POUNDS
AIRCRAFT_MFG	AIRCRAFT MANUFACTURER
AIRCRAFT_MODEL	AIRCRAFT MODEL - AN 'X' SUFFIX INDICATES AN OWNER-MAINTAINED VERSION OF THIS TYPE OF MODEL
GROUP_ID	AIRCRAFT GROUP CODE FOR BII TOTALLING PURPOSES
SERIAL_NUMBER	AIRCRAFT SERIAL NUMBER
TATC_CD	TYPE_APPROVAL - OR - TYPE_CERTIFICATE NUMBER FOR THIS MANUFACTURER AND MODEL
TCH_COUNTRY	TYPE_CERTIFICATE_HOLDER COUNTRY (COUNTRY RESPONSIBLE FOR THIS MANUFACTURER) CODE COUNTRY ---------- -------------------- XX - AF AFGHANISTAN AL ALBANIA DZ ALGERIA S7 AMERICAN SAMOA AO ANGOLA AN ANGUILLA AG ANTIGUA AND BARBUDA AR ARGENTINA AM ARMENIA AA ARUBA AU AUSTRALIA AS AUSTRIA AZ AZERBAIJAN BS BAHAMAS BH BAHRAIN BD BANGLADESH BB BARBADOS BR BELARUS BE BELGIUM BL BELIZE BJ BENIN BM BERMUDA BT BHUTAN BO BOLIVIA B4 BOSNIA & HERZEGOVINA BW BOTSWANA BV BR VIRGIN ISLANDS BZ BRAZIL BN BRUNEI DARUSSALAM BG BULGARIA BF BURKINA FASO BU BURMA BI BURUNDI CB CAMBODIA CM CAMEROON CF CANADA CV CAPE VERDE KY CAYMAN ISLANDS C4 CENTRAL AFRICAN REP TD CHAD CL CHILE CN CHINA CO COLOMBIA C1 COMOROS CG CONGO C2 COOK ISLANDS C9 COSTA RICA CR CROATIA CU CUBA CY CYPRUS CK CZECH REPUBLIC DK DENMARK DJ DJIBOUTI D1 DOMINICA DO DOMINICAN REPUBLIC EU EASA EC ECUADOR EG EGYPT EL EL SALVADOR G4 EQUATORIAL GUINEA ER ERITREA ES ESTONIA ET ETHIOPIA FI FALKLAND ISLANDS FJ FIJI FD FINLAND FR FRANCE FA FRENCH ANTILLES PF FRENCH POLYNESIA GA GABON GM GAMBIA GG GEORGIA GY GERMANY GH GHANA GR GREECE GD GREENLAND G1 GRENADA GU GUATEMALA G3 GUINEA-BISSAU G2 GUINIE GN GUYANA HA HAITI HD HONDURAS HK HONG KONG HU HUNGARY IC ICELAND IN INDIA I2 INDONESIA I3 IRAN IQ IRAQ IR IRELAND IM ISLE OF MAN IL ISRAEL IT ITALY CI IVORY COAST JA JAMAICA JN JAPAN JO JORDAN KZ KAZAKHSTAN KE KENYA KI KIRIBATI KU KUWAIT KR KYRGYZSTAN LO LAOS PDR LA LATVIA LE LEBANON LS LESOTHO LB LIBERIA LI LIBYA L2 LICHTENSTEIN LT LITHUANIA LU LUXEMBOURG MC MACAO MA MACEDONIA MG MADAGASCAR MW MALAWI M1 MALAYSIA M2 MALDIVES M3 MALI M4 MALTA MI MARSHALL ISLANDS MT MAURITANIA M5 MAURITIUS MX MEXICO M6 MICRONESIA MO MOLDOVA MN MONACO ML MONGOLIA M7 MONSERRAT MR MOROCCO MZ MOZAMBIQUE MY MYANMAR NA NAMIBIA NU NAURU NE NEPAL ND NETHERLANDS NT NETHERLANDS ANTILLES NC NEW CALEDONIA NZ NEW ZEALAND NI NICARAGUA N1 NIGER NG NIGERIA N2 NIUE NK NORTH KOREA NR NORWAY OM OMAN PA PAKISTAN P1 PALAU PN PANAMA PP PAPUA NEW GUINEA PR PARAGUAY PE PERU PH PHILIPPINES PL POLAND PY POLYNESIA PT PORTUGAL QA QATAR YA REPUBLIC OF YEMEN RE REUNION RO ROMANIA RU RUSSIA RW RWANDA S6 SAINT KITTS S4 SAINT LUCIA S5 SAINT VINCENT S8 SAINT-PIERRE-ET-MIQU SO SAMOA S2 SAN MARINO ST SAO TOME SC SAO TOMI ET PRINCIPE SA SAUDI ARABIA SE SENEGAL YU SERBIA & MONTENEGRO SR SEYCHELLES S3 SIERRA LEONE SI SINGAPORE SK SLOVAKIA SV SLOVENIA S1 SOLOMON ISLANDS SM SOMALIA SF SOUTH AFRICA KO SOUTH KOREA SP SPAIN SL SRI LANKA SD SUDAN SU SURINAME SZ SWAZILAND SN SWEDEN SW SWITZERLAND SY SYRIA TW TAIWAN TJ TAJIKISTAN TZ TANZANIA TH THAILAND TG TOGO TO TONGA TR TRINIDAD AND TOBAGO TN TUNISIA TU TURKEY TK TURKMENISTAN TC TURKS AND CAICOS TV TUVALU UG UGANDA UK UK UN UKRAINE U1 UNI-AIR UA UNITED ARAB EMIRATES UR URUGUAY US USA UZ UZBEKISTAN VA VANUATU VE VENEZUELA VN VIETNAM WS WESTERN SAMOA YS YEMEN ZR ZAIRE ZA ZAMBIA ZI ZIMBABWE
OWNER_TYPE	1-INDIVIDUAL, 2-ORGANIZATION
OWNER	LAST OWNER OF THAT AIRCRAFT DURING THE REPORTING YEAR ( MANY MISSING VALUES ARE FROM CAIS/CAWIS CONVERSION AS HISTORICAL CCARCS OWNERSHIP DATA WAS NOT AVAILABLE , OWNER = UNKNOWN)
CLIENT_ID	OWNER CLIENT_ID AS ASSIGNED BY CCARCS
REGION	TC_REGION CODE DESCR ---- -------------------- 1 PACIFIC 3 PNR 4 ONTARIO 5 QUEBEC 6 ATLANTIC 7 NCR 9 OUTSIDE CANADA
TC_CENTRE	TC_FILE_LOCATION CODE DESCR REGN PROV ---- -------------------- ---- ---- 99 - 9 XX 00 -- 7 XX 51 ABBOTSFORD 1 BC 21 ALMA 5 QC 09 CALGARY 3 AB 25 DORVAL 5 QC 06 EDMONTON 3 AB 28 EDMONTON CTR 3 AB 53 GOOSE BAY 6 NF 50 HALIFAX 6 NS 18 HAMILTON 4 ON 05 KELOWNA 1 BC 14 KINGSTON 4 ON 15 LONDON 4 ON 27 MONCTON 6 NB 26 NCR 7 ON 16 OTTAWA 4 ON 17 PEARSON INT 4 ON 04 PRINCE GEORGE 1 BC 23 QUEBEC 5 QC 02 RICHMOND 1 BC 12 SASKATOON 3 SK 55 SEPT ISLES 5 QC 24 ST-HUBERT 5 QC 54 ST. JOHNS 6 NF 20 SUDBURY 4 ON 19 THUNDER BAY 4 ON 13 TORONTO 4 ON 22 VAL D`OR 5 QC 01 VANCOUVER 1 BC 03 VICTORIA 1 BC 10 WHITEHORSE 3 YT 11 WINNIPEG 3 MB 07 YELLOWKNIFE 3 YT
COUNTRY	aircraft based country (99.99% Canada) However it can be based in any country
PROVINCE	aircraft based province
BASED	primary aircraft base
MUNICIPALITY	aircraft based municipality
OTHER	aircraft other based locale
AIRPORT	aircraft based airport , A text field - initially provided by CCARCS on aircraft registry, updatable by CAWIS users and/or the aircraft owner
RECD_IND	WAS A REPORT RECEIVED FOR THIS REPORTING YEAR ? ( THERE IS 1 RECORD - M01 table - ON THIS REPORT FOR EVERY AIRCRAFT THAT WAS REQUIRED TO AAIR-REPORT DURING THIS REPORTING YEAR - RESPONSE RATES WOULD BE CALCULATED AS [(TOTAL RECORDS FOR YEAR - SRIA - CURRENT YEAR BUILT ) / #RECD=Y]
TIME_SINCE_NEW	TIME SINCE NEW FOR THAT REPORTING YEAR ( NOT NECESSARILY CUMULATIVE, ENTRY ERRORS WERE MADE FROM YEAR TO YEAR)
YEARLY_HOURS_FLOWN	TOTAL HOURS FLOWN BY THIS AIRCRAFT DURING THIS REPORTING YEAR
TRAINING_HOURS	TRAINING HOURS DURING THIS REPORTING YEAR
OTHER_HOURS	OTHER TYPE HOURS DURING THIS REPORTING YEAR

Page Comparison

Versions Compared

Old Version 14

New Version Current

Key

The Public AAIR data view should look something like this :

AIRCRAFT_ID

UNIQUE NUMERIC IDENTIFIER FOR THIS AIRCRAFT ON THE CANADIAN REGISTER ALLOCATED BY CCARCS (Canadian Civil Aircraft Register)

MARK

AIRCRAFT TAIL MARK DURING THIS REPORTING YEAR - BEGINS WITH 'F' OR 'G' ( 'I' is not included ultralights do not report flight hours ) An aircraft may change its tail mark many times over its lifetime

REPORTING_YEAR

AIRCRAFT_ENTRY_DATE

ENTRY-DATE - INDICATES THE FIRST APPEARANCE OF THIS AIRCRAFT IN CAWIS (A DEFAULT DATE OF 1994 WAS USED FOR MUCH OF THE LEGACY DATA TAKEN FROM THE OLD MAINFRAME APP, CAIS)

ACTIVE_IND

ACTIVE INDICATOR - IS THIS AIRCRAFT ON THE CURRENT REGISTER ?

SR/IA

YEAR_MFG

YEAR OF MANUFACTURE - NOTE - AN AIRCRAFT LISTED HAVING BEEN CONSTRUCTED DURING THE CURRENT YEAR WILL NOT BE ISSUED A REQUEST FOR FLIGHT HOURS

YEAR_IMPORT

YEAR OF IMPORT - NOTE - AN AIRCRAFT LISTED HAVING BEEN IMPORTED DURING THE CURRENT YEAR WILL NOT BE ISSUED A REQUEST FOR FLIGHT HOURS, DESPITE THE POSSIBLITY IT MAY HAVE BEEN ON THE REGISTER UNDER OTHER OWNERSHIP DURING THE PREVIOUS YEAR

FLIGHT_AUTHORITY

FLIGHT_AUTHORITY CODE DESCR ---- -------------------- A C-OF-A B RESTRICTED C OWNER MAINT D LIMITED E EXHIBITION F AMATEUR BUILT G EXPERIMENTAL H ULTRA-LIGHT - DOES NOT REPORTI ADV ULTRA-LIGHT - DOES NOT REPORTJ SPECIFIC PURP K SPECIAL PURPOSE L NON-TYPE CERTIFIED

PURPOSE

AIRCRAFT_PURPOSE DURING THE GIVEN REPORTING YEAR

CODE DESCR ----- -------------------- 1 PRIVATE 2 COMMERCIAL 3 STATE 4 UNKNOWN 9 MILITARY

OPERATING_RULE

PRIMARY OPERATING RULE DURING THE REPORTING YEAR (ONLY THE NUMERICALLY HIGHEST OP RULE IS SAVED TO THE DATABASE)

CODE DESCR ---- -------------------- 406 FLIGHT TRAINING UNIT 604 PRIVATE-OP PASSENGER 701 FOREIGN AIR OPS 702 AERIAL WORK 703 AIR TAXI OPS 704 COMMUTER OPS 705 AIRLINE OPS 999 UNDEFINED

MAX_TAKEOFF_LBS

MAXIMUM TAKE OFF WEIGHT POUNDS

AIRCRAFT_MFG

AIRCRAFT MANUFACTURER

AIRCRAFT_MODEL

AIRCRAFT MODEL - AN 'X' SUFFIX INDICATES AN OWNER-MAINTAINED VERSION OF THIS TYPE OF MODEL

GROUP_ID

AIRCRAFT GROUP CODE FOR BII TOTALLING PURPOSES

SERIAL_NUMBER

AIRCRAFT SERIAL NUMBER

TATC_CD

TYPE_APPROVAL - OR - TYPE_CERTIFICATE NUMBER FOR THIS MANUFACTURER AND MODEL

TCH_COUNTRY

TYPE_CERTIFICATE_HOLDER COUNTRY (COUNTRY RESPONSIBLE FOR THIS MANUFACTURER)

OWNER_TYPE

1-INDIVIDUAL, 2-ORGANIZATION

OWNER

LAST OWNER OF THAT AIRCRAFT DURING THE REPORTING YEAR ( MANY MISSING VALUES ARE FROM CAIS/CAWIS CONVERSION AS HISTORICAL CCARCS OWNERSHIP DATA WAS NOT AVAILABLE , OWNER = UNKNOWN)

CLIENT_ID

OWNER CLIENT_ID AS ASSIGNED BY CCARCS

REGION

TC_REGION

CODE DESCR ---- -------------------- 1 PACIFIC 3 PNR 4 ONTARIO 5 QUEBEC 6 ATLANTIC 7 NCR 9 OUTSIDE CANADA

TC_CENTRE

TC_FILE_LOCATION

COUNTRY

aircraft based country (99.99% Canada) However it can be based in any country

PROVINCE

aircraft based province

BASED

primary aircraft base

MUNICIPALITY

aircraft based municipality

OTHER

aircraft other based locale

AIRPORT

aircraft based airport , A text field - initially provided by CCARCS on aircraft registry, updatable by CAWIS users and/or the aircraft owner

RECD_IND

WAS A REPORT RECEIVED FOR THIS REPORTING YEAR ? ( THERE IS 1 RECORD - M01 table - ON THIS REPORT FOR EVERY AIRCRAFT THAT WAS REQUIRED TO AAIR-REPORT DURING THIS REPORTING YEAR - RESPONSE RATES WOULD BE CALCULATED AS

[(TOTAL RECORDS FOR YEAR - SRIA - CURRENT YEAR BUILT ) / #RECD=Y]

TIME_SINCE_NEW

TIME SINCE NEW FOR THAT REPORTING YEAR ( NOT NECESSARILY CUMULATIVE, ENTRY ERRORS WERE MADE FROM YEAR TO YEAR)

YEARLY_HOURS_FLOWN

TOTAL HOURS FLOWN BY THIS AIRCRAFT DURING THIS REPORTING YEAR

TRAINING_HOURS

TRAINING HOURS DURING THIS REPORTING YEAR

OTHER_HOURS

OTHER TYPE HOURS DURING THIS REPORTING YEAR

FLIGHT_AUTHORITY
CODE DESCR
---- --------------------
A C-OF-A
B RESTRICTED
C OWNER MAINT
D LIMITED
E EXHIBITION
F AMATEUR BUILT
G EXPERIMENTAL
H ULTRA-LIGHT - DOES NOT REPORT
I ADV ULTRA-LIGHT - DOES NOT REPORT
J SPECIFIC PURP
K SPECIAL PURPOSE
L NON-TYPE CERTIFIED

CODE DESCR
----- --------------------
1 PRIVATE
2 COMMERCIAL
3 STATE
4 UNKNOWN
9 MILITARY

CODE DESCR
---- --------------------
406 FLIGHT TRAINING UNIT
604 PRIVATE-OP PASSENGER
701 FOREIGN AIR OPS
702 AERIAL WORK
703 AIR TAXI OPS
704 COMMUTER OPS
705 AIRLINE OPS
999 UNDEFINED

TYPE_CERTIFICATE_HOLDER COUNTRY
(COUNTRY RESPONSIBLE FOR THIS MANUFACTURER)

LAST OWNER OF THAT AIRCRAFT DURING THE REPORTING YEAR
( MANY MISSING VALUES ARE FROM CAIS/CAWIS CONVERSION AS HISTORICAL CCARCS OWNERSHIP DATA WAS NOT AVAILABLE , OWNER = UNKNOWN)

CODE DESCR
---- --------------------
1 PACIFIC
3 PNR
4 ONTARIO
5 QUEBEC
6 ATLANTIC
7 NCR
9 OUTSIDE CANADA

WAS A REPORT RECEIVED FOR THIS REPORTING YEAR ?
( THERE IS 1 RECORD - M01 table - ON THIS REPORT FOR EVERY AIRCRAFT THAT WAS REQUIRED TO AAIR-REPORT DURING THIS REPORTING YEAR - RESPONSE RATES WOULD BE CALCULATED AS