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 QXEA200500223Seat Track · corrodedPDX - RIGHTHAND INBOARD SEAT TRACK IS CORRODED AT X217 TO X237. REPAIRED IAW RD 8-53-4473 AND DHC-8/200 SRM 51-40-11.SDR QXEA200500226Seat Track · corrodedPDX - LEFTHAND INBOARD SEAT TRACK NR 6 CORROSION AROUND RIVETS ON OUTBOARD FLANGE APPROXIMATELY X533 TO X540. REPAIRED IAW DHC-8/200 SRM 51-40-11 AND RD 8-53-4472.SDR QXEA200500225Seat Track · corrodedPDX - LEFTHAND INBOARD SEAT TRACK NR 5 CORROSION AROUND RIVETS ON OUTBOARD FLANGE APPROXIMATELY X510 TO X524. REPAIRED IAW DHC-8/200 SRM 51-40-11 AND RD 8-53-4472.SDR QXEA200500224Seat Track · corrodedPDX - LEFTHAND INBOARD SEAT TRACK NR 4 CORROSION ON OUTBOARD FLANGE APPROXIMATELY X203 TO X208 AND X219 TO X221. REPAIRED IAW DHC-8/200 SRM 51-40-11 AND RD 8-53-4473.SDR UPS05443941Cargo Track · crackedINSPECTION TYPE:C M/D- BS 355 - 360, RBL 72, TIE DOWN TRACK FLANGE FOUND CORROSION CRACK (CRACK LENGTH 1 INCH). TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR GUUA94053021005ASeat Track · brokenDURING SCHEDULED ROUTINE INSP DISCOVERED RT SEAT TRACK FLOORBOARD ATTACH TAB BROKEN AT FS 380. REPAIRED BROKEN RT SEAT TRACK FLOOR SUPPORT TAB AT FS380.SDR SWIA200515053Seat Track · corrodedRT SIDE SEAT RAIL BETWEEN FS 364.00 - FS 409.00 + 16 IS CORRODED ITEM FOUND AT C-CHECK INSPECTION. REPLACED RT SIDE SEAT RAIL BETWEEN FS 364.00 - FS 409 + 16 IAW CRJ SRM 51-40-11, 51-41-02, 51-41-04, 51-25-16.SDR SWIA200515052Seat Track · corrodedRT SIDE SEAT RAIL BETWEEN FS 409.00 + 16 - FS 409.00 + 112 IS CORRODED ITEM FOUND AT C-CHECK INSPECTION. INSTALLED RT SIDE SEAT RAIL BETWEEN FS 409.00 + 16 - FS 409.00 + 112 IAW CRJ 200 AND MM 20-21-00-910-001.SDR SWIA200515051Seat Track · corrodedLT SIDE SEAT RAIL BETWEEN FS 409.00 + 112 AND FS 449.85 IS CORRODED ITEM FOUND AT C-CHECK INSPECTION. INSTALLED LT SIDE SEAT RAIL BETWEEN FS 409.00 + 112 ANS FS 449.85 IAW CRJ 200 SRM 51-41-04.SDR SWIA200515050Seat Track · corrodedLT SIDE SEAT RAIL BETWEEN FS 409.00 + 16 - FS 409.00 + 112 IS CORRODED, ITEM FOUND AT C-CHECK INSPECTION. REPLACED IAW CRJ SRM 51-40-11, 51-41-02, 51-41-04 AND 51-25-16.SDR SWIA200515049Seat Track · corrodedLT SIDE SEAT RAIL BETWEEN FS 364 - 409 + 16 IS CORRODED, ITEM FOUND AT C-CHECK INSPECTION. INSTALLED LT SIDE SEAT RAIL B/W FS 364-409 + 16 IAW CRJ SRM 51-41-02 PART 3.SDR SWIA200515048Seat Track · corrodedLT SIDE SEAT RAIL BETWEEN FS 449.85 - 449.00 IS CORRODED, ITEM FOUND AT C-CHECK INSPECTION. REPLACED IAW CRJ SRM 51-04-11, 51-41-02, 51-25-16.SDR UPS05443989Cargo Track · crackedINSPECTION TYPE: C, TIE DOWN TRACK BEAM LWR CHORD BS1000-1002 LBL 33 CORROSION CRACK FOUND. CRACK LENGTH 1 INCH AND CORROSION BLEND OUT 0.060 X 1 X 3 INCH, EXCEED SRM 53-10-01 LIMIT. M/D TIE DOWN TRACK BEAM LOWER CHORD REPAIRED AS PER HX RS R53-45-35264 & ENSDR UPS05443985Cargo Track · corrodedINSPECTION TYPE: C, BS 1500, RBL 78 TIE DOWN SUPPORT FITTING CORROSION FOUND. CORROSION BLEND OUT 0.025 X 1 X 1 EXCEED SRM 53-10-01 LIMIT. FITTING REPLACED PER SRM 51-10-01.SDR UPS05443965Seat Track · corrodedINSPECTION TYPE: C, BS 1500 - 1560, LBL 98 SEAT TRACK FLANGE CORROSION FOUND. CORROSION BLEND OUT 0.045 X 1 X 2 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT. TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A AT BS 1480-1570 LBL 98 AREA.SDR UPS05443962Seat Track · corrodedINSPECTION TYPE:C, BS 1580-1600 LBL 33 SEAT TRACK FLANGE CORROSION FOUND. CORROSION BLEND OUT 0.045 X 1 X 2 INCH EXCEED SRM 53-10-01 FIG 1, LIMIT. TIE DOWN TRACK REPLACED AT BS 1480 TO BS 1600 LBL 33 AS PER SRM 51-10-01 PG 9.SDR UPS05443961Cargo Track · corrodedINSPECTION TYPE: C, BS 1480 - 1500 RBL 34, TIE DOWN TRACK FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.040 X 1 X 2 INCH EXCEED SRM 53-10-01 FIG 1, LIMIT. TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS05443959Seat Track · corrodedINSPECTION TYPE:C M/D- BS 1600 - 1640 RBL 98 SEAT TRACK FLANGE CORROSION FOUND. CORROSION BLEND OUT 0.040 X 1 X 2 INCH EXCEED SRM 53-10-01 FIG 1, LIMIT. SEAT TRACK REPAIR AS PER SRM 53-10-05 FIG 1A.SDR UPS05443957Seat Track · crackedINSPECTION TYPE:C M/D- BS 1580 TO 1600 LBL 98 SEAT TRACK CRACKED (CRACK LENGTH 1 INCH). SEAT TRACK REPAIRED FROM BS 1570 TO BS 1630 LBL 98 AS PER SRM 53-10-05 FIG 1A.SDR UPS05443964Seat Track · corrodedINSPECTION TYPE: C, SEAT TRACK BS 1497 - 1500 LBL 33 RT FLANGE CORRODED. CORROSION BLEND OUT 0.030 X 1 X 2 INCH EXCEED SRM 53-10-01 FIG 1. TIE DOWN TRACK REPLACED AT BS 1480 TO BS 1600 LBL 33 AS PER SRM 51-10-01 PG 9.SDR UPS05443958Cargo Track · corrodedINSPECTION TYPE: C, BS 1660, RBL 78 TIE DOWN TRACK I/B FLANGE LWR FACE FOUND CORRODED. CORROSION BLEND OUT 0.035 X 1 X 1 INCH EXCEED SRM 53-10-01 FIG 1, LIMIT. TIE DOWN TRACK REPAIR AS PER SRM 53-10-05 FIG 1A.SDR QXEA200500208Cargo Track · corrodedPDX - AFT CARGO LEFTHAND INBOARD TRACK CORROSION ON OUTBOARD FLANGE APPROXIMATELY X672 TO X691. REPAIRED IAW DHC-8 400 SRM 51-42-05-330-801.SDR USAA050278Seat Track · corrodedBFM - FOUND RAIL CORRODED 2 INCH IN DIAMETER, .103 INCH DEEP, CABIN FRAME 13A, Y+953. CORROSION LEVEL 2, TASK C531172-01. REMOVED AND REPLACED LONGITUDINAL RAIL PER SRM 53-11-15 FIG 101, SH 1, 51-44-00, 51-42-11.SDR USAA050279Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, 2 INCHES BY 2 INCHES BY .040 INCH AREA, C74 AT Y1117. CORROSION LEVEL 2, TASK C534159-01. REPLACED WITH NEW SEAT TRACK PER SRM 51-44-00, 51-42-11, 52-44-11. (M)SDR ABXA050048Seat Track · corrodedSEAT TRACK AT LEFT BUTTLINE 44 WAS CORRODED BETWEEN STA 214 AND 224. REPAIRED TRACK AND SPLICED IN NEW SECTION OF TRACK IAW DC-9 SRM 53-05.SDR UPS05443974Seat Track · corrodedINSPECTION TYPE: C, BS 1165, RBL 75 SEAT TRACK FLANGE CORROSION FOUND. CORROSION BLEND OUT 0.030 X 1 X 1 EXCEED SRM 53-10-01 FIG 1, LIMIT SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 34.SDR UPS05443973Seat Track · crackedINSPECTION TYPE: C, BS 994 TO BS 995 RBL 98 SEAT TRACK CRACKED (CRACK LENGTH 1 INCH). M/ DECK BS 970 TO BS 995 RBL 98 TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS05443966Seat Track · crackedINSPECTION TYPE: C, BS 1140 - 1160, RBL 34 TIE DOWN TRACK FLANGE FOUND CRACKED (CRACK LENGTH 2.75 INCH). BS 1070 TO BS 1210 RBL 34 INCH TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 34.SDR UPS05443963Seat Track · crackedINSPECTION TYPE: C, BS 996 TO 999 RBL 75 SEAT TRACK CRACKED (CRACK LENGTH 1.5 INCH). TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A AT BS 930 TO BS 1000 RBL 75 AREA.SDR UPS05443947Seat Track · corrodedINSPECTION TYPE: C, BS 1110 RBL 75 SEAT TRACK WEB ATTACH STIFFENER FOUND CORRODED. CORROSION BLEND OUT 0.020 X 1 X 2 INCH EXCEED SRM 53-10-01 FIG 1, LIMIT. STIFFENER REPLACED AS PER SRM 51-10-01 PG 9.SDR USAA050251Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 3 INCHES LONG BY 1.25 INCHES WIDE BY .032 INCH DEEP/3.5 INCH LONG 1.25 INCHES WIDE .038 INCH, CABIN, FRAME 71, FRAME 72, -Y450. REPLACED SEAT TRACK ASSY PER SRM 53-0015 FIG 101, 53-41-15, 51-21-11. (M)SDR USAA050262Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 7 INCH BY 3.5 INCH BY .030 INCH DEEP, FRAME 32-33, -Y450, MAIN CABIN FLOOR. FABRICATED NEW TRACK SECTION AND SPLICES, INSTALLED REPAIR PARTS PER SRM 53-00-15, FIG 204. (M)SDR SWIA200514777Seat Track · corrodedLT AFT SEAT TRACK AT YL 479.00 IS CORRODED. (ITEM FOUND AT C-CHECK INSPECTION.) INSTALLED SEAT TRACK IAW EMB 120 SRM 51-22-00, 51-40-02, 51-25-00.SDR SWIA200514776Seat Track · corrodedSEAT TRACK LT IB AT YL 479.00 FROM FRM 13B TO 32 CORRODED. (ITEM FOUND AT C-CHECK INSPECTION.) INSTALLED NEW SEAT TRACK IAW EMB 120 SRM 51-22-00, 51-40-02.SDR SWIA200514775Seat Track · corrodedRT IB SEAT TRACK AT YR 479.00 FROM FROM 13 TO 32 IS CORRODED IN SEVERAL AREAS. (ITEM FOUND AT C-CHECK INSPECTION.) REPLACED SEAT TRACK IAW EMB 120 SRM 51-40-02, 51-22-00, 51-25-00.SDR SWIA200514774Seat Track · corrodedRT AFT SEAT TRACK AT YR 479.00 IS BADLY CORRODED. (ITEM FOUND AT C-CHECK INSPECTION.) RT AFT SEAT TRACK AT YR479.00 REPLACED IAW EMB 120 SRM 51-25-00, 51-22-00 AND 51-40-02.SDR SWIA200514771Seat Track · corrodedSEAT RAIL, LT OB CORRODED IN SEVERAL SPOTS AROUND THE SCREW HEADS. FR 15A AND FR32. (ITEM FOUND AT C-CHECK INSPECTION.) SEAT TRACK REPLACED IAW EMB 120 SRM 51-22-00, 51-25-00, 51-40-02.SDR SWIA200514770Seat Track · corrodedRIGHT SEAT RAIL CORRODED IN SEVERAL SPOTS AROUND SCREW HEADS FROM FRAME 13A- FR.32 OUTBOARD SIDEWALL. ITEM FOUND AT C-CHECK INSPECTION. SEAT TRACK REPLACED IAW EMB 120 SRM 51-25-00, 51-22-00, 51-40-02.SDR SWIA200514761Seat Track · corrodedRIGHT OUTBOARD AFT SEAT TRACK CORRODED AT FR38 TO FR34 (SIDEWALL). ITEM FOUND AT C-CHECK INSPECTION. SEAT TRACK REPLACED IAW EMB 120 SRM 51-25-00, 51-22-00, 51-40-02.SDR SWIA200514760Seat Track · corrodedLEFT OUTBOARD AFT SEAT TRACK CORRODED AT FR 39 TO FR.32 (SIDEWALL). ITEM FOUND AT C-CHECK INSPECTION. SEAT TRACK REPLACED IAW EMB 120 SRM 51-25-00, 51-22-00, 51-40-02.SDR USAA050240Seat Track · gougedBFM - FOUND TRACK GOUGED 1.5 INCH BY 1 INCH BY .25 INCH DEEP, FRAME 53.2, Y1959, MAIN CABIN FLOOR. FABRICATED SPLICES AND NEW SECTION OF SEAT TRACK, INSTALLED PARTS PER SRM 53-31-14 FIG 101 SHT 6.SDR 05FDEA00258Seat Track · corrodedMAIN DECK SEAT TRACK LBL 107 CORRODED AT STA 1966. REMOVED AND REPLACED WITH NEW SEAT TRACK FROM STA 1531 TO STA 2007 LBL 107 AS PER SRM 51-33-01 VOL II AND SRM 51-35-01 VOL II.SDR CALA0500042Seat Track · corrodedINSPECTION FOUND F/O'S AFT O/B SEAT TRACK CORRODED. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-40-01.SDR USAA050253Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 7 INCHES BY 1 INCH BY .019 INCH DEEP AND 13 INCHES BY 1 INCH BY .040 INCH DEEP, FRAME 53.7 AND 53.8, -Y450, MAIN CABIN FLOOR. REMOVED CORROSION, FABRICATED SPLICES AND NEW SECTION, INSTALLED REPAIR PARTS PER SRM 53-31-15. (M)SDR USAA050241Seat Track · gougedBFM - FOUND SEAT TRACK GOUGED .375 INCH BY .10 INCH BY .043 INCH DEEP, FRAME 47-48.5, -Y2462 MAIN CABIN FLOOR. SPLICED IN NEW SECTION OF SEAT TRACK PER SRM 53-31-15 FIG 201 SHT 1. (M)SDR USAA050252Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, FRAME 53.4-53.5 AT -Y1456, MAIN CABIN FLOOR. REPLACED WITH NEW TRACK PER SRM 53-31-15. (M)SDR USAA050271Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, 3 INCH BY 1.5 INCH BY .026 INCH DEEP, CABIN FRAME 30-33, -Y953. CORROSION LEVEL 2, TASK C532134-01. ACCOMPLISHED SEAT TRACK SPLICE REPAIR PER SRM 53-00-15, FIG 202, FIG 101. (M)SDR USAA050268Seat Track · corrodedBFM - FOUND SEAT FALSE RAIL CORRODED, 1 INCH WIDE BY 1 INCH LONG BY .053 DEEP, FRAME 13A +Y1959 MAIN CABIN FLOOR. REMOVED AND REPLACED FALSE RAIL PER SRM 53-11-14, 51-42-11. CORROSION LEVEL 2, TASK C531172-01. (M)SDR USAA050272Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 3.5 ICH LONG BY .85 INCH WIDE BY .040 INCH DEEP, CABIN FRAME 30-34, -Y1959. CORROSION LEVEL 2, TASK C53213401. ACCOMPLISHED SEAT TRACK SPLICE REPAIR PER SRM 53-00-15, FIG 204 FIG 101. (M)SDR USAA050260Seat Track · corrodedBFM - FOUND SEAT TRACK BEAM CORRODED 2.5 INCH BY 1.5 INCH BY .040 INCH AREA, FRAME C75 AND FRAME C76 AT -Y450 MAIN CABIN FLOOR. REPLACED WITH NEW SUPPORT BEAM PER SRM 53-00-15. (M)
Back to JASC 5347