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 USAA050274Seat Track · corrodedBFM - FOUND TRACK CORRODED 4 AREAS, TOTAL 8.5 SQUARE INCH, MAX D .060 INCH, FRAME 31-36, Y1959, MAIN CABIN FLOOR SEAT TRACK. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15. (M)SDR USAA050273Seat Track · corrodedBFM - FOUND TRACK CORRODED 11 AREAS TOTAL OF 14 SQUARE INCH MAX D .055 INCH, -Y 450, FRAME 58-68 MAIN CABIN FLOOR SEAT TRACK. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15. (M)SDR P5CA0501310Seat Track · brokenON PREFLIGHT FOUND BOTH SEAT TRACKS BROKEN ON THE F/O'S SEAT (AFT SEAT TRACK). REMOVED & REPLACED BOTH LT & RT AFT SEAT TRACKS PER AMM 25-11-00.SDR USAA050215Cargo Track · crackedPIT - FOUND CARGO FLOOR TIE DOWN CRACKED .125 INCH, FLOOR TIE DOWN RBBL 13.88 STATION 767 IN RADIUS. REMOVED AND REPLACED CARGO FLOOR TIE DOWN TRACK PER SRM 51-40-02. (M)SDR QXEA200500126Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK CORROSION APPROXIMATELY X 22.00. REPLACED IAW SRM 51-40-15 AND SRM 51-42-05-330-801.SDR 05FDEA00184Seat Track · damagedCABIN SEAT TRACK DAMAGED AT STA Y = 805, X = 48. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1, VOLUME I.SDR 05FDEA00183Seat Track · damagedCABIN SEAT TRACK DAMAGED AT STA Y = 805, X = -28. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1, VOLUME I.SDR 05FDEA00182Seat Track · damagedCABIN SEAT TRACK DAMAGED AT STA Y = 910, X = -48. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1, VOLUME I.SDR 05FDEA00181Seat Track · damagedCABIN SEAT TRACK DAMAGED AT STA Y = 910, X = 48. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1, VOLUME I.SDR 05FDEA00180Seat Track · damagedCABIN SEAT TRACK DAMAGED AT STA Y = 1029, X = 48. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1, VOLUME I.SDR CALA0500024Seat Track · corrodedINSPECTION FOUND LT MIDDLE SEAT TRACK CORRODED FROM STA 1022-1250, S18L. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 53-05, FIGURE 4F.SDR 05FDEA00179Seat Track · damagedCABIN SEAT TRACK DAMAGED AT STA Y = 1059, X = 48. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1, VOLUME I.SDR GUUA93353012505ASeat Track · brokenDURING SCHEDULED ROUTINE MX DISCOVERED RT SEAT TRACK FLOOR BOARD ATTACH TAB BROKEN AT FS 238. REPAIRED BROKEN RT SEAT TRACK FLOOR SUPPORT TAB AT FS 238.SDR IXXA0500201SSeat Track · wornDURING ROUTINE C-CHECK FOUND MAIN CABIN SEAT TRACK AT STATION 1220 -F- WORN. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, LOCATED, DRILLED, TREATED, PRIMED, AND INSTALLED REPAIR PARTS IAW DC8 SRM 53-2-3, AND 51-1-8SDR IXXA0500184SSeat Track · wornDURING ROUTINE C-CHECK FOUND FLIGHT DECK COURIER SEAT TRACKS FORWARD AND AFT WORN. REMOVED FASTENERS, AND DAMAGED SEAT TRACKS. RECEIVED NEW SEAT TRACKS, LOCATED, DRILLED AND INSTALLED NEW SEAT TRACKS IAW DC8 SRM 51-1-24 AND 51-3-1.SDR IXXA0500183SSeat Track · wornDURING ROUTINE C-CHECK FOUND FLIGHT DECK FLIGHT ENGINEER FORWARD AND AFT SEAT TRACKS WORN. REMOVED FASTENERS AND DAMAGED SEAT TRACKS. RECEIVED NEW SEAT TRACKS, LOCATED, DRILLED AND INSTALLED NEW SEAT TRACKS IAW DC8 SRM 51-3-0, 51-3-1, AND 51-1-21.SDR IXXA0500181SSeat Track · damagedDURING ROUTINE C-CHECK FOUND FLIGHT DECK FIRST OFFICER SEAT TRACKS AFT SET HOLES ELONGATED. REMOVED SEAT TRACKS. ORIGINAL THICKNESS WAS .125, REMOVED .040 MATERIAL, .080 REMAINING, OUT OF LIMITS. FABRICATED STRAPS FROM .040 THICK 301 STAINLESS STEEL. LOCATSDR USAA050178Seat Track · corrodedBFM - S1 - SEAT TRACK, (1.0, 1.0, 0.32 INCH D; 1.5, 1.0, .040 D), CORROSION; LEVEL 2; TASK J7-200-2580C, Y450, FR 58 TO 67. INSTALLED NEW SEAT TRACK IAW SRM. (K)SDR SIMA200503406Seat Track · corrodedFOUND LT FORWARD SEAT TRACK CORRODED. REPLACED SEAT TRACK IAW AMM. AIRCRAFT WAS RETURNED TO SERVICE. (K)SDR 05FDEA00171Seat Track · damagedSEAT TRACK AT CABIN STA 791 LBL 41.5 HAVE BOLTS INSTALLED WRONG. SEAT TRACK AT CABIN STA 791 LBL 41.5 REMOVED AS PER SRM 53-70-00 FIG 1 VOL I & SRM 51-31-01 VOL II. REPAIR SEAT TRACK & SPLICE, FABRICATED & INSTALLED AS PER SRM 53-70-00 FIG 1 VOL I & SRM 51-3SDR 05FDEA00170Seat Track · damagedSEAT TRACK AT CABIN STA 791 LBL 8.5 HAVE BOLTS INSTALLED WRONG. SEAT TRACK AT CABIN STA 745 TO STA 815 LBL 8.5 REMOVED AS PER SRM 51-31-01 VOL II. REPAIR SEAT TRACK, FABRICATED & INSTALLED AS PER SRM 53-70-00 FIG 1 VOL I & SRM 51-31-01 VOL II.SDR 05FDEA00169Seat Track · damagedCABIN SEAT TRACK DAMAGED AT STA Y = 1090, X = -48. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1, VOLUME I.SDR 05FDEA00168Seat Track · damagedCABIN SEAT TRACK DAMAGED AT STA Y = 1126, X = -48. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1, VOLUME I.SDR 05FDEA00167Seat Track · damagedCABIN SEAT TRACK DAMAGED AT STA Y = 6-80, X = -48. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1, VOLUME I.SDR 05FDEA00166Seat Track · damagedCABIN SEAT TRACK DAMAGED AT STA Y = 6-70 TO Y = 6-90, X = -8. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1, VOLUME I.SDR 05FDEA00165Seat Track · damagedCABIN SEAT TRACK DAMAGED AT STA Y = 1372, X = 48. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1, VOLUME I.SDR 05FDEA00164Seat Track · damagedCABIN SEAT TRACK DAMAGED AT STA Y = 1421, X = -8. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1, VOLUME I.SDR 05FDEA00157Seat Track · damagedCABIN SEAT TRACK AT STA 791 LBL 27.5 FOUND TO HAVE BOLTS INSTALLED WRONGLY. SEAT TRACK AT STA 740 TO STA 815 REMOVED AS PER SRM 51-31-01 VOL II. REPAIR SEAT TRACK & SPLICE FABRICATED AND INSTALLED AS PER SRM 53-70-00 FIG 1 VOL I & SRM 51-31-01 VOL II.SDR 05FDEA00156Seat Track · wornMAIN DECK SEAT TRACK RBL 107 FOUND WITH SCRATCHES AT STA 1189 TO STA 1223. DAMAGED SEAT TRACK AT MAIN DECK STA 1189 TO STA 1223 RBL 107 CUT AS PER SRM 53-70-00 FIG 1 VOL I & REMOVED AS PER SRM 51-31-01 VOL II. REPAIR SEAT TRACK & SPLICE, FABRICATED AND INSTASDR 05FDEA00155Seat Track · wornMAIN DECK SEAT TRACK RBL 107 FOUND WITH SCRATCHES AT STA 5-70 TO STA 1531. DAMAGED SEAT TRACK AT MAIN DECK RBL 107, STA 5-70 TO STA 1531 REMOVED AS PER SRM 51-31-01 VOL II. REPAIR SEAT TRACK, FABRICATED AS PER DWG A5A7084 & INSTALLED AS PER SRM 53-70-00 FIG SDR MWEA050018Seat Track · wornTHE FIRST OFFICER'S OUTBOARD AFT SEAT TRACK IS WORN AT THE LOCK PIN HOLES. REMOVED AND REPLACED TRACK ASSEMBLY.SDR QXEA200500377Seat Track · corrodedYYC - CABIN CENTER FLOOR SEAT TRACK NR 11 MINOR SURFACE CORROSION ON TRACK FITTING, FORWARD BAGGAGE BULKHEAD. REPAIRED IAW Q400 SRM 51-21-350-001, PARAGRAPH D.SDR QXEA200500201Seat Track · corrodedYYC - LEFTHAND OUTBOARD SIDE FACING SEATRAIL AT STATION 550 TO 569 HAD PITTING CORROSION. REPAIRED IAW CRJ700 REO 670-53-00-060, REV B AND HORIZON AIR EA R-53-266.SDR QXEA200500190Seat Track · corrodedYYC - RIGHT INBOARD SEAT RAIL, AT STATION X418, HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-00-001-001-A01, REO 670-53-00-060, REV B. AND HORIZON AIR EA R-53-266.SDR QXEA200500193Seat Track · corrodedYYC - RIGHT INBOARD SEAT RAIL, AT STATION X459, HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-00-001-001-A01, REO 670-53-00-060, REV B AND HORIZON AIR EA R-53-266.SDR QXEA200500197Seat Track · corrodedYYC - RIGHT INBOARD SEAT RAIL AT STATION 524 HAS PITTING CORROSION ON INSIDE SURFACE. REPAIRED IAW CRJ700 SRM 51-21-00-001-001-A01, REO 670-53-00-060, REV B. AND HORIZON AIR EA R-53-266.SDR QXEA200500195Seat Track · corrodedYYC - RIGHT INBOARD SEAT RAIL AT STATION X492 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-00-001-001-A01, REO 670-53-00-060, ERV B. AND HORIZON AIR EA R-53-266.SDR QXEA200500191Seat Track · corrodedYYC - RIGHT INBOARD SEAT RAIL, AT STATION X429, HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-00-001-001-A01, REO 670-53-00-060, REV B. AND HORIZON AIR EA R-53-266.SDR QXEA200500199Seat Track · corrodedYYC - RIGHT INBOARD SEAT RAIL AT STATION X571 HAS PITTING CORROSION ON INSIDE 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 QXEA200500198Seat Track · corrodedYYC - RIGHT INBOARD SEAT TRACK AT STATION X541 HAS PITTING CORROSION ON INSIDE 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 QXEA200500196Seat Track · corrodedYYC - RIGHT INBOARD SEAT RAIL AT STATION X510 HAS PITTING CORROSION ON INSIDE SURFACE. REPAIRED IAW CRJ700 SRM 51-21-00-001-001-A01, REO 670-53-00-060, REV B. AND HORIZON AIR EA R-53-266.SDR QXEA200500189Seat Track · corrodedYYC - RIGHT INBOARD SEAT RAIL, AT STATION X396, HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. 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 QXEA200500188Seat Track · corrodedYYC - RIGHT INBOARD SEATRAIL, AT STATION X349 TO X379, HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01, REO 670-53-00-060, REV B AND HORIZON AIR EA R-53-266, SECTION 1.SDR QXEA200500183Seat Track · corrodedYYC - LEFT OUTBOARD SIDE FACING SEAT RAIL AT STATION X708, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01, HORIZON AIR EA R-53-266 AND REO 670-53-00-060, REV B.SDR CALA0500021Seat Track · corrodedINSPECTION FOUND LEFT I/B CABIN SEAT TRACK CORRODED FROM STA 1022-1250, LBL 25. THE SEAT TRACK WAS REPLACED IAW SRM 53-05, FIGURE 4.SDR QXEA200500194Seat Track · corrodedYYC - RIGHT INBOARD SEAT RAIL, AT STATION X478 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-00-001-001-A01, REO 670-53-00-060, REV B AND HORIZON AIR EA R -53-266.SDR QXEA200500192Seat Track · corrodedYYC - RIGHT INBOARD SEAT RAIL, AT STATION X477, HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-0-001-001-A01, REO 670-53-00-060, REV B AND HORIZON AIR EA R-53-266.SDR QXEA200500185Seat Track · corrodedYYC - LEFT OUTBOARD SIDE FACING SEAT RAIL AT STATION X645 TO X661, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ-700 SRM 51-21-06-001-001-A01, REO 670-53-00-060. REV B AND HORIZON AIR EA R-53-266.SDR QXEA200500181Seat Track · corrodedYYC - LEFT OUTBOARD SIDE FACING SEAT RAIL AT STATION X796, HAS PITTING CORROSION ON INSIDE SURFACE. REPAIRED IAW CRJ SRM 51-21-06-001-001-A01 AND HORIZON AIR EA R-53-266.SDR QXEA200500186Seat Track · corrodedYYC - LEFT OUTBOARD SIDE FACING SEAT RAIL, AT STATION X613 TO X629, 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.
Back to JASC 5347