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 AWXA200601977Dummy Rail · corrodedSAL - CORROSION ON MAIN CABIN DUMMY RAIL, FS 16 + 19", -Y1292. REPLACED MAIN CABIN DUMMY RAIL, FS 12 - FS 24, -Y1292 IAW A319 SRM 51-72-11.SDR 06FDEA04097Seat Track · wornSTRUCTURES-A300/A310 REPAIR IDENTIFICATION AND SUPPLEMENTAL MAINTENANCE COMPLY WITH EO 6-5100-7-5000 REV NR B POS PT1. CABIN FLOOR TRACK Y-450 WORN BETWEEN FRAMES 60 AND 61. REPAIRED PER SRM 53-10-16 FIG 208 SHEET 1. REPAIR EVALUATED PER GMM 6-2-100 AND CLSDR 06FDEA04096Seat Track · wornSTRUCTURES-A300/A310 REPAIR IDENTIFICATION AND SUPPLEMENTAL MAINTENANCE COMPLY WITH EO 6-5100-7-5000 REV NR B POS PT1. CABIN, FLOOR TRACK Y-952 WORN BETWEEN FRAMES 60 AND 61. REPAIRED PER SRM 53-10-16 FIG 208 SHEET 1. REPAIR EVALUATED PER GMM 6-2-100 AND CSDR 06FDEA04089Seat Track · wornSTRUCTURES-A300/A310 REPAIR IDENTIFICATION AND SUPPLEMENTAL MAINTENANCE COMPLY WITH EO 6-5100-7-5000 REV NR B POS PT1. CABIN FLOOR TRACK Y-450 WORN BETWEEN FRAMES 60 AND 61. REPAIRED PER SRM 53-10-16 FIG 208 SHEET 1.SDR 06FDEA04088Seat Track · wornSTRUCTURES-A300/A310 REPAIR IDENTIFICATION AND SUPPLEMENTAL MAINTENANCE COMPLY WITH EO 6-5100-7-5000 REV NR B POS PT1. CABIN FLOOR TRACK Y-952 WORN BETWEEN FRAMES 60 AND 61 REPAIRED PER SRM 53-10-16 FIG 201 SHEET 1.SDR AWXA200602031Seat Track · corrodedMCN - CORROSION ON MAIN CABIN SEAT TRACK, BS 395 TO BS 412, LBL 20, WL 208. REPLACED MAIN CABIN SEAT TRACK, BS 344 -BS 460, LBL 20 IAW B737-300 SRM 51-40-02.SDR AWXA200602004Seat Track · corrodedMCN - CORROSION ON MAIN CABIN SEAT TRACK, BS 395 TO BS 412, RBL 45. REPLACED MAIN CABIN SEAT TRACK, BS 395 TO BS 412, RBL 45 IAW B737-300 SRM 51-40-02.SDR AWXA200601980Seat Track · corrodedSAL - CORROSION ON MAIN CABIN SEAT TRACK, FS 36+2", FS 37+1", FS 38+3", FS 39+1", FS 40+1", -Y1292. REPLACED MAIN CABIN SEAT TRACK, FS 36 - FS 41, -Y1292 IAW A319 SRM 51-72-11.SDR AWXA200601970Seat Track · corrodedMCN - MAJOR REPAIR - CORROSION ON MAIN CABIN SEAT TRACK, +Y1292, FS 41 TO FS 46+16". REPLACED MAIN CABIN SEAT TRACK, +Y1292, FS 41 TO FS 47 IAW A319 SRM 51-72-11 AND 51-42-11.SDR 06FDEA04077Seat Track · crackedLOWER FUSELAGE FWD CARGO COMPT AT STA 755 X = 47 Z = -18 ON SEAT TRACK FOUND CRACK 3" LONG. REMOVED AND REPLACED CRACKED SECTION OF SEAT TRACK IAW SRM 53-70-00 FIG 1 VOL 1. REMOVED AND REPLACED DAMAGED FLOOR PANELS IAW SRM 53-60-00 VOL 1 PAGE 26. FABRICATESDR 06FDEA04058Seat Track · corrodedMAIN CABIN COMPT FOUND CORROSION WITH EXFOLIATION ON SEAT TRACK FROM STA 1381 TO STA 1521 AT X = 107 LT SIDE. CUT REMOVED CORRODED SECTION OF TRACK, INSTALLED NEW SECTION TRACK AND SPLICE -7A IAW SRM 53-70-00 FIG 1 SHT 1/3 VOL 1. FABRICATED PARTS IAW DETAIL SDR QXEA200603055Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK HAS CORROSION IN CHANNEL FROM X410-X421, WITH A PIT AT X417. REPAIRED IAW RD8/4-53-884, SRM 51-21-10.SDR AWXA200601963Seat Track · corrodedSAL - MAJOR REPAIR - CORROSION ON MAIN CABIN SEAT TRACK, FS 36 - FS 41, -Y765. REPLACED MAIN CABIN SEAT TRACK, FS 36 - FS 41, -Y765 IAW A319 SRM 51-72-11.SDR MALA060612Seat Track · corrodedSEAT TRACK AT LBL 18.3 HAS CORROSION THAT IS OUT OF LIMITS. REPAIRED IAW MESABA EOS53342. SEE EAMS WORK ORDER 214742 TASK 1518.SDR MALA060611Seat Track · corrodedSEAT TRACK AT BL0 HAS CORROSION THAT IS OUT OF LIMITS. REPAIRED IAW MESABA EOS53342. SEE EAMS WORK ORDER 214742 TASK 1517.SDR QXEA200603476Seat Track · corrodedC2 PDX - FOUND SEAT TRACK NR 16 IS PITTED IN NUMEROUS PLACES BETWEEN X719 AND X742. REPAIRED IAW RD8/4-53-884 AND RD8/4-53-1769.SDR QXEA200603391Seat Track · corrodedPDX C4 - LEFT OUTBOARD SEAT TRACK BOX STRUCTURE TOP SIDE AT STRINGER 23L HAS 13" LONG AREA WITH SPOTS OF CORROSION AROUND (13) RIVETS BETWEEN FUSELAGE STATION X5100 - X524. REPAIRED IAW DHC-8-200 SRM 51-40-11.SDR AWXA200602003Seat Track · corrodedMCN - CORROSION ON MAIN CABIN SEAT TRACK, BS 395 TO BS 412, RBL 24. REPLACED MAIN CABIN SEAT TRACK, BS 395 TO BS 412, RBL 24 IAW B737-300 SRM 51-40-02.SDR QXEA200603060Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK NR 19 PITTED AND GOUGED AT STATION X260, X272.0, X303.0, X310.0, X341.0, X365.0, X405.0, X418.0, X449.0, X540.0. REPAIRED IAW RD8/4-53-884 AND SRM 51-21-10.SDR QXEA200603059Seat Track · corrodedC2 PDX - LEFT INBOARD SEAT TRACK NR 4 LEFT FLOOR SUPPORT FLANGE HAS LIGHT SURFACE CORROSION FROM X9-X26. REPAIRED IAW RD8/4-53-884, SRM 51-21-00, AND RD8/4-53-1767.SDR QXEA200603044Seat Track · damagedC2 PDX - LEFT INBOARD SEAT TRACK NR 5 HAS MINOR SCRATCHES AT STATION X88 TO X96. REPAIRED IAW RD8/4-53-884, SRM 51-21-10.SDR QXEA200603507Seat Track · corrodedC2 PDX - SEAT TRACK NR 9 HAS PITTING CORROSION ON AFT END FROM X778 TO X782. REPAIRED IAW RD8/4-53-884 AND SRM 51-21-10.SDR QXEA200603506Seat Track · damagedC2 PDX - RIGHT INBOARD SEAT TRACK NR 15 HAS MINOR SCRATCHES FROM STATION X614 TO X624. REPAIRED IAW RD8/4-53-884 AND SRM 51-21-10.SDR QXEA200603503Seat Track · corrodedC2 PDX - LEFT SEAT TRACK NR 2 HAS LIGHT CORROSION IN CHANNEL AT X541. REPAIRED IAW RD8/4-53-884.SDR QXEA200603500Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK HAS LIGHT CORROSION IN THE CHANNEL X484-X495. REPAIRED IAW RD8/4-53-884.SDR QXEA200603505Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK NR 19 PITTED AND GOUGED AT STATIONS X260.0, X272.0, X303.0, X310.0, X341.0, X365.0, X388.0, X405.0, X418.0, X439.0, X449.0, X465.0, X540.0. REPAIRED IAW RD8/4-53-884.SDR QXEA200603502Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK 32 HAS LIGHT CORROSION IN CHANNEL AT X512. REPAIRED IAW RD8/4-53-884.SDR QXEA200603499Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 2 CORROSION PITS IN CHANNEL BETWEEN X480 AND X484. REPAIRED IAW RD8/4-53-884.SDR QXEA200603498Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK HAS LIGHT CORROSION IN CHANNEL FROM X449-X457 AND AT X462. REPAIRED IAW RD8/4-53-884.SDR QXEA200603497Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 2 HAS LIGHT CORROSION ON TOP AND IN CHANNEL FROM X363-X379. REPAIRED IAW RD8/4-53-884.SDR QXEA200603493Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 2 HAS CORROSION ON TOP AND IN CHANNEL FROM X322-X327, WITH A PIT AT X323. REPAIRED IAW RD8/4-53-884.SDR QXEA200603496Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 2 HAS LIGHT CORROSION ON TOP AND IN CHANNEL FROM X357-X360. REPAIRED IAW RD8/4-53-884.SDR QXEA200603494Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 2 HAS CORROSION IN CHANNEL FROM X331-X340. REPAIRED IAW RD8/4-53-884.SDR QXEA200603495Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 2 HAS A PIT IN THE CHANNEL AT X355. REPAIRED IAW RD8/4-53-884.SDR QXEA200603488Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 3 HAS LIGHT SURFACE CORROSION IN CHANNEL AT X655. REPAIRED IAW RD8/4-53-884.SDR QXEA200603486Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 3 HAS LIGHT SURFACE CORROSION IN CHANNEL FROM X576-X578. REPAIRED IAW RD8/4-53-884.SDR QXEA200603485Seat Track · corrodedC2 PDX - FOUND LEFT OUTBOARD SEAT TRACK NR 3 HAS LIGHT SURFACE CORROSION IN CHANNEL IN FORWARD 1" OF SEAT TRACK. REPAIRED IAW RD8/4-53-884.SDR QXEA200603483Seat Track · damagedC2 PDX - RIGHT OUTBOARD SEAT TRACK NR 21 NICKED AT STATION X700.00. REPAIRED IAW RD8/4-53-884 AND SRM 51-21-10.SDR QXEA200603487Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK HAS A SMALL DIA PIT IN CHANNEL AT X602. REPAIRED IAW RD8/4-53-884.SDR QXEA200603484Seat Track · damagedC2 PDX - RIGHT INBOARD SEAT TRACK NR 13 HAS MINOR SCRATCHES, NICKS, CHAFES AT STATION 356-590. REPAIRED IAW RD8/4-53-884 AND SRM 51-21-10.SDR QXEA200603492Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 2 HAS CORROSION IN CHANNEL AT X310. REPAIRED IAWRD8/4-53-884.SDR QXEA200603490Seat Track · corrodedC2 PDX-LEFT OUTBOARD SEAT TRACK NR 2 HAS LIGHT CORROSION IN CHANNEL FROM X255-X258. REPAIRED IAW RD8/4-53-884.SDR QXEA200603491Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 2 HAS LIGHT CORROSION ON TOP AND IN CHANNEL FROM X260-X280 WITH A PIT AT X262. REPAIRED IAW RD8/4-53-884.SDR QXEA200603489Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 2 HAS LIGHT CORROSION ON TOP AND IN CHANNEL FROM X230-X239. REPAIRED IAW ED8/4-53-884.SDR QXEA200603482Seat Track · gougedC2 PDX - RIGHT OUTBOARD SEAT TRACK NR 19 GOUGED AT STATION X556.0. REPAIRED IAW RD8/4-53-884 AND SRM 51-21-10.SDR QXEA200603481Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK NR 19 PITTED FROM STATION X323.0 TO X327.0. REPAIRED IAW ED8/4-53-884 AND SRM 51-21-10.SDR QXEA200603480Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK NR 19 PITTED AT STATION X291.0. REPAIRED IAW RD8/4-53-884 AND SRM 51-21-10.SDR QXEA200603056Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 2 HAS A PIT AT X447. REPAIRED IAW RD8/4-53-884.SDR QXEA200603054Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 2 HAS LIGHT CORROSION IN CHANNEL IN 3 PLACES X382-X384, X388-X392, X396-X402. REPAIRED IAW RD8/4-53-884.SDR QXEA200603053Seat Track · corrodedC2 PDX - LEFT OUTBOARD SEAT TRACK NR 2 HAS A PIT IN THE BOTTOM FROM THE CHANNEL AT X293. REPAIRED IAW RD8/4-53-884.
Back to JASC 5347