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 BJNA020827Beam · corrodedFOUND LEVEL 2 CORROSION 4 EACH PLACES ON UPPER SURFACE OF BEAM 294.5 BETWEEN LBL 10 TO RBL 20. REMOVED CORROSION AND TREAT. REPAINT SURFACE CHECK LIMITS. (M)SDR UPS02239191Web · crackedINSPECTION TYPE:C CRACK FOUND IN NLG FWD L/H PRESSURE WEB AT BS 235 APPROX. CRACK REMOVED IAW SRM 51-40-2. HFEC INSPECTION CONFIRMED CRACK REMOV AL. REPAIR PARTS FABRICATED AND REPAIR INSTALLED IAW SRM 51-40-2, FI G. 1.SDR UPS02239119Web · crackedINSPECTION TYPE:C LIGHTENING HOLE IN AFT AIRSTAIR TORQUE BOX AT BS 1243 RHS IS CRACKED WEB REPAIR CARRIED OUT IAW SRM 51-10-4SDR MWEA02504Stiffener · damaged1 EACH DOUBLE DRILLED HOLES ON AFT PRESSURE BULKHEAD BETWEEN RADIAL STIFFENER 18&20 LEFT. -- REAMED HOLES AND INSTALLED BUSHING.SDR MWEA020503Stiffener · damaged2 EACH DOUBLE DRILLED HOLES ON AFT PRESSURE BULKHEAD RADIAL STIFFNERS 2&6 LEFT. -- REAMED HOLE UP AND INSTALLED 2 EACH BUSHINGS.SDR MWEA020510Seal · crackedLEFT AND RIGHT AFT PRESSURE BULKHEAD SEAL RETAINERS ARE CRACKED. -- DRILLED UP AND INSTALLED SEAL RETAINERS.SDR 0203079952Door · crackedDuring Hck in DHN, aft cargo door was found to be cracked at the #2 forward doorstop. Repaired per EA 99-191323.SDR TSAA0251185Frame · crackedCRACK LOCATED AT BS 807, S-14L. CUT AND REMOVED DAMAGED AREA, VERIFIED CRACK REMOVAL UTILIZING HFEC METHOD NO DEFECTS NOTED, FABRICATED AND INSTALLED REPAIR ANGLES AND FILLER FROM .063 IN 2075-T6 IAW APPROVED FASTENERS WENT WITH BMS 5-95 SEALANT PER TABLE I ASDR TSAA0251188Window Frame · crackedRT SIDE WINDOW FRAME CORNER FASTENER HOLE CRACK AT BS 727B. VERIFIED CRACK ON WINDOW FRAME ASSY BY UTILIZING HFEC ROTAR PROBE METHOD, REAMED WINDOW FRAME FASTENER HOLE UNTIL REMOVAL OF CRACK. VERIFIED CRACK REMOVAL BY HFEC ROTARY METHOD, ENLARGED AND INSTALLSDR TSAA0251187Window Frame · crackedRT SIDE WINDOW FRAME CORNER FASTENER HOLE CRACK AT BS 380. CRACK ON WINDOW FRAME ASSY BY UTILIZING HFEC ROTARY PROBE METHOD, REAMED WINDOW FRAME FASTENER HOLE UNTIL REMOVAL OF CRACK, CRACK REMOVAL BY HFEC ROTARY METHOD, ENLARGED, INSTALLED FREEZE PLUG TO FASTSDR UPS02239167Doubler · crackedINSPECTION TYPE:C SUSPECT CRACK AT FASTNER BESIDE REPAIR AT NLG WHEEL WELL LEFT FWD PR ESS WEB AT BS 269.5 REPAIR DOUBLER REMOVED IAW SRM 51-30-2 NDT CARRIED OUT CRACK CONFIRM ED & END OF CRACK MARKED. DOUBLER AND FILLERS FABRICATED AND INSTALL ED IAW SRM SDR UPS02239197Web · crackedINSPECTION TYPE:C CRACKS FOUND IN NLG W/WELL PRESSURE WEB AT BS 269.5, 4" BELOW THE CE ILING ON THE R/H PRESSURE WEB AREA. NEW WEB AND DOUBLERS FABRICATED AND INSTALLED IAW DRAWING 65-18414SDR 2002UALA01306Crease Beam · corrodedCABIN FLOOR STRUCTURE OUTER CREASE BEAM HAD EXCESSIVE CORROSION ON UPPER SURFACE AT STATION 736 RBL 64 STRINGER 17R. MAJOR REPAIR ACCOMPLISHED. REMOVED COMPLETE SECTION OF CREASE BEAM AND INSTALLED NEW SECTION.SDR 02FDEA00583Torque Box · corrodedCORROSION AROUND FASTENER HEADS IN AVIONICS COMPT NOSE GEAR WHEEL WELL TOP TORQUE BOX (FROM FRAME 13 TO 15A).SDR 0203269867Intercostal · crackedDuring Mck in ATL, the inbrd edge of the floor support intercostal at station 180 was found with two cracks between x=20 and x=30.SDR UPS02239198Skin · corrodedINSPECTION TYPE:C CORROSION FOUND ON FUSELAGE SKIN AT BS 1181, BETWEEN S-5L AND S-6L. TO REMOVE CORROSION COMPLETELY, SKIN CUT-OUT WAS MADE FROM BS 1145 T O BS 1180, BETWEEN S-5L AND S-10L. REPAIR WAS CARRIWED OUT IAW SMRO EO 2002-044-002 R2. REF. UPS EO BSDR UPS02239121Intercostal · crackedINSPECTION TYPE:C CRACK ON INTERCOSTAL AT BS 1130 BBL 6 R INTERCOSTAL REMOVED IAW SRM 51-30-02 INTERCOSTAL FABRICATED IAW SRM 51-20-1 FIG 7 AND INSTALLED IAW SRM 51-30-2SDR 2002UALA01299Crease Beam · corrodedCABIN AFT RIGHT HAND GALLEY DOOR CREASE BEAM INBOARD CHORD CORRODED ALONG DOOR OPENING AREA STATION 947 - 1006 RBL45 - RBL 47. MAJOR REPAIR ACCOMPLISHED. REPLACED CHORD ANGLE.SDR GTIA021210Door Frame · corrodedFTW - FOUND AFT CARGO DOOR JAMB BEAM CORRODED FS 1155-1212. REMOVED DOOR JAMB BEAM FROM STATION 1147-1250 DRILLED AND LOCATED HOLES IN NEW BEAM. INSTALLED NEW DOOR JAMB BEAM. (M)SDR QXEA0201219Stop Fitting · wornPDX - LOWER FORWARD BAG DOOR STOP AT STATION 564.5 HAS WEAR TO STOP. REPAIRED IAW RD 8-53-104.SDR QXEA0201203Stop Fitting · gougedPDX-CARGO DOOR APERTURE AFT UPPER DOOR STOP IS GOUGED. REPAIRED IAW RD8-53-104.SDR QXEA0201189Stop Fitting · wornPDX-CARGO DOOR APERTURE LOWER AFT DOOR STOP IS WORN. REPAIRED IAW RD8-53-104.SDR QXEA0201168Stop Fitting · wornPDX- LOWER FORWARD BAG DOOR STOP AT STATION 564.5 HAS .060 WEAR INTO STOP. REPAIRED IAW RD8-53-104.SDR 2002UALA01292Door Frame · crackedFORWARD GALLEY DOOR CUTOUT FORWARD FRAME IS CRACKED AT TOP INBOARD CORNER. MAJOR REPAIR ACCOMPLISHED. REPLACED STUB FRAME.SDR AALA20021163Beam · corrodedTUL - FOUND CORROSION ON AFT CARGO DOOR THRESHOLD BEAM AT STATION 1163-1174. REMOVED AND REPLACED BEAM PER AARD 53-10-00. (M)SDR BJNA020813Door Frame · gougedFOUND RIGHT SIDE FORWARD EDGE OF AFT CARGO DOOR OPENING IS GOUGED AND TORN. CUT OUT DAMAGED AREA AND FABRICATED STACKED DOUBLER REPAIR PER B737 SRM 53-30-3 FIG 46. INSTALLED REPAIR PER B737 SRM 31-30-2, 51-20-4, 53-30-3 FIG 46. (M)SDR AMTA200201059Door Frame · crackedFWD FUSELAGE SECTION, RT ECS BAY CUTOUT FRAME FOR ACCESS DOOR CRACKED WITH CORROSION AT STAND OFF ATTACH POINT JUST FORWARD OF FORWARD HINGE ARM ATTACH POINT, TOP FWD OF O/B FRAME FORMER, TM3. REMOVED AND REPLACED CRACKED AND CORRODED CHORD ON O/B SIDE OF RT SDR UPS02439071Fitting · crackedINSPECTION TYPE:C RH BS 1480 BULKHEAD EXTENSION FITTING BOLT HOLE #11 FOUND CRACK. RH BS 1480 BULKHEAD #11 HOLE AT EXTENSION FITTING REAMED TO 0.625" AND BUSHING INSTALLED AS PER SB 747-53A2390 REWORKED HOLE INSPECTED NIL CRACK FOUND AS PER NTM PART 6 51-SDR 0203059951Bulkhead · crackedDuring HCK in DHN, the aft pressure bulkhead web was found cracked under Z=63.5 stiffener approx. 10" outboard of the ventral door jamb. Repaired per EA 99-191325.SDR AUS20020964Frame · cracked(AUS) RT OUTBOARD FRAME CRACKED. FRAME IS LOCATED AT BS727 STRINGER NO18.SDR DHL2002363515Skin · corrodedC-check/STA. 1415 STR. 49R and STA. 49L on the interior of the skin there is 4SQ" of moderate corrosion at STR. 49R and 7SQ" of moderate corrosion at STR. 49LCorrective action/Removed corrosion IAW A300 SRM 51-40-11. UT thickness checked per NTM 51-20-00 49L SDR HEEA080516Bushing · oversizedLT CABIN ROOF PANEL HAS OVERSIZED BUSHINGS.SDR ABXA030220Door Frame · crackedL1 DOOR JAMB LOWER AFT CORNER HAD STAINLESS STEEL REPAIR. REMOVED DOOR CLOSE OUT PANEL TO FOM. FABRICATED 3 DOUBLER, 5 DOUBLER AND FILLERS, INSTALLED ALL IAW DC-8 SRM 53-2-0, 51-1-21 AND 51-3-0.SDR 02FDEA00565Door Frame · crackedAFT FRAME OF FWD CARGO DOOR CUT OUT CRACK AT THE TIP DOOR STOP FITTING BETWEEN STR 19R - 20R. REMOVED AND REPLACED ANGLE & FILLER ON AFT FRAME PER EA 7-5310-65859.SDR BJNA020811Shear Tie · corrodedFOUND CORROSION IN FORWARD PIT AT STA 500 LBL 2 TO RBL 2 FRAME LOWER LEG, LEVEL 2 CORROSION. CUT AND REMOVED CORROSION FROM SHEAR TIE LEG. FABRICATED AND INSTALLED SHEAR TIE REPAIR AND DOUBLER IAW SRM.SDR BJNA020809Structure · corrodedFOUND CORROSION ON 4 SCREW HOLES AT RBL 20 BETWEEN BS 986.5 TO BS 967, CORROSION LEVEL 2. (M)SDR QXEA0201205Stop Fitting · gougedPDX-CARGO DOOR APERTURE AFT UPPER DOOR STOP IS GOUGED. REPAIRED IAW RD8-53-5461.SDR QXEA0201204Stop Fitting · gougedPDX-CARGO DOOR APERTURE FORWARD UPPER DOOR STOP IS GOUGED ON FUSELAGE. REPAIRED IAW RD8-53-5461.SDR UPS02439163Skin · crackedINSPECTION TYPE:C RH BS 1480 B/H #12 HOLE CRACK FOUND AT SKIN THROUGH THICKNESS RUNNING FWD & AFT REFER ATTACHED SKETCH. (STR R33 TO R34) RH BS 1480 B/H #12 HOLE AT SKIN REAMED TO 0.710 " DIAMETER AND BUSHING REPAIR CARRIED OUT AS PER RS # R-53-43-34784. NSDR UPS02439162Fitting · crackedINSPECTION TYPE:C RH BS 1480 B/H EXTENSION FITTING #9 HOLE CRACK FOUND, APPROX 1/16", RUNNING FWD & AFT REFER ATTACHED SKETCH. ( STR R33 TO R34) RH BS 1480 B/H EXTENSION FITTING #9 HOLE REAMED TO 0.850" DIAMETER AND BUSHING REPAIR CARRIED OUT AS PER RS #RSDR UPS02439101Web · crackedINSPECTION TYPE:C RH BS 320 NOSE W/W VERTICAL BEAM WEB ONE INSULATION BLANKET STANDOFF HOLE CRACK FOUND APPROX 7/8" LONG AS MARKED. (WL 160 TO 170) VERTICAL BEAM WEB REPLACED AS PER DWG 624U0005 SHEET 4 AND SRM 51-10 -01 PG 8.SDR UPS02439097Web · crackedINSPECTION TYPE:C FWD CARGO - STA 900 (LBL 46", BELOW FLOOR 6") FRAME WEB FOUND CRACK AS MARKED. REPAIRED WEB AT FWD CARGO STA 900 LBL 46" AS PER SRM 51-40-02.SDR UPS02439072Fitting · crackedINSPECTION TYPE:C RH BS 1480 B/H #16 HOLE CRACK AT B/H WEB AFT SURFACE RUNNING UP APPROX 0.040" LONG. REFER ATTACHED SKETCH. (STR R34) RH BS 1480 B/H HOLE AT WEB PNL REAMED TO 0.500" AND BUSHING INSTALLED AS PER SB 747-53A2390 REWORKED HOLE INSPECTED. NIL SDR UPS02439070Fitting · crackedINSPECTION TYPE:C BS 1480 RH B/H #3 HOLE FOUND CRACK AT OUTER CHORD SPLICE FTG, RUNNING FWD APPROX 1/16" & AFT APPROX 0.040" LONG. (STR R33 TO R34) RH BS 1480 B/H #3 HOLE AT OUTER CHORD SPLICE FTG REAMED TO 0.625" AND BUSHING INSTALLED AS PER SB 747-53A239SDR UPS02439069Fitting · crackedINSPECTION TYPE:C BS 1480 RH B/H #5 HOLE FOUND CRACK AT OUTER CHORD SPLICE FTG, RUNNING FWD APPROX 1/8" AND AFT APPROX 1/16" LONG. (STR R33 TO R34). RH BS 1480 B/H #5 HOLE AT OUTER CHORD SPLICE FTG REAMED TO 0.660" AND BUSHING INSTALLED AS PER SB747-53A239SDR UPS02439068Fitting · crackedINSPECTION TYPE:C BS 1480 RH B/H #6 HOLE FOUND CRACK AT OUTER CHORD SPLICE FTG RUNNING AFT APPROX 1/16" LONG.(STR R33 TO R34). RH BS 1480 B/H #6 HOLE AT OUTER CHORD SPLICE FTG REAMED TO 0.660" AND BUSHING INSTALLED AS PER SB 747-53A2390 REWORKED HOLE INSPSDR UPS02439067Fitting · crackedINSPECTION TYPE:C BS 1480 RH B/H #9 HOLE FOUND CRACK AT OUTER CHORD SPLICE FTG. RUNNING AFT APPROX 1/16" LONG. (STR R33 TO R34) RH BS 1480 B/H #9 HOLE AT OUTER CHORD SPLICE FTG REAMED TO 0.660" AND BUSHING INSTALLED AS PER SB747-53A2390. REWORKED HOLE INSPSDR UPS02439066Fitting · crackedINSPECTION TYPE:C BS 1480 RH B/H #7 HOLE FOUND CORROSION AROUND AND INSIDE HOLE BORE OF OUTER CHORD SPLICE FTG. (STR R33 TO R34). RH BS 1480 B/H #7 HOLE AT OUTER CHORD SPLICE FTG REAMED TO 0.660 AND BUSHING INSTALLED AS PER B747-53A2390 REWORKED HOLE INSPSDR UPS02439065Fitting · crackedINSPECTION TYPE:C BS 1480 RH B/H #14 HOLE FOUND CRACK AT OUTER CHORD SPLICE FTG, RUNNING O/B APPROX 1/16" LONG. (STR R33 TO R34) RH BS 1480 B/H #14 HOLE AT OUTER CHORD SPLICE FTG REAMED TO 0.500" AND BUSHING INSTALLED AS PER SB 747-53A2390 REWORKED HOLE INSDR UPS02439064Fitting · crackedINSPECTION TYPE:C BS 1480 RH B/H #16 HOLE FOUND CRACK AT OUTER CHORD SPLICE FTG, RUNNING I/B APPROX 1/16" & O/B APPROX 1/8" LONG.(STR R33 TO R34). RH BS 1480 B/H #16 HOLE AT OUTER CHORD SPLICE FTG REAMED TO 0.562" AND BUSHING INSTALLED AS PER SB 747-53A239
Back to JASC 5310