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 AWXA200401141Crease Beam · corrodedDURING C-18 CHECK, EXFOLIATION CORROSION WAS FOUND ON R-1 DOOR OUTER CHORD (CREASE BEAM ANGLE) BETWEEN BS 299 AND BS 324, RBL 62, WL 209. MAINTENANCE REMOVED DAMAGED R-1 DOOR OUTER CHORD FROM BS 299 TO BS 324, RBL 62; FABRICATED A NEW REPLACEMENT CHORD; INSTASDR SWAA042849Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 663.5, LBL 32, CRACKED. REPAIRED WEB PER SRM.SDR SWAA042847Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR FRAME CUTOUT AT UPPER STOP, CRACKED. REPAIRED FRAME PER SRM.SDR CA041025004Crossbeam · cracked(CAN) THE BI-DIRECTIONAL CROSSBEAM WAS IN FOR NDT INSPECTION IAW AD96-156-071(B)R1. THE NDT AMO FOUND THE CROSSBEAM CRACKED IN THE CUP OR AS INDICATED IN SB05-00- 28 'R' REGION.SDR 2004UALA00966Crease Beam · corrodedCABIN CREASE BEAM SHEAR WEB AT RBL 70.5 FROM STA 960 TO 984 CORRODED. FABRICATED NEW SHEAR WEB.SDR 2004UALA00903Shear Web · corrodedCABIN CREASE BEAM SHEAR WEB AT LBL 70.5 FROM STA 960 TO 984 IS CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED NEW SHEAR WEB.SDR USAA040673Shear Tie · corrodedFOUND SHEAR TIE CORRODED .5 INCH BY .5 INCH, STATION 1320 ABOVE STRINGERS 27R AND 26R. FABRICATED AND INSTALLED NEW SHEAR TIE IAW SRM 51-40-00. (M)SDR 2004UALA00872Crease Beam · corrodedMAIN CABIN BODY STATION 680 TO 740 LBL 63 FLOOR CREASE BEAM HAS SEVERAL AREAS OF CORROSION. REPLACED CREASE BEAM.SDR DL73S040931Door Frame · crackedINSPECTION OF THE C2 DOOR OPENING FRAME AT FS 794 PER AD 93-14-10 REVEALED CRACK IN THE DOOR FRAME WEB AND FLANGE JUST BELOW THE NR 5 DOOR STOP FITTING. THE CRACKS WERE REMOVED WITH A CUT OUT AND REPAIRED WITH AN ALUMINUM REPAIR ANGLE AND AN EXTERNAL ALUMINUMSDR SWAA042808Door Frame · crackedDURING SCHEDULED D CHECK, FOUND FWD CARGO DOOR FRAME CUTOUT AT FWD NR 5 STOP, CRACKED. REPAIRED FRAME PER ER.SDR 04FDEA02831Liner · puncturedAFT PIT DOOR JAMB AFT SIDE THRESHOLD PANEL HAS HOLE PUNCTURES ON IT. WELD REPAIRED IAW FEDEX EA 8-5320-77632, REFERENCE NON-ROUTINE.SDR UPS04443270Shear Tie · corrodedINSPECTION TYPE:C, FWD CARGO STA 840 S44L - S45L BILGE AREA SHEAR TIE CORROSION FOUND. NEW SHEAR TIE REPLACED & INSTALLED AT BS 840 STR 44L - 45L AS PER SRM 51-30-02, DUE TO BLEND OUT DEPTH 0.050 INCH, WIDTH 1 INCH & LENGTH 3 INCH OUT OF SRM 53-10-01 FIG 1 LISDR USAA040788Keelbeam · corrodedPIT Q5, KEEL BEAM, 2 INCHES X 40 INCHES AREA CORROSION; LEVEL 1 TASK NR C53-208-01, L KEEL BEAM STA 500D-540. REMOVED AND REPLACED, SPLICED IN NEW SECTION IAW TYP REP 53-60-09.SDR UPS04443332Splice · crackedINSPECTION TYPE: C, M/D BS 280, S22-23R FRAME SPLICE FOUND CRACK. BS 280 STR 22 TO 23R FRAME SPLICE REPLACED AS PER SRM 51-30-02.SDR C7WA200400048Shear Tie · corrodedSHEAR TIE CORRODED AT STA 970 BETWEEN STR 28 AND 29 LT. REPAIRED SHEAR TIE IAW SRM 53-10-4 FIG 11, MATERIAL USED 7075-T6 X .050 INCH X 6 INCHES X 11 INCHES.SDR C7WA200400047Shear Tie · corrodedSHEAR TIE CORRODED AT STA 970 BETWEEN STR 28 AND 29 RT. REPAIRED SHEAR TIE IAW SRM 53-10-4 FIG 11. MATERIAL USED 7075-T6 X .050 INCH X 6 INCHES X 11 INCHES.SDR USAA040652Window Frame · crackedPIT - FOUND WINDOW FRAME CRACKED .25 INCH, UPPER OUTBOARD CORNER OF CAPTAIN WINDOW FRAME. REMOVED DAMAGE, DOUBLER INSTALLED PER SRM 53-10-01. (M)SDR UPS04843370Fitting · crackedINSPECTION TYPE: C, CRACKED FITTING IN MAIN CABIN SUBFLOOR, FS 978-980 IN CORNER, LBL 66. REMOVED AND REPLACED FITTING IAW SRM 51-1-20D.SDR A6WA200460041Gusset · crackedAIRBRAKE STRUCTURE AFT OF FRAME 50 RIGHT SIDE GUSSET CRACKED. REPAIR IN PROGRESS. (M)SDR MWEA040170Shear Tie · crackedSHEAR TIE AT STATION 294 ABOVE LONGERON 17 LEFT IS CRACKED AND DENTED. FABRICATED AND INSTALLED NEW FORMER.SDR SWAA042731Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 663.5, LBL 32, CRACKED. REPAIRED WEB PER SRM.SDR SWAA042727Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 665, RBL 42, CRACKED. REPAIRED PRESSURE WEB PER SRM.SDR SWAA042724Strap · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR FRAME UPPER HINGE CUTOUT LOWER CORNER CRACKED. REPAIRED DOOR FRAME UPPER HINGE CUTOUT PER EA.SDR AMTA200401157Crease Beam · corrodedFOUND CORROSION ON CREASE BEAM STATION 1240 RBL 67.5 WL 208. REPAIRED DAMAGE PER SRM 51-70-12 FIG 1. (M)SDR 2004UALA00875Structure · damagedLT EXTERNAL FUSELAGE RIVET HOLE AT STA 520 AND STR 19L HAS EGG SHAPED HOLE. CUTOUT DAMAGE AND INSTALLED STRUCTURAL FILLER AND DOUBLER REPAIR.SDR DLM88040899Beam · corrodedCORROSION ON C2 CARGO BIN DOOR JAMB BEAM AEROMEXICO NRC T0024526. REPLACED CORRODED AREA OF C2 CARGO BIN DOOR JAMB BEAM.SDR DLM88040898Door Frame · corrodedCORROSION ON AFT LOWER WEB OF C3 CARGO BIN DOOR JAMB CLOSE TO STA Y= 1212 AEROMEXICO NRC T0024551. REPLACED WEB OF LOWER C3 CARGO BIN DOOR JAMB.SDR USAA040726Crease Beam · corrodedWEB, 1 INCH AREA, CORROSION; NO LEVEL OR TASK, UPPER AND LOWER SURFACE CREASE BEAM, LT SIDE STA 948, 965. MANUFACTURED WEB FROM ALUM MATERIAL IAW SRM 53-60-15.SDR 2004UALA00878Shear Tie · corrodedAFT PIT STA 1400, FWD SHEAR TIE IS CORRODED BETWEEN STR 27L AND 28L. FABRICATED & INSTALLED NEW SHEAR TIE.SDR DLM88040897Beam · corrodedCORROSION ON C3 CARGO BIN DOOR JAMB BEAM NRC T0024527. REPLACED C3 CARGO BIN DOOR JAMB BEAM.SDR DLM88040894Beam · crackedCRACK ON FWD ANGLE OF AFT RIGHT OVERWING EXIT DOOR BEAM NR 1 AEROMEXICO NRC T0024557. REPLACED FWD ANGLE OF RIGHT OVERWING EXIT DOOR BEAM NR 1.SDR 0402009860Door Frame · crackedDURING L-CHECK, FOUND CRACK IN FORWARD SERVICE DOOR JAMB AT LOWER FORWARD AND AFT CORNERS. REPAIRED PER EA 98-200689.SDR SIMA200426904Beam · corrodedDURING AN IMBV INSPECTION THE GALLEY CENTER BEAM WAS FOUND CORRODED. CUTOUT A SECTION OF THE DAMGAED AREA. FABRICATED A U SHAPE DOUBLER. REPAIR DONE IAW EMB 145 SRM, SRM 145/1142 REV 27, CHAPTER 53-21-10 PARA 5 FIG 204 SHEET 2. (M)SDR SWAA042694Door Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD SERVICE DOOR CUTOUT UPPER STUB FRAME FWD RADIUS, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA042692Door Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME NR 5 STOP UPPER FLANGE, CRACKED. REMOVED AND REPLACED AFT FRAME SECTION PER ER.SDR SWAA042685Door Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME AT NR 5 STOP, CRACKED. REPAIRED FRAME PER ER.SDR SWAA042665Door Frame · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME FWD FACE, CORRODED. REMOVED AND REPLACED CARGO DOOR FRAME CUTOUT PER SRM.SDR USAA040805Door Frame · crackedPIT, Q5, WEB FRAME, 3 INCH CRACK AT FWD ENTRY DOOR LOWER WEB FRAME FORWARD CORNER. FABRICATED AND INSTALLED FILLER AND DOUBLER IAW SRM 52-10-02 FIG 1, SRM 51-70-11 FIG 1.SDR ASAA0410397Structure · corrodedPAE - FOUND CORROSION AT RIGHT MLG WHEEL WELL ON CHORD. CUTOUT DAMAGED AREA AND SPLICE IN NEW AREA PER SRM. (M)SDR UPS04843300Beam · crackedINSPECTION TYPE:C3 AFT SIDE OF AFT PRESSURE BULKHEAD 4TH J-BEAM UP FROM BOTTOM HAS LOWER EXISTING DOUBLER CRACKED AT CENTERLINE. NDT VERIFIED CRACK IN LOWER EXISTING DOUBLER IS 2 INCHES IN LENGTH. REMOVED EXISTING REPAIR DOUBLERS. NDT VERIFIED 2 INCH CRACK SDR UPS04843299Beam · crackedINSPECTION TYPE:C3 AFT PRESSURE BULKHEAD AFT SIDE 3RD J-BEAM UP FROM BOTTOM CRACKED AT BO BOTH UPPER & LOWER EXISTING DOUBLERS AT CENTERLINE WITH UPPER FLANGE HANS SHEARED & LOOSE FASTENERS. NDT VERIFIED CRACK IN BOTH UPPER & LOWER J-BEAM DOUBLERS IS 2 INCHESSDR ASOA04764Crease Beam · corrodedDURING A C-CHECK IN YUL, THE RIGHT CREASE BEAM BETWEEN FRAME 39/40 WAS FOUND TO CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT CREASE BEAM BETWEEN FRAME 39/40 IAW SRM 51-25-03 AND 51-25-01. (M)SDR ASAA0410395Beam · corrodedPAE - FOUND CORROSION ON LONGITUDINAL BEAM. REMOVED AND REPLACED LONGITUDINAL BEAM. (M)SDR UPS04843306Finger Doubler · corrodedINSPECTION TYPE-C3 SHEARED FASTENERS AND CORROSION UNDER FINGER DOUBLER STA 880-900 BL 0. CUT OUT DAMAGE TO WEB AND FINGER DOUBLER. FABRICATED FILLER, FINGER DO DOUBLER, AND DOUBLER IAW SRO DWG 5645332. INSTALLED ALL REPAIR PARTS IAW SAA SK772-069.SDR GAIA04103Beam · crackedDURING C-CHECK INSPECTION FOUND FWD 1183 BULKHEAD VERTICAL BEAM RBL 36.8, CRACKED. REF FASI NR 86371, STOP DRILLED CRACKED HOLES AND REPAIRED 1183 BULKHEAD VERTICAL BEAM RBL 36.8, IAW SB 727-53-0192.SDR GAIA04102Beam · crackedDURING C-CHECK INSPECTION FOUND FWD 1183 BULKHEAD VERTICAL BEAM LBL 36.8 HAS 2 CRACKS. REF FASI NR 86370, STOP DRILLED CRACKED AREA ON FWD BULKHEAD 1183 VERTICAL BEAM AND INSTALLED REPAIR KIT ANGLES IAW SB 727-52-0192.SDR GAIA04167Door Frame · crackedDURING C-CHECK INSPECTION, FOUND FORWARD ENTRY DOOR FRAME CRACKED AT UPPER AFT LATCH ROLLER. REF FASI NR 87126, ACCOMPLISHED WEB REPAIR IAW SRM 51-40-3, FIG 1.SDR GAIA04165Frame · crackedDURING C-CHECK INSPECTION FOUND R-2 DOOR CUT OUT FORWARD FRAME INNER CHORD CRACKED AT STRINGER 17 RT. REF FASI NR 87020, CUT OUT DAMAGE, INSTALLED ANGLE REPAIR IAW SRM 51-40-3, FIG 1.SDR GAIA04160Beam · crackedDURING C-CHECK INSPECTION FOUND AFT CABIN VERTICAL BEAM BS 1183, LBL24 INCH, WL 269, CRACKED. REF FASI NR 86945 INSTALLED REPAIR KIT 65C33556-41 IAW SB 727-53-0182, REV 1.SDR 2004UALA00887Shear Tie · corrodedAFT PIT STA 1600 BETWEEN STR 28R AND 29R, SHEAR TIE IS CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW SHEAR TIE.
Back to JASC 5310