Centaur Aviation Inc

Earlier aircraft under this name · 16

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 = 'CENTAUR AVIATION INC' OR list_contains(d.other_registrant_names, 'CENTAUR AVIATION 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.

N8279MCessna 210K · S/N 21059279Cancelled Jul 3, 2013 · Registration expired, pending cancellation · Built 1970 · Memphis, TNN89710Cessna 152 · S/N 15282835Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1978 · Olive Branch, MSN5294ACessna 210N · S/N 21063352Cancelled Mar 6, 1980 · Exported to South Africa · Olive Branch, MSN48973Cessna 152 · S/N 15283396Cancelled Aug 28, 1979 · Exported to Pakistan · Olive Branch, MSN733BMCessna U206G · S/N U20604750Cancelled Jul 19, 1979 · Exported to Canada · Olive Branch, MSN5182ACessna 210N · S/N 21063298Cancelled Jul 5, 1979 · Exported to Australia · Olive Branch, MSN96947Cessna 182Q · S/N 18266906Cancelled Jun 22, 1979 · Exported to Australia · Olive Branch, MSN65420Cessna 152 · S/N 152-81542Cancelled Dec 28, 1978 · Exported to Australia · Olive Branch, MSN65503Cessna 152 · S/N 152-81590Cancelled Dec 28, 1978 · Exported to Australia · Olive Branch, MSN739WPCessna 172N · S/N 17270867Cancelled Dec 28, 1978 · Exported to New Zealand · Olive Branch, MSN9943MCessna U206G · S/N U20604593Cancelled Dec 20, 1978 · Exported to Australia · Olive Branch, MSN3041ECessna 172N · S/N 17271412Cancelled Nov 17, 1978 · Exported to Australia · Olive Branch, MSN94963Cessna 182Q · S/N 18266548Cancelled Nov 17, 1978 · Exported to Australia · Olive Branch, MSN94870Cessna 182Q · S/N 18266525Cancelled Nov 9, 1978 · Exported to AustraliaN94945Cessna 182Q · S/N 182-66543Cancelled Sep 26, 1978 · Exported to Australia · Olive Branch, MSN94662Cessna 182Q · S/N 18266482Cancelled Aug 3, 1978 · Exported to Australia · Olive Branch, MS
Back to Centaur Aviation Inc