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 QXEA200602819Seat Track · corrodedC4 PDX - LT OB SEAT TRACK NR 1 HAS GOUGES IN CENTER OF TRACK AT STA X405. REPAIRED IAW SRM 51-20-36, 51-20-16 AND RD8-53-1342.SDR QXEA200602818Seat Track · corrodedC4 PDX - LT OB SEAT TRACK NR 1 HAS SPOT OF CORROSION IN CENTER OF TRACK AT STA X408. REPAIRED IAW SRM 51-20-36, 51-20-16 AND RD8-53-1342.SDR QXEA200602817Seat Track · corrodedC4 PDX - LT OB SEAT TRACK NR 1 HAS CORROSION AROUND EDGE OF CLAW OPENING AT STATION X424. REPAIRED IAW SRM 51-20-36, 51-20-16 AND RD8-53-1342.SDR QXEA200602816Seat Track · corrodedC4 PDX - LT OB SEAT TRACK NR 2 HAS CORROSION IN CENTER OF TRACK AT STATION X469. REPAIRED IAW SRM 51-20-36, 51-20-16 AND RD8-53-1342.SDR QXEA200602823Seat Track · gougedC4 PDX - LT OB SEAT TRACK NR 1 HAS GOUGES ON EDGE OF CLAW OPENING AT STATION X280. REPAIRED IAW SRM 51-20-36, 51-20-16 AND RD8-53-1342.SDR QXEA200602822Seat Track · corrodedC4 PDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS CORROSION ON TOP OF TRACK AT STATION X313. REPAIRED IAW SRM 51-20-36, 51-20-16 AND RD8-53-1342.SDR QXEA200602807Seat Track · corrodedC4 PDX - RIGHT OUTBOARD SEAT TRACK NR 10 HAS CORROSION AROUND CLAW OPENING AT STATION X298. REPAIRED IAW SRM 51-20-16, 51-20-36, AND RD8-53-1342.SDR QXEA200602805Seat Track · corrodedC4 PDX - RIGHT OUTBOARD SEAT TRACK NR 10 HAS DEEP CORROSION IN CENTER OF TRACK AT STATION X370. REPAIRED IAW SRM 51-20-16 AND 51-20-36, AND RD8-53-1342.SDR QXEA200602801Seat Track · corrodedC4 PDX - RIGHT OUTBOARD SEAT TRACK NR 11 HAS CORROSION ON EDGE OF CLAW OPENING AT STATION X455. REPAIRED IAW SRM 51-20-16 AND 51-20-36, AND RD8-53-1342.SDR QXEA200602800Seat Track · corrodedC4 PDX - RIGHT OUTBOARD SEAT TRACK NR 11HAS CORROSION AROUND EDGES OF CLAW OPENINGS FROM STATION X468 TO X470. REPAIRED IAW SRM 51-20-16 AND 51-20-36, AND RD8-53-1342.SDR UPS06448594Seat Track · corrodedBS 2190-2200 RBL89 SEAT TRACK FLANGE FOUND CORRODED. (BOTH SIDES) CORROSION BLEND OUT 0.035" BY 5/8" BY 10" EXCEED SRM LIMIT. BS 2150-2230 RBL89 SEAT TRACK REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED AS PER SRM 51-30-02.SDR UPS06M48531Seat Track · corrodedINSPECTION TYPE:4C SEAT TRACK AT FS 475 RBL 8.5 HAS SURFACE CORROSION. REMOVED SEAT TRACK AT FS 475 RBL 8.5, FABRICATED REPLACEMENT SEAT TRACK PER DWG WSP0826, AND INSTALLED IAW MD-11 SRM 51-31-01,51-33-01, AND 51-35-02.SDR UPS06448562Seat Track · corrodedINSPECTION TYPE:C M/D BS 1800-1860 RBL75 SEAT TRACK FLANGE AND CROWN FOUND CORRODED. CORROSION BLEND OUT 0.036" BY 5/8" BY 1 3/4" EXCEED SRM LIMIT. M/D SEAT TRACK AT BS 1730-1870 RBL75 REPAIRED AS PER SRM 53-10-05 FIG 1A REFER NRC50940 FOR WORKING DETAIL.SDR UPS06448557Seat Track · corrodedINSPECTION TYPE:C M/D BS1880-1910 RBL11 SEAT TRACK O/B FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.021" BY 1/2" BY 10" EXCEED SRM LIMIT. SEAT TRACK REPLACED AS PER SRM 51-10-01 P9 JUST AT M/D RBL11 BETWEEN BS 1870 AND 1910.SDR UPS06448555Seat Track · corrodedINSPECTION TYPE:C M/D BS1920 RBL33 SEAT TRACK O/B FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.022" BY 1/2" BY 1" EXCEED SRM LIMIT. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 33 JUST AT M/D RBL33 BETWEEN BS 1810 AND BS 1950 (REFER NRC NO.51784 FOR DETAIL).SDR UPS06448553Seat Track · corrodedINSPECTION TYPE:C M/D BS 1880-1900 RBL33 SEAT TRACK I/B FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.045" BY 7/8" BY 1 1/8" EXCEED SRM LIMIT. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 33 JUST AT M/D RBL 33 BETWEEN BS 1810 AND BS 1950 (REFER NRC NO.51784 FOSDR UPS06448552Seat Track · corrodedINSPECTION TYPE:C M/D BS1813 RBL33 SEAT TRACK I/B FLANGE LOWER FACE FOUND CORRODED. CORROSION BLEND OUT 0.040" BY 7/8" BY 1.5" EXCEED SRM LIMIT. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 33 JUST AT M/D RBL33 BETWEEN BS1810 AND BS 1950.SDR UPS06448547Seat Track · corrodedINSPECTION TYPE:C M/D BS 2132 LBL89 SEAT TRACK I/B FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.035" BY 5/8" BY 1" EXCEED SRM LIMIT. M/D BS 2150-2230 LBL89 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS06448546Seat Track · corrodedINSPECTION TYPE:C M/D BS1800-1820 SEAT TRACK I/B FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.057" BY 7/8" BY 1 7/8" EXCEED SRM LIMIT. M/D BS 1770-1830 LBL33 SEAT TRACK REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED WITH EXISTING SPLICE PER SRM 51-30-02.SDR UPS06448545Seat Track · corrodedINSPECTION TYPE:C M/D BS 2050-2130 LBL97 SEAT TRACK FLANGE FOUND CORRODED (BOTH SIDE). CORROSION BLEND OUT 0.035" BY 3/4" BY 1.5" EXCEED SRM LIMIT. M/D BS 2030-2150 LBL 98 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS06448544Seat Track · corrodedINSPECTION TYPE:C M/D BS2160 RBL 65 SEAT TRACK FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.022" BY 1/2" BY 3" EXCEED SRM LIMIT. M/D BS 2110-2240 RBL 65 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1ASDR UPS06448543Seat Track · corrodedINSPECTION TYPE:C M/D BS 2220-2240 RBL65 SEAT TRACK O/B FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.026" BY 5/8" BY 20" EXCEED SRM LIMIT. M/D BS 2110-2240 RBL65 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A REFER NRC 51776 FOR WORKING DETAIL.SDR UPS06448542Seat Track · corrodedINSPECTION TYPE:C M/D SEAT TRACK FLANGE FOUND CORRODED BOTH I/B AND O/B. CORROSION BLEND OUT 0.043" BY 3/4" BY 1.5" EXCEED SRM LIMIT. M/D BS1890-2030 LBL 33 SEAT TRACK REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS06448476Cargo Track · corrodedBS 1680 RBL86 TIE DOWN FTG FLANGE FOUND CORROSION. CORROSION BLEND OUT 0.033" BY 1/2" BY 1/2" EXCEED SRM LIMIT. TIE DOWN FTG PLATE REPLACED AS PER MM 20-51-01.SDR UPS06448499Seat Track · corrodedBS 2060-2080 RBL75 SEAT TRACK O/B FLANGE FOUND CORROSION. CORROSION BLEND OUT 0.030" BY 1/2" BY 1.5". SEAT TRACK REPLACED AS PER SRM 53-10-05 FIG 1A JUST AT M/D, RBL75 BETWEEN STA 2010 AND 2110.SDR UPS06448475Seat Track · corrodedBS 1920 - 1960 RBL 75 SEAT TRACK I/B FLANGE FOUND CORROSION. CORROSION BLEND OUT 0.030" BY 1" BY 1 1/4" EXCEED SRM LIMIT. BS 1870- 2010 RBL 75 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS06448473Seat Track · corrodedBS 1780-1850 LBL11 SEAT TRACK I/B FLANGE FOUND CORROSION. CORROSION BLEND OUT 0.034" BY 3/4" BY 1 1/4" EXCEED SRM LIMIT. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 14 JUST AT M/D LBL11 BETWEEN STA 1770 AND 1850 REFER NRC NR 50955 FOR WORKING DETAIL.SDR QXEA200602814Seat Track · corrodedC4 PDX - LEFT OUTBOARD SEAT TRACK NR 2 HAS CORROSION IN CENTER OF TRACK AT STATION X495. REPAIRED IAW SRM 51-20-36, 51-20-16 AND RD8-53-1342.SDR QXEA200602815Seat Track · corrodedC4 PDX - LT OB SEAT TRACK NR 2 HAS 3 SPOTS OF CORROSION ON TOP OF TRACK FROM STATION X486 TO X488. REPAIRED IAW SRM 51-20-36, 51-20-16 AND RD8-53-1342.SDR QXEA200602813Seat Track · corrodedC4 PDX - LT OB SEAT TRACK NR 3 HAS CORROSION ON TOP OF TRACK AT STA X518. REPAIRED IAW SRM 51-20-36, 51-20-16 AND RD8-53-3644.SDR QXEA200602812Seat Track · corrodedC4 PDX - LEFT INBOARD SEAT TRACK NR 4 HAS LIGHT SURFACE CORROSION ON TOP OF TRACK FROM STATION X190 TO X200. REPAIRED IAW SRM 51-20-36.SDR QXEA200602808Seat Track · corrodedC4 PDX - LEFT INBOARD SEAT TRACK NR 6 HAS CORROSION ON OUTBOARD EDGE OF SEAT TRACK AROUND NUTPLATE HOLE AT STATION X567. REPAIRED IAW SRM 51-20-16, 51-20-36, AND RD8-53-784.SDR QXEA200602811Seat Track · corrodedC4 PDX - LEFT INBOARD SEAT TRACK NR 4 HAS CORROSION ON TOP OF TRACK FROM STATION X253 TO X256. REPAIRED IAW SRM 51-20-16, 51-20-36, AND RD8-53-1339.SDR QXEA200602806Seat Track · corrodedC4 PDX - RIGHT OUTBOARD SEAT TRACK NR 10 HAS CORROSION IN CENTER OF TRACK AT STATION X343. REPAIRED IAW SRM 51-20-16, 51-20-36, AND RD8-53-1342.SDR QXEA200602810Seat Track · gougedC4 PDX - LEFT INBOARD SEAT TRACK NR 5 HAS GOUGES IN CENTER OF TRACK AT STATION X508. REPAIRED IAW SRM 51-20-16, 51-20-36, AND RD8-53-1339.SDR QXEA200602809Seat Track · corrodedC4 PDX - LEFT INBOARD SEAT TRACK NR 6 HAS CORROSION ON INBOARD AND OUTBOARD EDGE OF TRACK FLANGE AT STATION X555. REPAIRED IAW SRM 51-20-16, 51-20-36, AND RD8-53-784.SDR QXEA200602804Seat Track · gougedC4 PDX - RIGHT INBOARD SEAT TRACK NR 8 HAS GOUGE ON EDGE OF CLAW OPENING AT STATION X434. REPAIRED IAW SRM 51-20-16 AND 51-20-36, AND RD8-53-1339.SDR QXEA200602803Seat Track · corrodedC4 PDX - RIGHT INBOARD SEAT TRACK NR 8 HAS CORROSION ON EDGE OF CLAW OPENING AT STATION X501. REPAIRED IAW SRM 51-20-16 AND 51-20-36, AND RD8-53-1339.SDR QXEA200602798Seat Track · corrodedC4 PDX - RIGHT OUTBOARD SEAT TRACK NR 12 HAS GOUGE IN CENTER OF TRACK AT STATION X541. REPAIRED IAW SRM 51-20-16 AND 51-20-36, AND RD8-53-3644.SDR QXEA200602802Seat Track · corrodedC4 PDX - RIGHT INBOARD SEAT TRACK NR 9 HAS CORROSION ON INBOARD FLANGE OF TRACK AT STATION X552. REPAIRED IAW SRM 51-20-16 AND 51-20-36, AND RD8-53-784.SDR QXEA200602799Seat Track · corrodedC4 PDX - RIGHT OUTBOARD SEAT TRACK NR 12 HAS CORROSION ON TOP INBOARD EDGE OF TRACK AT STATION X531. REPAIRED IAW SRM 51-20-16 AND 51-20-36, AND RD8-53-3644.SDR AWXA200601794Seat Track · corrodedBC-4 CHECK - NR 5949426, CORROSION ON MAIN CABIN SEAT TRACK, FR 36 + 3 INCHES TO FR 41, -Y1292. REPLACED MAIN CABIN SEAT TRACK, FR 36 + 3 INCHES TO FR 41, -Y1292 IAW A319 SRM 51-42-11 AND 51-72-11.SDR ASAA0671103Cargo Track · corrodedAFT CARGO PIT TIE DOWN TRACK AT BS 767+4 IS CORRODED. REPAIRED IAW SRM 53 00 53 FIG 201 REPAIR 3.SDR 06FDEA03730Seat Track · corrodedCARGO SEAT TRACK (STA 475, LT X=27.5) FOUND CORRODED. REPAIR CARRIED OUT AT M/D CARGO SEAT TRACK AT STA475 LT X=27.5 AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MINOR AS PER GMM 6-2-100.SDR UPS06448606Plate · corrodedBS 1840 RBL 25 TIE DOWN FTG FLANGE PLATE FOUND CORRODED. CORROSION BLEND OUT 0.017" BY 5/8" BY 1" EXCEED SRM LIMIT. TIE DOWN FTG PLATE REPLACED AS PER MM 20-51-01.SDR UPS06448605Plate · corrodedBS 1820 RBL 35 TIE DOWN FTG PLATE FOUND CORRODED. CORROSION BLEND OUT 0.017" BY 1/2" BY 2" EXCEED SRM LIMIT. TIE DOWN FTG PLATE REPLACED AS PER MM 20-51-01.SDR UPS06448603Plate · corrodedBS 1800 RBL 80 TIE DOWN FITTING FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.038" BY 1/2" BY 2" EXCEED SRM LIMIT. TIE DOWN FTG PLATE REPLACED AS PER MM 20-51-01.SDR UPS06448602Fitting · corrodedBS 1860 RBL55 TIE DOWN FITTIING FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.026" BY 3/4" BY 3/4" EXCEED SRM LIMIT. TIE DOWN FITTING REPLACED AS PER MM 20-51-01.SDR UPS06448601Plate · corrodedINSPECTION TYPE:C M/D BS 1900 RBL 13 TIE DOWN FITTING FLANGE PLATE FOUND CORRODED. CORROSION BLEND OUT 0.020" BY 3/4" BY 2" EXCEED SRM LIMIT. TIE DOWN FITTING PLATE REPLACED AS PER MM 20-51-01.SDR UPS06448600Fitting · corrodedTIE DOWN FITTING SUPPORT PLATE CORRODED AT STA 1861 LBL77-80. CORROSION BLEND OUT 0.017" BY 5/8" BY 2" EXCEED SRM LIMIT. TIE DOWN FITTING REPLACED AS PER MM 20-51-01.
Back to JASC 5347