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 ASAA0380655Seat Track · corrodedOKC - DURING 30K CHECK, FOUND SEAT TRACK CORRODED. REPLACED SEAT TRACK. (M)SDR ASAA0380685Seat Track · corrodedOAK 15K CHECK, FOUND SEAT TRACK CORRODED AT FS 200-240. REMOVED DAMAGED SECTION AND SPLICED IN NEW PER SRM 53-05. (M)SDR ASAA0380681Seat Track · corrodedOAK - FOUND DURING 15K CHECK, SEAT TRACK IS CORRODED AT FS 200-220. REMOVED DAMAGED AREA AND SPLICED IN NEW TRACK PER SRM 53-05. (M)SDR ASOA03557Seat Track · corrodedDURING A C-CHECK IN BNA, THE RIGHT SEAT TRACKS FROM FS 36 TO FS 39 AND BETWEEN FS 39 AND FS 40, INCLUDING THE LEFT SEAT TRACK FROM FS 39 TO FS 41 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT SEAT TRACKS FROM FS 36 TO FS SDR SIMA200328807Seat Track · dirtyORD - WHILE TAXIING AIRCRAFT, CAPTAINS SEAT INTERMITTENTLY WOULD SLIDE BACK FROM A LOCKED POSITION. MAINTENANCE CLEANED DEBRIS FROM SLIDE TRACK. OPERATIONAL CHECK WAS GOOD AND AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR QXEA200301341Seat Track · corrodedRT OUTBOARD TRACK NR 12 SEAT ATTACH AREA CORROSION ON TOP AT APPROXIMATELY X518.00. REPAIRED IAW RD 8-53-3644.SDR QXEA200301342Seat Track · corrodedRIGHT OUTBOARD TRACK NR 12 SEAT ATTACH AREA CORROSION UNDER OUTBOARD LUG. REPAIRED IAW RD 8-53-3644.SDR QXEA200301349Seat Track · corrodedPDX - RIGHT INBOARD TRACK NR 8 SEAT ATTACH AREA CORROSION UNDER LUG OUTBOARD APPROXIMATELY X500.00. REPAIRED IAW RD 8-53-1339.SDR QXEA200301343Seat Track · corrodedRIGHT INBOARD TRACK NR 9 SEAT ATTACH AREA CORROSION AND BARE METAL BOTTOM APPROXIMATELY X541.00. REPAIRED IAW DASH 8-2 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA200301331Seat Track · corrodedPDX - LEFT OUTBOARD NR 1 SEAT TRACK CORROSION OUTBOARD LUG AND BARE METAL SEAT ATTACH AREA, APPROXIMATELY X312.00. REPAIRED IAW RD 8-53-1342.SDR QXEA200301330Seat Track · chafedPDX - RIGHT INBOARD TRACK NR 8 CHAFED IN BOTTOM FROM X446.00 TO X455.00 AND FROM X506.00 TO X515.00. REPAIRED IAW RD8-53-1339.SDR QXEA200301329Seat Track · corrodedPDX - RIGHT INBOARD TRACK NR 8 SEAT ATTACH AREA CORROSION BOTTOM OUTBOARD, APPROXIMATELY X487.00. REPLACED SEAT TRACK.SDR QXEA200301328Seat Track · corrodedPDX - LEFT OUTBOARD TRACK NR 1 SEAT ATTACH AREA CORROSION UNDER INBOARD AND OUTBOARD LUGS, APPROXIMATELY X393.00. REPAIRED IAW RD 8-53-1342.SDR QXEA200301327Seat Track · corrodedPDX - LEFT OUTBOARD TRACK NR 1 SEAT ATTACH AREA CORROSION UNDER INBOARD AND OUTBOARD LUGS, APPROXIMATELY X424.00. REPAIRED IAW RD 8-53-1342.SDR QXEA200301326Seat Track · corrodedPDX - LEFT OUTBOARD TRACK NR 2 SEAT ATTACH AREA HAS CORROSION TOP AND BOTTOM, APPROXIMATELY X487.00. REPAIRED IAW RD 8-53-1342.SDR QXEA200301325Seat Track · gougedLEFT OUTBOARD TRACK NR 2 TOP INBOARD EDGE GOUGED/NICKED, APPROXIMATELY X469.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-26.SDR QXEA200301324Seat Track · corrodedLEFT OUTBOARD TRACK NR 2 SEAT ATTACH AREA CORROSION UNDER INBOARD LUG, APPROXIMATELY X455.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-26.SDR QXEA200301323Seat Track · corrodedLEFT OUTBOARD NR 2 SEAT TRACK CORROSION IN SEAT ATTACH AREA TOP AND BOTTOM, APPROXIMATELY S438.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA200301322Seat Track · corrodedLEFT OUTBOARD TRACK NR 3 SEAT ATTACH AREA CORROSION AND BARE METAL APPROXIMATELY X541.00. REPAIRED IAW SRM 51-20-16 AND 51-20-36.SDR QXEA200301321Seat Track · corrodedLEFT OUTBOARD TRACK NR 3 SEAT ATTACH AREA CORROSION TOP APPROXIMATELY X525.00. REPAIRED IAW RD 8-53-1342 AND DHC-8 SRM 51-20-16 AND 51-20-26.SDR QXEA200301339Seat Track · damagedRIGHT HAND OUTBOARD TRACK NR 11 REQUIRES REPLACEMENT. REPLACED NR 11 SEAT TRACK IAW DHC-8-200 SRM 51-40-11.SDR QXEA200301338Seat Track · damagedRIGHT HAND OUTBOARD TRACK NR 10 REQUIRES REPLACEMENT. REPLACED SEAT TRACK IAW DHC-8-200 SRM 51-40-11.SDR QXEA200301337Seat Track · damagedNR 8 SEAT TRACK HAS A NR 6 RIVET HOLE BLOWN OUT ON BOTTOM FORWARD END IN SPLICE AREA THIRD HOLE AFT. REPAIRED IAW DHC-8 SRM 51-40-11 AND RD 8-55-4722.SDR QXEA200301279Seat Track · corrodedPDX- RT INBOARD SEAT TRACK NR 7 HAS DEEP PITTING CORROSION ON TOP RAIL AROUND FASTENER HOLES BETWEEN STATION X196 AND X202. REPAIRED IAW RD8-53-1339, RD8-53-1102, RD8-53-4473 AND SRM 51-40-11.SDR QXEA200301278Seat Track · corrodedPDX- LT HAND INBOARD SEAT TRACK NR 4 HAS DEEP PITTING CORROSION ON FLANGE AROUND RIVET HOLES BETWEEN STATION X195 AND X202. REPAIRED IAW RD8-53-1102, RD8-53-4473 AND SRM 51-40-11.SDR CALA0300588Seat Track · corrodedINSPECTION FOUND CENTER FLOOR RAIL CORRODED AT TOP AND INSIDE CHANNEL AT FLOOR STRAP AFT OF STA 847. THE FLOOR RAIL WAS REPAIRED IAW ECRA 5320-01603.SDR DHL2003807525Cargo Track · wornMAIN CARGO COMPT NR 2 TRACK LUGS WORN AT STA 1396.000. TRIMMED OUT WORN AREA IAW SRM 53-2-3 PG 17, FIG 6D. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED NEW PLUG WITH NEW FASTENERS ON MAIN CARGO COMPT NR 2 TRACK AT STA 1396.000 IAW SRM 53-2-3 PG 17SDR CALA0300583Cargo Track · corrodedINSPECTION FOUND LT TIEDOWN RAIL CORRODED AT STA 787, S26L. A NEW TIEDOWN RAIL WAS INSTALLED IAW SRM 51-40-02.SDR DHL2003807523Cargo Track · wornMAIN CARGO COMPT NR 1 TRACK LUG WORN AT STA 1120.000. CUT OUT NR 1 TRACK DAMAGED SECTION, STA 1120.000 IAW SRM 53-2-3 PG 17, FIG 6D. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG AND CHANNEL IAW SRM 53-2-3 PG 17, FIG 6D, SRM 51-3-0 PGSDR DHL2003807524Plug · wornMAIN CARGO COMPT NR 4 TRACK PLUGS LUGS WORN, STA 865.000. REMOVED WORN PLUG OF NR 4 TRACK, STA 865.000 IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG IAW SRM 51-3-0 PG 1.SDR AALA20031150Seat Track · corrodedTUL - FOUND CORROSION IN SEAT TRACK CHANNEL AND AROUND FASTENERS TRACK. REMOVED CORRODED SECTION OF NR 4 SEAT TRACK AND SPLICED IN NEW SECTION PER SRM 53-00-52-2 AND PER ESP 90309. (M)SDR QXEA200301283Seat Track · corrodedPDX-LEFT INBOARD TRACK NR 5 SEAT ATTACH AREA CORROSION UNDER OUTBOARD LUG. REPAIRED IAW RD8-53-1339.SDR QXEA200301282Seat Track · corrodedPDX-LEFT INBOARD TRACK NR 5 SEAT ATTACH AREA CORROSION BETWEEN INBOARD X487.00. REPAIRED IAW RD8-53-1339.SDR QXEA200301284Seat Track · chafedPDX-LT INBOARD TRACK NR 5 BOTTOM OF TRACK CHAFED FROM X445 TO X455 AND X507 TO X515. REPAIRED IAW RD8-53-1339.SDR CALA0300579Cargo Track · corrodedINSPECTION FOUND FORWARD BAGGAGE BIN RT AFT CARGO TRACK CORRODED AT ATTACH SCREWS IN THREE PLACES FROM STA 465-503. THE CARGO TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-01.SDR CALA0300578Seat Track · corrodedINSPECTION FOUND RT SEAT TRACK CORRODED AT STA 910-927. THE SEAT TRACK WAS REMOVED AND REPLACED USING SPLICES AND FILLER IAW SRM 53-00-52, FIGURE 204.SDR ASAA0380611Seat Track · corrodedOKC - FOUND 15K CHECK, CABIN SEAT TRACK IS CORRODED AT FS 1098-1217. REPLACED SEAT TRACK PER SRM 53-05. (M)SDR AWXA200301310Seat Track · corrodedDURING C-15 CHECK CORROSION WAS FOUND ON UPPER FLANGE OF SEAT TRACK AT LBL 45, BS 540 TO 727. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUT OUT SEAT TRACK AT LBL 45, BS 584.5-596.5; FABRICATED A NEW REPLACEMENT SECTION OF SEATSDR AWXA200301309Seat Track · corrodedLCQ - MINOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON UPPER FLANGE OF SEAT TRACK AT LBL 45, BS 767-947. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT SEAT TRACK AT LBL 45, BS 767-947; FABRICATED A NEW REPLACEMENT SESDR QXEA200301281Seat Track · corrodedPDX-LT INBOARD TRACK NR 6 HAS CORROSION AROUND NUT PLATE AT STATION X564.00 AND X580.00. REPAIRED IAW RD8-51-103 AND SRM 51-40-11.SDR CALA0300577Seat Track · corrodedINSPECTION FOUND RT IB CABIN SEAT TRACK CORRODED AT STA 916-935. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52, FIGURE 204.SDR MWEA030411Seat Track · corrodedLOWER SIDE OF NR 2 SEAT TRACK IS CORRODED AT NUTPLATE, APPROXIMATELY STATION 1268. REMOVED AND REPLACED REPAIR PLUG.SDR MALA030461Seat Track · corrodedDURING C2 INSPECTION IN CWA, FOUND SEAT TRACK NR 3 CORRODED. MAINTENANCE CARRIED OUT EO A53026 ON SEAT TRACK NR 3. REFER TO LOG PAGE 189910 FOR DETAIL. A/C RELEASE DATE 10/12/03.SDR IXXA060561SSeat Track · misrepairedDURING ROUTINE C CHECK, FOUND FIRST OFFICER FORWARD OUTBOARD SEAT TRACK HAS IMPROPER REPAIR. REMOVED EXISTING REPAIR. FABRICATED REPAIR PARTS, LOCATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED REPAIR PARTS IAW DC8 SRM 53-2-351-1-8, AND 51-1-20D.SDR AWXA200301281Seat Track · corrodedDURING C-17 CHECK CORROSION WAS FOUND ON SEAT TRACK FROM BS 440 TO BS 500A, RBL 45. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED SEAT TRACK FROM BS 360 TO BS 500A, RBL 45; FABRICATED A NEW REPLACEMENT SEAT TRACK; INSTASDR AWXA200301280Seat Track · corrodedDURING C-17 CHECK CORROSION WAS FOUND ON SEAT TRACK BS 887 TO BS 947, LBL 45. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED SECTION OF SEAT TRACK BS 887 TO BS 947, LBL 45; FABRICATED A NEW REPLACEMENT SECTION OF SSDR AWXA200301278Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK CORROSION WAS FOUND ON SEAT TRACK FROM BS 460 TO BS 480, RBL 25. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED SECTION OF SEAT TRACK FROM BS 460 TO BS 480, RBL 25; FABRICATED ASDR AWXA200301277Seat Track · corrodedDURING C-17 CHECK GALVANIC CORROSION WAS FOUND ON SEAT TRACK FROM BS 827 TO BS 867, LBL 45. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED CORRODED SEAT TRACK FROM BS 807 TO BS 867, LBL 45; FABRICATED A NEW REPLACEMENT SECTISDR UPS03841438Seat Track · corrodedINSPECTION TYPE:C3 AFT RT SEAT TRACK CORRODED AT STA 1680 I/B LOWER SIDE BLENDED SEAT TRACK TO 100 PERCENT MAT LOSS AND FOUND OUT OF LIMITS IAW DC8 53-2-0 FIG 1F. DRILLED, LOCATED NEW SEAT TRACK IAW DC8 SRM 51-1-24 AND 5 3-2-3. ALODINED AND PRIMED IAW DC8 SRSDR AWXA200301329Floorbeam · crackedDURING C-17 CHECK A .1875 INCH CRACK WAS FOUND ON FLOORBEAM AT FASTENER HOLE BS 727B, RBL 45. MAINTENANCE TRIMMED OUT CRACK ON FLOORBEAM BS 727B, RBL 45; PERFORMED HFEC INSPECTION OF CUTOUT TO VERIFY NO CRACKS EXIST; FABRICATED A FILLER AND REPAIR STRAPS; INS
Back to JASC 5347