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 DALA1315220682Crease Beam · corrodedMID CABIN LT CREASE BEAM, BS 466, LBL 64, HAS CORROSION ON INNER CHORD UPPER LIP. REPLACED CREASE BEAM INNER CHORD IAW SRM 51-40-02.SDR FDEA201305291125Door Frame · crackedCABIN - R3 DOOR FWD JAMB LOWER WEB BS 1256 FOUND CRACKED. REPAIRED IAW SRM 53-40-15, FIGURE 201, REPAIR 3, REVISION 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR DALA13026440950Beam · corrodedCORROSION ON LOWER BEAM OF AFT CARGO COMPARTMENT DOOR FRAME BS 1155 TO 1212. CORROSION ON LOWER BEAM WAS REMOVED, MEASURED, AND FOUND OUT OF LIMITS. REPAIR WAS INSTALLED IAW SRM 53-05, FIG 1, 2, 3, 51-10-3, PAR 14, 21, 26.SDR WX0A071598Door Frame · crackedVENTRAL DOOR SURROUND REVEAL CRACK IN UPPER LEFT CORNER. STOP DRILLED CRACK AND INSTALLED REPAIR DOUBLER.SDR FDEA201305291136Crease Beam · corrodedCREASE BEAM AT FS 680, RBL 64 INBD CHORD CORRODED. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-30-13, FIG 101, PAGE 105 DETAIL VIII, SECTION BB. R & R CREASE BEAM IAW SRM 51-40-02 AND DWG 143N5520. REPAIR IS CLASSIFIED AS A CATEGORY `A` MAJOR REPASDR FDEA201305291113Crease Beam · corrodedBS 1020-1040, RT CREASE BEAM WEB UPPER SURFACE FOUND CORRODED. R & R IAW DWG 144N5140, SHT 2, REV C. REPAIR IS MAJOR.SDR SIMA20130528008Gusset · corrodedDURING B INSPECTION, FOUND THE LAVATORY AREA RT BEAM TOP GUSSET HAS CORROSION. REMOVED CORRODED RT BEAM TOP GUSSET, DRILLED AND INSTALLED A NEW TOP GUSSET IAW SRM 51-40-02 51-20-03. THE ACFT WAS RETURNED TO SERVICE.SDR CHQA20130528201Door Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE LOWER AFT FRAME OF THE MAIN CABIN DOOR. DOOR FRAME REPAIRED IAW SRM 51-40-02.SDR CHQA20130528198Door Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE LOWER AFT FRAME OF THE SERVICE DOOR AROUND THE NUT PLATE HOLES. THE FRAME WAS REPAIRED IAW ETD 2013-145-011083.SDR DALA13026430950Doubler · crackedCRACK ON INTERNAL DOUBLER AT THE LOWER AFT DOOR FRAME CORNER BS 423.5 BETWEEN L26 - 27R OF THE FWD CARGO COMPARTMENT. IDENTIFIED CRACK ON PRODUCTION DOUBLER AND TRIMMED OUT FABRICATED REPAIR PARTS AND PERFORMED REPAIR IAW SRM 53-05, FIG 105 WITH DOUBLER, TRISDR DALA13024770991Door Frame · damagedDURING SCHEDULED MX INSPECTION, CORROSION WAS NOTED AT THE AFT LOWER CARGO COMPARTMENT DOOR JAMB. REPAIRS WERE INCORPORATED IAW SRM 53-05, FIGURE 123 AND 51-30-5.SDR SWAA2013060416751Crease Beam · corrodedR2 TOP OF CREASE BEAM CORRODED. R & R BEAM IAW SRM AND DWG.SDR COEA2013071121900Structure · chafedDURING HEAVY CHECK, FOUND CHAFE ON CARGO DOOR SWITCH BOX INNER SURFACE BETWEEN FRAMES 17 AND 18. REPAIR IAW SRAS DT/S-3536/13.7868.SDR UALA2013052803658Crease Beam · crackedDURING C1 CHECK, BS 1681 CREASE BEAM AT RBL 48 WAS FOUND CRACKED THRU THE HORIZONTAL FLANGE. REPAIRED IAW EA 130519, REV IR.SDR COEA2013062510900Crease Beam · damagedDURING HEAVY CHECK, LT CREASE BEAM FR 29-30 HAS TOOL MARKS ON THE UPPER SURFACE. FABRICATED AND REPLACED LT CREASE BEAM SHEAR WEB FROM FRAME 29-30 IAW SRM.SDR COEA2013062509900Crease Beam · corrodedDURING HEAVY CHECK, FOUND CORROSION ON LT CREASE BEAM INNER CHORD IS CORRODED AFT OF FRAME 33. REPLACE WITH OEM PART.SDR COEA2013061908900Failsafe · corrodedDURING HEAVY CHECK, FRAME 13 FAILSAFE HAS CORROSION BETWEEN S20-21R. REPAIR IAW SRM 53-00-00.SDR COEA2013061807900Crease Beam · damagedDURING HEAVY CHECK, LT CREASE BEAM WEB FR 30-31 HAS TOOLING DAMAGE ON THE UPPER SURFACE. FABRICATED AND REPLACED LT CREASE BEAM WEB IAW SRM.SDR COEA2013061406900Shear Web · damagedDURING HEAVY CHECK, LT CREASE BEAM WEB FR 28-29 HAS TOOLING DAMAGE ON THE UPPER SURFACE. FABRICATE AND REPLACE LT CREASE BEAM SHEAR WEB FROM FRAME 28-29 IAW SRM. MAJOR REPAIR.SDR COEA2013061402900Crease Beam · corrodedDURING HEAVY CHECK, FOUND LT CREASE BEAM INNER CHORD SPLICE AT FR 29 CORRODED. REPLACED WITH NEW PART.SDR ASAA2013052595061Crease Beam · corrodedCABIN FLOOR RT CREASE BEAM HAS CORROSION SPOT AT BS 380. ACFT GROUNDED. INSTALLED REPAIR ANGLES IAW SRM 51-70-12-0G-0, FIG 1.SDR FDEA201305251086Crossbeam · crackedMAIN DECK CARGO COMPARTMENT CROSSBEAM FOUND CRACKED AT STATION FRAME 31 BETWEEN SEAT TRACK Y1456 AND Y1959. CRACKED CROSSBEAM REPAIRED IAW SRM 53-10-15, FIG 212, REV 23 AND EA 6-5310-T0300636. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR UALA2013052803647Crease Beam · corrodedCREASE BEAM WEB AT R4 DOOR HAS CORROSION ON TOP SURFACE. REMOVED CORROSION DAMAGE IS 100 PERCENT OF THICKNESS OUT OF LIMITS IAW SRM 53-60-15. R & R BEAM IAW SRM 51-40-02 AND DWG 146N8122. MAJOR REPAIR.SDR ASAA2013052495004Door Frame · corrodedAFT CARGO DOOR CUTOUT FWD FRAME REPAIR DOUBLER IS CORRODED. FOUND ON REMOVAL OF TRANSITION PANEL. ACFT GROUNDED. R & R AFT CARGO DOOR CUTOUT FWD FRAME AND FACTORY DOUBLER IAW SRM 51-40-02.SDR DALA13024630952Beam · corrodedCORROSION ON LOWER DOOR FRAME BEAM STA Y=1155-1212 AT AFT CARGO COMPARTMENT. (C3) (MRB 53-019-02). CORROSION WAS BLENDED OUT IAW SRM 51-10-3. PAR 21 AND 14 (UT) AND REMAINING THICKNESSES WERE FOUND OUT OF LIMITS IAW DWG 5936038, REV "A" AND SRM 53-05 FIG 123.;SDR ASAA2013052395252Structure · corrodedLT WHEEL WELL MANIFOLD ASSY UPPER CHORD HAS BARE METAL AND CORROSION. ACFT GROUNDED. REMOVED LT WHEEL WELL MANIFOLD UPPER CHORD FABRICATED NEW CHORD TREATED, PRIMED TOPCOATED AND INSTALLED IAW SRM 51-30-01-0G-0, 51-40-02-0G-0 AND AMM 51-21 21-307-014 AND 51SDR SWAA2013060616842Window Frame · crackedLEFT E-F WINDOW POST FRAME CRACKED INDICATION AT THE SECOND LOWER FASTENER HOLE. REPAIRED FRAME IAW EA.SDR DALA13025310126Failsafe · crackedBS 955 RT BULKHEAK FITTING FAILSAFE STRAP FOUND CRACKED. REPAIRED IAW IAW ER/A 513102-14AD, REV ORIG.SDR ASAA2013052295276Beam · corrodedFWD ENTRY DOOR THRESHOLD CENTER SUPPORT CORRODED NEAR AFT END IN PREVIOUSLY BLENDED AREA. ACFT GROUNDED. REMOVED CORROSION, FOUND TO BE OUT OF ALLOWABLE LIMITS IAW SRM 53-10-15-1A1. R & R SUPPORT IAW SRM 51-40-02-0G0 AND DWG 69-02471.SDR SWAA2013053116634Stop Fitting · crackedAFT BULKHEAD DOOR LT MIDDLE STOP FITTING CRACKED. R & R MIDDLE STOP IAW SRM.SDR QXEA2013052201044Beam · crackedFWD CARGO DOOR BEAM CRACKED AT CENTER LOCATION. MATCHED DRILLED NEW NR 2 BEAM IAW SRM 51-40-07-02-01. ALODINED, PRIMED HOLES & INSTALLED NUTPLATES IAW SRM 51-21-10-02-01, 51-25-10-02-01, 51-42-05-02-01. INSTALLED NR 2 BEAM IAW SRM 51-42-05-02-01, 51-40-15-SDR FDEA201305221058Crossbeam · crackedMAIN DECK CARGO BAY CROSSBEAM FOUND CRACKED AT STATION FRAME 30 BETWEEN SEAT TRACK Y1456 AND Y1959. ACCOMPLISHED REPAIR AS IAW SRM 53-10-15, FIG 212 AND EA 6-5310-T0 300636 PART 1. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR FDEA201305211056Crease Beam · damagedLEFT CREASE BEAM INBD ANGLE BS 1180-1290, HAS SEVERAL SHORT EDGE MARGIN HOLES. FOUND TO BE OUT OF LIMITS IAW SRM-51-40-06. R & R LT CREASEBEAM INBD CHORD IAW-SRM-51-40-02 AND DWG 146N5590, CAT "A" MAJOR REPAIR.SDR DALA1315740683Crease Beam · corrodedCREASE BEAM WEB HAS HEAVY CORROSION BETWEEN BS 996-1020, S17L. R & R PART IAW SRM 51-40-02.SDR DALA1315730683Crease Beam · corrodedCREASE BEAM WEB HAS CORROSION BETWEEN BS 960-984, S17L. R & R PART IAW SRM 51-40-02.SDR FDEA201305211055Crease Beam · damagedCREASE BEAM INNER ANGLE HAS DOUBLE DRILLED HOLE AT BS 1210, RT SIDE. CHECKED LIMITS OF DOUBLE DRILLED HOLE ON CREASE BEAM, STA 1180-1290 RT SIDE. CREASE BEAM FOUND TO BE OUT OF LIMITS IAW-51-40-06. R & R INBD CREASE BEAM FROM BS 1180-1290, RT SIDE IAW-51-SDR SWAA2013052916578Window Frame · crackedRIGHT FLIGHT DECK WINDOW FRAME FASTENER HOLE CRACKED AT NR 8 FASTENER BETWEEN E-F POST. REPAIRED FRAME IAW EA.SDR SWAA2013052916576Window Frame · crackedLEFT FLIGHT DECK WINDOW FRAME FASTENER HOLE CRACKED AT NR 8 FASTENER BETWEEN E-F POST. REPAIRED FRAME IAW EA.SDR SWAA2013052916575Window Frame · crackedNR 3 CO-PILOT WINDOW, FWD FRAME CRACKED IN NR 7 HOLE. REPAIRED FRAME IAW EA.SDR SWAA2013052916574Window Frame · crackedNR 3 CO-PILOT WINDOW, FWD FRAME CRACKED IN #5 HOLE. REPAIRED FRAME IAW EA.SDR DALA13025260127Failsafe · crackedUT INSPECTION, FOUND CRACK INDICATION ON FAILSAFE STRAP AT THE RT BULKHEAD AT BS 955. BS 955 AT RT BLKHD FAIL SAFE STRAP REPAIR CARRIED OUT IAW PRI 513478-14AD, REV 0, REV 1 & REV 2. PERMANENT REPAIR COMPARED AND COMPLIED WITH FINAL ERA 513478-14AD, REV ORIGISDR DALA13025250127Failsafe · crackedUT INSPECTION FOUND CRACK INDICATION ON FAILSAFE STRAP AT THE REAR SPAR LT BULKHEAD AT BS 955. BS 955 LT BULKHEAD FAIL SAFE STRAP REPAIR CARRIED OUT IAW PRI 513476-14, AD REV 0, REV 1 & REV 2. PERMANENT REPAIR COMPARED AND COMPLIED WITH FINAL ERA 513476-14ADSDR FDEA201305211053Crease Beam · corrodedBS 740-760, RT CREASE BEAM INBD ANGLE LOWER SURFACE FOUND CORROSION AT BS 750. CORROSION REMOVED IAW SRM 51-10-02, REV 109. FOUND WITHIN ALLOWABLE DAMAGE LIMITS IAW SRM 53-30-15, FIG 101, DAMAGE 1, REV 109. REPAIR IS MINOR.SDR FDEA201305211052Crease Beam · corrodedBS 1172 RT CREASE BEAM WEB UPPER SURFACE FOUND CORRODED. R & R WITH NEW SHEAR WEB, FABRICATED IAW DWG 144N5210 SHT1, REV.- AND INSTALLED IAW DWG 144N5200, SHT.2, REV B. REPAIR IS MAJOR.SDR FDEA201305201035Crossbeam · misrepairedMAIN DECK CARGO COMPARTMENT CROSSBEAM, FRAME 27 BETWEEN -Y450 AND -Y953 MISREPAIRED. REPAIR CARRIED OUT IAW EA 6-5310-167620. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR FDEA201305201034Crossbeam · misrepairedMAIN DECK CARGO COMPARTMENT CROSSBEAM, FRAME 29 BETWEEN -Y450 AND -Y953 MISREPAIRED. REPAIR CARRIED OUT IAW EA 6-5310-167620. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR FDEA201305201032Crossbeam · misrepairedMAIN DECK CARGO COMPARTMENT CROSSBEAM, FRAME 30 BETWEEN -Y450 AND -Y953 MISREPAIRED. REPAIR CARRIED OUT IAW EA 6-5310-167620. REPAIR CLASSIFIED AS MAJOR GMM 6-2-100, REV 116.SDR FDEA201305201030Crossbeam · misrepairedMAIN DECK CARGO CROSSBEAM, FRAME 30 BETWEEN Y450 AND Y953 MISREPAIRED. REPAIRED IAW SRM 53-10-15, FIG 212, REV 23. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116. EO 6-5100-7-5000D, PART 1.SDR ASOA2013060703816Door Frame · corrodedRIGHT LOWER DOOR POST AT FS 280 CORRODED. REPAIRED IAW REO 690-53-11-526.SDR ASOA2013060703812Door Frame · corrodedLIGHT LOWER DOOR POST AT FS 280 CORRODED. REPAIRED IAW REO 690-53-11-526 IAW NDTM PT.1, 51-20-006-250-A01.
Back to JASC 5310