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 KCSA071208Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 200, RBL 48.SDR KCSA071207Seat Track · crackedMAIN DECK SEAT TRACK CRACKED AT BS 900, RBL 33.SDR QXEA200701127Seat Track · corrodedC4 PDX - NR 7 SEAT TRACK HAS PITTING CORROSION AROUND TIE DOWN FASTENER AROUND STATION 222. REPAIRED IAW RD8/4-53-4473 AND RD8/4-53-1102.SDR AWXA200700864Seat Track · corrodedSAL - MAJOR REPAIR - BC-6 CHECK - NR 5948791, CORROSION ON CABIN SEAT TRACK, BS 1590/FR 36 + 1" AND BS 1753/FR 40 + 14" , -Y1292. REPLACED CABIN SEAT TRACK, BS 1590/FR 36 - BS 1810/FR 41, -Y1292 IAW A320 SRM 51-72-11.SDR AWXA200700862Seat Track · corrodedSAL - MAJOR REPAIR - CORROSION ON CABIN SEAT TRACK, BS 1590/FR 36 + 1", -Y765. REPLACED CABIN SEAT TRACK, BS 1590/FR 36 - BS 1810/FR 41, -Y765 IAW A320 SRM 51-72-11.SDR CALA0700345Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1460-1535, LBL 74. THE SEAT TRACK WAS REPAIRED IAW SRM 53-00-52, REPAIR 3, FIGURE 202.SDR 07FDEA02408Seat Track · corrodedAFT UPPER MAIN DECK, CORROSION ON LWR O/B FLANGE OF SEAT TRACK STA 950 10" TO 950B 10" RBL 47". REMOVED CORROSION REF SRM 51-10-6 AFTER BLEND. ORIGINAL MATERIAL "T" .081 AFTER BLEND MATERIAL REMAINING .052 FOR A MATERIAL LOSS OF .029 AND WAS OUT OF LIMITS REFSDR SIMA200719714Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 28 TO 36. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719713Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 19 TO 23. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719718Seat Track · corrodedLEFT FORWARD INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 18 TO 23. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719717Seat Track · corrodedRIGHT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 47 TO 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719716Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 23 TO 28. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719712Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 28 TO 36. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719710Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 TO 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719724Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 23 TO 28. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719723Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 47 TO 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719722Seat Track · corrodedRIGHT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 24 TO 28. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719721Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 47 TO 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719720Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 TO 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719719Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 47 TO 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719711Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 23 TO 28. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719715Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 TO 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200720607Seat Track · corrodedSEAT TRACK AT BL18.3L FOUND CORRODED. REMOVED AND REPLACED SEAT TRACK IAW SAAB AMM 53-70-60. AIRCRAFT RETURNED TO SERVICE.SDR QXEA200701128Seat Track · corrodedC4 PDX - NR 4 SEAT TRACK AT STATION 242 HAS PITTING CORROSION ON FLANGE AND VERTICAL SIDE OF RAIL. REPAIRED IW RD8/4-53-4698 AND RD8/4-53-1102.SDR AWXA200700824Seat Track · corrodedSAL - MAJOR REPAIR - BC-6 CHECK - NR 5971950, CORROSION ON CABIN SEAT TRACK, FR 36/BS 1430 - FR 41/1650, +Y765. REPLACED CABIN SEAT TRACK, FR 36/BS 1430 - FR 41/1650, +Y765 IAW A319 SRM 51-72-11.SDR TRAX200700951Seat Track · corrodedCORROSION ON RT SIDE CABIN FLOOR RAIL FS 349.00 TO 485.00.SDR ASAA0781857Cargo Track · corrodedAFT CARGO RT CARGO TRACK IS CORRODED BETWEEN STA 1148 AND 1155. REMOVED DAMAGED SECTION OF CARGO TRACK, LOCATED, DRILLED AND INSTALLED A REPLACEMENT TRACK SECTION IAW SRM 51-30-1 PG 13 AND 51-30-5 PG 3.SDR HNAA0700217Seat Track · corrodedRIGHT SEAT TRACK AT STA 222.7000 AND 242.200 SURFACE CORROSION. RIGHT SEAT TRACK REPLACED BY NEW PART AND INSTALLED WITH SOLID RIVETS AS PER SRM 51-40-00 AND DEFLECTOR REPLACED BY NEW PART AND INSTALLED WITH SOLID RIVETS IAW SRM 51-40-00.SDR CPCP20070083Seat Track · corrodedFOUND FRAME 36-39 LT SEAT TRACK CORRODED. NOW LT SEAT TRACK BETWEEN FRAME 36-39 REPLACED IAW SRM 51-25-04.SDR SIMA200719709Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 23 TO 36. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719707Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 47 TO 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719708Seat Track · corrodedRIGHT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 53 TO 55. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719706Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 TO 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719705Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 23 TO 36. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719416Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 17 TO 23. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719414Seat Track · corrodedLEFT OUTBORAD SEAT TRACK CORRODED BETWEEN FRAMES 53 TO 55. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD - RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719420Seat Track · corrodedRIGHT INBORAD SEAT TRACK CORRODED BETWEEN FRAMES 36 TO 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719415Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 TO 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719413Seat Track · corrodedRIGHT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 47 TO 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719419Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 23 TO 36. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719418Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 TO 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICESDR SIMA200719417Seat Track · corrodedLEFT OUTBORAD SEAT TRACK CORRODED BETWEEN FRAMES 47 TO 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR HNAA0700219Seat Track · corrodedCARGO FLOOR SEAT TRACK RAIL TO BE CLEANED AND PRIMED. LEFT I/B AFT SEAT RAIL REPLACED AND INSTALLED WITH SOILD RIVETS IAW DRAWING AND SRM 51-40-00.SDR ASAA0781848Seat Track · corrodedCABIN SEAT TRACK CORRODED. REMOVED DAMAGED AREA OF TRACK, LOCATED, DRILLED AND INSTALLED A REPLACEMENT SECTION IAW SRM 53-05 FIG 4A PG 8C AND 8D.SDR SIMA200720608Seat Track · corrodedSEAT TRACK AT BL36.0R FOUND CORRODED. REMOVED AND REPLACED SEAT TRACK IAW SAAB AMM 51-40-21, 51-40-22 AND 51-40-25. AIRCRAFT RETURNED TO SERVICE.SDR SWIA200718646Seat Track · corrodedPAX SEAT TRACK HAS SURFACE CORROSION IN SEVERAL PLACES, FOUND AT C-CHECK. REPLACED CORRODED SEAT TRACKS WITH SERVICABLE TRACK.SDR SWIA200718645Seat Track · wornCO-PILOT SEAT TRACKS HAVE ELONGATED HOLES AND ARE WORN, FOUND AT C-CHECK. REPLACED COPILOT SEAT TRACK PER CRJ200 SRM 51-42-21 PG 19.SDR SWIA200718644Seat Track · wornPILOT SEAT TRACKS HAVE ELONGATED HOLES AND ARE WORN, FOUND AT C-CHECK. REPLACED PILOT SEAT TRACK PER CRJ200 SRM 51-42-21 PG 17-19.SDR SWIA200718642Seat Track · corrodedRIGHT SIDE SEAT RAIL HAS SURFACE CORROSION AT STA 484 TO 499. FOUND AT C-CHECK, REPLACED CORRODED SEAT TRACK SECTIONS AT RT OTBD FS 444.02 TO 495.98 PER REO 601R 53-00-055 AND CRJ200 AMM 53-01-11-420-001.SDR UPS07M50440Seat Track · corrodedINSPECTION TYPE:C CABIN - CORROSION ON SEAT TRACK AT STA 1966 X=107. AFFECTED AREA CORROSION REMOVED & REPROTECTED SRM 51-21-01VII R38. CROWN AREA ORG THK 0.145" MATL REMAIN 0.045" MATL REMV 0.100". FLANGE AREA ORG THK 0.080" MATL REMAIN 0.048" MATL REMV 0.
Back to JASC 5347