JASC 5347
Service difficulty reports · 66,435
Reports filed under 5347 · Fuselage, Seat/Cargo Attach Fittings, 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 = '5347' 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 = '5347' 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 QXEA0101208Seat Track · corrodedPDX-SEAT TRACK NR 8 HAS CORROSION INSIDE TRACK AT STATION 435. REPAIRED IAW DHC-8 SRM 51-20-26 AND RD8-53-1339.SDR SIMA200119902Seat Track · corrodedSAW - DURING CPCP8 INSPECTION, FOUND CORROSION ON SEAT TRACKS, RIGHT FORWARD OUTBOARD, LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, AND LAVATORY, THE SEAT TRACKS WERE REMOVED AND REPLACED IAW AMERICAN EAGLE AIRLINES EO E2-53MR-115. THE AIRCRAFT WAS RETURNEDSDR SIMA200119911Seat Track · corrodedSAW - DURING CPCP8 INSPECTION, FOUND CORROSION ON SEAT TRACKS, RIGHT FORWARD OUTBOARD, LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, AND LAVATORY, THE SEAT TRACKS WERE REMOVED AND REPLACED IAW AMERICAN EAGLE AIRLINES ENGINEERING ORDER SDR SIMA200119907Seat Track · corrodedSAW - DURING CPCP2 INSPECTION, FOUND CORROSION ON LEFT AFT OUTBOARD, LEFT AFT INBOARD, LEFT FLIGHT ATTENDANT, AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW AMERICAN EAGLE AIRLINES ENGINEERING ORDER E2-53MR-115. THE AIRSDR ZW0A0105407Seat Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON CABIN FLOOR TRACK, LBL 44, STA 1136 TO 1174, AND 1174 TO 1231. CLEANED MINOR CORROSION STA 1200 TO 1231 PER SPM 6-80-01. TREATED PER SRM 51-10-3. REMOVED TRACK AT STA 1080 TO 1200 AND REPLACED WITH NEW TRACK SECTION.SDR UPS01836478Seat Track · corrodedINSPECTION TYPE:C1/3 MAIN CABIN AT STA 740-810 & LBL 47 SEAT TRACK HAS CORROSION INBD & OTBD SIDES OF SEAT TRACK AROUND FASTENER HOLES (UNDER SIDE). REMOVED CORROSION FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED SEAT TR ACK, FABED NEW SEAT TRACK, AND INSTALLED NSDR 01FDEA00591Seat Track · damagedNR 2 SEAT TRACK DAMAGED AT BS 1421 MAIN DECK COMPT. *S/D* SMOOTHED AND FOUND WITHIN LIMITS PER SRM 53-70-00 FIG 3.SDR 01FDEA00590Seat Track · damagedDAMAGED SEAT TRACK NR 8 BS 1361 TO 1401 8 IN AT MAIN CARGO DECK. *S/D* REMOVED AND REPLACED PER SRM 53-70-00 FIG 1 VOL 1.SDR 01FDEA00589Seat Track · damagedDAMAGED NR 3 SEAT TRACK BS 1059 MAIN CARGO COMPT. *S/D* REMOVED AND REPLACED PER SRM 53-70-00 FIG 1 VOL 1.SDR 01FDEA00587Seat Track · corrodedCABIN CORROSION FOUND ON SEAT TRACK CAVITY AROUND BS 540 & X=-8. *S/D* REMOVED AND REPLACED PER SRM 53-70-00 FIG 1 VOL 1.SDR AWXA0001992Seat Track · corrodedPASSENGER CABIN SEAT TRACK TOP FLANGE CORRODED AROUND FASTENER HOLES B/S 420, RBL 44. REMOVED AND REPLACED SEAT TRACK SUPPORT B/S 420, RBL 44, IAW SRM 51-40-02 FIG 12 PAGE 42.SDR AWXA0002042Seat Track · corrodedD: Pass. Cabin BS 395-377 seat track corroded @ RBL 24 O/B flangeC: Removed damaged channel (track) IAW SRM 51-40-05 fig 39-40. Fabricated track, treated primed, installed per SRM 51-40-02 pg 26 SRM 51-20-01 pg 1-3 SRM 51-30-01 pg 11 (STA 395-377,RBL 24) and pSDR RRXA11406Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION ON SEAT TRACK STA 1240 RBL 48. REMOVED DAMGED AREA AND FABRICATED REPLACEMENT PART AND INSTALLED IAW SRM 53-2-3 FIG 14 AND SRM 51-3-00.SDR MWEA011035Seat Track · wornCAPTAINS AFT OUTBOARD SEAT TRACK IS WORN AROUND LOCK PIN HOLES. -- REMOVED DAMAGE FROM SEAT TRACK UPPER CAP SURFACE, FABRICATED AND INSTALLED REPAIR DOUBLER.SDR MWEA011033Seat Track · wornFIRST OFFICERS OUTBOARD SEAT TRACK IS WORN AROUND LOCK PIN HOLES. -- FABRICATED, LOCATED, DRILLED AND INSTALLED NEW SEAT TRACK.SDR MWEA011032Seat Track · wornCAPTAINS AFT INBOARD SEAT TRACK IS WORN AROUND LOCK PIN HOLES. -- REMOVED DAMAGED FROM SEAT TRACK, FABRICATED AND INSTALLED REPAIR DOUBLER.SDR MWEA011031Seat Track · wornFIRST OFFICERS AFT INBOARD SEAT TRACK IS WORN AROUND LOCK PIN HOLES. -- REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR DOUBLER.SDR ZW0A0105107Seat Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON NUMBER 2 FLOOR TRACK AT RBL 22, STA 1080 TO 1250. REPLACED TRACK PER SPM 6-70-01 AND SRM 53-05, FIG 4. PRIMED PER SRM 51-10-3. REMOVED CORROSION PER SPM 6-80-01.SDR UPS01836523Seat Track · corrodedINSPECTION TYPE:C1/3 SEAT TRACK E AT STA 980 HAS CORROSION. REMOVED AND REPLACED SEAT TRACK.SDR UPS01836343Seat Track · corrodedINSPECTION TYPE:C1,3 STA 470 TRACK G HAS CORROSION DOWN CTR. FOUND TO BE BEYOND ALLOWABLE LIMITS IAW DC8 SRM 53-2-3 FIG 12.SDR 01FDEA00531Seat Track · damagedMAIN DECK FLOOR TRACK DAMAGED AT BS Y=800 X= 47. *S/D* REMOVED AND REPLACED SEAT TRACK PER SRM 51-70-00 FIG 1 VOL 1.SDR ZW0A0104905Seat Track · corrodedDURING CHECK-C MAINT FOUND CHAIR TRACK CORROSION AT STA 1030 TO 1211 LBL 22 INCHES, STA 1079 TO 1136 LBL 22 INCHES, STA 1136 AND LBL 22 INCHES, AND HOLES DRILLED IN BOTTOM OF TRACK AT LBL 22 INCHES STA 1136 TO 1170. REPLACED TRACK FROM STA 1030 TO 1211 PER SRSDR ABXA010397Seat Track · dirtyAFTER MOVING THE CAPTAIN'S SEAT FORWARD OR AFT, THE HANDLE DID NOT LOCK DOWN ALLOWING THE SEAT TO MOVE. CLEANED AND LUBRICATED THE SEAT TRACK. CHECKED GOOD IAW DC-8 MM 25-11-01.SDR ASAA0110486Seat Track · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SEAT TRACK AT BS 344-520, LBL 62.5 CORRODED. REPAIRED PER SRM. (M)SDR RRXA11402Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION ON SEAT TRACK FS STA 600 LBL 48. REMOVED DAMAGED AREA, FABRICATED REPLACEMENT SECTION AND INSTALLED IAW 53-2-3 FIG 14 AND SRM 51-1-20DSDR QXEA0101153Seat Track · corrodedPDX - FORWARD LEFT-HAND CENTER SEAT TRACK NR 4 HAS CORROSION ON TOP OF TRACK AT FORWARD END OF TRACK AT APPROIMATELY STATION X262.400. REPAIRED IAW HORIZON AIR EA 2-53-304.SDR QXEA0101152Seat Track · corrodedPDX - FORWARD LEFT-HAND CENTER SEAT TRACK NR 4 HAS CORROSION ON OUTBOARD FLANGE AT APPROXIMATELY STATION X234.500. REPAIRED IAW HORIZON AIR EA 2-53-304.SDR 2001UALA01322Seat Track · corrodedAFT CABIN O/B SEAT TRACK HAS CORROSION IN SEVERAL AREAS, BS 986 - BS 1006. REPLACED RT OUTBOARD TRACK SECTION. MAJOR REPAIR ACCOMPLISHED.SDR QXEA0101261Seat Track · corrodedYYC-LEFT HAND INBOARD SEAT TRACK BETWEEN FRAMES 8305 AND 8805 IS CORRODED. REPAIRED IAW FOKKER SRM 53-10-4, PAGE 9.SDR QXEA0101260Seat Track · corrodedYYC-CORROSION ON RIGHT HAND OUTBOARD SEAT TRACK AT FRAME 4610. REPAIRED IAW FOKKER SRM 53-10-4, PAGE 9.SDR QXEA0101259Seat Track · corrodedYYC-CORROSION ON RIGHT HAND INBOARD SEAT TRACK BETWEEN FRAMES 14285 AND 14755. REPAIRED IAW FOKKER SRM 53-10-4, PAGE 9.SDR QXEA0101258Seat Track · corrodedYYC-CORROSION ON RIGHT HAND INBOARD SEAT TRACK AT FRAME 13815B. REPAIRED IAW FOKKER SRM 53-10-4, PAGE 9.SDR QXEA0101257Seat Track · corrodedYYC-CORROSION ON LEFT HAND INBOARD SEAT TRACK BETWEEN FRAMES 15205 AND 15635. REPAIRED IAW FOKKER SRM 53-10-4, PAGE 9.SDR QXEA0101256Seat Track · corrodedYYC-CORROSION ON LEFT HAND INBOARD SEAT TRACK AT FRAME 13345. REPAIRED IAW FOKKER SRM 53-10-4, PAGE 9.SDR QXEA0101255Seat Track · corrodedYYC-CORROSION ON RIGHT HAND INBOARD SEAT TRACK BETWEEN FRAMES 12405 AND 12875. REPAIRED IAW FOKKER SRM 53-10-4, PAGE 9.SDR QXEA0101254Seat Track · corrodedYYC-CORROSION ON LEFT HAND INBOARD SEAT TRACK AT FRAME 10966. REPAIRED IAW FOKKER SRM 53-10-4, PAGE 9.SDR QXEA0101154Seat Track · gougedPDX - FORWARD RIGHT-HAND OUTBOARD SEAT TRACK NR 10 HAS GOUGES AT APPROXIMATELY STATION X436.500. REPAIRED IAW HORIZON AIR EA 2-53-305, STEP 3.SDR ASAA0110464Seat Track · wornPHX - DURING SCHEDULED D-CHECK, FOUND SEAT TRACK LUGS AT BS 420-480, LEFT BUTTOCK LINE 24.5 WORN. REPAIRED PER SRM. (M)SDR QXEA0101157Seat Track · corrodedPDX - FORWARD OUTBOARD SEAT TRACK NR 10 HAS CORROSION INSIDE TRACK CHANNEL AT CUTOUT. LOCATED AT APPROXIMATELY STATION X252.700. REPAIRED IAW RD 8-53-1342.SDR QXEA0101156Seat Track · corrodedPDX - FORWARD RIGHT-HAND OUTBOARD SEAT TRACK NR 10 HAS CORROSION INSIDE TRACK CHANNEL AT APPROXIMATELY X302.400. REPAIRED IAW RD 8-53-1342.SDR QXEA0101155Seat Track · corrodedPDX - FORWARD RIGHT-HAND OUTBOARD SEAT TRACK NR 10 HAS CORROSION ON TOP OF SEAT TRACK RAIL AT APPROXIMATELY STATION X376.110. REPAIRED IAW RD 8-53-1342.SDR DHL2001803501Seat Track · brokenFWD CARGO COMPARTMENT-R/H TRACK LUGS BROKEN AND WORN AND POINTS OF CORROSION BETWEEN STA 160.00 AND 260.00.REMOVED DAMAGED TRACK(STA 160-260)PER SRM 51-3-0 PAGE 1. CLEANED TREATED AND PRIMED PER SRM 51-1-8 B.INSTALLED NEW TRACK (P/N S2955978)PER SRM 51-3-0 PAGSDR DHL2001803500Seat Track · brokenDURING C CHK FOUND FWD CARGO COMPARTMENT R/H TRACK LUGS BROKEN WORN AND POINTS OF CORROSION BETWEEN STA 70.000 AND STA 160.000.REMOVED DAMAGED TRACK(STA70-160)PER SRM 51-1-88.CLEANED TREATED AND PRIMED AREA PER SRM 51-1-88.INSTALLED NEW TRACK P/N S 2955978 PERSDR UPS01836339Seat Track · corrodedINSPECTION TYPE:C2 STA 1100 TO 1120 RBL 24 SEAT TRACK IS CORRODED BEYOND LIMITS. REPAIRED SEAT TRACK IAW SRM 53-2-3 FIG 8A.SDR UPS01836338Seat Track · corrodedINSPECTION TYPE:C2 STA 1100-1120 LBL 46 SEAT TRACK IS CORRODED BEYOND LIMITS. REPAIRED SEAT TRACK IAW SRM 53-2-3 FIG 8A.SDR USAA010852Seat Track · corrodedPIT - FOUND SEAT TRACK CORRODED 3 INCH BY 6 INCH, NR 2 GALLEY MIDDLE SEAT TRACK STATION 328 GOING AFT. (M)SDR USAA010851Seat Track · corrodedPIT - FOUND SEAT TRACK CORRODED 3 INCHES BY 6 INCHES, NR 2 GALLEY SEAT TRACK STATION 328 AFT. (M)SDR UPS01836354Seat Track · corrodedINSPECTION TYPE:C2 STA 1620 - 1660 SEAT TRACK IS CORRODED BEYOND LIMITS AT BL 0. REPAIRED SEAT TRACK IAW SRM 53-2-3 FIG 8A.SDR DHL2001803547Seat Track · wornMAIN CARGO COMPT - LUGS WORN ON CENTRAL TRACK AT STA 163.00 TO STA 62.000.REMOVED DAMAGED CTR TRACK (STA 62-163)PER SRM 51-3-0 PG 1.CLEANED TREATED AND PRIMED AREA PER SRM 51-1-8B.INSTALLED NEW TRACK PER SRM 57-3-0 PG 1 AND 51-3-1 PG 1SDR CALA0100610Cargo Track · corrodedINSPECTION FOUND FORWARD PIT RT SIDE CARGO TIE DOWN TRACK CORRODED AT LOWER SIDE OF FASTENER HOLES FROM FS 218 TO FORWARD DOOR FRAME. THE TIE DOWN TRACK AND ATTACHING ANGLE WERE REMOVED AND A NEW TRACK AND ATTACH ANGLE WERE INSTALLED IAW SRM 51-30-2 AND 51-30
Back to JASC 5347