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 DU4R2006439Seat Track · corrodedCORROSION ON LEFT O/B SEAT TRACK BS 1027. FABRICATED AND INSTALLED SEAT TRACK BS 898 TO BS 1075 177 INCHES FROM BAC1520-541 IAW B757 SRM 51-40-02 AND 53-00-52.SDR SIMA200611508Seat Track · corrodedSAW - FOUND RIGHT LOWER SEAT TRACK BETWEEN FRAMES 53 AND 55 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200611507Seat Track · corrodedFOUND RIGHT UPPER SEAT TRACK BETWEEN FRAMES 47 AND 52 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200611506Seat Track · corrodedFOUND RIGHT INBOARD SEAT TRACK BETWEEN FRAMES 24 AND 30 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200611505Seat Track · corrodedSAW - FOUND LEFT INBOARAD SEAT TRACK BETWEEN FRAMES 17 AND 24 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200611504Seat Track · corrodedFOUND RIGHT INBOARD SEAT TRACK BETWEEN FRAMES 36 AND 47 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200611503Seat Track · corrodedFOUND RIGHT UPPER SEAT TRACK BETWEEN FRAMES 30 AND 36 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200611502Seat Track · corrodedFOUND RIGHT UPPER SEAT TRACK BETWEEN FRAMES 53 AND 55 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200611501Seat Track · corrodedFOUND LEFT LOWER SEAT TRACK BETWEEN FRAMES 47 AND 53 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200611417Seat Track · corrodedSAW - FOUND LEFT INBOARD SEAT TRACK BETWEEN FRAMES 24 AND 30 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200611416Seat Track · corrodedFOUND LEFT OUTBOARD SEAT TRACK BETWEEN FRAMES 30 AND 36 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200611415Seat Track · corrodedFOUND RIGHT UPPER SEAT TRACK BETWEEN FRAMES 36 AND 47 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200611414Seat Track · corrodedSAW - FOUND LEFT UPPER SEAT TRACK BETWEEN FRAMES 47 AND 52 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200611418Seat Track · corrodedSAW - RIGHT INBOARD SEAT TRACK BETWEEN FRAMES 47 AND 53 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR TRAX200600078Seat Track · corrodedFOUND CORROSION ON FLOOR SEAT TRACK SEC 4 - FS559 TO 559+86 - BL9L, RESOLVED ON W/O: 22159 TASKCARD: N/R-00232. BLENDED ALL CORROSION ON PAX SEAT TRACK 559-559+86 LBL9 AS REQUIRED IAW CRJ 200 SRM 53-41-49 AND 53-00-00 AS REQUIRED. ALL REMOVED DAMAGE IS WITHISDR TRAX200600111Cargo Track · corrodedALL CARGO FLOOR TRACKS CORRODED.SDR TRAX200600096Seat Track · corrodedFOUND CORROSION ON FLOOR SEAT TRACK - SEC 2- FS 394 TO 409+128 - BL9RT.SDR TRAX200600092Seat Track · corrodedFOUND CORROSION ON FLOOR SEAT TRACK - SEC1 - FS364 TO 394 - BL9RT.SDR TRAX200600091Seat Track · corrodedFOUND CORROSION ON FLOOR SEAT TRACK - SEC 4 - FS559 TO 559+86 - BL9RT.SDR TRAX200600083Seat Track · corrodedFOUND CORROSION ON FLOOR SEAT TRACK -SEC 1, FS 364 TO 394 -BL9LT.SDR TRAX200600067Seat Track · corrodedFOUND CORROSION ON LT SIDEWALL SEAT TRACK AT FUS STA 409+16 APPROX .SDR TRAX200600066Seat Track · corrodedFOUND CORROSION ON RT IB SEAT TRACK AT FS 529 APPROX.SDR TRAX200600065Seat Track · corrodedFOUND CORROSION ON LT IB SEAT TRACK AT APPROX FUS STA 559+64.SDR AWXA200600669Seat Track · corrodedSAL - MAJOR REPAIR - NR 5915048 - DURING C6 CHECK DISCOVERED CORROSION ON THE LEFT HAND OUTBOARD SEAT TRACK AT FR 42 + 18, Y1292. MAINTENANCE REMOVED LEFT HAND OUTBOARD SEAT TRACK BETWEEN FS 41 AND FS 47, Y 1292. RE-WORK WAS FOUND OUT OF LIMITS IAW AIRBUS 32SDR AWXA200600668Seat Track · corrodedSAL - DURING C6 CHECK DISCOVERED CORROSION ONTHE LEFT OUTBOARD SEAT TRACK BETWEEN FS 39 AND FS 40, Y1292. CORROSION WAS FOUND OUT OF SRM LIMITS. MAINTENANCE REMOVED THE LEFT OUTBOARD SEAT TRACK FROM FS 36 TO FS 41, Y 1292 IAW AIRBUS 320 SRM 51-72-11. INSTALSDR SIMA200611411Seat Track · corrodedFOUND RIGHT UPPER SEAT TRACK BETWEEN FRAMES 24-30 CORRODED. REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR AWXA200600659Seat Track · corrodedDURING C6 CHECK DISCOVERED CORROSION ON SEAT TRACK LOC. -Y765 FR 58+4", FR 59+6", FR60+3",FR61+13", FR 62+9" AND FR 64+2" FLOOR CABIN (6 POINTS). MAINTENANCE REPAIRED SEAT TRACK AT Y765 FR 58+4 IAW AIRBUS 320 SRM 53-00-15 FIG 201 AND SRM 561-42-11. THE OTHERSDR SIMA200611408Seat Track · corrodedSAW - FOUND RIGHT OUTBOARD SEAT TRACK BETWEEN FRAMES 30-36 IS CORRODED. REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA200611406Seat Track · corrodedLEFT FORWARD INBOARD SEAT TRACK HAS CORROSION. REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR QXEA200601080Seat Track · corrodedPDX - C4 SEAT TRACK NR 6 FUSELAGE STATION 545 CORROSION IN THE BOTTOM OF THE TRACK. REPAIRED IAW RD 8-53-1339, RD 8-53-4936, DHC-8-200 SRM 51-20-16, 51-20-36 AND 51-20-56.SDR QXEA200601074Seat Track · corrodedPDX - C4 SEAT TRACK NR 6 THE NUT PLATE TANGS AT FUSELAGE STATION 547, 564 AND 580 ARE CORRODED. REPAIRED IAW RD 8-53-1336, DHC-8-200 SRM 51-20-36, 51-20-16 AND SRM 51-20-56.SDR QXEA200601073Seat Track · corrodedPDX - C4 SEAT TRACK NR 6 FUSELAGE STATION 597 CORROSION OUTBOARD BOTTOM OF TRACK. REPAIRED IAW RD 8-53-4936 AND DHC-8-200 SRM 51-20-36 AND SRM 51-20-56.SDR AWXA200600683Seat Track · corrodedDURING BC6 CHECK DISCOVERED CORROSION ON THE INBOARD RT SEAT TRACK BETWEEN FS 41 AND FS 42 AT Y-765. CORROSION WAS REMOVED AND REWORK WAS FOUND OUT OF LIMITS IAW AIRBUS 320 SRM 53-31-15 FIG 103. MAINTENANCE REMOVED AND INSTALLED NEW SEAT TRACK AT Y-765 FS 41SDR QXEA200601198Seat Track · corrodedPDX - C4 RIGHT INBOARD SEAT TRACK NR 7 HAS AREA OF LIGHT CORROSION ON TOP OF TRACK AT STATION X202. REPAIRED IAW DHC-8-200 SRM 51-20-16, 51-20-36 AND RD 8-53-4698.SDR QXEA200601187Seat Track · corrodedPDX - C4 GOUGES IN RIGHT OUTBOARD SEAT TRACK AT STATION X392. REPAIRED IAW RD 8-53-1342, DHC-8-200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA200601186Seat Track · corrodedPDX - C4 CORROSION IN CENTER OF RIGHT OUTBOARD SEAT TRACK AT APPROXIMATELY STATION X376. REPAIRED IAW DHC-8-200 SRM 51-20-16, 51-20-36 AND RD 8-53-1342.SDR QXEA200601113Seat Track · corrodedPDX - C4 RIGHT INBOARD SEAT TRACK NR 7 HAS CORROSION ON TOP OF TRACK AT APPROXIMATELY STATION X 228. REPAIRED IAW RD 8-53-4698, DHC 8 200 SRM 51-26-16 AND 51-26-36.SDR QXEA200601086Seat Track · corrodedPDX - C4 SEAT TRACK NR 4 FUSELAGE STATION 399 CORROSION ON THE INBOARD BOTTOM OF THE TRACK. REPAIRED IAW RD 8-53-1339, DHC-8-200 SRM 51-20-36.SDR QXEA200601085Seat Track · corrodedPDX - C4 SEAT TRACK NR 4 FUSELAGE STATION 376 CORROSION IN THE BOTTOM OF THE SEAT TRACK. REPAIRED IAW RD 8-53-1339 AND DHC-8-200 SRM 51-20-36.SDR QXEA200601084Seat Track · corrodedPDX - C4 SEAT TRACK NR 4 FUSELAGE STATION 342-345 CORROSION IN THE BOTTOM OF THE TRACK. REPARIED IAW RD 8-53-1339, DHC-8-200 SRM 51-20-16, 51-20-36.SDR QXEA200601083Seat Track · corrodedPDX - C4 SEAT TRACK NR 4 FUSELAGE STATION 201 THROUGH 234 THERE IS CORROSION AROUND ALL THE RIVET HOLES ON THE OUTBOARD FLANGE. REPAIRED IAW RD 8-56-4698, DHC-8-200 SRM 51-40-11 AND 51-20-36.SDR QXEA200601081Seat Track · corrodedPDX - C4 SEAT TRACK NR 5 FUSELAGE STATION 488-494 CORROSION IN THE BOTTOM OF THE TRACK. REPAIRED IAW RD 8-53-1339, DHC-8-200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA200601089Seat Track · gougedPDX - C4 RIGHT INBOARD SEAT TRACK NR 7 GOUGE ON TOP OF TRACK AT APPROXIMATELY STATION X215.0. REPAIRED IAW RD 8-53-4698, DHC-8-200 SRM 51-20-16 AND 51-20-36.SDR QXEA200601088Seat Track · corrodedPDX - C4 RIGHT INBOARD SEAT TRACK NR 7 HAS CORROSION ON TOP AND EDGE OF TRACK AT APPROIMATELY STATION X195. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA200601087Seat Track · corrodedPDX - C4 RIGHT HAND INBOARD SEAT TRACK NR 7 HAS CORROSION ON TOP OF TRACK AT APPROXIMATELY STATION X186.0. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA200601082Seat Track · gougedPDX - C4 SEAT TRACK NR 1 FUSELAGE STATION SCRATCHES AND GOUGES ON TOP OF TRACK. REPAIRED IAW RD 8-53-1342 AND DHC-8-200 SRM 51-20-36.SDR QXEA200601078Seat Track · corrodedPDX - C4 RIGHT HAND INBOARD SEAT TRACK HAS LIGHT CORROSION AT APPROXIMATLEY X507. REPAIRED IAW RD 8-53-1342, DHC-8-200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA200601077Seat Track · corrodedPDX - C4 RIGHT INBOARD SEAT TRACK HAS LIGHT CORROSION AT APPROXIMATLEY X438. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA200601076Seat Track · corrodedPDX - C4 RIGHT OUTBOARD SEAT TRACK IS CORRODED AT APPROXIMATELY X470. REPAIRED IAW RD 8-53-1342 AND DHC-8-200 SRM 51-20-16, SRM 51-20-36.SDR QXEA200601072Seat Track · corrodedPDX - C4 SEAT TRACK NR 3 FUSELAGE STATION 541-543 CORROSION IN BOTTOM OF TRACK. REPAIRED IAW RD 8-53-3644 AND DHC-8-200 SRM 51-20-36.
Back to JASC 5347