Hotton Aviation Co Inc
Earlier aircraft under this name · 33
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 = 'HOTTON AVIATION CO INC' OR list_contains(d.other_registrant_names, 'HOTTON AVIATION CO INC') 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 = 'HOTTON AVIATION CO INC' OR list_contains(d.other_registrant_names, 'HOTTON AVIATION CO INC') 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.
N63746Piper PA-31-310 · S/N 31-7712053N4656NCessna 402C · S/N 402C-0016N5154YCessna T210N · S/N 210-64098N4910YCessna T210N · S/N 21064040N5162NCessna 182 · S/N 182-67553N6585CCessna T210N · S/N 21063923N4797NCessna 182Q · S/N 18267375N5785MCessna T-310P · S/N 310P-0085N6236UCessna TU206G · S/N U20605392N24LTCessna T210L · S/N 21060937N6445NCessna T210N · S/N 21063021N732WBCessna T206 · S/N U20604731N761BECessna T210M · S/N 21062119N30025Piper PA-32-300 · S/N 32-7840194N6757MCessna U206G · S/N U20604510N761MYCessna T210M · S/N 21062375N761SCCessna T210M · S/N 21062472N735NWCessna 182Q · S/N 18265564N761FZCessna 210M · S/N 21062234N3572YCessna 182F · S/N 18254472N58495Cessna 182P · S/N 18262102N9936ECessna 182P · S/N 18263996N1718XCessna 210L · S/N 21060740N35817Cessna U206F · S/N U20602739N4731KCessna 182P · S/N 18263730N94179Cessna T210L · S/N 21060528N235WBeech V35B · S/N D-9723N7565NCessna 182P · S/N 18263254N92858Cessna 182N · S/N 18260400N52870Cessna 182P · S/N 18262913N235WCessna 182N · S/N 18260770N52699Cessna 182P · S/N 18262780N9108QBeech V35B · S/N D-9216
Back to Hotton Aviation Co Inc