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 AWXA200500640Shear Plate · crackedDURING C08 CHECK, A CRACK WAS FOUND AT SHEAR PLATE Y1300 BETWEEN FS 68 TO FS 69. MAINTENANCE REMOVED AND REPLACED SHEAR PLATE Y1300 BETWEEN FS 68 TO FS 69 IAW A320 SRM 51-42-11, PAGE 7 AND A320 SRM 51-72-11.SDR AWXA200500602Beam · crackedDURING C-14 CHECK, BS 178 BULKHEAD VERTICAL BEAM WEB AT WL 175, LT BL 5.7, WAS FOUND TO BE CRACKED. MAINTENANCE REPAIRED BULKHEAD VERTICAL BEAM WEB IAW B737-300 SRM 53-10-08-2, FIGURE 212.SDR AWXA200500595Structure · corrodedMCN - MAJOR REPAIR - DURING C-14 CHECK, CORROSION WAS FOUND ON THE L2 INNER CHORD LOCATED AT BS 978, BS 982, BS 991, LT BL 46, WL 209. MAINTENANCE FOUND THE CORROSION TO BE OUT OF LIMITS PER B737-300 SRM 53-60-51-1. MAINTENANCE REMOVED AND REPLACED INNER CHOSDR QXEA200500925Door Frame · gougedYYC - AFT BAGGAGE DOOR SURROUND STRUCTURE HAS GOUGE ON FORWARD FRAME, LOWER INBOARD CORNER. REPAIRED IAW CRJ700 SRM 51-25-16-001-001-A01 AND 51-21-11-001-001-A01.SDR QXEA200500924Door Frame · corrodedYYC - AFT BAGGAGE DOOR SURROUND STRUCTURE LOWER SILL HAS TWO SPOTS OF CORROSION AT STATION 1015 AND 1031. REPAIRED IAW HORIZON AIR EA R-53-324 AND REO 670-53-61-168.SDR SWAA051292Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON LT CREASE BEAM WEB AT BS 500 + 10, BS 500A + 15 & BS 500C + 15. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA051291Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON RT CREASE BEAM WEB AT BS 370 & BS 406. REPAIRED CREASE BEAM WEB PER SRM.SDR 83Crease Beam · corrodedR-1 SERVICE DOOR INNER CHORD CREASE BEAM HAS CORROSION THRU OUT THE BEAM.SDR LR7A05057Window Frame · crackedDURING SCHEDULED C-6 CHECK PER JOB CARD HC5321 LEFT CLEAR VISION WINDOW FRAME CRACKED AT LOWER FWD CORNER FS 105 WL 230. REPAIR CARRIED OUT IAW DWG R05-009-01 & LAC MEA382-53-05-037, FS 105 WL 230.SDR LR7A05052Window Frame · crackedDURING SCHEDULED C-6 CHECK PER JOB CARD HC5321 RIGHT CLEAR VISION WINDOW FRAME CRACKED AT LOWER FWD CORNER FS 105 WL 230. REPAIR CARRIED OUT IAW DWG R05-009-02 & LAC MEA 382-53-05-038, FS 105 WL 230.SDR 05FDEA01158Structure · corrodedCORROSION AT LEFT MAIN WHEEL WELL, BS 928-932 WL 189 LBL 65 UPPER SURFACE. REPLACED STRINGER 18A PER SRM 51-40-3.SDR DHL2005741530Door Frame · chafedMAIN CARGO DOOR CUT-OUT FRAME CHAFED AT AFT LOWER CORNER AS MARKED AT BS 620L. CLEANED AREA FOUND TO BE OUT OF LIMITS IAW B727 SRM 53-10-1 FIG 1. REMOVED SKIN, SIDE GUIDE AND WEDGE IAW B727 SRM 51-30-2 FIG 7. LOCATED, DRILLED AND TRIMMED INNER SKIN WEB AND SDR 2005FA0000643Spar · crackedWHERE HORIZONTAL STAB SPAR ATTACHES. THE BULKHEAD IS CUT AWAY, TO ALLOW THIS, AND IS FORMED BY JOGGLE BEND. SIDE TO SIDE. AT THIS JOGGLE, IT IS CRACKED, FORE AND AFT, TO INCLUDE BOTH BULKHEAD AND FORMER. (SW01200504216) (K)SDR 05FDEA01132Flange · corrodedCORROSION RIGHT FORWARD ESCAPE HATCH LOWER EDGE UNDER THE SEAL. REPLACED RT FWD ESCAPE HATCH PER FED-EX MM 52-20-002-5.SDR USAA050628Beam · corrodedBFM - FOUND LONGITUDE BEAM ASSY CORRODED FIVE AREAS, 1.20 INCHES LONG, .300 INCHES WIDE, .050 INCHES DEEP, 3 INCHES LONG, 1.20 INCHES WIDE, .080, MAIN CABIN, B/T FRAME 79-80, Y-450. REMOVED AND REPLACED BEAM ASSEMBLY PER SRM 51-72-11, 51-43-11, 51-42-00. (M)SDR QXEA200500718Stop Fitting · wornPDX - RIGHTHAND FORWARD EMERGENCY EXIT DOOR STOPS ON FUSELAGE HAVE STEP WEAR. REPAIRED IAW DHC-8-200 MM 20-21-21 AND RD 8-53-126.SDR QXES200500719Stop Fitting · wornPDX - RIGHTHAND FORWARD EMERGENCY EXIT DOOR STOPS ON DOOR HAVE STEP WEAR. REPAIRED IAW RD 8-52-349 AND DHC-8-200 TASK 52-20-16-830-802.SDR DHL2005741525Web · chafedREMAIN CARGO DOOR , CUTOUT FRAME CHAFED AT FWD BOTTOM CORNER AT BS 480L. CLEANED AREA FOUND MAJOR DAMAGED AND IS OUT OF LIMITS IAW B727 SRM 53-10-1 FIG 1. REMOVED SKIN SIDE GUIDE AND WEDGE IAW B727 SRM 51-30-2 FIG 7. LOCATED TRIMMED AND DRILLED INNER WEB ANSDR UIEA200500061Support Beam · damagedSTA 1810 SIDE CARGO DOOR SILL SUPPORT BEAM DAMAGED AT ROLLOUT SAFETY STOPS. FORM 8100-9 SHOWS THAT THE DAMAGED AREA WAS TRIMMED OUT AND A REPAIR ANGLE IS INSTALLED. (K)SDR ASAA0510080Window Frame · crackedYXX - FOUND LOWER AFT CORNER OF WINDOW FRAME CRACKED IN FASTENER HOLE AT BS 500A PLUS 15 INCHES RT. REPAIRED IAW ERO 3774 CRACK REMOVED ERO 3774 STEP 1.1. (M)SDR ABXA050106Door Frame · crackedFORWARD DOOR JAMB CRACKED. INBOARD END FORWARD OF DOOR HINGE. REPAIRED AREA IAW DC-9 SRM 53-01.SDR QXEA200500715Stop Fitting · chafedPDX - BOTTOM AFT BAG DOOR STOP CHAFED. REPAIRED IAW RD 8-53-104.SDR QXEA200500714Stop Fitting · chafedPDX - BOTTOM FORWARD BAG DOOR STOP CHAFED. REPAIRED IAW RD 8-53-104.SDR ASAA0580209Door Frame · corrodedFOUND HV CHECK, AFT CARGO BAY DOOR JAMB BEAM CORRODED. REPLACED BEAM. (M)SDR 2005UALA00351Shear Web · corrodedAFT CABIN SHEAR WEB IS CORRODED AT STA 1681 TO 1720 AROUND DRAIN ATTACH FASTENER HOLES RBL 48. CORROSION WAS REMOVED AND A DOUBLER REPAIR INSTALLED.SDR 2005FA0001578Tube · corrodedANNUAL INSPECTION DISCOVERED WIDESPREAD CORROSION OF 4130 STEEL FUSELAGE STRUCTURE. LOWER DOOR POST TUBES WERE CORRODED NEARLY THROUGH, RENDERING AIRPLANE UNAIRWORTHY. SIGNIFICANT PORTIONS OF APPARENT ORIGINAL YELLOW FIBERGLASS INSTALLATION WERE WET. AIRCRAFSDR MALA050338Door Frame · corrodedDURING 4Y/2Y CHECK IN BNA FOUND COCKPIT ENTRANCE DOOR FRAMES LT AND RT SIDES AT FS 225 ARE CORRODED AND HAVE BEEN REPAIRED IAW MESABA EO S53185.SDR QXEA200500752Structure · chafedYYC - LOWER FUSELAGE IN WHEEL WELL HAS LOOSE DIAPHRAGM AT UPPER ATTACH SCREWS AND CHAFING DAMAGE. REPAIRED IAW CRJ700 SRM 51-42-001-001-A01, SRM 51-42-06-001-001-A01, AND SRM 51-42-21-001-001-A01.SDR MALA050334Door Frame · corrodedDURING 4Y/2Y CHECK IN BAN FOUND LEFT COCKPIT ENTRY DOOR POST IS CORRODED OUT OF LIMITS AND HAS BEEN REPAIRED IAW MESABA EO S53185.SDR COMA0570041Beam · corrodedTRANSVERSE BEAM AT FS 280 FROM LBL 36 TO RBL 36 IS CORRODED ALONG THE UPPER AND LOWER EDGES. REPLACED THE TRANSVERSE BEAM AT FS 280 IAW BOMBARDIER INC REO 670-53-11-047, AND CRJ 700 SRM 51-42-06-001-001-A01.SDR RT62005F00000Support Fitting · crackedREAR CROSSTUBE BOX-BEAM ASSEMBLY: LEFT FORWARD SUPPORT FITTING- 1 INCH VERTICAL CRACK, RT FORWARD SUPPORT FITTING - 1 INCH CRACK IN RADIUS. CRACKS FOUND DURING SCHEDULED INSPECTION. (K) (1 OF 4)SDR UPS05444384Frame · crackedRT BS 460 FRAME (JUST BELOW U/D FLOORBEAM LWR CHORD) WEB CRACKED, CRACK LENGTH 1.875. FRAME WEB REPLACED AS PER SRM 51-10-01 PG 9.SDR ASOA05356Post · corrodedDURING HANGAR MAINTENANCE, THE FS 280 BULKHEAD, DOOR POST AT LBL 11.128 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED THE FS 280 BULKHEAD, DOOR POST AT LBL 11.128 IAW EO. (K)SDR MALA050319Door Frame · corrodedDURING 4K CHECK IN BNA FOUND COCKPIT DOOR POST AT RBL 10.0 IS CORRODED AND HAS BEEN REPAIRED IAW MESABA EO S53185.SDR MALA050318Door Frame · corrodedDURING 4K CHECK IN BNA FOUND COCKPIT DOOR POST AT LBL 10.0 IS CORRODED AND HAS BEEN REPAIRED IAW MESABA EO S53185.SDR ASAA0580199Beam · corrodedOKC - DURING C-CHECK, AFT CARGO BAY DOOR CUTOUT BEAM IS CORRODED UNDER REPAIR DOUBLER. REPLACED CUTOUT BEAM. (M)SDR EIA2005090Crease Beam · crackedM/D BS 980 S41 CREASE BEAM FOUND CRACKED. CRACKED WEB REPLACED PER SRM 51-30-02 AND 51-10-01.SDR EIA2005089Crease Beam · deformedM/D BS 980-1000 CREASE BEAM BETWEEN STR 4-STR 5 BEAM WEB FOUND DEFORMED. DEFORMED WEB REPLACED PER SRM 51-30-02 AND 51-10-01.SDR SIMA200510112Beam · corrodedDURING CPCP INSPECTION, FOUND CENTER HAT SECTION REPAIR DOUBLER AT FRAME 20 IS CORRODED. MAINTENANCE REPLACED HAT BEAM SECTION IAW EMB SRM 51-40-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 2005UALA00294Door Frame · crackedDOOR 1R LOWER FRAME CRACKED (LOWER AFT CORNER). REPLACED FRAME.SDR ASOA05295Support Beam · crackedDURING C-CHECK, THE ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL0 WAS FOUND TO BE CRACKED BEYOND LIMIST. MAINTENANCE IS REPAIRING THE ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL0 IAW EO. (K)SDR AWXA200500503Beam · corrodedSAL - MAJOR REPAIR - DURING C-08 CHECK EXFOLIATION CORROSION WAS FOUND ON LOWER SILL BEAM AT -Y1270 RT, FS 68. MAINTENANCE CUTOUT CORRODED SECTION OF LOWER SILL BEAM AT -Y1270 RT FROM FR 68+3" TO FR 68+7"; FABRICATED A REPAIR ANGLE; INSTALLED REPAIR PART IAW SDR 05FDEA00800Beam · crackedAFT FUSELAGE COMPT STA 2007 RT BEAM APPROX X=20 FOUND VERTICAL L-ANGLE BRACKET SUSPECT CRACK AT THE TOP MOST EDGE AS MARKED. REPAIRED AS PER FEDEX EA 1-5310-83088.SDR 2005UALA00289Crease Beam · corrodedCABIN CREASE BEAM CORRODED AT STA 294.5 RIGHT TO STA 328 RIGHT WL 207, RBL 60. REPLACED CREASE BEAM.SDR UPS05844283Longeron · crackedINSPECTION TYPE: C1, LONGERON CRACKED .25 INCH LONG AT STA 1726 L10 RT. REPAIRED LONGERON BY INSTALLING DOUBLER AND FILLER IAW SRM 53-02-02 FIG 11, 51-1-20, 51-3-0.SDR 0500479611Door Frame · corrodedDURING M-CHECK FOUND CRACK IN LT SIDE AFT ENTRY DOOR JAMB FRAME. REPAIRED PER EA 96-203207.SDR C2XA05SH022Door Frame · crackedSHV - DURING C-CHECK CRACK FOUND ON STRINGER 14L FR 18 BOTTOM I/B HOLE ON MAIN DOOR FRAME. MAINTENANCE REAMED MAIN DOOR STOP ATTACH HOLE, FR 18 STR 14 BOTTOM I/B PER EC5310-01333. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DHL2005740555Web · crackedCRACK AT INBD WEB R/LOWER TORQUE BOX LWR LIGHTENING HOLES STA 1248. STOP DRILLED CRACK .250 TERMINATED AT END OF CRACK AT INBD R/LOWER TORQUE BOX LWR LIGHTENING HOLE STA 1248 IAW B727 SRM 51-10-1 NDT INSPECTED USING HFEC IAW B727 NDT MAN PART 651-00-00 FIG 23SDR DHL2005740554Torque Box · crackedCRACK AT INBD WED RT LOWER TORQUE BOX, LOWER LIGHTENING HOLE STA 1240. STOP DRILLED CRACK .250 TERMINATED AT END OF CRACK ON RT LOWER TORQUE BOX WEB STA 1240 IAW B727 SRM 51-10-1 NDT INSP AREA USING HFEC IAW B727 NDTM PAR 6 51-00-00 FIG 23. CRACK TERMINATED SDR 2005UALA00286Crease Beam · corrodedAFT CABIN CREASE BEAM RBL 57, WL 208.1 CORRODED IN NUMEROUS LOCATIONS FROM STA 947.5 TO STA 990. REPLACED CREASE BEAM.
Back to JASC 5310