OpenAirDocs.org
Vandalia, OH

Registered aircraft · 21

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'OH' AND g.registrant_city = 'VANDALIA'
  ORDER BY g.n_number"

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.

N121RBCirrus Design SR22 · S/N 5079Built 2021 · Bergmanone LLCN151ASocata TB 10 · S/N 764Macnealy Gregory AN177BCCessna 177B · S/N 17701803Built 1972 · Craig William RichardN182EVEvektor-Aerotechnik SPORTSTAR PLUS · S/N 20071002Built 2007 · Marshall Timothy WN220RSPilatus PC-24 · S/N 260Built 2022 · Bergmantwo LLCN232SRCirrus Design SR22 · S/N 1990Registration pendingBuilt 2006N236NXPilatus PC-12/47E · S/N 1236Built 2010 · Hj Aviation LLCN2521YCessna 172D · S/N 17249821Built 1962 · Clanin James RobertN262LMDiamond Aircraft Ind DA 62 · S/N 62.C033Lone Mountain Aircraft LLCN336BCirrus Design SR22 · S/N 2049Built 2006 · Wright Brothers Aero IncN3482EAeronca 7AC · S/N 7AC-6863Built 1947 · Bruner Kevin GN4418TPiper PA-32-300 · S/N 32-7240079Built 1972 · Rankin Kevin KN5775QMooney M20E · S/N 746Built 1965 · Singer DavidN594MCirrus Design SR20 · S/N 2595Built 2020 · Lone Mountain Aircraft LLCN679LMCirrus Design SR22 · S/N 1679Built 2005 · Lone Mountain Aircraft LLCN712RACirrus Design SR22 · S/N 1933Built 2006 · Lone Mountain Aircraft LLCN717APCirrus Design SR22 · S/N 3289Built 2008 · Lone Mountain Aircraft LLCN79EMCirrus Design SR22 · S/N 9399Built 2023 · Lone Mountain Aircraft LLCN806BPCirrus Design SR20 · S/N 2524Built 2019 · Lone Mountain Aircraft Training LLCN8146TCirrus Design SR20 · S/N 1373Built 2003 · Singer Group LLCN872KBCessna 140 · S/N 11220Built 1946 · Bruner Kevin G
Back to Vandalia, OH