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 MALA020292Seat Track · corrodedDURING 4K-CHECK IN CWA, FOUND CORROSION OUT OF SAAB SRM LIMITS ON LT CENTER AISLE SEAT TRACK LBL 18.3, FWD PORTION. MAINTENANCE COMPLETED REPAIR FROM STA 297 TO 372 IAW EO 53060.SDR CALA2000280Seat Track · corrodedRIGHT O/B SEAT TRACK PITTED UNDER G-2 GALLEY AT APPROXIMATELY STA 208. REPLACED O/B SECTION OF SEAT TRACK IAW SRM 53-05, FIG 4F.SDR GTIA020594Cargo Track · corrodedFTW - FORWARD LOWER CARGO PIT, CORRODED AT RT CARGO TRACK STATION 427. REMOVED RIGHT CARGO TRACK STATION 427 TO 636. FABRICATED A NEW TRACK. INSTALLED NEW TRACK FRONT STATION 427-636. (M)SDR UPS02438492Seat Track · corrodedINSPECTION TYPE:C M/D- SEAT TRACK FOUND SLIGHTLY CORRODED BS 510-BS 520, LBL 91. CORROSION REMOVED IAW SRM 51-10-01. BLEND OUT NOT WITHIN SRM 53-10-01 FIG 1 LIMITS, FOR REPAIR REFER TO SRM FIG 53-10-05 FIG 1A.SDR UPS02438472Seat Track · corrodedINSPECTION TYPE:C M/D- ZONE-E SEAT TRACK FOUND BULGE UP AT BS 2150 - 2163 LBL 98. CORROSION REMOVED IAW SRM 51-10-01. BLEND OUT NOT WITHIN SRM 53-10-01 FIG 1 LIMITS, FOR REPLACEMENT REFER TO SRM FIG 51-10-01 PG 8.SDR 2002UALA00872Seat Track · corrodedRIGHT I/B SEAT TRACK AT RBL 25 CORRODED STATION 680 TO STATION 700 ON I/B FLANGE. MAJOR REPAIR ACCOMPLISHED. SEAT TRACK REPLACED FROM STA 620-700.SDR AALA20020807Seat Track · corrodedTUL - FOUND SEAT TRACK NR 6 CORRODED STATION 451-458. INSTALLED SLAT TRACK REPAIR PER SRM 53-05 FIG 4A SHEET 1 AND 2. (M)SDR UPS02438477Seat Track · corrodedINSPECTION TYPE:C M/D- SEAT TRACK FOUND SLIGHTLY CORRODED BS 240 TO 260, RBL 50 TO RBL 53. CORROSION REMOVED IAW SRM 51-10-01. BLEND OUT NOT WITHIN SRM 53-10-01 FIG 1 LIMITS, FOR REPAIR REFER TO SRM FIG 53-10-05 FIG 1A.SDR UPS02438475Seat Track · corrodedINSPECTION TYPE:C M/D SEAT TRACK FOUND CORRODED BS 406 TO 406, RBL R57. CORROSION REMOVED IAW SRM 51-10-01. BLEND OUT NOT WITHIN SRM 53-10-01 FIG 1 LIMITS, FOR REPAIR REFER TO SRM FIG 53-10-05 FIG 1A.SDR UPS02838391Seat Track · corrodedINSPECTION TYPE:C13 SEAT TRACK E AT STA 1140 CORRODED AT POSITION-B. REMOVED AND REPLACED SECTION OF SEAT TRACK IAW DC8 SRM 53-2-3 AND UPS EO DC8-5320-5167C.SDR UPS02438397Seat Track · crackedINSPECTION TYPE:C M/D- SEAT TRACK FOUND CRACK BS 460 RBL R88. SEAT TRACK REPLACED AS PER SRM 53-10-05 FIG 1A.SDR UPS02438394Seat Track · corrodedINSPECTION TYPE:C M/D SEAT TRACK FOUND CORROSION CRACK. SEAT TRACK REPLACED AS PER SRM 53-10-05 FIG 1A.SDR QXEA0200821Seat Track · corrodedPDX - NR 12 SEAT TRACK IS CORRODED ON UPPER AND INNER SURFACED. REPAIRED IAW DHC-8 SRM 51-20-16.SDR QXEA0200820Seat Track · corrodedPDX - NR 1 SEAT TRACK CORRODED HAS DEEP PITTING ON INNER SURFACE. REPAIRED IAW DHC-8 SRM 51-40-00.SDR CALA2000268Seat TrackSEAT TRACK AT F/S 390 RH O/B IS HEAVILY CORRODED APPROXIMATELY 4"X19'. REMOVED AND REINSTALLED AIR GRILL F/S 200-484 RH O/B IAW SRM 51-30-1. REMOVED AND REINSTALLED FLOOR PANELS F/S 256-465 RH O/B IAW SRM 51-30-1. INSTALLED NEW SEAT TRACK, SPLICE, & FITTING IASDR ASAA0280164Cargo Track · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON CARGO BAY LEFT TIEDOWN TRACK AT FS 1007 TO 1220. REPLACED CARGO TRACK PER SRM'S 51-10-3, 51-10-3B, 51-10-4, AND 53-05. (M)SDR SWIA200210901Seat Track · corrodedLEFT SIDE AFT SECTION OF SEAT RAIL NEEDS TO BE REPLACED DUE TO CORROSION. REMOVED AND REPLACED SEAT RAIL IAW MM 53-01-05.SDR QXEA0200782Seat Track · corrodedPDX- NR 8 SEAT TRACK HAS LIGHT SURFACE CORROSION ON OUTBOARD FLANGE AT STATION X442 - X478. REPAIRED IAW RD-8 53-1339, RD-8 53-4473 AND RD-8 53-4472.SDR QXEA0200794Seat Track · corrodedPDX- NR 10 SEAT TRACK CORRODED UPPER AND INNER SURFACES AT STATION X373-X376. REPAIRED IAW RD-8 53-1342, SRM 51-40-00 AND SRM 51-40-11.SDR CALA2000262Seat TrackCAPTAINS UPPER AND LOWER SEAT TRACKS WORN, REPAIRED AND REINSTALLED TRACKS IAW SRM 51-30-1 & 53-40-01.SDR AALA20020733Seat Track · corrodedTUL - FOUND CORROSION FS 1200-1271. REPLACED NR 3 SEAT TRACK FROM STATION 1200-1271. (M)SDR AALA20020732Seat Track · corrodedTUL - FOUND CORROSION FS 1200-1271. REPLACED NR 3 SEAT TRACK FROM STATION 1200-1271. (M)SDR AALA20020736Seat Track · corrodedTUL - NR 5 SEAT TRACK HAS CORROSION AT FLOORBOARD ATTACH HOLE, AT STATION 200, RIGHT FLANGE. REMOVED CORROSION PER SRM 51-10-03. INSTALLED DOUBLER PER AARD 53-20-00-13. (M)SDR QXEA0200786Seat Track · corrodedPDX- NR 7 SEAT TRACK IS CORRODED BEYOND LIMITS. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA0200785Seat Track · corrodedPDX- NR 4 SEAT TRACK HAS MULTIPLE AREAS OF CORROSION BEYOND LIMITS. REPAIRED IAW RD-8 53-1102, RD-8 53-2075, SRM 51-40-11, SRM 51-40-00 AND RD-8 53-4473.SDR QXEA0200758Seat Track · corrodedPDX- NR 3 SEAT TRACK HAS AREAS OF LIGHT CORROSION AT STATION X515 - X517, X529 - X531 AND X541 - X543. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0200757Seat Track · corrodedPDX- NR 9 SEAT TRACK IS CORRODED ON INBOARD FLANGE STATION X598. REPAIRED IAW RD-8 53-4936 AND HORIZON AIR EA 2-53-390.SDR AALA20020691Seat Track · corrodedCORROSION, NR 6 SEAT TRACK AROUND FASTENER HOLE AT STA 1003. INSTALLED STRAP ON SEAT TRACK FLANGE PER AARD.SDR QXEA0200781Seat Track · corrodedPDX- NR 11 SEAT TRACK IS CORRODED ON UPPER AND INNER SURFACES AT STATION X498 - X501. REPAIRED IAW RD-8 53-1342.SDR QXEA0200780Seat Track · corrodedPDX- NR 11 SEAT TRACK IS CORRODED ON UPPER AND INNER SURFACES AT STATION X484 - X487. REPAIRED IAW RD-8 53-1342.SDR QXEA0200779Seat Track · corrodedPDX- NR 11 SEAT TRACK IS CORRODED ON UPPER AND INNER SURFACES AT STATION X452 - X454. REPAIRED IAW RD-8 53-1342.SDR QXEA0200778Seat Track · corrodedPDX- NR 11 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES AT STATION X436 - X439. REPAIRED IAW RD-8 1342.SDR QXEA0200774Seat Track · corrodedPDX-NR 2 SEAT TRACK IS CORRODED ON INNER AND UPPER SURFACES AT STATION X484 - X486. REPAIRED IAW RD-8 53-1342.SDR QXEA0200773Seat Track · corrodedPDX- NR 2 SEAT TRACK IS CORRODED ON INNER AND UPPER SURFACES AT STATION X467 - X470. REPAIRED IAW RD-8 53-1342.SDR QXEA0200772Seat Track · corrodedPDX- NR 2 SEAT TRACK IS CORRODED ON INNER AND UPPER SURFACES AT STATION X437.5 - X440. REPAIRED IAW RD-8 53-1342.SDR QXEA0200761Seat Track · corrodedPDX- NR 6 SEAT TRACK IS WORN AND CORRODED ON INNER SURFACE AT STATION X542 - X545. REPAIRED IAW RD-8 53-4936.SDR QXEA0200743Seat Track · corrodedPDX- NR 6 SEAT TRACK CORRODED ON OUTBOARD FLANGE STATION X593 - X597. REPAIRED IAW RD-8 53-4936.SDR QXEA0200742Seat Track · corrodedPDX- NR 6 SEAT TRACK IS CORRODED ON INBOARD FLANGE STATION X545 - X549. REPAIRED IAW RD-8 53-4936.SDR QXEA0200741Seat Track · corrodedPDX- NR 9 SEAT TRACK IS CORRODED ON INBOARD FLANGE. REPAIRED IAW RD-8 53-4936.SDR AALA20020701Seat Track · corrodedTUL - FOUND CORROSION ON LOWER SIDE OF NR 3 SEAT TRACK AROUND CLIPNUT HOLES BETWEEN STATION 1271-1309. INSTALLED NEW SECTION OF SEAT TRACK FROM STATION 1258-1309 PER SRM 51-01 AND AARD 51-60-00-08. (M)SDR AALA20020700Seat Track · corrodedTUL - FOUND STATION 1300-1302 NR 3 SEAT TRACK CORRODED. INSTALLED NEW SECTION OF SEAT TRACK FROM STATION 1258-1309 PER SRM 51-01 AND AARD 51-60-00-08. (M)SDR AALA20020699Seat Track · corrodedTUL - FOUND STATION 1276-1280 NR 3 SEAT TRACK CORRODED. INSTALLED NEW SECTION OF SEAT TRACK FROM STATION 1258-1309 PER SRM 51-01 AND AARD 51-60-00-08. (M)SDR SIMA200214815Seat Track · corrodedABI - THIS IS A LEVEL 2 FINDING. RIGHT SEAT TRACK PROFILE HAS CORROSION BETWEEN FRAMES 24 AND 29. BLENDED AND PERFORMED NDT, FOUND TO BE ACCEPTED AS IS IAW EMB GST-1491/02. (M)SDR AALA20020677Seat Track · corroded(SEAT TRACK) CORROSION AROUND CLIP NUT HOLES UNDERSIDE INBOARD SEAT TRACK NR 3 STA 1271-1309. INSTALLED NEW SECTION OF SEAT TRACK FROM STA 1258 TO STA 1309 PER SRM 51-30 AND SRM.SDR MALA020272Seat Track · corrodedDURING 4K-CHECK IN CWA, SEAT TRACK LBL 18.3 HAS CORROSION. MAINTENANCE REPLACED SEAT TRACK FROM STA 297-329 IAW EO 53060.SDR ASOA02272Seat Track · corrodedDURING C-CHECK INSPECTION, THE RIGHT FORWARD WALL SEAT TRACK WAS CORRODED OUT OF LIMITS BETWEEN FRAMES 15 AND 32. MAINTENANCE REMOVED AND REPLACED THE CORRODED WALL SEAT TRACK IAW ASA EO 120-25-0007C, WHICH USES EST-381/93, DATED 30 AUGUST 1993, AS A REFERENCSDR ASOA02271Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE LEFT FORWARD FLOOR SEAT TRACK WAS FOUND CORRODED BEYOND LIMITS BETWEEN FRAMES 15 AND 32. MAINTENANCE REMOVED AND REPLACED THE CORRODED SEAT TRACK IAW SRM'S 51-25-00, 51-40-06, 51-10-00. MAINTENANCE ALSO COMPLIED WITH ASASDR AALA20020605Seat Track · corrodedTUL - FOUND CORROSION AROUND MOUNT HOLE FOR G-4 GALLEY IN NR 1 SEAT TRACK, STATION 1174. REMOVED CORRODED TRACK. INSTALLED NEW TRACK, STATION 1174 TO 1309 PER SRM 51-00. (M)SDR USAA020181Cargo Track · corrodedPIT - FOUND FLOOR RAIL HAD CORROSION SCATTERED OVER 98.5 INCHES, CARGO FLOOR RAIL RBBL 13.80 STATION 853-780. CORROSION LEVEL 1. SPLICED IN NEW FLOOR RAIL PER SRM 53-00-53. (M)SDR AALA20020698Seat Track · corrodedTUL - FOUND NR 2 SEAT TRACK CORRODED. REPLACED NR 2 SEAT TRACK STATION 1185-1309 PER AARD 51-60-00-08. (M)
Back to JASC 5347