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 UPS02239164Seat Track · crackedINSPECTION TYPE:C CRACK ON SEAT TRACK IN LWR AFT CARGO COMP AT BS 960 BBL 18L. REPAIR CARRIED OUT IAW SRM 53-10-5 FIG 5.SDR QXEA0201167Seat Track · gougedPDX-RIGHT HAND INBOARD NR 7 SEAT TRACK HAS GOUGES AT X411.000. REPAIRED IAW DHC8 SRM 51-20-16, PAGE 4, SRM 51-20-36 AND SRM 20-16-01.SDR UPS02M39589Seat Track · corrodedINSPECTION TYPE:C CABIN SEAT TRACK HAS CORROSION AT STA 1351-1361 X=-75.25. SEAT TRACK AT STA 1351-1361 CORROSION EXCEED LIMITS PER SRM 53-70-00 FIG3 VOL1 REV31. SEAT TRACK FABRICATED & REPLACED FROM STA 1260 TO 1391 AS PER SRM53- 70-00 FIG1 VOL1 REV31.SDR SIMA200222701Seat Track · corrodedMBV - FOUND PREVIOUS REPAIR ON FORWARD END OF SEAT TRACK 18.3L CORRODED. PREPARED AND INSTALLED EXTRUSION (P/N 7253799381) AND U-BEAM (P/N 7253799379) IAW SAAB 340 SRM 72LKS 3079 REV 40 53-70-60 PG 204/205. (M)SDR QXEA0201170Seat Track · corrodedPDX-CORROSION AT AFT END OF NR 6 SEAT TRACK AT STATION Y9.250 AND X596.0. REPAIRED IAW RD8-53-4936 AND SRM 51-40-11.SDR CALA0200438Seat Track · corrodedINSPECTION FOUND L/H CENTER SEAT TRACK CORRODED BETWEEN STA 1079 AND 1136. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-5.SDR AAL2002F00017Seat Track · corrodedSEAT TRACK NR 3, CORRODED AT STA 1232, STA 1275, AND STA 1300. C/A: SPLICED IN SERVICEABLE SEAT TRACK FROM STA 1185 TO STA 1309 IAW SRM.SDR BJNA020810Seat Track · corrodedSURFACE CORROSION ON SEAT TRACK AT RBL 32 AT BS 328, LEVEL 2 CORROSION. FOUND CORROSION ON SEAT TRACK OUT OF LIMITS, CUT NEW TRACK FROM BAC1520-792 16 INCH INSTALLED IAW 727 SRM 51-10-2, 51-10-1 AND 51-30-2. (M)SDR QXEA0201221Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK HAS CORROSION ON OUTBOARD FLANGE AT X222.000. REPAIRED IAW DHC-8 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA0201220Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK HAS CORROSION ON OUTBOARD FLANGE AT X222.000. REPAIRED IAW DHC-8 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA0201188Seat Track · corrodedPDX-LEFT HAND INBOARD NR 4 SEAT TRACK HAS CORROSION ON OUTBOARD FLANGE AT X222.000. REPAIRED IAW RD8-53-4473 AND SRM 51-40-11, RD8-53-1102, SRM 51-40-00, SRM 51-60-00 AND SRM 51-60-11.SDR QXEA0201176Seat Track · gougedPDX-RIGHT HAND INBOARD NR 7 SEAT TRACK HAS GOUGES ON SEAT TRACK AT X409.000. REPAIRED IAW RD8-53-1339 AND SRM 51-20-16, PAGE 4.SDR QXEA0201175Seat Track · gougedPDX- RIGHT HAND INBOARD NR 7 SEAT TRACK HAS GOUGES ON SEAT TRACK AT X372.000. REPAIRED IAW RD8-53-1339 AND SRM 51-20-16, PAGE 4.SDR QXEA0201174Seat Track · gougedPDX- RIGHT HAND INBOARD NR 7 SEAT TRACK HAS GOUGES IN CENTER OF TRACK AT X296.000. REPAIRED IAW RD8-53-1339 AND SRM 51-20-16, PAGE 4.SDR QXEA0201173Seat Track · gougedPDX-RIGHT HAND INBOARD NR 7 SEAT TRACK HAS GOUGES ON INBOARD AND OUTBOARD RAILS AT X282.000. REPAIRED IAW RD8-53-1339 AND SRM 51-20-16, PAGE 4.SDR QXEA0201172Seat Track · gougedPDX-RIGHT HAND INBOARD NR 7 SEAT TRACK HAS GOUGE IN CENTER OF TRACK AT X280.000. REPAIRED IAW RD8-53-1339 AND SRM 51-20-16, PAGE 4.SDR QXEA0201166Seat Track · gougedPDX-RIGHT HAND INBOARD NR 8 SEAT TRACK HAS GOUGES ON INBOARD TRACK RAIL AT X436.000. REPAIRED IAW RD8-53-1339 AND SRM 51-20-16, PAGE 4.SDR QXEA0201165Seat Track · corrodedPDX-LEFT HAND INBOARD NR 5 SEAT TRACK HAS SURFACE CORROSION AT X515.000. REPAIRED IAW RD8-53-1339 AND SRM 51-20-16, PAGE 4.SDR QXEA0201164Seat Track · gougedPDX-LEFT HAND INBOARD NR 5 SEAT TRACK IS GOUGED IN CENTER OF TRACK AT X501.000. REPAIRED IAW RD8-53-1339 AND SRM 51-20-16, PAGE 4.SDR QXEA0201160Seat Track · corrodedPDX-LEFT HAND OUTBOARD NR 3 SEAT TRACK HAS SURFACE CORROSION. REPAIRED IAW RD8-53-3644 AND SRM 51-20-16, PAGE 4.SDR QXEA0201159Seat Track · gougedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS GOUGES ON OUTBOARD RAIL AT X456.500. REPAIRED IAW RD 8-53-1342 AND SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR QXEA0201158Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS CORROSION AT X488.500. REPAIRED IAW RD 8-53-1342 AND SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR QXEA0201157Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS CORROSION AT X467.000. REPAIRED IAW RD 8-53-1342 AND SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR QXEA0201156Seat Track · gougedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS GOUGES ON OUTBOARD FLANGE AT X426.000. REPAIRED IAW RD 8-53-1352 AND SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR QXEA0201155Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS SURFACE CORROSION AT X438.000. REPAIRED IAW RD 8-53-1342 AND SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR QXEA0201154Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS SURFACE CORROSION AT X424.124. REPAIRED IAW RD 8-53-1342 AND SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR QXEA0201153Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS SURFACE CORROSION AT X405.737. REPAIRED IAW RD 8-53-1342 AND SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR QXEA0201152Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS SURFACE CORROSION AT X380.000. REPAIRED IAW RD 8-53-1352 AND SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR QXEA0201151Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS SURFACE CORROSION AT X295.000. REPAIRED IAW RD 8-53-1352 AND SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR QXEA0201150Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS LIGHT CORROSION AT X256.000. REPAIRED IAW RD 8-53-1342.SDR DHL2002721504Seat Track · corrodedDURING C-CHECK DISCREPANCY AS FOLLOWS, CABIN, SEAT TRACK AT STA 760 IS CORRODED AT RBL 24. REMOVED CORROSION FROM CABIN SEAT TRACK AND FOUND CORROSION TO BE BEYOND ALLOWABLE LIMITS IAW B-727 SRM 53-10-1 FIG 3. REMOVED CORRODED SEAT TRACK IAW B-727 SRM 51-30-2SDR DHL2002721503Seat Track · corrodedDURING C-CHECK DISCREPANCY AS FOLLOWS, CABIN SEAT TRACK BETWEEN STA 870-848, AFT FLANGE CORRODED AT LBL 24. REMOVED CORROSION FROM CABIN SEAT TRACK, BEYOND ALLOWABLE LIMITS IAW B-727 SRM 53-10-1 FIG 1. REMOVED CORRODED SEAT TRACK. FABRICATED NEW SECTION IAWSDR UPS02M39590Seat Track · corrodedINSPECTION TYPE:C CABIN SEAT TRACK CORRODED FROM STA1321 TO 1361X=75.25 & TRACK JOINER AT STA1351X=75.25. SEAT TRACK AT STA 1321 TO STA1361,X=75.25 & STA1351,X=75.25 EXCEEDED LIMIT AS PER SRM 53-70-00 FIG3 VOL1 REV31. SEAT TRACK FABRICATED & REPLACED FROM STSDR QXEA0201163Seat Track · corrodedPDX-RIGHT HAND OUTBOARD NR 11 SEAT TRACK IS GOUGED AND HAS SURFACE CORROSION AT X467.000. REPAIRED IAW RD8-53-1342 AND SRM 51-20-16, PAGE 4.SDR QXEA0201162Seat Track · corrodedPDX-RIGHT HAND OUTBOARD NR 11 SEAT TRACK IS GOUGED AND HAS SURFACE CORROSION AT X452.000. REPAIRED IAW RD8-53-1342 AND SRM 51-20-16, PAGE 4.SDR QXEA0201161Seat Track · corrodedPDX-RIGHT HAND OUTBOARD NR 11 SEAT TRACK HAS CORROSION. REPAIRED IAW RD8-53-1342 AND SRM 51-20-16, PAGE 4.SDR QXEA0201149Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK HAS LIGHT SURFACE CORROSION AT X421.000. REPAIRED IAW DHC-8 SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR QXEA0201148Seat Track · gougedPDX - RIGHT HAND OUTBOARD SEAT TRACK HAS GOUGES AT X342.300. REPAIRED IAW DHC-82 SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR QXEA0201147Seat Track · gougedPDX - RIGHT HAND OUTBOARD SEAT TRACK HAS GOUGES IN CENTER AT X310.000. REPAIRED IAW DHC-82 SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR QXEA0201146Seat Track · gougedPDX - RIGHT HAND OUTBOARD SEAT TRACK HAS GOUGES AT X282.400. REPAIRED IAW DHC-82 SRM 51-20-16, PAGE 4, PARAGRAPH 4D.SDR MALA020465Seat Track · corrodedDURING 4K INSPECTION IN CWA, BL 0 SEAT TRACK HAS LIGHT CORROSION. MAINTENANCE REMOVED CORROSION, TREATED, PRIMED AND PAINTED SEAT TRACK IAW E SF340 SRM 51-70-40.SDR MALA020464Seat Track · corrodedDURING 4K INSPECTION IN CWA, LBL 18.3 SEAT TRACK HAS CORROSION ON SIDE IN CARGO INFILL PANEL AREA. MAINTENANCE REMOVED CORROSION IAW SRM 51-70-40.SDR MALA020463Seat Track · corrodedDURING 4K INSPECTION IN CWA, LBL 18.3 SEAT TRACK HAS CORROSION AT FWD SECTION AND CENTER SECTION. MAINTENANCE REMOVED CORROSION IAW SRM 51-70-40.SDR CALA0200436Seat Track · corrodedINSPECTION FOUND R/H CENTER AND R/H I/B SEAT TRACKS CORRODED AT STA 228. THE CORRODED SEAT TRACK SECTIONS WERE REMOVED AND NEW SECTIONS WERE SPLICED IN IAW SRM 53-05, FIGURE 4F AND 51-30-0.SDR MALA020459Seat Track · corrodedDURING 4K INSPECTION IN CWA, I/B GALLEY SEAT TRACK HAS CORROSION. MAINTENANCE REMOVED CORROSION AND APPLIED PROTECTIVE TREATMENTS AND COATINGS IAW SAAB SRM 51-70-40.SDR DHL2002721514Seat Track · corrodedDURING C-CHECK, CABIN SEAT TRACK AT LBL 45 IS CORRODED AT STA 1148 AND STA 1156. REMOVED CABIN SEAT TRACK SECTION FROM STA 1148 TO STA 1156-LBL 45 IAW B-727 SRM 51-30-2. FABRICATED NEW SECTION OF SEAT TRACK IAW B-727 SRM 53-10-5 FIG 1. INSTALLED NEW SEAT TRSDR UPS02M39219Seat Track · corrodedINSPECTION TYPE:C, CABIN FLOOR SEAT TRACK HAS CORROSION AT STA 800 TO 805 X=8.5. SEAT TRACK CROWN CORROSION REMOVED, FOUND EXCEEDED LIMIT PER SRM 53-70-00 FIG 3 VOL I REV 31. SEAT TRACK SECTIONAL REPLACED FROM STA 783 TO STA 909 X=8.5.SDR DHL2002721508Seat Track · corrodedDURING C-CHECK, CABIN SEAT TRACK AT RBL 45 IS CORRODED AT STA 1177. REMOVED CABIN SEAT TRACK AT STA 1177 AND RBL 45 IAW B-727 SRM 51-30-2. FABRICATED NEW SEAT TRACK IAW B-727 SRM 53-10-5 FIG 1. INSTALLED SECTION OF SEAT TRACK IAW B-727 SRM 53-10-5 FIG 1.SDR DHL2002721507Seat Track · corrodedDURING C-CHECK, CABIN SEAT TRACK AT LBL 24 IS CORRODED AT STA 1136 AND STA 1156. REMOVED CABIN SEAT TRACK SECTION IAW B 727 SRM 51-30-2. FABRICATED A NEW SECTION OF SEAT TRACK IAW B-727 SRM 57-10-5 FIG 1. INSTALLED NEW SEAT TRACK IAW B-727 SRM 53-10-5 FIG 1SDR UPS02439096Seat Track · corrodedINSPECTION TYPE:C M/D- BS2278 LBL 33 SEAT TRACK CROWN CORR. CORROSION REMOVED IAW SRM 51-10-01. CORROSION BLEND OUT 0.040" X 1" X 2" EXCEED SRM 53-10-01 FIG 1 LIMITS. FOR REPLACEMENT REFER TO SRM FIG 51-10-01.
Back to JASC 5347