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 KCSA061320Seat Track · corrodedSEAT TRACK AT STA 705 LBL 66 CORRODED.SDR QXEA200602476Seat Track · corrodedC3 PDX - FOUND CORROSION PITTING IN RIGHT OUTBOARD SEAT TRACK AT X161. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602479Seat Track · damagedC3 PDX - CHAFE DAMAGE INSIDE SEAT TRACK NR 7 FROM STATION X457.5 TO X465.5. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602470Seat Track · corrodedC3 PDX-CORROSION INSIDE SEAT TRACK NR13 AT STATION X424.00. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602469Seat Track · corrodedC3 PDX-CORROSION INSIDE SEAT TRACK NR 7 AT STATION X423.00. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602467Seat Track · chafedC3 PDX-CHAFE DAMAGE INSIDE SEAT TRACK NR 7 AT STATION X373.100. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602466Seat Track · corrodedC3 PDX-CORROSION INSIDE SEAT TRACK NR7 AT STATION X311.00. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602465Seat Track · gougedC3 PDX-GOUGES INSIDE SEAT TRACK NR 7 AT STATION X281.00. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602468Seat Track · gougedC3 PDX-GOUGE INSIDE SEAT TRACK NR 7 AT STATION X397.00. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602446Seat Track · corrodedC3 PDX-CORROSION ON SEAT TRACK NR 11 AT STATION X 70.00. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR QXEA200602435Seat Track · unknownC3 PDX-MTX REQUEST TO REPLACE RT OB SEAT TRACK NR 14 STATION X.229.5 - 570.0. REPAIRED IAW SRM 51-42-05, SRM 51-40-15, AND SRM 51-42-90.SDR QXEA200602437Seat Track · chafedC3 PDX-CHAFE DAMAGE INSIDE SEAT TRACK NR 13 AT STATION X 555.8. REPAIRED IAW RD84-53-884.SDR QXEA200602447Seat Track · chafedC3 PDX-CHAFE DAMAGE INSIDE SEAT TRACK NR 6 FROM STATION X 144.00 TO X 156.00. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR QXEA200602439Seat Track · corrodedC3 PDX-CORROSION INSIDE TRACK NR 9 AT STATION X 705.00. REPAIRED IAW RD84-53-884 AND SRM 51-42-05.SDR QXEA200602438Seat Track · chafedC3 PDX - CHAFE DAMAGE INSIDE SEAT TRACK NR 8 AT STATION X 604.5. REPAIRED IAW RD84-53-884 AND SRM 51-20-10.SDR QXEA200602449Seat Track · gougedC3 PDX - GOUGES INSIDE SEAT TRACK NR 6 AT STATION X 202.00. REPAIRED IAW RD 53-884 AND SRM 51-21-10.SDR QXEA200602445Seat Track · corrodedC3 PDX - CORROSION ON SEAT TRACK NR 11 AROUND RIVET HEAD INBOARD SIDE AT STATION X 71.200. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR QXEA200602444Seat Track · gougedC3 PDX - GOUGE INSIDE SEAT TRACK NR 5 AT STATION X 75.00. REPAIRED IAW RD 84-53-884, SRM 51-21-10.SDR QXEA200602440Seat Track · out of alignmentC3 PDX - RIGHT OUTBOARD SEAT TRACK NR 20 AT STATION X570.0 TO X 669.0 REQUIRED REALIGNMENT. REPAIRED IAW SRM 51-42-05, SRM 51-40-07.SDR QXEA200602452Seat Track · damagedC3 PDX - SRATCH INSIDE SEAT TRACK NR 12 AT STATION X 161.00. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR QXEA200602451Seat Track · chafedC3 PDX - CHAFE DAMAGE INSIDE SEAT TRACK NR 12 FROM STATION X 176.00 TO X 189.00. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR QXEA200602450Seat Track · chafedC3 PDX - CHAFE DAMAGE INSIDE SEAT TRACK 36 FROM STATION X 212.00 TO X 225.00. REPAIRED IAW RD 53-884 AND SRM 51-21-10.SDR QXEA200602448Seat Track · gougedC3 PDX - GOUGE INSIDE SEAT TRACK NR 6 AT STATION X 167.00. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR KCSA061315Seat Track · crackedSTA 980 TO 1020 AT RBL 99 SEVERAL AREA'S OF CORROSION ABOVE AND BELOW SEAT TRACK FLANGES.SDR QXEA200602478Seat Track · corrodedC3 PDX - CORROSION IN SEAT TRACK RIGHT OUTBOARD AT X211.5. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602477Seat Track · corrodedC3 PDX - CORROSION IN RIGHT OUTBOARD SEAT TRACK AT X169 TO X172. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602471Seat Track · corrodedC3 PDX-LT OB SEAT TRACK PITTED AT STATION X600. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602472Seat Track · corrodedC3 PDX-LT OB SEAT TRACK PITTED AT STATION X635. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602474Seat Track · gougedC3 PDX-GOUGE AND STRATCHES IN SEAT TRACK RT SIDE OB AT X125 TO X130. REPAIRED IAW RD-84-53-884 AND SRM 51-25-10.SDR QXEA200602473Seat Track · gougedC3 PDX-GOUGE ON RT OB SEAT TRACK AT X110. REPAIRED IAW RD-84-53-884 AND SRM 51-25-10.SDR QXEA200602464Seat Track · corrodedC3 PDX - FOUND CORROSION INSIDE SEAT TRACK NR 1 AT STATION X198.00. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602463Seat Track · corrodedC3 PDX - FOUND CORROSION INSIDE SEAT TRACK NR 1 AT STATION X187.00. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602460Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 1 AT STATION X136.00. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR QXEA200602456Seat Track · chafedC3 PDX - CHAFE DAMAGE ON SEAT TRACK NR 1 AT STATION X77.00. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR QXEA200602457Seat Track · chafedC3 PDX - CHAFE DAMAGE ON SEAT TRACK NR 1 AT STATION X94.800. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR QXEA200602461Seat Track · chafedC3 PDX - CHAFE DAMAGE INSIDE SEAT TRACK NR 1 FROM STATION X138.00 TO X160.00. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602459Seat Track · chafedC3 PDX - CHAFE DAMAGE INSIDE SEAT TRACK NR 1 FROM STATION X116.00 TO X130.00. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR QXEA200602455Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 1 FROM STATION X32.400 TO X64.00. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR QXEA200602462Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK AT STATION X170.00. REPAIRED IAW RD-84-53-884 AND SRM 51-21-10.SDR QXEA200602458Seat Track · corrodedC3 PDX - CORROSION ON AND IN SEAT TRACK NR 1 AT STATION X107.800. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR QXEA200602443Seat Track · corrodedC3 PDX - RIGHT INBOARD SEAT TRACK CORRODED ON TOP SURFACE AT STATION X 747 TO 752. REPAIRED IAW RD 84-53-884, SRM 51-40-10, AND SRM 51-42-05.SDR QXEA200602441Seat Track · corrodedC3 PDX - PITTING CORROSION ON SEAT TRACK NR 18 AT STATION 201. REPAIRED IAW RD 84-53-884 AND SRM 51-00-06, SRM 51-21-10.SDR QXEA200602442Seat Track · corrodedC3 PDX -LEFT SEAT TRACK HAS CORROSION AT STATION X 587. REPAIRED IAW RD 84-53-884 AND SRM 51-21-10.SDR KCSA061300Seat Track · corrodedFOUND SEAT TRACK AT STA 720 RBL99 HAS CORROSION.SDR KCSA061299Seat Track · corrodedFOUND SEAT TRACK AT STA 380 TO 400 LBL11 CORRODED.SDR KCSA061298Seat Track · corrodedFOUND SEAT TRACK STA 460 LBL88 CORRODED.SDR KCSA061297Seat Track · corrodedFOUND SEAT TRACK CORRODED AT STA 1480 LBL98 WL200.SDR KCSA061292Seat Track · corrodedFOUND SEAT TRACK CORRODED AT STA 705 LBL-48.SDR DHL2006745538Seat Track · corrodedCABIN SEAT TRACK BS 980, RBL 25 HAS CORROSION AS MARKED. REMOVED & REINSTALLED FLOORBOARD AFTER FAB SEAT TRACK FROM BS 950E TO 1060, RBL 24. REMOVED SEAT TRACK & FAB NEW FROM P/N BAC 1520-792, PO 9003091 DIM 103", TREATED, PRIMED, & INSTALLED NEW FAB SEAT TRSDR SIMA200626112Seat Track · corrodedINSPECTED PREVIOUS REPAIR ON SEAT TRACK BL 18.3L AT STATION 298 WAS FOUND CORRODED. REMOVED A 32.1 SECTION OF SEAT TRACK TO PREVIOUS REPAIR AND CLEANED THE AREA. INSTALL U-BEAM AND TRACK. REPAIR DONE IAW SAAB 340 SRM, SRM 72LKS 3079 REV 17, CHAPTER 53-70-60
Back to JASC 5347