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 QXEA0102055Seat Track · gougedPDX - RT INBOARD SEAT TRACK HAS MINOR GOUGES AT STATION 12415. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 5 AND SRM 51-10-04, PAGE 9, PARAGRAPH 4C.SDR CALA0101023Track · corrodedINSPECTION FOUND AFT CARGO L/H O/B FLOOR TRACK CORRODED AT STA 727-727C. THE FLOOR TRACK WAS REMOVED AND REPLACED IAW SRM 53-60-53 AND 53-00-53.SDR AALA20020034Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 1. CUT OUT CORRODED AREA AND INSTALLED PLUG REPAIR PER 53-05 FIG 4A. (M)SDR AALA20020032Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK UNDER TIE DOWN. CUT OUT CORROSION AREA AND INSTALLED PLUG REPAIR PER SRM 53-05 FIG 4A. (M)SDR QXEA0102051Seat Track · damagedPDX - RT OUTBOARD SEAT TRACK HAS BEEN BLENDED BETWEEN STATION 4590 AND 4700. BLEND DONE IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4C.SDR ZW0A0112004Cargo Track · corrodedDURING CHECK-C MAINT THE TIE DOWN TRACK HAD CORROSION AT STA 1127 TO 1140, LBL 34 TO LBL 37. INSTALLED NEW TRACK.SDR 0104475506Seat Track · corrodedDuring "H" check found corrosion on seat track at BS 400 RBL 24.75. Repaired per EA 55-187323.SDR CALA0101017Seat Track · corrodedINSPECTION FOUND CABIN L/H O/B SEAT TRACK CORRODED AT STA 887-907. REPAIRED SEAT TRACK IAW SRM 53-00-52, FIGURE 204.SDR ASAA0140164Seat Track · gougedPAE - DURING SI CHECK, FOUND SEAT TRACK GOUGED AT BS 538, LBL 45.5 AND WL 208. REPLACED PER SRM. (M)SDR AALA21002127Seat Track · damagedTUL - FOUND NUT PLATE MISSING FOR GALLEY TIE DOWN. CUT OUT AREA AND INSTALLED SEAT TRACK PLUG PER 53-05. (M)SDR AALA20012122Seat Track · corrodedTUL - FOUND NR 1 SEAT TRACK CORRODED STATION 1281, 1218, 1176, 1188. REPLACED NR 1 SEAT TRACK BETWEEN STATION 1174 AND 1307 PER SRM 53-05. (M)SDR 01FDEA01031Seat Track · corrodedCORRODED SEAT TRACK AT X=108.00 Z=-19.00 BS 1539-1553. REMOVED AND REPLACED SEAT TRACK PER SRM 53-70-00.SDR MWEA011441Seat Track · corrodedSEAT TRACK 4 BETWEEN STATION 200 AND 218 IS CORRODED AT FORWARD END AND AROUND FASTENER HOLES ON UPPER SURFACE AND LOWER SURFACE REMOVED, FABRICATED AND INSTALLED SEAT TRACK.SDR ZW0A0111407Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPT THE RT TIE DOWN WAS CORRODED FROM STA 1212 TO 1322. REPLACED WITH NEW TRACK PER SRM 51-30-1, STA 1212 TO 1322.SDR ZW0A0111406Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPT THE LT TIE DOWN TRACK WAS CORRODED FROM STA 1212 TO 1322. INSTALLED NEW TRACK PER SRM 51-30-2, AND 51-30-8. INSTALLED SPLICE PER SRM 53-05, FIG 4G.SDR ZW0A0111401Seat Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON CHAIR TRACK AT STA 1079 TO 1240. REMOVED AND REPLACED FLOOR TRACK FROM STA 1079 TO 1240 PER SRM 53-05, FIG 4F.SDR QXEA0101985Seat Track · corrodedPDX - RT INBOARD SEAT TRACK HAS PITTING ON INBOARD FLANGE AT APPROXIMATELY STATION 306 - 327. REPAIRED IAW HORIZON AIR EA 4-53-1527.SDR QXEA0101984Seat Track · corrodedPDX - RT INBOARD SEAT TRACK HAS PITTING ON INBOARD FLANGE AT APPROXIMATELY STATION 340-404. REPAIRED IAW HORIZON AIR EA 4-53-1527.SDR QXEA0101983Seat Track · corrodedPDX - RT INBOARD SEAT TRACK IS PITTED ON INBOARD FLANGE AT APPROXIMATELY STATION 676 - 685. REPAIRED IAW HORIZON AIR EA 4-53-1527.SDR QXEA0101982Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK HAS THREE PITS ON OUTBOARD FLANGE AT APPROXIMATELY STATION 232 - 234. REPAIRED IAW HORIZON AIR EA 4-53-1528.SDR QXEA0101981Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK HAS PITTING ON OUTBOARD FLANGE AT APPROXIMATELY STATION 325 - 327. REPAIRED IAW HORIZON AIR EA 4-53-1528.SDR QXEA0101980Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK HAS PITTING ON INBOARD FLANGE AT APPROXIMATELY STATION 349 - 357. REPAIRED IAW HORIZON AIR EA 4-53-1528.SDR QXEA0101915Seat Track · corrodedPDX - RT INBOARD SEAT TRACK HAS LIGHT CORROSION ON OUTBOARD FLANGE AT APPROXIMATELY STATION 180.5 TO 191. REPAIRED IAW FOKKER SRM 51-31-01, SRM 51-11-4, AND SRM 51-30-02.SDR GTIA012259Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK X22 FROM STATION 323-417. CUT OFF SEAT TRACK DAMAGE IN STATION 323-417. DRILLED NEW SEAT TRACK IN STATION 323-417. DRILLED SPLICE IN STATION 417 SEAT TRACK. INSTALLED SEAT TRACK IN STATION 323-417. INSSDR GTIA012253Seat Track · corrodedFTW - FOUND CORROSION, NICKS AND GOUGES AT SEAT TRACK X22 FROM STATION 228-323. REMOVED DAMAGED SECTION OF SEAT TRACK STATION 228-323. LOCATED AND DRILLED SEAT TRACK. INSTALLED SEAT TRACK STATION 228-323 IAW DC9 MM 53-40-1. (M)SDR GTIA012106Seat Track · gougedFTW - FOUND CORROSION, NICKS AND GOUGES AT X 44 SEAT TRACK FROM STATION 765 TO STATION 860. INSTALLED SECTION OF SEAT TRACK FROM STATION 765 TO Y 860 X 44 IAW SRM DC9 53-05. (M)SDR AALA20012132Seat Track · corrodedTUL - NR 5 SEAT TRACK CORRODED STATION 233. INSTALLED SEAT TRACK PLUG PLUG PER SRM 53-05 FIG 4A. RESTORED PROTECTIVE FINISH. (M)SDR AALA20012131Seat Track · corrodedTUL - FOUND NR 3 SEAT TRACK CORRODED STATION 1231-1233. INSTALLED SEAT TRACK PLUG REPAIR PER AARD 53-20-00-10, PAGE 2 FIG 1. (M)SDR GTIA012184Seat Track · wornFTW - FOUND CAPTAIN SEAT TRACKS ARE WORN. REMOVED UPPER DAMAGED TRACKS. FORMED NEW TRACK. INSTALLED CAPTAINS SEAT TRACKS IAW DC9 SRM 51-30-1. (M)SDR AALA20012107Seat Track · corrodedTUL - FOUND NR 1 SEAT TRACK CORRODED AT NUTPLATE ATTACH AREA FOR TIE DOWN BOLT. INSTALLED PLUG PER SRM 51-10-3. (M)SDR ZW0A0111402Seat Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON CHAIR TRACK NUMBER 2 FROM STA 1136 TO 1079. REMOVED CORRODED TRACK FROM STA 1079 TO 1309, AND INSTALLED NEW TRACK FROM STA 1079 TO 1309. INSTALLED SPLICE ASSEMBLY AT STA 1079 WITH HI-LOKS, WASHERS, AND NUTS AND PR1422 SDR AALA20012109Seat Track · corrodedTUL - FOUND NR 2 SEAT TRACK CORRODED INSIDE TRACK AT STATION 1190. INSTALLED SEAT TRACK PLUG IN SEAT TRACK NR 2 STATION 1190 PER AARD 53-20-00-10. (M)SDR ASOA01226Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE LEFT NR 2 SEAT TRACK OUTBOARD FLOOR BOARD FLANGE, AT A CLIP NUT FASTENER HOLE JUST FORWARD OF FRAME 17, WAS FOUND CORRODED BEYOND ALLOWABLE LIMITS. MAINTENANCE REPAIRED CORROSION IAW ASA EO72-53-0119. THIS EO REFERENCE FSDR ASOA01227Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE LEFT NR 1 SEAT TRACK HAD CORROSION ON THE CLIP NUT HOLE FORWARD OF FRAME 16. CORROSION WAS ALSO FOUND ON THREE CENTER CLIP NUT HOLES BETWEEN FRAMES 16 AND 17 AND TWO CENTER CLIP HOLES BETWEEN FRAMES 19 AND 20. MAINTENANCSDR ASOA01232Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE RIGHT FLOOR SEAT TRACK, CENTER SECTION, WAS FOUND CORRODED BETWEEN FRAMES 24 AND 32. MAINTENANCE REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW CPM 51-14-00. THE SEAT TRACK WAS REMOVED IAW SRM 51-40-02. A NEW SEAT TRACSDR ASOA01231Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE LEFT FLOOR SEAT TRACK, CENTER SECTION, WAS FOUND CORRODED BETWEEN FRAMES 22 AND 32. MAINTENANCE REMOVED THE SEAT TRACK IAW SRM 51-40-2. A NEW SEAT TRACK WAS LOCATED AND DRILLED IAW SRM 51-25-00 AND 51-40-6. AIRCRAFT WISDR QXEA0101848Seat Track · wornPDX - LT OUTBOARD SEAT TRACK HAS WORN AREA AT BOTTOM OF GROOVE APPROXIMATELY STATION 192. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101843Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON OUTBOARD FLANGE AT APPROXIMATELY STATION 331 TO 335. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101842Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK HAS SEVERAL GOUGES ON TOP OF RAIL AT APPROXIMATELY STATION 677 TO 683. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101841Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK HAS A GOUGE ON TOP OF TRACK AT APPROXIMATELY STATION 673.5. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101840Seat Track · scratchedPDX - LT OUTBOARD SEAT TRACK HAS A SCRATCH ON TOP OF RAIL AT APPROXIMATELY STATION 491. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101839Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION BOTTOM OF CHANNEL AT APPROXIMATELY STATION 223 TO 225. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101838Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION AT APPROXIMATELY STATION 228 TO 242, BOTTOM OF CHANNEL. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101837Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON INBOARD FLANGE AT APPROXIMATELY STATION 248-249. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101836Seat Track · wornPDX - LT INBOARD SEAT TRACK HAS WORN AREA FRONT TOP EDGE OF RAIL AT APPROXIMATELY STATION 254. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101835Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION INBOARD FLANGE AT APPROXIMATELY STATION 306. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101834Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON INBOARD FLANGE AT APPROXIMATELY STATION 327 TO 330. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101833Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION AT APPROXIMATELY STATION 331-333 ON INBOARD FLANGE. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 1B(2).SDR QXEA0101832Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON OUTBOARD FLANGE AT APPROXIMATELY STATION 347-357. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101831Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION IN BOTTOM OF CHANNEL AT APPROXIMATELY STATION 357-359. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).
Back to JASC 5347