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 FDEA201306271410Crease Beam · misrepairedCREASE BEAM MISREPAIRED AT BS 986 LT SIDE INBD. INSTALLED NEW CREASE BEAM IAW SRM 51-40-02 AND DWG 144N5152. CAT "A" MAJOR REPAIR.SDR SWAA2013081219103Door Frame · crackedR1 DOOR CUTOUT STUB FRAME CRACKED AT STATION 295. R&R CUTOUT IAW DRAWING & SRM.SDR SWAA2013073018661Door Frame · corrodedFWD CARGO DOOR CUT OUT FWD FRAME CLOSURE WEB CORRODED AT STATION 400, STRINGER 23R. REPAIRED WEB IAW SRMSDR SWAA2013070117751Door Frame · crackedAFT GALLEY DOOR CUTOUT CLOSEOUT FRAME BETWEEN THE FWD UPPER STOP PAD AND THE UPPER CAM PLATE CRACKED. R&R FRAME SRM.SDR REXA2013062601227Structure · crackedFWD ELECTRICAL BAY SKIN CRACKED UNDER ADG HYD HAND PUMP. REPAIRED FWD ELECTRICAL BAY SKIN UNDER ADG HYD PUMP IAW EO R53400.SDR DALA13033139258Scoop · crackedDURING SPECIAL VISIT, ATTEMPTS TO WELD CRACKS IN RAM AIR SCOOP WERE UNSUCCESSFUL, ERA 516402-14 ISSUED. ACCOMPLISHED SECTION I OF ERA 516402-14, REV O.SDR DALA2014121006495Roller Tray · damagedAFT CARGO ROLLER TRAY DAMAGED. PERFORMED PERMANENT REPAIR ON AFT CARGO ROLLER TRAY IAW ERA 516401-14, REV ORIG AND SRM 53-00-53.SDR SWAA2013080818958Crease Beam · corrodedRT CREASE BEAM WEB CORRODED BETWEEN STATION 747 & STATION 767. REPAIRED WEB IAW SRM.SDR A6WA2013071041053Structure · corrodedCORROSION FOUND OUT OF LIMITS AT FS 574+10 LBL 9. R & R IAW SRM 53-61-49.SDR K11A2013070825003Window Frame · corrodedMAIN DECK WINDOW FRAME CORRODED, BS 710.SDR FDEA201306251389Beam · corrodedCENTER WHEEL WELL RT DIAGONAL BOOT STRAP HAS CORROSION. BS 1461 TO 1490, WL 100. REMOVED AND REPLACED PER SRM 51-31-01, REV. 52. NEW BOOT STRAP FABRICATED PER EA 1-5310-T0300908, PART 1, REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100, REV. 116.SDR FDEA201306251388Beam · corrodedCENTER WHEEL WELL LT DIAGONAL BOOT STRAP HAS CORROSION BS 1461 TO 1490, WL 100. REMOVED AND REPLACED IAW SRM 51-31-01, REV. 52. STRAP FABRICATED IAW EA 1-5310- T0300892, PART 1. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV. 116.SDR C77A20130625001Finger Doubler · corrodedFORWARD CARGO DOOR CUTOUT STRUCTURE AFT FINGER DOUBLER, HAS CORROSION AT X=8399.7-8662.2, Y=290-310. R & R AFT FINGER DOUBLER IAW SRM 51-41-01 AND 51-43-01.SDR SWAA2013062717655Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME 2ND LOWER CORNER FASTENER HOLE ALONG THE E-F POST CRACKED. REPAIRED FRAME IAW ACO.SDR FDEA201306251398Crease Beam · corrodedMDC LT CREASE BEAM INBD ANGLE AT BS 1290 -1370 , HAS CORROSION , SCRATCHES , AND DOUBLE DRILLED HOLES. FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15, FIG 101, DETAIL VIII. R & R LT CREASE BEAM INBD ANGLE IAW SRM 51-40-02 AND DWG 146N8326.SDR UHLA2013062400275Door Frame · corrodedFWD CARGO DOOR ENTRYWAY HAS CORROSION ON AFT AIDE OF BUMPER PLATE NUTPLATES ATTACH STRUCTURE. R & R FWD CARGO DOOR CUTOUT LOWER AND AFT SEAL RESTS. MAJOR REPAIRSDR FDEA201306241380Structure · crackedONE CRACK WAS FOUND. THE CRACK, 18MM LENGTH AT ZONE B,J AREA OF RT SIDE NOSE SECTION /FR 12A FITTING. REPLACED IAW EO E6-5340-7-5002 C1 PART7 & PART 8.SDR IPXA3179013Structure · damagedPREVIOUS BLENDOUT AT FASTENER 1.75" FWD OF FRAME 38.2 AT STR 47R REQUIRES REMOVAL OF ADJACENT REPAIR DOUBLER MATERIAL THICKNESS IS 0.098. REPAIRED IAW EO A300-5310-51178-A.SDR QXEA2013062401110Sealant · missingPASSENGERS & F/A REPORTED VERY LOUD NOISE COMING FROM FWD RT EXIT. PASSENGER HAD TO BE MOVED. DIVERTED AND ACCOMPLISHED A UNEVENTFUL LANDING. GROUND RAN ACFT FOUND EVIDENCE OF AIR LEAKAGE FROM FWD & AFT POSITIONS DITCHING DAM AND UPPER EXIT MEET ON FUSELAGESDR ALGA062520137506Window Frame · corrodedCABIN WINDOW FRAME FOUND CRACKED DURING INSPECTION.SDR UALA2013062404374Line · leakingFOUND UPPER FUEL OIL COOLER LINE LEAKING. SECURED LINE NO LEAKS FOUND. RAN ENG 5 MIN NO LEAKS NOTED.SDR UALA2013062704511Panel · corrodedAPPEARS TO BE AREA OF CORROSION & DELAMINATION BELOW ADP EXHAUST OUTLET. REMOVED DAMAGED AREA FROM PANEL 191KL AND REPAIRED IAW SRM. SEALED PRIMED AND PAINTED IAW MM 51-21-00.SDR SWAA2013071118119Crease Beam · corrodedLT CREASE BEAM WEB UPPER SURFACE CORRODED AT BS 869. REPAIRED WEB IAW SRM.SDR K11A2013062325001Window Frame · corrodedREPAIR WINDOW FORGING FROM STA 720B - 720D DUE TO PREVIOUSLY INSTALLED DOUBLER AT BS 720C - 720D RT SIDE.SDR SWAA2013070117762Crease Beam · corrodedLT CREASE BEAM WEB UPPER SURFACE CORRODED AT BS 450. R&R WEB IAW SRM AND DWG.SDR SWAA2013070117761Crease Beam · corrodedLT CREASE BEAM WEB UPPER SURFACE CORRODED AT BS 403. R&R SHEAR WEB IAW SRM & DWG.SDR SWAA2013070117763Crease Beam · corrodedLT CREASE BEAM WEB UPPER SURFACE CORRODED AT BS 757. R&R WEB IAW SRM.SDR DALA13032989258Structure · crackedRAM AIR INLET UPPER AFT EDGE CRACKED. PERFORMED WELD REPAIR IAW SRM 55-30-05. FPI AND HFEC IAW PS 900-6-3, NR 2 AND 06-10-01.001, NO CRACKS.SDR FDEA201306221369Crease Beam · corrodedBS 1260-1270, RT CREASE BEAM INBD ANGLE HAS THREE AREAS OF HEAVY CORROSION. REPAIRED IAW EA F-5310-167516, PART 1. MAJOR REPAIR.SDR DALA13031063755Crease Beam · corrodedDURING INSPECTION FOUND L2 DOOR, DOOR CUTOUT LOWER SILL, CREASE BEAM HAS SEVERAL AREAS OF CORROSION. MX REMOVED CREASE BEAM AND INSTALLED NEW CREASE BEAM IAW DWG 147A8501 AND SRM 51-40-02 AND 51-40-05.SDR SWAA2013070918044Door Frame · crackedAFT CARGO PIT BS 794 FORWARD DOOR FRAME UPPER CLOSE OUT WEB LOWER EDGE CRACKED. R&R WEB IAW SRM & DRAWING.SDR QXEA2013062101119Door Frame · corrodedAFT PASSENGER DOOR AFT FRAME HAS CORROSION IN MULTIPLE LOCATIONS. REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 13 MIN THICKNESS NOTED .058" REF NTM 51-00-04-910-801 REV 9. CONFIRMED CRACK FREE REF NTM 51-00-06-910-801, PT REV 9. RECEIVED ADVANCED INFORMATISDR QXEA2013062101115Door Frame · corrodedAFT PASSENGER DOOR FWD FRAME CORRODED IN MULTIPLE LOCATIONS. REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 13 MIN THICKNESS NOTED .056" REF NTM 51-00-04-910-801, REV 9. CONFIRMED CRACK FREE REF NTM 51-00-06-10-801, PT 1, REV 9. RECEIVED ADVANCED INFORMATION SDR DALA13030873216Crossbeam · bentDURING INSPECTION, FOUND BEND ON CROSSBEAM LOCATED IN FWD CARGO BAY FR 32 BETWEEN STR 37L TO STR 37R. REPLACED CROSSBEAM IAW SRM 51-72-11 AND DWG.SDR FDEA201306211367Crease Beam · corrodedMDC RT CREASE BEAM AT BS 1290-1405 HAS CORROSION, TOP AND BOTTOM SURFACES INCLUDED. REMOVED CORROSION IAW SRM 51-10-02. CHECKED LIMITS ON INBD CHORD FOUND OUT OF LIMITS IAW SRM 53-60-15, FIG 101, DETAIL VIII. R & R STRUCTURE IAW SRM 51-40-02 AND DWG 146N8SDR SWAA2013071218170Crease Beam · corrodedRT CREASE BEAM INNER CHORD CORRODED AT STATION 294. R&R BEAM IAW SRM.SDR FDEA201306201354Frame · misrepairedFUSELAGE FRAME AT BS 1921, LONGERON 51R MISREPAIRED. REPAIRED IAW EA1-5310-T0300934 PART 1. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100 REVISION 116.SDR CHQA20130620245Beam · corrodedDURING INSPECTION, CORROSION WAS FOUND AT THE FWD SCREW HOLES ON THE SERVICE DOOR THRESHOLD BEAM. THE BEAM WAS REPAIRED IAW SRM 53-21-02.SDR SWAA2013070117756Crease Beam · corrodedRT CREASE BEAM WEB CORRODED AT STA 694, RBL65. REPAIRED WEB IAW SWA EA.SDR SWAA2013070117755Crease Beam · corrodedLT CREASE BEAM WEB CORRODED BETWEEN STA 694 TO STA 727, LBL 65. REPAIRED WEB IAW SWA EA.SDR SWAA2013070117754Crease Beam · corrodedCABIN FLOOR CREASE BEAM UPPER FLANGE CORRODED BETWEEN STA 694 TO STA 727, LBL 65. REPAIRED BEAM IAW SWA EA.SDR SWAA2013070117753Crease Beam · corrodedCABIN FLOOR CREASE BEAM UPPER FLANGE CORRODED AT STA 694, RBL 65. REPAIRED BEAM IAW EA.SDR ABXA20130620466Beam · corrodedLEFT WHEEL WELL TRANSVERSE BEAM BS 1021 HAS CORROSION ON OTBD LOWER TEE. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED SECTION AND REPAIRED IAW SRM 51-70-12, FIG 1, ACFT WAS GROUNDED.SDR SWAA2013062717683Window Frame · crackedLEFT NR 3 WINDOW E&F FRAME 2ND HOLE FROM BOTTOM HFEC HOLE PROBE CRACKED. REPAIRED FRAME IAW SWA EA.SDR SWAA2013062717656Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME 2ND LOWER CORNER FASTENER HOLE ALONG THE E-F POST CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2013080118738Crease Beam · corrodedRT CREASE BEAM INNER CHORD CORRODED BETWEEN STATION 947 TO STATION 992. R&R CHORD IAW SRM & DRAWING.SDR CALA2013062100437Door Frame · crackedR1 DOOR STUB FRAME CRACKED AT BOTTOM TWO HOLES BS 291.50, WL 210.00 INTERIM REPAIR IAW ECRA 5311-01611,SDR SWAA2013062717682Window Frame · crackedLEFT NR 3 FLIGHT DECK WINDOW FRAME CRACKED AT THE SECOND LOWER FASTENER HOLE FROM THE BOTTOM. REPAIRED FRAME IAW SWA EA.SDR SWAA2013062617611Window Frame · crackedRIGHT NR 3 FLIGHT DECK WINDOW FRAME CRACKED AT THE THIRD LOWER FASTENER HOLE FROM THE BOTTOM. REPAIRED FRAME IAW EA.SDR R61A201306180548Door Frame · dirtyCREW REPORTED LOUD WHISTLING NOISE COMING FROM THE LT EMERGENCY OVERWING EXIT DURING FLIGHT. AN EMERGENCY WAS NOT DECLARED AND PLANE LANDED WITHOUT INCIDENT. MX REMOVED LT OVERWING EXIT HATCH, INSPECTED SEAL AND NO DEFECTS FOUND. MX FOUND DEBRIS IN THE DOOR
Back to JASC 5310