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 SCNA97329Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, CORROSION WAS FOUND ON SEAT TRACKS AT STATION 1110, RBL 45 AND RBL 55. REMOVED, FABRICATED AND INSTALLED BOTH SECTIONS OF SEAT TRACK FROM STATIONS 1070 TO 1130 IAW SRM 51-31-02, 51-10-6 AND 53-10-5.SDR SIMA972633Seat Track · corrodedSAW - DURING D-CHECK INSPECTION, MAINTENANCE DISCOVERED SEAT TRACKS CORRODED OUT OF LIMITS, LEFT AFT INBOARD, LEFT AFT OUTBOARD. MAINTENANCE REMOVED AND REPLACED SEAT TRACK IAW SRM 51-25-04. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA972632Seat Track · corrodedSAW - DURING D-CHECK INSPECTION MAINTENANCE DISCOVERED SEAT TRACKS CORRODED OUT OF LIMITS, RIGHT AFT CARGO. MAINTENANCE REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-25-04. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA972631Seat Track · corrodedDURING D-CHECK INSPECTION MAINTENANCE DISCOVERED SEAT TRACKS CORRODED OUT OF LIMITS, LEFT AND RIGHT AFT FLIGHT ATTENDANT. MAINTENACNE REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-25-04. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR ORJA97157Track · corrodedCORROSION ON LEFT AND RIGHT LOCK DOWN TRACK FOR FWD LAV WALL. REMOVED CORROSION TRACK. REPLACED WITH NEW TRACK IAW DC-9 SRM 53-05 INSTALLED TRACK IAW DC-9 SRM 51-30-1 AND 51-30-5. AIRCRAFT RETURNED TO SERVICE. (M)SDR 97ZZZM1075Seat Track · corrodedSAW - DURING D-CHECK INSPECTION, MAINTENANCE DISCOVERED SEAT TRACKS CORRODED OUT OF LIMITS, LEFT AFT INBOARD, LEFT AFT OUTBOARD. MAINTENANCE REMOVED AND REPLACED SEAT TRACK IAW SRM 51-25-04. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR W8PA971488Cargo Track · corrodedPAE - CORROSION ON TRACK OF AFT CARGO BAY AT BS 944.5, LBL 16, WL 165. REMOVED SECTION OF CARGO TRACK, FABRICATED NEW SECTION AND INSTALLED PER SRM 53-60-53, 53-00-03.SDR ABXA9701495Track · crackedDURING C-CHECK, FOUND THE TRACK AT STA 710, RBL 54 CRACKED AT SPLICE. REPLACED TRACK PER ABX EA 532000014-001.SDR AALA971834Tie Down · corrodedTUL - TIE DOWN TROUGH HAS CORROSION ON FASTENERS AND LUGS. REPLACED TIE DOWN TROUGH PER AARD 51-01-00-05 AND SRM 51-21-01 VOL 11. (M)SDR AALA971833Seat Track · gougedTUL - FOUND SEAT TRACK NR 2 GOUGED TOP SIDE. ROUTED OUT DAMAGE AND INSTALLED PLUG REPAIR PER SRM 53-70-00. (M)SDR AALA971832Seat Track · gougedTUL - FOUND SEAT TRACK NR 4 TOP SIDE GOUGED. INSTALLED SEAT TRACK SPLICE REPAIR PE SRM 53-70-00. (M)SDR AALA971816Seat Track · gougedTUL - FOUND SEAT TRACK NR 3 GOUGED FORWARD OF ROW 22. INSTALLED NEW SECTION OF SEAT TRACK PER SRM 53-70-00. (M)SDR AALA971815Seat Track · gougedTUL - SEAT TRACK NR 4 GOUGED ON TOP SIDE FORWARD OF ROW 22. INSTALLED NEW SECTION OF SEAT TRACK PER SRM 53-70-00. (M)SDR C2XA97IA280Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND LEFT AFT FLOOR SEAT TRACK TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB120 MM 53-01-05. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA277Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND LEFT FORWARD SIDEWALL SEAT TRACK CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB 120 MM 53-01-05. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA276Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND RIGHT AFT FLOOR SEAT TRACK TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB120 MM 53-01-05. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA273Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOND RIGHT AFT SIDE WALL SEAT TRACK CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB120 MM 53-01-05. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA272Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOND RIGHT FORWARD SIDE WALL SEAT TRACK CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB120 MM 53-01-05. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA269Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND LEFT AFT SIDEWALL SEAT TRACK CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB120MM 53-01-05. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR AALA971814Seat Track · gougedTUL - TOP OF SEAT TRACK NR 2 GOUGED. INSTALLED PLUG REPAIR PER SRM 53-70-00. (M)SDR AWXA9700581Seat Track · corrodedDURING SCHEDULED C-12 INSPECTION, FOUND CORROSION (C53-107-02 PART 2 OF 2) ON SEAT TRACK STA 328, RBL 42, WL 208. REMOVED AND REPLACED SEAT TRACK FROM BS 328 TO 360, RBL 42, WL 208 PER SRM 53-00-52.SDR EISA97212Seat Track · corrodedMAIN CABIN LEFT INBOARD SEAT TRACK HAS CORROSION FS 360 TO 480. REPLACED SEAT TRACK SECTION FROM FS 360 TO 480 IAW SRM 53-10-05. (M)SDR ABXA9701655Seat Track · corrodedSTA 980-1000 LBL44, SEAT TRACK HAS HEAVY CORROSION. REPLACED SEAT TRACK LBL44 STA 960-180 IAW SRM 51-1-21, 51-3-0.SDR ABXA9701646Seat Track · corrodedSTA 1140-1160 LBL 44 SEAT TRACK HAS HEAVY CORROSION. REPLACED SEAT TRACK STA 1110 TO 1210 LBL 44 IAW SRM 53-2-3, 51-1-8, 51-3-0 AND 51-1-21.SDR AALA971787Seat Track · corrodedTUL - FOUND CORRODED TRACK BETWEEN FRAMES 12 AND 13. REPLACED FLOOR TRACK PER SRM 51-72-10-0. (M)SDR ABXA9701650Seat Track · corrodedSTA 360-420 AT STRINGER 33R SEAT TRACK HAS HEAVY CORROSION. REPLACED DAMAGED SECTION OF SEAT TRACK STA 360-520 IAW SRM 52-2-3 AND 51-1-20.SDR AALA971781Seat Track · corrodedTUL - FOUND SEAT TRACK NR 5 CORRODED AT AFT MOUNT FOR LAV. ACCOMPLISHED STANDARD SEAT TRACK PLUG REPAIR PER SRM 53-70-00 FIG NR 4, ALODINED, PRIMED AND PAINTED REPAIR AND AREA. (M)SDR AALA971778Seat Track · corrodedTUL - AFT INBOARD TIE DOWN IN NR 7 SEAT TRACK LAV MODULE DD IS CORRODED. ACCOMPLISHED A SEAT TRACK REPAIR PER SRM 53-70-00 VOL 1. (M)SDR AALA971777Seat Track · corrodedTUL - FOUND SEAT TRACK NR 4 CORRODED AT AFT MOUNT OF LAV. ACCOMPLISHED STANDARD SEAT TRACK PLUG REPAIR PER SRM 53-70-00 FIG 4. ALODINED, PRIMED AND PAINTED REPAIR AREA. (M)SDR ZZDA5327697Seat Track · broken offDURING C-CHECK AT AERO CORP, LT INBD SEAT TRACK LUGS AT STATIONS 480-520, AND STATIONS 540-597 ARE BROKEN OFF. FABRICATED SEAT TRACKS FROM BAC 1500-841 44.50 INCHES AND BAC 1520 792 77.5 INCHES BY 3.5 INCHES IAW B 737 SRM 53-10-5, FIG 1. INSTALLED IAW B 737 SSDR EISA97217Seat Track · crackedMAIN CABIN LEFT OUTBOARD SEAT TRACK HAS CRACKS FS 1050. SEAT TRACK SECTION REPLACED FROM FS 1050 TO 1090 IAW SRM 53-10-05. (M)SDR ABXA9701656Seat Track · corrodedSTATION 1270-1380 ABOVE STRINGER 33L SEAT TRACK IS CORRODED. REPLACED SEAT TRACK STA 1270-1380 ABOVE LONGERON 33L IAW DC8 SRM 53-2-0.SDR SWIA97969Seat Track · corrodedCABIN LEFT UPPER SEAT TRACK FORWARD SECTION HAS AREAS OF CORROSION. FIT, DRILLED AND INSTALLED NEW SEAT TRACK AS REQUIRED.SDR SWIA97968Seat Track · corrodedCABIN RIGHT UPPER SEAT TRACK FORWARD SECTION HAS SEVERAL AREAS OF CORROSION. DRILLED AND INSTALLED NEW SEAT TRACK AS REQUIRED.SDR SWIA97967Seat Track · corrodedRIGHT LOWER SEAT TRACK (FORWARD SECTION) HAS SEVERAL AREAS OF CORROSION. INSTALLED NEW SEAT TRACK AFTER DRILLING AND FITTING TO PROPER POSITION.SDR SWIA97966Seat Track · corrodedLEFT LOWER SEAT TRACK (FORWARD SECTION) HAS SEVERAL AREAS OF CORROSION. REPLACED LEFT LOWER SEAT TRACK.SDR SWIA97963Seat Track · corrodedSMALL FORWARD GALLEY MOUNT SEAT TRACK CORRODED. REPLACED SMALL FORWARD GALLEY MOUNT SEAT TRACK.SDR SCNA97319Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, THE NUMBER 1 SEAT TRACK AT FS 1010 TO 1030, LBL 48, WAS FOUND CORRODED BEYOND LIMITS. REMOVED CORRODED SECTION OF TRACK, SPLICED IN NEW SECTION OF TRACK IN ACCORDANCE WITH SRM 53-10-5.SDR SCNA97317Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, THE NUMBER 2 SEAT TRACK AT FS 1010 TO 1030, LBL 24 WAS FOUND CORRODED BEYOND LIMITS. REMOVED CORRODED SECTION OF TRACK, SPLICED IN NEW SECTION OF TRACK IN ACCORDANCE WITH SRM 53-10-5.SDR EISA97214Seat Track · corrodedMAIN CABIN, RIGHT INBOARD SEAT TRACK HAS CORROSION ON BOTH FLANGES FROM FS 360 TO 400. REPLACED SEAT TRACK SECTION FROM FS 360 TO 480 IAW SRM 53-10-05. (M)SDR WRLA97104Seat Track · corrodedDURING CONVERSION OF PASSENGER INTERIOR CONFIGURATION, REPAIR AGENCY FOUND CORROSION IN SEAT TRACKS REQUIRING REPLACEMENT. STA 1854 TO STA 1902, RBL 56. REPAIR AGENCY REPLACED SEAT TRACK IAW SRM 51-30-02. (X)SDR SCNA97318Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, THE NUMBER 5 SEAT TRACK AT FS 400 TO 420, RBL 48 WAS FOUND CORRODED BEYOND LIMITS. REMOVED CORRODED SECTION OF TRACK, SPLICED IN NEW SECTION OF TRACK IN ACCORDANCE WITH SRM 53-10-5.SDR DHL9780744CTrack · wornMCC, FUS STA 420, LINE NR 5, FLOOR TRACK WORN TWO PLACES. CUT OUT DAMAGED SECTION OF SEAT TRACK AND FABRICATED PLUGS AND CHANNEL IAW SRM 53-2-3. TREATED AND PRIMED AREA AND PLUGS IAW SRM 51-1-8. INSTALLED REPAIR PLUGS IAW SM 53-2-3.SDR DHL9780743CTrack · wornMCC, FUS STA 860, FLOOR TRACK WORN, LINE NR 5. REMOVED DAMAGED EXISTING PLUG AND FABRICATED NEW PLUG 1 EACH, IAW SRM 53-2-3. CLEANED AREA, TREATED AND PRIMED AREA AND REPAIR PLUG IAW SRM 51-1-8. INSTALLED REPAIR PLUG IAW SM 52-2-3.SDR DHL9780742CTrack · damagedMCC, FROM FUS STA 940 TO FS 960 FLOOR TRACK IS DAMAGED, LINE NR 5. REMOVED DAMAGED SECTION OF SEAT TRACK, PREPARED A NEW SECTION MADE FROM THE APPROPIATE MATCHING SECTION OF TRACKS AND FABRICATED SPLICES IAW SRM 53-2-3. TREATED AND PRIMED SEAT TRACK AND SPLISDR DHL9780741CTrack · damagedMCC, FUS STA 1040, FLOOR TRACK IS DAMAGED, 4 PLACES, LINE NR 5. CUT OUT DAMAGED FLOOR TRACK AND REPLACED 10 FT OF SEAT TRACK AND FABRICATED REPAIR SPLICES IAW SM 53-2-3 FIG 14. TREATED AND PRIMED IAW SRM 51-1-8. INSTALLED FLOOR TRACK AND SPLICES IAW SRM 53-SDR DHL9780740CTrack · chippedMCC, FUS STA 1060, LINE NR 5, FLOOR TRACK IS CHIPPED. CUT OUT DAMAGED FLOOR AND REPLACED 10 FT OF SEAT TRACK AND FABRICATED REPAIR SPLICES IAW SRM 53-2-3 FIG 14. TREATED AND PRIMED PARTS IAW SRM 51-1-8. INSTALLED FLOOR TRACK AND SPLICES IAW SRM 53-2-3 FIG 1SDR DHL9780739CTrack · damagedMCC, FUS STA 1300, LINE NR 5, FLOOR TRACK DAMAGED, ABOUT 25 INCHES. CUT OUT DAMAGED FLOOR TRACK AND REPLACED 10 FT OF SEAT TRACK AND FABRICATED REPAIR SPLICED IAW SRM 53-2-3 FIG 3. TREATED AND PRIMED PARTS IAW SRM 51-1-8. INSTALLED FLOOR TRACK AND SPLICES ISDR DHL9780738CTrack · damagedMCC, FUS STA 1220, LINE NR 5, FLOOR TRACK DAMAGED, TWO PLACES. REMOVED DAMAGED EXISTING PLUGS IAW SRM 53-2-3. CLEANED AREA. TREATED AND PRIMED AREA AND PLUGS IAW SRM 51-1-8. INSTALLED PLUGS IAW SRM 53-2-3.SDR DHL9780737CTrack · chippedMCC, FUS STA 1300, LINE NR 5, FLOOR TRACK IS CHIPPED, TWO PLACES. REMOVED DAMAGED EXISTING PLUGS AND FABRICATED NEW PLUGS IAW SRM 53-2-3. CLEANED AREA AND OK TO TREAT AND PRIME AREA AND REPAIR PLUGS. TREATED AND PRIMED AREA AND REPAIR PLUGS IAW SRM 51-1-8.
Back to JASC 5347