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 96ZZZW37Track · corrodedLEVEL 2 CORROSION - AFT CARGO COMPARTMENT PIT NR 3 LEFT SIDE FLOOR TRACK ABOVE STRINGER 33L HAS CORROSION FROM FS 1240 TO 1380. REMOVED DAMAGED SECTION OF TRACK AND REPLACED.SDR 96ZZZM163Track · corrodedLEVEL 2 CORROSION, AFT CARGO COMPARTMENT PIT NR 3 LEFT SIDE FLOOR TRACK ABOVE STRINGER 33L HAS CORROSION FROM FS 1240 TO 1380. REMOVED DAMAGED SECTION OF TRACK AND REPLACED. (M)SDR AALA952150Tied Down Track · corrodedTULE - FOUND HEAVY CORROSION ON RIGHT TIEDOWN TRACK STATION 1045-1136, 1141, AND 1155. REPLACED SECTION OF TIEDOWN TRACK STATION 1007-1155. (M)SDR ABXA9600060Seat Tracks · wornDURING 826AX MOD-DISCOVERED MAIN CABIN SEAT TRACK ROW 'F', STATIONS 1590-1630, STATION 270, AND STATIONS 1540-1580, ROW 'B', STATIONS 1470-1500, AND AT STATIONS 45-70, SCALLOPS WORN, NICKS, GOUGES, BULDGE AREAS AROUND FASTENERS. FABRICATED TRIPLE SEAT TRACK ASDR ABXA9600059Seat Tracks · corrodedDURING 826AX MOD-DISCOVERED SEAT TRACK ROW 'F', STATION 857 ROW 'B', STATION 420, STATION 500, ROW 'C', STATIONS 1470-1490, ROW 'F', STATION 950 AND STATIONS 990-1300 HAVE CORROSION, ARE CHAFED, AND HAVE WORN SCALLOPS. FABRICATED DUAL SEAT TRACKS AT NUMEROUS SDR AALA952148Seat Track · corrodedTULE - FOUND CORROSION ON SEAT TRACK AT STATION 824-879. REPLACED SEAT TRACK FROM STATION 824-879 WITH NEW TRACK PER SRM 53-70-00, PAGES 344, FIG 1 SHEETS 1 AND 2. (M)SDR 96ZZZW1Seat Track · corrodedLEVEL 2 CORROSION - CABIN FLOOR INBOARD SEAT TRACK STATION 1620 TO 1580 RT HAS CORROSION. REMOVED DAMAGED SECTION OF SEAT TRACK, FABRICATED AND INSTALLED REPAIR PER SRM 53-2-3.SDR 96ZZZM127Seat Track · corrodedLEVEL 2 CORROSION, CABIN FLOOR INBOARD SEAT TRACK STATION 1620 - STATION 1580 RIGHT HAS CORROSION. REMOVED DAMAGED SECTION OF SEAT TRACK, FABRICATED AND INSTALLED REPAIR PER SRM 53-2-3. (M)SDR C2XA95IA420Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND RIGHT FWD OUTBOARD SEAT TRACK CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK, AIRCRAFT APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA95IA419Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND LEFT FORWARD OUTBOARD SEAT TRACK CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK, AIRCRAFT APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA95IA418Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND THE LEFT AFT FLOOR SEAT TRACK CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK, AIRCRAFT APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA95IA417Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FORWARD SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK, AIRCRAFT APPROVED FOR RETURN TO SERVICE. (M)SDR 96ZZZM519Floor Track · corrodedLEVEL 2 CORROSION, AFT CARGO COMPARTMENT NR 3 RIGHT SIDE FLOOR TRACK ABOVE STRINGER 33R HAS CORROSION FROM FS 1240 TO FS 1380. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED NEW FLOOR TRACK PER SRM 51-1-0.SDR 96ZZZM126Floor Track · corrodedLEVEL 2 CORROSION, AFT CARGO COMPARTMENT NR 3 RIGHT SIDE FLOOR TRACK ABOVE STRINGER 33R HAS CORROSION FROM FS 1240 TO FS 1380. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED NEW FLOOR TRACK PER SRM 51-1-0. (M)SDR GTIA96NK029Seat Track · corrodedDURING C-CHECK, FOUND PAX SEAT TRACKS FROM FS Y200 TO FS Y256 AT PLUS X23 AND -X47 CORRODED. REPAIRED PAX SEAT TRACKS IAW SRM 53-05 FIG 4 SHEET 1. (M)SDR AALA952126Seat Track · corrodedFOUND CORROSION AT STATION 757 TO STATION 760, NR 5 SEAT TRACK, BELOW MID GALLEY. REPAIRED PER SRM 53-70-00 FIG 2A. (M)SDR AALA952125Seat Track · corrodedTULE - FOUND CORROSION AT STATION 757 TO STATION 760, SEAT TRACK NR 6, UNDER CENTER GALLEY. INSTALLED STRAP DOUBLER PER SRM 53-70-00. (M)SDR USAA951390Seat Track · corrosionINT - DURING 'Q-2' CHECK VISUAL INSPECTION, FOUND CORROSION AT CLIP NUT HOLES, STA 986 - STA 1016, RBL 24 AND RBL 26, WL 208.1 SEAT TRACK. REPLACED SEAT TRACKS, REPAIRED PER SRM 51-10-01. CORROSION LEVEL 1. (X)SDR USAA951375Seat Tracks · corrosionINT - DURING 'Q-2' CHECK VISUAL INSPECTION, FOUND CORROSION AT SEAT TRACKS 1 INCH BY 1 INCH, RBL 8, RBL 24, AND RBL 36 AT STA 986 - STA 1016. REPLACED THREE SEAT TRACKS. REPAIRED PER SRM 51-10-01. CORROSION TASK NR C53-107-02. CORROSION LEVEL 2. (X)SDR 96ZZZX1393Seat Track · corrodedSEAT TRACK, RBL 13, STA 340 - STA 380, HAS LEVEL 2 CORROSION AT SEVERAL AREAS ALONG FLANGES AND FLOOR BEAM ATTACH POINTS. REMOVED DAMAGED SEAT TRACK, FABRICATED AND INSTALLED NEW SEAT TRACK SECTION PER SRM 51-10-1 AND SRM 51-30-2.SDR 96ZZZM247Tiedown Track · corrodedMCI - DURING OP-16, FOUND CORROSION IN LEFT TIEDOWN TRACK, STATION 1079 TO STATION 1109. REPAIRED PER SRM 53-05, FIGURE 4G AND ARA 9859.SDR 96ZZZM245Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON FLOOR TRACK, STATION 160 TO STATION 200, RBL 53. REPLACED TRACK PER SSRM 51-10-01.SDR 96ZZZM238Cargo Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON LEFT FLOOR CARGO TRACK, FS 1079 TO FS 1222. INSTALLED NEW TRACK PER SRM 51-10, ITEM 1, FIGURE C AND INSTALLED SPLICE PER SRM 53-03, FIGURE 4G.SDR 96ZZZM231Hold Down Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON 'E' GALLEY AFT INBOARD HOLD DOWN TRACK, STATION 1302 TO STATION 1281. REPLACED TRACK PER SRM 53-03, PAGE 10G.SDR 96ZZZM230Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON FLOOR TRACK FORWARD OF AFT END OF TRACK AT SCREWS, LBL 36, STATION 1136. REMOVED CORROSION PER SRM 51-10-3, AND REPLACED TRACK PER SRM 51-10-1C.SDR 96ZZZM226Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON FLOOR TRACK NR 3, RBL 20, STATION 200-240. REPLACED TRACK PER SRM 53-05, PAGE 10G AND SRM 51-01, ITEM C.SDR C2XA95IA412Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FORWARD FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT FORWARD FLOOR SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA95IA411Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FORWARD FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT FORWARD FLOOR SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA95IA410Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT SIDEWALL 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 C2XA95IA409Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT AFT SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR DL72W954720Seat Track · corrodedSEAT TRACK AT G-3 GALLEY INBOARD AFT MOUNT IS CORRODED. REPAIR PER M/M 53-20-11, PAGE 805.SDR 9521579307Cargo Track · corrodedDURING H-CHECK, FOUND CORROSION ON THE LEFT CARGO TRACK SPLICE, FS 598-693. REPAIRED TRACK (P/N 5936594-501) PER EA 93-103380.SDR SWAA950788Seat Track · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND 7 CRACKS IN SEAT TRACK WEB EXTENDING FROM RIVET HEADS THAT SECURE WEB TO PRESS DECK ATTACHING ANGLES BETWEEN BS 706/715 AT RBL 24.75. REPAIRED PER BOEING SRM.SDR SCNA95295Seat Track · corrodedDURING SCHEDULED INSPECTION, CORROSION WAS FOUND ON SEAT TRACK AT STATION 1050-1070, RBL 20. REMOVED CORROSION, FOUND TO BE BEYOND LIMITS. FABRICATED, INSTALLED NEW SEAT TRACK IAW B727 SRM 53-10-05, 51-10-12, 51-20-02, 51-10-05, 51-10-03.SDR 9522179307Seat Track · corrodedDURING H-CHECK, FOUND CORROSION ON THE LEFT OUTBOARD SEAT TRACK FS 208, OUTBOARD FLANGE. REPAIRED TRACK (P/N 5930547-3) PER EA 93-103404.SDR QXEA9500440Seat Track · corrodedPDX - DURING C-CHECK, FOUND SEAT TRACK P/N 85320701-123 IS CORRODED BEYOND MANUFACTURER'S LIMITS. NEW TRACK WAS INSTALLED AND AIRCRAFT RETURNED TO SERVICE.SDR QXEA9500439Seat Track · corrodedPDX - SEAT TRACK P/N 85330507-107 FOUND CORRODED BEYOND MANFACTURER'S LIMITS. NEW TRACK WAS INSTALLED AND AIRCRAFT RETURNED TO SERVICE.SDR QXEA9500438Seat Track · corrodedPDX - SEAT TRACK P/N 85330217-001 FOUND CORRODED BEYOND MANUFACTURER'S LIMITS. NEW TRACK WAS INSTALLED AND AIRCRAFT RETURNED TO SERVICE.SDR QXEA9500437Seat Track · corrodedPDX - SEAT TRACK P/N 85330469-001 FOUND CORRODED BEYOND MANUFACTURER'S LIMITS. NEW TRACK WAS INSTALLED. AIRCRAFT RETURNED TO SERVICE.SDR QXEA9500436Seat Track · corrodedPDX - SEAT TRACKS P/N 85320701-125 FOUND CORRODED BEYOND MANUFACTURER'S LIMITS. NEW TRACK INSTALLED AND AIRCRAFT RETURNED TO SERVICE.SDR QXEA9500435Seat Track · corrodedPDX - SEAT TRACK P/N 85331040-109 FOUND CORRODED BEYOND MANUFACTURER'S LIMITS. NEW TRACK WAS INSTALLED AND AIRCRAFT RETURNED TO SERVICE.SDR ASAA9580292Cargo Track · corrodedPAE - DURING 30K CHECK, CORROSION FOUND ON CARGO TRACK AT Y427 TO Y637, X-17, Z-44.5. REMOVED DAMAGED AREA AND INSTALLED NEW PIECES IAW DC-9, SRM 51-10-03 AND SRM 51-30-01, SRM 51-30-02 AND SRM 53-05. PART TAC, 19,401. (X)SDR USAA951370Seat Tracks · corrosionINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND 25 INCHES BY .5 INCH CORRODED AREA LBL 22 BS 344-369 SEAT TRACKS. FABRICATED SEAT TRACKS AND INSTALLED. REPAIRED PER SRM 53-00-52. CORROSION TASK NR C53-107-02. CORROSION LEVEL 2. (M)SDR USAA951326Floor Track · corrodedINT - DURING 'Q-3' CHECK VISUAL INSPECTION, FOUND SEVERAL .50 INCH BY 1 INCH CORRODED AREAS, BS 727F TO BS 787, RBL 14, CARGO FLOOR TRACK. CUT OUT CORRODED TRACK (BEAM) FROM BS 727E PLUS 14 TO BS 807. FABRICATED AND INSTALLED NEW BEAM SECTION AND SPLICES. RESDR USAA951256Seat Tracks · corrosionINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND 25 INCH BY .5 INCH CORRODED AREA LBL 22 BS 344-369, ON SEAT TRACKS. FABRICATED SEAT TRACKS AND INSTALLED. REPAIRED PER SRM 53-00-52, CORROSION TASK NR C53-107-02, CORROSION LEVEL 2. (M)SDR ABXA9600229Seat Track · corrodedDURING C-CHECK INSPECTION, FOUND LEVEL 2 CORROSION ON THE SEAT TRACK AT RBL 24 AT STA 180, STA 210, AND STA 218. INSTALLED NEW SEAT TRACK IAW DC-9 SRM 51-30-1.SDR 96ZZZM220Seat Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON NR 2 CHAIR TRACK, FS 1130 AND FS 1142. INSTALLED NEW TRACK PER SRM 51-01, PAGE 1.SDR MALA954748Seat Track · crackedDURING A SCHEDULED INSPECTION IN MSP, MAINTENANCE FOUND THE PILOTS INBOARD SEAT TRACK ATTACH POINT AT FS 116.56 TO BE CRACKED. REPAIRS WERE COMPLETED BY STOP DRILLING THE CRACK AND INSTALLING A REPAIR DOUBLER IAW FAC LAR 95-MALA-306. (M)SDR MALA954744Seat Track · crackedDURING A SCHEDULED INSPECTION IN MSP, MAINTENANCE FOUND CRACKS AT THE LEFT OUTBOARD SEAT TRACK ATTACH HOLES ON FS 116.56. REPAIRS WERE COMPLETED BY INSTALLING A REPAIR ANGLE IAW AERO TECH DESIGNS EA 01-95032. (M)SDR MALA954743Seat Channel · crackedDURING A SCHEDULED INSPECTION IN MSP, MAINTENANCE FOUND CRACKS AT THE NUT PLATE ATTACH RIVET HOLES ON THE RIGHT INBOARD SEAT CHANNEL LOCATED APPROXIMATELY 4 INCHES AFT OF FS 107. REPAIRS WERE COMPLETED BY INSTALLING A DOUBLER IAW FAC ARP 53-10-9322. (M)
Back to JASC 5347