Registered aircraft · 19

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

Query with SQL

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 = 'NORTH CHESTERFIELD' ORDER BY g.n_number

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 = 'NORTH CHESTERFIELD'
  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.

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 = 'NORTH CHESTERFIELD'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N101ELSchempp Hirth Flugzeugbau ARCUS M · S/N 208Built 2019 · Lambert Eric J N210VAKodiak KODIAK 100 · S/N 100-0353Built 2025 · Commonwealth Of Virginia N212FGDonald S Bondy RV-10 · S/N 40432Built 2012 · Welch Charles E N230WACirrus Design SR20 · S/N 2229Built 2013 · Wing Nuts Fling Club Ltd N290CCBeech 65-A90 · S/N LJ132Built 1966 · Monument Aviation LLC N33VAKodiak KODIAK 100 · S/N 100-0351Built 2025 · Commonwealth Of Virginia N3XBBeech 65-A90 · S/N LJ-234Built 1967 · Monument Aviation LLC N445WTMooney M20C · S/N 2776Built 1964 · Clayton Edwin G N4723RCessna 172RG · S/N 172RG0018Built 1979 · Smolkin Alexander S N53VABell Textron Canada 407 · S/N 56432Built 2025 · Commonwealth Of Virginia N57AGBeech B90 · S/N LJ-343Built 1968 · Monument Aviation LLC N6325JPiper PA-28-180 · S/N 28-4733Built 1968 · Bantle Flyers LLC N71VABell Textron Canada 407 · S/N 54898Built 2020 · Virginia State Police N767MCBeech C90 · S/N LJ-595Built 1973 · Monument Aviation LLC N818DECessna 650 · S/N 650-0121Built 1987 · Mt Gilead Full Gospel International Ministries Inc N876VAKodiak KODIAK 100 · S/N 100-0352Built 2025 · Commonwealth Of Virginia N90MEBeech C90 · S/N LJ-661Built 1975 · Monument Aviation LLC N95MKMooney M20R · S/N 29-0053Built 1995 · Latobius LLC N964SGColumbia Aircraft Mfg LC42-550FG · S/N 42518Built 2006 · Wing Nuts Flying Club Ltd

Back to North Chesterfield, VA