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 98ZZZM546Seat Track · corrodedDURING CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER FOUND THE RIGHT FORWARD OUTBOARD SEAT TRACK CORRODED IN SEVERAL AREAS. INSTALLED SEAT TRACK IAW ATR 42 SRM 51-25-04. CAUSE OF DAMAGE, ENVIRONMENTAL. (M)SDR 98ZZZM545Seat Track · corrodedDURING A CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER FOUND THE LEFT CENTER OUTBOARD SEAT TRACK CORRODED IN SEVERAL AREAS. INSTALLED SEAT TRACK IAW ATR 42 SRM 51-25-04. CAUSE OF DAMAGE, ENVIROMENTAL. (M)SDR 98ZZZM544Seat Track · corrodedDURING A CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER FOUND THE LEFT OUTBOARD SEAT TRACK, AFT CABIN CORRODED IN SEVERAL AREA. REMOVED AND INSTALLED SEAT TRACK IAW ATR 42 SRM 53-61-00. CAUSE OF DAMAGE, ENVIROMENTAL.SDR 98ZZZM543Seat Track · corrodedDURING A CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER FOUND THE RIGHT CENTER INBOARD SEAT TRACK CORRODED IN SEVERAL AREAS. REMOVED AND INSTALLED SEAT TRACK IAW ATR 42 SRM 51-25-04. CAUSE OF DAMAGE, ENVIROMENTAL.SDR MWEA98580Seat Tracks · wornTHE CAPTAINS ON FIRST OFFICERS LOWER OUTBOARD SEAT TRACK IS WORN. MAINTENANCE FABRICATED AND INSTALLED SEAT TRACKS.SDR CKSA98303Seat Track · brokenDURING ROUTINE B CHECK INSPECTION, FOUND P-1-1 SEAT TRACK BROKEN. REMOVED DAMAGED SECTION OF SEAT TRACK AND SPLICED IN NEW SECTION IAW DC-8 SRM CHAPTER 53-2-3. NON-ROUTINE TASK CARD NUMBER 23703.SDR CKSA98302Seat Track · wornDURING ROUTINE B CHECK INSPECTION, FOUND NR 2 SEAT TRACK STA 332 WORN. REMOVED DAMAGED SECTION OF SEAT TRACK, SPLICED IN NEW SECTION OF SEAT TRACK IAW DC-8 SRM 53-2-3. NON-ROUTINE TASK CARD NUMBER 23935.SDR CALA9800813Tie Down Rail · corrodedAFT CRGO BIN LEFT TIE DOWN RAIL STA 1007 TO 1220 CORRODED AT FASTENERS. REPLACED LEFT TIE DOWN RAIL PER SRM 51-30-5.SDR AALA980883Seat Track · corrodedTUL - TOP OF NR 7 SEAT TRACK FLANGE CORRODED STATION 1231 TO 1238. REPLACED UPPER HALF OF TRACK NR 7 FROM STATION 1231 TO 1238 PER SRM 51-72-10-0. (M)SDR AALA980884Rail · corrodedTUL - FOUND CORROSION ON FLOOR BOARD RAIL NR 8 BY R-1 DOOR STATION 1212, FRAME 15. SURFACE TREATED PER SRM 51-21-00-02. FABRICATED AND INSTALLED STRAP PER AARD 53-20-00-2. (M)SDR QXEA9800695Seat Track · damagedCO-PILOTS OUTBOARD SEAT TRACK OUTBOARD SIDE RAIL HAS AREAS OF SMALL NICKS. REPLACED SEAT RAIL.SDR SIMA981201Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS CORRODED. THE LEFT AFT INBOARD, LEFT AFT OUTBOARD, AND BOTH FLIGHT ATTENDANTS. MAINTENANCE REMOVED AND REPLACED ALL SEAT TRACKS IAW SRM 53-63-00. AIRCRAFT WAS RETURNED TO SERVICESDR MALA976458Seat Track · corrodedDURING C CHECK, FOUND CORROSION AT BOTH CENTER AISLE SEAT TRACK FLANGES BL.O AND BL 18.5 FROM STATION 294 AND STATION 339. MAINTENANCE REPAIRED BY REINFORCING REPAIR ANGLE IAW 72SDS1048.SDR 98ZZZX1966Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS CORRODED. THE LEFT AFT INBOARD, LEFT AFT OUTBOARD, AND BOTH FLIGHT ATTENDANTS. MAINTENANCE REMOVED AND REPLACED ALL SEAT TRACKS IAW SRM 53-63-00. AIRCRAFT WAS RETURNED TO SERVICESDR 98ZZZX1965Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS CORRODED. THE LEFT AFT INBOARD, LEFT AFT OUTBOARD, AND BOTH FLIGHT ATTENDANTS. MAINTENANCE REMOVED AND REPLACED ALL SEAT TRACKS IAW SRM 53-63-00. AIRCRAFT WAS RETURNED TO SERVICESDR 98ZZZX1964Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS CORRODED. THE LEFT AFT INBOARD, LEFT AFT OUTBOARD, AND BOTH FLIGHT ATTENDANTS. MAINTENANCE REMOVED AND REPLACED ALL SEAT TRACKS IAW SRM 53-63-00. AIRCRAFT WAS RETURNED TO SERVICESDR QXEA9800705Seat Track · corrodedCORROSION ON FLOOR SUPPORT BEAM FROM FORWARD OF INBOARD RIGHT SEAT TRACK TO FRAME 3820 ON UPPER SURFACE. REPAIRED IAW FOKKER SRM 51-31-01, PAGE 13.SDR QXEA9800697Seat Track · wornOUTBOARD PILOT SEAT TRACK WORN TO LIMITS. REPLACED OUTBOARD SEAT TRACK IAW FOKKER SRM 53-40-01, PAGE 201B, CODE 2.SDR QXEA9800696Seat Track · wornINBOARD PILOT SEAT TRACK IS WORN TO LIMITS. REPLACED SEAT TRACK IAW FOKKER SRM 53-40-01, PAGE 201.SDR CALA9800765Seat Track · corrodedCORROSION RIGHT OUTBOARD SEAT TRACK STA 208. FABRICATED NEW SEAT TRACK SPLICE AND INSTALLED PER SRM 53-05 FIG 4F.SDR C2XA98IA149Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FLIGHT ATTENDANTS SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW ATR42-320 SRM 51-25-02 AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA148Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE FLIGHT ATTENDANTS RIGHT SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW ATR 42-300 SRM 51-25-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR TWAA9807010Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK FOUND CORROSION ON RT OTBD GALLEY TRACK FROM STA 180 TO STA 237, 44 IN RBL. REPLACED SECTION OF TRACK PER SRM 51-01, PAGE 1 ITEM C, AND 51-30-0. (X)SDR 98ZZZX2996Seat Track · corrodedDURING A CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER, FOUND THE RT AFT OUTBOARD SEAT TRACK CORRODED FORWARD FRAME 35. REMOVED AND INSTALLED AFT OUTBOARD SEAT TRACK WITH NEW IAW ATR SRM 53-63-00. CAUSE OF DAMAGE: ENVIRONMENTAL, LAVATORY/GALLESDR 98ZZZX2995Seat Track · corrodedDURING A CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER, FOUND THE RIGHT F/A SEAT TRACK CORRODED AT FRAME 39. INSTALLED NEW SEAT TRACK IAW ATR SRM 51-25-04. CAUSE OF DAMAGE: ENVIRONMENTAL. AIRCRAFT TT: 18,688.4 HOURS/ TAC: 23,278.SDR 98ZZZX2555Seat Track · corrodedDURING A CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER, FOUND THE LEFT F/A SEAT TRACK CORRODED AT FRAME 39. INSTALLED NEW LEFT SEAT TRACK PER SRM 51-25-04. CAUSE OF DAMAGE: ENVIRONMENTAL. AIRCRAFT TT: 18,688.4 HOURS. TAC: 23,278.SDR 98ZZZX2554Seat Track · corrodedDURING A CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER, FOUND THE LAVATORY WALL SEAT TRACK BETWEEN FRAMES 39 AND 41 CLIP NUT HOLE CORRODED AFT AREA. INSTALLED SERVICEABLE SEAT TRACK BETWEEN FRAMES 39 AND 41 LAVATORY WALL IAW ATR 42 SRM 51-25-04.SDR 98ZZZX2551Seat Track · corrodedDURING A CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER, FOUND THE RIGHT AFT INBOARD SEAT TRACK CORRODED FORWARD OF FRAME 35. COMPLETE REPLACMENT OF RT AFT INBOARD SEAT TRACK BY COUNTERSINK HOLES, INSTALLED HILOCKS, AND RIVETS ON AFT SUPPORT BRACSDR 98ZZZX2548Seat Track · corrodedDURING A CPCP 4 INSPECTION, PERFORMED AT AMR EAGLE MAINTENANCE CENTER, FOUND FORWARD LEFT INBOARD SEAT TRACK FLOORBOARD CLIP HOLES CORRODED BETWEEN FRAMES 13 AND 16. INSTALLED SEAT TRACK PER SRM 51-21-04. CAUSE OF DAMAGE: ENVIRONMENTAL. AIRCRAFT TT: 18,68SDR CKSA98299Seat Track · corrodedDURING ROUTINE B CHECK INSPECTION, FOUND SEAT TRACK STA 490 RBL25 CORRODED. REMOVED AND REPLACED SEAT TRACK PER DC-8 SRM 53-02-3. NON ROUTINE TASK CARD NUMBER 23625.SDR RRXA99480Seat Track · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO SEAT TRACK A RIGHT TUNNEL AT STA 1100, X+59 TO +62, Z+1.1 TO +1.3. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED SPLICE AND DOUBLER IAW DSDR UPS98826568Cargo Track · crackedINSPECTION TYPE-C, FS 1320 ABOVE STR 33L CARGO TRACK HAS HEAVY CORROSION AND IS CRACKED AT FS 1260. REMOVED, FABRICATED AND INSTALLED REPLACEMENT TRACK IAW SRM 51-3-0 AND DWG 5759223.SDR DHL9870725CSeat Track · corrodedAT C-CHECK, CABIN SEAT TRACK CORRODED AT STA 540 LBL 24. CUT OUT DAMAGED SECTION, INSTALLED NEW TRACK PER SRM 53-10-5. N/R 5586SDR TWAA9806613Floor Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CORROSION ON FLOOR TRACK FROM STATION 180 TO 240, LBL 21 INCH. REMOVED CORRODED TRACK FROM STATION 180 TO 248. FABRICATED AND INSTALLED NEW TRACK PER SRM 53-01, PAGE 1 ITEM C. (M)SDR TWAA9806608Floor Track · wornMCI - DURING OP 16 MAINTENANCE CHECK AT RBL 8 INCH BS 269 HAS FLOOR TRACK WITH EXCESS METAL REMOVED BEYOND LIMITS TO CLEAN UP CORROSION. REPLACED SECTION OF TRACK PER SRM 53-05, PG 10G VIEW A. (M)SDR TWAA9806402Floor Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, RBL 8 IN SGTA 269 FOUND FLOOR TRACK WITH EXCESS METAL REMOVED BEYOND LIMITS TO CLEAN UP CORROSION. REPLACED SECTION OF TRACK PER SRM 53-05 PG 10G, VIEW A. ACFT TT: 70,506 HOURS. ACFT TC: 66,322. (X)SDR TWAA9806307Floor Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CORROSION ON FLOOR TRACK FROM STA 180 TO STA 240, 21 INCHES LBL. REMOVED CORRODED TRACK FROM STA 180 TO STA 248. FABRICATED AND INSTALLED NEW TRACK PER SRM 53-01, PG 1 ITEM C. ACFT TT: 70,506 HOURS. ACFT TC: 66SDR SIMA981113Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, MAINTENANCE REPORTED THE RIGHT MIDDLE OUTBOARD SEAT TRACK WAS DAMAGED AT SEAT MOUNTING SURFACE. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-25-04. AIRCRAFT WAS RETURNED TO SERVICE. (X)SDR AALA980822Roller Track · corrodedTUL - CORROSION DAMAGE FOUND ON ROLLER TRACK. REPLACED CARGO FLOOR ROLLER TRACK AT POSITION NR 1 BETWEEN FRAMES 54 AND 58. 53-10-15, PAGES 211 AND 212. TST: 27,077.37 HOURS. CYCLES: 10,835. (X)SDR UPS98826657Plug · corrodedINSPECTION TYPE:C, SEAT TRACK PLUG CORRODED STA 680 BL25R. REMOVED AND REPLACED PLUG IAW DC8 SRM 53 3 2, 51 3 0, 51 1 8.SDR UPS98826639Seat Track · corrodedINSPECTION TYPE:C/CK, CORROSION, SEAT TRACK E AT STA 1634 TO 1680. REMOVED DAMAGED SECTION, STA 1600 TO 1680. FABBED AND INSTALLED NEW SECTION IAW DC8 SRM 51 3 0 AND UPS EO DC8 5320 5167.SDR COMA9860086Seat Track · corrodedA 24 AND 48 MONTH INSPECTION. LEFT FORWARD FLOOR SEAT RAIL IS CORRODED FS 349 AND 409+32. REPLACED SEAT RAIL.SDR SIMA981083Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS CORRODED. THE LEFT FORWARD OUTBOARD, LEFT CENTER OUTBOARD, LEFT AFT INBOARD, LEFT AFT OUTBOARD, RIGHT CENTER OUTBOARD AND THE RIGHT FLIGHT ATTENDANT. MAINTENANCE REMOVED AND REPLASDR EISA98096Seat Track · corrodedDURING ACCOMPLISHMENT OF CPCP WORKCARD, FOUND SEAT TRACK CORRODED AT STA 737, 757, 775, 850, 870, 887, AND 908, RIGHT-HAND OUTBOARD TRACK. REPLACED RIGHT-HAND OUTBOARD TRACK FROM STA 737 TO STA 965 PER SRM 53-05. TT: 66,670:41 HOURS. TC: 61,562. (X)SDR EISA98095Seat Track · corrodedDURING ACCOMPLISHEMNT OF CPCP WORKCARD, FOUND CORROSION ON RIGHT-HAND INBD SEAT TRACK AT STA 690, 718, 737, 756, 813, 832, 870, AND 889. CORROSION REMOVED FROM STA 690 - STA 737 AND MATERIAL LOSS WITHIN SRM LIMITS 53-05, FIG 4. REPLACED SEAT TRACK FROM STA 7SDR UPS98826602Seat Track · corrodedINSPECTION TYPE:C/CK STA 55 TO 72 SEAT TRACK 11 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW DC8 SRM 53 7 3 AND DC8 SRM 51 1 8.SDR TWAA9806918Floor Track · corrodedMCI - DURING OP 15 MAINTENANCE CHECK, FOUND CORROSION ON RT FLOOR TRACK FROM FS 1212 TO 1322. REMOVED AND REPLACED TRACK PER SRM 51-01, PAGE 2 ITEM C, AND TWA STD PRACTICES. (M)SDR UPS98826607Seat Track · corrodedINSPECTION TYPE:C/CK FWD PIT STA 160 180 FLOOR POST SEAT TRACK AND SPLICES CORRODED. REMOVED CORROSION FROM POST AND SPLICES ALODINED AND PRIMED IAW DC8 SRM 51 1 8. REMOVED DAMAGED SEAT TRACK DRILLED AND INSTALLED NEW SECTION IAW DC8 SRM 51 1 8 AND 51 3 0 ANSDR TWAA9806604Floor Track · corrodedDURING OP 16 MAINTENANCE CHECK, FOUND FLOOR TRACK CORROSION AT FS 198 TO 237, RBL 21 TO 26. REMOVED CORROSION PER 51-10-3. REINSTALLED TRACK PER MM 53-40-1 PAGE 201. (M)SDR TWAA9806406Floor Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND FS 198 FLOOR TRACK WITH CORROSION RBL 21 TO RBL 26. REMOVED CORROSION PER 51-10-3. REINSTALLED TRACK PER MM 53-40-1 PG 201. ACFT TT: 70,506 HOURS. ACFT TC: 66,322. (X)
Back to JASC 5347