OpenAirDocs.org
Trade-Ayer Inc

Earlier aircraft under this name · 20

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

N10019Consolidated Vultee PBY-5A · S/N 48335Cancelled Nov 8, 1963 · Linden, NJN6625DLockheed PV-2 · S/N 37345Cancelled Nov 14, 1962 · Linden, NJN6626DLockheed PV-2 · S/N 37353Cancelled Nov 14, 1962 · Linden, NJN6630DLockheed PV-2 · S/N 37533Cancelled Nov 14, 1962 · Linden, NJN6616DLockheed PV-2 · S/N 37142Cancelled Nov 13, 1962 · Linden, NJN6618DLockheed PV-2 · S/N 37200Cancelled Nov 13, 1962 · Linden, NJN6619DLockheed PV-2 · S/N 37231Cancelled Nov 13, 1962 · Linden, NJN6620DLockheed PV-2 · S/N 37285Cancelled Nov 13, 1962 · Linden, NJN6621DLockheed PV-2 · S/N 37274Cancelled Nov 13, 1962 · Linden, NJN6623DLockheed PV-2 · S/N 37304Cancelled Nov 13, 1962 · Linden, NJN6624DLockheed PV-2 · S/N 37339Cancelled Nov 13, 1962 · Linden, NJN6631DLockheed PV-2 · S/N 37437Cancelled Nov 13, 1962 · Linden, NJN6632DLockheed PV-2 · S/N 37457Cancelled Nov 13, 1962 · Linden, NJN6633DLockheed PV-2 · S/N 37461Cancelled Nov 13, 1962 · Linden, NJN6635DLockheed PV-2 · S/N 37478Cancelled Nov 13, 1962 · Linden, NJN6638DLockheed PV-2 · S/N 37486Cancelled Nov 13, 1962 · Linden, NJN6639DLockheed PV-2 · S/N 37493Cancelled Nov 13, 1962 · Linden, NJN6640DLockheed PV-2 · S/N 37494Cancelled Nov 13, 1962 · Linden, NJN6641DLockheed PV-2 · S/N 37505Cancelled Nov 13, 1962 · Linden, NJN10013Command-Aire 3C-3 · S/N 534Cancelled Jul 20, 1956 · Exported to Canada
Back to Trade-Ayer Inc