Page Comparison

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) 

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 ?

SRIA

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

OWNER_TYPE

1-INDIVIDUAL, 2-ORGANIZATION

OWNER

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

CLIENT_ID

OWNER CLIENT_ID AS ASSIGN 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  

RECD_IND

WAS A REPORT RECEIVED FOR THIS REPORTING YEAR ?  ( THERE IS 1 RECORD ON THIS TABLE FOR EVERY AIRCRAFT THAT WAS REQUIRED TO 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