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 QXEA0201560Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 1 TOP CORROSION IN SEAT ATTACH AREA AT X266.00. REPLACED NR 1 SEAT TRACK.SDR QXEA0201557Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 10 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X266.00 TO FORWARD END. REPLACED NR 10 SEAT TRACK.SDR QXEA0201555Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 6 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X541.00. REPLACED NR 6 SEAT TRACK.SDR QXEA0201554Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 6 CORROSION AROUND OUTBOARD NUT PLATE AT X591.00. REPLACED NR 6 SEAT TRACK.SDR QXEA0201553Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 6 CORROSION AROUND INBOARD NUT PLATE AT X580.00. REPLACED NR 6 SEAT TRACK.SDR QXEA0201552Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 6 CORROSION AROUND INBOARD NUT PLATE AT X580.00. REPLACED NR 6 SEAT TRACK.SDR QXEA0201551Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 1 TOP CORROSION IN SEAT ATTACH AREA AT 424.00. REPLACED NR 1 SEAT TRACK.SDR QXEA0201550Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 1 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X407.00. REPLACED NR 1 SEAT TRACK.SDR QXEA0201549Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 1 TOP CORROSION IN SEAT ATTACH AREA AT X393.00. REPLACED NR 1 SEAT TRACK.SDR QXEA0201548Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 6 CORROSION AROUND INBOARD NUT PLATE AT X548.00. REPLACED NR 6 SEAT TRACK.SDR QXEA0201547Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 6 CORROSION AROUND INBOARD NUT PLATE AT X565.00. REPLACED NR 6 SEAT TRACK.SDR QXEA0201546Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 10 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X280.00. REPLACED SEAT TRACK.SDR QXEA0201545Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 10 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X298.00. REPLACED NR 10 SEAT TRACK.SDR QXEA0201544Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 10 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X312.00. REPLACED NR 10 SEAT TRACK.SDR QXEA0201543Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 10 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X328.00. REPLACED NR 10 SEAT TRACK.SDR QXEA0201542Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 10 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X343.00. REPLACED NR 10 SEAT TRACK.SDR QXEA0201541Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 10 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X363.00. REPLACED NR 10 SEAT TRACK.SDR QXEA0201540Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 10 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X377.00. REPLACED NR 10 SEAT TRACK.SDR QXEA0201539Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 10 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X393.00. REPLACED NR 10 SEAT TRACK.SDR QXEA0201538Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 10 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X407.00. REPLACED NR 10 SEAT TRACK.SDR QXEA0201537Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 10 TOP CORROSION IN SEAT ATTACH AREA AT X424.00. REPLACED NR 10 SEAT TRACK.SDR QXEA0201536Seat Track · corrodedPDX - RIGHT HAND INBOARD SEAT TRACK NR 9 INBOARD FLANGE CORROSION AT X530.00. REPLACED NR 9 SEAT TRACK.SDR QXEA0201535Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 5 FORWARD OUTBOARD FLANGE CORROSION AROUND EIGHT RIVETS AT X426. REPLACED NR 5 SEAT TRACK.SDR QXEA0201567Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 1 AT TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X377.00. REPLACED NR 1 SEAT TRACK.SDR QXEA0201566Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 1 TOP CORROSION IN SEAT ATTACH AREA FROM X363.00 TO X377.00. REPLACED NR 1 SEAT TRACK.SDR QXEA0201565Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 1 TOP CORROSION IN SEAT ATTACH AREA AT X343.00. REPLACED NR 1 SEAT TRACK.SDR QXEA0201564Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 1 TOP CORROSION IN SEAT ATTACH AREA AT X328.00. REPLACED NR 1 SEAT TRACK.SDR QXEA0201563Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 1 TOP CORROSION IN SEAT ATTACH AREA AT X312.00. REPLACED NR 1 SEAT TRACK.SDR QXEA0201534Seat Track · chafedPDX - LEFT HAND INBOARD SEAT TRACK NR 5 APPROXIMATELY 12 INCHES OF BOTTOM CHAFED BY FLOOR TRIM AT X445.00. REPLACED NR 5 SEAT TRACK.SDR QXEA0201533Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 5 BOTTOM CORROSION AT SEAT ATTACH AREA APPROXIMATELY X469.00. REPLACED NR 5 SEAT TRACK.SDR QXEA0201532Seat Track · chafedPDX - LEFT HAND INBOARD SEAT TRACK NR 5 BOTTOM CHAFED APPROXIMATELY 12 INCHES BY FLOOR TRIM AT X475.00. REPLACED NR 5 SEAT TRACK.SDR QXEA0201531Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 5 TOP CORROSION APPROXIMATELY 12 INCHES AT X488.00. REPLACED NR 5 SEAT TRACK.SDR QXEA0201530Seat Track · chafedPDX - LEFT HAND INBOARD SEAT TRACK NR 5 BOTTOM CHAFED APPROXIMATELY 12 INCHES BY FLOOR TRIM AT X510.00. REPLACED NR 5 SEAT TRACK.SDR QXEA0201529Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 5 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X518.00. REPLACED NR 5 SEAT TRACK.SDR QXEA0201528Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 OUTBOARD FLANGE CORROSION AT X198.00. REPLACED NR 4 SEAT TRACK.SDR QXEA0201527Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 OUTBOARD FLANGE CORROSION AROUND RIVETS FROM X201.00 TO X222.00. REPLACED NR 4 SEAT TRACK.SDR QXEA0201526Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 BRACKET ON OUTBOARD FLANGE CORRODED FROM X201.00 TO X222.00. REPLACED NR 4 SEAT TRACK.SDR QXEA0201525Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 OUTBOARD FLANGE CORROSION AROUND FASTENER RECEPTACLE AT APPROXIMATELY X228.00. REPLACED NR 4 SEAT TRACK.SDR QXEA0201524Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 OUTBOARD FLANGE CORROSION AROUND FASTENER RECEPTACLE AT APPROXIMATELY X240.00. REPLACED NR 4 SEAT TRACK.SDR QXEA0201523Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 OUTBOARD FLANGE CORROSION AROUND TWO FASTENER RECEPTACLES AT APPROXIMATELY X252.00. REPLACED NR 4 SEAT TRACK.SDR QXEA0201522Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 OUTBOARD FLANGE CORROSION AROUND FASTENER RECEPTACLE AT APPROXIMATELY X270.00. REPLACED NR 4 SEAT TRACK.SDR QXEA0201521Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 OUTBOARD FLANGE CORROSION AROUND FASTENER RECEPTACLE, APPROXIMATELY X285.00. REPLACED NR 4 SEAT TRACK.SDR QXEA0201520Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 OUTBOARD FLANGE CORROSION AROUND FASTENER RECEPTACLE, APPROXIMATELY X297.00. REPLACED NR 4 SEAT TRACK.SDR QXEA0201519Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 OUTBOARD FLANGE CORROSION AROUND TWO FASTENER RECEPTACLES AT X312. REPLACED NR 4 SEAT TRACK.SDR QXEA0201518Seat Track · damagedPDX - RIGHT HAND INBOARD SEAT TRACK NR 7 DRIP FACE RECEPTACLE HOLE DAMAGED PIECES BROKEN OUT AT X312.00. REPLACED NR 7 SEAT TRACK.SDR QXEA0201517Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA APPROXIMATELY X267.00. REPLACED NR 4 SEAT TRACK.SDR QXEA0201516Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 CORROSION IN TOP AND BOTTOM AT SEAT ATTACH AREA APPROXIMATELY X280.00. REPLACED NR 4 SEAT TRACK.SDR QXEA0201515Seat Track · chafedPDX- LEFT HAND INBOARD SEAT TRACK NR 4 BOTTOM CHAFED APPROXIMATELY 12 INCHES BY TRACK COVER AT X291.00. REPLACED SEAT TRACK.SDR QXEA0201514Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 CORROSION ON TOP IN AREA OF SEAT ATTACH AT APPROXIMATELY X298.00. REPLACED NR 4 SEAT TRACK.SDR QXEA0201513Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 CORROSION TOP AND BOTTOM OF SEAT ATTACH AREA AT APPROXIMATELY X312.00. REPLACED NR 4 SEAT TRACK.
Back to JASC 5347