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 QXEA0003106Seat Track · corrodedPDX-RIGHT HAND INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL JUST AFT OF FRAME AT STATION 9805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-1, PAGE 205.SDR QXEA0003105Seat Track · corrodedPDX-RIGHT HAND INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL JUST AFT OF FRAME AT STATION 9305. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-1, PAGE 205.SDR QXEA0003104Seat Track · corrodedPDX-RIGHT HAND INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL AT STATION 8605. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-1, PAGE 205.SDR QXEA0003103Seat Track · corrodedPDX-RIGHT HAND INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL AT STATION 8305. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-1, PAGE 205.SDR QXEA0003102Seat Track · corrodedPDX-RIGHT HAND INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL AT STATION 7505. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-1, PAGE 205.SDR QXEA0003101Seat Track · corrodedPDX-RIGHT HAND INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL AT STATION 7805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-1, PAGE 205.SDR QXEA0003100Seat Track · corrodedPDX-RIGHT HAND INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL, UNDER LIP JUST FORWARD OF STATION 6805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-1, PAGE 205.SDR QXEA0003099Seat Track · corrodedPDX-RIGHT HAND INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL JUST FORWARD OF STATION 6305. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-1, PAGE 205.SDR QXEA0003098Seat Track · corrodedPDX-RIGHT HAND INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL JUST AFT OF STATION 5805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-1, PAGE 205.SDR QXEA0003097Seat Track · corrodedPDX-RIGHT HAND INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL JUST AFT OF STATION 5305. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-1, PAGE 205.SDR QXEA0003096Seat Track · corrodedPDX-RIGHT HAND OUTBOARD SEAT TRACK HAS CORROSION INSIDE CHANNEL AT STATION 7805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0003095Seat Track · corrodedPDX-RIGHT HAND OUTBOARD SEAT TRACK HAS CORROSION INSIDE CHANNEL AT STATION 7505. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0003094Seat Track · corrodedPDX-RIGHT HAND OUTBOARD SEAT TRACK HAS CORROSION INSIDE AT STATION 7050. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0003093Seat Track · corrodedPDX-RIGHT HAND OUTBOARD SEAT TRACK HAS CORROSION INSIDE CHANNEL FORWARD OF STATION 6805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0003092Seat Track · corrodedPDX-RIGHT HAND OUTBOARD SEAT TRACK HAS CORROSION INSIDE CHANNEL FORWARD OF STATION 6305. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0003091Seat Track · corrodedPDX-LEFT HAND INBOARD SEAT TRACK HAS CORROSION INSIDE CHANNEL AT STATION 14600. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-1, PAGE 205.SDR QXEA0003090Seat Track · corrodedPDX-LEFT HAND INBOARD SEAT TRACK HAS CORROSION INSIDE CHANNEL AT STATION 7000. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-1, PAGE 205.SDR USAA001970Seat Track · crackedSEAT TRACK CRACKED. INSTALLED SEAT TRACK AND FLOOR SUPPORTSSDR TWAA0018614Seat Track · corrodedDURING CHECK-C MAINT FOUND FASTENER HOLES CORRODED FOR FLOOR AND SIDE WALL PANELS AT LT FLOOR TRACK STA 1221 THRU 1322. REPAIRED PER SRM 53-05, FIG 4G.SDR TWAA0018603Seat Track · corrodedDURING CHECK-C MAINT THE GALLEY FLOOR TRACK AT LBL 22 HAD MANY CORROSION AREAS AT PANEL ATTACH HOLES, STA 1200 TO 1309. NUMBER 3 SEAT TRACK REPLACED FROM STA 1125 TO 1309, LBL 27, PER SRM 53-05, PAGE 10G.SDR AWXA0000895Seat Track · corrodedAFT GALLEY STA 986 - 1016 RBL 18 SEAT TRACK HAS CORROSION. REMOVED CORROSION IAW SRM 53-60-52 FIG 101; ORG MATERIAL .070 INCH MATERIAL LOST .450 INCH OUT OF LIMITS TO BE REPLACED ON N/R 5366844.SDR AWXA0000894Seat Track · damagedCABIN SEAT TRACK AT LBL 24 STA 480 - 500D WAS FOUND OUT OF LIMITS. REMOVED SEAT TRACK IAW SRM 51-40-02; MACHINED TRACK IAW 53-00-52; FABBED TRACK (R812808) IAW 53-30-52; INSTALLED TRACK IAW 51-40-02 (BAC1520-792/71T6).SDR AWXA0000892Seat Track · gougedMAIN DECK SEAT TRACK GOUGED LBL 24. 5 INCHES FWD OF STA 500D, 9 INCHES FWD OF STA 500A, 14 INCHES FWD STA 460. REMOVED SEAT TRACK IAW SRM 51-40-02 AT STA 460 - 500D LBL 24; MACHINED TRACK IAW 53-00-52; FABBED TRACK (R812808) IAW 53-30-52; INSTALLED TRACK IAW SDR MALA000670Seat Track · corrodedFOUND DURING 4K-CHECK INSPECTION FOUND RT CENTER AISLE SEAT TRACK INBD/OTBD TOP FLANGES CORRODED IN CARGO AREA. APPROXIMATELY STA 640-685. MAINTENANCE PERFORMED PERMANENT REPAIR IAW EL S53078.SDR MALA000669Seat Track · wornFOUND DURING 4K-CHECK, LT CENTER AISLE SEAT TRACK IB AND OB IP FLANGES CORRODED. MAINTENANCE PERFORMED PERMANENT REPAIR IAW EO 53078.SDR MWEA001161Seat Track · corrodedNR 1 SEAT TRACK AT STATION 490 HAS AREA OF SEVERE CORROSION. FABRICATED AND INSTALLED REPAIR PLUG.SDR CALA0001778Seat Track · corrodedINSPECTION FOUND LT CENTER SEAT TRACK CORRODED AT FS 788 - 1258. THE SEAT TRACK SECTION WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-3, AND 53-05, FIGURE 4F.SDR TWAA0018507Galley Track · corrodedDURING CHECK-C MAINT, THE GALLEY FLOOR TRACK AT LBL 42 HAD MANY CORRODED AREAS AT STA 1200 TO 1315. REPLACED TRACK WITH NEW USING FASTENERS PER SPM 6-30-07 AND RIVETS PER SRM 51-30-02.SDR TWAA0018007Galley Track · corrodedDURING CHECK-C MAINT FOUND CORROSION UNDER G2 GALLEY, AT AREA OF FLOOR TRACK NUMBER 5, STA 237. REMOVED CORRODED TRACK FROM STA 200 TO 246. SPLICED IN NEW SECTION PER SRM 53-05, FIG 4F.SDR QXEA0003058Seat Track · corrodedYXX- LEFT HAND INBOARD AFT SEAT TRACK TOP SURFACE HAS VARIOUS SPOTS OF CORROSION BETWEEN X548 AND X593. REPAIRED IAW DHC-8 SRM 51-40-11, PAGE 1-4 AND HORIZON AIR RD8-53-784.SDR L1GA200000424Cargo Track · corrodedCORROSION AROUND FASTENER HOLES ON FWD PIT TIE DOWN TRACK. REPLACED WITH NEW IDENTICAL PART.SDR L1GA200000510Cargo Track · damagedA 152 INCH SECTION WITH ELONGATED HOLES FWD CARGO FS 218 - 370 LT TRACK. FABBED NEW TRACK.SDR L1GA200000498Cargo Track · corrodedA 120 INCH OF CORROSION AFT CARGO LT TRACK FS 790 - 910. FABBED NEW TRACK.SDR L1GA200000497Cargo Track · corrodedA 175 INCH STRIP OF CORROSION AFT CARGO RT TRACK FS 775 - 900.SDR L1GA200000328Seat Track · corrodedA 137 SQ INCH AREA 7 SPOTS OF CORROSION. SPLICED IN REPAIR TRACK.SDR L1GA200000449Seat Track · corrodedA 114 INCH SECTION WITH 8 CORRODED AREAS AT FS 408 TO 522 RBL 22 SEAT TRACK. SPLICED IN SECTION OF NEW SEAT TRACK.SDR L1GA200000448Seat Track · corrodedA 27 INCH AREA OF CORROSION FS 200 TO 227 RBL 44 SEAT TRACK. SPLICED REPAIR.SDR CALA0001765Seat Track · corrodedINSPECTION FOUND RIGHT I/B SEAT TRACK CORRODED AT STA 200 - 266, RBL 22. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 53-01, FIGURE 4F, 51-10-3, AND 53-05, FIGURE 4F.SDR CALA0001759Cargo Track · corrodedINSPECTION FOUND MID CARGO RIGHT TIE DOWN TRACK CORRODED AT STA 693 - 786. THE TIE DOWN TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-10-3, 51-10-4, AND 51-30-1.SDR CALA0001758Seat Track · corrodedINSPECTION FOUND LEFT O/B SEAT TRACK CORRODED AT FS 1031 - 1089. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-5, 51-30-1, 51-10-4, 51-30-2, AND 51-10-3.SDR CALA0001752Seat Track · corrodedINSPECTION FOUND RIGHT O/B SEAT TRACK CORRODED AT FS 200 - 265. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4F, 51-30-2, 51-30-5, 51-30-1, 51-10-4, AND 51-10-3.SDR GAIA00705Seat Track · crackedDURING A ROUTINE HEAVY MAINTENANCE CHECK AT FLIGHT STAR AIRCRAFT SERVICES AT JAX, IT WAS DISCOVERED THAT THE BS520 SEAT TRACK, LBL 45 WAS CRACKED.ACCOMPLISHED REPAIR IAW BOEING SRM 53-10-5. A/C WAS RETURNED TO SERVICE.SDR GAIA00700Seat Track · gougedDURING A ROUTINE HEAVY MAINTENANCE CHECK AT FLIGHT STAR AIRCRAFT SERVICES AT JAX, IT WAS DISCOVERED THAT THE SEAT TRACK AT BS440, LBL 24 WAS GOUGED.ACCOMPLISHED REPAIR IAW BOEING SRM 53-10-2. A/C WAS RETURNED TO SERVICE.SDR GAIA00699Seat Track · gougedDURING A ROUTINE HEAVY MAINTENANCE CHECK AT FLIGHT STAR AIRCRAFT SERVICES AT JAX, IT WAS DISCOVERED THAT THE SEAT TRACK AT BS720 TO 740, LEFT SIDE WAS GOUGED. ACCOMPLISHED REPAIR IAW BOEING SRM 53-10-2. A/C WAS RETURNED TO SERVICE.SDR GAIA00698Seat Track · gougedDURING A ROUTINE HEAVY MAINTENANCE CHECK AT FLIGHT STAR AIRCRAFT SERVICES AT JAX, IT WAS DISCOVERED THAT THE SEAT TRACK AT BS 1170 TO 1110, RBL 45 WAS GOUGED.ACCOMPLISHED REPAIR IAW BOEING SRM 53-10-2. A/C WAS RETURNED TO SERVICE.SDR GAIA00697Seat Track · gougedDURING A ROUTINE HEAVY MAINTENANCE CHECK AT FLIGHT STAR AIRCRAFT SERVICES AT JAX, IT WAS DISCOVERED THAT THE SEAT TRACK AT BS760 LBL 48 WAS GOUGED.ACCOMPLISHED REPAIR IAW BOEING SRM 53-10-2. A/C WAS RETURNED TO SERVICE.SDR GAIA00696Seat Track · gougedDURING ROUTINE HEAVY MAINTENANCE CHECK AT FLIGHT STAR AIRCRAFT SERVICES AT JAX, IT WAS DISCOVERED THAT THE SEAT TRACK AT BS364 LBL48 WAS GOUGED.ACCOMPLISHED REPAIR IAW BOEING SRM 53-10-2. A/C WAS RETURNED TO SERVICE.SDR CALA0001744Cargo Track · corrodedINSPECTION FOUND LT TIE DOWN RAIL CORRODED AT STA 1212 - 1322. A NEW SECTION OF TIE DOWN RAIL WAS INSTALLED IAW SRM 51-30.SDR SCNA00389Seat Track · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS RT SIDE SEAT TRACK BETWEEN STATIONS 420 AND 440 RBL 48. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED SECTION OF SEAT TRACK IAW B727 SRM 513002. FABRICATED NEW SEAT TRACK PER SAMPLESDR CALA0001736Seat Track · corrodedINSPECTION FOUND RIGHT I/B SEAT TRACK CORRODED AT STA 727E, RBL 19. THE CORRODED AREA WAS CUT OUT AND A REPAIR WAS INSTALLED IAW SRM 53-00-52, FIGURE 204.
Back to JASC 5347