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 DALA1100789855Frame · damagedAFT CARGO COMPT BS 1108, L26L FRAME HAS A HOLE ON TOP SIDE. FABRICATED AND INSTALLED REPAIR STRAP IAW DC9-A-53-10-05-801-663A-A. REQUIRED INSP COMPLETED.SDR DALA1036199855Frame · damagedDURING M-CHECK, FOUND AFT CARGO COMPARTMENT BS 1136 AT L26L FRAME HAS A HOLE IN IT ON TOP SIDE. FABRICATED REPAIR STRAP LOCATED, DRILLED, DEBURRED, TREATED PRIMED & INSTALLED STRAP IAW DC9-53-13-3, 51-10-4, 51-10-3, 51-30-5 AND NWA SRP DC-9-A-53-10-05-801-663SDR DALA1035819855Frame · damagedDURING M-CHECK, FOUND AFT CARGO COMPARTMENT BS 1088 BETWEEN L30 & L29R FRAME HAS A HOLE ON TOP SIDE. FORMED REPAIR ANGLE DRILLED AND LOCATED, TRIMMED, TREATED, PRIMED & INSTALLED IAW SRM A53-10-05, 53-13-3, FIG 3, 51-30-2, 53-10-2, 51-30-5, 53-03, PG 4.SDR DALA1035799855Frame · damagedDURING M-CHECK FOUND AFT CARGO COMPT STA 1108, L29L FRAME HAS A HOLE ON TOP SIDE. RECEIVED MATERIAL FOR REPAIR IAW SRM DC-9-A-53-10-06-663A-A. LOCATED, DRILLED STRAP IAW SRM 51-10-2, 51-10-4. INSTALLED STRAP IAW SRM 51-30-5.SDR DALA1052650909Frame · corrodedAFT CARGO COMPT STA 1307 BETWEEN LONGERON 24R AND 24L, FRAME CORRODED BEYOND LIMITS. REPAIRED FRAME SECTION IAW SRM 57-10-2, 53-03D, FIG 2A AND 51-10-2.SDR USAA2010121493045Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK, CRACKED FRAME AT BS 500E, S20L - S21L. REPAIRED FRAME AT BS 500E, S20L - S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR FDEA201011204438Frame · puncturedFRAME UPPER FLANGE PUNCTURED - BS 1110 ABOVE STR 27R, BENEATH CARGO NET STANCHION FITTING. CUT OUT DAMAGED AREA DIM 3 7/8" X 1 3/4" IAW SRM 51-40-3 FIG 1. FABRICATED REPAIR USING 7075-0, .063", DIM. 14" X 5 3/4", LOCATED AND DRILLED PART IAW SRM 51-40-3 FIG 1,SDR FDEA201011204437Frame · puncturedFRAME UPPER FLANGE PUNCTURED - STA 1130 ABOVE STR 27L, BENEATH CARGO NET STANCHION FITTING. CUT OUT DAMAGED AREA DIMENSION 5 5/8" X 1" IAW SRM 51-40-3 FIG 1. FABRICATED FRAME REPAIR USING 7075-0, .063", DIMENSION 14 3/4" X 5 5/8" IAW SRM 51-40-3 FIG 1 AND 53-SDR FDEA201011204439Frame · dentedFWD PIT FRAME REPAIR DOUBLER IS DENTED AT BS 600, BETWEEN STR 25-26L. REMOVED FRAME REPAIR DOUBLER AT BS600 BETWEEN STRINGER 25L AND 26L IAW SRM, REV 103, 51-30-2. FABRICATED FRAME REPAIR USING 7075-0, .063" X 6.6" X 4.0" IAW DRAWING NR 69-43674. INSTALLED DSDR AALA20101120TUL03Frame · crackedFORWARD SIDE OF FRAME 1418 IS CRACKED NEXT TO RADIUS BLOCK AT LONGERON 2 RIGHT. INSTALLED DOUBLER PER SRM 53-03-00 FIGURE 31A.SDR AALA20101120TUL02Frame · crackedAFT SIDE OF FRAME 1418 IS CRACKED NEXT TO RADIUS BLOCK AT LONGERON 2 RIGHT. INSTALLED DOUBLER PER SRM 53-03-00 FIGURE 31A.SDR DALA1101310659Frame · damagedFWD E/E FRAME DENTED/GOUGED AT UPPER RADIUS FROM CONTACT WITH DOOR LOCK PIN STA 231.25 BL0. ACCOMPLISHED ERA 487265-14, REV ORIG AT SAA ON N/R CARD 171956.SDR FDEA201011194436Frame · damagedFRAME UPPER FLANGE PUNCTURED - STA 1090 ABOVE STR 27R, BENEATH CARGO NET STANCHION FITTING CUT OUT DAMAGED AREA DIM. 3 3/8" X 1 1/4" IAW SRM 51-40-3 FIG 1. FABRICATED REPAIR DOUBLER USING 7075-0, .090". LOCATED AND DRILLED REPAIR, DIMENSION 12" X 4 1/2", FISDR ASOA201001819Frame · corrodedCORROSION FOUND AT FS 364.00 AND LBL2. REMOVED CORRORSION. REPAIRED AREA FOUND TO BE WITHIN LIMITS IAW SRM 53-21-23-101-003-A01 AND 51-12-00-001-001-A01. PERFORMED LIQUID PENRTRANT INSP TYPE I, METHOD C REPAIR AREA FS 364.00 AT LBL 2 IAW SRM 51-12-00-001-0SDR ASOA201001818Frame · corrodedCORROSION FOUND ON FRAME FS 319.70 AT STR 27. REMOVED CORROSION. REPAIRED AREA FOUND TO BE WITHIN LIMITS IAW SRM 53-21-06-101-002-A01 AND 51-12-00-001-001-A01. PERFORMED FLUORESCENT LIQUID PENETRANT INSP ON REPAIR AREA FS 319.70 AT STR27 IAW SRM 51-12-00-00SDR QXEA2010112200790Frame · corrodedC2 CHECK - INTERIOR FUSELAGE FRAME LOWER FLANGE AT STA X281.000 HAS CORROSION BETWEEN STR 31S AND 32S. REMOVED RIVETS COMMON TO EXTERNAL SKIN FOR ACCESS IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW RD 8/4-53-2344. MEASURED AFFECTED AREA MIN THICKNESS REMAISDR CALA2010111900588Beltframe · crackedSUPPORT TASK - BELFRAME STA 827 HAS CRACK AT FASTENER HOLE BETWEEN STRINGERS S8L AND S9L AT THE A/C OUTLET EXTRUSION SUPPORT BRACKET ATTACHMENT AREA. REPAIRED FRAME-REF-EC/RA 5311-01512,DIP PER EA-5310-04498 STEP 35 TO PERFORM A ONE TIME INSPECTION.SDR ASOA201001806Frame · corrodedFRAME FLANGE HAS CORROSION FS 295, STR 27. REPAIR AREA FOUND TO BE WITHIN LIMITS IAW SRM 53-21-06-101-002-A01 AND 51-12-00-001-001-A01. (LT) 2 NDT REQUIRED INSTALL RIVETS AND RESTORE FINISH. PERFORMED FLUORESCENT LIQUID PENETRANT INSP ON FRAME FLANGE FS 295SDR ASOA201001805Frame · corrodedFRAME FLANGE HAS CORROSION FS 310, STR 27. REPAIRED AREA FOUND TO BE WITHIN LIMITS IAW SRM 53-21-06-101-002-A01 AND 51-12-00-001-001-A01. PERFORMED FLUORESCENT LIQUID PENETRANT INSP ON FRAME FLANGE FS 310.00, STR 27 IAW SRM 51-12-00-001-001-A01 AND MAC NDT INSDR DALA1032869853Former · crackedDURING M-CHECK FOUND MAIN PASSENGER CABIN APB NR4 FORMER FROM FLOOR LEVEL RT SIDE OTBD END IS CRACKED. REMOVED EXISTING END CLIP, TRIMMED OUT CRACKED 1" X 2" NDT TO VERIFY, CRACK CONTAINED, RECEIVED 2EA CLIPS PN 09-5300-3-0914, PO1031968, PN9915558-234N, PO10SDR USAA2010120992956Frame · crackedMCN - C20 - MAJOR REPAIR - CRACK IN FRAME RE-INFORCEMENT FITTING AT R1 DOOR AFT LOWER CORNER AT BS 328 BETWEEN S16R TO S17R. REPLACED FRAME RE-INFORCEMENT FITTING AT R1 DOOR AFT LOWER CORNER AT BS 328 BETWEEN S16R TO S17R IAW B737 SRM 51-40-02 & BOEING DRAWINSDR QXEA2010111800785Frame · corrodedC2 CHECK - INTERNAL FUSELAGE FRAME AT STA X28.00 BETWEEN STR 24P AND 25P HAS CORROSION. CLEANED AND REMOVED SURFACE CORROSION IAW SRM 51-21-00. MEASURED AFFECTED AREA MIN THICKNESS REMAINING .046" REF NTM 51-00-02-250-801. FOUND TO BE WITHIN LIMITS IAW RD 8SDR QXEA2010111800784Frame · corrodedC2 CHECK - INTERNAL FUSELAGE FRAME AT STA X6.00 BETWEEN STR 24P AND 25P HAS CORROSION. CLEANED AND REMOVED SURFACE CORROSION IAW SRM 51-21-00. MEASURED AFFECTED AREA, MIN THICKNESS REMAINING .048" REF NTM 51-00-02-250-801. CONFIRMED CRACK FREE CONDITION OF SDR C2XA10SH397Frame · bentSHV - DURING C-CHECK FRAME 21 BENT BETWEEN STRINGER 21L & 21R. MAINTENANCE PERFORMED REPAIR OF FRAME 21 BETWEEN STRINGER 21L & 21R IAW ETD 2010-145/10420. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA10SH395Frame · crackedSHV - DURING C-CHECK FRAME 10 CRACKED DIRECTLY UNDER DV WINDOW FRAME LT. MAINTENANCE REMOVED AND REPLACED FRAME 10 SECTION UNDER DV WINDOW LT IAW EMB-145 SRM 51-40-02 AND 51-20-01. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA10SH394Frame · crackedSHV - DURING C-CHECK FRAME 10 CRACKED DIRECTLY UNDER DV WINDOW FRAME RT. MAINTENANCE REMOVED AND REPLACED FRAME 10 SECTION UNDER DV WINDOW IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA20101116TUL02Frame · crackedSTATION 1418 FRAME CRACKED BETWEEN LONGERON 2 RIGHT AND LEFT. ACCOMPLISHED SPLICE REPAIR PER EA MD80-53-011681.SDR AALA20101116TUL01Frame · corrodedCORROSION AFT SIDE FRAME STATION 1250 LONGERON 29 LEFT TO 29 RIGHT. INSTALLED FRAME SPLICE PER EA MD80-53-014022.SDR USAA2010120992955Frame · crackedMCN - C20 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 360 BETWEEN S13R TO S14R. REPAIRED FUSELAGE FRAME AT BS 360 BETWEEN S13R TO S14R IAW TYPICAL REPAIR 53-10-21.SDR AALA20101116TUL11Frame · crackedFRAME 1418 CRACKED ON AFT SIDE AT LONGERON 2 LEFT. STOP-DRILLED CRACK INSTALLED DOUBLER REPAIR PER SRM 53-10-00-15.SDR SWAA107089Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA107088Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA107087Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA107078Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM.SDR SWAA107077Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM.SDR KCSA101179Frame · corrodedSTA 580 LBL 114 FRAME UPPER CHORD HAS CORROSION.SDR FOTR2019813271Frame Splice · chafedBS 1166 BETWEEN STRINGER 5 & 6 R GILLINER SUPPORT IS CHAFING AGAINST FRAME SPLICE. REMOVED FRAME SPLICE IAW SRM 51-30-2. FABRICATED FRAME SPLICE APPROX. DIM 8.3750" X 4.3750" IAW SRM 53-10-2, FIG 5 AND SRM 51-20-1, FIG 7. INSTALLED FRAME SPLICE AT BS 1166 BESDR FOTR20198913427Frame · damagedSTA 720E FRAME HAS FASTENERS W/ NO ED IN RT SIDE WINDOW AREA. CUTOUT DAMAGED AREA DIM. 1" X 3/4" IAW SRM 53-10-4, FIG 1. FAB. FRAME REPAIR 2EA PARTS MAT. USED 7075-0 .071" PO 90016396 DIM 13.5" X 3" & 13.5 X 4" IAW SRM 53-10-4, FIG 1 HEAT TREATED PARTS FROM 7SDR FOTR/20198/13440Frame · damagedSTA 720, FRAME HAS FASTENER W/NO ED IN WINDOW AREA ON LT SIDE. CUTOUT DAMAGE AREA DIM. 1" X .7500", FABRICATED FRAME REPAIR 2EA PARTS, MATERIAL USED 7075-0. PO 90016396, DIM 13" X 3" & 13" X 4" IAW. SRM 53-10-4. HEAT TREATED PART FROM 7075-0 TO 7075-T6. IAWSDR COMA2010111850233Frame · corrodedFRAME AT FS 333.00 CORRODED BETWEEN STRINGERS 26L AND 26R. REMOVED AND REPLACED CORRODED FRAME SECTION FROM FACTORY SPLICE AT STRINGER 23L TO FACTORY SPLICE AT STRINGER 23R, IAW SRM 51-42-06 AND 51-42-21.SDR DALA1032759855Fastener · shearedDURING M-CHECK FOUND MAIN CABIN STA 1060 2 EA FASTENERS SHEARED ON FRAME SPLICE CAP AT L16R. REMOVED AND REPLACED 2 EA FASTENERS IN MAIN CABIN STA 1060 ON FRAME SPLICE CAP AT L16R IAW DC-9 SRM 51-30-2.SDR FDEA201011154378Frame · crackedMCD UPPER LOBE- FRAME AT STA 1520, S3L CRACKED. REMOVED DAMAGED AREA IAW SRM 51-10-02. FABRICATED NEW FRAME SECTION ON TRAV T10/854913, CHANNEL NR1 (2EA) TRAV T10/854912 & CHANNEL NR2 (2EA) TRAV T10/854911. LOC & DRILLED IAW SRM 53-00-07. TREATED & PRIMED SDR SWAA107042Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME PER SRM.SDR SWAA107010Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 26L. REPAIRED FRAME PER SRM.SDR SWAA106989Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 332, BETWEEN STR 5R TO STR 19R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA106985Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM AND BAC DWG.SDR CALA2010111500541Frame · crackedMAIN FRAME CRACKED AT STA 616 JUST BELOW FLOOR DECK LT SIDE. COMPLETED REPAIR OF STA 616 FRAME REF EC/RA 5311-01158.SDR CALA2010111500540Frame · crackedMAIN FRAME CRACKED STA 616 RT JUST BELOW MAIN DECK FLOOR. COMPLETED REPAIR FRAME STA 616R REF EC/RA 5311-01158.SDR EOPA111410358ALFrame · crackedFRAME FOUND TO HAVE 1.5 INCH CRACK.SDR FDEA201011144361Frame · dentedFWD CARGO COMPT LT FRAME AT STA 780, S24L-25L FOUND DENTED. FWD CARGO COMPT DENTED LT FRAME REPAIRED IAW EA F-5310-142359, PART 1. REPAIR IS CLASSIFIED AS MAJOR.
Back to JASC 5311