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 AALA960999Stop · corrodedTUL - FOUND STATION 420 RIGHT SIDE OF CABIN SEAT TRACK STOP BLOCK CORRODED ON INBOARD AND OUTBOARD FLANGES IN FRONT OF THE SHORT 40 INCHES SECTION OF SEAT TRACK JUST INBOARD OF CREASE ANGLE. REMOVED AND DELETED SEAT TRACK STOP BLOCK PER SRM 53-10-2 PG 44N (A)SDR AALA960998Seat Track · corrodedTUL - FOUND STATION 360 RBL 55 SEAT TRACK CORRODED ON INBOARD FLANGE TOP SIDE. INSTALLED NEW SEAT TRACK FROM STATION 344-380, RT RBL 55. (M)SDR AALA960995Seat Track · corrodedTUL - FOUND STATION 344, RIGHT INBOARD SEAT TRACK HAS CORROSION AT ATTACH POINT TO FLOOR BEAM UPPER FLANGE OF TRACK, INBOARD AND OUTBOARD SIDES. REMOVED CORRODED SECTION. SPLICED IN NEW SECTION SRM 53-10-5, FIG 7. (M)SDR UPS96820767Seat Track · corrosionINSPECTION TYPE-CS2, CORROSION OUT OF LIMITS ON SEAT TRACK NR 5, FS 1707. REPLACED SEAT TRACK SECTION FS 1670 TO 1707 PER SRM 53-2-3.SDR UPS96220639Cargo Track · corrodedINSPECTION TYPE-C, CORROSION ON LEFT CARGO TRACK, STA 517 LWR CARGO COMPT. REMOVED AND REPLACED TRACK PER SRM 51-30-2 (P/N 65-23410-4).SDR 9615349305Track · corrodedDURING H-CHECK, FOUND CORROSION ON THE FORWARD CARGO TIE DOWN TRACK, LEFT SIDE, FS 408 - 427. REPAIRED TRACK (P/N 5936594-521N) PER EA 93-105343.SDR C2XA96IA153Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT INBOARD SEAT TRACK WAS FOUND TO BE CORRODED FROM FRAME 33 TO FRAME 36. MAINTENANCE REMOVED THE DAMAGED SECTION OF SEAT TRACK AND REPLACED IT WITH A SERVICEABLE SECTION, REFERENCE ATR SRM 53-00-00 AND THE AIRCRAFT WASSDR AALA960943Seat Track · corrodedTUL - THREE AREAS OF CORROSION ON SEAT TRACK A ON TOP FLANGE. REMOVED AND REPLACED SEAT TRACK PER SRM 51-72-10-0. TST: 21,904 HOURS. CYCLES, 8,714. (X)SDR AALA960941Seat Track · corrodedTUL - SEAT TRACK 3 HAS CORROSION ON INBOARD FLANGE. REMOVED AND REPLACED SEAT TRACK PER SRM 51-72-10-0. TST: 21,904 HOURS. CYCLES: 8,714. (X)SDR AALA960927Track · corrodedTUL - FOUND CORROSION ON AFT CARGO TIE DOWN TRACK (RT AFT SIDE TRACK). BLENDED CORROSION (SRM 51-10-03). FOUND TO BE OUT OF LIMITS. INSTALLED NEW TIE DOWN TRACK. (M)SDR DHL9670601CSeat Track · corrodedAT C-CHECK, FOUND SEAT TRACK CORRODED AT STA 700 TO 740 AT LBL 45. REMOVED AND REPLACED TRACK PER SRM 51-10-5.SDR AALA960923Seat Track · corrodedTUL - SEAT TRACK NR 8 HAS CORROSION ON INBOARD FLANGE. REPLACED SEAT TRACK PER AARD 51-10-00-3, AND NSTALLED PER SRM 51-72-10-0. TST: 21,904 HOURS. CYCLES, 8,714. (X)SDR AALA960922Seat Track · corrodedTUL - SEAT TRACK NR 9 HAS CORROSION IN CHANNEL. REPLACED SEAT TRACK PER AARD 51-10-00-3 AND INSTALLED PER SRM 51-72-10-0. TST: 21,904 HOURS. CYCLES, 8,714. (X)SDR UPS96220489Seat Track · corrodedINSPECTION TYPE: C. STA 1130-1136, RBL 62 SEAT TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED, AND INSTALLED SEAT TRACK PER SRM 51-10-01 AND 51-30-02.SDR AALA960916Track · corrodedTUL - FOUND CORROSION IN TIE DOWN TRACK NR 2 AT FS 1200 AND FS 1300. REMOVED AND REPLACED TRACK FROM STATION 1180-1307 PER SRM 53-05 FIG 4. (M)SDR UPS96220505Seat Track · corrodedINSPECTION TYPE: C. CORROSION ON SEAT TRACK IN 3 AREAS THAT ARE OUT OF LIMITS AT STR 378, LBL 45.5. REMOVED AND REPLACED SEAT TRACK FROM STA 344-390 IAW SRM 53-10-5 AND 51-30-2.SDR UPS96220503Seat Track · corrodedINSPECTION TYPE: C. MAIN CABIN SEAT TRACK STA 552, RBL 62 TRACK WAS FOUND BEYOND LIMITS DUE TO CORROSION REMOVAL. REMOVED DAMAGED SECTION OF SEAT TRACK AND INSTALLED NEW SECTION IAW SRM 53-10-5 FIG 1 AND 51-30-2.SDR UPS96220445Seat Track · corrodedINSPECTION TYPE SI, CORROSION ON SEAT TRACK AT BS 520 RBL 15 WL 150. REMOVED AND REPLACED SEAT TRACK FROM 480 TO 530 RBL 15 WL 15 IAW SRM 53-10-05.SDR DHL9672136CSeat Track · corrodedAT C-CHECK, FOUND SEAT TRACK CORRODED AT BS 720B TO 720C AT RBL 48. REPLACED SEAT TRACK PER SRM 51-10-1.SDR AALA960912Seat Tracks · corrodedTUL - FOUND NR 5 SEAT TRACK CORRODED FORWARD END OUTBOARD SIDE. REPLACED NR 5 SEAT TRACK STATION 207 TO STATION 246. INSTALLED SPLICE AT STATION 246 IAW SRM 53-05 FIG 4F. TREATED AND PRIMED AREAS AS REQUIRED. (M)SDR COMA9610210Seat Track · corrodedDURING 2C INSPECTION, FOUND SEAT TRACKS FOR RIGHT HAND SIDE PASSENGERS SEATS TO BE CORRODED. REMOVED CORRODED SEAT TRACKS AND REPLACED WITH SERVICEABLE TRACKS.SDR COMA9610206Track · corrodedDURING 2C INSPECTION, FOUND GALLEY FLOOR ATTACHMENT TRACK TO BE CORRODED. REMOVED CORRODED TRACK AND REPLACED WITH A SERVICEABLE TRACK.SDR COMA9610204Seat Track · corrodedDURING 2C INSPECTION, FOUND SEAT TRACKS FOR LEFT HAND SIDE PASSENGER SEATS TO BE CORRODED. REMOVED CORRODED SEAT TRACKS AND REPLACED WITH SERVICEABLE TRACKS.SDR UPS96220461Seat Track · corrodedINSPECTION TYPE SI, CORROSION ON SEAT TRACK TOP AND BOTTOM OF FLANGES STA 1090 TO 1130 LBL 55 WL 208. FOUND CORROSION OUT OF LIMITS PER SRM 53-10-01, REMOVED AND REPLACED SEAT TRACK IAW SRM 51-10-2, 51-30-02 AND 51-30-05.SDR C2XA96IA145Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FLIGHT ATTENDANT SEAT TRACK WAS FOUND TO BE CORRODED. MX REMOVED AND REPLACED THE RIGHT SEAT TRACK AND THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 96ZZZM1157Seat Track · corrodedFOUND LEVEL 2 CORROSION, AFT PASSENGER COMPARTMENT SEAT TRACK AT LEFT BL 73 STATION 1746 HAS CORROSION. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PER SRM 53-21-00.SDR DHL9672199CSeat Track · wornAT C-CHECK, NR 6 SEAT TRACK AT STA 950D RBL 45 WORN. REPLACED SEAT TRACK PER SRM 51-10-1.SDR DHL9672157CSeat Track · crackedAT C-CHECK, NR 5 SEAT TRACK RBL 25 AT STA 720C CRACKED AT CENTER BETWEEN ATTACHING FASTENERS. REPLACED TRACK PER SRM 51-10-1.SDR DHL9672156CSeat Track · wornAT C-CHECK, NR 3 SEAT TRACK LBL 25 LOCKING HOLES ELONGATED. REMOVED AND REPLACED TRACK BS 480 TO 590 AND INSTALLED SPLICE BETWEEN 480 TO 600 AT LBL 25, 11 LONG. INSTALLED STRAP 9 BY 3 PER SRM 53-10-5.SDR DHL9672155CSeat Track · wornAT C-CHECK, NR 5 SEAT TRACK RBL 25 LOCKING HOLES ELONGATED AT STA 602. REMOVED AND REPLACED SEAT TRACK BS 550 TO BS 690 PER SRM 51-30-2.SDR DHL9672154CSeat Track · crackedAT C-CHECK, NR 6 SEAT TRACK CRACKED FROM RBL 45 AT STA 540 TO 542. REMOVED AND REPLACED SEAT TRACK BS 480 TO 700 PER SRM 51-30-2.SDR DHL9672150CSeat Track · wornAT C-CHECK, FOUND NR 6 SEAT TRACK WORN FROM BS 480 TO 700 RBL 45. REMOVED AND REPLACED TRACK PER SRM 51-10-1.SDR DHL9672110CSeat Track · crackedAT C-CHECK, FOUND NR 5 SEAT TRACK RBL 25 AT STA 600 CENTER CRACKED BETWEEN ATTACH FASTENERS. REMOVED AND REPLACED SEAT TRACK FROM STA 550 TO 690 PER SRM 51-30-2.SDR DHL72160CSeat Track · wornAT C-CHECK, LOCK HOLES WERE ELONGATED ON NR 2 SEAT TRACK LBL 45 STA 848. REMOVED AND REPLACED TRACK PER SRM 51-10-1.SDR DHL9672189Seat Track · corrosionAT C-CHECK, SEAT TRACK CORRODED IN SEVERAL PLACES AT LBL 46 AT BS 1110 AND 1130. REMOVED SEAT TRACK AND INSTALLED NEW TRACK PER SRM 51-10-1.SDR DHL9672151CSeat Track · corrodedAT C-CHECK, FOUND CORROSION AT BS 720A O/B SEAT TRACK ON TOP FLANGE AROUND FASTENER HOLES. REPLACED SEAT TRACK PER SRM 51-10-1.SDR DHL9672147CSeat Track · corrodedAT C-CHECK, FOUND CORROSION ON SEAT TRACK FLANGE BS 340 TO 380 LBL 59. FABRICATED AND INSTALLED NEW SEAT TRACK 116 PER SRM 51-10-1.SDR DHL9672141CSeat Track · corrodedAT C-CHECK, FOUND CORROSION ON SEAT TRACK BS 680 TO 700 RBL 24. REMOVED SEAT TRACK FROM STA 550 TO 690, REMOVED CORROSION FROM SEAT TRACK 690 TO 700, WITHIN LIMITS. REPLACED TRACK FROM 550 TO 690 PER SRM 51-10-1.SDR DHL9672138CSeat Track · corrodedAT C-CHECK, FOUND CORROSION AROUND HOLES IN SEAT TRACK BS 680 OUTBD RIGHT TRACK. REMOVED AND REPLACED SEAT TRACK BS 480 TO 700 PER SRM 51-30-2.SDR DHL9672137CSeat Track · corrodedAT C-CHECK, FOUND CORROSION ON SEAT TRACK FLANGE BS 340 TO 380 LBL 45. FABRICATED AND INSTALLED NEW SEAT TRACK PER SRM 51-10-1, 40 LONG.SDR DHL9672134CSeat Track · corrodedAT C-CHECK, FOUND CORROSION ON UPPER SURFACE OF SEAT TRACK FLANGE STA 1000 BL 58L. FABRICATED AND INSTALLED NEW SEAT TRACK 40 LONG PER SRM 51-10-1.SDR DHL9672118CSeat Track · corrodedAT C-CHECK, FOUND CORROSION ON SEAT TRACK FLANGE BS 680 TO 720A. REMOVED AND REPLACED FLOOR TRACK PER SRM 51-10-1.SDR DHL96721103Seat Track · corrodedAT C-CHECK, FOUND SEAT TRACK AT RBL 48 CORRODED AT STA 950C TO 950F. REPLACED TRACK PER SRM 51-10-1.SDR DHL9672123CSeat Track · corrodedAT C-CHECK, FOUND CABIN SEAT FLANGE FROM BS 857 TO BS 863 LBL 45 CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM 51-10-1, 20 LONG.SDR DHL9672191CSeat Track · corrodedAT C-CHECK, AFT CABIN FLOOR SEAT TRACK HEAVILY CORRODED AT LBL 25, BETWEEN BS 1110 AND 1130. REMOVED AND REPLACED SEAT TRACK 26 LONG PER SRM 51-10-1.SDR 96DHL72198CSeat Track · corrodedAT C-CHECK, SEAT TRACK BL 24 LT CORRODED STA 998 TO 1025. REMOVED AND REPLACED SEAT TRACK FROM STA 970 TO 1110 PER SRM 51-30-2.SDR 96DHL72195CSeat Track · corrodedAT C-CHECK, SEAT TRACK FLANGES CORRODED AT RBL 55 BETWEEN STA 1100 AND1130. REPLACED SEAT TRACK PER SRM 51-10-1.SDR 96DHK72194CSeat Track · crackedAT C-CHECK, FOUND INBD FLANGE OF SEAT TRACK HAS CORROSION CRACK BETWEEN STA 1110 AND 1130 AT RBL 46. FABRICATED AND INSTALLED NEW SEAT TRACK FROM BS 1010 TO BS 1130 PER SRM 51-10-1 AND 51-30-2.SDR C2XA961A134Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND PASSENGER LEFT AND RIGHT SEAT TRACKS TO HAVE CORROSION BEYOND LIMITS. MX REMOVED AND REPLACED SEAT TRACKS, FRAME 29 TO FRAME 39. (M)SDR USAA960594Seat Track · corrodedYYC - DURING FC-06 CHECK, FOUND LIGHT SURFACE ATTACK CORROSION AT SEAT TRACK, BL 600 RT, STA 16495 - STA 17845. INSTALLED NEW SEAT RAIL PER SRM 51-10-00 REPAIR BY PART REPLACEMENT. (X)
Back to JASC 5347