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 QXEA200500410Mount · damagedYYC - NR 2 VHF ANTENNA MOUNT REWORK IS NOT ACCOMPLISHED REF FAA AD 2004-05-13. COMPLIED WITH IAW HORIZON AIR EA 6-53-265, 6-53-162 AND SERVICE BULLETIN 2004-05-13.SDR 2006FA0000149Structure · corrodedAIR STAIR DOOR LOWER CLOSURE, MFG FROM 4130 STEEL, WAS CORRODED THRU UNDER FOLDING STEP. THIS CLOSURE HAD BEEN PREVIOUSLY REPAIRED BY REMOVING CORROSION, TREATING AND A DOUBLER INSTALLED. REMOVED CLOSURE DUE TO CORROSION AND DISBOND FROM DOOR CORE MATERIAL.SDR 2005UALA00128Frame · crackedFWD CARGO DOOR CUTOUT FRAME CRACKED AT FWD LOWER STOP. MANUFACTURED AND INSTALLED REPAIR ANGLE DOUBLER.SDR AWXA200500232Crease Beam · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A .75 INCH CRACK WAS FOUND IN WEB UNDER CREASE BEAM INNER CHORD AT BS 986.5, LBL 43. MAINTENANCE REMOVED DAMAGED WEB FROM BS 986.5 TO BS 1016, LBL 37 TO LBL 45; FABRICATED A NEW REPLACEMENT WEB PER DWG 65-46812; INSTALLESDR SWAA050352Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM CHORD AT RIGHT BS 188, CRACKED. REMOVED AND REPLACED CREASE BEAM CHORD SECTIONS PER SRM.SDR SWAA050351Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPARTMENT SHEAR TIE AT BS 787, RBL 4, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050332Structure · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRUCTURE BETWEEN BS 616 AND BS 639, STRINGER 18R, CRACKED. REPAIRED STRUCTURE PER T1-153-018.SDR 050301Beam · crackedFORWARD CARGO COMPARTMENT, DOOR JAMB, STUB BEAM SHORT FLANGE IS CRACKED.SDR ASOA05195Crease Beam · corrodedDURING A C-CHECK IN YUL, THE CREASE BEAM BETWEEN FRAME 39-40 RT WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE CREASE BEAM BETWEEN FRAME 39-40 RT IAW SRM 51-25-01. (M)SDR CALA0500040Door Frame · crackedINSPECTION FOUND A 1.75 INCH CRACK IN NWW LT DOOR JAMB AT UPPER LOCK FASTENER FOR SPRAY DEFLECTOR GUARD, STA 45. THE CRACK WAS STOP DRILLED AND A REPAIR WAS INSTALLED IAW SRM 53-05, FIGURE 110.SDR CA050209001Crossbeam · corroded(CAN) CORROSION FOUND AT FS280 (MAINLY RT SECTION) AND CRACKS AT LBL/RBL 9.0 AT FLOORBEAM ATTACHMENT FITTING. REPAIR TO BE PERFORMED USING GENERIC REPAIR ENGINEERING ORDERS (GEN REOS) 670-53-11-045, -046,-047, -052 AND IS MODSUM IS670531100026.SDR SWAA050300Crease Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM WEB BETWEEN BS 616 AND BS 639, RBL 70, CRACKED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR 05FDEA00216Beam · crackedLOWER FLANGE UPPER SURFACE OF LONGITUDINAL BEAM 5 LT AT FRAME 51A HAS A .5 INCH LONG CRACK. VERIFIED BY EDDY CURRENT INSPECTION. STOP DRILLED CRACK AND DOUBLE FLUSH PLUGGED HOLE PER EO 6-5310-7-5010 PT1 SECTION C7.SDR 05FDEA00214Beam · crackedLOWER FLANGE UPPER SURFACE OF LONGITUDINAL BEAM 5 LT AT FRAME 52A HAS A .5 INCH LONG CRACK, VERIFIED BY EDDY CURRENT INSPECTION. STOP DRILLED CRACK AND DOUBLE FLUSH PLUGGED HOLE PER EO 6-5310-7-5010 SECTION C8.SDR SWAA050292Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FWD CARGO COMPARTMENT SHEAR TIE AT BS 500, BL 0, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA050290Crease Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM WEB AT BS 580, RBL 70, CRACKED. REMOVED AND REPLACED WEB PER SRM.SDR SWAA050286Shear Tie · crackedDURING SPV, FOUND 2 EACH CRACKS ON SHEAR TIES AT BS 360, ABOVE AND BELOW STRINGER 14L. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR COMA0570012Beam · 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 AEROSPACE REO 670-52-11-047, BRAS EO 610R-53-5930 AND CRJ 700 SRM 51-42-06-001 AO1.SDR SWAA050266Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND 4 EACH SHEAR TIES BETWEEN BS 727D AND BS 787, FROM LBL 11 TO RBL 14, CORRODED. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA050275Crease Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND 3 EACH LT CREASE BEAM WEBS CRACKED AT BS 580, BS 620 AND BS 640. REMOVED AND REPLACED CREASE BEAM WEB SECTIONS PER SRM.SDR SWAA050268Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 500, STRINGER 28R, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050262Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE AT BS 967, STRINGER 24R, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050249Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPARTMENT SHEAR TIE AT BS 1006, LBL 1, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050248Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 500A, STRINGER 16R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWIA200514569Beam · crackedMAIN FUSELAGE FS 280.00 RBL 9.0 LOWER FLANGE OF TRANSVERSE BEAM CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FS280, RBL 9 LOWER FLANGE OF TRANSVERSE BEAM IAW CRJ REO 601R-53-11-171 REV A.SDR 05FDEA00200Door Frame · damagedAFT CARGO DOOR AFT FRAME UPPER SIDE AFTER REMOVAL OF UPPER DOOR SILL SECTION TO RECTIFY N00021, FOUND 1 AREA OF CORROSION ON AFT FRAME REAR FACE SURFACE SURROUNDING NUT PLATE. REMOVED CORROSION IAW A300-600 SRM 51-74-10 AND REPAIRED AFT CARGO DOOR AFT FRAME SDR 05FDEA00190Frame · dentedBS 500, RBL 35, WL 161 DENT ON FRAME. REPAIRED PER SRM 53-10-1, 51-40-3SDR SWAA050241Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND 3 EACH SHEAR TIES CORRODED BETWEEN BS 727E AND BS 787, LBL 18 AND RBL 9. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR QXEA200500382Doubler · corrodedYYC - FUSELAGE LAV SERVICE DOOR SURROUND LOWER MACHINED DOUBLER HAS EXFOLIATION CORROSION. REPAIRED IAW RD 8/4-114-, ISSUE 1, PAGE 5 AND HORIZON AIR EA 6-53-515.SDR SWAA050215Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 727B TO BS 727D, RBL 70, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR COOSDR05003Door Frame · crackedFWD CARGO COMPARTMENT, DOOR JAMB, STUB BEAM, PN 5921718-1, SHORT FLANGES CRACKED. (K)SDR SWAA050186Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB BETWEEN BS 360 AND BS 380, LBL 64, CORRODED. REMOVED AND REPLACED WEB SECTION PER SRM.SDR 200501309Rack · tornFOUND TRAY HAD STRESS TEARS IN THE CORNERS OF THE THUMBSCREW CUTOUT AT THE BEND RADII FOLLOWING INSPECTION IAW SIL-012.SDR SWAA050180Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND 2 EACH SHEAR TIES BETWEEN BS 747E AND BS 767, BETWEEN STRINGERS 27R AND 26R, CORRODED. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR IXXA0500169SDoubler · crackedDURING ROUTINE C-CHECK FOUND AIR START ENCLOSURE GOUGED AND CRACKED. REMOVED FASTENERS, INNER AND OUTER DOUBLER. FABRICATED INNER AND OUTER DOUBLER. LOCATED, DRILLED, TREATED PRIMED, AND INSTALLED NEW INNER AND OUTER DOUBLER IAW DAC DRAWING 5614438, DC8 SRMSDR SWAA050152Door Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FWD SERVICE DOOR FWD LWR STUB FRAME CORRODED. REPAIRED FRAME PER ER.SDR QXEA200500384Track · gougedYYC - AFT FUSELAGE, AFT ENTRY DOOR SURROUND STRUCTURE LOWER AFT LATCH TRACK GOUGES AT STATION 698.000 AND STRINGER 20P. REPAIRED IAW DHC-8 400 SRM 51-14-0-350-803, SRM 51-21-10-380-001, 51-25-10-370-001 AND 51-25-15-370-001.SDR 05FDEA00128Stop Fitting · damagedINTERNAL ANGLE AT NR 7 LEFT DOOR STOP HAS MECHANICAL DAMAGE (DRILLED INTO). REMOVED AND REPLACED NR 7 LEFT DOOR STOP FITTING AS PER SRM 51-30-5, 51-30-2.SDR SWAA050144Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 500D, STRINGER 26L, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR LCQ37Door Frame · corrodedSTA. 908.5, AFT CARGO DOOR FRAME WEB HAS CORROSION ON VERTICAL SUPPORT, FOUR CORNERS FWD SIDE. S/O 152051, OPS 29258, ZONE 1E-3SDR SWAA050118Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND RT AND LT CREASE BEAM WEBS BETWEEN BS 727B AND BS 747, CORRODED. REMOVED AND REPLACED CREASE BEAM WEBS PER SRM.SDR SWAA050117Web · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 353, LBL 62, CORRODED. REMOVED AND REPLACED WEB PER SRM.SDR SWAA050110Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE, AFT CARGO COMPARTMENT BS 807, STRINGER 25L, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050104Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT AFT CARGO COMPARTMENT BS 927, RBL 3, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR IXXA0500160SCloseout Panel · corrodedDURING ROUTINE C-CHECK FOUND RIGHT HAND GEAR OVERHEAD TRUNNION PANEL CORRODED, DELAMINATED. REMOVED FASTENER AND DAMAGED PANEL. RECEIVED OVERHAULED TRUNNION PANEL. LOCATED, DRILLED AND INSTALLED TRUNNION PANEL IAW DC8 SRM 51-1-24, 51-3-0, AND 51-3-1.SDR QXEA200500167Door Frame · gougedYYC - FORWARD FUSELAGE AT PILOT ESCAPE HATCH CUTOUT, FORWARD RIGHT CORNER HAS GOUGE ON OUTER SKIN 1" LONG. REPAIRED IAW HORIZON AIR EA R-53-256 AND CRJ REO 670-53-11-059.SDR USAA050180Support Beam · corrodedBFM - S1 CHECK- AUX BEAM SUPPORT - (1.5 INCH L X 1.5 INCH W X .060 INCH D); CORROSION; LEVEL 2; TASK J7-900-09000-043, FR71.8 - Y1400 - Z240. REMOVED AND REPLACED WITH NEW PORT SRM. (K)SDR CA050114005Crossbeam · cracked(CAN) AN ENGINEER WAS DOING A 30 HOUR INSPECTION IAW AWD 96-156-071(B) R1 PART 1.1.THE ENGINEER DISCOVERED A BLACK LINE IN THE REGION THAT IS TO BE INSPECTED, A CLOSER LOOK, IT WAS DETERMINED THAT IT WAS CRACKED. THE TSO IS ACTUALLY TSI SINCE THE LAST (NDT LISDR SWAA050080Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE IN AFT CARGO COMPARTMENT BS 767, RBL 8, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR ASAA0540027Door Frame · gougedOKC - E AND E BAY DOOR CUTOUT FORWARD FRAME, WEB AT STA328, LBL 0 TO 3 IS GOUGED. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR DOUBLER IAW SRM. (K)
Back to JASC 5310