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 ASAA0410392Shear Tie · crackedPAE - FOUND SHEAR TIE CRACKED AT 2 FASTENER HOLE LOCATIONS. REMOVED AND REPLACED SHEAR TIE. (M)SDR UPS04843265Door Frame · crackedINSPECTION TYPE: C3, L1 DOOR HAS A CRACK ON THE LOWER FWD DOOR JAMB STARTING FROM THE EDGE AND TERMINATES AT THE FASTENER HOLE. CUT OUT CRACK ON FWD LOWER CORNER OF L1 DOOR JAMB OUTER SKIN AND INTERNAL DOUBLER. NDT VERIFIED NO CRACKS NOTED AT CUT OUTS. FABRSDR AWXA200401045Crease Beam · corrodedDURING C-14 CHECK CORROSION WAS FOUND ON L-1 DOORWAY CREASE BEAM INNER CHORD BETWEEN BS 319 AND BS 357, LBL 58, WL 208. MAINTENANCE REMOVED CORRODED CREASE BEAM INNER CHORD FROM BS 319 TO BS 357, LBL 58; FABRICATED A NEW REPLACEMENT CREASE BEAM INNER CHORD IASDR 372PA0062Failsafe · corrodedFAILSAFE LINK BETWEEN BS 967 AND BS 986.5 AT LBL 46 CORRODED. REPLACED FAILSAFE LINK PER SRM 51-10-2.SDR MWEA040162Door Frame · damagedFORWARD SECTION OF AFT CARGO COMPARTMENT DOOR FRAME DAMAGED. REMOVED AND REPLACED DOUBLER.SDR AWXA200401044Crease Beam · corrodedDURING C-14 CHECK CORROSION WAS FOUND ON R-1 DOORWAY CREASE BEAM INNER CHORD BETWEEN BS 294 AND BS 356, RBL 58, WL 208. MAINTENANCE REMOVED CORRODED CREASE BEAM INNER CHORD FROM BS 294 TO BS 356, RBL 58; FABRICATED A NEW REPLACEMENT CREASE BEAM INNER CHORD IAWSDR 04FDEA02664Adapter · brokenMAIN CABIN FS 44 FLOOR LEVEL BETWEEN SEAT TRACK R1 AND R2 SEAT TRACK (CLS ADAPTER) IS BROKEN. REMOVED AND REPLACED CLS ADAPTOR IAW A310/200 SRM 51-40-21.SDR ASAA0410390Shear Tie · corrodedPAE - FOUND CORROSION ON SHEARTIE, FORWARD AND AFT SIDES. FOUND CORROSION BLENDOUT TO BE 'OUT OF LIMITS'. REMOVED, FABRICATED AND INSTALLED SHEAR TIE. (M)SDR ASAA0440163Door Frame · corrodedOAK - FOUND AFT CARGO COMPARTMENT DOOR JAMB WEB IS CORRODED. REPLACED WEB. (M)SDR EIA2004084Skin · corrodedMAIN CABIN WINDOW BELT CORRODED BETWEEN B.S. 680-700 LT. REMOVED CORROSION FOUND OUT OF LIMITS INSTALLED REPAIR IAW ECRA 480-53-171-2.SDR USAA040570Door Frame · crackedCLT - FOUND FRAME CRACKED .25 INCH, E-E ACCESS DOOR AT FRAME WEB TO FLANGE CORNER RADIUS. DAMAGE AREA REPAIRED IAW EA 95806. (M)SDR EIA2004080Forging · corrodedMAIN CABIN INTERIOR LEFT WINDOW FORGING AND STR 22 L CORRODED BETWEEN BS 300-320. REMOVED CORROSION, STR 22L OUT OF LIMITS REPLACED STR PER B747 SRM 51-30-02 FROM BS 220-406.SDR EIA2004086Forging · corrodedLT WINDOW FORGING AND STR 22L CORROSION BETWEEN BS 360-380. REMOVE CORROSION, STRINGER 22L FOUND OUT OF LIMITS, REMOVED AND REPLACED STRINGER FROM BS 220-400 PER B747 SRM 51-30-02.SDR USAA040820Crease Beam · crackedPIT, Q5, CREASE BEAM WEB 1 INCH CRACK. LT CREASE BEAM BS 616-639. DEFECTIVE PART REPLACED WITH IDENT PART IAW SRM 51-10-02.SDR 031283Tube · bentDURING SCHEDULED INSPECTION, FOUND AFT FUSELAGE TUBES BENT AND CRACKED. THIS AREA HAD BEEN PREVIOUSLY REPAIRED FOR SIMILAR CONDITION. DAMAGE WAS APPARENTLY CAUSED BY TAIL WHEEL LINK STRIKING TUBES AS A RESULT OF UNDER INFLATION OR COLLAPSE OF TAIL WHEEL STRUTSDR COMA0460492Angle · crackedPASSENGER DOOR AFT CLOSE OUT ANGLE IS CRACKED. PERFORMED A MAJOR REPAIR TO PASSENGER DOOR AFT DRAG ANGLE BY CUTTING AWAY DAMAGED AREA, LPI FABED REPAIR ANGLES AND INSTALLED IAW BOMBARDIER REO 601R-52-11-513.SDR SWAA042555Structure · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR FRAME UPPER HINGE BOX FITTING CUTOUT AT LOWER CORNER, CRACKED. REPAIRED HINGE BOX FITTING PER EA.SDR SWAA042554Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR AFT FRAME AT 3RD STOP, CRACKED. REPAIRED DOOR FRAME PER SRM.SDR SWAA042549Fitting · crackedDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR FRAME UPPER HINGE BOX FITTING, CRACKED. REMOVED AND REPLACED UPPER HINGE BOX FITTING PER SRM.SDR GTIA040785Door Frame · corrodedFTW - FOUND AFT PIT DOOR JAM CORROSION. REMOVED CORROSION. FABRICATED DOOR BEAM REPAIR. INSTALLED REPAIR PARTS. (M)SDR SWAA042524Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 663, RBL 36, CRACKED. REPAIRED WEB PER SRM.SDR USAA040813Clip · crackedPIT, Q5, CLIP EST. .125 INCH CRACK, STA 500B S 10L. REPLACED CLIP IAW SRM 51-10-02 AND 51-40.SDR SWAA042517Window Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND COCKPIT L1 WINDOW POST UPPER OUTBOARD CORNER CRACKED. REPAIRED WINDOW POST PER SRM.SDR SWAA042530Door Frame · crackedDURING SCHEDULED C-1 CHECK, FOUND FWD CARGO DOOR AFT FRAME AT AFT LOWER STOP, CRACKED. REPAIRED DOOR FRAME PER BAC DRAWING.SDR ASAA0410384Beam · corrodedFOUND CORROSION ON LONGITUDINAL BEAM. REMOVED AND REPLACED LONGITUDINAL BEAM. (M)SDR ABXA040304Rib · crackedPRESSURE DOME PLUG DOOR NR 4 STOP SUPPORT RIB CRACKED. REPAIRED AREA IAW DC-9 SRM 52-02.SDR SWAA042512Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR FRAME FWD OF TORQUE TUBE ACCESS PANEL UPPER FASTENER HOLE, CRACKED. REPAIRED DOOR FRAME PER SRM.SDR SWAA042486Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 465, RBL 70, TO BS 865, RBL 65, BS 817 TO BS 865 LBL 65, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB SECTIONS PER SRM.SDR SWAA042483Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND RT CREASE BEAM AT BS 967 TO BS 983, CORRODED. REMOVED AND REPLACED CREASE BEAM PER SRM.SDR SWAA042482Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE AT BS 360, STRINGERS 14L, CRACKED. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR 04FDEA02565Door Frame · gougedAFT CARGO DOOR CUTOUT ON LOWER FWD FRAME, NOTED GOUGES/DAMAGED SURFACE APPROX 13 INCHES LONG. GOUGES RANGE FROM .080 INCH TO .2 INCH. BLENDED AREA AND FOUND TO BE OUT OF LIMITS IAW A300/600 SRM 53-17-12. FABRICATED AND INSTALLED REPAIR DOUBLERS IAW A300/6SDR AWXA200401061Crease Beam · corrodedDURING C-18 CHECK INTERGRANULAR CORROSION WAS FOUND ON L-1 DOOR CREASE BEAM AT FASTENER HOLES BETWEEN BS 318 AND BS 335. MAINTENANCE REMOVED CORRODED U-CHANNEL AT L-1 DOOR FROM BS 318 TO BS 335; FABRICATED A NEW REPLACEMENT U-CHANNEL; INSTALLED REPAIR PART IASDR 2004UALA00806Crease Beam · corrodedCREASE BEAM WEB CORRODED ON UPPER SURFACE STA 1406 TO 1413. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM WEB.SDR 2004UALA00804Crease Beam · corrodedLEFT HAND CREASE BEAM HAS A LARGE AREA OF CORROSION AT BS 686, JUST FORWARD OF THE L2 CABIN DOOR. MAJOR REPAIR ACCOMPLISHED. REPLACED CHORD ANGLE.SDR BJNA040807Door Frame · crackedDURING C-CHECK INSPECTION, FOUND C-1 DOOR LOWER FORWARD CORNER FRAME CRACKED. INSTALLED NEW LOWER FORWARD CORNER AT C1 DOOR IAW SRM 51-20-1 AND SERVICE BULLETIN 737-52A1100 REV 4. (M) BJNASDR BJNA040808Door Frame · crackedDURING C-CHECK INSPECTION, FOUND C-1 DOOR LOWER AFT CORNER FRAME CRACKED. INSTALLED NEW LOWER AFT CORNER AT C1 DOOR IAW SRM 51-20-1 AND SB 737-52A1100 REV 4. (M) BJNASDR SWAA042465Door Frame · crackedDURING SCHEDULED C3 CHECK, FOUND FWD SERVICE DOOR CUTOUT WEB BELOW THE UPPER HINGE, CRACKED. REPAIRED WEB PER SRM.SDR USAA040506Beam · crackedPIT - FOUND VERTICAL BEAM CRACKED, VERT CHORD 5.7 LEFT WL 184 STATION 178 FPBH. REMOVED DEFECTIVE PARTS, INSTALLED REPAIR ANGLE PER EO 5300V155. (M)SDR ABXA040298Structure · vibrationAIRCRAFT HAD AN UNUSUAL VIBRATION. COCKPIT WAS OSCILLATING UP AND DOWN APPROXIMATELY 3 CYCLES IAW SECOND. SLOWED AC TO 280 KIAS, NO CHANGE. AFTER TRANSITION TO MACH NR, OSCILLATION ABATED AS THE IAS DECREASED THROUGH 270 KNOTS. ALL ENGINE INDICATIONS WERE NORMSDR SWAA042441Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND L1 COCKPIT WINDOW POST CRACKED AT UPPER OUTBOARD CORNER. REPAIRED WINDOW POST PER SRM.SDR SWAA042440Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE LT CREASE BEAM CORRODED AT BS 877. REPAIRED CREASE BEAM PER SRM.SDR 04FDEA02547Crossbeam · crackedQA PICKUP FLOORBEAM AT FWD FACE OF FR 33 BETWEEN Y450 AND Y953 WITH HAIR LINE CRACK.SDR IXXA0500006SDoor Frame · crackedDURING A ROUTINE C-CHECK INSPECTION, EXTERNAL FUSELAGE AFT PASSENGER DOOR UPPER CORNER DOOR JAMB CRACKED .5 INCH AT STA 1660.000 L-9 TO L-101. PERFORMED MAJOR REPAIR. REMOVED FASTENER, DAMAGED AREA AND FABRICATED FILLER, DOUBLER, AND TRIPLER. CLEANED, TREATSDR SWAA042433Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 407, RBL 70 CORRODED. REMOVED AND REPLACED CREASE BEAM SECTION PER SRM.SDR ASAA0410382Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED, FABRICATED AND INSTALLED SHEAR TIE. (M)SDR ABXA040318Door Frame · crackedCRACKED MAIN ENTRY DOOR FRAME WEB AT STA 207. REPAIRED WEB IAW DC-9 SRM 51-70-4.SDR SWIA200413750Beam · crackedFUSELAGE TRANSVERSE BEAM LOWER FLANGE IS CRACKED; FS 280.00 RBL 12.0. ITEM FOUND AT C-CHECK INSPECTION. LOWER FLANGE REPAIRED IAW CRJ REO #601R-53-11-171 REV A.SDR ESPA200400004Structure · bird strikeWHILE ON APPROACH AIRCRAFT WAS STRUCK BY A BIRD ON THE LEFT SIDE OF THE FORWARD FUSELAGE.SDR F3LA200400089Structure · crackedON WALK AROUND, MAINTENANCE REPORTED A 4-INCH CRACK IN RT FWD TOP WHEEL WELL. REPAIRED IAW SRM 53-10-51, PAGE 213, FIGURE 203.SDR USAA040513Door Frame · crackedPIT - FOUND FRAME CRACKED .25 INCH, NR 4 DOOR STOP CUT OUT AFT SIDE OF DOOR. CUT OUT DAMAGE, INSTALLED DOUBLER PER TYPICAL REPAIR 52-10-11. (M)
Back to JASC 5310