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 QXEA0100847Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORRODED IN CHANNEL AND ON LUGS AT STATION 597. REPAIRED IAW RD8-53-784.SDR QXEA0100846Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORRODED AFT OF SEAT RAILS AND ON OUTBOARD RAIL AT STATION 547. REPAIRED IAW RD 8-53-1339.SDR QXEA0100845Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORRODED ON INBOARD SIDE OF CHANNEL, IN CHANNEL AND ON LEFT AND RIGHT LUGS AT NR 8. REPAIRED IAW RD 8-53-1339.SDR QXEA0100844Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORRODED IN CHANNEL AT STATION 486. REPAIRED IAW RD8-53-1339.SDR QXEA0100843Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CHAFED IN CHANNEL AT STATION 456. REPAIRED IAW RD8-53-1339.SDR QXEA0100842Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORRODED ON LEFT AND RIGHT RAIL AT STATION 436. REPAIRED IAW RD8-53-1339.SDR QXEA0100841Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORRODED IN CHANNEL AT STATION 430. REPAIRED IAW RD8-53-1339.SDR QXEA0100840Seat Track · gougedPDX - RIGHT INBOARD SEAT TRACK GOUGED .002 INCH ON OUTBOARD LUG AT STATION 418. REPAIRED IAW RD8-53-1339.SDR QXEA0100839Seat Track · chafedPDX - RIGHT INBOARD SEAT TRACK CHAFED ON INBOARD LUG AT STATION 405. REPAIRED IAW RD8-53-1339.SDR QXEA0100838Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORRODED ON LEFT AND RIGHT LUGS AT STATION 390. REPAIRED IAW RD8-53-1339.SDR QXEA0100837Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORRODED IN CHANNEL AT STATION 387. REPAIRED IAW RD8-53-1339.SDR QXEA0100836Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORRODED IN CHANNEL AT STATION 360. REPAIRED IAW RD8-53-1339.SDR QXEA0100834Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORRODED ON OUTBOARD LUG AT STATION 324. REPAIRED IAW RD8-53-1339.SDR QXEA0100833Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORRODED IN CHANNEL AT STATION 322. REPAIRED IAW RD8-53-1339.SDR QXEA0100832Seat Track · gougedPDX - RIGHT INBOARD SEAT TRACK GOUGED ON LUGS AT STATION 295. REPAIRED IAW RD8-53-1339.SDR QXEA0100831Seat Track · chafedPDX - RIGHT INBOARD SEAT TRACK CHAFED IN CHANNEL 8 INCHES TO 11 INCHES LONG AT STATION 291. REPAIRED IAW RD8-53-1339.SDR UPS01435928Seat Track · corrodedINSPECTION TYPE:C-2 U/D - BS 480-520 RBL 65 SEAT TRACK FOUND HEAVY CORROSION DURING FLOOR COVERING REMOVED. TIE DOWN TRACK REPLACED AS PER SRM 51-10-01.SDR AALA20011038Seat Track · corrodedTUL - FOUND CORROSION NR 2 SEAT TRACK STATION 1300, 1251, AND 1287. INSTALLED NEW SECTION OF NR 2 SEAT TRACK FROM STATION 1240 TO 1309 PER SRM 53-05 FIG NR 4F. (M)SDR QXEA0100829Seat Track · gougedPDX - LEFT INBOARD SEAT TRACK GOUGED AT STATION 520. REPAIRED IAW RD8-53-1339.SDR QXEA0100827Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORRODED AROUND BOLT HOLE AT STATION 202. REPAIRED IAW RD8-53-1139.SDR QXEA0100826Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK GOUGED IN CHANNEL IN AFT 4 INCHES OF TRACK AT STATION 545. REPAIRED IAW RD8-53-1342.SDR QXEA0100825Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK CORRODED ON INBOARD AND OUTBOARD RAILS AT STATION 545. REPAIRED IAW RD 8-53-3611.SDR QXEA0100824Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK CORRODED IN OUTBOARD SIDE OF CHANNEL AT STATION 531. REPAIRED IAW RD 8-53-3644.SDR QXEA0100823Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK CORRODED ON INBOARD AND OUTBOARD LUGS AT STATION 466. REPAIRED IAW RD 8-53-1342.SDR QXEA0100822Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK CORRODED ON INBOARD RAIL AT STATION 468 TO 471. REPAIRED IAW RD 8-53-1342.SDR QXEA0100821Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK CORRODED IN CHANNEL AT STATION 471. REPAIRED IAW RD 8-53-1342.SDR QXEA0100820Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK CORRODED ON INBOARD SIDE OF CHANNEL AT STATION 436. REPAIRED IAW RD 8-53-1342.SDR QXEA0100819Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK CORRODED IN CHANNEL AT STATION 395-395. REPAIRED IAW RD 8-53-1342.SDR QXEA0100818Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK CORRODED ON INBOARD SIDE OF CHANNEL UNDER LUGS AT STATION 375. REPAIRED IAW RD 8-53-1342.SDR QXEA0100817Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK CORRODED ON OUTBOARD RAIL IN LUG AREA AT STATION 363. REPAIRED IAW RD 8-53-1342.SDR QXEA0100816Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK CORRODED ON INBOARD SIDE OF CHANNEL AT STATION 298-312. REPAIRED IAW RD 8-53-1342.SDR QXEA0100815Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK GOUGED .003 INCH ON INBOARD RAIL AT STATION 270. REPAIRED IAW RD 8-53-1342.SDR QXEA0100814Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK CORRODED AT INSIDE CENTER AT STATION 538. REPAIRED IAW RD 8-53-3644.SDR QXEA0100813Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK CORRODED IN INSIDE CENTER AT STATION 516 TO 517. REPAIRED IAW RD 8-53-3644.SDR QXEA0100812Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK CORRODED ON TOP INBOARD AND OUTBOARD AT STATION 485 TO 487. REPAIRED IAW RD 8-53-1342.SDR QXEA0100811Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK CORRODED ON INBOARD TOP AT STATION 470. REPAIRED IAW RD 8-53-1342.SDR QXEA0100810Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK CORRODED INSIDE CENTER AND UNDER INSIDE TOP AT STATION 467-471. REPAIRED IAW RD 8-53-1342.SDR QXEA0100809Seat Track · gougedPDX - RIGHT OUTBOARD SEAT TRACK IS GOUGED APPROXIMATELY .005 AT TOP INBOARD AND OUTBOARD AT STATION 454. REPAIRED IAW RD 8-53-1342.SDR QXEA0100808Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK IS CORRODED AT INSIDE AND TOP INBOARD AND OUTBOARD AT STATION 436 TO 439. REPAIRED IAW RD 8-53-1342.SDR QXEA0100807Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION ON INSIDE CENTER AND TOP INBOARD ALSO GOUGED APPROXIMATELY .005 INCH AT TOP OUTBOARD AT STATION 421 TO 423. REPAIRED IAW RD 8-53-1342.SDR QXEA0100806Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION ON INSIDE CENTER AT STATION 390. REPAIRED IAW RD 8-53-1342.SDR QXEA0100805Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION ON BOTH SIDES OF INSIDE AND ON INBOARD TOP OF TRACK AT STATION 310. REPAIRED IAW RD 8-53-1342.SDR QXEA0100804Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION ON INSIDE OF TRACK ON INSIDE EDGE AT STATION 291. REPAIRED IAW RD 8-53-1342.SDR QXEA0100803Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION ON OUTBOARD TOP FROM STATION 270 TO 274. REPAIRED IAW RD 8-53-1342.SDR QXEA0100802Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION ON INBOARD AND OUTBOARD TOP AND INSIDE CENTER OF FORWARD SIX INCHES OF TRACK FROM STATION 262-268. REPAIRED IAW RD 8-53-1342.SDR F3LA200100072Cargo Track · corrodedDURING C-6 CHECK, INSPECTION REPORTED CARGO FLOOR TRACK CORRODED AT BS 800 TO 840 ABOVE STR 26R IN AFT CARGO BAY. FABRICATED FLOOR TRACK AND SPLICE PLATES AND INSTALLED PER SRM 53-00-53, 51-10-02, SEC 53, AND SOPM 20-41-02.SDR DHL2001366503Seat Track · damagedC-CHECK - NR 2 RT SEAT TRACK DAMAGED AT FR 29. DAMAGED AREA REMOVED AND FOUND TO BE OUT OF SRM 53-10-00 LIMITS. REPLACED SEAT TRACK WITH NEW.SDR AALA20011061Track · corrodedTUL - FOUND LAVATORY TIE DOWN AT STATION 253 LBL 19 CORRODED. REMOVED AND REPLACED TIE DOWN SECTION WITH NEW SRM 51-01. (M)SDR AALA20011060Track · corrodedTUL - FOUND LAV TIE DOWN AT STATION 255 LBL 32 CORRODED. REMOVED AND REPLACED TIE DOWN TRACK WITH NEW SRM 51-01. (M)SDR AALA20011062Cargo Track · corrodedTUL - FOUND LEFT TIE DOWN TRACK CORRODED FS 1117, 1174-1206. REMOVED AND REPLACED SECTION OF LEFT TIE DOWN TRACK FROM STATION 1007-1221. (M)
Back to JASC 5347