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 QXEA0201795Seat Track · corrodedPDX - RIGHT HAND INBOARD NR 8 SEAT TRACK FORWARD OUTBOARD FLANGE CORROSION FROM X424.00 TO X427. REPAIRED IAW RD 8-53-1339, DHC8200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201794Seat Track · chafedPDX - RIGHT HAND INBOARD SEAT TRACK NR 9 BOTTOM CHAFED IN AFT BULKHEAD ATTACH AREA AT APPROXIMATELY X541.00. REPAIRED IAW RD 8-53-4936, DHC8200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201793Seat Track · chafedPDX - RIGHT HAND INBOARD SEAT TRACK NR 9 BOTTOM CHAFED IN SEAT ATTACH AREA AT APPROXIMATELY X526.00. REPAIRED IAW RD 8-53-4936, DHC-8 200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201792Seat Track · corrodedPDX - RIGHT HAND INBOARD SEAT TRACK NR 8 TOP CORROSION AND GOUGING IN SEAT ATTACH AREA AT APPROXIMATELY X516.00. REPAIRED SEAT TRACK IAW RD 8-53-1339, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201790Seat Track · gougedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 12 TOP GOUGED IN SEAT ATTACH AREA AT APPROXIMATELY X531.00. REPAIRED IAW DHC-8 200 SRM 51-20-16, PAGE 4, PARAGRAPH C AND SRM 51-20-36.SDR MALA020642Seat Track · corrodedDURING C-CHECK IN CVG, NR 4 SEAT TRACK FORWARD OF FRAME 20 IS CORRODED. MAINTENANCE REPAIRED NR 4 SEAT TRACK IAW A53026. A/C RELEASE DATE 11/11/02.SDR MALA020641Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 3 SEAT TRACK FORWARD OF FRAME 20 IS CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED NR 3 SEAT TRACK IAW EO A53026. A/C RELEASE DATE: 11/11/02.SDR MALA020640Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 1 SEAT TRACK FORWARD OF FRAME 20, UPPER SURFACE HAS CORROSION. MAINTENANCE REPAIRED NR 1 SEAT TRACK IAW EO 53026. RELEASE DATE WAS 11/11/02SDR QXEA0201789Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK NR 2 TOP CORROSION IN SEAT ATTACH AREA AT APPROXIMATELY X485.00 TO X491.00. REPAIRED IAW DHC-8 200 SRM 51-20-16, PAGE 4, PARAGRAPH C, STEPS 1-8 AND SRM 51-20-36.SDR QXEA0201788Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK NR 2 TOP CORROSION AND BOTTOM GOUGED IN SEAT ATTACH AREA AT APPROXIMATELY X469.00. REPAIRED IAW DHC-8 200 SRM 51-20-16, PAGE 4, PARAGRAPH C, STEPS 1-8 AND SRM 51-20-36.SDR QXEA0201787Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK NR 2 TOP CORROSION IN SEAT ATTACH AREA AT APPROXIMATELY X454.00. REPAIRED IAW DHC-8 200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201786Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK NR 2 TOP GOUGED IN SEAT ATTACH AREA AT APPROXIMATELY X438.00. REPAIRED IAW DHC-8200 SRM 51-20-16 AND SRM 51-20-36.SDR UPS02639799Seat Track · crackedBROKEN SEAT TRACK ***SUPPLEMENTAL MRR*** REMOVED AND REPLACED FLOORBOARDS PART NUMBER 457T4115-2SDR GTIA021170Seat Track · damagedFTW - FOUND LEFT OUTBOARD SEAT TRACK APPROXIMATELY STATION 807, 788, 768, 750, 731, 712, 693, 674, 655, 636, 617, 598, 560 AND 541. GOUGES AND CORROSION IN TRACK, APPROX STATION 807, 788, 768, 758 740, 731, 712, 693, 623, 674 AND 655 CORROSION AND GOUGES AT SSDR QXEA0201765Seat Track · chafedPDX - LT INBOARD NR 5 SEAT TRACK FORWARD OUTBOARD FLANGE CHAFED X424.00 TO X427.00. REPAIRED IAW RD 8-53-1339 AND RD 8-53-4473/4472.SDR AAL2003F00014Seat Track · corrodedNR 6 SEAT TRACK IS CORRODED BEYOND LIMITS. INSTALLED SEAT TRACK FROM STA 210 TO 798 IAW SRM 53-05-00, FIG 98.SDR QXEA0201782Seat Track · damagedPDX - NR 1 SEAT TRACK HAS NUMEROUS TOOLING MARKS FROM RIVET RUN ALONG VERTICAL BEAR APPROXIMATELY 0..6 INCH DEEP AT APPROXIMATELY STATION 264 WHERE PAINT STRIPPED. REPAIRED IAW HORIZON AIR EA 2-53-437.SDR AALA20021498Seat Track · corrodedTUL - FOUND RN 1 SEAT TRACK UNDER GALLEY CORRODED AT STATION 1177, 1195, 1208, 1215, 1225-1229, 1241 AND 1281. INSTALLED NEW SEAT TRACK NR 1 FROM STATION 1174 TO 1308 PER AMM 53-40-01. (M)SDR QXEA0201785Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK NR 1 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT APPROXIMATELY X312.00. REPAIRED IAW DHC-8 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA0201748Seat Track · corrodedPDX - CORROSION ON TOP OF LT OUTBOARD SEAT TRACK NR 1 IN SEAT ATTACH AREA APPROXIMATELY X424.00. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA0201747Seat Track · corrodedPDX - CORROSION ON TOP OF LT OUTBOARD SEAT TRACK NR 1 IN SEAT ATTACH AREA APPROXIMATELY X407.00. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA0201746Seat Track · corrodedPDX - CORROSION ON TOP OF LT OUTBOARD SEAT TRACK NR 1 IN SEAT ATTACH AREA APPROXIMATELY X393.00. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA0201745Seat Track · corrodedPDX - CORROSION ON LT OUTBOARD SEAT TRACK NR 1 TOP AND BOTTOM IN SEAT ATTACH AREA APPROXIMATELY X377.00. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA0201744Seat Track · corrodedPDX - CORROSION ON LT OUTBOARD SEAT TRACK NR 1 IN SEAT ATTACH AREA APPROXIMATELY X360.00 AND X368.00. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA0201743Seat Track · corrodedPDX - CORROSION ON LT OUTBOARD SEAT TRACK NR 1 TOP SEAT ATTACH AREA APPROXIMATELY X343.00. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA0201742Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK NR 1 TOP CORROSION IN SEAT ATTACH AREA APPROXIMATELY X328.00. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA0201741Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK NR 1 TOP CORROSION IN SEAT ATTACH AREA APPROXIMATELY X298.00. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA0201740Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK NR 1 TOP CORROSION IN SEAT ATTACH AREA APPROXIMATELY X280.00. REPAIRED IAW DHC-8 SRM 51-40-00.SDR DHL2002720515Seat Track · damagedDURING "C" CHECK, MAIN CABIN SEAT TRACK DAMAGED BS 480 TO 560 LBL 45.5. REPAIRED IAW SRM.SDR ASAA0280371Fitting · corrodedOKC - FOUND DURING 30K CHECK, TIE DOWN FITTING CORRODED IN AFT CARGO BAY FS 1153 BETWEEN LONGERON 30-29R. REPLACED FITTING PER SRM 51-10-3. (M)SDR ASAA0280374Seat Track · corrodedOKC - DURING 30K-CHECK, FOUND FALSE SEAT TRACK CORRODED AT FS 1155, BL 0. REPLACED TRACK PER SRM 51-30-1. (M)SDR QXEA0201762Seat Track · chafedPDX - LT INBOARD NR 4 SEAT TRACK INBOARD FLANGE AND DRIP HAVE BARE METAL AND LIGHT CHAFING IN VARIOUS AREAS ALONG FULL LENGTH. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201761Seat Track · chafedPDX - LT INBOARD NR 4 SEAT TRACK OUTBOARD FLANGE HAS BARE METAL AND LIGHT CHAFING VARIOS AREAS ALONG FULL LENGTH. REPLACED NR 4 SEAT TRACK.SDR QXEA0201760Seat Track · chafedPDX - LT INBOARD NR 4 SEAT TRACK BOTTOM CHAFED X380.00 TO X391.00. REPAIRED IAW RD 8-53-1339.SDR QXEA0201758Seat Track · chafedPDX - LT INBOARD NR 4 SEAT TRACK BOTTOM CHAFED X349.00 TO X359.00. REPAIRED IAW RD 8-53-1339.SDR QXEA0201756Seat Track · chafedPDX - LT INBOARD NR 4 SEAT TRACK BOTTOM CHAFED X316.00 TO X327.00. REPAIRED IAW RD 8-53-1339.SDR QXEA0201755Seat Track · chafedPDX - LT INBOARD NR 4 SEAT TRACK BOTTOM CHAFED X282.00 TO X296.00. REPAIRED IAW RD 8-53-1339.SDR QXEA0201753Seat Track · corrodedPDX - CORROSION ON LT INBOARD SEAT TRACK NR 4 IN SEAT ATTACH AREA AT APPROXIMATELY X377.00. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA0201752Seat Track · gougedPDX - GOUGING IN SEAT ATTACH AREA OF LT INBOARD SEAT TRACK NR 4 APPROXIMATELY X280.00. REPAIRED IAW RD 8-53-1339.SDR QXEA0201751Seat Track · corrodedPDX - CORROSION ON LT INBOARD SEAT TRACK NR 4 IN FLANGE APPROXIMATELY X220.00 TO X237.00. REPLACED NR 4 LT INBOARD SEAT TRACK.SDR QXEA0201763Seat Track · chafedPDX - RT INBOARD NR 7 SEAT TRACK OUTBOARD FLANGE HAS BARE METAL AND LIGHT CHAFING VARIOUS AREAS ALONG FULL LENGTH. REPLACED SEAT TRACK.SDR QXEA0201759Seat Track · chafedPDX - RT INBOARD NR 7 SEAT TRACK BOTTOM CHAFED X349.00 TO S359.00. REPAIRED IAW RD 8-53-1339.SDR QXEA0201757Seat Track · chafedPDX - RT INBOARD NR 7 SEAT TRACK BOTTOM CHAFED X316.00 TO X327.00. REPAIRED IAW RD 8-53-1339.SDR QXEA0201726Seat Track · chafedPDX - RT INBOARD NR 7 SEAT TRACK BOTTOM CHAFED X380.00 TO X391.00. REPLACED NR 7 RT INBOARD SEAT TRACK.SDR QXEA0201725Seat Track · chafedPDX - RT INBOARD NR 7 SEAT TRACK BOTTOM CHAFED X282.00 TO X296.00. REPLACED NR 7 SEAT TRACK.SDR QXEA0201724Seat Track · corrodedPDX - RT INBOARD SEAT TRACK NR 7 TOP CORROSION IN SEAT ATTACH AREA AT APPROXIMATELY X266.00. REPAIRED IAW RD 8-53-4473, RD 8-53-1102 AND DHC-8 SRM 51-40-11.SDR QXEA0201750Seat Track · damagedPDX - RT INBOARD SEAT TRACK NR 7 HAS BARE METAL AT SEAT ATTACH POINTS. REPLACED NR 7 RT INBOARD SEAT TRACK.SDR QXEA0201749Seat Track · corrodedPDX - CORROSION IN TOP OF RT INBOARD SEAT TRACK NR 7 APPROXIMATELY X212.00 TO X230.00. REPLACED NR 7 RT INBOARD SEAT TRACK.SDR QXEA0201764Seat Track · chafedPDX - RT INBOARD NR 7 SEAT TRACK INBOARD FLANGE AND DRIP HAVE BARE METAL AND LIGHT CHAFING VARIOUS AREAS ALONG FULL LENGTH. REPLACED SEAT TRACK.SDR QXEA0201727Seat Track · chafedPDX - RT INBOARD NR 7 SEAT TRACK BOTTOM CHAFED X410.00 TO X422.00. REPLACED NR 7 RT INBOARD SEAT TRACK.
Back to JASC 5347