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 QXEA0300181Seat Track · scratchedPDX - NR 5 SEAT TRACK HAS SCRATCHES AT STATION 500-515. REPAIRED IAW RD 8-53-1339, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300180Seat Track · scratchedPDX - NR 6 SEAT TRACK HAS SCRATCHES AT STATION 597. REPAIRED IAW RD 8-53-4936, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300179Seat Track · scratchedPDX - NR 6 SEAT TRACK HAS SCRATCHES AT STATION 540-545. REPAIRED IAW RD 8-53-4936, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300178Seat Track · scratchedPDX - NR 6 SEAT TRACK HAS SCRATCHES AT STATION 531. REPAIRED IAW RD 8-53-4936, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300177Seat Track · corrodedPDX - NR 2 SEAT TRACK HAS LIGHT PITTING AT STATION 438. REPAIRED IAW RD 8-53-1352, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300176Seat Track · corrodedPDX - NR 2 SEAT TRACK HAS PITTING CORROSION AT STATION 455. REPAIRED IAW RD 8-53-1342, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300175Seat Track · corrodedPDX - NR 1 SEAT TRACK HAS LIGHT PITTING AT STATION 360. REPAIRED IAW RD 8-53-1342, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300174Seat Track · scratchedPDX - NR 1 SEAT TRACK HAS SCRATCHES AT STATION 370-375. REPAIRED IAW RD 8-53-1342, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300173Seat Track · corrodedPDX - NR 2 SEAT TRACK HAS LIGHT PITTING AT STATION 468. REPAIRED IAW RD 8-53-1342, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300172Seat Track · corrodedPDX - NR 2 SEAT TRACK HAS LIGHT PITTING AT STATION 488. REPAIRED IAW RD 8-53-1342, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300171Seat Track · corrodedPDX - NR 3 SEAT TRACK HAS LIGHT PITTING AT STATION 514. REPAIRED IAW RD 8-53-3644, DHC-8-200 SRM 51-40-11 AND SRM 51-40-00.SDR QXEA0300170Seat Track · scratchedPDX - NR 4 SEAT TRACK HAS SCRATCHES AT STATION 410-420. REPAIRED IAW RD 8-53-1339, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300169Seat Track · scratchedPDX - NR 4 SEAT TRACK HAS SCRATCHES AT STATION 380-390. REPAIRED IAW RD 8-53-1339, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300168Seat Track · scratchedPDX - NR 4 SEAT TRACK HAS SCRATCHES AT STATION 370. REPAIRED IAW RD 8-53-1339, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300167Seat Track · scratchedPDX - NR 4 SEAT TRACK HAS SCRATCHES AT STATION 344-360. REPAIRED IAW RD 8-53-1339, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300166Seat Track · chafedPDX - NR 4 SEAT TRACK HAS CHAFING AT STATION 338. REPAIRED IAW RD 8-26-1339, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300165Seat Track · scratchedPDX - NR 4 SEAT TRACK HAS SCRATCHES AT STATION 310-325. REPAIRED IAW RD 8-53-1339, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300164Seat Track · scratchedPDX - NR 4 SEAT TRACK HAS SCRATCHES AT STATION 285-295. REPAIRED IAW RD 8-53-1339, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300163Seat Track · corrodedPDX - LIGHT PITTING AT STATION 265 IN NR 4 SEAT TRACK. REPAIRED IAW RD 8-53-1339 AND DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300162Seat Track · corrodedPDX- NR 1 SEAT TRACK HAS LIGHT PITTING AT STATION 295-298. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-16, 51-20-36 AND RD 8-53-1342.SDR QXEA0300161Seat Track · corrodedPDX- NR 1 SEAT TRACK HAS LIGHT PITTING CORROSION AT STATION 310. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-16, 51-20-36 AND 8-53-1342.SDR QXEA0300160Seat Track · scratchedPDX- NR 1 SEAT TRACK HAS SCRATCHES AT STATION 330. REPAIRED IAW DHC-8 SRM 51-20-16, 51-20-36, 51-00-06 AND RD 8-53-1342.SDR QXEA0300159Seat Track · corrodedPDX- NR 1 SEAT TRACK HAS LIGHT PITTING AT STATION 340-345. REPAIRED IAW DHC-8 SRM 51-20-16, 51-00-06, 51-20-36 AND RD 8-53-1342.SDR QXEA0300158Seat Track · corrodedPDX- NR 1 SEAT TRACK HAS PITTING CORROSION AT STATION 390. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-16, 51-20-36 AND RD 8-53-1342.SDR QXEA0300157Seat Track · corrodedPDX- NR 1 SEAT TRACK HAS PITTING CORROSION AT STATION 405-408. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-16, 50-20-36 AND RD 8-53-1342.SDR QXEA0300156Seat Track · corrodedPDX- NR 1 SEAT TRACK HAS PITTING CORROSION AT STATION 424. REPAIRED IAW DHC-8 SRM 51-20-16, 51-00-06 AND 51-20-36.SDR MALA030144Seat Track · corrodedDURING C-CHECK IN CVG, NR 4 SEAT TRACK HAS CORROSION BETWEEN FRAME 18-20. MAINTENANCE REPAIRED DAMAGE IAW EO A53026. A/C RELEASE DATE 1/30/03.SDR IXXA060495SSeat Track · gougedDURING ROUTINE C-CHECK, FOUND SEAT TRACK "B" GOUGED AT STATION FS 400. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, LOCATED, DRILLED TRIMMED, TREATED, PRIMED, AND INSTALLED REPAIR PARTS IAW DC8 SRM 53-2-3, AND 51-1-8.SDR IXXA060502SSeat Track · wornDURING ROUTINE C CHECK, FOUND SEAT TRACK WORN AND GOUGED AT STATION 240 BL-0. REMOVED DAMAGE. FABRICATED REPAIR PARTS, LOCATED, DRILLED, TREATED, PRIMED, AND INSTALLED REPAIR PARTS, IAW,DC8 SRM 53-2-3, AND 51-1-8.SDR IXXA060501SSeat Track · gougedDURING ROUTINE C CHECK, FOUND SEAT TRACK GOUGED AT STATION 250 BL-0. REMOVED DAMAGE. FABRICATED REPAIR PARTS, LOCATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED REPAIR PARTS, IAW DC8 SRM 53-2-3, AND 53-2-3.SDR 2003F00456Seat Track · crackedAT C-CHECK, FOUND CRACKED SEAT TRACK AT STATION 948C, LBL 25. REPLACED SEAT TRACK AT STATION 950B TO 950D. (M)SDR ASAA0380102Cargo Track · corrodedOAK - FOUND DURING C-CHECK, TIEDOWN TRACK FLOR MOUNT HOLES ARE CORRODED IN AFT CARGO BAY. REPLACED TIEDOWN TRACK PER SRM 51-30-2 AND 51-10-4. (M)SDR IXXA060503SSeat Track · gougedDURING ROUTINE C CHECK FOUND A SEAT TRACK GOUGED AT STATION 275 RBL 45.5. REMOVED DAMAGE. FABRICATED REPAIR PARTS, LOCATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED REPAIR PARTS.IAW DC8 SRM 53-2-3, 51-1-8, AND 53-2-3.SDR DHL2003804770Cargo Track · wornMAIN CARGO TRACK WORN IN VARIOUS LOCATIONS . CUT OUT DAMAGED TRACKS IAW SRM 53-2-3 PG 17 , CLEANED , TREATED AND PRIMED AREA IAW SRM 51-1-8B INSTALLED NEW PLUGS AND CHANNEL OR INSTALLED NEW TRACK SECTION IAW SRM 53-2-3 PG. 49-50SDR QXEA0300151Seat Track · gougedPDX- REMOVE AND REPLACE NR 10 SEAT TRACK DUE TO A PERVIOUS BLEND AND GOUGE WHICH APPEARS TO BE BEYOND BLENDABLE LIMITS. REPAIRED IAW DHC-8 SRM 51-40-11, 51-40-00 AND RD 8-51-102.SDR QXEA0300150Seat Track · corrodedPDX- REMOVE AND REPLACE SEAT TRACK NR 11 DUE TO CORROSION AT STATION 455.5 WHICH APPEARS TO BE BEYOND BLENDABLE LIMITS. REPAIRED IAW DHC-8 SRM 51-40-11 AND 51-40-00.SDR 03FDEA00062Seat Track · corrodedCORROSION ON SEAT TRACK OUTBOARD FLANGE BS 720D - 720D+10 LBL 25 WL 208. REMOVED AND REPLACED NEW SEAT TRACK IAW SRM 51-30-2.SDR DHL2003804912Cargo Track · wornM/C COMPT CTR TRACK LUGS WORN FROM STA 1670.000 - STA 1710.000. REMOVED DAMAGED AREA FROM CTR TRACK IAW SRM 53-2-3 PG 49-50. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TRACK SECTION AND REINSTALLED SPLICES IAW SRM 53-2-3 PG 49-50 AND 51SDR DHL2003804904Cargo Track · wornMAIN CARGO COMPT NR 1 RT TRACK LUG WORN STA 1670.000 - STA 1770.000. REMOVED DAMAGED TRACK AREA IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TRACK SECTION WITH NEW FASTENERS ON MAIN CARGO COMPT 1 RT TRACK STA 1670.000SDR 2003F00451Seat Track · corrodedAT C-CHECK, FOUND CORROSION ON SEAT TRACK AT STATION 1100, RBL 48. REPLACED SEAT TRACK AT FUSELAGE STATION 1070-1136, RBL 48. TREATED AND PRIMED. (M)SDR 2003F00279Seat Track · corrodedAT C-CHECK, FOUND SEAT TRACK CORRODED AT STATION 1110 TO 1120, RBL 45. REMOVED CORROSION ON SEAT TRACK FLANGE. MATERIAL LOSS OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK. TREATED AND PRIMED. (M)SDR DHL2003804907Cargo Track · wornM/C COMPT NR 3 LT TRACK LUG WORN, STA 785.000. REMOVED NR 3 LT TRACK DAMAGED AREA IAW SRM 53-2-3 PG 17, SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW CHANNEL AND PLUG IAW SRM 53-2-3 PG 17, SRM 51-3-0 PG 1.SDR 03FDEA00055Seat Track · corrodedCORROSION IB-FLANGE ON SEAT TRACK NUT PLATE HOLE STA 514 LBL 25 WL 208. R&R SEAT TRACK PER SRM 51-30-2.SDR 03FDEA00054Seat Track · corrodedCORROSION ON SEAT TRACK OB FLANGE BS 650-660 LBL 25 WL 208. R&R SEAT TRACK PER SRM 51-30-2.SDR CALA0300015Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT BS 1495-1525, RBL 75. THE SEAT TRACK WAS REPAIRED IAW SRM 53-00-52, REPAIR 3.SDR MALA030142Seat Track · corrodedDURING C-CHECK IN CVG, NR 3 SEAT TRACK SHOWS CORROSION BETWEEN FRAME 18 & 20A. MAINTENANCE REPAIRED DAMAGE IAW EO A53026. A/C RELEASE DATE 1/30/03.SDR MALA030141Seat Track · corrodedDURING C-CHECK IN CVG, NR 1 SEAT TRACK SHOWS CORROSION BETWEEN FRAME 18 AND 20A. MAINTENANCE REPAIRED DAMAGE IAW EO A53026. A/C RELEASE DATE 1/30/03.SDR ASAA0380091Cargo Track · corrodedOKC - FOUND DURING C-CHECK, AFT CARGO BAY TIEDOWN BRACKET IS CORRODED. REPLACED BRACKET PER SRM 51-30-5. (M)SDR ASAA0380092Cargo Track · corrodedOKC - FOUND DURING C-CHECK, AFT CARGO BAY FLOOR TRACK CORRODED AT FASTENER HOLES. REPLACED FLOOR TRACK PER SRM 53-05 AND 51-10-3. (M)SDR ASAA0380086Cargo Track · corrodedOKC - FOUND DURING C-CHECK, AFT CARGO BAY TIEDOWN TRACK IS CORRODED AROUND FASTENER HOLES. REPLACED TRACK PER SRM 51-10-4 AND 51-30-1. (M)
Back to JASC 5347