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 SWAA043674Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 907, BETWEEN STRINGER 25R AND STRINGER 26R, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA043673Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 767, STRINGER 27L, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR ASA0440356Crease Beam · damagedPAE - FWD SERVICE DOOR, DAMAGE ON WEB. REMOVED DAMAGE ON CREASE BEAM WEB, FABRICATED REPAIR PARTS AND INSTALLED. (K)SDR ASAA0480616Door Frame · gougedOKC - HV-CHECK, TWO MOUNTING HOLES GOUGED AT BOTTOM FRAME OF LEFT OVERWING EXIT. INSTALLED DOUBLER PER EA 53-20-01679. (M)SDR ASAA0480611Spacer · corrodedOKC - HV-CHECK, AFT CARGO BAY DOOR JAMB BEAM SPACER IS CORRODED. REPLACED SPACER. (M)SDR ASA0440342Crease Beam · corrodedPAE - FOUND CORROSION ON CREASE BEAM CHORD, MOPSILL. REPLACED PER SRM. (M)SDR ASA0440343Shear Tie · corrodedPAE - FOUND CORROSION ON SHEAR TIE. REPLACED PER SRM. (M)SDR SWAA043645Door Frame · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPARTMENT FRAME AT BS 787, RBL 10, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 2004UALA01222Shear Tie · corrodedSHEAR TIE CORRODED BEYOND LIMITS AT STA 1400. INSTALLED NEW SHEAR TIE.SDR 2004UALA01221Shear Tie · corrodedSHEAR TIE IS CORRODED BEYOND LIMITS AT STA 1400 BETWEEN STR 30 AND 29R. REPLACED SHEAR TIE.SDR ASA0440298Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE UPPER SURFACE. REPAIRED PER SRM. (M)SDR ASA0440336Shear Tie · corrodedPAE - FOUND CORROSION ON SHEAR TIE. REPLACED SHEAR TIE. (M)SDR ASA0440325Crease Beam · corrodedPAE - FOUND CORROSION ON INBOARD CHORD OF RT CREASE BEAM, MOPSILL. REPLACED MOPSILL, CREASE BEAM. (M)SDR SWAA043627Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 295 TO BS 299, RBL 55, CORRODED. REMOVED AND REPLACED WEB SECTION PER SRM.SDR ASA0440288Shear Tie · corrodedPAE - FOUND CORROSION ON FRAME TO SKIN ANGLE. REPAIRED PER SRM. (M)SDR USAA041093Support Beam · corrodedBFM - S1-CHECK - SUPPORT BEAM, 2.15 X 1.0 X .036 INCH AND 1.73 X 1.70 X .052 INCH. CORROSION; LEVEL 2; TASK NR JA-260-53500, MAIN CABIN Y1292, FR 66-68. (K)SDR SWAA043622Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 330 TO BS 335, RBL 55, CORRODED. REMOVED AND REPLACED WEB SECTION PER SRM.SDR ASA0440287Shear Tie · corrodedPAE - FOUND SHEAR TIE UPPER SURFACE CORRODED. REPAIRED PER SRM. (M)SDR ASA0440285Shear Tie · corrodedPAE - FOUND SHEAR TIE UPPER SURFACE CORRODED. REPAIRED PER SRM. (M)SDR ASA0440314Crease Beam · dentedPAE - FOUND CORROSION ON INBOARD CREASE BEAM CHORD, MOPSILL. REPLACED CREASE BEAM CHORD. (M)SDR USAA041086Beam · corrodedBFM - S1 CHECK - BEAM, 2.0 INCH X 1.2 INCH X 0.049 INCH AREA, CORROSION; LEVEL 2; TASK NR JA 260-53500, MAIN CABIN FLOOR BTW FR 66-68, BI - Y1292. REMOVED AND REPLACED BEAM ASSY IAW SRM. (K)SDR C2XA04TY180Shear Tie · corrodedDURING C-CHECK THE LEFT AND RIGHT FRAME 65 AND FRAME 68 SHEAR CLIPS WERE FOUND CORRODED. REPAIRED IAW SRM 51-30-01 AND IC2004-145/5946. AIRCRAFT RETURNED TO SERVICE.SDR USAA041128Structure · corrodedBFM - FOUND PROFILE Z-ASSY CORRODED .781 INCH LONG BY .843 INC WIDE BY .054 INCH DEEP, CABIN MAIN, Y-1805, FRAME 76-77. REMOVED AND REPLACED PROFILE Z-ASSY PER SRM 53-41-14, 51-74-00, 51-42-11. (M)SDR QXEA200500086Structure · damagedPDX - AC RECEPTACLE BASE DAMAGED. REMOVED DAMAGED RECEPTACLE BASE. INSTALLED NEW BASE PER SRM 51-42-06. FABRICATED AND INSTALLED NEW PARTS IAW EA R-53-239.SDR QXEA200500085Frame · damagedPDX - FRAME FOR AC RECEPTACLE BOX BENT AT FLANGE. REMOVED DAMAGED FRAME AND INSTALLED A NEW FRAME PER SRM 51-42-06.SDR 2004UALA01206Structure · corrodedMAIN CABIN AT STA 1640 & RBL 8 HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. INSTALLED "J" ANGLE REPAIR.SDR ASA0440308Crease Beam · corrodedPAE - FOUND CORROSION ON UPPER LOBE INTERIOR CORROSION ON CREASE BEAM WEB. REPLACED CREASE BEAM WEB. (M)SDR ASA0440306Crease Beam · corrodedPAE - FOUND CREASE BEAM CHORD CORRODED. REPLACED PER SRM. (M)SDR CA041209001Structure · vibration(CAN) VERT SIGNIFICANT RUMBLE/VIBRATION DURING CLIMB AND CRUISE. A/C ROUTED TO HANGAR FOR INVESTIGATION. NOTE: MORE INFO. WILL FOLLOW AS BECOME AVAIL.SDR N382005F00000Door Frame · crackedDURING AC 4000 LANDING INSPECTION, FOUND APPROX 1INCH CRACK AT THE UPPER FORWARD RADIUS OF DOOR FRAME. STOP DRILLED CRACK AND REPAIRED WITH AN OVERLAY DOUBLER IAW THE SRM. OVERLAY INSTALLED WET WITH PRC 1440. (K)SDR ASOA04989Plate · crackedDURING A C-CHECK IN MCN, THE CARGO DOOR FLOOR SILL PLATE WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE CARGO DOOR FLOOR SILL PLATE IAW ASA EO 600-53-0117. (M)SDR 2004UALA01193Crease Beam · corrodedCABIN CREASE BEAM ANGLE CORRODED AT FS 1410 LBL 68. DAMAGED CAUSED BY TYPICAL CABIN CORROSION. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED REPAIR ANGLE AND FILLER.SDR ASA0440282Crease Beam · corrodedPAE - FOUND CORROSION ON L-ANGLE OF RIGHT CREASE BEAM. REPAIRED PER SRM. (M)SDR ASA0440284Crease Beam · corrodedPAE - FOUND CREASE BEAM CHORD CORRODED. REPAIRED PER SRM. (M)SDR ASAA0480595Door Frame · crackedHV-CHECK-FORWARD ENTRY DOOR JAMB WEB AFT SIDE AT CRACKED. REMOVED DAMAGE, INSTALLED REPAIR FILLER AND DOUBLER.(K)SDR AWXA200401409Support · corrodedSAL - MAJOR REPAIR - DURING C-10 CHECK EXFOLIATION CORROSION WAS FOUND ON CABIN SUPPORT STRUCTURE AT RBL 60 BETWEEN BS 350 AND BS 365.25. MAINTENANCE REMOVED CORRODED SUPPORT STRUCTURE AT RBL 60 FROM BS 350 TO BS 365.25; INSTALLED NEW REPLACEMENT SUPPORT STRUSDR SWAA043553Structure · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED BETWEEN BS 380 AND BS 440, STRINGER 8L. REMOVED AND REPLACED STRUCTURE SECTION PER SRM.SDR SWAA043552Structure · crackedDURING SCHEDULED D-CHECK, FOUND STRUCTURE CRACKED BETWEEN BS 787 AND BS 867, STRINGER 8L. REMOVED AND REPLACED STRUCTURE SECTION PER SRM.SDR MWEA040218Frame · dentedFRAME STATION 313 LONGERON 21 LEFT HAS A DENT WITH IN 1 INCH OF LONGERON. FABRICATED AND INSTALLED DOUBLER.SDR SWAA043533Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR FRAME CUTOUT, LOWER FWD STOP FITTING, WEB DOUBLER CRACKED AT BS 303.9, STRINGER 16L. REMOVED AND REPLACED FRAME CUTOUT WEB DOUBLER PER SRM.SDR EIA2004164Tie · crackedM/D BS 920 LEFT O/B TENSION TIE AFT SIDE CRACKED. TENSION TIE REPAIRED PER SRM 51-30-02 AND SB 747-53-2371 FIG 3.SDR DHL2004873559Fairing · crackedRT MLG DOOR JAMB FAIRING CRACKED 0.875, XW 3.125 AFTER EXISTING REPAIR (MAJOR REPAIR). REMOVED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 12-02-04, DWG W90-R12 REV IR DATED 11-18-04 DWG BOEING 5651221. REMOVED CRACKED FAIRING IAW SRM 51-1-21 PG 1. FABRICATED NESDR DHL2004873544Beam · damagedMAIN CARGO COMPT AFT PRESSURE BULKHEAD VERTICAL BEAM HOLES MISDRILLED AT STA 1766.000 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW DWG W90-R15 AND FAA FORM 8110-3 NOV 30,2004. CLEANED, TREATED AND PRIMED MISDRILLED HOLES AREA IAW SRM 51-1-8B. PERFORMED NDT INSDR 04FDEA03332Structure · corrodedBULK CARGO FLOOR STRUCT RT SIDE FR 64 TO 67 FLOOR STRUCT W/MULTIPLE CORROSION FROM TOP TO UNDERNEATH SURFACE. REMOVED AND REPLACED T- PROFILE AT FR63 TO FR 67 RBL 37 RT IAW A310 SRM 51-40-21.SDR SWIA200414597Buttstrap · corrodedFRAME 34-38, YL479.00, LEFT BUTTSTRAP IS CORRODED. ITEM FOUND AT C-CHECK INSPECTION. BUTTSTRAP REPLACED IAW EMB 120 SRM 51-40-02, 51-22-00, 51-25-00.SDR ASAA0410678Crease Beam · crackedPAE, D-CHECK: CREASE BEAM WEB IS CRACKED. REPLACED CREASE BEAM WEB.SDR ASAA0410658Door Frame · damagedPAE - DURING D-CHECK, ELONGATED HOLES IN WEB. REPLACED WEB. (M)SDR ASAA0410657Failsafe · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON FAIL/SAFE CHORD. REPLACED FAIL/SAFE CHORD. (M)SDR ABXA040391Shear Tie · crackedUPPER END OF SHEAR TIE CRACKED AT LONGERON 14 RIGHT, AFT OF FRAME 1056. REMOVED AND REPLACED SHEAR TIE IAW DC-9 SRM 51-30-5.SDR MWEA040216Beam · corrodedCORROSION AROUND LIGHTENING HOLE ON TOP OF NR 3 RIGHT FORWARD EMERGENCY EXIT DOOR BEAM. FABRICATED AND INSTALLED DOUBLER.
Back to JASC 5310