OpenAirDocs.org
Richmond, VA

Registered aircraft · 140

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

N104JLSchempp Hirth Flugzeugbau DISCUS-2C FES · S/N 60Built 2022 · Reilly David JN108SFCostruzioni Aeronautiche Tecna P92 EAGLET · S/N 1189Built 2008 · Mid-Atlantic Air Ventures IncN112ALCessna 421C · S/N 421C0697Built 1979 · Passport Auto & Aviation IncN120SFCostruzioni Aeronautiche Tecna P92 EAGLET · S/N 1190Built 2008 · Mid-Atlantic Air Ventures IncN141HLDiamond Aircraft Ind DA 40 · S/N 40.1079Built 2010 · Synchronistic Operations Solutions LLCN158BBBeech 58 · S/N TH-592Built 1975 · Stubbs J PhillipN162SFCostruzioni Aeronautiche Tecna P92 EAGLET · S/N 1219Built 2008 · Mid-Atlantic Air Ventures IncN162UADiamond Aircraft Ind DA 40 NG · S/N 40.NC240Built 2023 · November Tango LLCN169ECCessna 172RG · S/N 172RG0515Built 1980 · First Eclipse LimitedN16HVCostruzioni Aeronautiche Tecna P92 EAGLET · S/N 1201Built 2008 · Mid-Atlantic Air Ventures IncN16SMHawker Beechcraft HAWKER 900XP · S/N HA-0040Built 2007 · Jokity Holdings LLCN17055Costruzioni Aeronautiche Tecna P2006T · S/N 072/USBuilt 2011 · Mid-Atlantic Air Ventures IncN188LAPiper PA 46-350P · S/N 4636185Avf Flyers LLCN189PPLearjet 45 · S/N 264Butler LLCN18TATailwind GLASAIR SPORTSMAN GS · S/N 7034Built 2021 · Tailwind Aviation LLCN196TABell Helicopter Textron Canada 407 · S/N 53925Built 2009 · Helo N426ha LLCN1VAHawker Beechcraft B300 · S/N FL-549Built 2007 · Commmonwealth Of VirginiaN200UYGlaser-Dirks Flugzeugbau DG-200 · S/N 2-69Built 1979 · Appleby Peter BN203HABell 407 · S/N 53023Built 1996 · Helo N203ha LLCN205MHMooney M20J · S/N 24-3026Ismail AhmadN228KTCirrus Design SR22T · S/N 2301Built 2021 · Tattersall Thomas KN231EFMooney M20K · S/N 25-0183Built 1979 · Stubbs J PhillipN237TACostruzioni Aeronautiche Tecna P92 TAIL DRAGGER · S/N 1414Built 2012 · Mid-Atlantic Air Ventures IncN238SRBell Helicopter Textron Canada 206L-4 · S/N 52469Built 2015 · Apple Realty Group IncN239SRLearjet 45 · S/N 2049Built 2006 · Apple Realty Group IncN2490CC A Tecnam P2002 SIERRA · S/N 198Built 2006 · Mid-Atlantic Air Ventures IncN24LCBeech C24R · S/N MC-540Built 1977 · First Eclipse LtdN24PQBeech B24R · S/N MC-227Built 1974 · Blackburn Joseph E JrN256AHLearjet 45 · S/N 2123Built 2011 · Apple Six Hospitality Air LLCN26VABell 407 · S/N 53688Built 2006 · Virginia State PoliceN278BDCessna 172H · S/N 17255945Built 1967 · Stubbs J PhillipN280CIai GULFSTREAM G280 · S/N 2077Built 2015 · Cca Holdings LLCN2848QCessna 172L · S/N 17259848Built 1971 · First Eclipse LtdN28VABell Helicopter Textron Canada 412EP · S/N 37045Built 2019 · Virginia State PoliceN292TACostruzioni Aeronautiche Tecna P92 EAGLET · S/N 1486Built 2014 · Mid-Atlantic Air Ventures IncN2GIsrael Aircraft Industries GULFSTREAM 200 · S/N 106Built 2004 · Performance Aviation LLCN2VAHawker Beechcraft B300 · S/N FL-537Built 2007 · Commonwealth Of VirginiaN307BLCirrus Design SF50 · S/N 0477Built 2023 · Tbl Air LLCN30VABell 407 · S/N 53453Built 2000 · Commonwealth Of VirginiaN315BTPhantom Aeronautics PHANTOM X-1E · S/N 715Built 2000 · Bertrand DominiqueN318ELHawker Beechcraft B300 · S/N FL582Built 2008 · Express Leasing LLCN32VACessna 182P · S/N 182-63322Built 1974 · Commonwealth Of VirginiaN336EDRobinson Helicopter R44 II · S/N 13461Built 2013 · Advanced Therapy Products IncN336VBellanca 17-31ATC · S/N 79-31155Built 1979 · Robertson Ryan TN343ABRaytheon A36 · S/N E-3343Built 2000 · Ponderosa 343 LLCN34VABell 407 · S/N 53454Built 2000 · Commonwealth Of VirginiaN353TACostruzioni Aeronautiche Tecna P92 EAGLET · S/N 1316Built 2010 · Mid-Atlantic Air Ventures IncN3826Mcknight FLYBABY 1A · S/N 66-66Built 1972 · Hinckle David SN397DWCulotta David W CHALLENGER II · S/N CH2-1103-2397Culotta David WN407HABell 407 · S/N 53099Built 1997 · Helo N219ha LLC
Back to Richmond, VA