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 QXEA200500593Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND OUTBOARD SEAT RAIL AT STATION X708 HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-0101-A01, PARAGRAPH 3E AND SRM 51-21-16, CODE A044.SDR QXEA200500606Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND INBOARD SEATRAIL, AT STATION X584, HAS PITTING CORROSION ON TOP SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E, REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500609Seat Track · corrodedYYC - FUSELAGE INTERIOR, LEFTHAND INBOARD SEAT RAIL AT STATION X460 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500607Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND INBOARD SEAT RAIL AT STATION X603 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E, REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500598Seat Track · corrodedYYC - FUSELAGE INTERIOR RIGHTHAND OUTBOARD SEAT RAIL AT STATION X810 HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPHA 3E, REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500594Seat Track · corrodedYYC - FUSELAGE INTERIOR, RT OUTBOARD SEAT RAIL AT STATION X712 HAS PITTING CORROSION ON INSIDE SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAGH 3E AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500605Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND INBOARD SEAT RAIL AT STATION X540 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E, REO 670-53-00-013 AND SRM 51-21-16, CODE A044.SDR QXEA200500603Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND INBOARD SEAT RAIL AT STATION X479 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E, REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500612Seat Track · corrodedYYC - FUSELAGE INTERIOR, LEFTHAND INBOARD SEAT RAIL AT STATION X665 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E, REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500610Seat Track · corrodedYYC - FUSELAGE INTERIOR, LEFTHAND INBOARD SEAT RAIL AT STATION X479 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500608Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND INBOARD SEAT RAIL AT STATION X616 HAS PITTING CORROSION ON TOP SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E, REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500602Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND INBOARD SEAT RAIL AT STATION X448 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E, REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500590Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHT OUTBOARD SEAT RAIL AT STATION X584, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700/90-0 SRM 51-21-06-001-001-A01, PARAGRAPH 3E.SDR QXEA200500589Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHT OUTBOARD SEAT RAIL AT STATION X553 HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01.SDR QXEA200500587Seat Track · corrodedYYC - FUSELAGE INTERIOR LEFT OUTBOARD SEAT RAIL AT STATION X810 HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ 7--/9-- SRM 51-21-06-001-001-A01 AND REO 670-53-00-013.SDR QXEA200500586Seat Track · corrodedYYC FUSELAGE INTERIOR LEFT OUTBOARD SEAT RAIL AT STATION X795 HAS PITTING CORROSION ON INSIDE AND MOST INBOARD SURFACES. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01 AND REO 670-53-00-013.SDR QXEA200500584Seat Track · corrodedYYC FUSELAGE INTERIOR, LEFT OUTBOARD SEAT RAIL AT STATION X740 HAS PITTING CORROSION ON ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01 AND REO 670-53-00-013.SDR QXEA200500583Seat Track · corrodedYYC - FUSELAGE INTERIOR LEFT OUTBOARD SEAT RAIL AT STATION X615 HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01, PARAGRAPH 3E AND CRM 51-21-16, CODE A044.SDR QXEA200500591Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHT OUTBOARD SEAT RAIL AT STATION X613, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E.SDR QXEA200500592Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHT OUTBOARD SEAT RAIL AT STATION X646 HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E.SDR QXEA200500588Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHT OUTBOARD SEAT RAIL AT STATION X522 HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700/900 SRN 51-21-06-001-001-A01.SDR SIMA200509109Seat Track · corrodedDURING MBV INSPECTION FOUND FORWARD CABIN LT FWD IB SEAT TRACK CORRODED AROUND FASTENERS. REMOVED AND REPLACED LT FWD IB SEAT TRACK IAW MM. AC RETURNED TO SERVICE. (K)SDR USAA050425Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, FS 18 -Y950-Z240. REPLACED SEAT TRACK PER SRM 53-00-15 FIG 101, 51-72-11, 51-42-11. (M)SDR USAA050424Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 2.5 INCH LONG BY .75 INCH WIDE BY .040 INCH DEEP, MAIN CABIN SEAT TRACK Y450 FRAME 15-17. CORROSION LEVEL 2, TASK C531172-01. REPLACED SEAT TRACK PER SRM 53-00-15. (M)SDR 05FDEA00599Seat Track · wornMAIN DECK CARGO COMPARTMENT, SEAT TRACK CROWN AT RIGHTHAND STA Y= 1090, X= -47 FOUND ELONGATED. MAIN DECK CARGO COMPARTMENT, SEAT TRACK AT RIGHTHAND STA Y= 1049 TO Y= 1129 , X= -47 TRIMMED, REMOVED AND REWORKED SEAT TRACK INSTALLED PER SRM 53-70-00 VOLUME I, SDR 05FDEA00591Seat Track · corrodedMAIN DECK CARGO COMP'T LEFT NR 5 SEAT TRACK, FR49, FR51.5, FR54, CORROSION INSIDE SCALLOP HOLES, 3-AREAS. REMOVED AND REPLACED SEAT TRACK SECTION BETWEEN FRAMES 50.5 AND 54 IAW A310-200 SRM 53-10-16.SDR 05FDEA00585Seat Track · corrodedMAIN DECK CARGO COMPT RT NR 2 SEAT TRACK, FR45.5, FR46, FR46.5, FR47, FR49, FR52.5, FR53, FR54 CORROSION INSIDE SCALOPE HOLES, 9 AREAS AS MARKED. REMOVED CORROSION IAW A310 SRM 51-74-10. TRACK IS OUT OF LIMITS IAW A310 SRM 53-10-16 FIG 101. FABRICATED NEW SDR 05FDEA00583Seat Track · corrodedMAIN DECK CARGO COMPT LEFT NR 3 SEAT TRACK, FR48, FR49.5, FR51.5, FR53.5, 4 EA AREAS OF CORROSION INSIDE SCALLOP HOLES AS MARKED. REMOVED AND REPLACED SEAT TRACK SECTION BETWEEN FRAME 50.5 TO 54 IAW A310-200 SRM 53-10-16.SDR 05FDEA00582Seat Track · corrodedMAIN DECK CARGO COMPT RT NR 3 SEAT TRACK FR45.5, FR47, FR48, FR49, FR51.5, FR52.5, CORROSION INSIDE SCALLOP HOLES 8-AERAS. REMOVED CORROSION IAW A310-200 SRM 51-74-10. TRACK WAS OUT OF LIMITS IAW A310-20 SRM 53-10-16 FIG 101. REMOVED AND REINSTALLED COUPLESDR USAA050483Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1 INCH LONG BY 1.5 INCH WIDE BY .27 INCH DEEP, MAIN CABIN Y-450 FRAME 40-42. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15. (M)SDR QXEA200500585Seat Track · corrodedYYC - FUSELAGE INTERIOR, LEFT OUTBOARD SEAT RAIL AT STATION X785 HAS PITTING CORROSION AND TOOL MARKS ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01 AND REO 670-53-00-013.SDR 05FDEA00571Seat Track · corrodedM-DECK CARGO COMP'T RT NR 4 SEAT TRACK FR46, FR47, FR48, FR49.5, FR50.5, FR51.3, FR52.5, FR53.4, CORROSION INSIDE SCALOPE HOLES, 9-AREAS. REMOVED CORROSION IAW A310-200 SRM 51-74-10, OUT OF LIMITS IAW SRM 53-10-16 FIG 101. FABBED NEW SEAT TRACK IAW DWG A538-SDR 05FDEA00559Seat Track · corrodedM DECK COMP'T NR 1 SEAT TRACK, FR45.5, FR48, FR49, FR52, FR52.5 FR53.5, 6-EA AREAS OF CORROSION INSIDE SCALOPE HOLES AS MARKED. REMOVED CORROSION IAW SRM 51-74-10, OUT OF LIMITS BETWEEN FR52 & 54 IAW 53-10-16 FIG 101. CUT OUT & FABBED NEW REPAIR SECTION OF SSDR 05FDEA00549Seat Track · gougedRT NR 2 SEATRACK FR 54.2, HAS 1 GOUGED AREA ON SCALOPE HOLE. REMOVED DAMAGED SEAT TRACK FITTING AT MDCC SONE 241 RT NR 2 FR 54.2 AND REPLACED WITH NEWS SEAT TRACK FITTING P/N A5381114620000 IAW A310-200 SRM 51-40-21.SDR 05FDEA00548Seat Track · corrodedNR 1 SEAT TRACK, FR61.5, FR 62.5, FR64.5, FR65.5, FR66.5, FR70.5, HAS 9 AREAS CORROSION INSIDE SCALLOPED HOLES. REMOVED CORROSION IAW SRM 51-74-10, SEVERAL AREAS OUT OF LIMITS IAW SRM 53-10-16 FIG 601. CUT OUT 2EA SEAT TRACKS FROM 2EA SEAT TRACKS IAW SRM 51-SDR 05FDEA00543Seat Track · corrodedCABIN SEAT TRACK F CORRODED FUSELAGE STATION 959 - 1130. REMOVED DAMAGED SECTION OF SEAT TRACK AND SPLICED IN NEW SECTION OF SEAT TRACK IAW DC10 SRM 53-70-00 VOL 1.SDR 05FDEA00518Seat Track · corrodedCABIN SEAT TRACK -B- CORRODED BETWEEN FUSELAGE STATION 1850 - 1879. REMOVED AND REPLACED SEAT TRACK SECTION IAW DC10 SRM 53-70-00 VOL I AND 51-31-01 VOL 2.SDR USAA050422Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1.5 INCHES LONG BY .7 INCHES BY .025 INCH DEEP, -Y1959 FRAME 40-47 -Z240. REMOVED AND REPLACED WITH NEW SEAT TRACK PER SRM 51-74-00, 53-31-15 FIG 101 SHT 8. (M)SDR USAA050426Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1 INCH LONG BY 1 INCH WIDE BY 0.025 INCH DEEP, Y953 FRAME 13 -Z -240. CORROSION LEVEL 2, TASK C53117201. REMOVED AND REPLACED WITH NEW SEAT TRACK PER SRM 51-74-00, AND 53-11-15. (M)SDR UPS05444211Cargo Track · corrodedM/DECK BS 1720 LBL 78 INCH AND 85 INCH TIE DOWN FTG ATTACH PLATE FOUND CORRODED. CORROSION BLEND OUT 0.030 INCH BY 1 INCH BY 1 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT, TIE DOWN FTG AND PLATE REPLACED AS PER MM 20-51-01 FTG P/N: 69B62076-1, PLATE P/N: 69B62100-1.SDR UPS05444206Cargo Track · corrodedM/DECK BS 1880 RBL 50 INCH TIE DOWN FTG ATT PLATE FOUND CORRODED. CORROSION BLEND OUT 0.025 INCH BY 1 INCH BY 1 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT, BS 1880 RBL 50 INCH TIE DOWN FTG. REEPLACED AS PER MM 20-51-01.SDR MASA200500220Seat Track · corrodedIN C-CHECK, SEAT TRACK AT LT Y479 CORRODED FROM FR 18 TO FR 24, OUT OF LIMITS REF SRM 53-00-11. REPLACED TRACK.SDR UPS05444179Seat Track · corrodedINSPECTION TYPE:C M/D- BS 2040 - 2140 LBL 65 SEAT TRACK FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.050 X 1 X 10 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS05444178Seat Track · corrodedINSPECTION TYPE:C M/D - BS 2040-2050 LBL 88 SEAT TRACK FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.045 X 1 X 5 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT. SEAT TRACK REPLACED AS PER SRM 51-10-01 PG 9.SDR UPS05444177Seat Track · corrodedINSPECTION TYPE:C M/D- BS 1800 TO 1920 RBL 11 SEAT TRACK FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.040 X 1 X 1 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 16.SDR UPS05444176Seat Track · corrodedINSPECTION TYPE:C M/D- BS 1780 RBL 95 SEAT TRACK CROWN FOUND CORRODED. CORROSION BLEND OUT 0.045 X 1 X 2 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT. SEAT TRACK REPLACED AS PER SRM 51-10-01 PG 9.SDR UPS05444173Seat Track · corrodedINSPECTION TYPE:C M/D- BS 2130 TO 2140 LBL 75 SEAT TRACK FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.045 X 1 X 1 INCH. CORROSION BLEND OUT 0.045 X 1 X 1 INCH, EXCEED SRM 53-10-01 FIG 1 LIMITS. SEAT TRACK REPLACED AS PER SRM 51-10-01 PG 9.SDR 05FDEA00511Seat Track · corrodedMAIN DECK CARGO - SEAT TRACK CORRODED AT STA 1351 RT 76 INCHES. SEAT TRACK REPAIRED AS PER SRM 53-70-00 VOL 1 FIG 1, AT STA 1269 TO 1391.SDR UPS05444210Cargo Track · corrodedM/DECK BS 1500 LBL 75 INCH TIE DOWN FTG ATTACH PLATE FOUND CORRODED. CORROSION BLEND OUT 0.030 INCH BY 1 INCH BY 1 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT, TIE DOWN FTG REPLACED AS PER MM 20-51-01.SDR UPS05444209Cargo Track · corrodedM/DECK BS 1940 AND 1960 LBL 80 INCH TIE DOWN FTG ATT PLATE FOUND CORRODED. CORROSION BLEND OUT 0.020 INCH BY 1 INCH BY 1 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT, M/D BS 1940 LBL 80 INCH TIE DOWN FTG REPLACED AS PER MM 20-51-01.
Back to JASC 5347