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 CALA0200598Seat Track · corrodedINSPECTION FOUND R/H INBOARD SEAT TRACK CORRODED AT STA 229. A NEW SECTION OF SEAT TRACK WAS INSTALLED IAW SRM 53-05, FIGURE 4F.SDR CALA0200595Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT BS 1497-1567, RBL 74. THE SEAT TRACK WAS REPAIRED IAW ECRA 5310-04307.SDR 02FDEA00962Seat Track · corrodedMDCC FLOOR SEAT TRACK FLANGE FOUND WITH CORROSION AT STA 1521, LBL 8. TRIMMED CORRODED FLANGE AT STA 1521, LBL 8 IAW SRM. NON DESTRUCTIVE TESTING CARRIED OUT AT TRIMMED AREA IAW DAC NDT SPM. FAB FILLER AND STRAP IAW SRM. INSTALLED IAW SRM.SDR AALA20021829Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 3 STATION 1201-1205. REPLACED SEAT TRACK NR 3 FOR STATION 1186-1307 SRM 51-01. (M)SDR AALA20021828Seat Track · corrodedTUL - FOUND CORROSION ON NR 3 SEAT TRACK STATION 1280-1282. INSTALLED SEAT TRACK SPLICE PER SRM 53-05. (M)SDR AALA20021868Seat Track · corrodedTUL - FOUND CORROSION ON NR 6 SEAT TRACK AT FS 218. INSTALLED SEAT TRACK AND SPLICE REPAIR STATION 207-260 RIGHT, IAW SRM 53-05-00. (M)SDR AALA20021851Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 1. INSTALLED NEW SEAT TRACK PER SRM 53-05. (M)SDR AALA20021850Seat Track · corrodedTUL - FOUND CORROSION ON NR 1 SEAT TRACK, FS 1277-1281. INSTALLED NEW SEAT TRACK PER SRM 53-05. (M)SDR AALA20030063Galley Track · corrodedTUL - FOND GALLEY TIE DOWN TRACK CORRODED AT STATION 207 INBOARD OF NR 4 SEAT TRACK. REMOVED AND REPLACED TIE DOWN FITTING AT STATION 207 INBOARD OF NR 4 SEAT TRACK AS PER 51-01. (M)SDR AALA20030029Seat Track · corrodedTUL - FOUND NR 6 SEAT TRACK CORRODED AT 1ST FASTENER HOLE, STATION 216. REMOVED AND REPLACED NR 6 SEAT TRACK FROM STATION 216-303 PER SRM 53-05-00, FIG 4F, SHEET 1 THROUGH SHEET 11. (M)SDR AALA20030026Seat Track · corrodedTUL - FOUND NR 5 SEAT TRACK CORRODED FROM STATION 200-206. INSTALLED NEW SEAT TRACK FROM STATION 200R-247R PER SRM 53-05. (M)SDR ASAA0280660Seat Track · corrodedOKC - FOUND DURING 30K CHECK, SEAT TRACK CORRODED AT FS 275. REPLACED DAMAGED SECTION OF TRACK PER SRM 53-05. (M)SDR ASAA0280659Seat Track · corrodedOKC - FOUND DURING 30K CHECK, SEAT TRACK CORRODED AT FS 624. REPLACED DAMAGED SECTION OF TRACK PER SRM 53-05. (M)SDR ASAA0280658Seat Track · corrodedOKC - FOUND DURING 30K CHECK, SEAT TRACK CORRODED AT FS 826. REPLACED DAMAGED SECTION OF TRACK PER SRM 53-05. (M)SDR ASAA0280657Seat Track · corrodedOKC - FOUND DURING 30K CHECK, SEAT TRACK CORRODED AT FS 275. REPLACED DAMAGED SECTION OF TRACK PER SRM 53-05. (M)SDR AALA20030023Seat Track · corrodedTUL - FOUND CORROSION ON NR 1 SEAT TRACK AT STATION 672. INSTALLED SEAT TRACK PLUG PER SRM 53-05. (M)SDR AALA20030027Seat Track · corrodedTUL - FOUND NR 2 SEAT TRACK HAS CORROSION AT STATION 1300. REPAIRED PER SRM 53-05 FIG 4A AND AARD 53-20-00-10. (M)SDR AALA20030022Seat Track · corrodedTUL - FOUND CORROSION INSIDE SEAT TRACK NR 1, BEYOND MANUAL LIMITS, TRACK EAR TOO THIN. INSTALLED PLUGPER AARD 53-20-00-10, REPAIR NR 10. (M)SDR AALA20021852Seat Track · corrodedTUL - FOUND TRACK CORRODED BEYOND LIMITS UNDER GALLEY ATTACH POINTS, FS 1174-1320. SEAT TRACK REPLACED PER AMM 53-40-00-2. (M)SDR 2002F01113Seat Track · corrodedDURING SCHEDULED INSPECTION LEVEL 2 CORROSION DISCOVERED AT FORWARD FUSELAGE SECTION, FS 381, LBL 25, TM 91 IN SEAT ATTACH TRACK. MAINTENANCE REMOVED AND REPLACED SEAT TRACK IAW SRM.SDR QXEA0202128Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK X206 HAS A PIT ON THE OUTBOARD FLANGE. REPAIRED IAW DHC-8 SRM 51-30-26 AND SRM 51-40-11.SDR SIMA200234504Seat Track · corrodedABI - DUIRNG A MBV INSPECTION OF AIRCRAFT, THE CABIN SEAT TRACK 18.3L AT THE FORWARD END WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. REMOVED A 32 SECTION OF CORRODED SEAT TRACK. REPLACED SECTION IWA SAAB 340 SRM (72LKS 3079, REV 40) 53-70-60 PARA 2 AND STANDSDR SIMA200234503Seat Track · corrodedABI - DURING A MBV INSPECTION, THE CABIN SEAT TRACK BL 0 AT THE FORWARD END WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. REMOVED A 32 SECTION OF CORRODED SEAT TRACK. INSTALLED REPLACEMENT SECTION IAW SAAB 340 SRM (72LKS 3079 REV 40) 543-70-60 PARA 2 AND STANDSDR QXEA0202134Seat Track · gougedPDX - LEFT HAND OUTBOARD SEAT TRACK X275.5 HAS A GOUGE IN THE CHANNEL. REPAIRED IAW DHC-8 200 SRM 51-20-16.SDR QXEA0202133Seat Track · corrodedPDX - LEFT HAND OUTBOARD X348.5 SEAT TRACK HAS ONE PIT IN CHANNEL. REPAIRED IAW DHC-8 200 SRM 51-20-16.SDR QXEA0202132Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK X284.5 HAS TWO CORROSION PITS IN THE CHANNEL. REPAIRED IAW DHC-8 200 SRM 51-20-16.SDR QXEA0202131Seat Track · gougedPDX - LEFT HAND OUTBOARD SEAT TRACK X380 HAS ONE GOUGE ON THE TOP CAP. REPAIRED IAW DHC-8 200 SRM 51-20-16.SDR QXEA0202130Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK X468 TO X486 TOP CAPS HAVE LIGHT CORROSION. REPAIRED IAW DHC-8 200 SRM 51-20-16.SDR QXEA0202129Seat Track · gougedPDX - LEFT HAND OUTBOARD SEAT TRACK X542 HAS A GOUGE IN THE CHANNEL. REPAIRED IAW RD 8-53-3644 AND DHC-8 SRM 51-20-16.SDR QXEA0202127Seat Track · groovedPDX - LEFT HAND INBOARD SEAT TRACK X475 TO X488 HAS GROOVES IN TRACK. REPAIRED IAW DHC-8 200 SRM 51-20-16.SDR QXEA0202126Seat Track · gougedPDX - LEFT HAND INBOARD SEAT TRACK X446 TO X455 HAS GOUGES IN CHANNEL. REPAIRED IAW DHC-8 200 SRM 51-20-16.SDR QXEA0202124Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK X506 HAS A CORROSION PIT IN THE CHANNEL. REPAIRED IAW RD 8-53-1339 AND DHC-8 SRM 51-20-16.SDR QXEA0202123Seat Track · gougedPDX - LEFT HAND INBOARD SEAT TRACK X545 HAS A GOUGE IN THE CHANNEL. REPAIRED IAW DHC-8 SRM 51-20-16.SDR QXEA0202120Seat Track · groovedPDX - TRACK NR 3 HAS LIGHT LENGTH WISE GROOVES ALONG THE INNER AREA OF THE TRACK AT APPROXIMATELY STATION 428.00. REPAIRED IAW DHC-8 SRM 51-20-16.SDR QXEA0202119Seat Track · scoredPDX - SEAT TRACK NR 12 HAS SCORE MARKS AT STATION 522 AND 521. REPAIRED IAW DHC-8 200 SRM 51-20-16.SDR QXEA0202118Seat Track · scoredPDX - SEAT TRACK NR 8 HAS TWO LENGTH WISE SCORE MARKS APPROXIMATELY AT STATION 514.5. REPAIRED IAW DHCC-8 200 SRM 51-20-16.SDR QXEA0202117Seat Track · corrodedPDX - SEAT TRACK NR 8 CORROSION ON THE UPPER SURFACE AT APPROXIMATELY STATION 502. REPAIRED IAW DHC-8 200 SRM 51-20-16.SDR 02FDEA00913Seat Track · corrodedSEAT TRACK FROM BS 760 TO 850 IS CORRODED. LBL 25, WL 208. REPLACED SEAT TRACK AND T-CHORD OF LONGITUDINAL BEAM IAW SRM 53-10-5, 51-30-2 51-30-8.SDR QXEA0202121Seat Track · corrodedPDX - SEAT TRACK NR 7 FORWARD INBOARD RIGHT HAND HAS SEVERAL AREAS OF DEEP CORROSION PITS AT APPROXIMATELY STATION 213. REPAIRED IAW DHC08 SRM 51-30-26 AND SRM 51-40-11.SDR ASAA0210348Seat Track · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SEAT TRACK AT BS 887-947, RIGHT BUTTOCK LINE 45.5 CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0280617Cargo Track · corrodedOAK - FOUND C-CHECK, FOUND CORROSION ON SCREW HOLES AND MOUNT SCREWS ON LEFT TIEDOWN TRACK IN AFT CARGO BAY AT FS 1007 TO 1307 ABOVE LONGERON 28L. REPLACED TIEDOWN TRACK PER SRM 51-10-4, 51-30-1, AND 51-10-3. (M)SDR QXEA0202125Seat Track · gougedPDX - LEFT HAND INBOARD SEAT TRACK AT X488 HAS A PREVIOUSLY BLENDED GOUGE. REPAIRED IAW HORIZON AIR EA 2-53-241.SDR QXEA0202097Seat Track · corrodedPDX - NR 10 SEAT TRACK RIGHT HAND FORWARD OUTBOARD HAS THREE AREAS OF DEEP CORROSION AT STATION 279.00, 315.00 AND 327.00. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA0202096Seat Track · corrodedPDX - SEAT TRACK NR 11 HAS A DEEP CORROSION PIT AT STATION 502.00. REPAIRED IAW DHC-8 SRM 51-40-11.SDR GTIA021278Seat Track · corrodedFTW - FOUND LEFT MID SEAT TRACK WORN AND CORRODED FS 1212-1309. SEAT TRACK STATION 1227 TO 1309 LEFT MID WAS FOUND TO BE CORRODED OUT OF LIMITS. REMOVED SEAT TRACK. LOCATED AND DRILLED NEW SEAT TRACK. INSTALLED LEFT MID SEAT TRACK. (M)SDR GTIA021275Seat Track · corrodedFTW - FOUND LEFT INBOARD SEAT TRACK WORN AND CORRODED FS 1212-1309. STATION 1227-1250 ON LEFT INBOARD SEAT TRACK WAS FOUND TO BE OUT OF LIMITS. REMOVED LEFT INBOARD SEAT TRACK. LOCATED AND DRILLED NEW SEAT TRACK. INSTALLED LEFT INBOARD SEAT TRACK. (M)SDR GTIA021274Seat Track · corrodedFTW - FOUND LEFT INBOARD SEAT TRACK WORN AND CORRODED FS 237-863. REMOVED FLOOR PANEL FS 768-826 LBL 22-44 TO REMOVED CORROSION. FOUND THE FLOOR BOARD AT FS 768-826 LBL 22-44 MISSING INSERT AND CRACK EDGE. FABRICATED NEW FLOOR BOARD. INSTALLED FLOOR BOARD.SDR CALA0200567Cargo Track · crackedINSPECTION FOUND A 7 INCH CRACK IN TIE DOWN RAIL AT STA 807, RBL 14. THE TIE DOWN RAIL WAS REMOVED AND REPLACED IAW SRM 53-00-53, FIGURE 202.SDR GTIA021260Seat Track · corrodedFTW - FOUND RIGHT INBOARD SEAT TRACK CORRODED AT STATION 200 AND 256. MATERIAL LOSS OUT OF LIMITS AT SEAT TRACK STATION 267. REMOVED DAMAGE AREA. FABRICATED NEW SEAT TRACK FS 200-320. INSTALLED SEAT TRACK AND SPLICE. (M)SDR AUS20021378Seat Track · cracked(AUS) SEAT TRACK CRACKED ACROSS LOCK PIN HOLES.
Back to JASC 5347