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 SWAA2014043027564Window Frame · crackedFLIGHT DECK LT NR 1 WINDOW FRAME UPPER OTBD CORNER CRACKED. REPAIRED FRAME IAW ACO.SDR FDEA201404210781Crease Beam · corrodedMAIN CABIN AT BS 1260 RT INBD CREASE BEAM CORRODED. BLENDED CORROSION IAW SRM 53-40-13. FOUND TO BE OUT OF LIMITS IAW SRM 53-40-13 FIG 101 DETAIL II. REPLACED CREASE BEAM IAW SRM 51-40-02 & DWG 146N5590. REPAIR CLASSIFIED AS CATEGORY A MAJOR.SDR DALA14024555641Crease Beam · corrodedMAIN CABIN AT BS 780, CREASE BEAM CORRODED. REPAIRED IAW ER/A 524962-14, REV O.SDR DALA14024980188Failsafe · crackedBS 955, FAILSAFE STRAP FOUND CRACKED AT 2:00 AND 10:00 O'CLOCK. REPLACED ERA 524044-14AD.SDR DALA14024950188Failsafe · damagedBS 955 FAILSAFE STRAP TEE FITTING FOUND THROUGH THICKNESS CORROSION AT 10:00 O'CLOCK POSITION APPROX 0.040" IN LENGTH. REPLACED IAW ERA 524044-14AD.SDR SWIA201437181Door Frame · crackedPASSENGER DOOR FRAME UPPER FWD STOP BRACKET ASSY HAS A CRACK. REPLACED DAMAGED DOOR FRAME UPPER FWD DOOR STOP BRACKET IAW SRM.SDR SWIA201437795Structure · corrodedLOCK FASTENER AND SURROUNDING STRUCTURE COMMON TO THE DIAPHRAGM SILL DECK AT RBL 40, FS 830 IS CORRODED. REPAIRED SILL DECK AT FS 834.40, RBL 40 IAW REO.SDR SWIA201437252Beam · crackedFOUND A CRACK AT WEB BEAM LBL 9.0 ON BS 559. C-CHECK COMPLIED WITH STRUCTURAL REPAIRS AS REQUIRED IAW REO.SDR SWAA2014060628777Door Frame · crackedAFT FRAME OF FWD CARGO DOOR CUT OUT CRACKED AT BS 492, STRINGER 24R. R & R FRAME IAW SRM & DWG.SDR DALA14025239212Door Frame · damagedMID CARGO BAY CUTOUT LOWER PLATE HAS NUMEROUS LOCATIONS OF CORROSION, GOUGES AND TOOL DAMAGE. REMOVED DAMAGED MID CARGO DOOR JAMB BEAM, LOCATED, DRILLED AND INSTALLED NEW IAW SRM 51-30-05, 51-30-02 AND DWG 5930481.SDR DALA14024520936Catwalk · crackedMAINTENANCE DISCOVERED THAT THE TAILCONE CATWALK OVER THE VENTRAL STAIRWAY HAD STRUCTURAL CRACKS IN 3 PLACES. THIS IS CONSIDERED A DEFECT IN THE EMERGENCY ESCAPE SYSTEM AND COULD HAVE AN ADVERSE AFFECT ON THE EVACUATION ROUTE. THE CATWALK WAS REPAIRED IAW ER/SDR DALA14025175641Crease Beam · corrodedMAIN CABIN BETWEEN BS 720-755, RBL 64 CREASE BEAM CORRODED. REMOVED CREASE BEAM. LOCATED AND DRILLED NEW CREASE BEAM AND INSTALLED IAW SRM 51-40-02, PAR 7 AND 4 AND 51-40-05 AND 51-40-08SDR DALA14023570960Beam · crackedFWD ENTRY DOOR UPPER BEAM FWD & AFT ENDS ARE CRACKED. REMOVED BEAM & INSTALLED NEW IAW SRM 51-30-2, & 52-13-0.SDR HSRR201404150001Crossbeam · crackedDURING ROUTINE INSPECTION DISCOVERED A CRACK IN THE CROSS TIE RADIUS AT THE LOWER AFT SIDE OF THE RT EMERGENCY EXIT.SDR DALA2016110808648Beam · corrodedAFT CARGO BAY C-3 THRESHOLD BEAM CORRODED, FABRICATED AND REPLACED EXISTING REPAIR.SDR FDEA201404140729Crease Beam · corrodedMAIN DECK CARGO LT CREASE BEAM OTBD ANGLE SPLICE HAS EDGE CORROSION AT BS 1462. SPLICE WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13 DETAIL III PG 103. REMOVED AND REPLACED SPLICE IAW SRM 51-40-02 AND DRAWING 146N5590. MAJOR REPAIR.SDR SWAA2014051427987Window Frame · crackedFLIGHT DECK LT NR 1 WINDOW FRAME CRACKED AT UPPER AFT CORNER. R & R FRAME IAW ACO & EA.SDR SWAA2014051427986Window Frame · crackedRIGHT NR 3 FLIGHT DECK WINDOW FRAME CRACKED AT 2ND FASTENER FROM BOTTOM OF E-F POST. REPAIRED FRAME CRACKED IAW ACO & SI.SDR SWAA2014050827805Window Frame · crackedLEFT NR 3 FLIGHT DECK WINDOW FRAME CRACKED AT 3RD FASTENER FROM BOTTOM OF E-F POST. REPAIRED FRAME IAW ACO.SDR SWAA2014050827804Window Frame · crackedLEFT NR 3 FLIGHT DECK WINDOW FRAME CRACKED AT 2ND FASTENER FROM BOTTOM OF E-F POST. REPAIRED FRAME IAW ACO.SDR SWAA2014050727762Window Frame · crackedRIGHT NR 1 WINDOW FRAME POST CRACKED AT UPPER AFT CORNER. REPAIRED FRAME IAW ER & EA.SDR IPXA2014042582769Fitting · cracked3C INSPECTION, ACFT BAY FUSELAGE RT FRAME 45 BASE FITTING CRACKED. REPAIRED FITTING IAW EO 5310-46789-A, APPENDIX G.SDR IPXA2014042582768Fitting · cracked3C INSPECTION, ACFT BAY FUSELAGE RT FRAME 46 BASE FITTING CRACKED. REPAIRED FITTING IAW EO A300-5310-46789-A, APPENDIX G.SDR IPXA2014042582766Fitting · cracked3C INSPECTION, ACFT BAY FUSELAGE FRAME 46 BASE FITTING CRACKED. REPAIRED FITTING IAW EO A300-5310-46789-A, APPENDIX F.SDR YENA20140414082Beam · crackedDURING A HEAVY MAINTENANCE CHECK, FOUND LT FUSELAGE SIDE BOX BEAM FLANGE AT STRINGER 15L FRAME 43, CRACKED, VERIFIED. CUT OUT DAMAGE. HFEC INSP ACCOMPLISHED. INSTALLED PRESSURE PLATE AND NEW FITTINGS. ALL WORK ACCOMPLISHED IAW SB A320-53-1251/EC A320-53-1SDR DALA14023655805Crease Beam · corrodedMAIN CABIN RT CREASE BEAM INBD ANGLE HAS CORROSION AT BS 778. COMPLIED WITH ER/A 524454-14, REV ORIGINAL.SDR KCSA201404141044Structure · crackedBS 2598, OTBD CHORD HAS A CRACK IN FASTENER HOLE AT S12R, COMMON TO LOWER FWD SPLICE FITTING.SDR DXTA2014050205757Door Frame · chafedCHAFE ON DOOR FRAME STRUCTURE ABOVE & FWD OF DOOR. REPAIRED IAW RD 5653 04RD.SDR QXEA2014042100306Structure · corrodedEVIDENCE OF CORROSION AROUND RIVET HEADS COMMON TO STRINGER 24R BETWEEN BS 71.2-94.8 . RT FUSELAGE JUST BELOW EMERGENCY DOOR THRESHOLD. REMOVED CORROSION. FOUND WITHIN LIMITS IAW SRM 53-20-17.SDR DALA14022986902Door Frame · crackedFWD CARGO DOORWAY FWD FRAME WEB, BS 560 AND OUTER ANGLE ARE CRACKED TWO INCHES ABOVE UPPER STOP FITTING. COMPLIED WITH ERA 524296-14AD, REV ORIGINAL.SDR ASOA20140413038Beam · corrodedDURING C-CHECK, CARGO LOWER BEAM FROM FRAMES 65-68 HAS CORROSION. MAINTENANCE R & R LOWER BEAM IAW SRM 51-40-02 AND CPM 51-21-06. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SCNA20140512073Window Frame · crackedPILOT AFT SIDE WINDOW NR 3 FRAME HAS HFEC CRACK INDICATION IN A BOLT HOLE AND COUNTERSINK FWD SIDE SECOND FROM BOTTOM. REPAIRED WINDOW FRAME CRACK.SDR SCNA20140506048Window Frame · crackedCO-PILOT SIDE, AFT SIDE WINDOW NR 3 FRAME HAS A HFEC CRACK INDICATION IN A BOLT HOLE AND COUNTERSINK. FWD SIDE SECOND FROM BOTTOM. REPAIRED CRACK ON RT NR 3 WINDOW.SDR SWIA201437138Structure · delaminatedL/E PANEL 630KL HAS SEPARATION OF THE SHROUD TO L/E SKIN. DELAMINATION. C-CHECK, REBONDED SEPARATION OF THE SHROUD TO L/E SKIN IAW REO.SDR SWIA201437137Structure · delaminatedL/E PANEL 630JL HAS SEPARATION OF THE SHROUD TO L/E SKIN, DELAMINATION. C-CHECK, REBONDED SEPARATION OF THE SHROUD TO L/E SKIN IAW REO.SDR ASAA2014041007487Beam · gougedOVERHEAD BEAM GOUGED AND CHAFED AT THE FWD LAV FWD INBD ATTACH POINT. ACFT GROUNDED. REPAIRED FWD LAV INBD ATTACHED POINT WEB SECTION AND FABRICATE AND INSTALLED NEW BRACKET IAW SRM 57-70-11-09-0 AND SRM 51-40-02-0G-0.SDR CALA2014041090800Door Frame · damagedFUSELAGE FRAME ON FWD SIDE OF L1 DOOR IS CRACKED & BENT. REPAIRED L1 DOORWAY BS 338 UPPER FRAME INBD CHORD IAW ECRA 5300-01886.SDR IPXA2014042182705Door Frame · crackedINSPECTION TYPE:4C, R3 DOOR LOWER FWD DOOR JAMB HAS CRACK AT LIGHTNING HOLE. ACCOMPLISHED REPAIR ON R3 DOOR LOWER FWD JAMB BS 1250 - 1256 IAW SRM 53-40-45, REPAIR 3, FIG 201, REV 55.SDR SWAA2014050227615Window Frame · crackedRIGHT FIRST OFFICER`S NR 1 WINDOW OTBD FRAME CRACKED AT THE UPPER HOLE. R & R FRAME IAW ACO.SDR SWAA2014042927518Forging · crackedRIGHT BS 887+10, CRACKED AT HOLE NR 8 IN LOWER FWD CORNER. R & R FORGING IAW DWG.SDR SWAA2014042927517Forging · crackedRIGHT BS 887+10 UPPER AFT WINDOW CORNER CRACKED. REPAIRED FORGING IAW SRM.SDR SWAA2014042227315Window Frame · crackedCOCKPIT RT NR 1 WINDOW FRAME OTBD POST CRACKED NEAR UPPER CORNER. REPAIRED FRAME IAW EA.SDR R61A201404080562Bolt · corrodedDURING HEAVY CHECK, THREE LATCH BOLTS ON BOTTOM CENTER OVERWING RT CUT OUT ARE CORRODED. MAINTENANCE R & R LATCH BOLTS IAW AMM 20-10-01, PN MS21134-03009, BOLT.SDR AALA20140408001Beam · corrodedCORROSION AFT CARGO DOOR BEAM. INSTALLED DOUBLER IAW AARD 53-10-00-3.SDR UHLA2014040700308Beam · corrodedCORROSION FOUND ON RT BEAM Y= +10.748, FRAMES 86-89. R & R BEAM.SDR UHLA2014040700301Seal Depressor · corrodedAFT CORNER SEAL DEPRESSOR. R & R AFT CORNER SEAL DEPRESSOR, MAJOR REPAIR.SDR SWAA2014041027008Window Frame · crackedLEFT FLIGHT DECK NR 1 WINDOW FRAME CRACKED ON UPPER OTBD EDGE. REPAIRED FRAME IAW EA.SDR R61A201404060508Bolt · corrodedDURING HEAVY CHECK, FWD CARGO LT & RT CENTER DOOR FITTING HARDWARE CORRODED. MAINTENANCE R & R FWD CARGO LT, RT CENTER DOOR FITTINGS HARDWARE IAW AMM 53-21-29, PN PE21094-06016A, BOLT.SDR C77A20140405001Finger Doubler · corrodedFORWARD CARGO FWD FINGER DOUBLER, CORRODED AT X= 8003, Y= 400 & GOUGED AT X= 7698 & Y= 395. R & R FWD CARGO FWD FINGER DOUBLER IAW SRM 51-41-01 & 51-43-01.SDR R61A201404040545Bolt · corrodedDURING HEAVY CHECK, BOLTS FOR FWD GALLEY ARE CORRODED. MAINTENANCE R & R BOLTS IAW AMM 25-31-01.
Back to JASC 5310