OpenAirDocs.org
Williamsburg, VA

Registered aircraft · 102

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

N1039DRogers Eugene W PIEL EMERAUDE CP-128 · S/N 50Built 1982 · Petro Jerry RN1084EAeronca 7AC · S/N 7AC4637Built 1946 · Petro Jerry RN10966Curtiss Wright CW-1 · S/N 1144Built 1931 · Petro Jerry RN110BTBaker Timothy C PAZMANY PL-2 · S/N 27Built 1988 · Petro Jerry RN11601Franklin 90 · S/N 104Petro Jerry RN12405Aeronca C-3 · S/N A-171Built 1931 · Petro Jerry RN124RTToth Robert S KITFOX IV-1200 · S/N 1793Built 2008 · Toth Robert SN12674Fairchild 22 C7A · S/N 1033First renewal noticeBuilt 1932 · Petro Jerry RN12XGRockwell International 114 · S/N 14237Built 1977 · Commander Aviation LLCN136PCBeech A36 · S/N E-2134Built 1984 · Papa Charlie Aviation LLCN13701Cessna 172M · S/N 17262953Built 1974 · M-A-R-S Aircraft Leasing LLCN14550Aeronca C-3 · S/N A-504First renewal noticePetro Jerry RN15HWJohn D Williams VANS RV-14 · S/N 140634Built 2020 · Williams John DN1725LCessna 182T · S/N 18282019Built 2007 · Meyer FrankN180EPiper PA-28-180 · S/N 28-5373Built 1969 · Groom Lucas WN18938Beech C24R · S/N MC-531Built 1977 · Hangar 5 LLCN192PGCirrus Design SR20 · S/N 1923Built 2008 · Rhoads William MN19386Waco YKS-7 · S/N 5212Built 1939 · Petro Jerry RN19608Taylorcraft A · S/N 214Built 1937 · Petro Jerry RN222EHForeman James D ACRO SPORT II · S/N 424Built 1987 · Muller Aviation LLCN2290Petro Jerry R SORRELL SNS-2 · S/N 229Petro Jerry RN22MKMitsubishi MU-2B-26A · S/N 375SALhb Aviation LLCN23090Luscombe 8A · S/N 1014Built 1953 · Petro Jerry RN233WBVans RV-12 · S/N 120901Built 2015 · Wmbgrv12 LLCN240BCIcon A5 · S/N 00060Built 2018 · A5 Partners 1.0 LLCN240MFOMF OMF-100-160 · S/N 0024Built 2002 · Millis RonaldN24590Beech B19 · S/N MB-546Built 1972 · Nice Flying LLCN2495EAeronca 7AC · S/N 7AC6077First renewal noticePetro Jerry RN24GDCostruzioni Aeronautiche Tecna P2004 BRAVO · S/N 067Built 2006 · Scrofani Philip J TrusteeN25048Balloon Works FIREFLY 8B-15 · S/N F8B-407Built 1992 · Carnegie Ronald S JrN25106Luscombe 8A · S/N 1030First renewal noticeBuilt 1939 · Petro Jerry RN2576XPiper PA-32R-301 · S/N 32R-8513013Built 1985 · Ochoa Chase EN26687Taylorcraft BL-65 · S/N 2029Built 1940 · Petro Jerry RN26838Piper J3C-65 · S/N 4212Built 1940 · Gross Scott AN2810QCessna 172L · S/N 17259810Built 1971 · Mcdowell Kevin JN2838LCessna 172H · S/N 17256038Built 1967 · A-R-M Aircraft Leasing LLCN2871Fairchild 22 C7A · S/N 1055First renewal noticeBuilt 1933 · Petro Jerry RN28FMCanadair CL-601-2A12 · S/N 3064Built 1986 · N28fm LLCN2929EAeronca 7AC · S/N 7AC-6512Built 1946 · Petro Jerry RN298MPierre Marcotte SONEX ACFT ONEX · S/N 0036Built 2014 · Hawkins John CN3094RPiper PA-32R-301T · S/N 3257388Built 2005 · Drygala Marcin MN3162QMaule MX-7-160 · S/N 19038CBuilt 1995 · Clevenger Matthew TN3192UCessna 182F · S/N 18254592Built 1962 · Colonial Aviators LLCN34135Commonwealth 185 · S/N 1846Built 1946 · Petro Jerry RN343TCCessna T182T · S/N T18208344Built 2004 · Two Rivers Aircraft Managmenet LLCN3601QBeech A23-24 · S/N MA-226Built 1967 · Ward Harry W TrusteeN36090Taylorcraft BL-65 · S/N 3057Built 1941 · Verell Edward TN375BALet L 33 SOLO · S/N 000510Built 2000 · Rhines John CN3809DCessna 182A · S/N 34509Built 1957 · Rhoads WilliamN38716Piper PA-28R-201 · S/N 28R-7737109Built 1977 · Spartan Aviation Group LLC
Back to Williamsburg, VA