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 9706226740Seat Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION ON SEAT TRACK BEAM INBOARD FLANGE LOWER SURFACE FS 1200 TO 1265, LBL 11. REPAIRED PER EA 67-123514.SDR 9706216740Seat Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION IN FLANGE HOLES OF SEAT TRACK BEAM FS 1060 TO 1160, LBL 99. REPAIRED PER EA 67-123514.SDR 9706206740Seat Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION ON SEAT TRACK BEAM OUTBOARD FLANGE AROUND FASTENER HOLES FS 1003 TO 1020, LBL 11. REPAIRED PER EA 67-123514.SDR 9706196740Seat Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION ON SEAT TRACK BEAM INBOARD FLANGE FS 1080 TO 1160, LBL 11. REPAIRED PER EA 67-123514.SDR 9706186740Seat Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION IN FLANGE HOLES IN SEAT TRACK BEAM FS 1160 TO 1265, LBL 99. REPAIRED PER EA 67-123514.SDR 9706176740Seat Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION IN FLANGE HOLES OF SEAT TRACK BEAM FS 1130 TO 1265, LBL 78. REPAIRED PER EA 67-123514.SDR 9706156740Seat Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION IN FLANGE HOLES IN SEAT TRACK BEAM FS 1000 TO 1080, LBL 78. REPAIRED PER EA 67-123514.SDR DHL9771245DSeat Track · corrodedAT D-CHECK, AFT PIT RIGHT SEAT TRACK HAS CORROSION AT INSIDE CUT OUT SLOTS AND FLANGES AT NUMEROUS AREAS STA 950 TO 1166. REMOVED AND REPLACED SEAT TRACK AT AFT CARGO RBL 14 FROM BS 950 TO BS 1100 PER SRM 51-10-1. INSTALLED SPLICE AT SEAT TRACK PER SRM 53-1SDR AALA970370Seat Track · corrodedTUL - FOUND SEAT TRACK NR 8 CORRODED AT STATION 1481. INSTALLED NEW TRACK SECTION 20 INCHES LONG PER SRM VOL I, CHAP 53-70-00, PG 3 AND 4. (M)SDR DHL9771274DSeat Track · corrodedAT D-CHECK, 9G BULKHEAD SHEAR PLATE AND SEAT TRACK CORRODED BETWEEN BS 360 AND 380 RBL 48. REMOVED SEAT TRACK, REPLACED TRACKS 3, 2 AND 5 FROM BS 360 TO 380 PER SRM 51-10-1. INSTALLED SEAT TRACK AT SHEAR PLATE PER SRM 51-30-2.SDR TWAA9808813Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CORROSION ON LEFT SIDE SET TRACK, SECOND INBOARD LBL 44. REPLACED FLOOR TRACK FROM FS 1127 TO FS 1309, PER SRM 51-01, PAGE 1 AND SRM 53-05 FIG F AND STD PRACTICES. (M)SDR TWAA9726008Seat Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON LEFT SIDE SEAT TRACK, SECOND INBOARD, LBL 44. REPLACED FLOOR TRACK PER SRM 51-01, PAGE 1 AND SRM 53-05 AND TWA STANDARD PRACTICES. (M)SDR DHL9771246DSeat Track · corrodedAT D-CHECK, AFT PIT RIGHT SEAT TRACK CRACKED AT RADIUS, STA 1070, RBL 14. REMOVED AND REPLACED SEAT TRACK FROM STA 950 TO 1100 PER SRM 51-10-1. INSTALLED NEW SPLICE AT SEAT TRACK PER SRM 53-10-5. STRAP 14 BY 1.SDR ABXA9700556Seat Track · corrodedDURING C-CHECK, THE SEAT TRACK AT STA 382 TO 503 BL 0 WAS FOUND CORRODED. THE SEAT TRACK WAS REPLACED IAW DC9 SRM 51-10-4.SDR DHL9771226DSeat Track · corrodedAT D-CHECK, CORROSION ON SEAT TRACK FLANGE, BS 1060 TO 1080, RBL 45. REMOVED AND REPLACED SEAT TRACK PER SRM 53-10-5 FROM 1050-1130.SDR DHL9771215DSeat Track · corrodedAT D-CHECK, CORROSION ON SEAT TRACK AND ATTACH FASTENER BS 480 RBL 25. INSTALLED NEW TRACK PER SRM 51-30-2.SDR DHL9771214DSeat Track · corrosionAT D-CHECK, CORROSION ON SEAT TRACK BS 470 TO 480 LBL 46. INSTALLED NEW SEAT TRACK PER SRM 51-30-2.SDR DHL9771213DSeat Track · corrodedAT D-CHECK, CORROSION OF SEAT TRACK BS 510 TO 540 LBL 25. SPLICED IN SECTION OF SEAT TRACK PER SRM 53-10-5.SDR DHL9771212DSeat Track · corrodedAT D-CHECK, CORROSION OF SEAT TRACK BS 470 TO 490 LBL 25. INSTALLED NEW SECTION OF SEAT TRACK FROM BS 470 TO 490 LBL 25 PER SRM 53-10-5.SDR DHL9771234DSeat Track · corrodedAT D-CHECK, CORROSION ON SEAT TRACK, BS 480 LBL 18. REPLACED SECTION OF SEAT TRACK PER SRM 53-10-5 FROM BS 480 TO 540.SDR DHL9771220DSeat Track · corrodedAT D-CHECK, CABIN SEAT TRACK HAS CORROSION ON FLANGE AND INSIDE CHANNEL STA 620 TO 740 RBL 46. REPLACED SECTION OF SEAT TRACK PER SRM 53-10-5.SDR DHL9771211DSeat Track · corrodedAT D-CHECK, SEAT TRACK CORRODED BS 355 TO 400 LBL 46. REPLACED DAMAGED SEAT TRACK PER SRM 53-10-5.SDR DHL9771210DSeat Track · corrodedAT D-CHECK, CABIN SEAT TRACK AT RBL 46 AT STA 715 HAS CORROSION. REPLACED SECTION OF SEAT TRACK PER SRM 53-10-5 FROM STA 620 TO 740 RBL 46 .SDR ABXA9700555Seat Track · corrodedDURING C-CHECK, THE SEAT TRACK AT STA 250 TO 300 BL 0 WAS FOUND CORRODED. THE SEAT TRACK WAS REPLACED IAW DC9 SRM.SDR DHL9771233DSeat Track · corrodedAT D-CHECK, CORRODED FASTENERS, NUT PLATES ON PREVIOUS SEAT TRACK FLANGE REPAIR, BS 520 TO 540 LB 20. REMOVED AND INSTALLED NEW SECTION OF SEAT TRACK PER SRM 51-30-2 FROM 480 TO 540.SDR ABXA9700568Seat Track · damagedDURING C-CHECK, THE SEAT TRACK AT STA 313 RBL 40 WAS FOUND DAMAGED. THE SEAT TRACK WAS REPLACED IAW DC9 SRM 51-30-1.SDR ABXA9700567Seat Track · corrodedDURING C-CHECK, THE SEAT TRACK AT STA 176 TO 218 RBL 40 WAS FOUND CORRODED. THE SEAT TRACK WAS REPLACED IAW DC9 SRM 51-30-1.SDR EIAA970027Seat Track · corrodedSAT - DURING C-6 INSPECTION, FORWARD CARGO COMPARTMENT, SEAT TRACK HAS MODERATE TO HEAVY CORROSION. FABRICATED AND INSTALLED FORWARD CARGO RIGHT CENTER SEAT TRACK IAW SRM 51-10-3 AND 53-20-0. (M)SDR EIAA970026Seat Track · corrodedSAT - DURING C-6 INSPECTION, FORWARD CARGO COMPARTMENT, SEAT TRACK RIGHT, AFT HAS MODERATE TO HEAVY CORROSION. FABRICATED AND INSTALLED FORWARD CARGO RIGHT AFT SEAT TRACK IAW SRM 51-10-3 AND 53-20-0. (M)SDR EIAA970025Seat Track · corrodedSAT - DURING C-6 INSPECTION, MAIN CARGO COMPARTMENT, SEAT TRACK AT STATION 200 NR 2 LEFT INBOARD FLANGE HAS EXFOLIATION CORROSION. REMOVED SECTION OF SEAT TRACK AT STATION 200 NR 2 LEFT SIDE PER SRM 53-05 FIGURE 4D PAGE 10C. INSTALLED REPLACEMENT SEAT TRACK SDR EIAA970023Seat Track · wornSAT - DURING C-6 INSPECTION, MAIN CARGO COMPARTMENT STATION 605, SEAT TRACK NR 12, LUGS ARE WORN AT FORTH BEAR TRAP. REMOVED AND REPLACED SEAT TRACK STATION 605 PER SRM 53-21-0 FIG 4. (M)SDR C2XA97IA062Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FLOOR 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 C2XA97IA061Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FORWARD 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 C2XA97IA060Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT AFT FLOOR 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 C2XA97IA059Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FORWARD SIDEWALL 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 F3LA97049Seat Track · corrodedPAE - WHILE WORKING INTERIOR 00171, FOUND CORROSION ON SEAT TRACK AT RBL 25, BS 344-BS 360. REMOVED CORROSION ON SEAT TRACK AT RBL 25, BS 344-BS 360, WL 208, FOUND TO BE OUT OF LIMITS IAW SRM 53-10-1. REMOVED SEAT TRACK FROM BS 344-BS 360, FABRICATED SEAT TRSDR C2XA97IA054Seat Track · corrodedDURING A ROUTINE INSPECTION, THE AFT CABIN LEFT INBOARD SEAT TRACK WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED DAMAGED PORTION OF SEAT TRACK, AND INSTALLED A SPLICE REPAIR PER ATR 42 SRM. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR DHL9771224DSeat Track · corrodedAT D-CHECK, CORROSION ON CABIN SEAT TRACK NR 6 RBL 48 FROM STA 730 TO 793. REPLACED SEAT TRACK PER SRM 53-10-5 FROM BS 600 TO 740.SDR AWXA9700125Seat Track · gougedDURING ROUTINE MAINTENANCE CHECK, FOUND SEAT TRACK GOUGED AT BS 1480, LBL 45, WL 208. BLENDED SEAT TRACK, FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED SEAT TRACK. FABRICATED AND INSTALLED NEW SEAT TRACK IAW, SRM 53-00-52.SDR UPS97422005Cargo Track · corrodedINSPECTION TYPE: C. FOUND CORROSION ON CARGO TRACK UNDER ENDSTOP FITTING AT RBL 45, BS 1910. CORROSION WAS OUT OF LIMITS. REPAIRED TRACK ACC. SRM 53-10-05.SDR TWAA9720013Cargo Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON CARGO TRACK FLANGES FOR FLOOR PANEL MOUNT HOLES, FS 1007 TO 1117, LEFT SIDE. INSTALLED NEW TRACK PER SRM 51-01 AND TWA STANDARD PRACTICES. (M)SDR TWAA9720010Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION AT LOWER SIDE OF RIGHT FLOOR TRACK, AFT OF DOOR AFT CARGO OPENING AT FASTENER HOLES. REPLACED RIGHT TRACK ASSEMBLY PER SRM 51-01, PAGE 1, ITEM C. (M)SDR TWAA9720008Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON FLOOR TRACK, FS 200, RBL 22. REPLACED FLOOR TRACK PER SRM 51-01, PAGE 1, ITEM C. (M)SDR TWAA9720007Cargo Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON AFT CARGO BIN LEFT CARGO TRACK. REPLACED AFT CARGO BIN LEFT TRACK, FS 1117-1322, PER SRM 51-01, PAGE 1, ITEM C. (M)SDR F3LA97034Seat Track · corrodedFOUND CORROSION (C53-107-01), ON SEAT TRACK BS 344-360, LBL 45, WL 208. BLENDED OUT CORROSION AT BS 344-360, LBL 45, WL 208. BLENDED OUT CORROSION AT BS 344-360, LBL 45, WL 208 IN AN AREA 6 INCH BY 1 INCH BY .020 INCH. ORIGINAL THICKNESS . 270 INCH OF SEAT SDR DHL9780415CSeat Track · wornAT C-CHECK, NR 4 FLOOR TRACK FROM BS 300 TO 420 WORN. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED SEAT TRACK PER SRM 53-2-3.SDR 97ZZZM636Seat Track · misdrilled31J - THE FOLLOWING WAS FOUND, CABIN SEAT TRACK LEFT OUTBOARD HAS HOLES .5 INCH DRILLED IN TOP THROUGH OUT. REMOVED AND REPLACED SEAT TRACK FROM STATION 520-540 IAW SRM 51-30-2. REMOVED AND REPLACED SEAT TRACK FROM STATION 727-727B IAW SRM 51-30-2. FABRICATSDR 97ZZZM635Seat Track · misdrilled31J - THE FOLLOWING WAS FOUND, CABIN SEAT TRACK LEFT OUTBOARD HAS HOLES .5 INCH DRILLED IN TOP THROUGH OUT. REMOVED AND REPLACED SEAT TRACK FROM STATION 520-540 IAW SRM 51-30-2. REMOVED AND REPLACED SEAT TRACK FROM STATION 727-727B IAW SRM 51-30-2. FABRICATSDR 97ZZZM630Seat Track · corroded31J - THE FOLLOWING WAS FOUND, CABIN SEAT TRACK RIGHT OUTBOARD HAS HOLES DRILLED IN TOP THROUGH OUT. REMOVED SEAT TRACK FROM STATION 420-480 520. FABRICATED NEW SEAT TRACK FROM BAC 1520-792 AND INSTALLED IAW SRM 53-10-5. REMOVED AND FABRICATED NEW SEAT TRACSDR 97ZZZM629Seat Track · misdrilled31J - THE FOLLOWING WAS FOUND, CABIN SEAT TRACK T/H INBOARD HAS HOLES DRILLED IN TOP THROUGH OUT. FABRICATED NEW SEAT TRACK FROM BAC 1520-792 100 INCHES LONG. INSTALLED NEW SEAT TRACK IAW SRM 51-10-2. REMOVED SEAT TRACK FROM STATION 520-540 AND INSTALLED NE
Back to JASC 5347