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 QXEA200500182Seat Track · corrodedYYC - LEFT OUTBOARD SIDE FACING SEAT RAIL, AT STATION X753, HAS PITTING CORROSION ON INNER AND MOST INBOARD SURFACES. REPAIRED IAW CRJ SRM 51-21-06-001-001-A01 AND HORIZON AIR EA R-53-266.SDR CALA0500020Seat Track · corrodedINSPECTION FOUND CAPTAIN'S AFT I/B SEAT TRACK CORRODED AT STA 83.55 - 101.55, LBL 10. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-01.SDR QXEA200500180Seat Track · corrodedYYC - RIGHT OUTBOARD SIDE FACING SEAT RAIL, AT STATION X810, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW SRM 51-21-06-001-001-A01 AND HORIZON AIR EA R-53-266.SDR QXEA200500187Seat Track · corrodedYYC - LEFT OUTBOARD SIDE FACING SEAT RAIL, AT STATION X581 TO X597, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01. REO 670-53-00-060, REV B, AND HORIZON AIR EA R-53-266.SDR QXEA200500184Seat Track · corrodedYYC - LEFT OUTBOARD SIDE FACING SEAT RAIL, AT STATION X676 TO X692, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01, REO 670-53-00-060, REV B AND HORIZON AIR EA R-53-266.SDR QXEA200500178Seat Track · corrodedYYC - RIGHT OUTBOARD SIDE FACING SEAT RAIL, AT STATION X753, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ REO 670-53-00-060, REV B AND HORIZON AIR EA R-53-226.SDR QXEA200500179Seat Track · corrodedYYC - RT OUTBOARD SIDE FACING SEAT RAIL, AT STATION X785 TO X797, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ REO 670-53-00-060, REV B AND HORIZON AIR EA R-53-266.SDR QXEA200500177Seat Track · corrodedYYC - RIGHT HAND OUTBOARD SIDE FACING SEAT RAIL AT STATION X739, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ 700 SRM 51-21-06-001-001-A01 AND HORIZON AIR EA R-53-266.SDR QXEA200500176Seat Track · corrodedYYC - RIGHT OUTBOARD SIDE FACING SEAT RAIL AT STATION X708, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW HORIZON AIR EA R-53-266 AND REO 670-53-00-060, REV B.SDR QXEA200500175Seat Track · corrodedYYC - RIGHT OUTBOARD SIDE FACING SEAT RAIL AT STATION X524 HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW HORIZON AIR EA R-53-266 AND REO 670-53-00-060, REV B.SDR 0500125523Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT BS 1640 LBL 24 AND 45.5. REPAIRED PER EA 55-20262.SDR 05FDEA00143Seat Track · wornMAIN DECK CARGO, SEAT TRACK BETWEEN STA Y= 879 TO Y= 929, X= -47.50 FOUND WORN. MAIN DECK CARGO, SEAT TRACK BETWEEN STA Y= 879 TO Y= 929, X= -47.50 CARRIED OUT REPAIR AS PER SRM 53-70-00 VOLUME I.SDR USAA050128Seat Track · corrodedBFM - FOUND DUMMY RAIL CORRODED 2.75 INCHES LONG BY 2 INCHES WIDE BY .035 INCHES DEEP, FRAME 13A, -Y953, -Z240. REMOVED AND REPLACED WITH NEW PART PER SRM 53-11-15 FIG 101. (M)SDR QXEA200500385Seat Track · gougedYYC - AFT FUSELAGE, AFT ENTRY DOOR SURROUND STRUCTURE FORWARD LATCH TRACK GOUGED, STATION 6680, STRINGER 17P.SDR LCQ40Seat Track · brokenCAPTAIN'S O/B SEAT TRACK HAS THE END PIECE BROKEN OFF. S/O 152051, OPS 29443, ZONE 6A-24.SDR USAA050187Seat Track · corrodedBFM - S1 CK - SEAT TRACK, (.75 X .25 X 0.030 D), CORROSION; LEVEL 2; TASK J7-200-2580, Y450, FR 68-70. INSTALLED NEW SEAT TRACK IAW SRM. (K)SDR USAA050186Seat Track · corrodedBFM - S1 CK - SEAT TRACK, (1.5 X 1.0 X 0.035 D) CORROSION; LEVEL 2; TASK NR J7-200-2580) Y450, FR 70-72. INSTALLED NEW SECTION OF SEAT TRACK IAW SRM. (K)SDR MALA050139Seat Track · corrodedDURING 6Y/4Y INSPECTION IN YYC, GALLEY SEAT TRACK P/N 7253721-459 IS CORRODED OUT OF LIMITS AND WILL BE REPLACED IAW SRM 51-40-27. AIRCRAFT RETURNED TO SERVICE 01/18/2005.SDR USAA050184Seat Track · corrodedBFM - S1 CHECK - SEAT TRACK, (3.0 X 0.50 X 0.03 AND 0.03 X 0.50 X 0.04); CORROSION; LEVEL 2; TASK J7-200-2580C SEAT TRACK, Y450, FR 53.7-55, Z240 MAIN CABIN FLOOR. INSTALLED NEW SEAT TRACK SECTION AND SPLICES IAW SRM. (K)SDR QXEA200500131Seat Track · corrodedPDX - CORROSION AROUND RIVETS ON LEFT HAND FORWARD INBOARD SEAT TRACK OUTER FLANGE FROM X19.4 TO X1.0. REPLACED IAW SRM 51-42-05-330-801.SDR QXEA200500125Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORROSION APPROXIMATELY X3.00. REPLACED IAW DHC-8 400 SRM 51-40-15 AND 51-42-05-330-801.SDR QXEA200500128Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORROSION APPROXIMATELY X68.00. REPLACED IAW SRM 51-40-15 AND SRM 51-42-05-330-801.SDR QXEA200500127Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORROSION APPROXIMATELY X40.00. REPLACED IAW SRM 51-40-15 AND 51-42-05-330-801.SDR QXEA200500124Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK HAS SCRATCH MARKS AND CORROSION INSIDE CHANNEL, 15 INCHES LONG AREA AT FUSELAGE STATION 90.00. REPAIRED IAW SRM 51-40-15.SDR QXEA200500130Seat Track · corrodedPDX - THE HOLES FOR THE LAV BOLTS HAVE CORROSION AROUND THEM ON THE RIGHT INBOARD FORWARD SEAT RAIL. REPLACED IAW DHC8/400 SRM 51-40-15 AND SRM 51-42-05-330-801.SDR QXEA200500129Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORROSION APPROXIMATELY X94.00. REPLACED IAW SRM 51-40-15 AND 51-42-05-330-801.SDR AWXA200500085Seat Track · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON LT OUTBOARD SEAT TRACK BETWEEN FR 40 AND FR 42. MAINTENANCE REMOVED CORRODED LT OUTBOARD SEAT TRACK FROM FR 40 TO FR 42; FABRICATED A NEW REPLACEMENT SEAT TRACK; INSTALLED REPAIR PART IAW SDR 05FDEA00117Seat Track · crackedTHE ONE RESTRANT (SECOND FROM CTR LINE) FOR POS 2R AFT IN MAIN CARGO COMPARTMENT IS INOP. S/M WILL NEED EXTENSIVE GROUND TIME TO PERFORM SEAT TRACK REPAIR. DUE TO FLT SCHEDULE ITEM REMAINS ON MEL. REPAIRED DAMAGED SEAT TRACK PER SRM 53-70-00 FIG 1.SDR USAA050134Floorboard · dentedBFM - FOUND FLOORBOARD WITH 3 DENTS, TWO CRACKS, 12 SQUARE INCHES, MAIN CABIN FLOOR PANEL 242 HF. REMOVED DAMAGED AREAS, FABRICATED REPAIR PATCH PER SRM 53-02-00. (M)SDR 05FDEA00105Seat Track · wornMAIN DECK CARGO, SEAT TRACK BETWEEN STA Y= 755 TO Y= 840, X= 47.50 FOUND WORN.CARRIED OUT REPAIR AS PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR ASAA0570011Seat Track · wornDURING MAINTENANCE CHECK FOUND FO IB AFT SEAT TRACK WORN. REPAIR IAW SRM. (K)SDR USAA050149Seat Track · corrodedBFM - FOUND TRACK CORRODED 2 INCH BY .7 INCH BY .033 INCH DEEP, FRAME 45, -Y450, MAIN CABIN FLOOR. REMOVED AND REPLACED SEAT TRACK PER SRM 53-31-15 FIG 101 SHT 8. CORROSION LEVEL 2, TASK NR J7-200-2578C. (M)SDR USAA050148Seat Track · corrodedBFM - FOUND TRACK CORRODED 2.3 INCH BY .4 INCH BY .032 INCH DEEP, FRAME 39.2 - Y450, MAIN CABIN FLOOR. REMOVED AND REPLACED SEAT TRACK PER SRM 53-31-15 FIG 101 SHT 8. (M)SDR USAA050147Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1.2 INCHES LONG BY .400 INCHES WIDE BY .045 INCH DEEP, FRAME 36-37 -Y450 -Z240. CUT OUT DAMAGED AREA AND REPLACED WITH NEW SEAT TRACK SECTION PER SRM 53-00-15 FIG 202. CORROSION LEVEL 2, TASK NR J7-900-09000-044. (M)SDR USAA050125Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, FRAME 37 PLUS Y450 - Z240. CUT OUT DAMAGED AREA AND REPLACED WITH NEW TRACK SECTION PER SRM 53-00-15 FIG 202. (M)SDR USAA050130Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, MAIN CABIN FLOOR -Y953 FRAME 52. REPLACED SECTION OF SEAT TRACK AND ADDED SPLICES PER SRM 53-31-15 FIG 101. CORROSION LEVEL 2, TASK NR J7-200-2578. (M)SDR ASOA05091Seat Track · corrodedDURING A C-CHECK, THE LT IB SEAT TRACK BETWEEN FR 13 TO 17 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LT IB SEAT TRACK BETWEEN FR 13 TO 17 IAW SRM. (K)SDR 05FDEA00088Seat Track · corrodedMAIN DECK CARGO, SEAT TRACK HORIZONTAL FLANGE UPPER SURFACE AT STA Y= 5-11 TO Y= 5-33, X= 75.25 FOUND FLOOR PANEL MOUNTING FOUND CORRODED AND WITH SHORT EDGE DISTANCE. CARRIED OUT REPAIR AS PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR AWXA200600163Seat Track · corrodedSAL - MAJOR REPAIR - DURING C-07 CHECK, CORROSION ON SEAT TRACK WAS FOUND AT Y 1292, BETWEEN FRAMES 15-AND 20 IN THREE PLACES. SEAT TRACK WAS REPLACED IAW AIRBUS SRM 51-72-11.SDR AWXA200600159Seat Track · corrodedSAL - DURING C-07 CHECK, CORROSION FOUND ON SEAT TRACK Y-1292 BETWEEN FRAME 15 AND FRAME 22 IN 5 PLACES. SEAT TRACK WAS REPLACED IAW A320 51-72-11 PAGE 1-2.SDR USAA050145Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1.5 INCH LONG BY .312 INCH WIDE BY .040 INCH DEEP, MAIN CABIN, FRAME 32-33.5, Y-1959. REMOVED AND REPLACED SEAT TRACK ASSEMBLY PER SRM 53-00-15, FIG 101, 51-42-11. (M)SDR USAA050127Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 3.70 INCH LONG BY 1.5 INCH WIDE BY .040 INCH DEEP, FRAME 47-53.1 +Y450 -Z240. REMOVED AND REPLACED WITH NEW SEAT TRACK PER SRM 53-31-15, FIG 101 AND 51-74-00. (M)SDR GTIA050023Seat Track · corrodedFOUND CABIN SEAT TRACKS LEFT OUTBOARD STATION 200-484750, STATION 1022-1307 NUMEROUS AREAS HAVE GOUGES AND CORROSION OUT OF LIMITS. REMOVED CORROSION, BLENDED GOUGES AND REPLACED OUT OF LIMIT SEAT TRACKS, PRIMED AND TREATED SEAT TRACKS. (M)SDR ASOA05090Seat Track · corrodedDURING A C-CHECK, THE SEAT TRACK BETWEEN FR 36 TO 39 ON THE RT SIDE WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK BETWEEN FR 36 TO 39 ON THE RT SIDE IAW SRM. (K)SDR AWXA200500089Seat Track · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON RT INBOARD SEAT TRACK BETWEEN FR 21 AND FR 24. MAINTENANCE REMOVED CORRODED RT INBOARD SEAT TRACK FROM FR 21 TO FR 24; FABRICATED A NEW REPLACEMENT SEAT TRACK; INSTALLED REPAIR PART IAWSDR AWXA200500087Seat Track · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK INTERGRANULAR CORROSION WAS FOUND ON LT INBOARD SEAT TRACK BETWEEN FR 42 AND FR 44. MAINTENANCE REMOVED CORRODED LT INBOARD SEAT TRACK FROM FR 42 TO FR 44; FABRICATED A NEW REPLACEMENT SEAT TRACK; INSTALLED REPAIR PART ISDR AWXA200500082Seat Track · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON CABIN FLOOR SEAT TRACK Y765 BETWEEN FR 20 AND FR 23. MAINTENANCE REMOVED AND REPLACED SEAT TRACK Y765 FROM FR 20 TO FR 23 IAW A320 SRM 51-72-11.SDR AWXA200500057Seat Track · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON CABIN FLOOR STRUCTURE SEAT TRACK Y1292 LT BETWEEN FS 20 AND FS 22. MAINTENANCE REMOVED CORRODED SEAT TRACK Y1292 LT FROM FS 20 TO FS 22; FABRICATED A NEW REPLACEMENT SEAT TRACK PER DWG D53112812; ISDR AWXA200500054Seat Track · corrodedSAL - MAJOR REPAIR - DURING C-4 CHECK EXFOLIATION CORROSION WAS FOUND ON LONGITUDINAL FLOORBEAM (DUMMY RAIL) -Y1379.5 RT AT FS 16. MAINTENANCE REMOVED CORRODED DUMMY RAIL -Y1379.5 RT AT FS 16; FABRICATED A NEW REPLACEMENT DUMMY RAIL; INSTALLED REPAIR PART IAWSDR 05FDEA00086Seat Track · corrodedMAIN DECK CARGO, SEAT TRACK BETWEEN STA Y= 1781 TO Y= 1801, X= 47.50 FOUND CORRODED. REPAIRED IAW SRM 51-2101.
Back to JASC 5347