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 9618661151Seat Track · corrodedDURING T-CHECK, FOUND CORROSION ON THE RBL 75 SEAT TRACK AT FS 1841. REPAIRED TRACK (P/N S 4929147) PER EA 11-106212.SDR 96ZZZM1350Seat Track · corrodedMCI - DURING OP-16, FOUND CORROSION AT RIGHT FLOOR TRACK, STATION 1311 TO STATION 1320. REMOVED AND REPLACED FLOOR TRACK PER SRM 51-01 AND TWA STANDARD PRACTICES. (M)SDR 96ZZZM1346Seat Track · corrodedMCI - DURING OP-16, FOUND CORROSION AT FLOOR TRACK, STATION 1211 TO 1320, RIGHT SIDE. REPLACED FLOOR TRACK PER SRM 51-01, PAGE 1 AND TWA STANDARD PRACTICES. (M)SDR 96ZZZM1342Seat Track · corrodedMCI - DURING OP-16, FOUND CORROSION AT LBL 44 CHAIR TRACK FLANGE, FS 1212, 1250, 1257, 1296. REPLACED PART PER SRM 51-10-01 AND TWA STANDARD PRACTICES. (M)SDR 9618646309Seat Track · corrodedDURING P-CHECK, FOUND CORROSION ON THE LBL 41 SEAT TRACK FROM BS 980 - 1000. REPAIRED TRACK (P/N 140U5617-13) PER EA 63-101910.SDR W8PA960111Floor Track · corrodedAFT CARGO BAY RIGHT FLOOR TRACK HAS CORROSION AT BS 942 AND BS 945, RBL 14 (OUT OF LIMITS PER SRM 53-60-53). REMOVED DAMAGED TRACK, FABRICATED, INSTALLED REPAIR PARTS IAW SRM 53-00-53. (M)SDR 96ZZZX4205Track · corrodedAFT CARGO BAY, RIGHT FLOOR TRACK, HAS COROSION AT BS 942 AND BS 945, RBL 14 (OUT OF LIMITS PER SRM 53-60-53). REMOVED DAMAGED TRACK, FABRICATED, INSTALLED REPAIR PARTS IAW SRM 53-00-53.SDR DHL9672109CSeat Track · crackedAT C-CHECK, FOUND NR 6 SEAT TRACK RBL 45 HAS CORROSION AND CRACKED AT STA 600 THROUGH 660. REMOVED AND REPLACED SEAT TRACK PER SRM 51-30-2, 60 INCHES LONG.SDR AALA961166Seat Track · corrodedTUL - CORROSION AND GOUGE ON NR 1 SEAT TRACK. ACCOMPLISHED SEAT TRACK PLUG REPAIR. TST: 23,096.48 HOURS. CYCLES: 13,154. (X)SDR UPS96220809Seat Track · corrodedINSPECTION TYPE SI, CORROSION IN SEAT TRACK RBL 62 STA 360 TO 380 WL 208. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS PER SRM 51-10-1. REMOVED AND REPLACED SEAT TRACK AT RBL 62 STA 360 TO 380 WL 208 IAW SRM 51-3-5, 51-20-151, 51-30-2.SDR AWXA960387Seat Track · corrodedDURING ROUTINE SCHEDULED C-8 MAINTENANCE CHECK, FOUND CORROSION ON SEAT TRACK FLANGE BS 347, LB 25, WL 208. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-30-2. (M)SDR AWXA96034Seat Track · corrodedPAE - DURING ROUTINE SCHEDULED C-8 MAINTENANCE CHECK, FOUND CORROSION IN SEAT TRACK WELL BS 337, RBL 45, WL 208. REMOVED AND REPLACED SEAT TRACK FROM BS 328 TO 380, RBL 45, WL208. (M)SDR AALA961164Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 8. REMOVED DAMAGED SECTION OF TRACK AND SPLICE IN NEW SECTION PER ESO 7399 AND DATED 8-1-96. (M)SDR UPS96220790Seat Track · corrodedINSPECTION TYPE SI, CORROSION ON SEAT TRACK FLANGE LBL 1 INCH STA 490 TO 502 WL 207.8. REMOVED CORROSION, REWORK DEEMED OUT OF LIMITS IAW SRM 53-10-1. REMOVED AND REPLACED SECTION OF SEAT TRACK FROM STA 490 TO 550 BL 0 TRACK IAW TRAMCO EWO 96-2419.SDR UPS96220786Seat Track · corrodedINSPECTION TYPE SI, CORROSION UNDER NUTPLATE ON SEAT TRACK FLANGE I/B RBL 25 STA 668 WL 207.8. MECHANICALLY REMOVED CORROSION, REWORK DEEMED OUT OF LIMITS IAW SRM 53-10-1. ALSO, FOUND CORROSION OUT OF LIMITS FROM STA 480 TO 690 RBL 25 SEAT TRACK. REMOVED ANSDR C2XA96IA181Seat 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 RETURNED TO SERVICE. (M)SDR AWXA960381Seat Track · corrodedPAE - FLT 7848 - DURING ROUTINE SCHEDULED C-16 MAINTENANCE CHECK, FOUND CORROSION ON SEAT TRACK AT STATION 328-344, RBL 45, WL 208. REMOVED, FABRICATED AND INSTALLED PER SRM 51-10-1, 51-21-41. (M)SDR C2XA96IA177Seat 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 RETURNED TO SERVICE. (M)SDR C2XA96IA176Seat 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 RETURNED TO SERVICE. (M)SDR C2XA96IA175Seat 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 WAS RETURNED TO SERVICE. (M)SDR UPS96220743Seat Track · crackedINSPECTION TYPE-C, SEAT TRACK AT BS 740 TO 760 LBL 44.5 IS CORRODED AND CRACKED. REMOVED AND REPAIRED TRACK PER SRM 51-30-2.SDR CKSA96078Seat Track · corrodedSPLP - FLT NR 74558: DURING C AND AOS INSPECTION WORK CARD 010-10, FOUND CARGO COMPARTMENT FLOOR NR 1 TRACK RIGHT SIDE STA 580 HAS LEVEL 2 CORROSION. INSTALLED TRACK AT AFFECTED AREA AS PER SRM 53-2-3.SDR CKSA96077Seat Track · corrodedSPLP - FLT NR 74558: DURING C AND AOS INSPECTION WORK CARD 006-4, FOUND CENTER TRACK, STA 1420 THROUGH STA 1400, HAS LEVEL 2 CORROSION. REMOVED AND REPLACED TRACK AT AFFECTED AREA PER SRM 53-2-3.SDR CKSA96076Seat Track · corrodedSPLP - FLT 74558: DURING C AND AOS INSPECTION WORK CARD NR 006-4: FOUND RT TRACK NR 1, STA 1580, HAS LEVEL 2 CORROSION. INSTALLED TRACK AT AFFECTED AREA PER SRM 53-2-3.SDR UPS96220730Seat Track · corrodedINSPECTION TYPE SI, CORROSION IN SEAT TRACK LBL 25 STA 786 TO 848 WL 208. MECHANICALLY REMOVED CORROSION, REWORK DEEMED OUT LIMITS IAW SRM 53-10-1. REMOVED AND REPLACED SEAT TRACK FROM STA 786 TO 848 LBL 25 IAW 51-30-2, 53-10-5.SDR ABXA9700121Seat Track · corrodedDURING C-CHECK AND COMPLIANCE WITH AD 92-22-08, FOUND SEAT TRACK EXFOLIATED STATION 216 TO 235. BLENDED IAW DC-9 SRM 51-10-3.SDR DHL9671511DSeat Track · corrodedAT D-CHECK, CABIN SEAT TRACK 31 HAS CORROSION STA 759 - STA 848. REMOVED SEAT TRACK AND REPLACED FROM STA 740 - STA 848 PER SRM 51-10-1.SDR AWXA960356Seat Track · corrodedPAE - FLT 7809 - DURING ROUTINE SCHEDULED C-5 MAINTENANCE CHECK, FOUND CORROSION ON SEAT TRACK -1292, Z-540, FR 20. REMOVED AND REPLACED SEAT TRACK AT Y-1292, Z-540, FR 20 TO FR 24 PER SRM 51-72-11 AND 51-42-21. (M)SDR P5CA9600594Seat Track · corrodedCORROSION AT MAIN DECK TIE DOWN (SEAT) TRACK INBD FLANGE FROM STA 2200 TO STA 2220 LBL11. CORROSION REMOVED AND RE-PROTECTED PER BAC SRM 51-10-01 AND 51-10-02.SDR P5CA9600564Seat Track · corrodedLEVEL 1 CORROSION AT MAIN DECK TIE DOWN (SEAT) TRACK STA 2182 LBL 98. CORROSION REMOVED AND RE-PROTECTED PER BAC SRM 51-10-01 AND SRM 51-10-02.SDR P5CA9600555Tie Down Track · corrodedLEVEL 1 CORROSION MAIN DECK BS 1670 RBL 98 TIE DOWN TRACK OUTBOARD FLANGE. REMOVED CORROSION AND TREATED PER BOEING SRM 51-10-01 AND 51-10-02.SDR P5CA9600534Seat Track · corrodedLEVEL 1 CORROSION MAIN DECK RBL 98 SEAT TRACK OUTBOARD FLANGE BETWEEN BS 640 AND 645. REMOVED CORROSION AND TREATED PER BOEING SRM 51-10-01 AND 51-10-02.SDR P5CA9600519Tie Down Track · corrodedLEVEL 1 COROSION BS 862, RBL 98 TIE DOWN TRACK OUTBOARD. REMOVED CORROSION AND TREATED PER BOEING SRM 51-10-01 AND 51-10-02.SDR RAIA960725Seat Track · corrodedFOUND LEFT AND RIGHT SEAT TRACK HAS CORROSION AT FRAME 34 AND 36 TO 39. REPLACE SEAT TRACK IN EFFECTED AREA AS PER SRM. (M)SDR DHL9671510DSeat Track · corrodedAT D-CHECK, SEAT TRACK CORRODED AT STA 640 - STA 740. REMOVED AND REPLACED SEAT TRACK PER SRM 51-10-1, 7 FEET BY 4 INCHES .SDR DHL9671509DSeat Track · corrodedAT D-CHECK, SEAT TRACK CORRODED STA 600 - STA 650. REPLACED SEAT TRACK PER SRM 51-10-1.SDR DHL9671544DSeat Track · corrodedAT D-CHECK, CABIN FLOOR SEAT TRACK HAS CORROSION UPPER SURFACE BETWEEN STA 761-784 BELOW RIGHT FWD OVERWING EXIT. REMOVED AND REPLACED SEAT TRACK PER SRM 51-30-2 .SDR UPS96220937Seat Track · corrodedINSPECTION TYPE-C, LT SEAT TRACK AT STA 1160 LT HAS HEAVY CORROSION, AFT LWR CARGO. REMOVED AND REPLACED SEAT TRACK (P/N 65-22797-5) PER SRM 51-30-2 AND 51-10-01.SDR AWXA960359Seat Track · corrodedPAE - FLT 7820 - DURING ROUTINE SCHEDULED C-9 MAINTENANCE CHECK, FOUND CORROSION ON SEAT TRACK OF BS 987 TO 1016, WL 208, RBL 38. REMOVED AND FABRICATED AND INSTALLED SEAT TRACK PER SRM 53-10-1. (M)SDR CA960801502Spring · fouled(CAN) CAPTAINS SEAT SHIFTED AFT ON TAKEOFF. SEAT TRACK WAS FOUND DIRTY AND THE SPRING WAS FOULED. THIS INCIDENT WAS SUBJECT OF BRAD SERVICE ADVISORY #96 03 15006 WHICH COINCIDENTALLY WAS RECEIVED SAME DAY INCIDENT HAPPENED.SDR C2XA96IA166Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT SIDE WALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PORTION OF SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA165Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT LOWER FORWARD SEAT TRACK WAS FOUND TO BE CORRODED. MX REMOVED AND REPLACED THE AFFECTED PORTION OF SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA164Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT LOWER AFT SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PORTION OF SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA163Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT UPPER FORWARD SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PORTION OF SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA162Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT LOWER 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 C2XA96IA161Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT AFT LOWER 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 C2XA96IA160Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT UPPER SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PORTION OF SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR 96ZZZM1196Seat Track · corrodedSTL - DURING OP-19, FOUND CORROSION ON LEFT INBOARD SEAT TRACK, STATION 200-206. REPLACED SEAT TRACK PER SRM 53-03, PAGE 10G, SHEET 1, FIGURE 4F. (M)SDR AALA961004Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK STATION 1110 TO 1130 LEFT OUTBOARD. REPLACED SEAT TRACK, LEFT OUTBOARD STATION 1110 TO 1130. (M)SDR AALA961001Seat Track · corrodedTUL - FOUND STATION 420 TO 460, RIGHT SIDE OF CABIN 40 INCHES SHORT SECTION OF SEAT TRACK CORRODING INSIDE CHANNEL, ENTIRE LENGTH. REMOVED AND DELECTED SEAT TRACK FROM STATION 420 TO 460 RT PER SRM 53-10-2 PG 44. (M)
Back to JASC 5347