Consolidated Air Parts Co

Earlier aircraft under this name · 23

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 = 'CONSOLIDATED AIR PARTS CO' OR list_contains(d.other_registrant_names, 'CONSOLIDATED AIR PARTS CO')
  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.

N4822EDouglas A-26 · S/N 44-35994Cancelled Nov 1, 1973 · North Hollywood, CAN8626EDouglas B-26 · S/N 44-34642Cancelled Nov 1, 1973 · Built 1959 · North Hollywood, CAN9300RDouglas B-26C · S/N 44-35857Cancelled Jun 28, 1971 · Exported to Canada · North Hollywood, CAN6600RBeech C-45H · S/N 52-10781Cancelled Mar 23, 1971 · N Hollywood, CAN6601RBeech C-45H · S/N 52-10831Cancelled Mar 23, 1971 · Sanford, MEN6608RBeech C-45H · S/N 51-11789Cancelled Mar 23, 1971 · Sanford, MEN6609RBeech C-45H · S/N 51-11546Cancelled Mar 23, 1971 · Sanford, MEN6610RBeech C-45H · S/N 55-10709Cancelled Mar 23, 1971 · Sanford, MEN6617RBeech C-45H · S/N 52-10542Cancelled Mar 23, 1971 · No Hollywood, CAN6623RBeech C-45H · S/N 52-10789Cancelled Mar 23, 1971 · N Hollywood, CAN6626RBeech C-45H · S/N 52-10935Cancelled Mar 23, 1971 · N Hollywood, CAN6632RBeech C-45H · S/N 51-11786Cancelled Mar 23, 1971 · Built 1960 · North Hollywood, CAN6633RBeech C-45H · S/N 51-11620Cancelled Mar 23, 1971 · Built 1961 · Noth Hollywood, CAN6634RBeech C-45H · S/N 51-11675Cancelled Mar 23, 1971 · Built 1961 · North Hollywood, CAN6635RBeech C-45H · S/N 51-11666Cancelled Mar 23, 1971 · Built 1961 · North Hollywood, CAN6639RBeech C-45H · S/N 52-10635Cancelled Mar 23, 1971 · N Hollywood, CAN6641RBeech C-45H · S/N 51-11828Cancelled Mar 23, 1971 · Hollywood, CAN6644RBeech C-45H · S/N 51-11447Cancelled Mar 23, 1971N6646RBeech C-45H · S/N 51-11820Cancelled Mar 23, 1971 · Hollywood, CAN6647RBeech C-45H · S/N 52-10963Cancelled Mar 23, 1971 · Hollywood, CAN6649RBeech C-45H · S/N 52-10659Cancelled Mar 23, 1971 · Hollywood, CAN6653RBeech C-45H · S/N 52-10782Cancelled Mar 23, 1971 · Hollywood, CAN8628EDouglas B-26 · S/N 44-35969Cancelled Dec 19, 1968 · Exported to Brazil · Built 1959 · North Hollywood, CA
Back to Consolidated Air Parts Co