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 ABXA010735Door Frame · corrodedAFT VENTRAL DOOR JAMB AT RBL 0 TO RBL 6, LOWER SECTION, CORRODED AND TWO POPPED RIVETS. REPAIRED AREA IAW DC-9 SRM 51-70-5.SDR 2002UALA00258Structure · corrodedCABIN AFT SHEAR DECK UPPER SURFACE CORROSION WITH EXCESSIVE MATERIAL LOSS STATION 1680 TO 1682 LBL 10 TO LBL 41. MAJOR REPAIR ACCOMPLISHED. DOUBLER AND TWO ANGLES INSTALLED.SDR AALA20020223Door Frame · corrodedTUL - FOUND AFT CARGO DOOR OPENING STATION 1155-1211 BEAM CORRODED. REPLACED LONGITUDINAL BEAMS AT STRIGNER 28R FROM STATION 1117 TO 1250.SDR DHL2002366003Frame · crackedFRAME 47 INSPECTION FOUND CRACKED FRAME 22MM X 25MM IN UPPER RADIUS RT SIDE, L/H FRAME 47 CRACKED 11MM X 17MM IN UPPER RADIUS. REQUIRES REPEAT INSPECTION 200 FC PER AMOC , S/B 53-0246 AND AD 96-13-11.SDR AALA20020183Attach Angle · corrodedTUL - FOUND AFT CARGO DOOR CUTOUT FORWARD LOWER CHORD ATTACH ANGLE CORRODED. REMOVED AND REPLACED ATTACH ANGLE PER SRM 51-01. (M)SDR DHL2002364001Frame · crackedWHILE INSPECTION PER S/B 53-0246 LEFT UPPER FRAME 47 HAS CRACK 22MM LONG X 34MM DEEP. RIGHT UPPER FRAME 47 HAS CRACK 22MM LONG X 45 MM DEEP. CRACKS REQUIRE REINSPECTION AT 100 FC PER AMOC AD 96-13-11SDR MWEA020111Intercostal · crackedINTERCOSTAL AT LONGERON 7 RIGHT, FUSELAGE STATION 256, HAS A HOLE WHICH IS CRACKED ON THE AFT END. -- REMOVED AND REPLACED INTERCOSTAL AND ANGLE.SDR MWEA020110Splice · misdrilledSTRINGER SPLICE BETWEEN KEEL BEAM AND LONGERON 29 LEFT FUSELAGE STATION 658 ABD 667 HAS DOUBLE DRILLED HOLES. -- INSTALLED NEW SPLICE.SDR MWEA020109Fitting · unserviceableREMOVED FITTING FROM LEFT KEEL AREA AT STATION 604 TO FACILITATE OTHER MAINTENANCE. -- INSTALLED NEW FITTING.SDR MWEA020125Longeron · crackedLONGERON 4 LEFT IS CRACKED AT STATION 160. -- FABRICATED AND INSTALLED LONGERON SECTIONS AND REPAIR SPLICES.SDR MWEA020107Panel · crackedMETALLIC FLOOR PANEL B8, HAS A FASTENER HOLE CRACKED AND ON THE SAME END THE OTHER CORNER IS CRACKED OFF WITH A BROKEN RIVET HEAD NEAR BY. -- FABRICATED AND INSTALLED DOUBLER.SDR MWEA020104Floorboard · dentedFLOORBOARD B11 IS DENTED AT THE FORWARD RIGHT CORNER. -- FABRICATED AND INSTALLED REPAIR DOUBLER.SDR MWEA020103Frame · damagedSTATION 658 FRAME HAS TWO HOLES IN INBOARD RADIUS OF FRAME BETWEEN LONGERON 17 LEFT AND 18 LEFT. -- FABRICATED AND INSTALLED RADIUS BLOCK AND CLIP.SDR MWEA020102Web · crackedRIGHT MAIN LANDING GEAR WHEEL WELL FORWARD UPPER KEEL WEB TO SLANT PANEL ANGLE CRACKED. -- REMOVED AND REPLACED ANGLE FITTING.SDR MWEA020098Frame · damagedSTATION 680 FRAME HAS THREE OPEN HOLES BETWEEN LONGERON 17 LEFT AND 18 LEFT. -- FABRICATED AND INSTALLED FREEZE PLUG AND RADIUS BLOCKS.SDR MWEA020096Longeron · crackedSTATION 699 LONGERON 6 LEFT IS CRACKED. -- FABRICATED AND INSTALLED LONGERON RADIUS BLOCKS, TWO SPLICES, AND ONE LONGERON FILLER.SDR MWEA020095Longeron · crackedSTATION 699 LONGERON 5 LEFT IS CRACKED. -- FABRICATED AND INSTALLED LONGERON SECTION AND SPLICES.SDR MWEA020094Longeron · crackedSTATION 699 LONGERON 4 LEFT IS CRACKED. -- FABRICATED AND INSTALLED REPAIR SPLICE AND FILLER INSTALLED.SDR MWEA020093Longeron · crackedSTATION 699 LONGERON LEFT 3 CRACKED. -- FABRICATED AND INSTALLED HAT SECTION REPAIR SPLICE, FILLER, AND SPLICES.SDR MWEA020092Shear Tie · crackedSHEAR TIE AT BULKHEAD FRAME STATION 965 HAS A CRACK LOCATED BETWEEN LONGERON 16 RIGHT AND 17 RIGHT. FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA020089Shear Tie · crackedFRAME STATION 945, SHEAR TIE HAS A CRACK LOCATED BETWEEN LONGERON 14 RIGHT AND 15 RIGHT. FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA020088Former · crackedFORWARD SIDE OF AFT PRESSURE BULKHEAD, THIRD FORMER UP FROM FLOOR ON RIGHT SIDE, IS CRACKED IN RADIUS AT OUTBOARD END. STATION 996. -- FABRICATED AND INSTALLED DOUBLERS.SDR MWEA020087Former · crackedFORWARD SIDE OF AFT PRESSURE BULKHEAD, FIRST FORMER UP FROM FLOOR ON RIGHT SIDE IS CRACKED IN RADIUS AT OUTBOARD END, STATION 996. -- FABRICATED AND INSTALLED DOUBLERS.SDR MWEA020086Former · crackedFORWARD SIDE OF AFT PRESSURE BULKHEAD, THIRD FORMER UP FROM FLOOR, LEFT SIDE IS CRACKED IN RADIUS AT OUTBOARD END. STATION 996. -- FABRICATED AND INSTALLED REPAIR ANGLES.SDR MWEA020085Former · crackedFORWARD SIDE OF AFT PRESSURE BULKHEAD, FIRST FORMER UP FROM FLOOR, LEFT SIDE IS CRACKED AT OUTBOARD END IN RADIUS, STATION 996. -- FABRICATED AND INSTALLED REPAIR ANGLES.SDR MWEA020081Skin · tool damageSTATION 699 TO 718 AT LONGERON 6 RIGHT, FUSELAGE SKIN (INTERNAL) HAS FOUR DIRLL START MARKS AND A GOUGE. -- FABRICATED AND INSTALLED SKIN REPAIRS.SDR UPS02237796Skin · crackedINSPECTION TYPE:C LT FUSELAGE SKIN HAS CRACK STARTING AT FASTENER CUT OUT BS 254 STR 10L CRACK DOES NOT NEED STOP DRILL IT RUNS FROM FASTENER HOLE TO EDGE OF SKIN, INSTALLED DOUBLER REPAIR AT LT FUSELAGE. BS 254 STR 10L AS PER B727 SRM 53-30-3 MATERIAL USESDR AUS20020252Skin · corroded(AUS) MAIN CARGO DOOR SUPPORT STRUCTURE TOP FORWARD CORNER CORRODED.CORROSION LOCATED AT ZONE 2-24, STN 48D, STRINGER 1LH TO STRINGER 3.SDR USAA020062Splice · crackedPIT - FOUND STRINGER SPLICE CRACKED .125 INCH AND .25 INCH, COMING FROM RIVET HOLES, STATION 907 54R. INSTALLED SPLICE PER SRM 51-40-02. (M)SDR USAA020061Door Frame · crackedPIT - FOUND INTERIOR DOOR FRAME SKIN 1 INCH CRAC, STATION 950, S11L INTERIOR AFT ENTRY DOOR FORWARD DOOR FRAME. INSTALLED DOUBLER PER EA 73190, T/R 53-30-07A. (M)SDR USAA020060Door Frame · crackedPIT - FOUND INTERIOR DOOR FRAME SKIN CRACKED 1 INCH, STATION 950 S11R INTERIOR DOOR FRAME SKIN FOR AFT SERVICE DOOR. INSTALLED STRAP PER SRM 53-30-07 AND EA 73190. (M)SDR ASOA02082Crossbeam · corrodedDURING C-CHECK INSPECTION IN BNA, ALL CROSSBEAMS AT FRAME 16 WERE FOUND CORRODED. THE LEFT INBOARD AND RIGHT OUTBOARD CROSSBEAMS WERE FOUND TO BE OUT OF LIMITS. MAINTENANCE REMOVED THE CORROSION ON THE LEFT OUTBOARD AND RIGHT INBOARD CROSSBEAMS IAW CPM 51-14SDR ASOA02085Crossbeam · corrodedDURING C-CHECK INSPECTION IN BNA, THE LEFT INBOARD AND RIGHT OUTBOARD CROSSBEAMS AT FRAME 16 WERE CORRODED. MAINTENANCE REMOVED AND REPLACED BOTH THE LEFT INBOARD AND RIGHT OUTBOARD CROSS BEAMS AT FRAME 16 IAW SRM 51-40-02. (M)SDR ASOA02084Crossbeam · corrodedDURING C-CHECK INSPECTION IN BNA, THE RIGHT OUTBOARD CROSSBEAM AT FRAME 36 WAS FOUND CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THR RIGHT OUTBOARD CROSSBEAM IAW SRM 51-40-02 AND 51-22-00. (M)SDR GAIA02015STShear Tie · corrodedDURING A CPCP INSPECTION DISCOVERED C3 DOOR AFT FRAME BS 1148 SHEAR TIE ABOVE STRINGER 23R IS CORRODED. ACCOMPLISHED BS 1148 SHEAR TIE REPLACEMENT ABOVE STRINGER 23R IAW B727 SRM 53-10-2 FIG 5. (M)SDR MWEA020124Web · oversizedWEB AT 15 RIGHT BETWEEN STATION 1038 AND 1059 HAS OVERSIZED HOLES. -- FABRICATED AND INSTALLED SPLICE ANGLE.SDR MWEA020123Web · oversizedREMOVED SECTION OF WEB AT STATION 1038 BETWEEN LONGERON 14 RIGHT AND 17 RIGHT. SPAR STRAP HOLES OVERSIZED. -- FABRICATED AND INSTALLED WEB SECTION AND WEB SPLICES.SDR MWEA020117Fitting · oversizedREMOVED FITTING THAT ATTACHES TO UPPER WEB AT FUSELAGE STATION 1038 LONGERON 15 RIGHT DUE TO OVERSIZED HOLES. -- FABRICATED AND INSTALLED FITTING.SDR 2002UALA00223Crease Beam · corrodedCABIN CREASE BEAM BODY STATION 758 RBL 65 HAS EXCESSIVE MATERIAL LOSS AT FASTENER HOLE. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR USAA020066Window Frame · crackedPIT - FOUND WINDOW FRAME CRACKED .5 INCH, UPPER AFT CORNER OF COCKPIT WINDOW 1R FRAME. CRACK ROUTED, AND DOUBLER INSTALLED AFTER NDT PER SRM 53-10-01. (M)SDR USAA020065Window Frame · crackedPIT - FOUND WINDOW FRAME CRACKED .5 INCH, UPPER AFT CORNER OF COCKPIT WINDOW 1L FRAME. ROUTED CRACK, NDT'D AND INSTALLED DOUBLER PER SRM 53-10-01. (M)SDR 2002UALA00227Door Frame · corrodedBODY STATION 266.5-286.5 RBL 86 DOOR CHORD CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED CHORD.SDR 2002UALA00208Crease Beam · corrodedCABIN CREASE BEAM INNER CHORD BODY STATION 740 TO BODY STATION 757 CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM INNER CHORD.SDR EIA2002007Structure · corrodedMZJ - FOUND EXFOLIATION CORROSION AT STATION 1241 RBL 2, UNDER DOUBLER FOR APU SHROUD LINE. REPAIRED CORROSION AREA PER ECRA 482-53-147-2. (M)SDR AWXA2002TESTIFrame · crackedTESTSDR AWXA2002TESTJFrame · crackedTESTSDR AWXA2002TESTFFrame · crackedTESTSDR AWXA2002TESTCFrame · crackedTESTSDR DHL2002363002Fitting · crackedDURING INSPECTION OF FRAME 47 FITTING , FOUND CRACK, 19MM LONG BY 18MM DEEP IN UPPER RADIUS OF FITTING. REQUIRES REPEAT INSPECTION AT 200 LIGHT CYCLES PER AMOC, S/B 28215 AD 96-13-11SDR 2002UALA00193Crease Beam · corrodedRIGHT STRINGER 17 CREASE BEAM INNER CHORD HAS CORROSION ON UPPER SURFACE STATION 947-993. MAJOR REPAIR ACCOMPLISHED.REPLACED CREASE BEAM.
Back to JASC 5310