Consolidated Vultee Aircraft Corp

Earlier aircraft under this name · 45

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 VULTEE AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'CONSOLIDATED VULTEE AIRCRAFT CORP')
  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.

N90850Consolidated Vultee 118 · S/N 2Cancelled Mar 20, 1956 · San Diego, CAN8551KStinson 108-1 · S/N 108-1551Cancelled Feb 17, 1956 · Wayne, MIN8557KStinson 108-1 · S/N 108-1557Cancelled Feb 17, 1956 · Wayne, MIN9017KStinson 108-1 · S/N 108-2017Cancelled Feb 14, 1956 · Wayne, MIN9027KStinson 108-1 · S/N 1082027Cancelled Feb 14, 1956 · Wayne, MIN9207KStinson 108-1 · S/N 108-2207Cancelled Feb 14, 1956 · Wayne, MIN9284KStinson 108-1 · S/N 108-2284Cancelled Feb 14, 1956 · Wayne, MIN9446KStinson 108-2 · S/N 1082446Cancelled Feb 14, 1956N153CStinson 108-2 · S/N 108-3153Cancelled Oct 17, 1955 · Wayne, MIN203CStinson 108-2 · S/N 108-3203Cancelled Oct 17, 1955 · Wayne, MIN8141KStinson 108-1 · S/N 108-1-1141Cancelled Oct 17, 1955 · Built 1943 · Wayne, MIN8147KStinson 108-1 · S/N 108-1-1147Cancelled Oct 17, 1955 · Built 1946 · Wayne, MIN8346KStinson 108-1 · S/N 108-1346Cancelled Oct 17, 1955 · Built 1946 · Wayne, MIN8711KStinson 108-1 · S/N 108-1711Cancelled Oct 17, 1955 · Wayne, MIN8757KStinson 108-1 · S/N 108-1757Cancelled Oct 17, 1955 · Wayne, MIN9776KStinson 108-2 · S/N 108-2776Cancelled Oct 17, 1955N4086CStinson 108-3 · S/N 108-5086Cancelled Oct 14, 1955 · Wayne, MIN4258CStinson 108-3 · S/N 108-5258Cancelled Oct 14, 1955 · Wayne, MIN591CStinson 108-3 · S/N 108-3591Cancelled Oct 14, 1955 · Wayne, MIN8241KStinson 108-1 · S/N 108-1-1241Cancelled Aug 10, 1954 · Wayne, MIN8423HConvair 340 · S/N 140Cancelled Apr 30, 1954 · San Diego, CAN90654Consolidated Vultee 116 · S/N 1Cancelled Mar 20, 1950 · San Diego, CAN821CStinson 108-3 · S/N 108-3821Cancelled Sep 22, 1949 · Exported to China · Wayne, MIN97487Stinson 108 · S/N 108-487Cancelled Aug 22, 1949 · Wayne, MIN90839Convair 240 · S/N 75Cancelled Jun 15, 1949 · Exported to Pakistan · San Diego, CAN97508Stinson 108 · S/N 108-508Cancelled Jun 14, 1949 · Wayne, MIN97127Stinson 108-1 · S/N 108-1-1127Cancelled May 2, 1949 · Wayne, MIN40004Consolidated Vultee - Stinson 106 · S/N 1Cancelled Sep 17, 1948 · Built 1945 · Wayne, MIN31519Stinson 108 · S/N 1Cancelled Aug 13, 1948 · Wayne, MIN3939Consolidated Vultee 39 · S/N 2Cancelled Mar 30, 1948 · Built 1944 · Sand Diego, CAN8151KStinson 108-1 · S/N 108-1-1151Cancelled Feb 11, 1948 · Wayne, MIN8187KStinson 108-1 · S/N 108-1-1187Cancelled Feb 11, 1948 · Exported to Argentina · Wayne, MIN97853Stinson 108-1 · S/N 853Cancelled Feb 11, 1948 · Exported to Chile · Built 1946 · Wayne, MIN8171KStinson 108-1 · S/N 108-1-1171Cancelled Feb 3, 1948 · Exported to Brazil · Wayne, MIN8851KStinson 108-1 · S/N 108-1851Cancelled Feb 3, 1948 · Wayne, MIN9111KStinson 108-1 · S/N 108-2111Cancelled Feb 3, 1948 · Wayne, MIN9112KStinson 108-1 · S/N 108-2112Cancelled Feb 3, 1948 · Wayne, MIN9113KStinson 108-1 · S/N 108-2113Cancelled Feb 3, 1948 · Wayne, MIN9153KStinson 108-1 · S/N 108-2153Cancelled Feb 3, 1948 · Wayne, MIN9166KStinson 108-1 · S/N 108-2166Cancelled Feb 3, 1948 · Wayne, MIN9182KStinson 108-1 · S/N 108-2182Cancelled Feb 3, 1948 · Exported to Uruguay · Wayne, MIN9227KStinson 108-1 · S/N 108-2227Cancelled Feb 3, 1948 · Wayne, MIN9541KStinson 108-2 · S/N 108-2541Cancelled Feb 3, 1948 · Wayne, MIN9507KStinson 108 · S/N 108-2507Cancelled May 19, 1947 · Exported to Mexico · Wayne, MIN8211KStinson 108-1 · S/N 108-1-1211Cancelled Jan 17, 1947 · Built 1946 · Wayne, MI
Back to Consolidated Vultee Aircraft Corp