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 QXEA0200791Seat Track · corrodedPDX- NR 10 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES AT STATION X327 - X330. REPAIRED IAW RD-8 53-1342.SDR QXEA0200790Seat Track · corrodedPDX- NR 10 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES AT STATION X310 - X313. REPAIRED IAW RD-8 53-1342.SDR QXEA0200789Seat Track · corrodedPDX- NR 10 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES AT STATION X295 - X298. REPAIRED IAW RD-8 53-1342.SDR QXEA0200788Seat Track · corrodedPDX- NR 10 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES AT STATION X278 - X280.5. REPAIRED IAW RD -8 53-1342.SDR QXEA0200787Seat Track · corrodedPDX- NR 10 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES AT STATION X265 - X268. REPAIRED IAW RD-8 53-1342.SDR QXEA0200784Seat Track · corrodedPDX- NR 8 SEAT TRACK IS CORRODED ON UPPER SURFACE AT STATION X514.5 - X516. REPAIRED IAW RD-8 53-4473, RD-8 53-4472 AND SRM 51-40-11.SDR QXEA0200783Seat Track · corrodedPDX- NR 8 SEAT TRACK IS CORRODED ON UPPER SURFACE AT STATION X484 - X486. REPAIRED IAW RD-8 53-4473, RD-8 53-4472 AND SRM 51-40-11.SDR QXEA0200777Seat Track · corrodedPDX- NR 10 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES AT STATION X422 - X424. REPAIRED IAW RD-8 53-1342.SDR QXEA0200776Seat Track · corrodedPDX- NR 10 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES AT STATION X405 - X408. REPAIRED IAW RD-8 53-1342.SDR QXEA0200771Seat Track · corrodedPDX- NR 1 SEAT TRACK CORRODED ON INNER SURFACES AT STATION X404 - X406. REPAIRED IAW RD-8 53-1342.SDR QXEA0200770Seat Track · corrodedPDX- NR 1 SEAT TRACK IS CORRODED ON INNER SURFACES. REPAIRED IAW RD-8 53-1342.SDR QXEA0200769Seat Track · corrodedPDX- NR 1 SEAT TRACK IS CORRODED ON INNER SURFACE AT STATION X362.5. REPAIRED IAW RD-8 53-1342.SDR QXEA0200768Seat Track · gougedPDX- NR 1 SEAT TRACK HAS DEEP GOUGES. REPAIRED IAW RD-8 53-1342.SDR QXEA0200767Seat Track · corrodedPDX- NR 1 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES AT STATIONS X295 - X298. REPAIRED IAW RD-8 53-1342.SDR QXEA0200766Seat Track · corrodedPDX- NR 1 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES AT STATION X277 - X281. REPAIRED IAW RD-8 53-1342.SDR QXEA0200765Seat Track · corrodedPDX- NR 1 SEAT TRACK CORRODED ON INNER SURFACE AT STATION X271 - X273. REPAIRED IAW RD-8 53-1342.SDR QXEA0200795Seat Track · corrodedPDX- NR 10 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES AT STATION X391-X394. REPAIRED IAW RD-8 53-1342, SRM 51-40-00 AND SRM 51-40-11.SDR QXEA0200793Seat Track · corrodedPDX- NR 10 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES AT STATION X360 - X363. REPAIRED IAW RD-8 53-1342, SRM 51-40-00 AND SRM 51-40-11.SDR QXEA0200792Seat Track · corrodedPDX- NR 10 SEAT TRACK CORRODED ON UPPER AND INNER SURFACES STATION X341 - X343. REPAIRED IAW RD-8 53-1342, SRM 51-40-00 AND SRM 51-40-11.SDR AALA20020673Seat Track · corrodedNR 1 CORRODED AT 1176, 1208 AND 1236. REPLACED SEAT TRACK, STA 1174 - 1309.SDR UPS02838131Seat Track · corrodedINSPECTION TYPE:C2 NR 1 SEAT TRACK AT STA 46 IS CORRODED. REPLACED SECTION OF SEAT TRACK WITH SPLICE IAW EO DC8-5320-5167.SDR AALA20020614Seat Track · corrodedTUL - FOUND CORROSION ON NR 2 SEAT TRACK INBOARD FLANGE AT CLIP NUTS STATION 1190-1205. BLENDED CORROSION PER SRM 53-01. INSTALLED DOUBLER STRAP PER AARD 53-22-00-13. (M)SDR SIMA200212138Seat Track · corrodedSAW - DURING CPCP2, FOUND LEFT AND RIGHT FLIGHT ATTENDANTS SEAT TRACKS TO BE CORRODED. REMOVED AND REPLACED SEAT TRACKS IAW EO E2-53MR-115RA. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR CALA0200244Cargo Track · corrodedINSPECTION FOUND RT TIE DOWN RAIL CORRODED ON UPPER SIDE FRONT IN AFT BAGGAGE BIN AT STA 807-840. A NEW TIE DOWN RAIL WAS INSTALLED IAW SRM 53-00-53, PAGE 204-205.SDR GTIA020443Cargo Track · corrodedFTW - FOUND AFT CARGO TRACK RIGHT FORWARD 'Z' ANGLE GOUGED AND TRACK HAS CORROSION. CORROSION FOUND TO BE OUT OF LIMITS. FABRICATED TRACK. INSTALLED CARGO TRACK. (M)SDR C1HA200283015Seat Track · corrodedSEAT TRACK LBL 45 IS CORRODED AT STA 1093.SDR C1HA200283014Seat Track · corrodedSEAT TRACK RBL 45 IS CORRODED AT STA 1100.SDR C1HA200283013Seat Track · corrodedSEAT TRACK RBL 24 IS CORRODED AT STA 1100.SDR C1HA200283012Seat Track · corrodedSEAT TRACK LBL 45 IS CORRODED STA 344-380.SDR C1HA200283010Seat Track · corrodedSEAT TRACK RBL 45 IS CORRODED AT STA 380-400.SDR C1HA200283009Seat Track · corrodedSEAT TRACK RBL 45 IS CORRODED AT STA 448-453.SDR SWIA200210845Seat Track · corrodedLT AFT-MOST SEAT TRACK SECTION CORRODED IN AREAS AS MARKED. REMOVED AND REPLACED PASSENGER SEAT TRACK LT AFT. NO OTHER DEFECTS NOTED.SDR AALA20020671Seat Track · damagedTUL - FOUND NR 3 SEAT TRACK INBOARD FLANGE HAS ELONGATED HOLES AT STATION 833 AND 828. NR 3 SEAT TRACK INBOARD FLANGE HAS ELONGATED HOLES AT 846, 851, 856, AND 860. REPAIRED PER AARD 53-20-00-13. (M)SDR AALA20020664Seat Track · corrodedTUL - FOUND NR 5 SEAT TRACK CORRODED AT STATION 200. REMOVED CORRODED TRACK. INSTALLED NEW TRACK NR 5 PER SRM 53-05. (M)SDR 2002F00595Seat Track · crackedAT C-CHECK, FOUND LEFT SEAT TRACK CRACKED APPROXIMATELY .325 INCHES LONG AT STATION 1137 BL 46L. (M)SDR QXEA0200729Seat Track · corrodedPDX- NR 7 SEAT TRACK HAS INTERGRANULAR CORROSION IN SEVERAL PLATES. REPAIRED IAW DHC-8 RD8-53-1102, SRM 20-09-06, PG 201 AND HORIZON AIR EA 2-53-389.SDR AALA20020610Seat Track · corrodedTUL - FOUND NR 5 SEAT TRACK HAS EXFOLIATED CORROSION BETWEEN STATION 200-207. REPLACED SEAT TRACK NR 5 FROM STATION 200-245 AS PER SRM 53-05 SHEET 1. (M)SDR UPS02838363Seat Track · brokenINSPECTION TYPE:C13 CABIN (CARGO) SEAT TRACK AT RBL 25 BS 55 HAS BROKEN LOBES. BLENDED SEAT TRACK OUT OF LIMITS IAW DC8 SRM 53-2-3, FABBED SEAT TRACK IAW DC8 SRM 53-2-3 A&P IAW DC8 SRM 51-1-8. INSTALLED NEW TRACK AND FLOORBOARDS IAW DC8 SRM 51-3-0.SDR UPS02438215Seat Track · corrodedINSPECTION TYPE:C U/D - BS 630-640, LBL 46 SEAT TRACK CROWN FOUND CORRODED AS MARKED. CORROSION REMOVED IAW SRM 51-10-01. BLEND OUT NOT WITHIN SRM 53-10-01 FIG 1 LIMITS. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS02438177Seat Track · corrodedINSPECTION TYPE:C U/D - BS 540-600 AND 610-640 LBL 66, SEAT TRACK CROWN AND FLANGE FOUND CORROSION. BS 540-600 AND 610-640 LBL 66, SEAT TRACK CROWN AND FLANGE REPAIRED AS PER SRM 51-10-01. (P/N: BAC1520-1567-717876511RK).SDR CALA0200234Seat Track · corrodedINSPECTION FOUND L/H O/B SEAT TRACK HAD PITTING CORROSION AT STA 727-767. A SEAT TRACK REPAIR WAS INSTALLED IAW SRM 53-00-52, FIGURE 204.SDR UPS02438152Seat Track · crackedINSPECTION TYPE:C M/ D- BS 2160 RBL 98 SEAT TRACK CRACK. SEAT TRACK REPLACED AS PER SRM 51-10-01 PG 8, P/N (BAC1520-1545-7178T6511RK).SDR CALA0200227Seat Track · corrodedINSPECTION FOUND R/H SEAT TRACK HAD PITTING CORROSION AT STA 847-907. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 53-00-52.SDR AAL2002F00026Seat Track · corrodedHEAVY CORROSION IN NR 3 SEAT TRACK, STA 1294. CUT OUT CORRODED AREA, INSTALLED REPAIR PLUG IAW SRM.SDR AALA20020661Seat Track · corrodedTUL - FOUND CORROSION ON TOP OF NR 2 SEAT TRACK, STATION 1300. CUT OUT CORRODED AREA. INSTALLED REPAIR PLUG PER SRM 53-05, FIG 4A. (M)SDR AALA20020659Seat Track · corrodedTUL - FOUND CORROSION ON TOP AND INSIDE OF NR 2 SEAT TRACK, STATION 1200. CUT OUT CORRODED AREA, INSTALLED REPAIR PLUG PER SRM 53-05, FIG 4A. (M)SDR UPS02438168Seat Track · chafedINSPECTION TYPE:C M/D - BS 900 AND 940-960 RBL 33 SEAT TRACK CROWN FOUND CHAFING MARK AS MARKED. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A. (P/N: BAC1520-1566-7178T6511RK)SDR UPS02438244Seat Track · corrodedINSPECTION TYPE:C M/D - BS 870 - 880 RBL 11 SEAT TRACK RT FLANGE FOUND CORROSION. CORROSION REMOVED IAW SRM 51-10-01. BLEND OUT NOT WITHIN SRM 53-10-01 LIMITS. M/D BS 870 - 1000 RBL 11 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR AWXA200200367Seat Track · corrodedYWG - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND FROM FR 16 TO FR 20, Y-1292 RT ON FLOOR SUPPORT SEAT TRACK. MAINTENANCE REMOVED CORRODED FLOOR SUPPORT SEAT TRACK FROM FR 16 TO FR 24, FABRICATED A NEW FLOOR SUPPORT SEAT TRACK PER DWG D53112782, AND ISDR UPS02438072Seat Track · crackedINSPECTION TYPE:MX FWD LOWER CARGO COMPARTMENT AFT END VERTICAL RESTRAINT ATTACH STRUCTURE O/B LEFT SIDE HAS LARGE AMOUNT OF CORROSION ON SEAT TRACK. SEAT TRACK IS ALSO CRACKED. REMOVED DAMAGED SECTION OF SEAT TRACK IAW SRM 53-10-05 FIG 5. FABBED NEW SECTIO
Back to JASC 5347