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 UPS98227569Seat Track · corrosionINSPECTION TYPE:SI CORROSION ON SEAT TRACK UPPER AND LOWER FLANGES STA 1070-1130 RBL 45 WL 208. REMOVED CORRODED SEAT TRACK, FABRICATED NEW SEAT TRACK AND INSTALLED IAW SRM 51-30-2, 53-10-5.SDR QXEA9801322Seat Track · corrodedCORROSION IN BOTTOM OF SEAT TRACK RIGHT-HAND OUTBOARD SEAT TRACK IN CABIN FRAME 6305 TO 6805. REPAIRED IAW FOKKER SRM 53-02-15.SDR CALA9801494Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 950A-950B, LBL 46. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS FABRICATED AND INSTALLED IAW SRM 51-30-2, 51-10-5, FIGURE 1, 51-10-2, AND MM 51-20-11.SDR CALA9801493Seat Track · corrodedINSPECTION FOUND RT OUTBOARD SEAT TRACK CORRODED AT STA 990-1030. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS FABRICATED AND INSTALLED IAW SRM 51-30-2, 53-10-5, 51-10-2, AND MM 51-20-11.SDR CALA9801492Seat Track · corrodedINSPECTION FOUND RT OUTBOARD SEAT TRACK CORRODED AT STA 950-950A. THE SEAT TRACK WAS REMOVED. A NEW SEAT TRACK WAS FABRICATED AND INSTALLED IAW SRM 53-10-5, FIGURE 1 AND 7, 51-30-2, 51-10-2, AND MM 51-20-0.SDR CALA9801490Seat Track · corrodedINSPECTION FOUND LT SEAT TRACK CORRODED AT STA 1050-1060. A NEW SEAT TRACK WAS FABRICATED AND INSTALLED IAW SRM 53-10-5, FIGURE 1.SDR C2XA98IA309Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT AFT 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 C2XA98IA307Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FORWARD FLOOR 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 C2XA98IA306Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FORWARD WALL 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 C2XA98IA305Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FORWARD FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA304Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FORWARD WALL 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 C2XA98IA303Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT AFT FLOOR 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 AALA981581Tie Down · corrodedTUL - CORROSION ON RT TIE DOWN TRACK, OUTBOARD FLANGE, STA 1212. REMOVED CORROSION. CUT-OUT DAMAGED AREA. INSTALLED FILLER AND STRAP REPAIR PER ESO 80559, DATED 8-20-98 AND SRM AARD 53-20-00-13. TST: 23,605.42 HOURS. CYCLES: 12,312. (X)SDR UPS98227540Seat Track · corrosionINSPECTION TYPE-SI, CORROSION ON EXPANSION LINK UPPER SEAT TRACK O/B FLANGE UNDER STRAP AFT OF BS 740 LBL 45 WL 208. REMOVED CORRODED SEAT TRACK, FABRICATED AND INSTALLED NEW SEAT TRACK IAW 51-30-2.SDR TWAA9813604Tie Down Track · corrodedDURING CHECK-C MAINT, FOUND IN AFT CARGO COMPT THE RT TIE DOWN TRACK, AFT OF CARGO DOOR, WITH CORROSION IN CHANNEL. REPLACED RT TIE DOWN TRACK AFT OF DOOR PER SRM 51-01, PAGE 4.SDR SIMA982311Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT AFT INBOARD AND OUTBOARD, AND THE RIGHT MIDDLE INBOARD AND OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACD BOTH LEFT AFT SEAT TRACKS. REPAIRED BOTH RIGHT MIDDLE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (MSDR TWAA9814505Seat Track · corrodedDURING CHECK-C, FOUND CORROSION ON NR 1 CHAIR TRACK, LBL 46 IN AT STA 1100. REMOVED CORRODED TRACK AND INSTALLED NEW TRACK AND FASTENERS PER SRM 53-10-5.SDR CALA9801481Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1136, RBL 25. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS FABRICATED AND INSTALLED IAW SRM 53-10-5, 51-30-5, 51-10-2, 51-30-2, AND MM 51-20-11.SDR UPS98827607Seat Track · corrodedINSPECTION TYPE C-CK, SEAT TRACK STA 1300 C TRACK HAS CORROSION. REMOVED DAMAGED AREA OF SEAT TRACK, SPLICED NEW TRACK IAW DC8 SRM 53-2-3.SDR UPS98227476Seat Track · corrodedINSPECTION TYPE-SI, CORROSION ON SEAT TRACK BS 655 TO 668, LBL 45, WL 208. REMOVED CORROSION FROM SEAT TRACK BS 668 TO 655, FOUND TO BE OUT OF LIMITS. REPLACED SEAT TRACK BS 480 TO 685, ALL WORK PERFORMED IAW SRM 51-10-06, 53-10-01, 51-30-02, 53-10-05.SDR CALA9801459Seat Track · corrodedINSPECTION FOUND FORWARD END OF LT INBOARD SEAT TRACK CORRODED AT STA 344 TO 384. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS FABRICATED AND INSTALLED IAW SRM 53-10-5, 51-10-2, 51-30-2, AND MM 51-20-0.SDR SCNA98712Seat Track · brokenDURING A HEAVY MAINT CHECK, A SEAT TRACK WAS FOUND BROKEN APPROX 4 INCHES LONG ON I/B SIDE OF TRACK AT STATION 720A WL 208 LBL 46. CUT OUT SEAT TRACK IAW SRM B727 531005. FABRICATED NEW SEAT TRACK IAW SRM PER B727 531005 FROM EXTRUSTION BAC 1520 792. TREATESDR QXEA9801316Seat Track · corrodedRIGHT-HAND INBOARD SEAT TRACK REQUIRES REPLACEMENT FROM STATION 5305 TO 8805 DUE TO NUMEROUS CORROSION ON TRACK. INSTALLED NEW SEAT TRACK SPLICE SECTION IAW FOKKER SRM 53-02-15, FIGURE 1, SHEET 2.SDR VJ9800392Seat Track · corrodedLT O/B SEAT TRACK CHANNEL AND PRIOR SPLICE FASTENERS BETWEEN STA 945 TO 965 IN CABIN FOUND TO BE CORRODED. REMOVED SECTION OF SEAT TRACK CHANNEL FROM STA 945 TO 965 LT, FOUND TO BE OUT OF LIMITS IAW DC-9 SRM 53-01 FIG 1. CLEANED SUB FLOOR AND FLOORBEAM IAW SSDR SIMA982231Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LEFT AFT INBOARD AND THE FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED BOTH SEATS TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR QXEA9801323Seat Track · corrodedCORROSION IN BEGINNING OF RIGHT-HAND OUTBOARD SEAT TRACK IN CABIN APPROXIMATELY .15 DIAMETER, .02 DEEP AT FRAME 4610. REPAIRED IAW FOKKER SRM 51-31-01.SDR 98ZZZM627Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LEFT AFT INBOARD AND THE FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED BOTH SEATS TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR EISA98237Seat Track · corrodedDURING ACCOMPLISHMENT OF C-ROUTINE INSPECTION, FOUND CORROSION ON SEAT TRACK STATION 344 TO 480 RBL 44. REMOVED AND REPLACED SEAT TRACK PER SRM 53-10-1. (M)SDR EISA98235Seat Track · corrodedDURING ACCOMPLISHMENT OF C-CHECK ROUTINE INSPECTION CARD, FOUND CORROSION ON SEAT TRACK STATION 560 RBL 44. REMOVED AND REPLACED DAMAGED AREA OF SEAT RACK PER SRM 53-10-5. (M)SDR EISA98234Seat Track · corrodedDURING ACCOMPLISHMENT OF C-CHECK ROUTINE INSPECTION, FOUND CORROSION ON SEAT TRACK STATION 837 RBL 24. REMOVED AND REPLACED DAMAGED AREA OF SEAT TRACK PER SRM 53-10-5. (M)SDR EISA98233Seat Track · corrodedDURING ACCOMPLISHMENT OF C-CHECK ROUTINE INSPECTION, FOUND CORROSION ON SEAT TRACK STATION 400 RBL 23. REMOVED SEAT TRACK FABRICATED NEW ONE PER SRM 53-10-5. (M)SDR EISA98230Seat Track · corrodedDURING ACCOMPLISHMENT OF C-CHECK ROUTINE INSPECTION CARD, FOUND CORROSION SEAT TRACK STATION 640 AND RBL 44. REMOVED AND REPLACED SEAT TRACK PER SRM 53-10-5. (M)SDR EISA98225Seat Track · corrodedDURING ACCOMPLISHMENT OF C-CHECK ROUTINE INSPECTION, FOUND CORROSION ON SEAT TRACK AT STATION 1050 LBL 25. REMOVED AND REPLACED SEAT TRACK PER SRM 53-10-5. (M)SDR CALA9801435Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT BS 380-420, RBL 24. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS FABRICATED AND INSTALLED IAW SRM 53-10-5 AND 51-10-5.SDR CALA9801431Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 824, RBL 70. THE CORRODED AREA WAS TRIMMED AND BLENDED OUT. STRAP AND FILLER WERE USED TO REINFORCE THE AREA IAW SRM 53-70-00, FIGURE 18.SDR UPS98827619Seat Track · corrosionINSPECTION TYPE C-CK, MAIN CABIN STA 879 TO 1080 SEAT TRACK A HAS CORROSION. REMOVED CORROSION IAW DC8 SRM 51-1-8. NOT WITHIN LIMITS IAW DC8 SRM 53-2-3. REMOVED DAMAGED SECTION OF SEAT TRACK STA 590 TO 1030, DRILLED NEW SECTION IAW DC8 SRM 51-1-4. ALODINEDSDR UPS98227560Track · crackedINSPECTION TYPE-D, CARGO TRACK SECTION BS 1010 RT SIDE HAS SIZEABLE CRACK. RT FWD TRACK REPLACED IAW SRM 51-30-2.SDR AALA981490Seat Track · corrodedTUL - FOUND SEAT TRACK HAS CORROSION AT FRAME 14. REMOVED AND REPLACED SEAT TRACK NR 7 FROM FRAME 11-15 PER SRM 51-72-10 AND SRM 51-21-00. (M)SDR UPS98827618Seat Track · corrodedINSPECTION TYPE C-CK, MAIN CABIN STA 130 TO 220 SEAT TRACK B HAS CORROSION. REMOVED CORRODED SECTION OF TRACK B STA 50 TO 220. TRIMMED, LOCATED, DRILLED NEW SECTION IAW DC8 SRM 53-2-3 & 51-1-24. ALODINED AND PRIMED TRACK AND AREA IAW DC8 SRM 51-1-8. INSTALSDR UPS98827584Seat Track · corrodedINSPECTION TYPE-C CK, SEAT TRACK NR C AT POSITION NR 3 HAS CORROSION. REMOVED AND REPLACED SEAT TRACK IAW DC 8 SRM 51-3-0.SDR UPS98227536Seat Track · corrodedINSPECTION TYPE-SI, CORROSION BETWEEN SEAT TRACK AND EXPANSION LINK FLANGES AT BS 850 RBL 25 WL 208. REPLACED SEAT TRACK AND EXPANSION LINK AS PER SRM 51-30-5.SDR SIMA982181Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FORWARD OUTBOARD AND RIGHT MIDDLE SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR CALA9801401Seat Track · corrodedINSPECTION FOUND CORROSION AT INBOARD AND OUTBOARD LEGS OF SEAT TRACK AT BS 1030-1120, LBL 45. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-2.SDR C2XA98IA298Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND THE RIGHT LOWER AFT SEAT TRACK WAS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW THE EMB120ER A/C MM 53-01-05. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA297Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND THE LEFT AFT LOWER SEAT TRACK HAD CORROSION. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB120ER A/C MM 53-01-05. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR 98ZZZM605Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FORWARD OUTBOARD AND RIGHT MIDDLE SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM604Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FORWARD OUTBOARD AND RIGHT MIDDLE SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM603Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FORWARD OUTBOARD AND RIGHT MIDDLE SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM602Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FORWARD OUTBOARD AND RIGHT MIDDLE SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM601Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FORWARD OUTBOARD AND RIGHT MIDDLE SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)
Back to JASC 5347