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 QXEA200500325Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 11 SEAT TRACK HAS A LARGE SPOT OF CORROSION ON BOTTOM OF GROOVE AT X462 AND CORROSION ON LUGS FROM X466 TO X469. REPAIRED IAW DHC-8 200 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500323Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 11 SEAT TRACK HAS DAMAGED LUGS AND CORRODED LUGS AT X486 TO X484 AND CORROSION ON BOTTOM OF LUGS AT X486. REPAIRED IAW RD 8-53-1343, DHC-8 200 SRM 51-40-00 AND 51-40-11.SDR QXEA200500328Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 11 SEAT TRACK HAS LITE CORROSION ON TOP OF OUTBOARD LUG AT X430. REPAIRED IAW DHC-8 200 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500327Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 11 SEAT TRACK HAS CORROSION ON TOP OF LUGS AT X434 TO X438 AND ON BOTTOM OF LUGS AT X436. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500326Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 11 SEAT TRACK HAS CORROSION ON BOTTOM OF LUG AT X455. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500324Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 11 SEAT TRACK HAS CORRODED LUGS AT X498. REPAIRED IAW DHC-8 200 SRM 51-40-00 AND 51-40-11.SDR QXEA200500344Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 10 SEAT TRACK HAS SURFACE CORROSION ON TOP OF LUGS AT X361 AND FROM X373 TO X375, PITTING IN BOTTOM OF CHANNEL AT X372 TO X375. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500343Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 10 SEAT TRACK HAS LITE SURFACE CORROISON ON TOP OF LUGS AT X326 AND PITTING IN BOTTOM OF CHANNEL AT X340 TO X342. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500342Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 10 SEAT TRACK HAS PITTING IN BOTTOM OF CHANNEL AND BELOW LUGS FROM X308 TO X312 AND ON TOP OF LUGS FROM X308 TO X312. REPAIRED IAW DHC-8 292 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500341Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 10 SEAT TRACK HAS SURFACE CORROSION ON TOP OF AND ON FACE OF LUGS, AND PITTING IN BOTTOM OF CHANNEL AT X296 TO X298. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500340Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 10 SEAT TRACK HAS PITTING IN BOTTOM OF CHANNEL AND SURFACE CORROSION ON TOP OF LUGS AT X278 TO X281. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500338Seat Track · corrodedPDX - SEAT TRACK NR 1 HAS PITTING CORROSION AT STATION X279. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500336Seat Track · corrodedPDX - SEAT TRACK NR 1 HAS PITTING CORROSION AT STATION X313. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500337Seat Track · corrodedPDX - SEAT TRACK NR 1 HAS PITTING CORROSION AT STATION X281. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500335Seat Track · corrodedPDX - SEAT TRACK NR 1 HAS PITTING CORROSION AT STATION X328. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500331Seat Track · scratchedPDX - SEAT TRACK NR 1 HAS SCRATCH FROM X395 TO X408. REPAIRED IAW DHC-8 200 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500334Seat Track · corrodedPDX - SEAT TRACK NR 1 HAS PITTING CORROSION AT X342. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500333Seat Track · corrodedPDX - SEAT TRACK NR 1 HAS PITTING CORROSION AT X352. REPAIRED IAW DHC-8 202 SRM 51-0-00 AND SRM 51-40-11.SDR QXEA200500332Seat Track · corrodedPDX - SEAT TRACK NR 1 HAS PITTING CORROSION AT X364. REPAIRED IAW DHC-8 200 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500330Seat Track · corrodedPDX - SEAT TRACK NR 1 HAS PITTING CORROSION AT X395. REPAIRED IAW DHC-8 200 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500329Seat Track · corrodedPDX - SEAT TRACK NR 11 HAS PITTING CORROSION AT X408. REPAIRED IAW DHC-8 200 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500346Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 10 SEAT TRACK HAS CORROSION IN BOTTOM OF CHANNEL AT X404 AND ON TOP AT X422. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200500345Seat Track · corrodedPDX - RIGHTHAND OUTBOARD NR 10 SEAT TRACK HAS SURFACE CORROSION ON TOP OF LUGS AT X389 AND PITTING IN BOTTOM OF CHANNEL AT X390 TO X392. REPAIRED IAW DHC-8 202 SRM 51-40-00 AND SRM 51-40-11.SDR MALA050163Seat Track · corrodedDURING 4Y/2Y CHECK FOUND SEAT TRACK AT LBL 18.3 IS CORRODED, FROM FS 297 TO FS 310. DAMAGE IS BEING REPAIRED IAW SRM 53-70-60.SDR MALA050162Seat Track · corrodedDURING 4Y/2Y CHECK FOUND SEAT TRACK AT BL 0, FROM FS 297 TO FS 310 IS CORRODED AND IS BEING REPAIRED IAW SRM 53-70-60.SDR MALA050161Seat Track · corrodedDURING 4Y/2Y CHECK FOUND SEAT TRACK AT BL 0, FROM FS 621 TO FS 686 IS CORRODED OUT OF LIMITS IN 2 AREAS AND WILL BE REPAIRED IAW MESABA EOS53078.SDR MALA050159Seat Track · corrodedDURING 4Y/2Y CHECK FOUND GALLEY SEAT TRACK, P/N 7253721-459 AND PROFILE, P/N 7253721-495 ARE CORRODED. ITEMS ARE BEING REPLACED IAW SRM 51-40-21 AND 51-40-22.SDR QXEA200500279Seat Track · corrodedYYC - RIGHTHAND INBOARD SEAT RAIL AT STATION X447 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW HORIZON AIR EA R-53-273 AND REO 670-53-21-072 REV N/C.SDR QXEA200500278Seat Track · corrodedYYC - RIGHTHAND INBOARD SEAT RAIL AT STATION X432 TO X437 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW HORIZON AIR EA R-53-273, REO 670-53-21-072 AND CRJ700 SRM 51-41-02-001-001-A01.SDR QXEA200500277Seat Track · corrodedYYC - RIGHTHAND INBOARD SEAT RAIL AT STATION X372 TO X399 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-41-02-001-001-A01, HORIZON AIR EA R-53-273, SECTION I AND REO 670-53-21-072.SDR QXEA200500276Seat Track · corrodedYYC - RIGHTHAND INBOARD SEAT RAIL AT STATION X356 TO X349 HAS PITTING CORROSION ON TOP, INSIDE AND OUTER SURFACES. REPAIRED IAW CRJ700 SRM 51-41-02-001-001-A01, HORIZON AIR EA R-53-273, SECTION 1 AND REO 670-53-21-072.SDR QXEA200500280Seat Track · corrodedYYC - RIGHTHAND INBOARD SEAT RAIL AT STATION X479 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW HORIZON AIR EA R-53-273, SECTION I AND REO 670-53-072, REV N/C.SDR 0500295521Seat Track · corrodedDURING "M" CHECK, FOUND CORROSION ON SEAT TRACK AT BS 1640 LBL 24. REPAIRED PER EA 55-202017.SDR UPS05443944Seat Track · corrodedINSPECTION TYPE: C - BS 2060 - 2140 RBL 98 SEAT TRACK CORROSION FOUND. CORROSION BLEND OUT 0.042 X 1 X 3 EXCEED SRM 53-10-01 FIG 1, LIMIT. SEAT TRACK REPLACED AS PER SRM 51-10-01 PG 9.SDR UPS05443943Seat Track · corrodedINSPECTION TYPE: C, BS 2060 LBL 70 INCH SEAT TRACK CORROSION FOUND. CORROSION BLEND OUT 0.045 X 1 X 2 EXCEED SRM 53-10-01 FIG 1, LIMIT. SEAT TRACK REPLACED AS PER SRM 51-10-01 PG 9.SDR UPS05443942Cargo Track · crackedINSPECTION TYPE: C, BS 2060 - 2140, RBL 90, TIE DOWN TRACK FLANGE FOUND CORROSION CRACK (CRACK LENGTH 1 INCH). TIE DOWN TRACK REPLACED AS PER SRM 51-10-01 PG 9.SDR MALA050151Seat Track · corrodedDURING 4Y/2Y CHECK FOUND SEAT TRACK AT BL 0 FROM FS 297 TO FS 310 IS CORRODED AND HAS BEEN REPAIRED IAW SRM 53-70-60.SDR 05FDEA00286Seat Track · crackedMAIN DECK CARGO SEAT TRACK FOUND CRACKED AT STA 905 LT 28 INCHES. CARRIED OUT REPAIR AS PER SRM 53-70-00 FIG 1 VOL I.SDR QXEA200500275Seat Track · corrodedYYC - LEFTHAND OUTBOARD SEAT RAIL AT STATION X490 TO X505 HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01, 51-21-11-001-001-A01, HORIZON AIR EA R-53-272 AND REO 670-53-31-025.SDR WRLA2005063Seat Track · corrodedDURING "C04" CHECK INSPECTION, FOUND CORROSION IN MAIN DECK CARGO SEAT TRACK AT STA 877, X=27.5.SDR WRLA2005061Seat Track · corrodedDURING "C04" CHECK INSPECTION, FOUND CORROSION IN MAIN DECK CARGO SEAT TRACK AT STA 880, X=8.5.SDR WRLA2005062Seat Track · corrodedDURING "C04" CHECK INSPECTION, FOUND CORROSION IN MAIN DECK CARGO SEAT TRACK AT STA 838, X=75.SDR WRLA2005060Seat Track · corrodedDURING "C04" CHECK INSPECTION, FOUND CORROSION IN MAIN DECK SEAT TRACK AT STA 445, X=-87.SDR WRLA2005059Seat Track · corrodedDURING "C04" CHECK INSPECTION, FOUND CORROSION IN MAIN DECK SEAT TRACK AT STA 847, X=44.SDR UPS05443977Cargo Track · corrodedINSPECTION TYPE:C M/D- BS 480-500 LBL 68 TIE DOWN TRACK O/B FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.039 X 1 X 2 EXCEED SRM 53-10-01 FIG 1, LIMIT TIE DOWN TRACK REPLACED AS PER SRM 51-10-01 PG 9.SDR UPS05443976Cargo Track · corrodedINSPECTION TYPE: C, BS 480-510 LBL 66 TIE DOWN TRACK I/B FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.041 X 1 X 3 EXCEED SRM 53-10-01 FIG 1, LIMIT TIE DOWN TRACK REPLACED AS PER SRM 51-10-01 PG 9.SDR UPS05443960Cargo Track · corrodedINSPECTION TYPE: C, BS 480 - 500 LBL 84 TIE DOWN TRACK I/B FLANGE & LIP FOUND CORRODED. CORROSION BLEND OUT 0.047 X 1 X 2 INCH EXCEED SRM 53-10-01 FIG 1, LIMIT. TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS05443950Cargo Track · corrodedINSPECTION TYPE: C, BS 440 - 460 LBL 86 TIE DOWN TRACK I/B FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.044 X 1 X 3 INCH EXCEED SRM 53-10-01 FIG 1, LIMIT. TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS05443940Cargo Track · corrodedINSPECTION TYPE: C, BS 160 - 180 RBL 13 TIE DOWN TRACK I/B FLANGE & LIP FOUND CORRODED. CORROSION BLEND OUT 0.040 X .5 X 3 INCH EXCEED SRM 53-10-01 FIG 1, LIMIT. TIE DOWN TRACK REPLACED AS PER SRM 51-10-01 PG 1.SDR UPS05443939Seat Track · corrodedINSPECTION TYPE: C, BS 190 - 240 RBL 11 - 33 SEAT TRACK FLANGE CORROSION FOUND. CORROSION BLEND OUT 0.046 X 1 X 5 INCH EXCEED SRM 53-10-01 FIG 1, LIMIT. SEAT TRACK REPLACED AS PER SRM 51-10-01 PG 9.
Back to JASC 5347