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 RAIA961261Seat Track · corrosionSTL - FOUND CORROSION ON RIGHT INBOARD SEAT TRACK AT FLOOR BEAM. MAINTENANCE REPLACED AFT SECTION OF RIGHT INBOARD SEAT TRACK FROM FLOOR BEAM 36 FORWARD IAW ATR 42 SRM 53-53-00. (M)SDR AWXA9600786Seat Track · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON SEAT TRACK STA 342 RBL 53 WL 208. REMOVED, FABRICATED AND INSTALLED SEAT TRACK IAW SRM 53-00-52, 51-40-02.SDR AWXA9600785Cargo Track · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND RT CARGO TRACK CORRODED FWD CARGO BAY BS 500A TO 500B. REMOVED CORRODED TRACK, FABRICATED AND DRILLED NEW TRACK PER SRM 51-40-01, INSTALLED TRACK PER SRM 51-40-02.SDR AWXA9600784Seat Track · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND BS 348 RBL 45 WL 208 SEAT TRACK CORRODED. REMOVED, FABRICATED AND INSTALLED SEAT TRACK IAW SRM 53-00-52, 51-40-02.SDR ABXA9700357Seat Track · corrodedDURING C-CHECK, THE SEAT TRACK AT STA 195RBL 44, WAS FOUND CORRODED. THE SEAT TRACK WAS REPAIRED IAW REA D953-17543-DE AND THE DC9 SRM. 51-30-1.SDR AALA961877Seat Track · corrodedTUL - CORROSION BEYOND LIMITS. SPLICED IN NEW SECTIONS OF SEAT TRACK PER SRM 53-70-00. (M)SDR AALA961876Seat Track · corrodedTUL - CORROSION IN THREE AREAS. SPLICED IN NEW SECTION OF TRACK PER SRM 53-70-00. (M)SDR TWAA9615822Seat Track · corrodedMCI - DURING CHECK C, FOUND CORROSION UNDER CLIP NUTS OF MAIN CABIN SEAT TRACK, LBL 45. REMOVED AND REPLACED SEAT TRACK PER SRM 51-30-2; SPLICED NEW SECTION PER SRM 53-05, FIGURE 4L. AIRCRAFT TOTAL TIME: 19,271 HOURS; 15,596 CYCLES. (X)SDR TWAA9615821Seat Track · corrodedMCI - DURING CHECK C, FOUND CORROSION ON MAIN CABIN SEAT TRACK SURFACE, LBL 45 TO LBL 22, STA 1106 - STA 1109. REMOVED CORRODED SEAT TRACK PER SRM 51-30-1, FABRICATED SPLICES PER SRM 53-05, FIGURE 4D; ALODINED AND PRIMED PER SRM 51-10-31 AND INSTALLED SEAT TSDR DLM11962763Seat Track · corrodedSEAT TRACK CORRODED IN SEVERAL PLACES BETWEEN FS 1305 AND 1361 RBL 75. REPAIRED PER SRM 53-70-00 MAJOR REPAIR.SDR DLM11962762Seat Track · corrodedSEAT TRACK CORRODED IN SEVERAL PLACES BETWEEN FS 1781 AND 1841 LBL 27. REPAIRED PER SRM 53-70-00 MAJOR REPAIR.SDR DLM11962761Seat Track · corrodedSEAT TRACK CORRODED IN SEVERAL PLACES BETWEEN FS 1771 AND 1861 RBL 27. REPAIRED PER SRM 53-70-00 MAJOR REPAIR.SDR AALA961883Tie Down Track · corrodedTUL - LEFT CARGO TIE-DOWN TRACK CORRODED FROM STA 1155 - STA 1300 AROUND CENTER FASTENERS AND HOLES. TREATED, PRIMED TIE-DOWN TRACK FROM STA 1155 TO STA 1222. REMOVED OUT OF LIMITS TRACK FROM STA 1222 TO STA 1322. INSTALLED NEW TIE-DOWN TRACK, LT CARGO FROM SDR AALA961875Seat Track · corrodedTUL - FOUND CORRODED SEAT TRACK. REPAIR TO SPECS PER SRM 53-70-00-0 VOL I PAGE 8 AND 9. (M)SDR TWAA9615716Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON AFT CARGO BIN RT AFT FLOOR TRACK, FS 1211 TO FS 3122. REPLACED TRACK PER SRM 51-5-00, PATE 1, ITEM C AND STANDARD PRACTICES. (M)SDR TWAA9615715Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON TOP OF FLOOR TRACK, LBL 56, STATION 1211. REMOVED CORROSION PER SRM 51-10-3, REPAIRED GALLEY TIE DOWN HOLE PER ARA 10750. (M)SDR ABXA9700369Guide Rail · gougedDURING C-CHECK, THE GUIDE RAIL AT STA 218 LBL 45, WAS FOUND GOUGED. THE GUIDE RAIL WAS REPLACED IAW DC-9 SRM.SDR CKSA96402Seat Track · corrodedDURING C-1 CHECK INSPECTION, FOUND FS 980 TO 1140 LONGERON -3RT SEAT TRACK AND MOUNT CORRODED MARKED L-177. REMOVED AND REPLACED SEAT TRACK AND REPAIRED IAW DC8 SRM 53-2-3 FIGURE 14. ALODINED AND PRIMED IAW DC8 SRM 51-1-8. CORROSION CARD NR 5590-0551. NON-SDR ABXA9700362Seat Track · corrodedDURING C CHECK, THE SEAT TRACK AT STA 190 RBL 22 WAS FOUND CORRODED. THE TRACK WAS REPAIRED IAW DC-9 SRM 53-05, FIG. 4A.SDR C2XA96IA297Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FLOOR 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 9627826636Seat Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION ON SEAT TRACK FLANGE. REPAIRED PER EA 66-120596.SDR TWAA9615818Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON RT FLOOR TRACK, FS 1155-1079. REPLACED TRACK PER SRM 53-5, PAGE 10 AND STANDARD PRACTICES. (M)SDR TWAA9615812Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON CARGO FLOOR TRACK, LONGERON 27R-28R, FS 1022-1155. REPLACED PART PER SRM 51-01. (M)SDR TWAA9615809Galley Track · corrodedMCI - DURING OP-16, FOUND CORROSION AROUND TIE HOLES OF OUTBOARD GALLEY TIE TRACK, LBL 54, FS 1174, 1210, 1238, 1295. REPLACED TRACK FROM 1174 TO 1322 PER MM 53-10-01. (M)SDR TWAA9615803Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON NR 2 FLOOR TRACK AT LEFT AFT SERVICE DOOR, LBL 44. INSTALLED NEW FLOOR TRACK FS 1126 TO 1222, PER SRM 53-05, PAGE 10G. (M)SDR ABXA9700156Track · wornWHILE COMPLYING WITH A C INSPECTION, FOUND THE CAPTAINS FOWARD SEAT TRACK WORN. REPLACED CAPTAINS FOWARD SEAT TRACKS IAW DC-9 SRM CHAPTER 51-30-1 AND MAINTENANCE MANUAL CHAPTER 25-13-1.SDR AWXA9600753Seat Track · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON SEAT TRACK AT STA 338, RBL 25, WL 208. INSTALLED NEW SEAT TRACK AT BS 338, RBL 25, WL 208 IN ACCORDANCE WITH SRM 53-00-52.SDR C2XA96IA295Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT OUTBOARD 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 AALA961767Galley Track · corrodedTUL - GALLEY SUPPORT NR 4 HAS CORROSION ALONG TRACK. NEW SUPPORT MADE PER SRM 51-00-00-1, AND INSTALLED ON AIRCRAFT. TST: 16,385 HOURS. CYCLES, 2,173. (X)SDR AWXA9600754Seat Track · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON SEAT TRACK AT STA 338, RBL 45, WL 208. INSTALLED NEW SEAT TRACK AT BS 338, RBL 45, WL 258 IN ACCORDANCE WITH SRM 53-00-52.SDR AALA961766Seat Track · corrodedTUL - NR 1 SEAT TRACK CORRODED AT STA 1351. REMOVED 40 INCHES OF TRACK FROM STA 1331 TO STA 1371. INSTALLED NEW SECTION OF TRACK AND TWO SPLICES 17 INCHES EACH LONG. TREATED/PRIMED AND PAINTED PER SRM 57-70-00, VOL I. TST: 16,385 HOURS. CYCLES, 2,173. (SDR AALA961763Seat Track · corrodedTUL - NR 2 SEAT TRACK CORRODED AT STA 1315. REMOVED DAMAGED SECTION OF SEAT TRACK AND INSTALLED NEW SECTION OF SEAT TRACK WITH SPLICES PER SRM 53-70-00, FIG 1, VOLT I. TST: 16,385. CYCLES, 2,173. (X)SDR AALA961762Seat Track · corrodedTUL - NR 2 SEAT TRACK CORRODED AT STA 1351. REMOVED DAMAGED SECTION OF SEAT TRACK AND INSTALLED NEW SECTION OF TRACK AND SPLICES PER SRM 53-70-00, FIG 1, VOL I. TST: 16,385 HOURS. CYCLES, 2,173. (X)SDR ABXA9700154Track · corrodedWHILE COMPLYING WITH A C INSPECTION, FOUND THE LEFT CARGO TIE DOWN TRACK IN THE AFT LOWER CARGO COMPARTMENT HAS EXFOLIATED CORROSION FROM FS 897 TO FS 965. REPLACED LEFT TRACK SECTION IAW DC-9 SRM CHAPTER 51-30-1.SDR 97ZZZX410Seat Track · corrosionDURING B-1/B-2 INSPECTION, THE RT OUTBOARD FORWARD SEAT TRACK (MAIN CABIN) WAS FOUND TO HAVE INTERGRANULAR CORROSION ON THE TRACK. REMOVED AND REPLACED WITH NEW TRACK. AIRCRAFT WILL BE RETURNED TO SERVICE AFTER INSPECTION IS COMPLETED.SDR 96ZZZX6117Seat Track · corrosionDURING B-1/B-2 INSPECTION, THE RT OUTBOARD FORWARD SEAT TRACK (MAIN CABIN) WAS FOUND TO HAVE INTERGRANULAR CORROSION ON THE TRACK. REMOVED AND REPLACED WITH NEW TRACK. AIRCRAFT WILL BE RETURNED TO SERVICE AFTER INSPECTION IS COMPLETED.SDR AALA961754Seat Track · corrodedTUL - NR 8 SEAT TRACK CORRODED AT STA 1315. REMOVED CORROSION, INSTALLED SEAT TRACK PLUG PER SRM 53-70-00, VOL I. TST: 16,385. CYCLES, 2,173. (X)SDR AALA961753Seat Track · corrodedTUL - NR 7 SEAT TRACK CORRODED AT STA 1351. REMOVED CORROSION, INSTALLED SEAT TRACK PLUG PER SRM 53-70-00. TST: 16,385. CYCLES, 2,173. (X)SDR 97ZZZM35Seat Track · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND THE CO-PILOT'S SEAT TRACK INBOARD SIDE AT STA 135 CORRODED. REMOVED FLOOR PANELS PER DC9 SRM 51-30-1. REMOVED SEAT TRACK PER DC9 SRM 51-30-1. LOCATED AND DRILLED NEW SEAT TRACK PER DC9 SRM 51-SDR 97ZZZM33Seat Track · corrodedDURING SCHEUDLED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND THE LT OUTBOARD SEAT TRACKS AT STA 920 - STA 935 CORRODED. REMOVED CORRODED SECTION OF SEAT TRACK, FABBED NEW SECTION, DRILLED AND DEBURRED, ALODINED AND PRIMED, AND INSTALLED. DRILLED AND DEBUSDR 97ZZZM32Seat Track · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND THE NR 1 SEAT TRACK FLANGE AT STA 209 CORRODED. REMOVED SEAT TRACK FLOOR BOARDS FROM STA 203 TO STA 230 IAW DC9 SRM 53-05, 4F. FABBED NEW SEAT TRACK IAW DC9 SRM 51-10-03. DRILLED UP SPLICE ANDSDR 97ZZZM31Seat Track · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND THE PILOT'S OUTBOARD SEAT TRACK CORRODED ON THE INBOARD FLANGE, STA 140. REMOVED FLOOR PANELS PER DC9 SRM 51-30-1. REMOVED SEAT TRACK PER DC9 SRM 51-30-1. LOCATED AND DRILLED NEW SEAT TRACK PESDR 97ZZZM30Seat Track · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND THE COPILOT'S OUTBOARD SEAT TRACK CORRODED ON OUTBOARD FLANGE, STA 140. REMOVED FLOOR PANELS PER DC9 SRM 51-30-1. REMOVED SEAT TRACK PER DC9 SRM 51-30-1. LOCATED AND DRILLED NEW SEAT TRACK PERSDR 97ZZZM29Seat Track · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND THE PILOT'S INBOARD SEAT TRACK CORRODED ON OUTBOARD FLANGE, STA 140. REMOVED FLOOR PANELS PER DC9 SRM 51-30-1. REMOVED SEAT TRACK PER DC9 SRM 51-30-1. LOCATED AND DRILLED NEW SEAT TRACK PER DCSDR 97ZZZM27Seat Track · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND THE NR 4 SEAT TRACK STA 180 - STA 218 INBOARD AND OUTBOARD FLANGES WERE CORRODED. REMOVED CORROSION IAW SRM 51-10-3. FOUND TO BE OUT OF LIMITS IAW SRM 53-05 FIG 4B. REMOVED, DRILLED AND DEBURRSDR 96ZZZX6047Seat Track · corrosionDURING A SCHEDULED INSPECTION AT AERO CORP, CORROSION WAS FOUND IN THE RIGHT OUTBOARD SEAT TRACK FROM STA 930 TO STA 935. DRILL OUT SEATED TRACK, BUT SEAT TRACK OUT. FAB NEW SEAT TRACK DRILL UP NEW, DEBURRED HOLES, INSTALLED SEAT TRACK AND SPLICE PART, IAW DSDR UPS96421724Seat Track · crackedINSPECTION TYPE: C. MAIN DECK INTERIOR BS 990 RBL 98 SEAT TRACK CORRODED/CRACKED. REPAIRED SEAT TRACK FROM BS 990 TO 1070 RBL 98 I.A.W. SRM 53-10-05 FIG. 34.SDR UPS96421714Seat Track · corrodedINSPECTION TYPE: C. SEAT TRACK LBL 11.33 IS CORRODED AT BS 440, 475 AND 500. DAMAGE EXCEEDED ALLOWABLE LIMITS IAW SRM 53-10-01. REPLACED SEAT TRACK PARTLY FROM BS 390 TO BS 520 IAW SRM 51-30-02.SDR 97ZZZX1765Seat Track · corrodedDURING A SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL,THE LT SEAT TRACK INBOARD, STA 200 - STA 240, WAS FOUND CORRODED BEYOND LIMITS. REMOVED CORRODED SECTION OF TRACK, FABBED AND INSTALLED NEW SECTION AND SPLICE IAW DC9 SRM'S 51-30-1, 51-30-2, 51-10-3,SDR 9627786608Seat Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION ON SEAT TRACK FLANGE 28 INBOARD AND 13 TO 18 AFT OF 1L ENTRYWAY FORWARD LOWER CORNER. REPAIRED PER EA 66-120462.
Back to JASC 5347