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 06FDEA0998Seat Track · corrodedMAIN DECK COMPARTMENT SEAT TRACK FOUND WITH CORROSION AT STATION 1741 - 1761 LBL 47. MAIN DECK COMPARTMENT CORRODED SEAT TRACK AT STATION 1741 - 1761 LBL 47. REMOVED AND REPLACED FROM STATION 1531 - 1887 LBL 47 AS PER SRM 51-31-01 VOLUME II WITH NEW SEAT TRASDR MALA060143Seat Track · corrodedSEAT TRACK AT LBL 18.3 IS CORRODED FROM FS 294 TO FS 339. REPAIRED IAW MESABA EOS53060.SDR DHL2006365500Seat Track · corrodedFLOOR TRACK SUPPORT BEAM AT STATION 1305 FR 16A AND LBL-78 AREA HAS SPOT OF CORROSION MARKED. REMOVED CORROSION AT FLOOR TACK SUPPORT BEAM AT STA 1305 FR 18A AND LBL 78 AS PER A300 SRM 51-40-11 FOUND OUT OF LIMITS AS OF PER A300 SRM 53-10-00. REMOVED AND REPSDR YENA200623Seat Track · corrodedON C4 CHECK, CORROSION ON SEAT TRACK LOCATED AT FR 20 AND FR 20 +3.5", FR 20 +19", Y-765. REPLACED SEAT TRACK LOCATED AT FR 20 AND FR 20 +3.5", FR 20 +19", Y-765, IAW SRM A320 51-72-11 PG 1.SDR 06FDEA0992Seat Track · corrodedFORWARD CABIN COMPARTMENT SEAT TRACK FOUND WITH CORROSION AT STATION 457.660 LBL 0. CORRODED EXISTING REPAIR SEAT TRACK ON FWD CABIN COMPARTMENT AT FS STATION 457.660 LBL 0 REMOVED AS PER SRM 51-31-01 VOL II. NEW REPAIR SEAT TRACK FABRICATED AND INSTALLED ASSDR QXEA200600790Seat Track · corrodedPDX C4, RIGHT HAND INBOARD SEAT TRACK NR 7 HAS CORROSION AT X202, X218-226 AND X265-273. REPAIRED IAW RD 8-53-4473.SDR MALA060209Seat Track · corrodedDURING 2 YEAR INSPECTION IN BNA, FOUND SEAT TRACK AT LBL 18.3, IS CORRODED BETWEEN FS 294.6 TO FS 339.0. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EO #S53060. REF: EAMS WORK ORDER 213523 TASK 1503.SDR MALA060141Seat Track · corrodedFOUND SEAT TRACK AT LBL 18.3 IS CORRODED BETWEEN FS 294.6 TO FS 339.0. REPAIRED IN ACCORDANCE WITH MESABA EO S53060. REF: EAMS WORK ORDER 213623 TASK 1503.SDR 06FDEA0989Seat Track · corrodedMAIN DECK COMPARTMENT SEAT TRACK FOUND WITH CORROSION AT STATION 1667 - 1691 LBL 75. CORROSION AT SEAT TRACK LOBE MAIN DECK COMPARTMENT STATION 1667 TO 1691 LBL 75 TRIMMED OUT AND CARRIED OUT REPAIR AS PER SRM 53-70-00 FIGURE 5 VOLUME I. REPAIR CLASSIFIED ASSDR MALA060140Seat Track · corrodedFOUND SEAT TRACK AT BL 0 IS CORRODED AT FS 294.6. REPAIRED IN ACCORDANCE WITH MESABA EO#S53060. REF: EAMS WORK ORDER 213623 TASK 1502.SDR 06FDEA0978Seat Track · corrodedMAIN CABIN BETWEEN STA 1901 TO 2007 X-107 FOUND CORROSION WITH EXFOLIATION INSIDE TRACK. FABRICATED PARTS IAW DETAIL PARTS TRAVELERS F166664/N00664 AND SRM 53-70-00 FIG 1 VOL 1. REMOVED PARTS IAW SRM 51-35-01 PAGE 1/13 AND SRM 51-33-01 PAGE 34/47 AND SRM 51-SDR DHL2006365502Seat Track · corrodedMAIN CABIN FLOOR BBL 54 LT BETWEEN FR 18 AND FR 20 SEAT TRACK HAS CORROSION 3 SPOTS. REMOVED CORROSION AT MAIN CABIN FLOOR BBL 54 LT BETWEEN FR 18 AN 20 SEAT TRACK AS PER A300 SRM 51-40-11 FOUND OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK PER A300 SRM 51-SDR 06FDEA0976Seat Track · corrodedMAIN DECK COMPARTMENT SEAT TRACK FOUND WITH CORROSION AT STATION 1239 - 1256 LBL 27. MAIN DECK COMPARTMENT SEAT TRACK STATION 6-100 TO STATION 1269 LBL 27. REPAIRED AS PER SRM 53-70-00 FIGURE I VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR USAA060431Seat Track · corrodedY1552.5 AT 4 INCHES AFT OF FR 33 CORRODED. REMOVED CORROSION, REPLACED SEAT TACK PER SRM 53-00-15 & 51-72-11, DEFECT SIZE: 2" X 0.5" X .038".SDR USAA060438Seat Track · corrodedY450 AT 15 INCHES FWD OF FR 58 CORRODED. REPLACED PER SRM 51-72-11, DEFECT SIZE: 2" X 1" X .036".SDR USAA060437Seat Track · corrodedY2462 AT FR 58 CORRODED. REPLACED SEAT TRACK PER SRM 51-72-11, DEFECT SIZE: 2" X .500" X .028".SDR USAA060436Seat Track · corrodedY450 AT 5 INCHES FWD OF FR 62 CORRODED. REPLACED SEAT TRACK PER SRM 51-72-11, DEFECT SIZE: 2" X 1" X 0.035".SDR USAA060435Seat Track · corrodedY450 AT 15 INCHES AFT OF FR 58 CORRODED. REPLACED SEAT TRACK PER SRM 51-72-11, DEFECT SIZE: 2" X 1" X .038".SDR USAA060434Seat Track · corrodedY2462 FR 47 & FR 53.2 - 6 SPOTS CORRODED. REPLACED SEAT TRACK PER SRM 51-72-11, DEFECT SIZE: 2" X 0.500" X 0.025" AT 6 SPOTS.SDR USAA060432Seat Track · corrodedY1959 5 PLACES FROM FR 47 - 53.2 CORRODED. REPLACED SEAT TRACK PER SRM 51-72-11, DEFECT SIZE: 2" X 1" X .030".SDR USAA060421Seat Track · corrodedY1456 AT 10 INCHES FWD OF FR 34. REMOVED CORROSION PER SRM 53-00-15 & REPLACED SEAT TRACK PER SRM 51-72-11, DEFECT SIZE: 1" X 1" X .038".SDR USAA060430Seat Track · corrodedFRETTING ON CROWN 6 PLACES AT Y450 FROM FR 47 - 53.2. REPLACED TRACK PER SRM 51-72-11, DEFECT SIZE: .5 SQ INCH AT 6 PLACES.SDR USAA060429Seat Track · corrodedY450 BETWEEN FR 39.2 AND 40 CORRODED. REPLACED SEAT TRACK PER SRM 53-31-15, 51-42-11, 51-44-11, DEFECT SIZE: 1 X 1 INCH.SDR USAA060428Seat Track · corrodedY2462 AT FRAME 54 CORRODED. REPLACED SEAT TRACK PER SRM 51-72-11, DEFECT SIZE: 1 SQ INCH.SDR USAA060427Seat Track · corrodedY450 AT 4 INCHES FWD OF FR 69 CORRODED. REPLACED SEAT TRACK PER SRM 51-72-11, DEFECT SIZE: 1" X 1" X 0.030".SDR USAA060425Seat Track · corrodedFR 59 AT -Y450 CORRODED. REPLACED SEAT TRACK PER SRM 5-42-11, 51-72-11, DEFECT SIZE: 1" X 2" X .040".SDR USAA060424Seat Track · corrodedY450 12 INCHES FWD OF FRAME 71 CORRODED. REMOVED DAMAGE, REPLACED SEAT TRACK PER SRM 51-72-11, DEFECT SIZE: 1 X 1 INCH.SDR USAA060423Seat Track · corrodedY450 BETWEEN FR 53.8 & 53.9 CORRODED. REPLACED SEAT TRACK PER SRM 51-72-11, DEFECT SIZE: 1.5" X 0.5" X 0.035".SDR USAA060422Seat Track · corrodedSEAT TRACK BETWEEN FR 40 & 42 Y-450 CORRODED. REPLACED PER SRM 51-42-11, DEFECT SIZE: 1" X 1" X .038".SDR USAA060433Seat Track · corrodedBETWEEN FR 47 - 52.3 Y-450 CORRODED. REPLACED SEAT TRACK PER SRM 51-72-11, DEFECT SIZE: 1" X .500" X .036" DEEP AT 3 PLACES.SDR QXEA200600714Seat Track · damagedYYC C4 FUSELAGE INTERIOR, RIGHT HAND FORWARD INBOARD SEAT RAIL HAS TWO AREAS OF SEAT ATTCH LUGS IN GALLEY ATT AREA THAT REQUIRE REMOVAL. REMOVED IAW DHC-8-200 SRM 51-20-36 AND HORIZON AIR EA 2-53-344.SDR USAA060413Seat Track · corrodedY450 AT FRAME 40.2, 41, 43, 44, 46 CROWN SECTION CORRODED. REMOVED CORROSION, REPLACED TRACK PER SRM 51-72-11, DEFECT SIZE: 1 X 1 INCH.SDR USAA060414Seat Track · corrodedFR 13A -Y953 TO FR 15A; CORROSION LEVEL 1; TASK C53117201. REPLACED NEW PER SRM 51-42-11 & 51-72-00, DEFECT SIZE: 1 X 1.5 X .0600.SDR USAA060416Seat Track · corrodedY-1959 AT 5 INCHES FWD OF FR 57.2 CORRODED. CORROSION BLENDED, REPLACED SEAT TRACK PER SRM 51-72-00, DEFECT SIZE: 1 X .500 INCH.SDR USAA060418Seat Track · corrodedSEAT TRACK CORRODED AT FR 72 AT Y450. NEW TRACK INSTALLED PER 51-72-11, DEFECT SIZE: .032 INCH DEEP.SDR USAA060419Seat Track · corrodedFR 13A -Y450; CORROSION TASK C53117201. REMOVED CORROSION; INSTALLED SEAT TRACK PER SRM 53-11-15; 51-42-11, DEFECT SIZE: 1 X .650 INCH.SDR USAA060420Seat Track · corrodedSEAT TRACK CROWN ON THE TOP Y+430 BETWEEN FR 14-15A; CORROSION TASK C53117201. CORROSION REMOVED .068 INCH, SEAT TRACK REPLACED PER SRM 51-42-11, DEFECT SIZE: .068 INCH.SDR USAA0600Seat Track · corrodedY1456 AT 10 INCHES FWD OF FR 34 CORRODED. REMOVED CORROSION; REPLACED SEAT TRACK PER SRM 53-00-15, 51-72-11, DEFECT SIZE: 1 X 1 X .038 INCH.SDR 06FDEA0948Repair · misinstalledSTA 909 - 969 X-27.5 SEAT TRACK SPLICE REPAIR. PERFORMED INSPECTION ON SEAT TRACK SPLICE REPAIR FOUND NOT IN COMPLIANCE WITH CRITERIA REQUEST BY EO 8-5100-7-5001 P2 FOUND SCREWS INSTEAD OF HI-LOK AND GANG CHANNEL INSTEAD OF NUT REMOVED GANG CHANNEL AND REPLACSDR 06FDEA0941Repair · corrodedSTA 1696 X = 27.5 EXISTING SEAT TRACK PLUG REPAIR. REMOVED CHANNEL IAW SRM 51-31-01 PAR 36/41 VOL 2. CLEANED CORROSION IAW SRM 51-21-01 PAR 34 VOL 2 VERIFICATED LIMITS IAW SRM 53-70-00 FIG 2 SHT 2 VOL 1 ORIGINAL THK IS .562 INCH IAW SRM 53-70-00 SHT 2 FIG 2 SDR 2006UALA00397Seat Track · brokenMAIN SEAT TRACK OUTBD LT SIDE STA 786-808, LBL 88 INBD NODES BROKEN OFF FROM TRACK. DAMAGED SEAT TRACK REMOVED/REPLACED PER SRM.SDR QXEA200600983Seat Track · dirtyPDX - ON FLIGHT 2534, FLIGHT ATTENDANT JUMPSEAT (FORWARD) DIFFICULT TO SLIDE INTO POSITION. MAINTENANCE CLEANED FORWARD FLIGHT ATTENDANT SEAT SLIDES. SEAT OPERATIONAL CHECKS GOOD. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR QXEA200600746Seat Track · corrodedYYC - C4 FUSELAGE INTERIOR LEFT OUTBOARD MID SEAT RAIL HAS ONE SPOT OF PITTING CORROSION. REPAIRED IAW RD 8-53-1342, ISSUE 6.SDR QXEA200600745Seat Track · corrodedYYC - C4 FUSELAGE INTERIOR LEFT HAND FORWARD OUTBOARD SEAT RAIL HAS SEVEN LOCAL AREAS OF PITTING CORROSION. REPAIRED IAW RD 8-53-1342, ISSUE 6.SDR QXEA200600744Seat Track · corrodedYYC - C4 FUSELAGE INTERIOR RIGHT HAND FORWARD OUTBOARD SEAT RAIL HAS ELEVEN LOCAL AREAS OF PITTING CORROSION. REPAIRED IAW RD 8-53-1342, ISSUE 6.SDR SIMA200606905Seat Track · corrodedRT OB SEAT TRACK NR 5 CORRODED. REPLACED SEAT TRACK IAW MM. (K)SDR SIMA200606904Seat Track · corrodedRT OB SEAT TRACK NR 4 CORRODED. REPLACED SEAT TRACK IAW MM. (K)SDR SIMA200606902Seat Track · corrodedRT OB SEAT TRACK NR 2 CORRODED. REPLACED SEAT TRACK IAW AIRCRAFT MM. (K)SDR UIEA200600019Seat Track · brokenMAIN DECK CARGO COMPT, SEAT TRACK IS MISSING TWO TABS BY THE MAIN CARGO DOOR BS 1800. REPLACED SEAT TRACK PER SRM 53-10-05 AND EO4753A686.SDR CA060315007Yoke · crackedCRACKS ORIGINATING IN ATTACHMENT BOLT HOLES.
Back to JASC 5347