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 SH52002F00000Sill · crackedDURING SCHEDULED INSPECTION FOUND LOWER WINDSHIELD SILL CRACKED (PRIMARY STRUCTURE) ON LEFT AND RIGHT SIDE OF COCKPIT. BOTH CRACKS ARE AT FS 235.0 WL 110.5 AND RUN ALONG THE BASE OF A WEB LEFT CRACK IS 1.5 INCHES LONG, RIGHT IS 1.0 INCH LONG. CRACKS IN THIS SDR SWAA020056Post · crackedDURING SCHEDULED 1/2D CHECK, FOUND F/O'S UPPER WINDOW POST CRACKED. REPAIRED POST PER SRM.SDR MWEA020049Structure · damagedlAVATORY TRUCK DAMAGED AIRCRAFT AT STATION #257-294 AND BETWEEN LONGERON 22-23 LEFT. -- REPAIRED AREA IN ACCORDANCE WITH STRUCTURAL REPAIR MANUAL ("SRM") 53-04, FIGURE 38 SHEET #23.SDR ASAA0210019Crossbeam · crackedPAE - DURING SCHEDULED C-CHECK, FOUND CARGO DOOR CROSSBEAM AT BS 444, WATERLINE 60 CRACKED. REPAIRED PER EA. (M)SDR GTIA020191Structure · corrodedFORWARD LAVATORY HAS CORROSION AT LOWER FLOOR, INSIDE TRASH CAN AREA CORROSION FOUND AFTER TRASH CAN REMOVAL. MATERIAL OUT OF LIMITS. FABRICATED PART. INSTALLED PART IAW MD80 SRM 51-30-2. (M)SDR DHL2002362002Fitting · crackedWHILE INSPECTING FRAME 47, FOUND CRACK LEFT SIDE LENGTH 44MM, RT SIDE 22MM DEPTH 42MM. REQUIRES 200 FC REINSPECT. PERFORMED CHAMFER TO CRUICIFORM FITTING RT AND LEFT SIDE PE S/B 53-0246SDR 02FDEA00049Crease Beam · corrodedCORROSION AROUND BROKEN FASTENER IN THE CREASE BEAM AT BS 1170, WL 208, RBL 61. R&R CREASE BEAMSDR 2002UALA00052Shear Tie · crackedSTA 298.5 LT SHEAR TIE CRACKED AT STRINGER 28-29.SDR 02FDEA00035Door Frame · damagedBS 625 TO 765 UPPER CARGO DOOR FWD AND AFT DOOR JAMB STRUCTURAL DAMAGE. REMOVED AND REPLACED DOOR PER EA 8-5330-56188.SDR 2002UALA00038Crease Beam · corrodedSTATION 312-360, WL 208, LBL 56 INBOARD CHORD ON CREASE BEAM HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. CHORD REPLACED.SDR SWAA020035Web · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE WEB CRACKED AT BS 294, STR 12L. REPAIRED WEB PER SRM.SDR MWEA020028Doubler · crackedRIGHT AFT PYLON WEB DOUBLER P/N 9912246 AT STATION 1038 HAS CRACKS EMINATING FROM THE UPPER STRAP ATTACHMENT HOLES. -- FABRICATED AND INSTALLED DOUBLER.SDR MWEA020027WebTHE AFT PYLON BULKHEAD HAS OVERSIZED HOLE WHERE THE UPPER PYLON STRAP ATTACHES TO IT. -- FABRICATED AND INSTALLED WEB AND DOUBLERS.SDR MWEA020026Web · oversizedRIGHT AFT PYLON SPAR WEB (P/N 9958154-21) UPPER HOLES ARE OVERSIZED. -- FABRICATED AND INSTALLED WEB.SDR MWEA020035Gusset · corrodedGUSSET CORROSION AT STATION 541, LONGERON 28 RIGHT -- REMOVED CORROSION. REMOVED, FABRICATED AND INSTALLED NEW GUSSET.SDR MWEA020034Bracket · misdrilledFUSELAGE FRAME TO FLOOR BRACKET HAS ONE MISSING FASTENER AND HOLE THROUGH FRAME IS MISDRILLED AT STATION 1257 RIGHT -- FABRICATED AND INSTALLED REPAIR DOUBLER.SDR MWEA020033Frame · gougedSTATION 769 FRAME AT LONGERON 17 LEFT IS GOUGED -- FABRICATED AND INSTALLED REPAIR DOUBLER.SDR MWEA020032Frame · gougedSTATION 693 FRAME AT LONGERON 17 LEFT IS GOUGED -- FABRICATED AND INSTALLED REPAIR DOUBLER.SDR 2002UALA00026Shear Tie · corrodedDAMAGE TO FRAME BUILD UP AT STATION 740 BETWEEN STRINGER 13R-14R, EXCESS MATERIAL REMOVED ON CLEAN UP TO SHEAR TIE PART. MAJOR REPAIR ACCOMPLISHED. FABRICATED NEW SHEAR TIE AND INSTALLED.SDR AALA20020662Door Frame · corrodedTUL - FOUND CORROSION AT AFT CARGO DOOR LOWER SILL FRAME, BETWEEN STATION 1155-1212. REMOVED AND REPLACED CARGO DOOR BEAM PER SRM 51-01. (M)SDR AALA20020026Door Frame · dentedTUL - FOUND DENT IN FORWARD CARGO DOOR CUTOUT UPPER CORNER. REPAIRED DENTED AREA PER ESO 80559. (M)SDR CA020104019Tube · misinstalled(CAN) WHEN INTERIOR OF THE A/C WAS REMOVED IT WAS NOTICED THAT THE TUBULAR STRUCTURE WELDED JOINT ON THE LT SIDE JUST FWD OF SPAR ON DIAGONAL BRACE BELOW THE FRONT OF REAR WINDOW IS MISSING A WELD. IN THE SAME AREA NOTICED A CLUSTER GUSSETS WITH INCOMPLETE SDR ABXA010674Panel · corrodedRIGHT SLANT PANEL HAD CORROSION AROUND NUT PLATES, LOWER EDGE FROM INBOARD TO OUTBOARD. REPLACED SLANT PANEL IAW DC-9 SRM 51-30-2, 51-10-4, 51-30-1 AND 51-20-6.SDR ABXA010671Angle · crackedLEFT WHEEL WELL ATTACH ANGLE CRACKED IN RADIUS, JUST OUTBOARD OF THE TRAP PANEL, ABOVE THE HYDRAULIC SERVICE ACCESS. REPLACED ANGLE IAW DC-9 SRM.SDR 2002UALA00007Crease Beam · corrodedCABIN STATION 312 TO 344 CREASE BEAM ANGLE AT FORWARD ENTRY DOOR IS CORRODED ADJACENT TO SCUPPER DRAIN. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM CHORD.SDR AALA2002054Beam · corrodedTUL - FOUND AFT CARGO DOOR BEAM HAS CORROSION FROM 1160 TO 1207. BLENDED OUT CORROSION PER ESO 80559. (M)SDR UPS02237514Door Frame · crackedINSPECTION TYPE:C+SI ON REMOVAL OF DAMAGED BRACKET, FWD LWR DOOR STOP FITTING FOUND DAMAGED AND DOOR CUTOUT FRAME CRACKED AT LWR FWD FASTENER FITTING HOLE AFT CARGO DOOR CUTOUT FWD FRAME.SDR UPS02837487Shear Tie · crackedINSPECTION TYPE:C2 STA 1860 LONG 3R CLIP/SHEAR TIE IS CRACKED. STOP DRILLED CRACK, NDT VERIFIED NO CRACKS. FABRICATED AND INSTALLED REPAIR ANGLES IAW SRM 53-2-0 FIG 1B.SDR UPS02837387Shear Tie · crackedINSPECTION TYPE:IN AFT PRESS BULKHEAD CANTED WEB 2 SHEAR TIES CRACKED RT SIDE BETWEEN L10 & L11 45 ANGLE BRACKET ATTACHED TO CONTROL BULKHEAD CRACKED AS MARKED. REMOVED EXISTING FASTENER FOR REPAIR. FABRICATED REPAIR DOUBLER. INSTALLED DOUBLER.SDR SWAA013446Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 827, WL 148 AND LBL 1. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA013420Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB CORRODED, BS 616 TO BS 639 RT SIDE. REPAIRED BEAM WEB PER SRM.SDR EISA20010151Skin · tornACCOMPLISHED SHEET METAL REPAIR AREA FORWARD OF RT OUT FLOW VALVE, STA 1166, STR. 24R.CORRECTIVE ACTION:CUT OUT DAMAGED AREA. FABRICATED DOUBLER .071 2024-T3 8" X 12" IAW B727 SRM 53-30-3, FIG. 3. TREATED & PRIMED AND INSTALLED DOUBLER IAW B727 SRM 51-10-2 & SDR 2001UALA02473Beam · corrodedCABIN C-ZONE STATION 852, LBL 54, UPPER TRANSBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM TRANSBEAM SPLICE.SDR SWAA013415Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BELTFRAME SHEAR TIE CORRODED, BS 842, BETWEEN STRINGER 28L AND 28R. REPAIRED SHEAR TIE PER SRM.SDR ASAA0140183Shear Tie · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON SHEAR TIE AT BS 500C, LBL 3 TO RBL 3 AND WL 149. REPAIRED IAW SRM. (M)SDR SWAA013407Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB CORRODED, BS 867 AND BS 887, LT SIDE. REPAIRED CREASE BEAM PER SRM.SDR SWAA013389Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED, BS 360, BETWEEN STRINGERS 14L AND 15L. REPAIRED SHEAR TIE PER SRM.SDR SWAA013387Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEBS CORRODED, BS 790 RT SIDE AND BS 639 TO 663 LT SIDE. REPAIRED WEB SECTIONS PER SRM.SDR F3LA200100139Web · corrodedDURING C-7 INSPECTION, INSPECTION REPORTED KEEL BEAM WEB CORRODED FROM B.S. 787 TO B.S. 807, RBL 10. FABRICATED AND INSTALLED REPLACEMENT WEB PER SRM 53-10-2, ITEM 33, PAGE 32, 41.SDR 2001UALA02450Crease Beam · corrodedCORROSION ON THE LT CREASE BEAM INNER CHORD P/N 143N5520-27 AT BODY STATION 758 LBL 64 STRINGER 17L. MAJOR REPAIR ACCOMPLISHED. REMOVED COMPLETE SECTION OF CREASE BEAM INNER CHORD AND INSTALLED NEW SECTION.SDR 2001UALA02445Crease Beam · corrodedMID CABIN CREASE BEAM INNER CHORD BODY STATION 1020 LBL 63 HAS SURFACE CORROSION ON UPPER FLANGE. MAJOR REPAIR ACCOMPLISHED. REPLACED INNER BULB ANGLE WITH SPLICE AT BODY STATION 1010.SDR ASAA0110660Shear Tie · crackedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE BS 420, STRINGER 26L-27L CRACKED. REPAIRED SHEAR TIE PER SRM. (M)SDR SWAA013365Beam · crackedDURING SCHEDULED 1/4D CHECK, FOUND RT SIDE STRINGER 18A SHEAR BEAM CRACKED AT BS 706. REPAIRED SHEAR BEAM PER SRM.SDR 2002F00159Shear Tie · crackedFOUND SHEAR TIE IS CRACKED AT STATION 787 STRINGER 6R. (M)SDR 2002F00156Shear Tie · crackedSHEAR TIE IS CRACKED AT STATION 727A STRINGER 3R, 4R AND 5R. (M)SDR 2002F00124Shear Tie · crackedFOUND SHEAR TIE CLIP IS CRACKED AT STATION 616 STRINGER 5R. (M)SDR 2001UALA02432Beam · corrodedBODY STATION 852 LBL 33 TRANSBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW SECTION AND SPLICES.SDR 01FDEA01084Door Frame · crackedAFT LWR CORNER NR 1 CARGO DOOR FRAME CRACKED BS 600. REPAIRED DOOR FRAME IAW FEDEX SRM 51-30-02.SDR SIMA200201712Door Frame · corrodedLEVEL 2 CORROSION ON CARGO DOOR CUT OUT LOWER EDGE. BLENDED OUT CORROSION IAW EMB GST 5054/01 AND GST-4140/01. (M)SDR 2002F00357Seal · damagedFLT 2588 - HLN - DURING CLIMB-OUT, CABIN PRESSURE WAS LOST. CREW AND PASSENGERS UTILIZED OXYGEN MASKS AND FLIGHT CONTINUED TO DESTINATION. CABIN DOOR SEAL HAD A HOLE IN IT. INITIALLY WAS DEFERRED PER MEL. FOUND HOLE POKED IN PASSENGER DOOR SEAL, REPLACED D
Back to JASC 5310