N313SW, cancelled Sep 8, 2017
Service difficulty reports · 402
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 n_number = 'N313SW' AND deregistration_id = 'N313SW-2017-09-08' 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 n_number = 'N313SW' AND deregistration_id = 'N313SW-2017-09-08' 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 SWAA950576Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN DENTED AT BS 500 PLUS 6, STRINGER 23R AT BS 860 STRINGER 26L BETWEEN BS 909 AND 916 STRINGER 24R AND AT BS 330 STRINGER 25L. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950462Pump · inopDURING CLIMBOUT, EXPERIENCED SYSTEM A HYDRAULIC PRESSURE LOSS. AIRCRAFT RETURNED TO ELP AND MADE AN UNEVENTFUL LANDING. INSPECTED AND FOUND A SYSTEM HYDRAULIC PUMP INOP. REPLACED AND SERVICED SYSTEM PER BOEING M/M.
Back to N313SW, cancelled Sep 8, 2017