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 DLM88071220Frame · brokenFOUND BROKEN FRAME AT STA 1510. REPLACED FRAME.SDR DLM88071193Frame · corrodedCORROSION ON FRAME AT STA Y=731 BETWEEN LONGERONS 30 AT C2 REPAIRED PER SRM 51-70-05D.SDR KCSA071333Doubler · crackedSTA -520 FRAME DOUBLER CRACKED BETWEEN STRINGER -30L AND 31L 1.5 INCH.SDR 07FDEA04018Frame · corrodedCORROSION FOUND AT AFT CARGO COMPARTMENT DOOR FRAME - FR59A, BETWEEN STRG 26 RT AND 29 RT. AFT CARGO COMPARTMENT DOOR FRAME WAS REPAIRED BETWEEN STR 26-29 RT IAW FEDEX EA 6-5310-113171.SDR USAA920070815Frame · corrodedCTL - MAJOR REPAIR - C-5 CHECK, LEVEL 2 CORROSION ON FRAME, BS 1006, BL 0. REPAIRED FRAME, BS 1006, BL 0 IAW B737-300 SRM 53-00-07 REPAIR 6.SDR C2XA07SH061Frame · crackedSHV - DURING C-CHECK MAINTENANCE FOUND FRAME 65 WITH CORROSION UNDER CARGO DOOR HOLD OPEN ROD SUPPORT BRACKET. MAINTENANCE REPAIRED CARGO DOOR HOLD OPEN ROD SUPPORT BRACKET IAW EC 5330-01719. AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR SWAA074437Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074445Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827 STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074436Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074429Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074439Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074434Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074438Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074440Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074435Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR CALA0700502Frame · crackedINSPECTION FOUND A .5 INCH CRACK IN FRAME O/B OF LEFT KEEL BEAM AT STA 520, S27L TO S28L. THE CRACK WAS LOCATED AT THE SECOND FASTENER HOLE FROM THE BOTTOM.SDR CALA0700501Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FRAME AT STA 847, S9L. REPAIRED IAW ECRA 5310-04651.SDR CALA0700500Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FRAME AT STA 807, S9R. REPAIRED IAW ECRA 5310-04651.SDR CALA0700499Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FRAME AT STA 500A BETWEEN STRINGERS 8 & 9R. REPAIRED IAW ECRA 5310-04651.SDR CALA0700498Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FRAME AT STA 480 BETWEEN STRINGERS 8 AND 9L. REPAIRED IAW ECRA 5310-04651.SDR CALA0700497Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FRAME AT STA 807, S9L. REPAIRED IAW ECRA 5310-04643.SDR CALA0700496Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FRAME AT STA 907, S9L. REPAIRED IAW ECRA 5310-04651.SDR CALA0700495Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FRAME AT STA 867, S9L. A REPAIR WAS INSTALLED IAW ECRA 5310-04651.SDR CALA0700494Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FRAME AT STA 827, S9L. REPAIR ANGLES WERE INSTALLED IAW ECRA 5310-04651.SDR CALA0700492Frame · corrodedINSPECTION FOUND CORROSION AT FRAME ATTACH POINT, STA 927 JUST I/B OF S27L, LBL 27 TO RBL 27. A REPAIR WAS INSTALLED IAW ECRA 5310-04655.SDR CALA0700491Frame · corrodedINSPECTION FOUND FRAME TO SKIN ATTACH POINT CORRODED AT BS 967 JUST I/B OF S27L. A REPAIR WAS INSTALLED IAW ECRA 5310-04654B.SDR 07FDEA03420Frame · misrepairedFOUND OLD REPAIRS AT MANHOLE FITTING FRAME 38.1-38.2 (MORE THAN FOUR ADJACENT POCKETS AFFECTED), NOT ALLOWED IAW SRM 53-14-12/PG 228. REPAIR PERFORMED BY REPLACEMENT OF MANHOLE FITTING BETWEEN FRAME 38.1-38.2 IAW DRW R537-06164 ISSUE D, APPROVED BY EA 6-5310-SDR 07FDEA03419Frame · misrepairedFOUND OLD REPAIRS AT MANHOLE FITTING FRAME 23-24 (MORE THAN FOUR ADJACENT POCKETS AFFECTED), NOT ALLOWED IAW SRM 53-13-12/PG 220. REPAIR PERFORMED BY REPLACMENT OF MANHOLE FITTING BETWEEN FRAME 23-24 IAW DRW, R537-06163 ISSUE B, APPROVED BY EA 6-5310-95923A ASDR 07FDEA03418Frame · damagedFOUND OLD REPAIR AT APU COMPARTMENT, FRAME 101 WITH AN ADDITIONAL DAMAGE (BENDED) ON SUPPORT ANGLE AND THE DOUBLER. REPAIR PERFORMED BY DRESS BACK THE BENDED FLANGE OF THE L-SECTION IAW EA 6-5339-95908 AND RAS/DAHAM/4020455/2006 ISSUE A.SDR 07FDEA03411Frame · misrepairedFOUND OLD EXTERNAL DOUBLER REPAIR ON FRAME 10 LH, Z-336, NOT FULLY CONFORM TO RAS/AS/359/95 ISSUE A AND OLD DELTA AIRLINES RECORD 297854-14 (WRONG RIVETS INSTALLED: HLT411-6 INSTEAD OF HL109-6). REPAIR PERFORMED BY REMOVING WRONG FASTENERS, NDT INSPECTION FORSDR SWIA200719074Frame · crackedLBL 9 LOWER FRAME FS 280 AND LBL 9 IS CRACKED, FOUND AT C-CHECK. COMPLIED WITH REPAIRS PER REO 601R 53-11-171.SDR ABXA070313Frame · crackedLEFT AFT MAIN FRAME STA 737 WAS CRACKED ON UPPER INBOARD FORWARD FLANGE BETWEEN Z-CLIP FASTENERS. REPAIRED MAIN FRAME STA 737 LEFT IAW EA 53400310.SDR UIEA200700346Frame · crackedR1 MED LOWER AFT CORNER FRAME CRACKED AT STA 490 RT S-25R TO S-26R AREA. C/OUT AS PER SRM 52-10-02 FIG 10.SDR LR7A07072Frame · crackedDURING SCHEDULED C-8 CHECK, PER JOB CARD HC5311, FOUND COCKPIT LT FRAME CRACKED AT FS132 WL206 TO 216 LBL50. RIB (FRAME) FS132 LT FABRICATED USING P/N:2024T3 .050", B/N:CK260281DC AND REPLACED IAW SMP583 CHAPTER 51-60 AND 51-70.SDR LR7A07071Frame · crackedDURING SCHEDULED C-8 CHECK, PER JOB CARD HC5311, FOUND COCKPIT RT FRAME CRACKED (INTERCOSTAL RIB OUT/IN FOR ACCESS, AT FS 132 WL207-217 RBL50. RIB (FRAME) REPLACED IAW SMP583 CHAPTER 51-60 AND 51-70. INTERCOSTAL RIB REINSTALLED IAW SMP583 CHAPTER 51-70.SDR SWAA074418Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA074378Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074390Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA074387Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074381Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074380Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074388Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074414Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074379Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074389Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 328, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074419Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 2 DOOR STOP. REPAIRED FRAME PER SRM.SDR 07FDEA03374Frame · damagedFOUND ON DIAPHRAGM FRAME 47-54 AT BEAM 4-5 LT AND RT NICKS AND IMPACT DAMAGES. REPAIR PERFORMED BY SMOOTH REWORK OF DAMAGED AREA ON BEAM 4-5 LT IAW EA 6-5315-95840 AND RAS 041406/011/2005 ISSUE A AND CUT OUT THE DIAPHRAGM AND INSTALLING A REPAIR SPLICE ON BEASDR 07FDEA03357Frame · chafedFOUND WEAR MARK ON INNER FLANGE OF FRAME 38.1 BETWEEN STRG 14-15 RT. REPAIR PERFORMED BY INSTALLING INTERNAL ANGLE AND ADDITIONAL SHIM AS PER PRINCIPLES GIVEN IN SRM 53-10-13/FIG 202, APPROVED EA 6-5314-95855 AND RAS/DABRE/7005992/2005.SDR CALA0700510Frame · crackedINSPECTION FOUND A 1.2 INCH CRACK IN LOWER SECTION OF LEFT FRAME INNER CHORD AT STA 616, S17L TO S18L. THE FRAME CHORD WAS REPAIRED IAW ECRA 5311-01158.SDR SWAA074374Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311