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 EIAA2010038Frame · crackedU/D BS 360 STR 8L-9L WL 330-330 FRAME WEB CRACK. REMOVED DAMAGE, FABBED AND INSTALLED REPAIR PER EA-53-1243.SDR EIAA2010037Frame · crackedU/D BS 360 STR 1R-2R FRAME WEB CRACK WL 350. REMOVED DAMAGE, FABBED AND INSTALLED REPAIR PER EA-53-1243.SDR EIAA2010036Frame · defectiveBS 840 U/P BS 860 STR 6-12 LT/RT FRAME MOD FOUND NOT TO MATCH DWG. REMOVED EXISTING MOD FABBED AND INSTALLED NEW REPAIR PER EA-53-1254.SDR EIAA2010021Frame · crackedFWD CARGO BS 980 STR 34R FRAME CRACK. REMOVED DAMAGE FABBED AND INSTALLED REPAIR PER EA-53-1241.SDR EIAA2010020Frame · crackedU/D BS 440 STR 10R-10AR FRAME WEB CRACKED. REMOVED DAMAGE, FABBED AND INSTALLED REPAIR PER EA-53-1243.SDR UIEA201000188Frame · crackedEO 4753A448, A CRACK WAS FOUND IN THE BS 420, S-10R FRAME WEB . THE DAMAGE WAS TRIMMED OUT AND REPAIRED IAW NRC 500789 AND SRM 53-10-04, FIGURE 11. PART 1 OF THIS EO DOCUMENTS THE FRAME WEB REPAIR IAW NRC 500789 AND SRM 53-10-04, FIGURE 11. THE REPAIR CONSISTSDR SIMA201014405Frame · damagedDURING MAINTENANCE BASE INSPECTION FOUND TOOL MARKS ON INBOARD WEB OF FRAME 61 BETWEEN STRINGERS 16R AND 17R. THE AIRCRAFT WAS REMOVED FROM SERVICE. COMPLIED WITH REPAIR TO THE FRAME 61 IAW EO EM-53MR-1556. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA103002Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27R TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA103000Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA102993Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SIMA201014005Frame · damagedDURING MAINTENANCE BASE VISIT FOUND DAMAGE TO FRAME 27 AND STRINGER 15L. THE AIRCRAFT WAS REMOVED FROM SERVICE. CUT OUT DAMAGE AND FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAE EO EM-53MR-155. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR IPXA10560744Frame · gougedINSPECTION TYPE:C3, FUSELAGE UPPER LOBE BS 440 APPROX STR 10 LT - GOUGE IN FRAME INBD FACE. REPAIRED IAW ATS ER 10-2930.SDR IPXA10560743Frame · gougedINSPECTION TYPE:C3, FUSELAGE UPPER LOBE BSTA 440 APPROX STR 11 LT - GOUGE IN FRAME INBD FACE. REPAIR IAW ATS ER 10-2930.SDR IPXA10560742Frame · gougedINSPECTION TYPE:C3, FUSELAGE UPPER LOBE BS 440 APPROX STR 12 LT - GOUGE IN FRAME INBD FACE. REPAIR IAW ATS ER 10-2930.SDR IPXA10560729Frame · gougedINSPECTION TYPE:C3, FUSELAGE UPPER LOBE BSTA 440 APPROX STR 8 RT - GOUGE IN FRAME INNER FACE. REPAIR IAW ATS ER 10-2928.SDR IPXA10560728Frame · gougedINSPECTION TYPE:C3, FUSELAGE UPPER LOBE BSTA 440 APPROX STR 7 RT - GOUGE IN FRAME INNER FACE. REPAIRED IAW ATS ER 10-2928.SDR IPXA10560727Frame · gougedINSPECTION TYPE:C3, FUSELAGE UPPER LOBE BSTA 440 APPROX STR 15 RT - GOUGE IN FRAME INNER FACE. REPAIRED IAW ATS ER 10-2928.SDR IPXA10560726Frame · gougedINSPECTION TYPE:C3, FUSELAGE UPPER LOBE BS 220 APPROX STR 6 RT - GOUGE IN FRAME INNER FACE. REPAIRED IAW ATS ER 10-2928.SDR IPXA10560725Frame · gougedINSPECTION TYPE:C3, FUSELAGE UPPER LOBE BS 440 APPROX STR 11 RT - GOUGE IN FRAME INNER FACE. REPAIR IAW ATS ER 10-2928.SDR IPXA10560714Frame · gougedINSPECTION TYPE:C3, FUSELAGE UPPER LOBE B, STA 440 APPROX STR 15 LT - GOUGE IN FRAME INBD FACE. REPAIR IAW ER 10-2911.SDR IPXA10560680Frame · gougedINSPECTION TYPE:C3 MAIN CARGO BAY FRAME INNER FLANGE HAS A SCREW GOUGE BS 440, STR 5-6L. REPAIRED IAW ATS ER NR 10-2929.SDR IPXA0560630Frame · gougedINSPECTION TYPE:C3, FUSELAGE UPPER LOBE BSTA 365 APPROX STR 15 LT - GOUGE IN FRAME INBD FACE. REPAIRED FRAME WEB IAW ER 10-2925.SDR IPXA10560594Frame · gougedINSPECTION TYPE:C3, FUSELAGE UPPER LOBE B, STA 440 APPROX STR 15 LT - GOUGE IN FRAME INBD FACE. REPAIR IAW ATS ER NR 10-2911.SDR IPXA10560444Frame · damagedINSPECTION TYPE:C2, FRAME AT BS 1000, BETWEEN S-15R AND S-16R HAS AN IMPROPERLY INSTALLED FASTENER AND THE ADJACENT FASTENER BELOW HAS A FIGURE EIGHT HOLE. REPAIRED IAW ER 10-2881.SDR IPXA10560410Frame · gougedINSPECTION TYPE:C2, AFT CARGO BAY DOOR SURROUND AFT FRAME INNER CHORD HAS A DEEP GOUGE BS 1440, RBL 26. REPAIRED IAW ER 10-2878 DATED 06/04/10.SDR SWAA102972Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA102971Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA102970Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER EA.SDR SWAA102968Frame · corrodedDURING SCHEDULED 2HC1 CHECK, FOUND FRAME CORRODED AT BS 967, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA102953Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 907, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA102950Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA102927Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 733D, LBL 8.10. REPAIRED FRAME PER EA.SDR SWAA102924Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT FRAME CORRODED AT BS 500C, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA102923Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT FRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA102922Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT FRAME CORRODED AT BS 500A, BETWEEN STR 1 TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA102921Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 1 TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA102916Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 27R TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA102911Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME CORRODED AT BS 947, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA102909Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND AFT CARGO DOOR CUTOUT, FWD FRAME CRACKED AT BS 794.3, BETWEEN RBL 6 TO RBL 20. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA102893Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR FDEA201005191579Frame · damagedSTA 640, ABOVE STR 26L FRAME HAS A ELONGATED HOLE AT STA 640 ABOVE STR 26L FRAME REPAIR WAS ACCOMPLISHED, DUE TO DISCREPANCY EFFECTING THE P TO F CONVERSION ON MAE MOD W/C NR 118250068DSSR06 AND MAE EA NR 757- 5332-16-F2479, REV A, DATED JAN 5, 2010. THIS NONSDR EIAA2010030Failsafe · damagedECRA 485-53-195-1 RELOCATION SECTION 42 FAIL-SAFE CHORD REPAIR DOUBLER/SPLICE AT BS 540 AND 560. REMOVED EXISTING DOUBLER/SPLICE REPAIR ON OUTER SURFACE OF FORMED FAIL-SAFE/UPPER CHORD AND INSTALLED REPLACEMENT REPAIR DOUBLER/SPLICE ON INNER SURFACE OF FORMEDSDR ZZDA2010286Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2984.SDR ZZDA2010285Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2973.SDR SWAA102884Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA102880Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA102878Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 827, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR FDEA201005181575Frame · gougedMAIN FRAME AT STA 1280 HAS 3 DEEP GOUGES AND 2 MIS-DRILLED LOCK FASTENER ABOVE STRINGER L-14. CABIN MAIN FRAME AT STA 1280, S-10L TO S-14L REPAIRED IAW SRM 53-00-07, REPAIR 1 REV 99. INITIAL INSP THRESHOLD AT 50,000 FLIGHT CYCLES AND AN INTERVAL INSP AT 12,0SDR C2XA10SH172Frame · crackedSHV - DURING C-CHECK THE LT FRAME 10 WAS FOUND TO BE CRACKED AT STRINGER 10L RIGHT BELOW THE LT DV WINDOW FRAME. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FRAME IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA10SH171Frame · crackedSHV - DURING C-CHECK FRAME 10 AT STRINGER 10R WAS FOUND TO BE CRACKED RIGHT BELOW THE RT DV WINDOW FRAME. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FRAME IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.
Back to JASC 5311