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 QXEA0000107Seat Track · gougedPDX - NICKS AND GOUGES IN INBOARD FLANGE OF LEFT-HAND INBOARD SEAT TRACK BETWEEN FRAMES 7305 AND 7805. REPAIRED IAW FOKKER SRM 51-10-04, PARAGRAPH 4.SDR QXEA0000105Seat Track · corrodedPDX - CORROSION ON OUTBOARD FLANGE OF LEFT-HAND INBOARD SEAT TRACK BETWEEN FRAME 6305 AND 6805. REPAIRED IAW FOKKER SRM 51-10-04, PARAGRAPH 4.SDR QXEA0000097Seat Track · gougedPDX - NUMEROUS GOUGES IN LEFT-HAND OUTBOARD SEAT TRACK BETWEEN FRAME 6805 AND 7305. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4.SDR QXEA0000095Seat Track · corrodedPDX - FRETTING CORROSION ON LEFT-HAND OUTBOARD SEAT TRACK AT STATION 4900. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4.SDR QXEA0000051Seat Track · gorgedPDX - RIGHT OUTBOARD SEAT TRACK GOUGED .010 DEEP BETWEEN FRAME 12875 AND 13345. REPAIRED IAW FOKKER SRM 53-40-01, PAGE 206, PARAGRAPH 4B, STEP 5.SDR MWEA99957Seat Track · wornCAPT'S AFT SEAT RAILS ARE WORN. MX FABRICATED AND INSTALLED NEW RAILS.SDR MWEA99956Seat Track · wornFIRST OFFICERS AFT SEAT RAILS ARE WORN. MAINTENANCE FABRICATED AND INSTALLED NEW RAILS.SDR MWEA99955Seat Track · corrodedNR 4 SEAT TRACK IS CORRODED FROM STATION 200 TO STATION 237. MAINTENANCE DRILLED AND INSTALLED NEW TRACK.SDR MWEA99954Seat Track · corrodedNR 3 SEAT TRACK IS MODERATELY CORRODED FROM STATION 200 TO STATION 237. MAINTENANCE DRILLED AND INSTALLED SEAT TRACK.SDR SIMA36414Seat Track · corrodedABI - FOUND CORROSION ON SEAT TRACK BEYOND LIMITS AT BL 0. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK AT BL 0. (M)SDR USAA991442Seat Track · corrodedCLT - DURING C-1 CHECK VISUAL INSPECTION, FOUND A 4 INCH BY 6 INCH AREA OF CORROSION AT STATION 377.7, LBL 24 SEAT TRACK. CORROSION LEVEL 1. REMOVED DAMAGED SEAT TRACK AND REPLACED PER SRM 51-10-00. (M)SDR USAA991441Seat Track · corrodedCLT - DURING C-1 CHECK VISUAL INSPECTION, FOUND A 4 INCH BY 6 INCH AREA OF CORROSION AT STA 377.7, LBL 45 SEAT TRACK, CORROSION LEVEL 1. REMOVED DAMAGED SEAT TRACK AND REPLACED PER SRM 51-20-=01 A01 AND SRM 51-10-00. (X)SDR USAA991422Seat Track · corrodedCLT - DURING C-1 CHECK VISUAL INSPECTION, FOUND A 4 INCH BY 6 INCH AREA OF CORROSION AT STA 377.4, LB7 24 SEAT TRACK, CORROSION LEVEL 1. REMOVED DEAMAGED SEAT TRACK AND REPLACED PER SRM 51-10-00. (X)SDR QXEA0000091Seat Track · gougedPDX - RIGHT-HAND INBOARD SEAT TRACK HAD TWO GOUGES APPROXIMATELY .020 DEEP, LOCATED JUST FORWARD OF FRAME 10346. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000090Seat Track · damagedPDX - RIGHT-HAND OUTBOARD SEAT TRACK HAS TOOL DAMAGE .300 LONG X .050 WIDE, LOCATED 10.5 AFT OF FRAME 9305C. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000087Seat Track · corrodedPDX - RIGHT-HAND OUTBOARD SEAT TRACK HAS SEVERAL AREAS OF EXPOSED METAL EXHIBITING LIGHT CORROSION BETWEEN FRAMES 4610 AND 7305. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000086Seat Track · corrodedPDX - RIGHT-HAND SEAT TRACK HAS SEVERAL AREAS OF EXPOSED METAL EXHIBITING LIGHT CORROSION BETWEEN FRAMES 4610 AND 7305. REPAIRED IAW FOKKER SRM 51-10-04 AND SRM 53-40-01, PAGE 201.SDR QXEA0000085Seat Track · corrodedPDX - AREA OF EXPOSED METAL EXHIBITING LIGHT CORROSION APPROXIMATELY 1 X 1 LOCATED JUST FORWARD OF FRAME 13815 ON RIGHT-HAND INBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 51-10-04.SDR CALA9901709Seat Track · corrodedINSPECTION FOUND SEAT TRACK SECTIONS CORRODED AT STA 380-420, RBL 40 AND STA 990-1030, RBL 48. THE SEAT TRACK SECTIONS WERE REMOVED AND REPLACED IAW SRM 51-30-2, 51-10-2, AND MM 51-20-0.SDR CALA9901694Seat Track · corrodedINSPECTION FOUND RT O/B SEAT TRACK CORRODED FROM STA 1030-1070. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-2.SDR CALA9901692Seat Track · corrodedINSPECTION FOUND RT O/B SEAT TRACKS CORRODED AT STA 990-1030 AND 950B-970. THE SEAT TRACK SECTIONS WERE REMOVED AND REPLACED IAW SRM 51-30-2.SDR CALA9901653Seat Track · corrodedINSPECTION FOUND LT O/B SEAT TRACK CORRODED FROM STA 950-1038. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-2, 51-10-4, 51-10-2, 51-30-2.SDR QXEA9902728Seat Track · corrodedPDX - CORROSION ON INBOARD FLANGE OF LEFT INBOARD SEAT TRACK JUST FORWARD OF FRAME 9305B. REPAIRED IAW FOKKER SRM 51-10-4.SDR QXEA9902727Seat Track · corrodedPDX - CORROSION ON INBOARD FLANGE OF LEFT INBOARD SEAT TRACK BETWEEN FRAMES 9305 AND 9305A.SDR QXEA9902725Seat Track · corrodedPDX - CORROSION ON INBOARD FLANGE OF LEFT INBOARD SEAT TRACK BETWEEN FRAME 8305 AND 8805. REPAIRED IAW FOKKER SRM 51-10-4.SDR QXEA9902708Seat Track · corrodedPDX - CORROSION IN CENTER OF LEFT OUTBOARD SEAT TRACK BETWEEN 9305C AND 9805. REPAIRED IAW FOKKER SRM 51-10-4.SDR QXEA9902707Seat Track · corrodedPDX - CORROSION ON BOTTOM SIDE OF FLANGE, LEFT INBOARD SEAT TRACK, FORWARD OF FRAME 9305C. REPAIRED IAW FOKKER SRM 51-10-4.SDR QXEA9902706Seat Track · gougedPDX - SEVERAL GOUGES IN CENTER OF LEFT OUTBOARD CABIN SEAT TRACK BETWEEN FRAMES 8205 AND 8805. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA9902705Seat Track · corrodedPDX - CORROSION IN SEVERAL PLACES ON LEFT OUTBOARD SEAT TRACK FLANGE BETWEEN FRAMES 8305 AND 8805. REPAIRED IAW FOKKER SRM 51-10-4.SDR QXEA9902704Seat Track · gougedPDX - GOUGES IN LEFT OUTBOARD SEAT TRACK BETWEEN FRAME 7805 AND 8305. REPAIRED IAW F-28 SRM 51-10-04.SDR QXEA0000108Seat Track · corrodedPDX - CORROSION ON INBOARD FLANGE OF LEFT-HAND SEAT TRACK BETWEEN FRAMES 7805 AND 8305. REPAIRED IAW FOKKER SRM 51-10-4.SDR QXEA0000101Seat Track · gougedPDX - GOUGES IN CENTER OF LEFT-HAND OUTBOARD SEAT TRACK, 4 AFT OF FRAME 14755. REPAIRED IAW FOKKER SRM 51-10-4.SDR QXEA0000100Seat Track · corrodedPDX - FRETTING CORROSION ON OUTBOARD FLANGE OF THE LEFT-HAND INBOARD SEAT TRACK BETWEEN FRAMES 13815A AND 13815B. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000099Seat Track · gougedPDX - GOUGES IN LEFT-HAND OUTBOARD SEAT TRACK, 5 AFT OF FRAME 13815A. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000098Seat Track · gougedPDX - GOUGES IN LEFT-HAND OUTBOARD SEAT TRACK AT FRAME 13815A. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000059Seat Track · gougedPDX - GOUGE IN LEFT OUTBOARD SEAT TRACK BETWEEN FRAME 13815 AND 13815A. REPAIRED IAW FOKKER SRM 53-40-01, PAGE 201 AND SRM 51-10-4.SDR QXEA0000058Seat Track · gougedPDX - GOUGE IN CENTER OF LEFT INBOARD SEAT TRACK, 8 FORWARD OF FRAME 13345. REPAIRED IAW FOKKER SRM 53-40-01, PAGE 201, 202 AND 206, FIGURE 205, AND SRM 53-40-01, PAGE 205.SDR AT0000020Seat Track · corrodedRT INBOARD SEAT TRACK CORRODED AT BS 900 TO 965. REMOVED AND REPLACED SEAT TRACK FROM BS 878 TO 965 IAW DC9 SRM 51-10-3, 53-05 FIG 4 AND 53-20-1.SDR 2000ZZZX199Seat Track · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON SEAT TRACK BS 1070 RBL 24.75 AND LBL 24.75.SDR TWAA0000413Seat Track · corrodedDURING CHECK-C MAINT, FOUND CORROSION ON FWD OTBD END OF TRACK, RBL 22 AROUND BLANK HOLE. REMOVED CORROSION 0.020, WHICH WAS WITHIN SRM 53-05 LIMITS, FROM BLANK HOLE AT END OF TRACK PER SPM 6-80-1 AND TREATED OUTER FLANGE HOLE PER SRM 51-10-3, PARA 3D. FINISSDR QXEA9902687Seat Track · chafedPDX - RIGHT INBOARD SEAT TRACK CHAFFED AND LUG LIP WORN AT APPROXIMATELY STATION 282. REPAIRED IAW DHC-8 SRM 51-40-00.SDR CALA9901632Seat Track · corrodedINSPECTION FOUND LT I/B SEAT TRACK CORRODED FROM STA 950-990, LBL 24 AND FROM STA 1070-1110, LBL 24. THE SEAT TRACK SECTIONS WERE REMOVED AND REPLACED IAW SRM 51-30-2, 51-20-0, AND 51-10-2.SDR ASAA9980321Cargo Track · corrodedPHX - DURING 30K CHECK, THE AFT CARGO COMPARTMENT TIEDOWN TRACK, TOP AND BOTTOM WAS FOUND CORRODED AT STATION 1007-1155 ABOVE LONGERON 27R. REPAIRED PER SRM 53-01. (M)SDR ASAA9980320Cargo Track · corrodedPHX - DURING 30K CHECK, THE AFT CARGO COMPARTMENT TIEDOWN TRACK, TOP AND BOTTOM, WAS FOUND CORRODED AT STATION 1007-1222, BL 16L. REPLACED TRACK PER SRM 53-01 AND 53-05, FIG 4G. (M)SDR ASAA9980319Cargo Track · corrodedPHX - DURING 30K CHECK, THE AFT CARGO COMPARTMENT TIEDOWN TRACK, TOP AND BOTTOM, WAS FOUND CORRODED AT STATION 1212-1322, BL 16R. REPLACED TRACK PER SRM 51-31-0. (M)SDR SAA9980318Cargo Track · corrodedPHX - DURING 30K CHECK, THE AFT CARGO COMPARTMENT TIEDOWN TRACK, TOP AND BOTTOM, WAS FOUND CORRODED AT STATION 1222-1322, BL 16. REPAIRED PER SRM 53-05, FIG 4C AND SRM 53-20-0, FIG 11. (M)SDR ASAA9980317Seat Track · corrodedPHX - DURING 30K CHECK, THE LEFT INBOARD TRACK WAS FOUND CORRODED ON THE EDGE AND INSIDE WEB OF THE TRACK AT APPROXIMATELY STATION 1041. REPAIRED AND REPLACED TRACK FROM STATION 1032 TO 1241 WITH SPLICES PER SRM 53-05, FIG 4F. (M)SDR ASAA9980316Seat Track · corrodedPHX - DURING 30K CHECK, THE LEFT OUTBOARD TRACK WAS FOUND CORRODED AT STATION 1155. REPAIRED AND REPLACED SEAT TRACK, STATION 1030 TO 1220, LEFT OUTBOARD, PER SRM 53-05, FIG 4. (M)SDR ASAA9980315Cargo Track · corrodedPHX - DURING 30K CHECK, THE AFT CARGO COMPARTMENT TIEDOWN TRACK, FORWARD END HAS THREE CORRODED FASTENERS AND NUTPLATES, STATION 1011, BL 6. REPAIRED PER SRM 51-30. (M)SDR TWAA0000602Seat Track · corrodedDURING OP 16 MAINT CHECK, FOUND CABIN FLOOR TRACK WITH CORROSION AT RBL 45 IN, STA 200 TO 229. REMOVED OLD PART OF TRACK AND INSTALLED NEW PIECE PER SRM 53-05, FIG 4.
Back to JASC 5347