OpenAirDocs.org
Vandalia, OH

Cancelled registrations · 36

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_state = 'OH' AND d.registrant_city = 'VANDALIA'
  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.

N241PSBombardier CL-600-2B19 · S/N 7909Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Psa Airlines IncN216PSBombardier CL-600-2B19 · S/N 7882Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 2003 · Psa Airlines IncN8349YPiper PA-30 · S/N 30-1496Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1967 · Richardson KennethN125VSwing Brian S VELOCITY RG · S/N DM 074Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1989 · Swing Brian SN3BQCessna 140 · S/N 11589Cancelled Jul 30, 2012 · Registration pending, canceled · Built 1946N951RMcdonnell Douglas DC-8-63 · S/N 46092Cancelled Feb 19, 2004 · Triennial form not returned · Emery Worldwide Airlines IncN37253Beech 77 · S/N WA122Cancelled Aug 5, 1994 · Triennial form not returned · Crossroads Aero Club IncN133MBRobinson Helicopter R22 BETA · S/N 1133Cancelled Feb 7, 1994 · Triennial form not returned · M G Helicopters IncN42BRPiper PA-31-310 · S/N 317712021Cancelled Nov 29, 1990 · Exported to Australia · Aviation Sales IncN55892Piper PA-28-180 · S/N 28-7305493Cancelled Jun 27, 1974 · Exported to Germany · Skyways IncN51208Cessna 150J · S/N 15069839Cancelled Aug 1, 1972 · Exported to Canada · Aviation Sales IncN50594Cessna 150J · S/N 15069421Cancelled Jul 13, 1972 · Exported to Canada · Aviation Sales IncN849PSPiper PA-23-250 · S/N 27-3913Cancelled Jul 5, 1972 · Exported to Canada · Skyways IncN3172RPiper PA-28R-180 · S/N 28R-31120Cancelled Apr 24, 1972 · Exported to Germany · Built 1969 · Skyways IncN79407Cessna 172K · S/N 17258058Cancelled Dec 3, 1971 · Van Dusen Aircraft Supply Ohio Division IncN22818Cessna 150H · S/N 15068538Cancelled Jan 26, 1971 · Aviation Sales IncN5041ZPiper PA-22 · S/N 22-8661Cancelled Jan 25, 1971 · Skyways IncN88MW B B Associates BIGOS RACER · S/N 101Cancelled Sep 18, 1970 · Dayton Air Racing AssociationN2157CCessna 195B · S/N 16142Cancelled Jun 17, 1970 · L Horbe William DeN5314Beech D50C · S/N DH-284Cancelled Jan 2, 1970 · Ohio Aviation CoN1902EAeronca 7AC · S/N 7AC5469Cancelled May 25, 1965 · Skyways IncN84603Aeronca 7AC · S/N 7AC3310Cancelled May 24, 1965 · Skyways IncN1342EAeronca 7AC · S/N 7AC-4903Cancelled May 22, 1965 · Skyways IncN2889EAeronca 7AC · S/N 7AC6472Cancelled May 22, 1965 · Skyways IncN6792PPiper PA-24-250 · S/N 24-1925Cancelled May 20, 1965 · Skyways IncN18388Barkley - Grow T8P-1 · S/N 1Cancelled May 26, 1964 · Exported to Canada · Built 1937 · Dayton Aircraft Sales IncN44594Beech D18S · S/N A-3Cancelled Jul 6, 1956 · Exported to Canada · Ohio Aviation CompanyN39633Aeronca 7AC · S/N 7AC-4Cancelled Mar 5, 1956 · Built 1945 · Skyways IncN64728Consolidated Vultee BT-13A · S/N 2595Cancelled Feb 17, 1956 · Skyways IncN61561Consolidated Vultee BT-13B (SNV-2) · S/N 79-234Cancelled Oct 12, 1955 · Mcintyre Ken RN61635Fairchild PT-23 · S/N H0-308Cancelled Oct 12, 1955 · Skyways IncN7482KPiper PA-20 · S/N 20-395Cancelled Nov 15, 1951 · Mackall H C JrN4397KRyan NAVION · S/N NAV-4-1397Cancelled Jun 14, 1949 · Built 1948 · Southern Ohio Aviation CoN91119North American NAVION · S/N NAV443Cancelled Apr 22, 1949 · Souther Ohio Aviation CoN17459Waco ZGC-7 · S/N 4553Cancelled Apr 22, 1948 · Built 1937 · Dayton Airways IncN368HDavis V-3 · S/N 104Cancelled Jun 1, 1932 · Johnson Edward A
Back to Vandalia, OH