JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, 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 = '5310' 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 = '5310' 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 IPXA2M71688Door Frame · crackedINSPECTION TYPE:4C, R3 DOOR JAMB FWD TORQUE BOX WEB IS CRACKED AT LOWER LIGHTNING HOLE AFT LOWER CORNER. REPAIRED R3 DOOR JAMB WEB NEAR STA 1256 BETWEEN STOP NR 7 AND Z=-19 IAW EO MD11-5310-45978-A AND STA SA EA 011-5330-01-A3643 REV IR.SDR SWAA2012021301399Crease Beam · corrodedCREASE BEAM CHORD CORRODED AT BS 390, WL 208 RT. REPAIRED CHORD PER ER AND EA.SDR FDEA201201180243Crease Beam · corrodedCREASE BEAM WEB BETWEEN STA 1300-1320 RT CORRODED CREASE BEAM WEB REPLACED IAW DWG 146N8322 AND SRM 51-40-02.SDR SWAA120410Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 360, STR 17R. REPAIRED WEB IAW SRM AND DWG.SDR COEA2012011817801Crease Beam · corrodedHEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: MATING SURFACE OF RT CREASE BEAM WEB AT FR 19-20 IS CORRODED (LENGTH 1", WIDTH 1", DEPTH .015"). FABRICATED AND INSTALLED NEW WEB - RT CREASE BEAM WEB AT STRINGER 14R BETWEEN FRAMES 19-20.SDR COEA2012011816801Crease Beam · corrodedHEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: MATING SURFACE OF RT CREASE BEAM WEB AT FRAME 17-18 IS CORRODED (LENGTH 3", WIDTH 1", DEPTH .068"). FABRICATED AND INSTALLED NEW WEB - RT CREASE BEAM WEB AT STRINGER 14R BETWEEN FRAMES 17-18.SDR COEA2012011815801Crease Beam · corrodedHEAVY CK COE / LEVEL 2 CORROSION: MATING SURFACE OF RT CREASE BEAM WEB AT FRAME 16-17 CORRODED (LENGTH 2", WIDTH 2", DEPTH .062"). REMOVED CORROSION, INSTALLED NEW OEM RT CREASE BEAM WEB AT FRAME 16-17 IAW SRM.SDR COEA2012011814801Crease Beam · crackedHEAVY CK / MAJOR REPAIR: LT CREASE BEAM WEB 23-24 DENTED ON UPPER SURFACE AND CRACKED. FABRICATED AND INSTALLED NEW WEB - LT CREASE BEAM WEB AT STRINGER 14L BETWEEN FRAMES 23-24.SDR FDEA201201170215Crease Beam · corrodedCORROSION ON MOST OTBD CREASE BEAM AT BS 1320-1330, RBL 64. CREASE BEAM ANGLE R & R IAW SRM 51-40-02, REV 104. REPAIR IS CLASSIFIED AS MAJOR.SDR ASOA201200176Unknown · corrodedLBL 27 HAS CORROSION FS 605.00 TO 574.00. REMOVED CORROSION IAW SRM 51-21-06 AND FOUND TO BE OUT OF LIMITS, REMOVED FLOORBEAM TEE IAW SRM 51-42-06 & 51-42-21. INSTALLED IAW REO 601R-53-61-3778, STEPS 1-4 AND STEPS 6 THRU 9.SDR SWAA120361Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 300 TO BS 400, LBL 68. REPAIRED WEB IAW SRM AND WG.SDR SWAA120328Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 420 TO BS 440, STR 17R. REPAIRED BEAM IAW SRM AND DWG.SDR SWAA120322Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 500D TO BS 500C, BETWEEN LBL 64 TO LBL 70. REMOVED AND REPLACED WEB PER SRM AND DWG.SDR FDEA201201160199Crease Beam · corrodedCREASE BEAM, LEFT SIDE ATTACHED SUPPORT ANGLE UPPER SKIN CORRODED AT BS 760. R & R INBD CHORD CREASE BEAM IAW SRM 53-30-13N AND DWG 143N5520 FROM STA 760 TO STA 900. MAJOR REPAIR.SDR HNAA2012011600480Structure · corrodedCORROSION FOUND AT S31, STA 207. BLENDED MINOR SURFACE CORROSION IAW SRM 51-20-11. ALODINED AND PRIMED AREA IAW AMM 51-25-03.SDR SWAA120285Door Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND R1 DOOR CUTOUT STUB FRAME CRACKED AT BS 294.5, RBL 54. REPAIRED FRAME IAW EA.SDR FDEA201201150180Shear Plate · crackedFWD FUSELAGE, FR38 4IN., 3IN. OUTBD OF SEAT TRACK 6R, SHEAR PLATE CRACKED 2 INCHES LONG. R & R FWD FUSELAGE SHEAR PLATE SUPPORT IAW FSRM 51-72-10.SDR AALA20120115TUL02Crease Beam · corrodedCORROSION ON RIGHT CREASE BEAM WEB FROM STATIONS 1380 TO 1400. REPLACED WEB PER AARD 51-10-05-1.SDR UALA2012011600317Door Frame · corrodedAFT CARGO AFT DOOR FRAME HAS A CORRODED HOLE APPROX .0250 DIA STA 1440 ABOVE STA S27R. REPAIR ACCOMPLISHED DURING HMV 4 ON SCAL LOG 9957898 PER ECRA 5310-05436.SDR FDEA201201140172Crease Beam · corrodedS-17L, CREASE BEAM INBD CHORD, STA 1240-1360 CORRODED. REMOVED CORROSION IAW SRM 51-10-02. CHECKED LIMITS FLANGE THICKNESS AND FOUND OUT OF LIMITS IAW SRM 53-60-13, FIG 101, DET VIII. REMOVED, FABRICATED IAW SRM 53-60-13. INSTALLED IAW SRM 51-40-02 AND DWG 1SDR WRLA20120113531Door Frame · corrodedFOUND MAIN DECK DOOR FRAME HAS CORROSION AT L18-19R. REPAIRED IAW EI W2012A53B-095 REV 00,01, & 02.SDR SWAA120290Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR FRAME CRACKED AT LOWER CORNER. REMOVED AND REPLACED FRAME IAW MM.SDR AALA20120113TUL20Door Frame · corrodedCORROSION ON AFT DOOR JAMB WEB UNDER RIGHT TIE-DOWN TRACK, STATIONS 1215 LONGERON 28 RIGHT. REMOVED AND REPLACED WEB SECTION PER AARD 53-10-00-24.SDR CHQA201200021Door Frame · corrodedDURING INSPECTION, THE CARGO DOOR SURROUND STRUCTURE AT FRAME 65 WAS FOUND TO BE CORRODED. MAINTENANCE REPAIRED THE CARGO DOOR SURROUND STRUCTURE AT FRAME 65 IN ACCORDANCE WITH ETD 2012-145-000521 REV A.SDR QXEA2012011300009Beam · corrodedAFT CARGO BAY LOWER EDGE BEAM HAS CORROSION. REMOVED CORROSION ON LOWER EDGE OF AFT BAG DOOR BEAM IAW SRM 51-21-00-00-02. MINIMUM REMAINING THICKNESS .054" REF NTM 51-00-02-250-801. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-01-250-801. COMPLIED WITHSDR SWAA120259Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 500, STR 17L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR DALA1201516303Door Frame · crackedL4 DOOR FWD FRAME CRACKED, BS 1680 WL 210. L=0.5". REPAIRED PER ERA 496575-14.SDR FDEA201201110098Failsafe · failedR1 DOOR FAILSAFE RING REQUIRES REMOVAL TO FOM FARME 16A RT FRAME REPAIR. REMOVED FAIL SAFE RING IAW SRM 51-40-21 AND EA 6-5310-135257B. LOCATED AND DRILLED NEW FAIL SAFE RING AT R1 DOOR IAW DWG 12R53610899 AND SRM 51-40-44. INSTALLED NEW FAIL SAFE RING AT R1SDR SWAA1201170Door Frame · corrodedAFT CARGO DOOR LOWER SILL ASSEMBLY FRAME CORRODED AT BS 787, RBL 2. REPAIRED FRAME PER EA.SDR ASOA201200099Door Frame · corrodedFS 364.00 BELLY FWD EDGE OF AVIONICS DOOR CUTOUT, FITTING FRAME CORRODED ON FORWARD SIDE FROM STRINGER 25L TO 25R BOTH LEGS OF ANGLE. INSTALLED NEW FRAME IAW DWG 601R32009 AND SRM 51-42-06.SDR ASOA201200095Door Frame · corrodedLEDT SIDE DOOR POST AT BOTTOM END HAS CORROSION DAMAGE FS 280.00 AT LBL 9.0. REPAIRED IAW REO 670-53-11-678.SDR CHQA201200011Structure · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE CARGO DOOR SURROUND STRUCTURE. REPAIRED IN ACCORDANCE WITH ETD 2012-145-000324 REVISION A.
SDR AALA20120109TUL03Door Frame · corrodedAFT CARGO DOOR JAMB BEAM STATIONS 1155 TO 1212 CORRODED. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3.SDR AALA20120109TUL05Door Frame · wornTHE FORWARD E AND E COMPARTMENT DOOR CUTOUT FRAME WEB WORN RIGHT SIDE ABOVE LATCH FITTING. REMOVED AND REPLACED THE FRAME WEB PER SRM 53-10-15-01-3 AND EA 737-53-021005.SDR SWAA120126Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM INNER CHORD CORRODED AT BS 727, STR 17R. REPAIRED CHORD IAW EA.SDR JR2R2012010600025Structure · corrodedWASTE WATER SERVICE DOOR SURROUND STRUCTURE JOINT PIECE AT STRINGER 21R CORRODED FROM FS 379 TO 394. REPLACED DIAPHRAM IAW SRM 51-42-06 AND 51-42-21.SDR SCNA12001Window Frame · crackedHIGH PITCH, LOW VOLUME SQUEAL NEAR L2 WINDOW WITH DIFFERENTIAL PRESSURE ABOVE 3.0. FOUND L3 WINDOW LEAKING AT UPPER FWD CORNER. FOUND WINDOW SEAL DETERIORATED. FOUND CRACK AT SECOND HOLE ON FWD WINDOW FRAME. CRACK RUNS THROUGH FASTENER HOLE & THROUGH RADIUSSDR FDEA201201060033Crease Beam · corrodedCREASE BEAM S17L BS 1020-1040, CORRODED. REMOVED CORROSION WITH MATERIAL LOSS OF .023 OF ORIGINAL .090 FOUND TO BE OUT OF LIMITS IAW SRM 53-40-13. R & R CREASE BEAM IAW SRM 51-40-02. MAJOR REPAIR.SDR SWAA120136Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 500A TO BS 500B, BETWEEN RBL 64 TO RBL 70. REPAIRED WEB IAW SRM AND DWG.SDR SWAA120135Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 380 TO BS 400, BETWEEN RBL 64 TO RBL 70. REPAIRED WEB IAW SRM AND DWG.SDR SWAA1201010Crease Beam · crackedCRACK ON CREASE BEAM LOCATED BS 520 AT STR 17L. REPAIRED BEAM IAW EA AND EO.SDR LR7A2012011700330Beam · crackedDURING SCHEDULED C-10 CHECK AND CENTER WING REPLACEMENT, FOUND CRACKS ON RT MLG BEAM FS 577, WL258, RBL61, HOLE F. REPAIR ACCOMPLISHED IAW LAC MEA 382-53-11-064.SDR LR7A2012011700329Beam · crackedDURING SCHEDULED C-10 CHECK AND CENTER WING REPLACEMENT, FOUND LT MAIN WHEEL WELL BEAM CRACKED FS588, WL198-200, LBL61. REPAIR ACCOMPLISHED IAW LKHEED SMP583, FIG 53-40-51.SDR LR7A2012011700296Manifold · crackedDURING SCHEDULED C-10 CHECK AND CENTER WING REPLACEMENT, FOUND LT & RT MWW MANIFOLDS (X3) CRACKED AT FS 507, LBL 61.5 & RBL 61.5, WL 142-148 AND FS 532, RBL 61.5, WL 142-148. REPAIR BY REPLACEMENT ACCOMPLISHED IAW SMP583 CHAP 51-70.SDR LR7A2012011700291Beam · crackedDURING SCHEDULED C-10 CHECK AND CENTER WING REPLACEMENT, FOUND CRACKED LT UPPER MWW ARMPIT PANEL ATTACH BEAM (WING TO FAIRING FORMER) AT FS 517, LBL 85, WL 236. REPAIR ACCOMPLISHED IAW MEA 382-57-051.SDR LR7A2012011700285Beam · crackedDURING SCHEDULED C-10 CHECK AND CENTER WING REPLACEMENT FOUND RT MLG BEAM CRACK FS 588, RBL 61, WL 258, HOLE F. REPAIR ACCOMPLISHED IAW MEA 382-53-11-049.SDR FDEA201201050021Crease Beam · corrodedRT CREASE BEAM S17R BS 450 TO 665 CORRODED. REMOVED CORROSION AND FOUND OUT OF LIMITS PER SRM 53-30-13, FIG.101, DETAIL 8. REMOVED AND REPLACED RT CREASEBEAM, PER SRM 51-40-02, AND DRAWING 143N5520. MAJOR REPAIRSDR COEA2012010407801Crease Beam · corrodedRIGHT CREASE BEAM WEB FR 34-15 HAS TOOLING MARKS AND CORROSION ON UPPER SURFACE (LENGTH 3', WIDTH 2", DEPTH .020"). REMOVED CORROSION, FABRICATED AND INSTALLED NEW SHEAR WEB IAW SRM.SDR COEA2012010406801Crease Beam · corrodedHEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: MATING SURFACE OF RT CREASE BEAM WEB AT FR 20-21 HAS LEVEL 2 CORROSION (LENGTH 2.75", WIDTH 3.5", DEPTH .012"). REMOVED CORROSION FABRICATED AND INSTALLED NEW WEB IAW ATR72 SRM.SDR SWAA120080Crease Beam · corrodedDURING SCHEDULED 8Y CHECK, FOUND L1 DOOR CREASE BEAM ANGLE CORRODED ON UPPER SURFACE. REMOVED AND REPLACED ANGLE IAW SRM.
Back to JASC 5310