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 SWAA2013051516039Frame · corrodedAFT CARGO FRAME CORRODED AT STATION 908. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013051416005Frame · corrodedFRAME CORRODED AT STA 908. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013051416004Frame · corrodedAFT CARGO FRAME CORRODED AT STA 908, BETWEEN LONGERON 29R TO LONG 29L. REMOVED ANAD REPLACED FRAME IAW SRM.SDR SWAA2013051315965Frame · corrodedFRAME CORRODED AT STA 974, BETWEEN LONGERON 28R & 28L. REMOVED AND REPLACED FRAME SECTION IAW SRM.SDR REXA2013042500541Frame · crackedLEFT BL 12 FRAME CRACKED FWD OF FS 280.00. CUT AWAY DAMAGED SECTION OF LBL 12 BEAM & REPAIRED IAW EO R53341.SDR MTNA2013042923Frame · corrodedFOUND FILIFORM CORROSION OUT OF LIMITS ON FRAME 10 RIGHT LOWER SEGMENT P/N S5317221120151. REPLACED SEGMENT IAW ATR SRM.SDR MTNA20130429022Frame · corrodedFOUND FILIFORM CORROSION OUT OF LIMITS ON FRAME 10 LEFT LOWER SEGMENT P/N S5317221120051. REPLACED SEGMENT IAW ATR SRM.SDR SWAA2013043015363Frame · crackedFRAME WEB CRACKED AT BS 178, LBL 17.0. REPAIRED WEB IAW SRM.SDR QXEA2013042500826Frame · corrodedFRAME X49.500 LOWER FLANGE HAS POSSIBLE CORROSION BETWEEN STRINGERS 29S AND 30S. REMOVED RIVETS AND CORROSION IAW SRM 51-42-05-02-01, REV 12, SRM 51-21-00-00-02, REV 12 MIN. THICKNESS NOTED .054", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801, PTSDR QXEA2013042500825Frame · corrodedFRAME X49.500 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 31P AND 33. REMOVED RIVETS AND CORROSION IAW SRM 51-42-05-02-01, REV 12, SRM 51-21-00-00-02 REV12. MIN. THICKNESS NOTED 050", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 & 51-00SDR QXEA2013042500821Frame · corrodedFRAME 584.5, FLANGE IS CORRODED STR 32S-31S. REMOVED 1EA RIVET TO ACCESS CORROSION AT FRAME X584.5 BETWEEN STR.31S-31S IAW SRM (R12) 51-42-05-02-01. REMOVED CORROSION FROM X584.5 BETWEEN STR 32S-31S IAW SRM (R12) 51-21-00-00-02. MIN THICKNESS NOTED .053", COSDR GLBA2013042600239Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK IN THE RT FUSELAGE FRAME AT FS 163.975 AND STRINGER 9AR AT THE STRINGER CUTOUT, .4" IN LENGTH. REPAIRED IAW EO 13-1900-53-037. MAJOR REPAIR.SDR GLBA2013042600238Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND CRACK IN THE FUSELAGE FRAME IN THE BEND RADIUS AT FS 451 AND STRINGER 10R, 1" IN LENGTH. REPAIRED IAW EO 13-1900-53-034. MAJOR REPAIR.SDR GLBA2013042600237Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK IN THE RT SIDEWALL FUSELAGE FRAME AT FS 107 AND JUCTION WITH LONGERON IN THE FRAME BEND RADIUS AT THE UPPER AND OF THE FRAME, 1" IN LENGTH. REPAIRED IAW EO 13-1900-53-038. MAJOR REPAIR.SDR GLBA2013042600236Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK IN THE FUSELAGE FRAME AT FS 177.35 AND STRINGER 13L IN THE BEND RADIUS, 1.1" IN LENGTH. REPAIRED IAW EO 13-1900-53-036. MAJOR REPAIR.SDR GLBA2013042600235Doubler · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK IN THE FUSELAGE FRAME DOUBLER AT BS 177.35 S13L, 1.2" IN LENGTH. REPAIRED IAW EO 13-1900-53-035. MAJOR REPAIR.SDR SWAA2013061016941Frame · crackedFRAME OUTBOARD CHORD CRACKED AT BS 727, STR 18A LT SIDE. REPAIRED FRAME IAW EA.SDR UALA2013042502871Frame · dentedAFT CARGO BAY FRAME DENTED BS 1400 S26L. CUT OUT DAMAGED AREA AND FABRICATED A REPAIR ANGLE AND INSTALLED PER SRM 53-00-07, REPAIR 5. MAJOR REPAIR.SDR UALA2013042502869Frame · dentedAFT CARGO BAY FRAME DENTED BS 1420 S27L. CUT OUT DAMAGED AREA OF FRAME INBOARD FLANGE, AND FORMED A REPAIR ANGLE PER SRM 53-00-07, REPAIR 5. MAJOR REPAIR.SDR UALA2013042502868Frame · dentedAFT CARGO BAY FRAME DENTED BS 1540 S26L. CUT OUT DAMAGED SECTION OF INBOARD FLANGE, AND FORMED REPAIR ANGLE PER SRM 53-00-07, REPAIR 5. MAJOR REPAIR.SDR UALA2013042502867Frame · bentAFT CARGO BAY FRAME BENT BS 1400, S26-27L. REPAIRED DAMAGED FRAME IAW SRM 53-00-07 REPAIR 5 DETAIL I. MAJOR REPAIR.SDR UALA2013042502866Frame · dentedAFT CARGO BAY FRAME DENTED FS 1440 S25-26L. REMOVED DAMAGE, FABRICATED AND INSTALLED FRAME REPAIR IAW SRM 53-00-07 REPAIR 5. MAJOR REPAIR.SDR UALA2013042502865Frame · dentedAFT CARGO BAY FRAME FS 1520 S26L DENTED. REMOVED DAMAGE, FABRICATED AND INSTALLED FRAME REPAIR IAW SRM 53-00-07 REPAIR 5. MAJOR REPAIR.SDR UALA2013042502864Frame · dentedAFT CARGO BAY FRAME FS 1500 S26L DENTED. REMOVED DAMAGE, FABRICATED AND INSTALLED FRAME REPAIR IAW SRM 53-00-07 REPAIR 5. MAJOR REPAIR.SDR UALA2013042502863Frame · dentedAFT CARGO BAY FRAME FS 1460 S26L DENTED. REMOVED DAMAGE. FABRICATED AND INSTALLED FRAME REPAIR IAW SRM 53-00-07 REPAIR 5. MAJOR REPAIR.SDR UALA2013042402859Frame · dentedFORWARD PIT FRAME DENTED AT BS 640 AT STR 23L. MAJOR REPAIR ACCOMPLISHED: INSTALLED OUTER "J" ANGLE REPAIR IAW SRM 53-00-07, TR 53-20, REPAIR 5.SDR SWAA2013052216385Frame · crackedFRAME OTBD CHORD FORWARD FLANGE'S LOWER FORWARD HOLE CRACKED STA 727, STR 18L. R & R CHORD IAW EA.SDR UALA2013042502876Frame · dentedFORWARD CARGO BAY BS 660 S24-25R FRAME DENTED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07 REPAIR 5. MAJOR REPAIR.SDR UALA2013042502875Frame · dentedAFT CARGO BAY BS 1520, S26L, FRAME DENTED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07 REPAIR 5. MAJOR REPAIR.SDR UALA2013042502874Frame · dentedFORWARD CARGO BAY FUSELAGE FRAME DENTED BS 600, S23-24L. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07 REPAIR 5. MAJOR REPAIR.SDR UALA2013042502873Frame · dentedAFT CARGO BAY FRAME DENTED AT BS 1480, S26L. REMOVED DAMAGE FABRICATED REPAIR AND INSTALLED PER SRM 53-00-07 REPAIR 5. MAJOR REPAIR.SDR UALA2013042502872Frame · dentedAFT CARGO BAY FRAME DENTED BS 1340, S25 - 26R. REMOVED DAMAGE FABRICATED REPAIR AND INSTALLED PER SRM 53-00-07. MAJOR REPAIR.SDR SWIA201333409Frame · corrodedFRAME AT FS 295 BETWEEN STRG 25L AND STRG 25R ON AFT FACE IS CORRODED. (C-CHECK) REPAIRED FRAME AT FS 295 BETWEEN STG 25L AND STG 25R IAW REO.SDR DALA1312203750Frame · crackedPASSENGER CABIN FRAME CRACKED LT STA 480 AT PSU ATTACH POINTACCOMPLISHED ERA 513576-14.SDR DALA1312193750Frame · crackedFRAME CRACKED RT BS 500C. ACCOMPLISED ERA 513576-14.SDR DALA1312173750Frame · crackedFRAME CRACKED LT BS 440. ACCOMPLISED ERA 513576-14.SDR DALA1312163750Frame · crackedFRAME CRACKED RT BS 500A. ACCOMPLISHED ERA 513576-14.SDR DALA1312153750Frame · crackedFRAME CRACKED RT BS 480 AT PSU ATTACH RAIL. ACCOMPLISHED ERA 513576-14.SDR FDEA201304240856Frame · damagedTWO MISSED DRILLED HOLES, L2 DOOR FUSELAGE FRAME BS 680 BETWEEN S12-13L. REPAIRED IAW EA F-5310-154149 PT 1.SDR QXEA2013042400808Frame · corrodedFRAME FLANGE AT FRAME 136, STR 33P - 32P HAS CORROSION. REMOVED RIVETS IAW SRM 51-42-05-02-01, REV 12. REMOVED CORROSION FROM FRAME FLANGE AT FRAME 136, STR 33P-32P IAW SRM REV 12 53-00-00-02-09. MIN THICKNESS NOTED .045", CONFIRMED CRACK FREE NTM 51-00-04-SDR QXEA2013042400807Frame · corrodedFRAME FLANGE AT FRAME 136, STR 32P - 31P HAS CORROSION. REMOVED 4 RIVETS AND CORROSION AT FRAME FLANGE AND FRAME AT X136 BETWEEN STR 32P-31P IAW SRM REV 12 53-00-00-02-09. MIN THICKNESS NOTED .046, CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00SDR QXEA2013042400805Frame · corrodedFRAME, FLANGE AND FRAME 136, STR 32S-31 HAS CORROSION. REMOVED 5 RIVETS AND CORROSION AT FRAME FLANGE AND FRAME 136 BETWEEN STR 32S-31S IAW SRM REV 12 53-00-00-02-09. MIN THICKNESS .043", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801SDR FDEA201304240854Frame · gougedMAIN DECK BS 1280 AT S10-11L FRAME IS GOUGED IN TWO PLACES. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07 FIG 101 DETAIL II. REMOVED DAMAGED FRAME IAW SRM 51-40-02. INSTALLED NEW FRAME AND TWO CHANNELS IAW SRM 51-40-02 AND SRM 53-00-07 FIG 201 PG 202 REPASDR SIMA20130423010Frame · crackedONE INCH CRACK FOUND ON FRAME 5 ABOVE STR 11. PERFORMED REPAIR TO FR 5 IAW E0-EM-53MR-2125.SDR SWAA2013052016208Frame · crackedRIGHT FRAME OTBD CHORD CRACKED AT STA 727. R & R CHORD IAW EA.SDR SWAA2013052016207Frame · crackedLEFT FRAME OTBD CHORD CRACKED AT STA 727. R & R CHORD IAW EA.SDR FDEA201304230831Frame · misrepairedFRAME MISREPAIRED AT CABIN BS 535, L24L. REPAIRED IAW SRM 53-20-07, FIG 201, REPAIR 1, REV 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR FDEA201304230830Frame · misrepairedFRAME MISREPAIRED AT CABIN STATION 535, L19L. REPAIRED IAW SRM 53-20-07, FIG 202, REPAIR 1, REV 52. EO 1-5100-7-5001B3, PART 1. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR REXA2013042300641Frame · corrodedLOWER FRAME SECTOR AT FS 333.00 CORRODED BEYOND LIMITS BETWEEN S-26R AND S-27. REPAIRED IAW EA CRJ253-01517 AND ASSOCIATED 8110-3.SDR DALA1313906803Frame · dentedFWD CARGO FRAME DENTED AT BS 600 INBD & OTBD OF STR 24L. ACCOMPLISHED SRM REPAIR SRM 53-00-07, FIG 201, REPAIR 5, DET III.
Back to JASC 5311