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.

N63746Piper PA-31-310 · S/N 31-7712053Cancelled Apr 15, 1983 · Exported to Mexico · Tucson, AZN4656NCessna 402C · S/N 402C-0016Cancelled May 4, 1982 · Exported to Mexico · Tucson, AZN5154YCessna T210N · S/N 210-64098Cancelled Jan 29, 1981 · Exported to Mexico · Tucson, AZN4910YCessna T210N · S/N 21064040Cancelled Jan 12, 1981 · Exported to Mexico · Tucson, AZN5162NCessna 182 · S/N 182-67553Cancelled Dec 16, 1980 · Exported to Mexico · Tucson, AZN6585CCessna T210N · S/N 21063923Cancelled Oct 30, 1980 · Exported to Mexico · Tucson, AZN4797NCessna 182Q · S/N 18267375Cancelled Sep 18, 1980 · Exported to Mexico · Tucson, AZN5785MCessna T-310P · S/N 310P-0085Cancelled Apr 10, 1980 · Exported to Mexico · Tucson, AZN6236UCessna TU206G · S/N U20605392Cancelled Jan 25, 1980 · Exported to Mexico · Tucson, AZN24LTCessna T210L · S/N 21060937Cancelled Jan 8, 1980 · Exported to Mexico · Built 1975 · Tucson, AZN6445NCessna T210N · S/N 21063021Cancelled Apr 2, 1979 · Exported to Mexico · Tucson, AZN732WBCessna T206 · S/N U20604731Cancelled Dec 27, 1978 · Tucson, AZN761BECessna T210M · S/N 21062119Cancelled Dec 27, 1978 · Exported to Mexico · Tucson, AZN30025Piper PA-32-300 · S/N 32-7840194Cancelled Nov 3, 1978 · Tucson, AZN6757MCessna U206G · S/N U20604510Cancelled Aug 10, 1978 · Exported to Mexico · Tucson, AZN761MYCessna T210M · S/N 21062375Cancelled Aug 4, 1978 · Exported to Mexico · Tuscon, AZN761SCCessna T210M · S/N 21062472Cancelled Mar 10, 1978 · Exported to Mexico · Tucson, AZN735NWCessna 182Q · S/N 18265564Cancelled Oct 31, 1977 · Exported to Mexico · Tucson, AZN761FZCessna 210M · S/N 21062234Cancelled Oct 19, 1977 · Exported to Mexico · Tucson, AZN3572YCessna 182F · S/N 18254472Cancelled May 23, 1977 · Exported to Canada · Tucson, AZN58495Cessna 182P · S/N 18262102Cancelled Aug 13, 1975 · Exported to Mexico · Tucson, AZN9936ECessna 182P · S/N 18263996Cancelled Aug 7, 1975 · Exported to Mexico · Tucson, AZN1718XCessna 210L · S/N 21060740Cancelled Jul 10, 1975 · Exported to Mexico · Tucson, AZN35817Cessna U206F · S/N U20602739Cancelled Jul 3, 1975 · Exported to Mexico · Built 1975 · Tucson, AZN4731KCessna 182P · S/N 18263730Cancelled Jun 20, 1975 · Exported to Mexico · Built 1975 · Tucson, AZN94179Cessna T210L · S/N 21060528Cancelled Jun 12, 1975 · Exported to Mexico · Tucson, AZN235WBeech V35B · S/N D-9723Cancelled Feb 26, 1975 · Exported to Mexico · Tucson, AZN7565NCessna 182P · S/N 18263254Cancelled Feb 26, 1975 · Exported to Mexico · Tucson, AZN92858Cessna 182N · S/N 18260400Cancelled Feb 18, 1975 · Exported to Mexico · Tucson, AZN52870Cessna 182P · S/N 18262913Cancelled Dec 12, 1974 · Exported to Mexico · Tucson, AZN235WCessna 182N · S/N 18260770Cancelled Nov 19, 1974 · Exported to Mexico · Tucson, AZN52699Cessna 182P · S/N 18262780Cancelled Apr 30, 1974 · Exported to Mexico · Tuscon, AZN9108QBeech V35B · S/N D-9216Cancelled Apr 29, 1974 · Exported to Mexico · Built 1970 · Tucson, AZ
Back to Hotton Aviation Co Inc