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 C2XA97IA130Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FORWARD SIDE WALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA129Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FORWARD SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA128Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FORWARD SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA125Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT SIDE WALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA124Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT AFT SIDEWALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA123Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT AFT FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR UPS97222457Seat Track · corrodedINSPECTION TYPE-SI, CORROSION ON SEAT TRACK AROUND NUT PLATE HOLES BS 870 TO 1020 LBL 65 WL 208. CORROSION REMOVAL OUT OF LIMITS. REMOVED SEAT TRACK SECTION FROM BS 8870 TO 1020 LBL 65 WL 208, FABRICATED NEW SECTION, INSTALLED ALL WORK IAW SRM 51-30-2, 51-30SDR C2XA97IA116Anchor · corrodedIAH - DURING C-CHECK INSPECTION, THE FLIGHT ATTENDANTS SEAT ANCHORS WERE FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT ANCHORS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR CALA9700606Seat Track · damagedDAMAGED SEAT TRACK FS 495 TO 520 LBL 8.5. FABRICATED AND INSTALLED SEAT TRACK IN ACCORDANCE WITH SRM 53-70-00 FIG 1, 53-42-01, 51-31-01, AND EA 2520-03222.SDR 97ZZZX4572Seat Track · brokenDURING A-CHECK, FOUND SEAT TRACK BROKEN AT STA 1810 TO STA 1850 ON MAIN CARGO DECK AND FLOOR FITTING DAMAGED. FLOOR FITTING REPLACED AND SEAT TRACK REPLACED PER SRM 53-10-05, FIG 33, SHEET 4.SDR UPS97822648Seat Track · corrodedINSPECTION TYPE:D, AFT LWR CARGO SEAT TRACK AT BL 0 HAS SEVERAL CORRODED FASTENER HOLES, BETWEEN STA 1000 AND 1020. REMOVED, FABRICATED, AND INSTALLED REPLACEMENT SECTION OF TRACK IAW SRM 53-3-0, 53-7-3, 53-2-3.SDR UPS97822597Seat Track · corrodedINSPECTION TYPE-D, SEAT TRACK CORRODED FROM FS 980 TO 1540 RBL 59. REMOVED, FABRICATED AND INSTALLED REPLACEMENT SECTION OF SEAT TRACK FROM FS 980 TO 1580 IAW SRM ADDEN DC8-5320-5167, SRM 53-3-0 AND 51-1-21. ALSO, WORK DONE ON N/R 610139.SDR UPS97822559Cargo Track · corrodedINSPECTION TYPE-D, AFT LOWER CARGO SEAT TRACK AT LBL 26 STA 1220 IS CORRODED. REMOVED, FABRICATED AND INSTALLED REPLACEMENT TRACK IAW SRM ADDEN DC8-5320-5167-C, SRM 51-3-0 AND 53-7-3 FROM FS 1190 TO 1350.SDR AALA970654Seat Track · corrodedTUL - SEAT TRACK NR 6 BLENDED BEYOND LIMITS. INSTALLED PLUG REPAIR PER SRM 53-05 FIG 4A-1. TST: 21,944.47. CYCLES 11,837. (X)SDR AALA970326Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK STATION 200 TO 222, NR 2 SEAT TRACK. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK. (M)SDR MZZA97062Seat Track · corrodedKUL - LP NR 826612 - FLOOR STRUCTURE UNDER FORWARD LAV HAS EVIDENCE OF TOILET FLUID LEAKAGE. FABRICATED SEAT TRACK, TREATED BY ALODINE AND PRIMED PER SRM 53-10-2/51-10-2. FLOOR AREA UNDER LAV CLEANED. (X)SDR MZZA97060Seat Track · corrodedKUL - SEAT TRACK BADLY CORRODED AT RBL 24.75, STATION 400 IN AREA OF FORWARD GALLEY FLOOR, IG CORROSION APPROX 1 INCH DIAMETER. FABRICATED DAMAGED SEAT TRACK, TREATED BY ALODINE AND PRIMED IAW SRM 53-10-2. (M)SDR 97ZZZX1706Mount Bracket · brokenDURING SCHEDULED MAINTENANCE, PASSENGER SEAT AFT FACING BEHIND COPILOT, WRITTEN UP AS 'LOOSE IN TRACK'. DISCOVERED FRONT FLOOR MOUNTED BRACKET CRACKED AND TORN FROM SEAT FRAME. SUSPECT CAUSE, SEAT BACK USED AS LEVERAGE INTO COCKPIT: ALSO, AIRCRAFT TYPE CERTSDR UPS97822560Seat Track · corrosionINSPECTION TYPE-D, STA 55 RBL 44 THE SEAT TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED AND INSTALLED SECTION OF TRACK FS 50 TO 130 IAW SRM 53-2-3 FIG 6, AND 51-01-20.SDR CKSA97141Seat Track · corrodedDURING CPCP CHECK INSPECTION, FOUND LEVEL 2 CORROSION FS 834 RBL 45 SEAT TRACK. REMOVED SEAT TRACK, FOUND FLOORBEAM CORRODED. REMOVED CORROSION FOUND OUT OF LIMITS IAW 53-2-0. INSTALLED DOUBLER IAW AIA SKETCH AIA/E/2483 REV A. REMOVED AND REPLACED SEAT TRASDR AALA970613Tie Down Track · corrodedTUL - AFT CARGO RIGHT REAR TIE DOWN TRACK CORRODED. REMOVED AND REPLACED TRACK. (M)SDR AALA970612Seat Track · corrodedAFW - SEAT TRACK AT STATION 377 LBL 45 HAD CORROSION BLENDED BEYOND SRM LIMITS E58 NR 1668871. REPAIRED PER MRB NR 757-1108. (M)SDR UPS97222443Seat Track · corrodedINSPECTION TYPE-SI, CORROSION ON SEAT TRACK FROM STA 760 TO 850 LBL 25 WL 208 (MARKED). REMOVED AND REPLACED SEAT TRACK FROM 760 TO 850 LBL 25 WL 208 IAW SRM 51-30-2, 53-10-5, 51-30-8 AND 53 -10-1.SDR UPS97222444Seat Track · corrodedINSPECTION TYPE-SI, CORROSION ON SEAT TRACK BS 344 LBL 65 WL 208. REMOVED AND REPLACED SEAT TRACK STA 344 LBL 65 WL 208 IAW SRM 51-30-5, 51-30-8, 51-10-2, 51-30-2 AND 53-10-1.SDR TWAA9752011Floor Track · crackedDURING SPECIAL CHECK, FOUND A SIX INCH CRACK IN FORWARD CARGO COMPARTMENT FLOOR TRACK, STA 980, RBL 25. REPAIRED TRACK PER SRM 53-10-05, PAGE 4, FIGURE 2. AIRCRAFT TOTAL TIME: 62,400 HOURS; 23,718 CYCLES. (X)SDR ABXA9700065Seat Track · wornDURING C-CHECK INSPECTION, FOUND UPPER CARGO COMPARTMENT SEAT TRACKS LOBES WORN BEYOND LIMITS. INSERT REPAIR INSTALLED IAW ABX EA 53470018.SDR UPS97222503Seat Track · corrodedINSPECTION TYPE-SI, SEAT TRACK CORRODED STA 420 TO 440 LBL 25 WL 207 ON FLANGE. CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REPLACED TRACK SECTION BS 380 TO 448 WITH NEW ITEM PER SRM 51-10-2, 53-10-1, 51-30-2.SDR UPS97222501Seat Track · corrodedINSPECTION TYPE-S, SEAT TRACK STA 485 TO 490 RBL 25 HAS CORROSION ON FLANGE WL 207. CORROSION OUT OF LIMITS PER SRM 53-10-1. REMOVED AREA OF DAMAGE AND SPLICED IN NEW SECTION OF TRACK PER MM 51-20-151, SRM 51-30-2, 53-10-5, 51-20-10.SDR UPS97222500Seat Track · corrodedINSPECTION TYP-SI, SEAT TRACK CORRODED STA 380 TO 440 LBL 45 WL 207. CORROSION OUT OF LIMITS PER SRM 53-10-1. REPLACED TRACK STA 330 TO 440 LBL 45 WITH NEW ITEM PER SRM 53-10-1, 51-30-3, 51-30-2.SDR UPS97222446Seat Track · corrodedINSPECTION TYPE-SI, SEAT TRACK STA 720B + 10 HAS CORROSION ON FLANGE LBL 25 WL 207. SEAT TRACK FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REPLACED AFFECTED SECTION OF SEAT TRACK WITH NEW ITEM PER SRM 53-10-5, 57-10-2.SDR TWAA9809313Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CENTER SEAT TRACK CORRODED AT STA 200 TO STA 218. REPLACED DAMAGED TRACK SECTION PER SRM 51-01, ITEM 7, AND SRM 53-05, PG 10. (X)SDR TWAA9808815Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CENTER FLOOR TRACK WITH CORROSION AT STATION 218 TO 237. REPLACED DAMAGED TRACK SECTION PER SRM 51-01, PAGE 1 ITEM C, AND SRM 53-05 PAGE 10. (M)SDR TWAA9743005Seat Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON CENTER FLOOR TRACK, STA 218 TO STA 237. REPLACED FLOOR TRACK PER SRM 51-01, PAGE 1, ITEM C, AND SRM 53-05, PAGE 10. AIRCRAFT TOTAL TIME: 43,165 HOURS; 22,408 CYCLES. (X)SDR TWAA9743004Seat Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON CENTER SEAT TRACK, STA 200 TO STA 218. REPLACED SEAT TRACK PER SRM 51-01, ITEM 7, AND SRM 53-05, PAGE 10, 6G. AIRCRAFT TOTAL TIME: 43,165 HOURS; 22,408 CYCLES. (X)SDR MWEA97189Seat Track · corrodedDURING INSPECTION, FS 230 SEAT TRACK NR 4 BLENDED BEYOND LIMIT. MANIT INSTALLED PLUG REPAIR IAW SRM 53-05 FIG 4A.SDR MWEA97147Seat Track · corrodedDURING INSPECTION, STA 210 NR 3 SEAT TRACK CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED IAW SRM 53-05 FIG 4F.SDR MWEA97137Seat Track · corrodedDURING INSPECTION, NR 1 SEAT TRACK HAS MODERATE CORROSION FROM STA 200 TO 260. MAINTENANCE SPLICED NEW SECTION IAW SRM 53-05 FIG 4F.SDR MWEA97136Seat Track · corrodedDURING INSPECTION, FOUND MODERATE CORROSION IN SEAT TRACK NR 4 FROM STA 200 TO 237. MAINTENANCE REPAIRED, SPLICING A SECTION OF SEAT TRACK IAW SRM 53-05 FIG 4F.SDR UPS97222498Seat Track · corrodedINSPECTION TYPE-SI, CORROSION IN HOLE ON SEAT TRACK BS 691 WL 208 RBL 45. CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REMOVED DAMAGED PORTION OF SEAT TRACK AND INSTALLED NEW IAW SRM 53-10-5, 51-20-21, 51-30-1.SDR EISA97070Seat Track · corrodedSEAT TRACK 3 LEFT CORRODED AT FS 348.2. REMOVED AND REPLACED SEAT TRACK FORM FS 340 TO 360 PER SRM 53-10-05. (M)SDR C2XA97IA112Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT OUTBOARD SEAT TRACK WAS FOUND TO BE CORRODED BETWEEN FRAMES 32 AND 36. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA110Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FLIGHT ATTENDANT SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA109Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT AFT FLIGHT ATTENDANT SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR UPS97222619Seat Track · corrodedINSPECTION TYPE-SI, CORROSION ON SEAT TRACK FROM STA 600 TO 620 LBL 0. REMOVED CORRODED SECTION OF SEAT TRACK PROCURED NEW SECTION OF SEAT TRACK AND INSTALLED IAW SRM 51-30-2.SDR UPS97222445Seat Track · corrodedINSPECTION TYPE-SI, CORROSION ON SEAT TRACK BS 364 LBL 65 WL 208. SEAT TRACK SECTION REMOVED AND REPLACED WITH NEW SECTION IAW SRM 51-30-2, 51-30-5, 51-30-8.SDR TWAA9809411Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CHAIR TRACK LBL 22 INCHES FROM FS 1307 TO FS 1251, OTBD FLANGE CORRODED. REPLACED TRACK STR 1155 TO STR 1307 PER SRM 51-01, PAGE 1 ITEM C. (X)SDR TWAA9809317Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND RANDOM CORROSION IN NR 1 SEAT TRACK AT FS 549 TO FS 605. CORROSION REMOVED AND PAINTED AREA PER SRM 51-10-03. (X)SDR TWAA9809316Floor Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND IN C3 CARGO COMPT FLOOR TRACK CORRODED AT FS 1220 TO FS 1238 AT SCREW FLANGES. REPLACED LT FLOOR TRACK FS 1220 TO FS 1320, PER SRM 51-01. (X)SDR TWAA9809314Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CORROSION IN NR 1 SEAT TRACK AT LOCATIONS FS 477 TO FS 539. CORROSION REMOVED PER SRM 53-10-03, AND PAINTED. (X)SDR PCAA9700357Seat Track · corrodedDURING A SCHEDULED C-CHECK, THE LEFT INBOARD CABIN SEAT RAIL WAS DISCOVERED TO BE CORRODED UNDER THE WARDROBE. REMOVED LEFT INBOARD SEAT RAIL P/N 85320490, AT STATION X232.5 - 182 AND SPLICED IN NEW SEAT RAIL SECTION IAW RD8-53-1932. A/C RETURNED TO SERVICE.
Back to JASC 5347