OpenAirDocs.org
Bristow, VA

Registered aircraft · 69

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 = 'BRISTOW'
  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.

N102BRCessna 182T · S/N 18282264Built 2010 · Otv LeasingN104VAPiper PA-28-161 · S/N 2842115Built 2001 · Dulles Aviation IncN125ALTextron T206H · S/N T20609639Built 2021 · Nby ProductionsN1352PPiper PA-23 · S/N 23-401Built 1955 · House TravisN142LJCessna 182T · S/N 18282272Built 2010 · Obr LeasingN143GMCessna T206H · S/N T20608971Built 2010 · Nby ProductionsN143GSCessna T206H · S/N T20608970Built 2010 · Pxw ServicesN179DMCessna T206H · S/N T20609179Built 2015 · Ng ResearchN180KHCessna T206H · S/N T20609180Built 2015 · Pwx ServicesN184SGCessna T206H · S/N T20609184Built 2015 · Nby ProductionsN185KPTextron T206H · S/N T20609185Built 2015 · Ng ResearchN187DHTextron T206H · S/N T20609187Built 2015 · Psl SurveysN188SSTextron T206H · S/N T20609188Built 2015 · Nby ProductionsN189CBTextron T206H · S/N T20609189Built 2015 · Otv LeasingN191MBTextron T206H · S/N T20609191Built 2015 · Fvx ResearchN192WBTextron T206H · S/N T20609192Built 2015 · Psl SurveysN193GMTextron T206H · S/N T20609193Built 2015 · Rkt ProductionsN194DDTextron T206H · S/N T20609194Built 2015 · Lcb LeasingN196TTTextron T206H · S/N T20609196Built 2015 · Nbr AviationN197WSTextron T206H · S/N T20609197Built 2015 · Obr LeasingN198RNTextron T206H · S/N T20609198Built 2015 · Kqm AviationN216NBTextron T206H · S/N T20609527Built 2018 · Nby ProductionsN232MJTextron T206H · S/N T20609641Built 2021 · Nby ProductionsN2365NCessna 182S · S/N 18280373Built 1998 · Dulles AviationN267RHCessna 182T · S/N 18282208Built 2010 · Pxw ServicesN302MPCessna 182T · S/N 18282273Built 2010 · Kqm AviationN3074VBeech 35 · S/N D-488Built 1947 · Hancock Steven W MN309DKTextron T206H · S/N T20609643Built 2021 · Nby ProductionsN31TDLewis Timothy H VANS RV-10 · S/N 40059Built 2010 · Lewis Timothy HN320RRCirrus Design SR22 · S/N 0358Built 2002 · Highway Aero LLCN3537BCessna 172S · S/N 172S8827Built 2001 · Dulles Aviation IncN408EBTextron T206H · S/N T20609650Built 2021 · Nby ProductionsN437HMTextron T206H · S/N T20609649Built 2021 · Nby ProductionsN461AJCessna 182T · S/N 18282225Built 2010 · Rkt ProductionsN4693SPiper J3C-65 · S/N 18373Wicker KirkN495BJCessna T206H · S/N T20608963Built 2010 · Obr LeasingN512FGCessna T206H · S/N T20609168Built 2015 · Lcb LeasingN523PHTextron T206H · S/N T20609646Built 2021 · Nby ProductionsN562CBCessna 182T · S/N 18282207Built 2010 · Kqm AviationN576DSCessna 182T · S/N 18282229Built 2010 · Lcb LeasingN599TSCessna T206H · S/N T20609169Built 2015 · Nbr AviationN610AGCessna 206H · S/N 20608324Built 2010 · Obr LeasingN612RWTextron T206H · S/N T20609642Built 2021 · Nby ProductionsN613TCAmerican Eurocopter AS350B3 · S/N 7522Built 2012 · T A F Y ConsultingN614TCAmerican Eurocopter AS350B3 · S/N 7479Built 2012 · Tafy ConsultingN629BACessna T206H · S/N T20609171Built 2015 · Kqm AviationN629BDTextron T206H · S/N T20609640Built 2021 · Nby ProductionsN629RSCessna T206H · S/N T20609173Built 2015 · Obr LeasingN6527CPiper PA-34-200T · S/N 34-7870163Built 1978 · Sunrise Site Development CorpN682DMTextron T206H · S/N T20609647Nby Productiions
Back to Bristow, VA