Dan Howard Aircraft Sales LLC
Earlier aircraft under this name · 21
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'DAN HOWARD AIRCRAFT SALES LLC' OR list_contains(d.other_registrant_names, 'DAN HOWARD AIRCRAFT SALES LLC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'DAN HOWARD AIRCRAFT SALES LLC' OR list_contains(d.other_registrant_names, 'DAN HOWARD AIRCRAFT SALES LLC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N6545NCessna 210N · S/N 21063101N2891LCessna 172H · S/N 17256091N2265SCessna T210L · S/N 21061209N761BGCessna T210M · S/N 21062121N8142GCessna 210K · S/N 21059442N9956NCessna T210N · S/N 21063258N8733WPiper PA-28-235 · S/N 28-10273N2356FCessna 210E · S/N 21058556N6114ACessna T210N · S/N 21063499N2292QPiper PA-28-161 · S/N 28-7716098N7562MCessna T210M · S/N 21062020N8427MCessna 210M · S/N 21062043N93111Cessna 210L · S/N 21060266N274CSCessna 210L · S/N 21060148N9489MCessna 210M · S/N 21062081N2137SCessna 210L · S/N 21061098N2495SCessna 210L · S/N 21061304N1025QPiper PA-28R-201 · S/N 28R-7737024N732CQCessna 210L · S/N 21061413N761AYCessna 210M · S/N 21062113N5991FCessna 210H · S/N 21058991
Back to Dan Howard Aircraft Sales LLC