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 QXEA0101830Seat Track · damagedPDX - LT INBOARD SEAT TRACK HAS SLIGHT DAMAGE TO HOLE EDGE AT APPROXIMATELY STATION 370-371. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101829Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON INBOARD FLANGE AT APPROXIMATELY STATION 376-425. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101828Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING ON OUTBOARD FLANGE AT APPROXIMATELY STATION 475-478. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101827Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON OUTBOARD FLANGE AT APPROXIMATELY STATION 510-520. REPAIRED IAW FOKKER MM 53-40-01, PAGE 205, FIGURE 204 AND SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101826Seat Track · gougedPDX - LT INBOARD SEAT TRACK HAS SEVERAL GOUGES IN TOP OF RAIL THE DEEPEST APPROXIMATELY .003 INCH AT APPROXIMATELY STATION 510-512. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101825Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION IN BOTTOM OF CHANNEL AT APPROXIMATELY STATION 559-562. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101824Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON INBOARD FLANGE AT APPROXIMATELY STATION 561-563. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101823Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON OUTBOARD FLANGE AT APPROXIMATELY STATION 684-695. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101813Seat Track · corrodedPDX - RT INBOARD SEAT TRACK HAS LIGHT CORROSION ON TOP OF RAIL AT APPROXIMATELY STATION 180.5 TO 187. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101812Seat Track · corrodedPDX - RT INBOARD SEAT TRACK HAS PITTING CORROSION ON INBOARD AND OUTBOARD FLANGES AT APPROXIMATELY STATION 202-256. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 9-B2.SDR QXEA0101811Seat Track · damagedPDX - RT INBOARD SEAT TRACK HAS PITTING ON INBOARD FLANGE AT APPROXIMATELY STATION 193-200. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101810Seat Track · damagedPDX - RT INBOARD SEAT TRACK HAS PITTING ON INBOARD FLANGE AT APPROXIMATELY STATION 256-272. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101809Seat Track · damagedPDX - RT OUTBOARD SEAT TRACK HAS PITTING ON OUTBOARD FLANGE AT APPROXIMATELY STATION 387-398. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101808Seat Track · gougedPDX - RT OUTBOARD SEAT TRACK HAS A GOUGE ON THE TOP RAIL AT APPROXIMATELY STATION 337-338. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101807Seat Track · wornPDX - RT OUTBOARD SEAT TRACK HAS WEAR ON TOP OF RAIL AT APPROXIMATELY STATION 195-196. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101806Seat Track · damagedPDX - RT INBOARD SEAT TRACK HAS HOLE EDGE DAMAGE ON TOP OF RAIL AT APPROXIMATELY STATION 653. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101804Seat Track · damagedPDX - RT OUTBOARD SEAT TRACK HAS PITTING ON INBOARD FLANGE AT APPROXIMATELY STATION 388-405. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101803Seat Track · gougedPDX - RT OUTBOARD SEAT TRACK HAS A GOUGE IN INBOARD FLANGE AT APPROXIMATELY STATION 503. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101802Seat Track · gougedPDX - RT OUTBOARD SEAT TRACK HAS GOUGE ON TOP RAIL AT APPROXIMATELY STATION 434. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101801Seat Track · damagedPDX - RT OUTBOARD SEAT TRACK HAS PITTING ON OUTBOARD FLANGE AT APPROXIMATELY STATION 520-531. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101800Seat Track · wornPDX - RT OUTBOARD SEAT TRACK HAS A WORN SPOT ON TOP RAIL AT APPROXIMATELY STATION 593. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101799Seat Track · damagedPDX - RT OUTBOARD SEAT TRACK HAS A CHAFE ON OUTBOARD FLANGE AT APPROXIMATELY STATION 583. REPAIRED IAW FOKKER SRM 53-40-01, FIGURE 204.SDR QXEA0101798Seat Track · damagedPDX - RT OUTBOARD SEAT TRACK HAS PITTING ON OUTBOARD FLANGE AT APPROXIMATELY STATION 656-567. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR ZW0A0111102Cargo Track · corrodedDURING CHECK-C MAINT THE AFT CARGO BIN, LT FLOOR TRACK HAD CORROSION AROUND NUT PLATE HOLES IN SEVERAL LOCATIONS, STA 1218 TO 1221. INSTALLED NEW TRACK AND FASTENERS PER PRINT 5936663-503, AND SRM 51-30-2.SDR ZW0A0111101Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPT, STA 1221 TO 1332, THE LT FLOOR TRACK HAD CORROSION AROUND NUT PLATE HOLES IN SEVERAL LOCATIONS. INSTALLED NEW TRACK AND FASTENERS PER PRINT 5936663-503, AND SRM 51-30-2.SDR GTIA012215Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK X44 INCH FROM STATION 200-342. REMOVED SEAT TRACK FROM STATION 200-285. DRILLED AND LOCATED NEW SEAT TRACK IAW DC9 SRM 51-10-4 AND 53-05. INSTALLED NEW SEAT TRACK FROM STATION 200-285. REMOVED SEAT TRACSDR GTIA012214Seat Track · corrodedFTW - FOUND CORROSION NICKS AND GOUGES AT SEAT TRACK -X44 INCH FROM STATION 342-440. REMOVED SEAT TRACK FROM STA 342-440. DRILLED AND LOCATED SEAT TRACK STATION 342-440. INSTALLED SEAT TRACK 342-440 -X44 IAW DC9 SRM 53-05. (M)SDR GTIA012213Seat Track · corrodedFTW - FOUND CORROSION NICK AND GOUGES AT SEAT TRACK -X44 INCHES FROM STA 440-532. REMOVED SEAT TRACK FROM STATION 440-532. FABRICATED DRILLED AND LOCATED NEW SEAT TRACK. INSTALLED NEW SEAT TRACK AT STA 440-532. (M)SDR GTIA012212Seat Track · corrodedFOUND CORROSION NICK AND GOUGES AT SEAT TRACK -44 INCH FROM STA Y 532-648. REMOVED SEAT TRACK FROM STATION 532-648. FABRICATED, DRILLED AND LOCATED NEW SEAT TRACK. INSTALLED SEAT TRACK. (M)SDR GTIA012211Seat Track · corrodedFTW - FOUND CORROSION NICKS GOUGES AT SEAT TRACK -X44 INCHES FROM STATION 648-766. REMOVED SEAT TRACK. LOCATE AND DRILL FROM 648-766. INSTALLED NEW SEAT TRACK AT STATION 648-766 RIGHT SIDE IAW DC9 SRM 53-05. (M)SDR GTIA012210Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK -X44 INCHES FROM STATION 766-964. REMOVED SEAT TRACK FROM STA 766-860. FABRICATED DRILLED AND LOCATED NEW SEAT TRACK. INSTALLED SEAT TRACK FROM 766-860. REMOVED SEAT TRACK DAMAGE FROM STATION 860-964. SDR GTIA012209Seat Track · corrodedFTW - FOUND CORROSION NICKS AND GOUGES AT SEAT TRACK -22 INCHES FROM STA 342-440. REMOVED DAMAGED SEAT TRACK FROM STA 342-437. LOCATE AND DRILL SEAT TRACK. INSTALLED SEAT TRACK AND SPLICES 342-437 IAW DC9 SRM 51-30-2. (M)SDR GTIA012208Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK -X22 FROM STA Y532 TO STA 648. REMOVED SEAT TRACK FROM STATION 532-648. FABRICATED DRILLED AND LOCATED NEW SECTION FROM 532-648. INSTALLED NEW SEAT TRACK FROM 532-648. (M)SDR GTIA012207Seat Track · corrodedFTW - FOUND CORROSION NICKS AND GOUGES AT SEAT TRACK -X22 FROM STATION Y648 TO STA Y766. REMOVED SEAT TRACK FROM STA 648-766. DRILLED AND LOCATE SEAT TRACK FROM STATION 648-766 AND SPLICE. INSTALLED SEAT TRACK PER SRM DC9 51-30-1. (M)SDR GTIA012254Seat Track · corrodedFTW - FOUND CORROSION NICKS AND GOUGES AT SEAT TRACK -X22 INCH FROM STATION 200-342. REMOVED SEAT TRACK FROM STATION 285-342. FABRICATED DRILLED AND LOCATED SEAT TRACK FROM STATION 285-342. DRILLED AND LOCATE SPLICE. INSTALLED SEAT TRACK FROM STATION 285-3SDR GTIA012252Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK X44 FROM STATION 860-964. CUT OFF SEAT TRACK DAMAGE IN STATION 860-964. LOCATED AND DRILLED SEAT TRACK. INSTALLED NEW SEAT TRACK FROM STATION 860-964 IAW DC9 SRM 51-30-1. (M)SDR GTIA012251Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK X44 INCHES FROM STA 417-532. CUT OFF SECTION SEAT TRACK FROM STATION 417-532. LOCATED AND DRILLED SEAT TRACK AND SPLICE. INSTALLED SEAT TRACK AND SPLICE TWO IAW DC9 M 53-40-1. (M)SDR GTIA012250Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK X44 FROM STATION 303-417. CUT OFF THE SEAT TRACK DAMAGED STATION 303-417. LOCATED AND DRILLED SEAT TRACK. INSTALLED SEAT TRACK 303-417 IAW DC9 53-40-1. (M)SDR GTIA012249Seat Track · corrodedFTW - FOUND CORROSION NICKS AND GOUGES AT SEAT TRACK X44 FROM STATION 200-303. CUT OFF THE SEAT TRACK DAMAGED STATION 200-303. LOCATED AND DRILLED SEAT TRACK AND SPLICE. INSTALLED SPLICE TWO AND SEAT TRACK IAW DC9 MM 53-40-11 AND SRM 53-05. (M)SDR GTIA012248Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGES ANS SEAT TRACK X22 INCH FROM STATION 860-964. REMOVED DAMAGE SECTION FROM STATION 860-964. LOCATE AND DRILLED SEAT TRACK. SEAT TRACK INSTALLED FROM 860-964. (M)SDR GTIA012247Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK X22 INCH FROM STATION 765-860. REMOVED DAMAGE SECTION FROM STATION 766-860. LOCATED AND DRILLED SEAT TRACK. INSTALLED SEAT TRACK IAW SRM DC9 51-30-5. (M)SDR GTIA012245Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK X22 INCHES FROM STATION 532-649. CUT OFF SEAT TRACK DAMAGE IN STATION 532-649. LOCATED AND DRILLED SEAT TRACK AND SPLICE. INSTALLED SEAT TRACK AND SPLICE IAW DC9 SRM 51-30-1. (M)SDR GTIA012244Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK X22 INCH FROM STATION 417-532. REMOVED DAMAGE SECTION OF SEAT TRACK STATION 417-532. DRILLED NEW SEAT TRACK 417-532. INSTALLED NEW SEAT TRACK IN STATION 417-532. (M)SDR GTIA012243Seat Track · corrodedFOUND CORROSION NICKS AND GOUGES AT SEAT TRACK X22 INCH FROM STATION 200-228. REMOVED DAMAGED SECTION OF SEAT TRACK 200-228. LOCATED AND DRILLED. INSTALLED SEAT TRACK AND SPLICE SRM 53-05. (M)SDR GTIA012242Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGED AT SEAT TRACK -X22 INCH FROM STATION 766-964. REMOVED SEAT TRACK FROM STATION 860-965. FABRICATED DRILLED AND LOCATED NEW SEAT TRACK FROM 860-965. FABRICATED DRILLED AND LOCATED SPLICE. INSTALLED SEAT TRACK SPLICE. SDR GTIA012241Seat Track · gougedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK -X22 INCH FROM STATION 440-532. REMOVED SEAT TRACK FROM STATION 440-532. FABRICATED DRILLED AND LOCATED NEW SEAT TRACK AND SPLICE. INSTALLED SEAT TRACK FROM STATION 440-532 PER DC9 SRM 51-30-1. (M)SDR GTIA012107Seat Track · gougedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK X44 FROM STATION 649 TO STATION 765. INSTALLED SECTION OF SEAT TRACK FROM STA Y 649 TO Y 765 X 44 IAW SRM DC9 53-05. (M)SDR GTIA012108Seat Track · gougedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK BY 44 INCHES FROM STATION Y 532 TO STA 649. INSTALLED SECTION OF SEAT TRACK FROM STA 532 TO STA 649. (M)SDR QXEA0101805Paint · missingPDX - RT INBOARD SEAT TRACK HAS PAINT MISSING IN BOTTOM CHANNEL AT APPROXIMATELY STATION 623-638. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR ZW0A0110804Seat Track · corrodedDURING CHECK-C MAINT, THE NUMBER 1 (LT OUTBOARD) FLOOR TRACK WAS CORRODED BEYOND LIMITS AT STA 797 TO 1003. REPLACED FLOOR TRACK PER SRM 51-30-1 AND SPM 6-70-01.
Back to JASC 5347