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 QXEA200602842Seat Track · corrodedC3 PDX - SEAT TRACK NR 19 HAS CORROSION AT STATION X509.5. REPAIRED IAW RD8/4-53-884.SDR QXEA200602841Seat Track · corrodedC3 PDX - SEAT TRACK NR 19 HAS CORROSION AT STATION X479.00. REPAIRED IAW RD8/4-53-884.SDR QXEA200602840Seat Track · corrodedC3 PDX - SEAT TRACK NR 19 HAS CORROSION AT STATION X469.5 TO X474.5. REPAIRED IAW RD8/4-53-884.SDR QXEA200602839Seat Track · corrodedC3 PDX - SEAT TRACK NR 19 HAS CORROSION AT STATION X449.5. REPAIRED IAW RD8/4-53-884.SDR QXEA200602838Seat Track · corrodedC3 PDX - SEAT TRACK NR 19 HAS CORROSION AT STATION X413.00 TO X444.00. REPAIRED IAW RD8/4-53-884.SDR 06FDEA03786Seat Track · corrodedM/D CARGO SEAT TRACK (STA 5/23, RH X=75.25) FOUND EDGE UNDER FLOOR CORRODED. REPAIR CARRIED OUT AT M/D CARGO SEAT TRACK AT STA 5/23 RH X=75.25 AS PER SRM 53-70- 00 FIGURE 5 VOLUME I. REPAIR CLASSIFIED AS MINOR AS PER GMM 6-2-100.SDR CALA0600432Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1517-1540, RBL 108 AND AT STA 1505-1543, LBL 108. THE SEAT TRACK SECTIONS WERE REPAIRED IAW SRM 53-00-52, FIGURE 202, REPAIR 4.SDR CALA0600431Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1497-1546, RBL 74, LBL 74. THE SEAT TRACK SECTIONS WERE REPAIRED IAW SRM 53-00-52, FIGURE 202, REPAIR 3.SDR CALA0600429Seat Track · corrodedINSPECTION FOUND LT I/B SEAT TRACK CORRODED AT STA 907-947.5, LBL 24.75. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR KCSA061474Seat Track · corrodedCORROSION ON MAIN DECK SEAT TRACK AT BS 1920, LBL 98.SDR QXEA200603455Seat Track · damagedC3 PDX - ALTERNATE SEAT TRACK IN AFT CARGO PIT INBOARD OF SEAT TRACK NR 15 HAS SCRATCH AT STATION X722. REPAIRED IAW RD8/4-53-884.SDR DHL2006363508Seat Track · corrodedMAIN CARGO COMPARTMENT FLOOR SUPPORT FS 20.5 LBL 80 SURFACE CORROSION. FABRICATED NEW SEAT TRACK AS REQUIRED FROM TMS 60-24257 7075T6,REF A300 SRM 51-10-40, TREATED AND PRIMED IAW A300 SRM 51-40-12. INSTALLED SEAT TRACK AT FS 20-22 LBL 80 IAW A300 SRM 53-10-SDR QXEA200602972Seat Track · damagedC3 PDX - SEAT TRACK NR 15 HAS SCRATCHES AND NICKS AT STATION X630, X654. REPAIRED IAW RD8/4-53-884.SDR QXEA200602971Seat Track · chafedC3 PDX - SEAT TRACK NR 14 HAS CHAFE AT STATION X604. REPAIRED IAW RD8/4-53-884.SDR QXEA200602970Seat Track · damagedC3 PDX - SEAT TRACK NR 7 HAS PIT AT STATION X358. REPAIRED IAW RD8/4-53-884.SDR QXEA200602969Seat Track · damagedC3 PDX - SEAT TRACK NR 7 HAS PIT AND CHAFE AT STATION X391. REPAIRED IAW RD8/4-53-884.SDR QXEA200602968Seat Track · damagedC3 PDX - SEAT TRACK NR 7 HAS GOUGES AND SCRATCHES AT STATION X405. REPAIRED IAW RD8/4-53-884.SDR QXEA200602967Seat Track · damagedC3 PDX - SEAT TRACK NR 7 HAS CHAFES, SCRATCHES, AND NICKS AT STATION X236, X268, X291, X297, X325, X348, X350, X355, X410 TO X424, X448, X475 TO X485, X508 TO X520, X540 TO X564 REPAIRED IAW RD8/4-53-884.SDR DHL2006363507Cargo Track · corrodedMAIN CARGO COMPARTMENT FLOOR SUPPORT FS 20.5 LBL 80 SURFACE CORROSION. FABRICATED NEW SEAT TRACK AS REQUIRED FROM TMS 60-24257 7075T6, REF A300 SRM 51-10-40, TREATED AND PRIMED IAW A300 SRM 51-40-12. INSTALLED SEAT TRACK AT FS 20-22 LBL 80 IAW A300 SRM 53-10SDR UPS06448519Seat Track · corrodedBS 2040 TO BS 2150 RBL 89 SEAT TRACK BOTTOM FLANGE CORRODED. CORROSION BLEND OUT 0.035" BY 1.5" BY 2" EXCEED SRM LIMIT. SEAT TRACK REPLACED AS PER SRM 51-10-01 P9 JUST AT M/D RBL89 BETWEEN BS2040 AND 2150.SDR QXEA200602933Seat Track · damagedC3 PDX - SEAT TRACK NR 15 HAS DEEP SCRATCHES IN BOTTOM OF TRACK CHANNEL FROM STATION X612 TO X624. REPAIRED IAW RD8/4-53-0884.SDR QXEA200602845Seat Track · corrodedC3 PDX - SEAT TRACK NR 18 HAS CORROSION AT STATION X229.5 TO X216.00. REPAIRED IAW RD8/4-53-884.SDR QXEA200602847Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 18 FROM STATION X196.00 TO X176.00. REPAIRED IAW RD8/4-53-884.SDR QXEA20060245Seat Track · corrodedC3 PDX-SEAT TRACK NR 18 HAS CORROSION AT STATION X229.5 TO X216.00. REPAIRED IAW RD8/4-53-884.SDR QXEA200602860Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 1 FROM STATION X32.4 TO X42.4. REPAIRED IAW RD8/4-53-884.SDR QXEA200602859Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 1 FROM STATION X67.00 TO X58.00. REPAIRED IAW RD8/4-53-884.SDR QXEA200602858Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 1 FROM STATION X84.00 TO X73.00. REPAIRED IAW RD8/4-53-884.SDR QXEA200602855Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 1 FROM STATION X156.00 TO X136.00. REPAIRED IAW RD8/4-53-884.SDR QXEA200602857Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 1 FROM STATION X94.00. REPAIRED IAW RD8/4-53-884.SDR QXEA200602854Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 1 FROM STATION X176.00 TO X168.00. REPAIRED IAW RD8/4-53-884.SDR QXEA200602853Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 1 FROM STATION X186.00. REPAIRED IAW RD8/4-53-884SDR QXEA200602852Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 1 FROM STATION X203.00 TO X189.00. REPAIRED IAW RD8/4-53-884SDR QXEA200602851Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 18 FROM STATION X116.00 TO X93.00. REPAIRED IAW RD8/4-53-884.SDR QXEA200602850Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 18 FROM STATION X136.00 TO X116.00. REPAIRED IAW RD8/4-53-884.SDR QXEA200602849Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 18 FROM STATION X156.00 TO X136.00. REPAIRED IAW RD8/4-53-884.SDR QXEA200602848Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 18 FROM STATION X176.00 TO X156.00. REPAIRED IAW RD8/4-53-884.SDR QXEA200602846Seat Track · corrodedC3 PDX - SEAT TRACK NR 18 HAS CORROSION AT STATION X216.00 TO X196.00. REPAIRED IAW RD8/4-53-884.SDR DHL2006363545Seat Track · corrodedMAIN CABIN FLOOR STRUCTURE UPPER FLANGE HAS CORROSION BETWEEN FS 12A AND 13A LBL18". REMOVED CORROSION AT MAIN CABIN FLOOR STRUCTURE UPPER FLANGE BETWEEN FS 12A AND 13A LBL18 IAW A300 SRM 51-40-11 MAT LOSS .018 MAT REMAINING .062 ORIGINAL MAT .080. FOUND OUTSDR DHL2006363547Seat Track · corrodedMAIN CABIN FLOOR STRUCTURE UPPER FLANGE HAS CORROSION BETWEEN FS 12A & 13A LBL18". REMOVED CORROSION AT MAIN CABIN FLOOR STRUCTURE UPPER FLANGE BETWEEN FS 12A & 13A LBL18 IAW A300 SRM 51-40-11 MAT LOSS .018 MAT REMAINING .062 ORIGINAL MAT .080. FOUND OUT OF SDR SIMA200631819Seat Track · corrodedDISC - FOUND LEFT OUTBOARD SEAT TRACK FROM FRAME 30 TO 36 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB SRM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR 06FDEA03768Seat Track · corrodedMAIN CABIN SEAT TRACK WORN BETWEEN STA1159 AND 1190 BBL 47. NON-ROUTINE-N00378 REMOVED AND REPLACED CORRODED SEAT TRACK, FABRICATED, ALODINED, PRIMED AND INSTALLED NEW SEAT TRACK IAW MD/DC 10 SRM 53-70-00 VOL I PAGE 21 AND 52-21-01 VOL II PAGE19. MECH 110207SDR 06FDEA03753Seat Track · corrodedM/DECK STA 5-53 X=-48 SEAT TRACK SPLICE FITTING LOWER SIDE FOUND CORRODED. REPAIR CARRIED OUT AT M/D CARGO SEAT TRACK AT STA 5-53 X=-48 AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 06FDEA03752Seat Track · corrodedM/DECK STA 5-11 X=-48 SEAT TRACK SPLICE LOWER SIDE FOUND CORRODED. REPAIR CARRIED OUT AT M/D CARGO SEAT TRACK AT STA 5-11 X=-48 AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 06FDEA03751Seat Track · corrodedMAIN DECK STA 1751 X=-9 SEAT TRACK FOUND CORRODED. REPAIR CARRIED OUT AT M/D CARGO SEAT TRACK AT STA 1751 RT X=8.5 AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 06FDEA03750Seat Track · corrodedFOUND EDGE UNDER FLOOR CORRODED, CARGO SEAT TRACK (STA 1316, RH X=75.25). REPAIR CARRIED OUT AT M/D CARGO SEAT TRACK AT STA 1316 RH X=75.25 AS PER SRM 53-70- 00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 06FDEA03749Seat Track · corrodedFOUND EDGE UNDER FLOOR CORRODED, CARGO SEAT TRACK (STA 1259, RT X=75.25). REPAIR CARRIED OUT AT M/D CARGO SEAT TRACK AT STA 1259 RH X=75.25 AS PER SRM 53-70- 00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR DHL2006363503Seat Track · corrodedCABIN FLOOR BETWEEN FRAME 15C AND 14C SEAT TRACK SUPPORT FLANGE AND SEAT TRACK FLANGE HAS CORROSION AT BL28R. REMOVED AND REPLACED CABIN FLOOR SEAT TRACK FROM FS 12A TO FS 15C LBL38 REF A300 SRM 51-10-40 AND TREATED AND PRIME AND APPLY TOP COAT AS NEEDED REF SDR DHL2006363504Seat Track · corrodedCABIN FLOOR BETWEEN FRAME 15C AND 14C SEAT TRACK SUPPORT FLANGE AND SEAT TRACK FLANGE HAS CORROSION AT BL28R. REMOVED AND REPLACED CABIN FLOOR SEAT TRACK FROM FS 12A TO FS 15C LBL 38 REF A300 SRM 51-10-40 AND TREATED AND PRIME AND APPLY TOP COAT AS NEEDED REFSDR QXEA200602821Seat Track · corrodedLT OB SEAT TRACK NR 1 HAS CORROSION AROUND EDGE OF CLAW OPENING AT STA X328. REPAIRED IAW SRM 51-20-36, 51-20-16 AND RD8-53-1342.SDR QXEA200602820Seat Track · corrodedC4 PDX - LT OB SEAT TRACK NR 1 HAS CORROSION AROUND EDGE OF CLAW OPENING AT STATION X363. REPAIRED IAW SRM 51-20-36, 51-20-16 AND RD8-53-1342.
Back to JASC 5347