-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathFilelayout.txt
89 lines (88 loc) · 26.6 KB
/
Filelayout.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
columnname columntype length description
------------------------------ ------------- ------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
c5 Char 13 Date and Sequence number
c10 VarChar 8 Date on which the report was received
c12 Char 5 Unique sequential number assigned on date report received
c14 Char 4 Region Code
c15 Char 4 Year
c16 Char 2 Month
c17 Char 2 Day
c18 Char 17 Operator Control Number
c20 Char 1 Segment Code 1 = aircraft, 2 = engine, 3 = propeller, 4 = component
c25 VarChar 8 Date of occurrence
c35 Char 1 A = Air Carrier G = General Aviation
c40 Char 4 Air Transport Association (ATA) code
c90 Char 16 Manufacturer's part number
c100 Char 16 Descriptive name of part
c110 Char 12 Component manufacturer's name
c120 Char 12 Component manufacturer's model designation
c130 Char 6 Aircraft manufacturer's name
c140 Char 6 FAA assigned code to identify aircraft group
c150 Char 12 Aircraft manufacturer's model number
c152 Char 7 Aircraft make and model sequence number
c160 Char 4 Region responsible for aircraft
c170 Char 6 Engine manufacturer's name
c180 Char 6 FAA assigned code to identify engine group
c190 Char 12 Engine manufacturer's model number
c192 Char 5 Engine make and model sequence number
c200 Char 4 Region responsible for engine certification
c210 Char 6 Propeller manufacturer's name
c220 Char 6 FAA assigned code to identify propeller group
c230 Char 12 Propeller manufacturer's model number
c240 Char 4 Region responsible for propeller certification
c250 Char 16 Location on sircraft of the defective or malfunctioning part
c260 Char 16 Text reflecting condition of failed part
c270 Char 1 Submitter code
c280 Char 1 Report submitted
c290 Char 1 Alert code
c300 Char 4 Air carrier operator code
c310a Char 1 1st occurrence - Precautionary Procedures Code (For use in report printout)
c310b Char 1 2nd occurrence - Precautionary Procedures Code (For use in report printout)
c310c Char 1 3rd occurrence - Precautionary Procedures Code (For use in report printout)
c310d Char 1 4th occurrence - Precautionary Procedures Code (For use in report printout)
c314a Char 24 1st occurrence - Precautionary Procedures Text (For use in report printout)
c314b Char 24 2nd occurrence - Precautionary Procedures Text (For use in report printout)
c314c Char 24 3rd occurrence - Precautionary Procedures Text (For use in report printout)
c314d Char 24 4th occurrence - Precautionary Procedures Text (For use in report printout)
c320a Char 1 1st occurrence - Nature condition code (For use in report printout)
c320b Char 1 2nd occurrence - Nature condition code (For use in report printout)
c320c Char 1 3rd occurrence - Nature condition code (For use in report printout)
c324a Char 26 1st occurrence - Nature condition text (For use in report printout)
c324b Char 26 2nd occurence - Nature condition text (For use in report printout)
c324c Char 26 3rd occurrence - Nature condition text (For use in report printout)
c330 Char 2 Stage of operation code
c332 Char 15 Stage of operation text
c340 Char 1 Report status
c350 Char 2 Microfilm roll number of original report
c360 Char 4 Microfilm frame number of original report
c370 Char 2 Region receiving report
c380 Char 2 District office receiving report
c390 Char 5 Aircraft registration or tail number
c400 VarChar 5 Total time accumulated on part regardless of overhaul
c410 VarChar 5 Total time accumulated on part since overhaul
c420 Char 1 Severity factor, the higher the number the greater the impact on continued flight safety
c430 Char 12 Manufacturer's serial number of component
c440 Char 12 Manufacturer's serial number of aircraft
c450 Char 12 Manufacturer's serial number of engine
c460 Char 12 Manufacturer's serial number of propeller
c490 Char 4 1st Code - Up to 2 three digit ATA codes. May be left blank
c510a VarChar 120 1st line of remarks (For use in report printout)
c510b VarChar 120 2nd line of remarks (For use in report printout)
c510c VarChar 120 3rd line of remarks (For use in report printout)
c510d VarChar 120 4th line of remarks (For use in report printout)
c510e VarChar 120 5th line of remarks (For use in report printout)
c510f VarChar 120 6th line of remarks (For use in report printout)
c602 Char 1 Aircraft weight class code
c604 Char 1 Aircraft wing type code
c606 Char 1 Aircraft power class code
c608 VarChar 2 Number of engines
c610 Char 2 Design characteristic code for typical engine f9or aircraft model
c612 Char 1 Engine power class code
c614 Char 1 Engine type code
c616 Char 2 Landing gear code
c620 Char 8 FAA type certificate control number for aircraft
c640 Char 8 FAA tyoe certificate control number for engine
c652 Char 1 Propeller power code
c654 Char 1 Propeller type code
c660 Char 8 FAA type certificate control number for propeller
eof VarChar 1 NULL