N595SW, cancelled Nov 16, 2015
Service difficulty reports · 53
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 = 'N595SW' AND deregistration_id = 'N595SW-2015-11-16' 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 = 'N595SW' AND deregistration_id = 'N595SW-2015-11-16' 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 SWIA200110469Pitot Line · contaminatedABORTED TAKEOFF DUE TO EFIS COMP MON MESSAGE AND 60 KTS DISCREPANCY IN AIRSPEED. (CAT II). FOUND MOISTURE IN PITOT SYSTEM NR 2. PERFORMED CONTAMINATION REMOVAL, PURGE AND LEAK TEST PROCEDURES FOR SYSTEMS P1, P2 & P3 IAW MM 34-11-00. FUNCTIONAL TEST GOOD OFSDR SWIA200110382Warning System · malfunctionedSHORTLY AFTER TAKEOFF GOT THE FOLLOWING STATUS MESSAGES, IB GND SPLR FAULT & OB GND SPLR FAULT. MESSAGES DISAPPEARED AFTER LANDING. POWERED DOWN AIRCRAFT; POWERED UP. PERFORMED TEST OF SPOILER SYSTEM. COULD NOT DUPLICATE. OPS CHECK GOOD.SDR SWIA200110261Pump · leakingDURING FLIGHT HYDRAULIC SYSTEM NR 1 QUANTITY DROPPED TO 0 PERCENT. PSI REMAINED AT 3000 PSI. RETURNED TO SLC. FOUND NR 1 HYDRAULIC QUANTITY AT 15 PERCENT, SERVICED IAW 12-12-29. RAN NR 1 ENGINE, NO LEAKS NOTED AT ENGINE HYDRAULIC PUMP. OPERATED NR 1 ELECT
Back to N595SW, cancelled Nov 16, 2015