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 R61A201406220825Bonding Strap · corrodedDURING HEAVY CHECK, RT ACCESS PANEL CUT OUT NUMEROUS BONDING STRAPS CORRODED. MX R & R 191FL RT ACCESS PANEL CUT OUT NUMEROUS BONDING STRAPS IAW SRM 51-73-00, AND REPLACED WORN AND CORRODED RECEPTACLE IAW SRM 51-42-04.SDR QXEA2014070900559Beam · corrodedEDGE BEAM UNDER THRESHOLD IS CORRODED. LOCATED AND DRILLED IAW SRM 51-40-07-02-01. INSTALLED, INNER, EDGE BEAM, IAW SRM 51-42-05, STEP 40.SDR SWAA2014070229566Window Post · crackedCOCKPIT LT SIDE NR 1 WINDOW POST CRACKED. REPAIRED POST IAW ACO.SDR SWAA2014070229565Window Post · crackedCOCKPIT RT SIDE NR 1 WINDOW POST CRACKED. REPAIRED POST IAW ACO.SDR QXEA2014062600535Rib · corrodedFOUND THREE CORRODED RIBS AT AFT PASSENGER DOOR THRESHOLD BS 676 -683. REMOVED CORRODED RIBS IAW SRM 51-42-05, STEP 4E. FABRICATED BRACKETS. LOCATED AND DRILLED RIBS IAW SRM 51-40-07-02-01. INSTALLED RIBS IAW SRM 51-42-05, STEP 4D.SDR DALA2014062203735Beam · crackedAFT AIRSTAIR TORQUE TUBE SUPPORT BEAM CRACKED. LOCATED BELOW RT AFT CORNER OF WALKING BRIDGE. FABRICATED NEW BRACKET. FABRICATED -5 AND -6 STRAPS IAW DWG 5920986. INSTALLED IAW SRM VOL 1 51-00-00 AND ERA 526846.SDR SIMA20140621004Roller · lack of lubeFLIGHT ATTENDANT REPORTS MAIN CABIN DOOR HARD TO OPEN & CLOSE. SERVICED MAIN DOOR ROLLER IAW AMM 53-21-02 & ETN-EM-52-061 WAS SERVICED. OPERATIONS CHECKED GOOD IAW AMM 52-18-00.SDR R61A201406200774Panel · corrodedFOUND LAVATORY SERVICE PANEL EXTERIOR SIDE LEADING EDGE WITH CORROSION. MX R & R WASTE SERVICE PANEL IAW SRM 51-40-00. PN 170-86668-403, WASTE SERVICE DOOR.SDR ASOA20140620130Beam · corrodedDURING C-CHECK, THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE R & R THE BEAM IAW SRM 51-40-02. ACFT APPROVED FOR RETURN TO SERVICE.SDR ASOA20140620129Beam · corrodedDURING C-CHECK, THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE R & R THE BEAM IAW SRM 51-40-02. ACFT APPROVED FOR RETURN TO SERVICE.SDR SWAA2014070829788Window Frame · crackedRIGHT NR 1 WINDOW FRAME UPPER HOLE CRACKED IN OTBD WINDOW POST. R & R FRAME IAW ACO.SDR DALA2014062103725Spacer · corrodedCORROSION ON PREVIOUS REPAIR SPACER OF LOWER MID CARGO DOOR FRAME BS 636-693. SPACER WAS REPLACED IAW SRM 53-05, FIG 123.SDR DALA2014061903699Beam · crackedCRACKED NR 1BEAM AFT EDGE AT FORWARD SERVICE DOOR. IN REF CARD 28 ZONE 58. FITTING, RETAINER, SEAL, AND BEAM WERE REMOVED IAW SRM 51-30-1 AND 51-30-2. NEW BEAM WAS DRILLED IAW SRM 51-40-0, NEW BEAM WAS TREATED AND PAINTED IAW SRM 51-40-3 PARA 14 AND 21, NEWSDR ASOA2014071010842Door Frame · corrodedPAX DOOR UPPER FRAME CORRODED AROUND BOLT HOLES. R & R UPPER DOOR FRAME IAW SRM 51-41-02, TASK 51-41-02-001-001-A01 AND DWG SH670-31825.SDR QXEA2014062500522Structure · corrodedLOWER EMERGENCY EXIT DOOR CORRODED ON INTERNAL AND EXTERNAL STRUCTURE. BLENDED CORROSION IAW SRM 51-21-00. NO DEFECTS NOTED. FOUND WITHIN TOLERANCE IAW DWG 85227205. RESTORED FINISH IAW SRM 51-21-10-02-01 & 51-25-10-02-01.SDR DALA2014062103727Doubler · crackedCRACK ON INTERNAL DOUBLER AT LOWER AFT DOOR FRAME CORNER BS 423.5 IN PROJECTION LONGERON 27R. REPAIRED IAW SRM 53-05, FIG 105 AND ER/A 525564-14 REV ORIG.SDR SWAA2014062429367Window Frame · crackedFLIGHT DECK LT NR 3 WINDOW FRAME E - F POST 2ND HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2014062429366Window Frame · crackedFLIGHT DECK LT NR 1 WINDOW FRAME UPPER OTBD CORNER CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2014062029256Window Frame · crackedLEFT NR 3 FLIGHT DECK WINDOW FRAME E - F POST 2ND HOLE FROM THE BOTTOM CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2014062029255Window Frame · crackedRIGHT NR FLIGHT DECK WINDOW FRAME E - F POST 3RD HOLE FROM THE BOTTOM CRACKED. REPAIRED FRAME IAW ACO.SDR DALA14036459253Door Frame · corrodedAFT CARGO, LOWER DOOR FRAME CORRODED. REPAIRED DOOR FRAME IAW SRM 53-60-02, FIG 9A.SDR FDEA201406171477Seal · unsecureFIRST OFFICER`S WINDOW WILL NOT CLOSE. WINDOW CONTACTING UPPER AFT WINDOW SEAL. SECURED SEAL, WINDOW OPS NORMAL IAW AMM 56-11-04-4.SDR DALA14036143221Door Frame · crackedDURING INSPECTION, ONE CRACK WAS FOUND AT LT AFT PASSENGER DOOR CUT-OUT AT FRAME 68 AND AT STRINGER 8L. REPAIRED IAW ERA 526355-14, SECT I. ERA 526355-14 SECTION I.SDR QXEA2014062600533Angle · corrodedFWD PAX DOOR SURROUND WEB TO SKIN ANGLE X26.7 AND X6.7 FOUND CORRODED. REMOVED ANGLES IAW SRM 51-42-05, STEP 4E. INSTALLED NEW ANGLES IAW SRM 51-42-05, STEP 4D.SDR SWAA2014062429364Window Frame · crackedFLIGHT DECK RT NR 1 WINDOW FRAME OTBD UPPER CORNER CRACKED. REPAIRED FRAME IAW ACO.SDR FDEA201406161468Crease Beam · corrodedCORROSION ON CREASE BEAM INNER CHORD STATION 377 BY DOOR L1. REMOVED CORROSION & FOUND TO BE OUT OF LIMITS IAW SRM 53-30-13 FIG 101 DETAIL II. R & R WITH NEW CREASE BEAM AT STATION 395 - 324 LBL 61 IAW SRM 51-40-02 & DWG 657N3383 MAJOR REPAIR.SDR SWAA2014070229585Window Post · crackedCOCKPIT RT NR 1 WINDOW POST CRACKED. REPAIRED POST IAW ACO.SDR SWAA2014070229584Window Post · crackedCOCKPIT LT NR 1 WINDOW POST CRACKED. REPAIRED POST IAW ACO.SDR SWAA2014070229582Window Post · crackedCOCKPIT LT NR 3 WINDOW POST CRACKED. REPAIRED POST IAW ACO.SDR DALA14035810963Doubler · crackedCRACK ON REPAIR DOUBLER BS 1451 BETWEEN LONGERONS 1 - 3L IN AFT ACCESSORY BAY. DOUBLER REMOVED IAW SRM 51-302. DOUBLER FABRICATED IAW D DING 991/860, REV L. DOUBLER INSTALLED IAW SRM 51-36-2 AND 51-30-5.SDR DALA14035673230Structure · corrodedDURING INSPECTION, FOUND CORROSION ON AFT LOWER CORNER FRAME 20. REPLACED AFT LOWER CORNER OF RT FWD PASSENGER/CREW DOOR CUT OUT IAW SRM 51-72-11 AND DWG D53112109.SDR SWAA2014070729669Window Frame · crackedRIGHT NR 1 FLIGHT DECK WINDOW FRAME, 1ST INBD HOLE CRACKED AT BS 217, WL 258. R & R FRAME IAW ACO.SDR DALA14035939233Beam · damagedNLG WHEEL WELL UPPER I-BEAM ASSEMBLY DAMAGED. R & R NLG WHEEL WELL UPPER I-BEAM ASSEMBLY IAW ERA 526178-14, REV O AND DWG 9957865.SDR DALA14035909232Web · damagedBS 101.55 CAPTAIN`S SIDE ELEVATOR CABLE FEED THROUGH AND WEB DAMAGED. REPAIRED IAW ERA 526158-14, REV O.SDR DALA14035770911Door Frame · corrodedFWD CARGO LOWER DOOR FRAME HAS COROSSION ON OUTER SURFACE IN SEVERAL AREAS BETWEEN BS 370-427. REPAIRED AREAS IAW ER/A 525958-14, REV ORIGINAL.SDR SWAA2014070729639Door Frame · crackedFORWARD CARGO DOOR CUT OUT FRAME WEB CRACKED AT BS 492, STRINGER 24R. R & R FRAME IAW SRM & DWG.SDR FDEA201406121412Crease Beam · corrodedRIGHT INBD CREASE BEAM UPPER SURFACE CORRODED BS 395. R & R CREASE BEAM ANGLE IAW SRM 51-40-02 & DWG 141N8422. MAJOR REPAIR.SDR UHLA2014061100455Crossbeam · mechanic errorMISDRILLED HOLE THROUGH CROSSBEAM AT FRAME 16. CUTOUT DAMAGE, FABRICATED A REPAIR FILLER AND DOUBLER, INSTALLED PARTS IAW ETD2014-170-0491107. MAJOR REPAIRSDR SWAA2014061629063Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED AT BS 850. REPAIRED WEB IAW SRM & DWG.SDR ASOA20140611125Beam · corrodedDURING C-CHECK, THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE R & R THE BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR FDEA201406101390Keelbeam · corrodedKEEL BEAM FITTING AT BS 1100 HAS CORROSION. REMOVED CORROSION IAW SRM 51-10-02, FOUND OUT OF LIMITS IAW SRM 53-40-12 FIG 101 DET IV. LOCATED & DRILLED IAW SRM 51-40-05, AND INSTALLED.SDR SWAA2014070829787Window Frame · crackedFLIGHT DECK RT NR 1 WINDOW FRAME UPPER OTBD CORNER CRACKED. R & R FRAME IAW ACO.SDR SWAA2014070329628Window Frame · crackedCOCKPIT RT WINDOW NR 3 POST FRAME CRACKED. R & R FRAME IAW SRM.SDR SWAA2014070329627Window Frame · crackedCOCKPIT LT WINDOW NR 3 POST FRAME CRACKED. R & R FRAME IAW SRM.SDR AALA20140621002Door Frame · crackedFORWARD ENTRY DOOR FRAME WEB, REPAIR DOUBLER CRACKED AT STATION 208 & LONGERON 15 LT. INSTALLED DOUBLER & FILLER IAW AARD 53-10-00-11.SDR R61A201406100782Check Valve · corrodedDURING HEAVY CHECK, FWD CARGO SIDE WALL CHECK VALVE SHOWS SIGNS OF CORROSION. MX R & R FWD CARGO SIDE WALL CHECK VALVE IAW AMM21-27-03.SDR SWIA201438352Stop Fitting · gougedLEFT EMERGENCY EXIT DOOR FRAME FWD TOP STOP FITTING NICKED AND GOUGED. C-CHECK, REPAIRED STOP FITTING IAW EA.SDR SWIA201438351Stop Fitting · gougedLEFT EMERGENCY EXIT DOOR FRAME FWD CENTER STOP FITTING NICKED AND GOUGED. C-CHECK, REPAIRED STOP FITTING IAW EA.SDR SWIA201438350Stop Fitting · nickedLEFT EMERGENCY EXIT DOOR FRAME FWD LOWER STOP FITTING NICKED. C-CHECK, REPAIRED LOWER STOP FITTING IAW EA.SDR SWIA201438349Stop Fitting · gougedLEFT EMERGENCY EXIT AFT CENTER STOP FITTING GOUGED. C-CHECK, REPAIRED STOP FITTING IAW EA.
Back to JASC 5310