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 QXEA0200310Seat Track · corrodedPDX - RT INBOARD SEAT TRACK FROM FRAME 6305 FORWARD ALONG INSIDE CHANNEL HAS CORROSION. REPAIRED IAW FOKKER SRM 53-40-01.SDR ZW0A0201807Cargo Track · corrodedDURING CHECK-C MAINT IN CARGO COMPT FOUND CORROSION ON TIE DOWN TRACK AT STA 785, RT SIDE. REPLACED TRACK WITH NEW AT STA 693 TO 788 PER SPM 6-70-01.SDR USAA020080Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED 1 INCH BY 3 INCHES, STATION 377 LBL 25. CORROSION LEVEL 1, TASK NR C53-221-03. FABRICATED AND INSTALLED SEAT TRACK SECTION LBL 25 BETWEEN STATION 377 AND 440 PER SRM 53-00-52. (M)SDR QXEA0200215Seat Track · corrodedPDX- RT INBOARD SEAT TRACK AT FRAME 13345 FORWARD INBOARD FLANGE HAS PITTING CORROSION. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 206 AND 51-10-04 PAGE 9.SDR AALA20020182Seat Track · corrodedTUL - FOUND CORROSION ON NR 6 SEAT TRACK FORWARD END, STATION 215 AROUND FIRST FLOORBOARD SUPPORT FASTENER HOLE OUTBOARD SIDE. INSTALLED NEW SECTION OF NR 6 SEAT TRACK AND SPLICE PER SRM 53-05. (M)SDR QXEA0200269Seat Track · corrodedPDX - LT INBOARD SEAT TRACK FROM STATION 423.346 TO STATION 403.661 BOTH MATTING FLANGES ARE PITTED AND HAVE CORROSION.SDR QXEA0200265Seat Track · gougedPDX - LT INBOARD SEAT TRACK AT STATION 403.668 TOP LUGS HAVE GOUGES.SDR QXEA0200259Seat Track · gougedPDX - LT INBOARD SEAT TRACK AT STATION 386.029 TOP LUGS HAVE GOUGES.SDR QXEA0200258Seat Track · gougedPDX - LT INBOARD SEAT TRACK AT STATION 403.661 TOP LUGS HAVE GOUGES.SDR QXEA0200256Seat Track · corrodedPDX - LT INBOARD SEAT TRACK AT STATION 386.017 TO STATION 366.338 MOST INBOARD FLANGE HAS PITTING AND CORROSION.SDR QXEA0200255Seat Track · corrodedPDX - LT INBOARD SEAT TRACK AT STATION 366.338 TO STATION 346.646 MOST INBOARD FLANGE HAS PITTING AND CORROSION.SDR QXEA0200219Seat Track · corrodedPDX- RT INBOARD SEAT TRACK AT STATION 649.400 IN TUNNEL IS CORRODED. REPAIRED IAW FOKKER SRM 53-01-01 PAGE 8, 53-40-01 PAGE 206 AND 51-10-4 PAGE 9.SDR QXEA0200218Seat Track · corrodedPDX- RT INBOARD SEAT TRACK AT FRAME 13815B JUST FORWARD ABOUT 2.5 INCHES IN TUNNEL THERE IS CORROSION. REPAIRED IAW FOKKER SRM 53-01-01 PAGE 8, 53-40-01 PAGE 206 AND 51-10-4 PAGE 9.SDR QXEA0200217Seat Track · corrodedPDX- RT INBOARD SEAT TRACK AT FRAME 13815 AFT INSIDE LUGS HAVE CORROSION. REPAIRED IAW FOKKER SRM 53-01-01 PAGE 8, 53-40-01 PAGE 206 AND 51-10-4 PAGE 9.SDR QXEA0200216Seat Track · corrodedPDX- RT INBOARD SEAT TRACK AT FRAME 13815 FORWARD INSIDE TUNNEL HAS CORROSION. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 206 AND 51-10-04 PAGE 9.SDR QXEA0200214Seat Track · corrodedPDX- RT INBOARD SEAT TRACK FROM FRAME 12875 FORWARD 8 INCHES INSIDE TUNNEL HAS CORROSION. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 206 AND 51-10-04 PAGE 9.SDR QXEA0200213Seat Track · corrodedPDX- RT INBOARD SEAT TRACK FROM FRAME 12405 INSIDE TUNNEL HAS PITTING CORROSION. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 206 AND 51-10-04 PAGE 9.SDR ASAA0280026Seat Track · corrodedPAE - DURING 30K CHECK, FOUND CORROSION ON SEAT TRACK AT FUSELAGE STATION 1212-1296, BUTTOCK LINE PLUS 22. REPLACED SEAT TRACK PER SRM 53-05. (M)SDR QXEA0200288Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 443.024 LUGS ARE GOUGED.SDR QXEA0200287Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 464.324 TOP LUGS HAVE GOUGES.SDR QXEA0200286Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 464.329 TOP LUGS HAVE GOUGES.SDR QXEA0200285Seat Track · gougedPDX - LT INBOARD SEAT TRACK AT STATION 443.021 TOP LUGS HAVE GOUGES.SDR QXEA0200284Seat Track · gougedPDX - LT INBOARD SEAT TRACK AT STATION 443.026 TOP LUGS HAVE GOUGES.SDR QXEA0200283Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 563.892 TOP LUGS HAVE GOUGES.SDR QXEA0200282Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 545.391 TOP LUGS HAVE GOUGES.SDR QXEA0200281Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 525.713 TOP LUGS HAVE GOUGES. REPAIRED IAW FOKKER MM 53-40-01, PGE 206, FIGURE 205 AND SRM 51-10-4, PAGE 9, PARAGRAPH 4B AND 4C.SDR QXEA0200280Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 517.749 TOP LUGS HAVE GOUGES.SDR QXEA0200279Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 506.028 TOP LUGS HAVE GOUGES.SDR QXEA0200278Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 506.022 TOP LUGS HAVE GOUGES.SDR QXEA0200277Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 488.740 TOP LUGS HAVE GOUGES.SDR QXEA0200276Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 582.394 THERE ARE GOUGES ON LUGS.SDR QXEA0200275Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 600.894 AFT OF FRAME 13345 TOP LUGS ARE GOUGED.SDR QXEA0200274Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 600.898 FORWARD OF FRAME 13815 GOUGES ON LUGS.SDR QXEA0200273Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 619.409 AND FRAME 13815A THE LUGS ON TOP ARE GOUGED.SDR QXEA0200268Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK FROM STATION 423.346 TO STATION 403.681 BOTH MATTING FLANGES ARE PITTED AND HAVE CORROSION.SDR QXEA0200267Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 386.016 TOP LUGS HAVE GOUGES.SDR QXEA0200266Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 403.656 TOP LUGS HAVE GOUGES.SDR QXEA0200264Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 403.668 TOP LUGS HAVE GOUGES.SDR QXEA0200263Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 403.661 TOP LUGS HAVE GOUGES.SDR QXEA0200262Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK BETWEEN STATION 386.023 AND STATION 366.338 MATTING FLANGES FOR FLOOR BOARDS ARE PITTED AND HAVE LIGHT CORROSION.SDR QXEA0200261Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 366.338 TOP LUGS ARE PITTED AND GOUGED.SDR QXEA0200260Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK FROM STATION 366.338 TO STATION 337.204 BOTH MATTING FLANGES FOR FLOOR BOARDS HAVE PITTING AND LIGHT CORROSION.SDR QXEA0200257Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 326.955 TOP LUGS HAVE GOUGES.SDR QXEA0200249Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK AT STATION 267.920 THERE IS A 3 INCH AREA IN THE CHANNEL HAS CORROSION. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 8, PARAGRAPH 4C, STEP 1 AND SRM 51-10-4, PAGE 9, PARAGRAPH 4C.SDR QXEA0200248Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK AT STATION 267.909 THERE IS A 3 INCH AREA OF CORROSION IN CHANNEL. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, PARAGRAPH 4A AND SRM 51-10-4, PAGE 9, PARAGRAPH 4C.SDR QXEA0200247Seat Track · chafedPDX - LT OUTBOARD SEAT TRACK AT STATION 248.224 LUGS ARE CHAFED TO THE POINT OF DETERIORATION. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205 AND SRM 51-10-4, PAGE 9, PARAGRAPH 4 B-C.SDR QXEA0200246Seat Track · corrodedPDX - LT OUTBOARD TRACK AT STATION 228.539 TOP EDGES AND LUGS HAVE CORROSION. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205 AND SRM 51-10-4, PAGE 9, PARAGRAPH 4C.SDR QXEA0200254Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK AT STATION 326.971 TO STATION 326.959 IN THE CHANNEL THERE IS CORROSION.SDR QXEA0200253Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 287.610 TOP LUGS HAVE GOUGES.SDR QXEA0200252Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 307.277 TOP LUGS HAVE GOUGES.
Back to JASC 5347