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 JR2R2011120800626Frame · corrodedFRAME AT FS 319.70 CORRODED FROM STR 26L TO 26R - REPAIRED FRAME IAW RO CRJ9-53-0875.SDR JR2R2011120800625Frame · corrodedFRAME AT FS 333 CORRODED AT STR 27 - REPAIRED FRAME IAW RO CRJ9-53-0885.SDR SIMA201134202Frame · damagedDURING MAINTENANCE BASE INSPECTION FOUND FRAME 70 TO HAVE A TOOLING MARK BETWEEN STRINGERS 11 AND 12 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. COMPLETED REPAIR TO FRAME 70 IAW EO EM-53MR-1903. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR DALA1170771705Failsafe · crackedFUS - RT STA 955 BULKHEAD FTG AREA 1 EACH FASTENER HOLE CRACKED AT FAIL SAFE STRAP. THE FAIL SAFE STRAP CRACK AREA TRIMMED OFF AND REPAIR ACCOMPLISHED AS PER ER/A 497668-14AD REV 0.SDR DALA1170761705Failsafe · crackedFUS - LT STA 955 BULKHEAD FTG AREA 1 EACH FASTENER HOLE CRACKED AT FAIL SAFE STRAP. THE FAIL SAFE STRAP CRACK AREA TRIMMED OFF AND REPAIR ACCOMPLISHED AS PER ER/A 497667-14AD REV 0.SDR DALA1169791705Frame · crackedCABIN LT STA 903 BETWEEN S-20L AND S-21L FRAME INNER CHORD CRACK. REPAIRED PER ERA 497669-14AD REV ORIG.SDR FDEA201112075209Frame · misrepairedFRAME MISREPAIRED REPAIR AT BS 1480 S24-26L. R & R FRAME IAW SRM 51-40-02 AND DWG 146N1030. MAJOR REPAIR.SDR USAA2011120900003Frame · crackedC11 CHECK - CRACK ON FRAME INNER CHORD ANGLE AT BS 616, S17R. REPLACED FRAME INNER CHORD ANGLE AT BS 616, S17R IAW TYPICAL REPAIR TR737-5362-10-0023.SDR USAA2011120900002Frame · crackedC11 CHECK - CRACK ON FRAME INNER CHORD ANGLE AT BS 616, S17R. REPLACED FRAME INNER CHORD ANGLE AT BS 616, S17R IAW TYPICAL REPAIR TR737-5362-10-0023.SDR SWAA20111207414Frame · corrodedDURING SCHEDULED OTS CHECK, FOUND FRAME CORRODED AT BS 993, RBL 45. REPAIRED FRAME IAW SRM.SDR SIMA201134201Frame · damagedDURING MAINTENANCE BASE INSPECTION FOUND TOOLING MARKS TO FORWARD SIDE OF FRAME 68. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 68 IAW EO EM-53MR-1907. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR FDEA201112075201Frame · chafedAFT LWR CARGO COMP, FRAME UPPER SURFACE HAS CHAFE AREA. BS 1580, BETWEEN S25-26L. REPAIRED IAW EA F-5310-153470. REPAIR CLASSIFIED AS MAJOR.SDR AALA20111206TUL12Frame · crackedCRACKED STIFFENER ON FUSELAGE FRAME AT STATION 365 LEFT BUTTLINE 30. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 53-10-51-2R 1.SDR COEA2011120606821Frame · corrodedHEAVY CK COE / LEVEL 2 CORROSION: FRAME 9 IS CORRODED ON THE FORWARD SIDE AT BL 0. (LENGTH 3", WIDTH 1.5", DEPTH .006"). REMOVED CORROSION, REMOVED AND REPLACED SPLICE WITH OEM PART IAW ATR SRM.SDR DALA1167321704Attach Fitting · crackedFS 927 RT AT STR 21R FRAME ATTACH FITTING IS CRACKED AND REPLACED PER B767-300 SRM 51-10-02 PARA 9. (REJECTED. DOES NOT MEET SDR CRITERIA. REFERENCE INVALID.)SDR DALA1167301704Frame · crackedFS 903 RT INNER FRAME CHORD AT STR 20R-21R IS CRACKED AND REPAIRED PER ERA 497655-14AD REV ORG.SDR ASOA201102345Frame · corrodedFOUND FS 333 LOWER FRAME IS CORRODED. FS 333 LOWER FRAME REPLACED.SDR ASOA201102324Frame · corrodedON REMOVAL OF INTERCOSTAL, FOUND FRAME FS 349 CORRODED. MAJOR REPAIR.SDR AALA20120208AFW05Strap · crackedLEFT BODY STATION 955 FAILSAFE STRAP CRACKED. ACCOMPLISHED REPAIR PER ECO C3039AE.SDR QXEA2011120701325Frame · corrodedCORROSION ON FRAME DOUBLER AT S36.00 BETWEEN LT STG 25 AND LT STG 24. BLENDED OUT CORROSION AND COMPLETED REPAIR IAW RD 8/4-53-2344. REMOVED FRAME DOUBLER. CLEANED RESIDUAL TRANSFER CORROSION FROM DOUBLER. TREATED AND PRIMED DOUBLER AND INSTALLED ALL FUSELSDR QXEA2011120701326Frame · corrodedCORROSION ON FRAME DOUBLER AT 258.500 BETWEEN LT STG 25 AND LT STG 24. BLENDED OUT CORROSION AND COMPLETED REPAIR IAW RD 8/4-53-2344. REMOVED FRAME DOUBLER OF FS 258.500 IAW SRM 51-42-05-02-01. CLEANED RESIDUAL TRANSFER CORROSION FROM DOUBLER. TREATED AND SDR QXEA2011120701327Frame · corrodedCORROSION ON ATTACH FLANGE OF FRAME AT X281.00 BETWEEN RT STR 31 AND RT STG 32. BLENDED TO REMOVE MINOR SURFACE CORROSION IAW RD 8/4-53-2344. TREATED, PRIMED, PAINTED IAW SRM 51-42-05-02-01. APPLIED CPC IAW SRM 51-25-01.SDR DALA1200136817Frame · dentedFWD CARGO FRAME DENTED AT STA 520 ABOVE STR 24L. INSTALLED REPAIR ANGLE, SHEAR TIE, AND REPAIR CLIP PER SRM 51-40-02.SDR DALA1171036817Frame · dentedFWD CARGO FRAME DENTED STA 580 BETWEEN STR 24 & 25L. REMOVED DAMAGED FRAME SECTION, FABRICATED REPAIR SPLICE AND ANGLES AND INSTALLED REF B757 SRM 53-00-07. DURING HMV AT ST AEROSPACE SAN ANTONIO.SDR TX9Y20111205003Failsafe · corrodedDURING DATUM AIRCRAFT INPUT,A CORROSION (SIZE ABOUT:3.3"*0.8") WAS FOUND ON BULK CARGO FRAME LOWER LOBE FAIL SAFE CHORD (P/N:65B04347-149,STA2200) HORIZONTAL FLANGE AT STR 40R. THE REPAIR WAS PERFORMED PER BOEING MESSAGE NUMBER TEC-SOF-11-0099. THE REPAIR WASDR QXEA2011120501306Frame · corrodedCORROSION FOUND ON AFT VERTICLE SIDE OF FRAME AT BS 882.703. REMOVED CORROSION IAW SRM 51-21-00-00-02. FOUND TO BE WITH LIMIT AND COMPLETED REPAIR IAW RD 8/4-55-711.SDR SWIA201131349Frame · corrodedCORROSION ON AFT SIDE OF FRAME AT FS 333.0 IN LOWER FUSELAGE BETWEEN STRINGERS 26L AND 26R. (C-CHECK) REPAIRED PER CRJ200 SRM.SDR ASOA201102303Frame · corrodedFOUND COCKPIT LOAD TO BE CORRODED BEYOND LIMITS IAW SRM 51-21-06. LOCATED HOLES IN NEW COCKPIT LAND AND INSTALLED. ALL WORK DONE IAW SRM 51-42-00-001-001-A01 AND SRM 51-42-21-001-001-A01 AND SRM 51-42-23-001-001-A01. MINOR REPAIR.SDR ASAA12410887Frame · crackedPASSENGER CABIN LT FRAME STA 440 CRACKED BETWEEN STR 8L & 9L. REPAIRED STA 440 LT FRAME IAW EA AD 20062609 400 53 128.SDR DALA1171026817Frame · dentedAFT CARGO FRAME DENTED STA 1420 ABOVE 26L. REMOVED DAMAGED FRAME SECTION, FABRICATED REPAIR AND INSTALLED REF B757 SRM 53-00-07 DURING HMV AT ST AEROSPACE SAN ANTONIO.SDR QXEA2011120601315Frame · corrodedDURING C-CHECK, FOUND CORROSION ON ATTACH FLANGE ON FRAME AT 373.150 BETWEEN STRINGERS LT STG 32 AND LT STG 31. BLENDED MINOR SURFACE CORROSION, BLEND MEASURES .002" DEEP .5" WIDE 1" LONG. BLEND IS WITHIN LIMITS IAW RD 8/4-53-2344. PERFORMED FPI ON BLENDED SDR FDEA201112025128Frame · misrepairedEXISTING FRAME REPAIR AT BS 1340, STR 22R-26R MISREPAIRED. REMOVED AND REPLACED FRAME AND SPLICE BS 1340 IAW SRM 51-40-02 AND DRAWING146N1028. MAJOR REPAIR.SDR DALA1169496817Frame · dentedAFT CARGO FRAME DENTED STA 1400 STR 25L. REMOVED PRODUCTION SPLICE, REMOVED DAMAGED AREA, FABRICATED REPAIR AND INSTALLED IAW B757 SRM 53-00-07 DURING HMV AT ST AEROSPACE SAN ANTONIO.SDR QXEA2011120601308Frame · corrodedDURING C-CHECK, FOUND CORROSION ON FWD SIDE OF FRAME AT X301.00 NEXT TO LT STG 31. BLENDED OUT CORROSION AND FOUND WITHIN LIMITS IAW RD 8/4-53-4149. COMPLETED REPAIR IN CONFORMITY WITH TASK CARD RD 8/4-53-4149.SDR QXEA2011120601312Frame · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME ATTACH FLANGE AT X469.500 BETWEEN LT STG 32 AND LT STG 31. BLENDED AND REPAIRED IAW RD 8/4-53-2344. APPLIED PRIMER AND PAINTED IAW SRM 51-25-10-02-01 AND 51-25-15-02-01.SDR FXGA2011120200003Frame · crackedDURING HEAVY MX DISCOVERED CRACKED FUSELAGE FRAME AT FUSELAGE STATION 438 AT STRINGERS 27L AND 27R.SDR QXEA2011120601310Frame · corrodedDURING C-CHECK, FOUND CORROSION ON ATTACH FLANGE OF FRAME AT X361.00 BETWEEN RT STG 32 AND RT STG 31. BLENDED CORROSION FOUND WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED, PRIMED AND PAINTED IAW RD 8/4-53-2344.SDR NACA20110050Frame · crackedCRACK FOUND IN FWD CARGO BAY STRINGER 19 TO 21, FRAME 500B AT WIRE PENETRATION HOLE, RIGHT. REPAIRED FRAME 500B RIGHT SIDE IAW SB 737-53A1279R1 PER SRM 53-00-07 REPAIR 13 AND AERONAUTICAL ENGINEERING EO 1563 DATED 3 DEC 2011.SDR NACA20110049Frame · crackedCRACK FOUND IN FWD CARGO BAY STRINGERS 19 TO 21, FRAME 500D AT WIDE PENETRATION HOLE AT RIGHT. REPAIRED FRAME 500D RIGHT IAW SB737-53A1279R1 PER SRM 53-00-07 REPAIR 13.SDR NACA20110051Frame · crackedCRACK FOUND IN FWD CARGO BAY BETWEEN STRINGERS 19 TO 21, FRAME 500D AT WIRE PENETRATION HOLE AT LEFT SIDE. REPAIRED FRAME 500D LEFT IAW SB737-53A1279R1 PER SRM 53-00-07 REPAIR 13. SEE ASCENT MWO 319-08-218 FOR REPAIR DETAILS.SDR QXEA2011120601320Frame · corrodedDURING C CHECK, FRAME ATTACH FLANGE AT FS X 39.000 BETWEEN STR 31P AND 32P FOUND CORRODED.SDR QXEA20111201313Frame · corrodedCORRODED RIVET ON FRAME DOUBLER AT X509.00 AT RT Y35.00. ACFT DOWN FOR C-CHECK.SDR QXEA2011120601307Frame · corrodedCORROSION ON ATTACH FLANGE OF FRAME AT 258.500 BETWEEN LT STR 32 AND STR 33. REMOVED CORROSION AND COMPLETED REPAIR IAW RD 8/4-53-2344.SDR COEA2011120233801Frame · corrodedHEAVY CK COE / LEVEL 2 CORROSION: FRAME 37 IS CORRODED FROM STR 17R TO ABOVE 14R (LENGTH 25", WIDTH 2", DEPTH .060"). REMOVED AND REPLACED FRAME WITH OEM PART IAW ATR SRM.SDR AALA20111202TUL05Strap · damagedELONGATED HOLE IN RIGHT FRAME STRAP STATION 1220. INSTALLED NEW STRAP.SDR QXEA2011120201301Frame · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME ATTACH FLANGE AT X 116.00 BETWEEN LT STG 31 AND RT STG 30. REMOVED CORROSION IAW RD 8/4-53-2344 AND 8/4-53-4145. TREATED, PRIMED AND PAINTED BLEND AREA IAW SRM 51-21-10-02-01, 51-25-10-02-01 AND 51-25-15-02-01.SDR QXEA2011120201294Frame · corrodedDURING C-CHECK, FOUND CORROSION ON ATTACH FLANGE OF FRAME AT X19.4 BETWEEN LT S31 & RT S31. BLENDED CORROSION AND FOUND IN LIMITS OF RD 8/4-53-2344. PERFORMED FPI IAW CHAPTER 8, NO DEFECTS NOTED. TREATED, PRIMED AND PAINTED IAW SRM 51-21-10-02-01, 51-25-10SDR QXEA2011120201305Frame · corrodedDURING C CHECK, FOUND CORROSION ON FLANGE OF FRAME AT BS 176.00 BETWEEN S30L AND S30R. BLENDED CORROSION IAW SRM 51-21-00-00-02 AND FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. COMPLETED REPAIR IAW RD 8/4-53-2344.SDR QXEA2011120201302Frame · corrodedDURING C CHECK, FOUND CORROSION ON FLANGE OF FRAME AT BS 136.00 BETWEEN S32L AND S30R. REMOVED CORROSION IAW SRM 51-21-00-00-02. FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ETCHED, ALODINED, PRIMED AND PAINTED IAW SRM 51-21-10-02-01, 51-25-10-02-01 AND 51-SDR QXEA2011120201304Frame · corrodedDURING C-CHECK, FOUND CORROSION ON FLANGE OF FRAME AT BS 156.00 BETWEEN S30L AND S30R. REMOVED RIVETS IAW SRM 51-40-07-02-01. REMOVED CORROSION AND FOUND WITHIN LIMITS IAW SRM 51-21-00-00-02 AND RD 8/4-53-2344. INSTALLED FASTENERS IAW SRM 51-42-05-02-01. T
Back to JASC 5311