OpenAirDocs.org
Yorktown, VA

Registered aircraft · 44

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

N1048DMooney M20M · S/N 27-0315Built 2001 · Dumbravo Dustin CN111LTTaylor Liam R RV-8 QUICK BUILD · S/N 83347Taylor Liam RN12250Beech A45 · S/N G-701Built 1955 · Renforth MichaelN1442EColumbia Aircraft Mfg LC41-550FG · S/N 41698Built 2006 · Mt Zephyr Enterprises LLCN1743HPiper PA-28-181 · S/N 28-7790337N1743h LLCN177AFPiper PA-60-700P · S/N 60-8423022Built 1984 · Mcgee Aviation LLCN1872MCessna 337G · S/N 33701472Renforth MichaelN201RUMooney M20J · S/N 24-0360Moore James BN21251Cessna 182P · S/N 18261518Built 1972 · De La Fuente Rene M TrusteeN214DPPresnell Don LONG EZ · S/N 38Built 1985 · Rothhaar Paul MN214LPKrasa Paul W LONG EZ · S/N 214KRBuilt 1999 · Krasa Paul WN215JCessna 210K · S/N 21059226Innovative Aerodynamic TechnologiesN242SLBRM Aero S R O BRISTELL LSA · S/N 388/2019Built 2018 · Bristell Aircraft Shares LLCN302DSDiamond Aircraft Ind DA 40 · S/N 40.742Built 2007 · Mt Zephyr Enterprises LLCN349DMMerchant Dean C VANS AIRCRAFT RV-8 · S/N 81556Built 2010 · Ritter John AN3546NMooney M20F · S/N 680092Gleason John RN42002Cessna 182L · S/N 18258801Built 1968 · Kuntz Jonathan WN4932LFrye Dwight R VANS RV-7 · S/N 70383Built 2013 · Three Aces LLCN526YZPennington Gary W RANS S6S SUPER · S/N 1295903Built 2006 · Peters Richard CN53620Cessna 337G · S/N 33701741Micren Design LLCN53704Cessna 337G · S/N 33701795Built 1977 · Renforth MichaelN5427WJack Richard Woods JR RV-7 · S/N 74473Built 2017 · Coulson Scott AN542SRCirrus Design SR22 · S/N 2213Built 2006 · Alliance Solutions Group IncN58WFBeech 58 · S/N TH-831Built 1977 · Hohlrieder Automotive CoN6308JCessna 172N · S/N 17273861Built 1980 · Katuzienski Joseph CN633DCDiamond Aircraft Ind DA 40 · S/N 40.940Built 2008 · Ritchie Holdings LLCN648ROlson Roger A RV 6 · S/N 20823Built 1992 · Hill Martin J IIIN65107Cessna 172P · S/N 17275686Built 1982 · Renforth Michael EN71FCessna 525B · S/N 525B0037Built 2005 · Aes Aviation LLCN7624TCessna 172A · S/N 47224Built 1960 · Air & Opportunity Aviation LLCN774PSPilatus B4-PC11 · S/N 203Built 1976 · Dewitt Joseph W IIIN810VKStitt Charles K RV-7A · S/N 71375Built 2011 · Stitt Charles KN8150XPiper PA-28-181 · S/N 28-8090232Built 1980 · There And Back Again LLCN848MECirrus Design SR22 · S/N 1823Built 2006 · Aes Aviation LLCN912SJJohnson Stuart K AVENTURA II · S/N AA2A0114Built 2005 · Johnson Stuart KN9308QBeech 95-B55 (T42A) · S/N TC-1411Built 1971 · Mt Zephyr Enterprises LLCN9420VMooney M20C · S/N 700040Built 1969 · Aerologic LLCN947CBBell Carl W VANS AIRCRAFT RV-7A · S/N 73077Built 2010 · Miner Dennis DN959DFConsolidated Aeronautics LAKE LA-4-200 · S/N 1040Built 1980 · Aerologic LLCN961RSPuckett PITTS S1C · S/N 1001Built 1978 · James River Pitts LLCN972QJPiper PA-28R-201T · S/N 28R7803366Built 1978 · Invictus Health LLCN97518Stinson 108 · S/N 108-518Built 1946 · Still Douglas AN97793Cessna 182Q · S/N 18267194Ligon Don RN9809CNorth American SNJ-6 · S/N 112049N9809c LLC
Back to Yorktown, VA