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 USAA050419Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 3 INCH BY 2 INCH BY .056 INCH AND 4 INCH BY 2 INCH BY .060 INCH, Y-450 FRAME 53.2 - 53.5 Z-240. INSTALLED NEW SEAT TRACK PER SRM 53-31-15 FIG 101 SHEET 1/8. (M)SDR USAA050417Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1 INCH BY .500 INCH BY .01 INCH BY 1 INCH BY .500 INCH BY .035 INCH, Y 450 FS 68-72 -Z240. REPLACED WITH NEW SEAT TRACK PER SRM 53-00-15 FIG 101 SHEET 1. (M)SDR QXEA200500486Seat Track · corrodedPDX - NR 7 SEAT TRACK HAS PITTING CORROSION OUT OF LIMITS AT X219. REPAIRED IAW EO 4473, 8-51-102 AND 8-53-1102.SDR QXEA200500495Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS AREAS WITH PITTING CORRSION BEYOND BLENDABLE LIMITS. REPLACED IAW SRM 51-40-00 AND SRM 51-40-11.SDR DHL2005805514Cargo Track · wornMAIN CARGO COMPT NR 7 TRACK LUGS WORN AT STA 250.000. CUT OUT NR 7 TRACK DAMAGED SECTION IAW SRM 53-2-3 PG 17-19. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TRACK PLUG AND CHANNEL IAW SRM 51-3-0 PG 1-2.SDR DHL2005805515Cargo Track · wornMAIN CARGO COMPT NR 6 TRACK LUGS WORN AT STA 240.000. CUT OUT NR 6 TRACK DAMAGED SEGMENT IAW SRM 53-2-3 PG 17-19. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG AND CHANNEL IAW SRM 51-3-0 PG 1-2.SDR DHL2005805521Cargo Track · deterioratedMAIN CARGO COMPT NR 5 TRACK PLUG DETERIORATED AT STA 158.000. REMOVED DETERIORATED NR 5 TRACK PLUG IAW SRM 51-3-0 PG 1-2. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TRACK PLUG IAW SRM 51-3-0 PG 1-2. TORQUED IAW SRM 51-3-1.SDR DHL2005805518Cargo Track · wornMAIN CARGO COMPT NR 7 TRACK PLUG LUGS WORN AT STA 228.000. REMOVED DETERIORATED TRACK PLUG IAW SRM 51-3-0 PG 1-2. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TRACK PLUG IAW SRM 51-3-0 PG 1-2. TORQUED IAW SRM 51-3-1.SDR 05FDEA00458Seat Track · gougedMDCC ZONE 250, FS 54.2 LT SEAT TRACK NR 3 HAS GOUGES ON SCALLOP HOLE 1 - EA AREA. REMOVED AND REPLACED SEAT TRACK FITTING IAW A310-200 SRM 51-72-10.SDR 05FDEA00455Adapter · corrodedMDCC ZONE 251 FS 60 BETWEEN RT SEAT TRACK NR 4 - 5, 1 - EA. CLS ADAPTER BROKEN. REMOVED AND REPLACED CLS ADAPTER IAW A310-200 SRM 51-72-10.SDR 05FDEA00454Adapter · gougedMAIN CABIN FRAME 36, CLS ADAPTER -Y60 IS GOUGED, BETWEEN SEAT TRACK 3 - 4 LT. REMOVED AND REPLACED CLS ADAPTER IAW A310-200 SRM 51-72-10.SDR 05FDEA00445Adapter · corrodedMDCC ZONE 241, FR 39, BETWEEN NR 2 - 3 RT SEAT TRACK LCS ADAPTER HAS 1 AREA OF CORROSION INSIDE SCALLOP HOLE. REMOVED AND REPLACED CLS ADAPTER IAW A310-200 SRM 51-72-10.SDR 05FDEA00444Adapter · crackedMDCC ZONE 250, FR 55/58 BETWEEN LT SEAT TRACK 2 - 3, 1 EA, CLS ADAPTER BROKEN. REMOVED AND REPLACED CLS ADAPTER IAW A310-200 SRM 51-72-10.SDR 05FDEA00421Seat Track · corrodedNR 4 SEAT TRACK LT OF CENTER FROM FS 16 TO FS 18 HAS CORROSION REF N00519. REMOVED AND REPLACED SEAT TRACK FROM FS 16 TO FS 18 IAW SRM 51-40-21 AND EA 6-5310-86038.SDR 05FDEA00420Seat Track · corrodedMDC NR 4 SEAT TRACK RT OF CENTER AT FR19 ON I/B SPLICE HAS CORROSION ON UPPER SURFACE. REMOVED AND REPLACED SPLICE ANGLE AT FR19 IAW SRM 51-40-21.SDR 05FDEA00417Seat Track · corrodedMDCC NR 4 SEAT TRACK RT OF CENTER FROM FR 16 TO FR 19 CORRODED REF N00517. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-40-21.SDR 05FDEA00411Seat Track · crackedMAIN DECK CARGO, SEAT TRACK FOUND CRACKED AT STA 820 TO 829, RBL 27. REPAIRED AS PER SRM 53-70-00 FIG 1, VOL 1.SDR 05FDEA00410Seat Track · wornMAIN DECK CARGO, SEAT TRACK FOUND WORN AT STA Y= 893 TO Y= 900, X=47. REPAIRED AS PER SRM 53-70-00 FIG1 VOL1.SDR 05FDEA00409Seat Track · crackedMAIN DECK CARGO, SEAT TRACK FOUND CRACKED AT STA 890 TO 900, LBL 27. SEAT TRACK REPAIRED AS PER SRM 53-70-00 FIG1 VOL1.SDR USAA050396Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .70 INCH LONG BY .085 INCH WIDE BY .030 INCH DEEP, -Y2462 BETWEEN FRAME 58-62 -Z240. REMOVED AND REPLACED WITH NEW SEAT TRACK PER SRM 51-74-00, 53-00-15 FIG 101 SHT 2. (M)SDR USAA050415Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1.5 INCHES LONG BY 1 INCH WIDE BY .039 INCH DEEP, Y1959 BETWEEN FRAME FRAME 53.1-53.2. CUT OUT DAMAGED AREA AND REPLACED WITH NEW SEAT TRACK SECTION PER SRM 53-00-15 FIG 102 SH 2, 53-00-15. (M)SDR USAA050397Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .8 INCH LONG BY .3 INC WIDE BY .058 INCH DEEP, -Y450 BETWEEN FRAME 55-58. REMOVED AND REPLACED WITH NEW SEAT TRACK SECTION PER SRM 51-74-00 AND 53-00-15 FIG 1 SHEET 2. (M)SDR USAA050399Seat Track · corrodedBFM - FOUND SEAT TRACK SECTION CORRODED 4 INCHES LONG BY 1 INCH WIDE BY .050 INCH DEEP, -Y450 BETWEEN FRAME 36-37.1 -Z240. CUT OUT DAMAGED AREA AND REPLACED WITH NEW SECTION PER SRM 53-00-15 FIG 204 SHEET 1. (M)SDR 05FDEA00392Seat Track · corrodedMAIN DECK CARGO COMPARTMENT, SEAT TRACK AT STA Y= 5-83, X= -8.5 FOUND WITH CORROSION. REWORKED TRACK INSTALLED PER SRM 53-70-00 VOLUME I FIGURE 1.SDR 05FDEA00390Seat Track · crackedMAIN DECK CARGO COMPARTMENT, SEAT TRACK AT STA Y= 635, X= -27 FOUND WITH APPROX 4 INCHES LONG CRACKED. TRIMMED PER SRM 53-70-00 VOLUME I, FIGURE 1. REWORKED SEAT TRACK AND SPLICES INSTALLED PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR 05FDEA00391Seat Track · crackedMAIN DECK CARGO COMPARTMENT, SEAT TRACK AT STA Y= 635, X= -8.5 FOUND WITH APPROXIMATELY 4 INCHES LONG CRACKED. REWORK SEAT TRACK INSTALLED PER SRM 53-70-00 VOLUME I, FIGURE1SDR 2005UALA00218Seat Track · damagedCABIN SEAT TRACK AT RBL 33.39, STA 1168-1222 FOUND TO BE OUT OF LIMIT AFTER DAMAGE REMOVAL. *S/D* MAJOR REPAIR ACCOMPLISHED. SEAT TRACK SECTION REPLACED.SDR 2005UALA00217Seat Track · damagedCABIN SEAT TRACK AT LBL 33.39 STA 1063-1218 IS FOUND TO BE OUT OF LIMIT AFTER DAMAGE REMOVAL. *S/D* MAJOR REPAIR ACCOMPLISHED. SEAT TRACK SECTIONS REPLACED.SDR 05FDEA00395Attach Fitting · corrodedLAV-A LOCKDOWN FITTING IS SEVERLY CORRODED REF N000672. REMOVED AND REPLACED LAV-A LOCKDOWN FITTING IAW SRM 51-72-10.SDR 05FDEA00394Seat Track · corrodedMAIN DECK CARGO COMPARTMENT, SEAT TRACK AT STA Y= 5-90, X= 8.5 FOUND WITH CORROSION. REMOVED AT EXISTING SPLICE PER SRM 51-33-01 VOLUME II. REWORKED SEAT TRACK INSTALLED PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR 05FDEA00393Seat Track · chafedMAIN DECK CARGO COMPARTMENT, SEAT TRACK AT STA Y= 1100, X= 47 FOUND WITH CHAFED MARK. REMOVED PER SRM 53-70-00 VOLUME I, FIGURE 1. FABRICATED SEAT TRACK AND SPLICES INSTALLED PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR USAA050400Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1 INCH LONG BY .500 INCH WIDE BY .071 INCH DEEP, -Y450 BETWEEN FRAME 72-75 -Z240. REMOVED AND REPLACED WITH NEW SEAT TRACK PER SRM 53-00-15, 51-42-11. (M)SDR USAA050380Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 4 INCH BY 1 INCH BY .050 INCH DEEP, FRAME 37, Y450, MAIN CABIN FLOOR. REMOVED DAMAGED SECTION, FABRICATED REPAIR SECTION AND SPLICES, INSTALLED REPAIR PARTS PER SRM 53-00-15. (M)SDR USAA050365Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 2.5 INCH BY .80 INCH WIDE BY .040 INCH DEEP, MAIN CABIN FLOOR, BS 855, RBL 88.5. CORROSION LEVEL 2, TASK C53-242-02. ACCOMPLISHED SEAT TRACK SPLICE REPAIR PER SRM 53-00-52, FIG 203/SRM 51-40-02. (M)SDR USAA050389Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1.3 INCH WIDE BY 1.15 INCH LONG BY .032 INCH DEEP, 14.6 INCH WIDE BY 1.15L BY .003, BETWEEN FRAME 32-36 Y-950. CORROSION LEVEL 2, TASK C532134-01. FABRICATED NEW TRACK SECTION AND SPLICES PER SRM 53-00-15, FIG 204, SHEET 1 ANDSDR USAA050388Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED Y-1550 AT FRAME 32 AND FRAME 34. CORROSION LEVEL 2, TASK C532134-01. REMOVED AND REPLACED PER SRM 51-42-11. (M)SDR USAA050387Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 4 INCH BY 1 INCH AREA, Y450 FROM FRAME 72-75. CORROSION LEVEL 2, TASK C534159-01. REMOVED AND REPLACED TRACK PER SRM 51-42-11. (M)SDR QXEA200500458Seat Track · corrodedYYC - LEFT HAND INBOARD SEAT RAIL AT STATION X663 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01 AND HORIZON AIR EA R-53-083.SDR QXEA200500450Seat Track · corrodedYYC - RIGHT HAND INBOARD SEAT RAIL AT STATION X430 HAS PITTING CORROSION AND WEARING MARKS ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01 AND REO 670-53-00-013.SDR QXEA200500445Seat Track · corrodedYYC - RIGHT HAND OUTBOARD SEAT RAIL AT STATION X421 TO X426 HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01 AND REO 670-53-00-013.SDR QXEA200500447Seat Track · corrodedYYC - RIGHT HAND INBOARD SEAT RAIL AT STATION X350 TO X355 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01 REO 670-53-00-013.SDR QXEA200500449Seat Track · corrodedYYC - RIGHT HAND INBOARD SEAT RAIL AT STATION X399 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01 AND REO 670-53-00-013.SDR QXEA200500452Seat Track · corrodedYYC - RIGHT HAND INBOARD SEAT RAIL AT STATION X479.5 HAS PITTING CORROSION ON INSIDE SURFACE AROUND SCREW HOLE. REPAIRED IAW CRJ700 51-21-06-001-001-A01 AND REO 670-53-00-013.SDR QXEA200500448Seat Track · corrodedYYC - RIGHT HAND INBOARD SEAT RAIL AT STATION X363 HAS PITTING CORROSION ON TOP SURFACE. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01 AND REO 670-53-00-013.SDR QXEA200500451Seat Track · corrodedYYC - RIGHT HAND INBOARD SEAT RAIL AT STATION X461 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01 AND REO 670-53-00-013.SDR 05FDEA00375Seat Track · brokenSEAT TRACK L-2 AT FRAME 52 HAS A BROKEN LUG, FOUND DURING CLS RE-INSTALLATION. REMOVED AND REPLACED SEAT TRACK SECTION IAW A310-200 SRM 53-10-16.SDR 05FDEA00370Seat Track · crackedMAIN DECK CARGO COMP ZONE 146 AT FR 43 BETWEEN SEAT TRACKS R1 AND R2 DUMMY TRACK IS CRACKED. REMOVED AND REPLACED SEAT TRACK IAW A310-200 SRM 51-40-21 AND 51-72-10.SDR 05FDEA00361Seat Track · corrodedMDCC NR 2 SEAT TRACK LEFT OF CENTER LINE FROM FRAME 15 TO FR 19 HAS HEAVY CORROSION. REMOVED NR 2 SEAT TRACK, SPLICE AND COUPLING IAW A310-200 SRM 51-40-21. LOCATED AND DRILLED NEW SEAT TRACK, SPLICE AND COUPLING IAW A310-200 SRM 51-40-44. INSTALLED NEW SEASDR 05FDEA00360Seat Track · corrodedMDCC NR 2 SEAT TRACK RT OF CENTER LINE FROM FRAME 15 TO FRAME 18 HAS HEAVY CORROSION. REMOVED SEAT TRACK IAW A310-200 SRM 51-40-21. INSTALLED NEW SEAT TRACK IAW A310-200 SRM 51-40-21.SDR USAA050383Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .37 INCH DEEP BY .04 INCH WIDE BY 1 INCH LONG AREA, BETWEEN FRAME 73-74 Y = +1137.1. CORROSION LEVEL 2, TASK C534159-01. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15, SRM 57-44-11. (M)
Back to JASC 5347