N393SW, cancelled Apr 20, 2011
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 = 'N393SW' AND deregistration_id = 'N393SW-2011-04-20' 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 = 'N393SW' AND deregistration_id = 'N393SW-2011-04-20' 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 SWIA971596unknownDE-ICE BOOT FAILURE LEADING EDGE DEVICES LEFT AND RIGHT OUTBOARD STABILIZER ALSO HAD LEFT AND RIGHT MIDDLE AND OUTBOARD WING FAILURE IN FLIGHT. RETURNED TO SEA. TIGHTENED PNEUMATIC LINE ON DE-ICE MANIFOLD. INSTALLED SERVICEABLE STABILIZER EJECTOR VALVE. ALSDR SWIA971595unknownOUTBOARD LEFT AND RIGHT STABILIZER AND MIDDLE AND OUTBOARD RIGHT WING BOOTS FAIL BOTH TIMERS AND CYCLES. FAILURE OCCURED EN ROUTE BLI. RETURNED TO SEA. REPLACED MIDDLE WING BOOT EJECTOR FLOW CONTROL VALVE IAW MM 30-70-04. REPLACED RIGHT ENGINE PRESSURE REGSDR SWIA971027Ejector Valves · lack of lubeDE-ICE BOOTS (LEADING EDGES) AND LEFT ENGINE AIR INLET WOULD NOT INFLATE. FAILED ALL DE-ICE TESTS ON TIMER 1 HEAVY CYCLE AND (L) INBOARD AND (L) OUTBOARD BOOTS FAILED ON TIMER 2 (ANY CYCLE). RETURNED TO LAX. LUBED EJECTOR VALVES AND RAN ENGINES. DE-ICE OPS
Back to N393SW, cancelled Apr 20, 2011