OpenAirDocs.org
Aerospace Products 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 = 'AEROSPACE PRODUCTS INC' OR list_contains(d.other_registrant_names, 'AEROSPACE PRODUCTS 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.

N90961Douglas DC-6B · S/N 44689Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1955 · N Hollywood, CAN9869ZBeech C-45H · S/N AF-235Cancelled Aug 26, 2004 · Triennial form not returned · Built 1951 · North Hollywood, CAN61726Douglas C-47 · S/N 20024Cancelled Dec 14, 1998 · Triennial form not returned · N Hollywood, CAN400JRBeech 65-A80 · S/N LD158Cancelled Mar 12, 1993 · North Hollywood, CAN6062GCessna 150K · S/N 15071562Cancelled Oct 15, 1990 · Exported to Philippines · Hollywood, CAN7825Beech 3N · S/N A-680Cancelled May 28, 1976 · Revoked, pending cancellation · Built 1952 · North Hollywood, CAN31APBeech 3NM · S/N CA-141Cancelled May 20, 1976 · Built 1952 · N Hollywood, CAN1511SBeech H-18 · S/N BA-636Cancelled May 13, 1976 · North Hollywood, CAN15565Douglas DC3 · S/N 4849Cancelled May 13, 1976 · North Hollywood, CAN7810Beech 3NM · S/N CA-109Cancelled Oct 3, 1974 · Exported to Canada · North Hollywood, CAN43VDouglas DC3 · S/N 42958Cancelled Jul 19, 1974 · Exported to Colombia · North Hollywood, CAN14423Beech 18S · S/N CA15Cancelled Aug 17, 1973 · North Hollywood, CAN9XBeech D18S · S/N A-327Cancelled Sep 26, 1972 · Exported to Canada · Built 1946 · North Hollywood, CAN4709CBeech C-45H · S/N AF-819Cancelled Apr 23, 1971 · North Hollywood, CAN28344Douglas DC3 · S/N 3281Cancelled Oct 31, 1966 · Built 1940 · North Hollywood, CAN33609Douglas DC-3A-S1C3G · S/N 4100Cancelled Nov 19, 1964 · Exported to Mexico · Built 1941 · North Hollywood, CA
Back to Aerospace Products Inc