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 UPS02238827Seat Track · corrodedINSPECTION TYPE:C+SI CORROSION ON SEAT TRACK FLANGE AT BS 360 BLO. CORROSION BLENDED AND FOUND TO BE OUTSIDE LIMITS, TRACK CUT AT BS 41 0 AND NEW SECTION SPLICED IN IAW SRV-SNN-02-00124H AND 00134H UPS AU THORISATION 727-53-20064SDR 0202199851Intercostal · crackedDuring an MCK in ATL, a crack was found in the intercostal that extends from station 148.5 to 160 at approx z=44. The crack extended from the upper edge of the inboard flange to the forward most lightning hole. Repaired per EA 98-190459.SDR UPS02238758Intercostal · crackedINSPECTION TYPE:C+SI CRACKED BRACKET ON INTERCOSTAL BS520 RBL15, CABIN FLOOR. BRACKET REPAIRED IAW SRM 51-40-03 FIG 1 TYP FORMED SECTION REPAIR.SDR ABXA020107Frame · corrodedAFT CARGO FRAME HAD CORROSION AROUND NUTPLATE AT FS 1140, LONGERON 30 LEFT. CORROSION WAS OUT OF LIMITS. TRIMMED OUT DAMAGED AREA AND INSTALLED REPAIR DOUBLER AND FILLER IAW DC-8 SRM 51-1-8, 53-2-0, 51-1-20D, AND REA D853-43923-MR.SDR UPS02238746Frame · crackedINSPECTION TYPE:C+SI FRAME CRACKED AT BS338-STR.13R FRAME REPAIRED IAW SRM 53-10-4 FIG 1.SDR ABXA020112Track · corrodedAFT CARGO COMPARTMENT STATION 1440 TO 1540, RIGHT BUTT LINE 60, CORROSION UNDER FLOOR BOARD CLIP NUTS. FABRICATED 8 EACH SPLICES AND REPAIR TRACK, INSTALLED AND REPAIRED AREA IAW DC-8 SRM 51-3-0, 53-2-0, 53-2-3, AND 51-1-8.SDR 0202179851Pressure Panel · crackedDuring MCK in ATL, cracks were found in the flight compartment horizontal pressure panel at statio 105. The cracks are located at sta x=-25 (1.0") and x=-35 (.75"). Repaired per EA 98-190448.SDR 2002UALA01027Shear Tie · crackedAFT PIT SHEAR TIE CRACKED AT STATION 708 BETWEEN STRINGER 27L AND 27R. MAJOR REPAIR ACCOMPLISHED. MANUFACTURED AND INSTALLED ANGLE REPAIR.SDR MWEA020413Shear Tie · damagedFORWARD CARGO COMPARTMENT FRAME STATION 446 SHEAR TIE HAS NUMEROUS ELONGATED FASTENER HOLES LOCATED BETWEEN LONGERON 28 LEFT AND 26 RIGHT. FABRICATED AND INSTALLED FORMERS.SDR MWEA020412Shear Tie · crackedAFT ACCESSORY COMPARTMENT FRAME STATION 1019. DOUBLER HAS A CRACK LOCATED BELOW LONGERON 14 LEFT. FABRICATED AND INSTALLED FORMER.SDR ABXA020108Longeron · corrodedAIR COND/PRESS COMPARTMENT AT FS 24, LONGERON 31 RIGHT WAS CORRODED AT ATTACH ANGLE ATTACHING FASTENERS. REMOVED CORRODED CLIP LONGERON TO FRAME. INSTALLED NEW ATTACH P/N 2643619-1 IAW DC-8 SRM 51-1-21A AND 51-1-24.SDR 2002UALA01009Crease Beam · corrodedSTATION 927 TO 1000 CABIN FLOOR RIGHT HAND INNER CREASE BEAM CHORD IS CORRODED. MAJOR REPAIR ACCOMPLISHED, CREASE BEAM REPLACEMENT.SDR 2002UALA01008Door Frame · crackedFORWARD ENTRY DOOR CUTOUT WEB CRACKED AT BODY STATION 294 STRINGER 12L. MAJOR REPAIR ACCOMPLISHED, INSTALLED NEW WEB.SDR UPS02238723Stringer · corrodedINSPECTION TYPE:C+SI INTERGRANULAR CORROSION S19L BS 460-440, CORROSION FOUND TO BE OUTSIDE LIMITS OF SRM 51-10-1. STRINGER REPAIR ED IAW SRM 53-10-3.SDR UPS02238719Stringer · corrodedINSPECTION TYPE:C+SI SURFACE CORROSION STRINGER 21R BS 448 APPROX SURFACE CORROSION FOUND TO BE OUTSIDE LIMITS I.A.W SRM 53-10-1. STRINGER 21 R REPAIRED I.A.W SRM 53-10-3 FIG1.SDR 2002UALA01015Crease Beam · corrodedCABIN FLOOR CREASE BEAM AT STATION 410, LBL 72, WL 208 CORRODED. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR INSTALLED.SDR UPS02238742Door Frame · crackedINSPECTION TYPE:C+SI CRACK ON FRAME BS 540 AT CARGO DOOR FITTING. CRACKED LUG OF BS 540 FRAME AT MCD LATCH SUPPORT FITTING CUT AWAY IAW SRM 51-40-3. REPAIR PARTS FABRICATED IAW SRM 51-40-3. PARTS INSTALLED IAW SRM 51-30-02 AND SRM 51-40-3.SDR ASAA0280204Door Frame · corrodedOAK - DURING C-CHECK, FOUND CORROSION ON MID CARGO BAY DOOR BEAM HORIZONTAL AND VERTICAL FACE. INSTALLED REPAIR DOUBLER PER TASK CARD 28553000. (M)SDR 0202169851Intercostal · crackedDuring an Mck in ATL, the centerline intercostal, between station 218 and 237 was found cracked.Repaired per EA 98-190476.SDR UPS02238760Web · crackedINSPECTION TYPE:C+SI CRACK TO WEB AT BS 1182 LBL54 APPROX AT ACCESS HOLE FOR PIPE WORK WEB REPLACED IAW SRM 51-20-1 FIG7 AND SRM 51-30-2SDR 2002UALA01002Door Frame · crackedCRACK IN INBOARD RADIUS OF FORWARD GALLEY DOOR CUTOUT, FORWARD FRAME JUST ABOVE STRINGER 17R. MAJOR REPAIR ACCOMPLISHEDINSTALLED DOUBLER REPAIR.SDR UPS02238787Frame · corrodedINSPECTION TYPE:C+SI INTERGRANULAR CORROSION ON FRAME WEB BS 218 LBL24 FASTENERS REMOVED, CORRODED SECTION OF FRAME WEB CUT OUT IAW 51-40-2 FIG1. PARTS FABRICATE, FRAME REPAIRED IAW SRM 51-40-2 FIGURE 1.SDR UPS02238761Bracket · crackedINSPECTION TYPE:C+SI CRACK ON SUPPORT ANGLE AT BS 178 BULKHEAD RBL24 SUPPORT BRAKET REPLACED IAW SRM 53-10-2 FIG1 ABD SRM 51-20-1 FIG 7 A ND SRM 51-30-2.SDR UPS02238718Intercostal · corrodedINSPECTION TYPE:C+SI SURFACE CORROSION ON INTERCOSTAL BETWEEN BS219+BS211 LBL 24 L/H. INTERCOSTAL FABRICATED IAW SRM 51-20-1 INTERCOSTAL INSTALLED IAW SRM 53-30-2SDR 2002UALA00983Crease Beam · corrodedCABIN CREASE BEAM WEB IS CORRODED BODY STATION 747-767, LBL 70, WL 208. MAJOR REPAIR ACCOMPLISHED. REPLACED WEB.SDR UPS02238810Butt Joint · corrodedINSPECTION TYPE:C+SI LFEC INSPECTION INDICATES MATERIAL LOSS AT BS 1080 BETWEEN S4L AND 6 L AREA REPAIRED IAW UPS ENGINEERING ORDER B727-5330-1177 APPEDIX 7.BET WEEN STRINGER 5L AND 6L AT BS 1080. BUTT JOINT RESEALED AND FASTENED IAW SRM 51-30-02.SDR 2002UALA00966Crease Beam · crackedCABIN CREASE BEAM INNER CHORD IS CRACKED AND CORRODED BS 280-360. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM.SDR 159PL0012Tie · crackedBS460 left frame tie cracked at lower fastener just above Str16Lt.SDR DLM88020622Door Frame · corrodedDURING HMV CORROSION FOUND ON HORIZONTAL FLANGE OF C3 DOOR LOWER JAMB BEAM. PRIOR SRM REPAIR FOUND IN AREA. CORROSION REMOVED. FOUR FASTENER HOLES NOTED WITH LESS THAN 2D ED. ALL DAMAGE REMOVED AND REPAIRED IAW ERA 413057-14.SDR F3LA200200160Door Frame · damagedDURING C-2 CHECK, INSPECTION REPORTED HOLE IN AFT CARGO DOOR FWD FRAME CAP WEB. FABRICATED AND INSTALLED WEB REPAIR PER SRM 51-70-13, 51-10-02 AND 51-70-13.SDR USAA020262Beam · corrodedCLT BEAM, 22 INCHES LONG, CORROSION, NO LEVEL OR TASK, STA 325, RBL 24-46. NEW T-CAP AND SPLICE PER SRM.SDR GTIA020753Beam · corrodedFTW - AFT PIT LOWER DOOR CUT OUT HAS CORROSION AT OUTBOARD BEAM SURFACE ANGLE ALONG EDGE BEAM. BEAM OUT OF LIMITS AT STATION 1188 AND STATION 1171. FABRICATED DOUBLER AND SPACER. INSTALLED DOUBLER AND SPACER. (M)SDR DHL2002745504Shear Tie · corrodedDURING C-CHECK, IN FWD CARGO SHEAR TIE HAS CORROSION AT BS 720R STR 28R. DAMAGE BEYOND LIMITS IAW B-727 SRM 53-10-1 AND 51-10-1. FABRICATED REPAIR IAW B-727 SRM 53-10-4 FIG 15. INSTALLED SHEAR TIE REPAIR IAW B-727 SRM 53-10-4 FIG 15.SDR MWEA020396Door Frame · chafedAFT RIGHT EMERGENCY EXIT DOOR JAMB IS CHAFED AT UPPER LATCH ASSY. LOCATED, DRILLED AND INSTALLED DOUBLER.SDR MWEA020395Door Frame · chafedRIGHT FORWARD EMERGENCY EXIT DOOR JAMB IS CHAFED AT THE TOP LATCH. LOCATED, DRILLED, AND INSTALLED DOUBLER.SDR AALA20020844Beam · corrodedTUL - FOUND DOOR BEAM HAS NUMEROUS AREAS OF CORRSOSION. DOUBLER INSTALLED PER AARD 53-10-03. (M)SDR AWXA200200535Crease Beam · crackedYVR - MAJOR REPAIR - DURING C-15 CHECK A CRACK WAS FOUND ON THE HORIZONTAL FLANGE OF THE RT INNER CHORD FO CREASE BEAM AT BS 639, RBL 64. MAINTENANCE REMOVED AND REPLACED THE RT CREASE BEAM INNER CHORD AT BS 639, RBL 64 PRE DRAWING 65-47973, AND B737-200 SRM SDR UPS02438681Web · corrodedINSPECTION TYPE:C R/H WING CENTER SECTION STA 1241 BULKHEAD CANTED PRESSURE DECK ANGLE REAR FACE CORRODED ADJACANT #5, 6 & 7 FASTENER HOLE AREA AS INDICATED. RH WING CENTER SECTION STA 1241 BULKHEAD CANTED PRESSURE DECK ANGLE REAR FACE CORROSION ADJACANT #SDR UPS02438613Seat Track · corrodedINSPECTION TYPE:C U/D - SEAT TRACK FOUND CORRODED AT STA 530-540 RBL 46". SEAT TRACK REPLACED AT U/D BS 480-530 RBL 46" AS PER SRM 51-10-01 PG. 8 AND SEAT TRACK REPAIR AT U/D STA 530-550 RBL 46" AS PER SRM 53-10-05 FIG.1A. CORROSION BLEND OUT SIZE 0.035" XSDR COOSDR020165Shear Tie · corrodedAFT CARGO COMP. BS 950A SHEAR TIE CORRODED BETWEEN STR 28R AND STR 29R.SDR UPS02438666Splice Plate · crackedINSPECTION TYPE:C NLG W/W RH AFT LWR CORNER STA 400 INTERNAL SPLICE PLATE CRKD AT FILLET AREA BY 1" AS MARKED. NLG W/W RH BS 400 BETWEEN STR 38R TO 44R REPAIRED AS PER EO 747-5330-3520 APPENDIX B CIRCLE 5.SDR COOSDR02144Door Frame · corrodedAFT CARGO COMPARTMENT DOOR, DOOR JAMB BEAM, CORRODED.SDR COOSDR02131Door Frame · crackedFORWARD CARGO COMPARTMENT STA 520 AND AFT CARGO COMPARTMENT STA 1057.60 DOORWAY FRAMES, CRACKEDSDR USAA020247Doubler · crackedPIT - FOUND DOUBLER CRACKED .5 INCH, FORWARD SERVICE DOOR FRAME LOWER CORNER HI-LOCK IN REPAIR DOUBLER. FABRICATED AND INSTALLED DOUBLER PER SRM 51-70-11. (M)SDR AALA20020853Shear Tie · crackedTUL - FOUND CRACK IN SHEAR TIE. REMOVED AND REPLACED SHEAR TIE SRM 51-01. (M)SDR AALA20020821Door Frame · corrodedTUL - FOUND CARGO CUT OUT LOWER FRAME HAS CORROSION ON OUTBOARD FACE STATION 1155-1211, SEVERAL AREAS. INSTALLED NEW FRAME PER SRM 51-01. (M)SDR C1HA200292021Shear Tie · corrodedSHEAR TIE HAS LIGHT SURFACE CORROSION AT STA 965 JUST OUT BOARD OF RBL 28SDR UPS02438669Splice Plate · crackedINSPECTION TYPE:C NLG W/W LH AFT LWR CORNER SPLICE PLATE CRACKED THROUGH 1EA FASTENER HOLE AT FILLET AREA BY 1.5" AS MARKED. NLG W/W LH AFT LWR CORNER SPLICE PLATE REPAIRED AS PER EO B747-5330-3520 APPENDIX B CIRCLE NOTE 5 JUST AT BS 400 BTN STR 38L AND STSDR UPS02438649Door Frame · crackedINSPECTION TYPE:C M/D - RT NR 4 DOOR FWD LWR CORNER CUTOUT REVEAL CRACKED. R4 DOOR LOWER CORNER REVEAL REPAIRED AS PER SRM 53-10-04 FIG 84.SDR UPS02438636Web · crackedINSPECTION TYPE:C M/D - BS 1220 LBL 98-116 FLR BEAM WEB FOUND CRACKED. FLOOR BEAM WEB REPAIR CARRIED OUT AS PER SRM 51-40-02 FIG.1
Back to JASC 5310