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 MALA020513Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 4 SEAT RAIL SHOWS EVIDENCE OF CORROSION BETWEEN FRAME 18 AND 20. MAINTENANCE REPAIRED DAMAGE BY REPLACING SECTION IAW EO NR A53026 AND SRM 53-00-32.SDR MALA020512Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 3 SEAT RAIL SHOWS EVIDENCE OF CORROSION BETWEEN FRAME 18 & 20. MAINTENANCE DAMAGED REPAIRED BY REPLACING SECTION IAW EO A53026, AND SRM 53-00-32.SDR AWXA200200699Seat Track · corrodedLCQ - MAJOR REPAIR - DURING C-08 CHECK CORROSION WAS FOUND ON INBOARD SEAT TRACK FLOOR SUPPORT AT BS 1300 TO 1320, LBL 24. MAINTENANCE REMOVED CORRODED FLOOR SUPPORT AT BS 1300 TO 1320, LBL 24; FABRICATED A NEW FLOOR SUPPORT, AND INSTALLED REPAIR IAW B757-200 SDR AALA20021201Seat Track · corrodedTUL - FOUND CORROSION ON NR 2 SEAT TRACK. REPLACED NR 2 TRACK SECTION PER SRM 53-05 FIG 4. (M)SDR AWXA200200778Tie Clip · crackedLCQ - MAJOR REPAIR - DURING C-08 CHECK A 5/8" CRACK WAS FOUND ON FLOOR BEAM SUPPORT TIE CLIP BS 1320, AFT CARGO COMPARTMENT. MAINTENANCE REMOVED CRACKED FLOOR BEAM SUPPORT TIE CLIP BS 1320, FABRICATED A NEW FLOOR SUPPORT TIE CLIP, AND INSTALLED REPAIR IAW B75SDR AWXA200200777Tie Clip · crackedLCQ - MAJOR REPAIR - DURING C-08 CHECK A 3/4" CRACK WAS FOUND ON FLOOR BEAM SUPPORT TIE CLIP BS 1280, AFT CARGO COMPARTMENT. MAINTENANCE REMOVED CRACKED FLOOR BEAM SUPPORT TIE CLIP BS 1280, FABRICATED A NEW FLOOR SUPPORT TIE CLIP, AND INSTALLED REPAIR IAW B75SDR UPS02839247Seat Track · damagedINSPECTION TYPE:C2 CABIN FLOOR SEAT TRACK IS WORN AND BROKEN AT LBL 45 STA 1590-1600. REMOVED DAMAGED SEAT TRACK STA 1590 TO 1680 LBL 45, FABRICATED AND INSTALLED REPLACEMENT SEAT TRACK SECTION IAW SRM 53-2-3 FIG 8A.SDR 2002UALA01219Seat Track · damagedCABIN SEAT TRACK MOUNT FLANGE UPPER SURFACE HAS EXCESSIVE MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. REPLACED SEAT TRACK BEAM.SDR AAL2002F00024Seat Track · corrodedNR 4 SEAT TRACK CORRODED AT STA 237. INSTALLED SEAT TRACK PLUG IAW SRM.SDR AWXA200200725Cargo Track · crackedMCN - MAJOR REPAIR - DURING C-17 CHECK A CRACK WAS FOUND ON THE OUTBOARD SIDE OF AFT CARGO FLOOR TRACK FLANGE, BS 767, RBL 15. MAINTENANCE REMOVED DAMAGED SECTION OF FLOOR TRACK, FABRICATED A NEW SECTION OF FLOOR TRACK, AND INSTALLED REPAIR IAW B737-300 SRM 5SDR AUS20020747Seat Track · failed(AUS) CAPTAINS SEAT FAILED TO LOCK IN SEAT TRACKS. SEAT SLID COMPLETELY BACK DURING TAKEOFF.SDR AAL2002F00023Seat Track · corrodedNR 1 SEAT TRACK TOPSIDE AND GALLEY MOUNT HOLE CORRODED STA 1209. REMOVED CORROSION BY ROUTING OUT. INSTALLED PLUG REPAIR IAW SRM. TREATED AND PRIMED IAW SRM.SDR AAL2002F00022Seat Track · corrodedNR 1 SEAT TRACK GALLEY MOUNT CORRODED AT STA 1234. C/A: REMOVED CORROSION BY ROUTING OUT INSTALLED PLUG AS IAW SRM. TREATED AND PRIMED.SDR 0202413234Seat Track · corrodedDuring "L" check found corrosion on seat track at BS 765 between frames 18 and 20. Repaired per EA 32-191967.SDR CALA0200427Seat Track · corrodedINSPECTION FOUND L/H CENTER SEAT TRACK CORRODED AT STA 1070. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1 AND 51-30-2.SDR ABXA030223Seat Track · corrodedSEAT TRACK AT BUTT LINE 25 LEFT WAS CORRODED, FS 70 - 260. REMOVED WEB AND FLOORBOARDS FS 70 - 260, LEFT BUTT LINE 0 - 45 TO FOM. REMOVED SEAT TRACK SECTION. FABRICATED SECTION IAW ZANTOP DWG 86302. ALODINED AND PRIMED IAW DC-8 SRM 51-1-8. INSTALLED SEAT SDR QXEA0201128Seat Track · corrodedPDX- NR 1 LEFT HAND OUTBOARD SEAT TRACK BOTTOM HAS CORROSION AT STATION X297.0. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA0201089Seat Track · gougedPDX- NR 9 RIGHT HAND INBOARD SEAT TRACK NEEDS TO BE CLEANED AND PRIMED AT SEAT ATTACH POINTS. GOUGES IN BOTTOM OF TRACK AT STATION X531.0 AND X542.0. REPAIRED IAW DHC-8 RD 8-53-4936.SDR QXEA0201088Seat Track · gougedPDX- NR 5 LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE IS GOUGED AT STATION X436.0. REPAIRED IAW DHC-8 RD 8-53-833.SDR QXEA0201087Seat Track · chafedPDX- NR 5 LEFT HAND INBOARD SEAT TRACK BOTTOM IS CHAFED BY TRIM PIECES AT STATIONS X448.0, X480.0 AND X510.0. REPAIRED IAW DHC-8 RD 8-53-1239.SDR QXEA0201085Seat Track · corrodedPDX- NR 6 LEFT HAND INBOARD SEAT TRACK HAS CORROSION AROUND THE NUT PLATES AT STATIONS X546.0, X565.0 AND X581.0. REPAIRED IAW DHC-8 SRM 51-40-11, 51-20-16, 51-20-36 AND RD 8-53-784.SDR QXEA0201081Seat Track · corrodedPDX- NR 10 RIGHT HAND OUTBOARD SEAT TRACK BOTTOM HAS CORROSION AT STATION X374.0. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA0201080Seat Track · corrodedPDX- NR 10 RIGHT HAND OUTBOARD SEAT TRACK BOTTOM HAS CORROSION AT STATION X342.0. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA0201079Seat Track · corrodedPDX- NR 10 RIGHT HAND OUTBOARD SEAT TRACK BOTTOM HAS CORROSION AT STATION X328. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA0201078Seat Track · corrodedPDX- NR 10 RIGHT HAND OUTBOARD SEAT TRACK TOP HAS CORROSION AT STATION X296.0. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA0201077Seat Track · corrodedPDX- NR 10 RIGHT HAND OUTBOARD SEAT TRACK TOP HAS CORROSION AT STATION X265.0. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA0201076Seat Track · corrodedPDX- NR 1 LEFT HAND OUTBOARD SEAT TRACK TOP HAS CORROSION AT STATION X265.0. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA0201066Seat Track · corrodedPDX- NR 4 LEFT HAND INBOARD SEAT TRACK TOP HAS PITTING AT STATION X391.0. REPAIRED IAW DHC-8 RD 8-53-1339.SDR QXEA0201065Seat Track · chafedPDX- NR 4 LEFT HAND INBOARD SEAT TRACK BOTTOM CHAFED BY TRIM PIECES AT STATIONS X291.0, X320.0, X387.0 AND X410.0. REPAIRED IAW DHC-8 RD 8-53-1339.SDR QXEA0201064Seat Track · corrodedPDX- NR 7 RIGHT HAND INBOARD SEAT TRACK INBOARD FLANGE AT STATION X396.0 IS PITTED. REPAIRED IAW DHC-8 RD 8-53-833.SDR QXEA0201063Seat Track · corrodedPDX- NR 7 RIGHT HAND INBOARD SEAT TRACK AT STATION X406 HAS CORROSION ON BOTTOM. REPAIRED IAW DHC-8 RD 8-53-1339.SDR QXEA0201062Seat Track · corrodedPDX - NR 10 RIGHT HAND OUTBOARD SEAT TRACK BOTTOM CORROSION AT X406.0. REPAIRED IAW RD 8-53-1342.SDR SWIA200211159Seat Track · corrodedDISCOVERED DURING C-CHECK, LEFT AND RIGHT FWD FLOOR SEAT TRACKS ARE CORRODED. REMOVED AND REPLACED LEFT AND RIGHT FWD FLOOR SEAT TRACKS IAW 53-01-05.SDR SWIA200211158Seat Track · corrodedDISCOVERED DURING C-CHECK, LEFT AND RIGHT FWD AND AFT WALL SEAT TRACKS ARE CORRODED. REMOVED AND REPLACED LEFT AND RIGHT FWD AND AFT WALL SEAT TRACKS IAW 53-01-05.SDR QXEA0201090Seat Track · corrodedPDX- NR 9 RIGHT HAND INBOARD SEAT TRACK HAS CORROSION AT NUT PLATES AT STATION X533.0 AND X546.0. REPAIRED IAW DHC-8 RD 8-53-4936.SDR QXEA0201086Seat Track · corrodedPDX- NR 9 RIGHT HAND INBOARD SEAT TRACK HAS CORROSION AROUND NUT PLATES AT STATIONS X598.0 AND X565.0. REPAIRED IAW DHC-8 RD 8-53-4936.SDR CALA0200421Seat Track · corrodedINSPECTION FOUND R/H I/B SEAT TRACK CORRODED AT STA 200-228. THE SEAT TRACK SECTION WAS REPLACED IAW SRM 53-05, FIGURE 4F, SHEET 1.SDR CALA0200417Seat Track · corrodedINSPECTION FOUND L/H O/B SEAT TRACK CORRODED AT G-3 GALLEY ATTACH POINT. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1.SDR CALA0200415Seat Track · corrodedINSPECTION FOUND O/B SEAT TRACK CORRODED AT #4 GALLEY ATTACH POINT, FS 1180, LBL 54. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-10-4.SDR CALA0200405Seat Track · corrodedINSPECTION FOUND L/H CENTER SEAT TRACK CORRODED AROUND FLOOR PANEL MOUNT HOLES BETWEEN STA 1136 AND 1174. A NEW SEAT TRACK SECTION WAS INSTALLED IAW SRM 53-05.SDR QXEA0201040Seat Track · damagedPDX - FLOORBEAM SEAT TRACK NR 7 ATTACH HOLE OVERSIZED AT APPROXIMATELY 405.737 AND YR9.25. REPAIRED IAW HORIZON AIR EA 2-53-405, FIGURE 4.SDR QXEA0201039Seat Track · damagedPDX - FLOORBEAM SEAT TRACK NR 7 ATTACH HOLE IS OVERSIZED. REPAIRED IAW HORIZON AIR EA 2-53-405.SDR QXEA0200964Seat Track · corrodedPDX- PITTING CORROSION ON RIGHT HAND INBOARD SEAT TRACK NUMBER 7 AT STATION 182-222. REPAIRED IAW DHC-8 SRM 51-40-00, 51-40-11, RD 8-53-1339 AND RD 8-53-1102.SDR CALA0200401Seat Track · corrodedINSPECTION FOUND R/H I/B SEAT TRACK CORRODED AT STA 200-228. THE CORRODED SECTION OF SEAT TRACK WAS REPLACED IAW SRM 53-05, FIGURE 4F, SHEET 1.SDR QXEA0201032Seat Track · scratchedPDX - SCRATCH ON RIGHT HAND OUTBOARD SEAT TRACK NR 12 AT STATION 540. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0201031Seat Track · corrodedPDX - CORROSION ON RIGHT HAND OUTBOARD SEAT TRACK NR 12 AT STATION 528. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0201030Seat Track · corrodedPDX - LIGHT CORROSION ON RIGHT HAND OUTBOARD SEAT TRACK NR 11 AT STATION 515. REPAIRED IAW RD 8-53-3644 DHC-8-200 SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0201018Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS LIGHT PITS IN TOP FLANGE X520. REPAIRED IAW DHC-8-202 SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0201017Seat Track · nickedPDX - LEFT HAND OUTBOARD SEAT TRACK X504 HAS NICKS IN TOP FLANGE. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0201016Seat Track · nickedPDX - LEFT HAND OUTBOARD SEAT TRACK AT X484 HAS NICKS IN CHANNEL AND ON TOP FLANGE. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-41.
Back to JASC 5347