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 SWAA118686Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT STR CUTOUT BS 947.5, STR 19L. REMOVED AND REPLACED FRAME PER SRM.SDR ASOA201102362Frame · corrodedFRAME AT FS 349 CORRODED BETWEEN S24L TO 24R. DRILLED UP NEW FRAME IAW SRM 51-40-11. REMOVED AND REPLACED FRAME IAW SRM 51-42-06.SDR SWAA118485Frame · crackedDURING SCHEDULED 16Y CHECK FOUND, FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SRM.SDR SWAA118445Frame · crackedDURING SCHEDULED 24Y CHECK FOUND, FRAME CRACKED AT BS 827, STR 27L. REPAIRED FRAME IAW SRM.SDR FDEA201112155266Frame · damagedCABIN FRAME AT STA 1280, S13L TO S14L HAS DAMAGE. REPAIRED IAW SRM 53-00-07 FIG 201 REPAIR 3, REV 104. REPAIR IS CLASSIFIED AS MAJOR.SDR GLBA20111214FFrame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND THE AFT FUSELAGE FRAME AT FS 456 CRACKED AT THE FWD GAS STRUT MOUNT UPPER INBD NUT PLATE, BETWEEN STRINGER 4L AND 5L, 2 CRACKS 1" AND .2" IN LENGTH. MX REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPESDR SWAA20111214436Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 7L TO STR 8L. REPAIRED FRAME IAW EA.SDR SWAA118432Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 727B, LBL 1.5. REPAIRED FRAME IAW SRM.SDR SWAA118430Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA118393Frame · crackedDURING SCHDULED 24Y CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 727A, STR 17R. REPAIRED FRAME IAW EA.SDR SWAA20111214392Frame · crackedDURING SCHDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 344, BETWEEN STR 23L TO STR 24L. REPAIRED FRAME IAW EO.SDR SWAA118390Frame · crackedDURING SCHDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 344, BETWEEN STR 24R TO STR 25R. REPAIRED FRAME IAW SRM.SDR SWAA20111213423Failsafe · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO BAY FAIL SAFE CHORD CORRODED AT BS 727E, STR 24L. REMOVED AND REPLACED CHORD IAW SRM AND DWG.SDR SWAA20111213416Frame · corrodedDURING SCHDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, RBL 18. R&R FRAME IAW SRM AND DWG.SDR SWAA118415Frame · corrodedDURING SCHDULED 16Y CHECK, FOUND FRAME WEB CORRODED AT BS 787, BETWEEN RBL 2 TO RBL 5. R&R WEB IAW SRM.SDR SWAA118414Frame · corrodedDURING SCHDULED 16Y CHECK, FOUND FRAME WEB CORRODED AT BS 787, LBL 6. R&R WEB IAW SRM.SDR SWAA20111213407Frame · corrodedDURING SCHDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 727E, BETWEEN LBL 7 TO RBL 12. R&R FRAME IAW SRM.SDR SWAA118406Frame · corrodedDURING SCHDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 727E, RBL 20. R&R FRAME IAW SRM AND DWG.SDR U2RA20111213077Frame · dentedDENT FOUND ON TOP OF FRAME AT BS 690 S24L.SDR SWAA118359Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND RT FRAME I/B LOWER FASTENER INNER CHORD CRACKED AT BS 616. REPAIRED CHORD PER SWA EA.SDR SWAA118347Failsafe · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT FAIL SAFE CHORD CORRODED AT BS 807, BETWEEN STR 25L TO STR 25R. R&R CHORD IAW SRM AND DWG.SDR SWAA20111213313Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SRM AND DWG.SDR CALA2011121400810Frame · crackedRT CABIN AREA CRACK FOUND AT FRAME STA 380 AND BETWEEN STRINGERS 8 AND 9 R. REF EA 5310-04716 REV C STE 07 FOR MFEC. INSTALLED REPAIR AT FRAME STA 380 BETWEEN STRINGER 8 AND 9 IAW EA 5310-04716 REV C.SDR FDEA201112135256Frame · gougedFUSELAGE UPPER LOBE INTERIOR BS 365 STR 8-9R FRAME GOUGED. COMPLIED WITH EA F-5310-157243, "CAT A MAJOR REPAIR".SDR FDEA201112135250Frame · damagedFRAME DAMAGED UNDER BRACKET AT STA 920, STR 5 - 6R. REPAIRED IAW SRM 53-00-07, REPAIR 3, FIG 201, REV 104. REPAIR CLASSIFIED AS MAJOR.SDR USAA2012013000008Frame · crackedC21 CHECK - 2 CRACKS IN FUSELAGE FRAME AT BS 440, S22R. REPLACED FUSELAGE FRAME AT BS 440, S22R IAW B737-300 SRM 51.40.02.0G FIG 8, 12.SDR FXGA20111210004Frame · crackedDURING HEAVY MX, DISCOVERED CRACKED FUSELAGE FRAME AT FUSELAGE STATION 438 AT STRINGERS 27L AND 27R.SDR CHQA201100477Frame · crackedDURING INSPECTION, A CRACK WAS FOUND ON FRAME 23. MAINTENANCE REPAIRED THE RIGHT-HAND FUSELAGE AT FRAME 23 UNDER SILL NUMBER 1 IN ACCORDANCE WITH ETD 2011-145-109359.SDR QXEA2011122001416Frame · corrodedFRAME 19.4 FLANGE IS CORRODED STR 31P TO 30P. REMOVED CORROSION IAW 51-21-00-00-02 AND RD 8/4-53-2344. BLENDED AREAS CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. NOMINAL THICKNESS .040" REF SRM 53-20-15-00-01, FOUND TO BE IN LIMITS IAW RD 8/4-5SDR QXEA2011122001417Frame · corrodedFRAME 176 FLANGES ARE CORRODED STR 29P TO 33. REMOVED RIVETS FOM AND CLEANED AND REMOVED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .037", CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 PT 4 AND 51-00-02-250-801 PT 6. MATERIAL LOSS FOUND TO BE WITSDR QXEA2011122001418Frame · corrodedFRAME 176 FLANGE IS CORRODED STR 32S TO 31S. REMOVED RIVETS FOM, CLEANED AND REMOVED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .039", CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 PT 4 AND 51-00-01-250-801 PT 6. MATERIAL LOSS FOUND TO SDR UALA2011121406832Frame · crackedBS 2120 FRAME UPPER STRUCTURE CRACKED BETWEEN RBL 40 & RBL 45.3. MAJOR REPAIR ACCOMPLISHED, MANUFACTURED & INSTALLED NEW FRAME SECTION REF ECRA 5300-01382, EN 747EN-53-038 5.SDR QXEA2011121901402Doubler · corrodedFRAME 258.5 FLANGE DOUBLER IS CORRODED STR 23P TO 25P. REMOVED CORROSION FROM DOUBLER IAW SRM 51-21-00-00-02. MATERIAL LOSS FOUND TO BE OUT OF LIMITS IAW SRM 51-30-15-00-01. REMOVED FLANGE DOUBLER IAW SRM 51-42-05-02-01. INSPECTED DOUBLER IAW NTM 51-00-06-SDR QXEA2011121901390Frame · corrodedFRAME 19.4 AFT SIDE IS CORRODED BY STR 30P. REMOVED CORROSION AT FR 19.4 STR 30P IAW SRM 51-21-00-00-02. MINIMUM REMAINING THICKNESS .038", CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. APPLIED ALODINE, PRIMER AND ALUMINIZED COATING IASDR QXEA2011121601361Frame · corrodedFRAME 1.0 FLANGE IS CORRODED STR 29P TO 30P. REMOVED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .046" CONFIRMED AREA CRACK FREE RE NTM 51-00-02-250-801. MATERIAL FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED AND PRIMED FLANGE AND FINISHESDR WX0A071022Frame · crackedF/STA 110 FRAME CRACKED ON RT SIDE AT A FASTNER HOLE APPROX LONGERON 16R. REPAIRED CRACK ON FRAME AT F/STA 110 BY INSTALLING DOUBLER IAW MD80 SRM, 51-70-4 FIG 2 AND 51-30-1.SDR CHQA201100501Frame · crackedDURING INSPECTION, THE COCKPIT LEFT AND RIGHT FRAME 10 WERE FOUND TO BE CRACKED. MAINTENANCE REPLACED THE LEFT (PN: 145-02409-001) AND RIGHT (PN: 145-02409-002) FRAME 10. THE NEW PART WAS INSTALLED WITH A SOLID RIVET IN ACCORDANCE WITH SRM 51-40-02.SDR USAA2011121600001Frame · crackedCDFI CHECK - CRACK IN FUSELAGE FRAME WEB AT BS 616, WL 208, LBL 70.85. REPAIRED FUSELAGE FRAME WEB AT BS 616, WL 208, LBL 70.85 IAW TYPICAL REPAIR TR737-5362-10-0023.SDR USAA2011121500034Frame · crackedCDFI CHECK - 3 INCH CRACK IN FUSELAGE FRAME INNER CHORD AT BS 616, WL 208, RBL 70.85. REPAIRED FUSELAGE FRAME INNER CHORD AT BS 616, WL 208, RBL 70.85 IAW B737 51-40-02 & BOEING DRAWING 65-40539.SDR USAA2011121200023Frame · crackedCDFI CHECK - CRACK ON FUSELAGE FRAME INNER CHORD AT BS 616, WL 208, LBL 70.85. REPAIRED FUSELAGE FRAME INNER CHORD AT BS 616, WL 208, LBL 70.85 IAW TYPICAL REPAIR TR737-5362-10-0023.SDR DALA1168760695Frame · dentedFWD CARGO FRAME DENTED ON UPPER RADIUS STA 540 BETWEEN STR 24 AND 25L. COMPLIED WITH ERA 496654-14 REV ORIGINAL AT SAA/SAT DURING HMV ON N/R 200984 W/O 89303150001.SDR ASAA11410820Frame · crackedRT SIDE FRAME 520 CRACKED AT A 1" PENETRATION HOLE. REPAIRED RT FRAME AT STA 520 IAW B737 400 SRM 53 00 07 REPAIR 13. THIS IS A CATEGORY B REPAIR WITH INSP THRESHOLD O 66 000 FLIGHT CYCLES AND 24 000 REPEAT INSP INTERVAL.SDR ASAA11410819Frame · crackedLT SIDE FRAME AT 500D HAS CRACK IN 1" WIRE PENETRATION HOLE AND CRACK IN .5" HOLE. REPAIRED STA 500D LT FRAME IAW EA AD 20112305 400 53 100. THIS IS A CAT B REPAIR WITH INSP THRESHOLD OF 66 000 CYCLES AND REPEAT INSP AT 24 000 FLT CYCLES INTERVAL.SDR ASAA11410818Frame · crackedRT FRAME 500B CRACKED AT .5" HOLE. REPAIRED STA 500B RT FRAME IAW EA AD 20112305 400 53 101 REV NEW ISSUED 12/16/2011. THIS IS A CAT B REPAIR WITH INSP THRESHOLD OF 66 000 FLIGHT CYCLES AND A REPEAT INSPECTION AT 24 000 FLT CYCLES.SDR ASAA11410817Frame · crackedRT FRAME 500F HAS CRACK AT 1" WIDE PENETRATION HOLE. REPAIRED 500F RT FRAME IAW B737 400 SRM 53 00 07 REPAIR 13. THIS IS A CATEGORY B REPAIR WITH INSP THRESHOLD O 66 000 FLIGHT CYCLES AND 24 000 REPEAT INSP INTERVAL.SDR ASAA11410816Frame · crackedLEFT SIDE FRAME 500B CRACK IN 1 INCH WIDE PENETRATION HOLE. REPAIRED 500B LT FRAME IAW B737 400 SRM 53 00 07 REPAIR 13. THIS IS A CATEGORY B REPAIR WITH INSP THRESHOLD O 66 000 FLIGHT CYCLES AND 24 000 REPEAT INSP INTERVAL.SDR ASAA11410815Frame · crackedLEFT SIDE FRAME 500F HAS CRACK IN 1" WIDE PENETRATION HOLE. REPAIRED 500F LT FRAME IAW B737 400 SRM 53 00 07 REPAIR 13. THIS IS A CATEGORY B REPAIR INSPECTION THRESHOLD OF 66 000 CYCLES AND A REPEAT INSP AT 24 000 FLIGHT CYCLES.SDR QXEA2011121601356Frame · corrodedCORROSION AT FRAME ATTACH FLANGE AT X116 BETWEEN L STR 29 AND L STR 30. BLENDED CORROSION ON FLANGE IAW RD 8/4-53-2344. TREAT, PRIMED AND PAINTED IAW SRM 51-21-10-02-01, 51-25-10-02-01, AND 51-25-15-02-01.SDR SWAA20111208427Frame · crackedDURING SCHEDULED 18Y, CHECK FOUND INNER FRAME CHORD CRACKED AT BS 615, WL 202. REPAIRED CHORD IAW EA.SDR JR2R2011120800627Frame · corrodedFRAME AT FS 364 CORRODED AT STR 27 - REPAIRED FRAME IAW RO CRJ9-53-0883.
Back to JASC 5311