JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '5311' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '5311' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR 05FDEA03691Frame · damagedEXISTING FRAME REPAIR IN FWD CARGO BAY AT BS680, S28R RBL 6, WL 154 (6" X 3"). REPAIR REQUIRES EVALUATION FOR MAJOR/MINOR DETERMINATION AND IF THE REPAIR WAS ACCOMPLISHED USING FAA APPROVED DATA. REMOVED EXISTING FRAME REPAIR AT BS 680 RBL 6 AND FABRICATSDR CALA0500388Frame · crackedINSPECTION FOUND A .5 INCH CRACK JUST BELOW UPPER HINGE, LOWER GUIDE PLATE AREA IN R-1 DOOR FUSELAGE CUTOUT FRAME, STA 294.5, S11 R TO S14R. THE DOOR FUSELAGE CUTOUT FRAME WAS REMOVED AND REPLACED IAW SRM 51-10-02 AND 51-40-02.SDR SWAA053511Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD SIDE CHORDS CRACKED AT WL 207. REMOVED AND REPLACED SIDE CHORDS PER SWA ACO.SDR ASAA0540605Frame · corrodedPAE - FOUND CORROSION AT APU COMPARTMENT LOWER CHORD FOR AIR INLET IS CORRODED AT BS 1118 TO 1125, RBL 20. REMOVED AND REPLACED PER B737-400 SRM 51-40-02 AND DWG 65-46579. (M)SDR ASAA0540604Frame · corrodedPAE - FOUND CORROSION AT APU COMPARTMENT UPPER CHORD FOR AIR INLET IS CORRODED AT BS 1122, RBL 11, WL 214. REMOVED AND REPLACED PER B737-400 SRM 51-40-02 AND DWG 656-46579. (M)SDR 05FDEA03641Frame · crackedFOUND CRACK IN STUB FRAME UPPER FLANGE IN FWD CARGO BAY BILGE AT BS 613, STR 26R. REPLACED STUB FRAME AT BS 613 STR 26R PER SRM 51-30-2.SDR SWAA053490Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 2R. REPAIRED FRAME PER SRM.SDR SWAA053489Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA053488Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA053487Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA053509Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SRM.SDR USAA051334Frame · crackedBETWEEN STRINGERS S-8R AND S-9R STA 480. CUT OUT DAMAGE, INSTALL FRAME DOUBLERS IAW TR 53-10-20. DEFECT SIZE: .5 INCH.SDR 05FDEA03614Frame · damagedFUSELAGE, MAIN FRAME FORWARD CARGO DOOR FORWARD FRAME REPLACEMENT AD'S 90-06-09 AND 98-11-03 R1 (LOG BOOK ENTRY REQUIRED). REPAIRED PER E.A. 7-5310-93709SDR SWAA053473Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, LOWER FRAME NR 5 DOOR STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA053466Frame · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BLKHD OTBD LOWER CHORD CORRODED AT BS 727, RBL 4.375. REPAIRED CHORD PER SWA EA AND SRM.SDR SWAA053465Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER SWA EA.SDR SWAA053458Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 947.5, BETWEEN STR 10R TO STR 13R. REPAIRED FRAME PER SRM.SDR SWAA053457Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME TO SKIN ATTACH ANGLE CRACKED AT BS 328, LBL 45, WL 206. REPAIRED ATTACH ANGLE PER SRM.SDR ASAA0540616Frame · damagedOKC - FOUND BS 277 FRAME WEB DAMAGED AT BS 17-18 LEFT DOUBLER REPAIR. REMOVED DAMAGED SECTION OF WEB, FABRICATED AND INSTALLED REPAIR ANGLE IAW ASA EA 5310-02511. (M)SDR ASAA0540595Frame · chafedPAE - FOUND AFT CARGO DOOR LOWER FORWARD SIDE FRAME HAS MULTIPLE NICKS AND CHAFING FROM LOWER STOP CUTOUT TO LOWER EDGE OF DOOR. REMOVED AND REPLACED FRAME SECTION PER B737-400 SRM 51-40-02. (M)SDR DHL2005749015Frame · dentedFRAME AT STA 970 ABOVE STR 26 LT IS DENTED M/R. CUT OUT DAMAGED AREA 7/8" BY 2 3/4" AND FABBED REPAIR ANGLE FROM 7075 T6 .063 PO 9002351 DIM 4" BY 10 7/8" IAW B727 SRM 51-40-3 FIG 1 AND 53-10-2. TREATED AND PRIMED IAW B727 SRM 51-10-20. INSTALLED REPAIR ANGSDR SIMA200531511Doubler · corrodedFOUND DOUBLER AT FRAME 22 ON RIGHT HAT BEAM CORRODED. INSTALLED NEW DOUBLER IAW SRM 51-40-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SWAA053451Beltframe · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 500B, ABOVE RT GENERATOR FEEDER CABLES ACCESS HOLE. REPAIRED BELTFRAME PER SWA EA.SDR SWAA053440Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 360 TO BS 380, WL 208. REPAIRED CREASE BEAM PER SRM.SDR DHL2005749013Frame · dentedFRAME DENTED BETWEEN STR 23-25L AT BS 680. CUT OUT DAMAGED AREA 1 1/2 INCHES BY 1 INCH, 1 1/4 INCHES BY 1 INCH. FAB REPAIR ANGLE MST IB 7075T6 /063 PO 9002351 22 1/4 INCHES BY 3 7/8 INCHES IAW B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1. TREATED AND PRIMED IAWSDR DHL2005749012Frame · dentedFOUND DENT ON FRAME AT BS 500 ABOVE STR 24R. CUT OUT DAMAGED AREA 4 1/8" BY 1 1/8" FROM FRAME ON BS 500 ABOVE STR 24R IAW B727 SRM 51-40-3 FIG 1. FAB REPAIR DOUBLER 12" BY 2 1/8" OF 7075 T6 .063 PO 9002351 IAW B727 SRM 51-10-2 FIG 3 AND 51-40-3 FIG 1. TREATSDR SWAA053429Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 259.5, BETWEEN RBL 11 TO LBL 11, WL 208. REPAIRED FRAME PER BFG ER.SDR ASOA05986Doubler · corrodedDURING A C-CHECK IN YUL, THE RIGHT SIDE DOUBLER, ON FRAME 39, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT SIDE DOUBLER, ON FRAME 39, IAW ASA EO 72-53-0194. (M)SDR QXEA200501650Frame · gougedYYC- DURING C3 CHECK, FUSELAGE INTERIOR UPPER FRAME AT STATION 939 STRINGER 3L HAS A GOUGE ON THE ATTACH ANGLE FOR INTERCOSTAL IN RADIUS. MAINTENANCE REPAIRED IAW CRJ-700 SRM 53-51-06-101-001-A01.SDR QXEA200501649Frame · gougedYYC- DURING C3 CHECK, FUSELAGE INTERIOR UPPER FRAME AT STATION 939 STRINGER 3R HAS A GOUGE ON THE AFT SIDE. MAINTENANCE REPAIRED FRAME IAW CRJ-700 SRM 53-51-06-101-001-A01. NO CRACKS FOUND.SDR ABXA050279Frame · corrodedFOUND FRAME EXFOLIATED AT FS 1041 AT LONGERON 29 LEFT. SPLICED IN NEW FRAME IAW DC-9 SRM.SDR USAA051266Frame · crackedFOUND FRAME CRACKED, STA 480 S-9L ON FRAME AT PSU RAIL. CUT OUT DAMAGE. INSTALL REPAIR DOUBLERS IAW TR 53-10-20, DEFECT SIZE: .25".SDR 05FDEA03593Frame · corrodedAFT CARGO COMPARTMENT FRAME HAS CORROSION STA 1030 RBL 18 IN. REMOVED CORROSION FROM SURFACE IAW SRM 51-10-6. ID MAT BEFORE 0.063 AFTER 0.060 FOUND TO BE WITHIN LIMITS IAW SRM 53-10-10 FIG 1. TREATED AND PRIMED SRM 51-10-2.SDR USAA051273Frame · corrodedFOUND FRAME CORRODED AT STATION 867 BETWEEN S27L AND S27R. REMOVED MINOR CORROSION AND THREE FASTENERS IN THE AREA. INSTALLED NEW FASTNERS IAW SRM 53-00-07, DEFECT SIZE: .4" BY .2".SDR USAA051276Frame · crackedFOUND FRAME CRACKED BETWEEN STRINGERS S-8R AND S-9R STA 480. CUT OUT DAMAGE, INSTALL FRAME DOUBLERS P/N 1133533 AND 1133534 PER TR 53-10-20, DEFECT SIZE: .5".SDR SWAA053408Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 490, FWD CARGO DOOR CUTOUT. REPAIRED FRAME PER BFG ER.SDR SWAA053407Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 440, FWD CARGO DOOR CUTOUT. REPAIRED FRAME PER BFG ER.SDR SWAA053404Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER SRM.SDR ASAA0540579Frame · corrodedPAE - FOUND CORROSION ON FRAME. REMOVED DAMAGED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR PARTS PER B737-400 SRM 53-00-07. (M)SDR ASOA05989Frame · corrodedDURING A C-CHECK IN YUL, FRAME FRAME 23A, AT STRINGER 21R AND STRINGER 21L, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED THE CORROSION ON FRAME FS 23A, AT STRINGER 21R AND STRINGER 21, IAW SRM 51-21-42. REPAIRED FRAME FS 23A, AT STRINGER 21R ASDR 05FDEA03577Frame · corrodedIN THE FWD CARGO COMPT SUMP AREA AT STA 919 FOUND SEVERE CORROSION WITH EXFOLIATION ON THE FRAME'S CAP BETWEEN L 51 LH TO L 50 RH. TRIMMED OUT FRAME CAP CORRODED REMOVED REMAINING CORROSION IAW SRM 51-21-01 PAR 34 VOL2 ORIGINAL MATERIAL THK IS .071 INCHES SDR 05FDEA03576Frame · corrodedLT MLG WHEEL WELL FOUND SEVERE CORROSION ON FRAME AND ANGLE AT STA Y1505 X62. REMOVED CORROSION IAW SRM 51-21-01 PAR 34 VOL 2 ORIGINAL THK OF FRAME IS .090''. MATERIAL REMOVED IS .045',' REMAIN MATERIAL THK .045''. MATERIAL REMOVED 50 PERCENT IS OUT LIMIT SDR AWXA200501410Frame · crackedMCN - DURING C13 CHECK DISCOVERED CHORD CRACKED, 2.7 INCHES, AT BS 188, WL 208 AND BL 31L. MAINTENANCE CUT OUT DAMAGED SECTION OF CHORD AT BS 188 IAW AMERICA WEST AIRLINES ENGINEERING REPAIR NR 03-5300-05314-ES3. FABRICATED REPAIR ANGLE AND FILLERS IAW AWA ESDR AWXA200501407Frame · crackedMCN - DURING C13 CHECK DISCOVERED CHORD CRACKED, .3 INCHES, AT BS 616, WL 207 AND BL 60L. MAINTENANCE CUT OUT DAMAGED SECTION OF CHORD AT BS 616 IAW AMERICA WEST AIRLINES ENGINEERING REPAIR NR 03-5311-01143-DD1. FABRICATED STIFFENING ANGLE AND FILLER IAW AWASDR ABXA050274Frame · crackedFOUND CRACK ON FRAME AT FASTENER FS 1152 AT LONGERON 15 RIGHT. REPAIRED AREA IAW DC-9 SRM 53-03.SDR 05FDEA03553Failsafe · crackedBS 1010 FRAME IS CRACKED AT STRINGER 25 LEFT. REPAIRED PER SRM 51-40-3SDR 05FDEA03552Failsafe · crackedBS 990 FRAME IS CRACKED AT STRINGER 25 RIGHT. REPAIRED PER SRM 51-40-3SDR 05FDEA03551Failsafe · crackedN01348 BS 990 FRAME IS CRACKED TWO PLACES AT STRINGER 25 LT. REPAIRED PER SRM 51-40-3SDR SWAA053381Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND LT CREASE BEAM CORRODED BETWEEN BS 294.5 TO BS 360, WL 208. REPAIRED CREASE BEAM IAW SRM.SDR SWAA053379Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 304, STR 16L. REPAIRED FRAME IAW MFG ER.
Back to JASC 5311