OpenAirDocs.org
Midlothian, VA

Registered aircraft · 25

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 = 'VA' AND g.registrant_city = 'MIDLOTHIAN'
  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.

N1142EChampion 7AC · S/N 7AC-4698Built 1946 · Henderson Joseph C IVN161BGPiper PA-28-161 · S/N 287816527Built 1978 · Wilson James RN1732JPiper PA-28-140 · S/N 28-24145Wyatt Roger GN184TSSanders Theodore L RV-8 · S/N 83209Built 2016 · Sanders David MN2249FBuckeye DREAM MACHINE · S/N 4974Forrest ChristopherN235CWMaule MT-7-235 · S/N 18009CGreen Michael LN282DSDiamond Aircraft Ind DA 40 · S/N 40.282Built 2003 · Dickinson Edward LN2957RPiper PA-32-300 · S/N 32-7940229Built 1979 · Bantle Aviation LLCN30807Cessna 177B · S/N 17701476Built 1970 · Edwards Garland UN3767KTemco GC-1B · S/N 1460Built 1946 · Skibinski Jan JosephN3950QCessna 172L · S/N 17260050Dieter Jason WN440LLee J B RV-4 · S/N 3685Built 2002 · Saunders Perry JN5676ZPiper PA-22-108 · S/N 22-9502Built 1963 · Henderson Joseph CN6267PPiper PA-24-250 · S/N 24-1375Built 1959 · Flyhigh LLCN662FMerrill Lester S RV-10 · S/N 41907Built 2024 · Lane BruceN6843FCessna 150F · S/N 15063443Built 1966 · Moyers John JasonN6859KPiper PA-16 · S/N 16-695Built 1949 · Shelton Gregory SN76476Cessna 140 · S/N 10908Legas Alan MichaelN770EJCirrus Design SF50 · S/N 0370Built 2022 · Delta Sf Va LLCN812LADiamond Aircraft Ind DA 40 NG · S/N 40.NC129Built 2021 · Skydonk LLCN814JCBeech 95-C55 · S/N TE-55Built 1966 · Sports Medicine Consulting LLCN845EACirrus Design SR20 · S/N 8545Built 2022 · Marlar Aviation LLCN8686YPiper PA-30 · S/N 30-1831Built 1969 · Advanced Aviation LLCN9722BPiper PA-30 · S/N 30-1156Built 1966 · Bosshard Steven AN9994FGlaser-Dirks Flugzeugbau DG-100G · S/N 72Built 1976 · Gray Elmon T
Back to Midlothian, VA