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 SIMA2475Seat Track · corrodedFOUND CORROSION ON THE RIGHT INBOARD SEAT TRACK BL 0 AT FUSELAGE STATION 294. REMOVED SECTION OF SEAT TRACK AND PERFORMED SEAT TRACK SPLICE REPAIR IAW SAAB SRM 53-70-60. (M)SDR SIMA2474Seat Track · corrodedSBP - FOUND CORROSION ON THE LEFT INBOARD SEAT TRACK, BL 18.3 AT FUSELAGE STATION 294. REMOVED SECTION OF SEAT TRACK AND PERFORMED SEAT TRACK SPLICE REPAIR IAW SAAB SRM 53-70-60. (M)SDR CALA0001386Cargo Track · corrodedINSPECTION FOUND RT TIEDOWN TRACK CORRODED FROM STA 1211 - 1309 AND LT TIEDOWN TRACK CORRODED FROM STA 1007 - 1309 IN AFT PIT. THE TRACKS WERE REMOVED AND NEW TRACKS WERE INSTALLED IAW SRM 53-05, FIGURE 5, 51-10-3, 51-10-4, AND 51-30-5.SDR CALA0001385Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED AT FS 936 - 1212. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-1 AND 53-05, FIGURE 1.SDR CALA0001381Cargo Track · corrodedINSPECTION FOUND LT CARGO TIE DOWN TRACK CORRODED IN MID CARGO COMPARTMENT AT FS 522. THE TIE DOWN TRACK WAS REMOVED AND A REPLACEMENT TRACK WAS INSTALLED IAW SRM 53-05, FIGURE 4G.SDR CALA0001380Seat Track · corrodedINSPECTION FOUND LT CENTER SEAT TRACK CORRODED AT STA 1126 - 1240. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1, 51-30-2, AND 53-05, FIGURE 4.SDR ASAA0080533Seat Track · corrodedPHX - DURING SCHEDULED 30K CHECK, THE SEAT TRACK STATION 1155 TO 1174, LBL 44 WAS FOUND TO BE CORRODED. REPAIRED PER SRM. (M)SDR ASAA0080568Cargo Track · corrodedPHX-DURING SCHEDULED 30K CHECK THE AFT CARGO COMPARTMENT TRACK SECTION AT STA 1250, LONG 27L, WAS FOUND TO BE CORRODED. REPAIRED PER SRM.SDR ASAA0080556Cargo Track · corrodedPHX-DURING SCHEDULED 30K CHECK THE AFT CARGO COMPARTMENT FLOOR TRACK CHANNEL AT STA 1079 TO 1155, RBL 20, WAS FOUND TO BE CORRODED.REPAIRED PER SRM.SDR ASAA0080557Cargo Track · corrodedPHX-DURING SCHEDULED 30K CHECK THE CENTER CARGO COMPARTMENT CARGO TRACK AT STA 782, RBL 18, WAS FOUND TO BE CORRODED. REPAIRED PER SRM.SDR ASAA0080562Cargo Track · corrodedPHX-DURING SCHEDULED 30K CHECK THE AFT CARGO COMPARTMENT TRACK AT STA 1212 TO 1309, LONG 28R WAS FOUND TO BE CORRODED. REPAIRED PER SRM.SDR ASAA0080525Seat Track · corrodedPHX-DURING SCHEDULED 30K CHECK THE SEAT TRACK AT STA 200 TO STA 795, RBL24, WAS FOUND TO BE CORRODED.REPAIRED PER SRM.SDR ASAA0080531Seat Track · chafedPHX-DURING SCHEDULED 30K CHECK THE FLOOR BEAM SPLICE AT STA 864, RBL 24, SEAT TRACK CHAFING.REPAIRED PER SRM.SDR ASAA0080532Seat Track · corrodedPHX-DURING SCHEDULED 30K CHECK THE SEAT TRACK AT STA 1030 TO 1290, LBL 24, WAS FOUND TO BE CORRODED.REPAIRED PER SRM.SDR ASAA0080540Cargo Track · corrodedPHX-DURING SCHEDULED 30K CHECK THE CENTER CARGO COMPARTMENT CARGO TRACK AT STA 786, LBL 18, WAS FOUND TO BE CORRODED.REPAIRED PER SRM.SDR AALA20001525Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 1 STATION 796. REMOVED DAMAGED SECTION, SPLICED IN NEW SECTION PER SRM 53-05 PART 1. (M)SDR AALA20001521Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 6 AT THE FOLLOWING STATIONS 484, 625, 687, 717, 748, 765, 779 AND 795. REPLACED SEAT TRACK NR 6 FROM STATION 302-798 PER SRM 51-01. (M)SDR AALA20001520Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 2 AT THE FOLLOWING STATIONS 1300-1303, 1200-1202, 1205-1207, 1196, 1266, 1225, 1171, 1259, 1286, 1177, 1167, 1190, 1276, 1280 AND 1201. REPLACED NR 2 SEAT TRACK FROM STATION 1165 TO 1307 PER SRM 51-01. (M)SDR AALA20001491Seat Track · corrodedTUL - FOUND CORROSION BEYOND LIMITS. INSTALLED NEW SEAT TRACK SRM 51-01. (M)SDR SIMA2452Seat Track · corrodedSAW - DURING CPCP-2, FOUND RIGHT FLIGHT ATTENDANT, RIGHT AFT INBOARD AND RIGHT OUTBOARD SEAT TRACK CORRODED BEYOND LIMITS. REMOVED AND REPLACED SEAT TRACKS (P/N S53678001210, EPN-E9-5300-013-009, EPN-E9-5300-013-008)IAW EO E9-5300-013. (M)SDR AWXA0000611Seat Track · corrodedC-CHECK CORROSION, CABIN FLOOR PANEL SUPPORT Y1292 RT FRAME 20 CORRODED. NEW FLOOR SUPPORT FABRICATED IAW DWG D53112815 AND INSTALLED IAW A320 SRM 51-72-11.SDR AWXA0000609Seat Track · corrodedC-CHECK CORROSION, NR 4 SEAT TRACK FRAME 31.5 FRETTED. REPAIRED IAW A320 SRM 53-00-15 PG 202 FIG 201.SDR AWXA0000605Seat Track · corrodedC-CHECK CORROSION, AFT FLOOR PANEL SUPPORT FRAME 66 STR Y925 LT, FLT ATTENDANT SEAT ATTACH POINT CORRODED. REMOVED AND REPLACED BEAM IAW A320 SRM 51-72-11.SDR AWXA0000604Seat Track · corrodedC-CHECK CORROSION, NR 3 SEAT TRACK AT FRAME 20R Y-765 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW A320 SRM 51-42-11, FAB''D REPLACEMENT PART IAW DWG D53112782.SDR AALA20001522Cargo Track · corrodedTUL - FOUND RIGHT CARGO TIE DOWN TRACK CORRODED IN CENTER OF TRACK STATION 1079 TO STATION 1155, ALSO CORRODED ON OUTBOARD FLANGE STATION 1155. REMOVED TIE DOWN TRACK AND INSTALLED NEW TRACK SRM 51-01. (M)SDR CALA0001353Seat Track · corrodedINSPECTION FOUND LEFT O/B SEAT TRACK AFT OF L-2 DOOR CORRODED AT FS 1174. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-1, 51-10-4, AND 51-10-3.SDR GAIA00603Seat Track · corrodedDISCREPANCY: DURING HEAVY CHECK FOUND: SEAT TRACK AT BS585 RBL24 CORRODEDCORRECTIVE ACTION: REMOVED DAMAGED, FABRICATED SEAT TRACK & INSTALLED IAW B727 SRM 53-10-5 STA 580 TO 600.SDR AALA20001523Seat Track · corrodedTUL - FOUND SEAT TRACK NR 2 HAS CORROSION AT STATION 1202. ACCOMPLISHED SEAT TRACK PLUG REPAIR PER AARD 53-20-00-10. (M)SDR AALA20001508Seat Track · corrodedTUL - FOUND NR 6 SEAT TRACK CORRODED STATION 446-465. ROUTED OUT DAMAGE AREA AND INSTALLED PLUG AT NR 6 SEAT TRACK STATION 450-454 PER SRM 53-05 FIG 4A. (M)SDR AALA20001507Seat Track · corrodedTUL - FOUND NR 6 SEAT TRACK CORROSION STATION 639. INSTALLED PLUG NR 6 SEAT TRACK AT STATION 639 PER SRM 53-05 FIG 4A. (M)SDR MALA000580Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON SEAT TRACK LT FLANGE AT BL 0, STA 294. MAINTENANCE FOUND AFTER REMOVAL OF CORROSION REMAINING MATERIALS OUT OF ALLOWABLE LIMIT AS MARKED. REF SRM 53-70-60. RESTORED SURFACE PROTECTION AND PAINT REF SAAB SRM 51-20-42/43. FSDR MALA000579Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON SEAT TRACK WEB LBL 18.3, STA 297. MAINTENANCE REMOVED CORROSION ON TRACK WEB, AFTER CORROSION REMOVAL FOUND REMAINING MATERIAL OUT OF ALLOWABLE LIMIT AS MARKED. REF SRM 53-70-60. RESTORED SURFACE PROTECTION AND PAINT REF SSDR MALA000578Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON SEAT TRACK RT FLANGE RBL 18.3, STA 294. MAINTENANCE FOUND AFTER REMOVING CORROSION REMAINING MATERIALS OUT OF ALLOWABLE LIMIT AS MARKED. REF SRM 53-70-60. RESTORED, SURFACE PROTECTION AND PAINT REF SAAB SRM 51-20-42/43. FASDR TWAA0014305Galley Track · corrodedDURING OP 15 MAINT CHECK, FOUND GALLEY TRACK NUMBER 1 AT STA 237 TO 247, LBL 44 INCHES, WAS CORRODED. REPLACED TRACK FROM STA 200 TO 301. INSTALLED SPLICE PER SRM 53-05 FIG 4F.SDR TWAA0014309Seat Track · corrodedDURING OP 15 MAINT CHECK, FOUND FWD F/A SEAT ATTACH POINT AT STA 163, LBL 42 INCHES, WAS CORRODED. REMOVED CORROSION PER SPM 6-80-01 AND SRM 51-30-00. REPLACED F/A ATTACH POINT PER SRM 51-01 PAGE 9.SDR GAIA00537Seat Track · damagedDISCREPANCY: DURING HEAVY CHECK FOUND: HOLE IN SEAT TRACK BS740 RBL25CORRECTIVE ACTION: REPLACED SEAT TRACK BS740 RBL 25 IAW B727 SRM53-10-5SDR USAA001442Seat Track · corrodedPIT - FOUND SEAT TRACK CORRODED .09375 INCH AROUND SCREW HOLES, OUTBOARD SEAT TRACK RIGHT SIDE BETWEEN STATION 663 AND 685. CORROSION LEVEL 1, TASK NR C53-107-01. BLENDED PER SRM 53-00-52 PER SRM SRM 53-00-52. (M)SDR RRXA002996Seat Track · brokenDURING A MAINTENANCE VISIT FOUND A BROKEN SEAT TRACK AT STA 680 AND RBL 25, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR RRXA002995Seat Track · brokenDURING A MAINTENANCE VISIT FOUND A BROKEN SEAT TRACK AT STA 1040 AND RBL 25, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR RRXA002994Seat Track · brokenDURING A MAINTENANCE VISIT FOUND A BROKEN SEAT TRACK AT STA 1450 AND RBL 25, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR RRXA002992Seat Track · brokenDURING A MAINTENANCE VISIT FOUND A BROKEN SEAT TRACK AT X=0 Y=1477 Z=0, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR TWAA0013608Galley Track · crackedDURING OP 15 MAINT CHECK, GALLEY TRACK NUMBER 2 AT STA 200, LBL 22 INCHES, WAS CRACKED. REMOVED AND REPLACED NUMBER 2 TRACK FROM STA 200 TO 266.5 PER SRM 53-05 AND INSTALLED FASTENERS PER SRM 51-30.SDR CALA0001336Seat Track · corrodedINSPECTION FOUND CABIN RT CENTER SEAT TRACK CORRODED AT FS 200. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4F.SDR L1GA200000277Seat Track · wornSEAT TRACK WORN BEYOND LIMITS, PILOTS. REMOVED AND REPLACED SEAT TRACK.SDR L1GA200000276Seat Track · wornSEAT TRACK WORN BEYOND LIMITS. REMOVED AND REPLACED PILOTS SEAT TRACK.SDR L1GA200000275Seat Track · damagedHOLES IN SEAT TRACK WORN BEYOND LIMITS, CO-PILOT. REMOVED AND REPLACED SEAT TRACK.SDR L1GA200000259Seat Track · corrodedA 1 BY 7 INCH CORRODED AREA RT OUTBOARD SEAT TRACK. REMOVED AND REPLACED SEAT TRACK.SDR L1GA200000258Seat Track · corrodedA 1 BY 7 INCH CORRODED AREA SEAT TRACK. REMOVED AND REPLACED TRACK.SDR L1GA200000257Seat Track · corrodedA 1 X 15 INCH CORRODED AREA RT OUTBOARD SEAT TRACK FS 670 - 685. REMOVED AND REPLACED SEAT TRACK.SDR L1GA200000256Seat Track · corrodedA 1 X 24 INCH CORRODED AREA AT RT OUTBOARD SEAT TRACK AT FS 642 - 666. REMOVED AND REPLACED TRACK.
Back to JASC 5347