OpenAirDocs.org
Hampton, GA

Registered aircraft · 48

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 = 'GA' AND g.registrant_city = 'HAMPTON'
  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.

N104HFBell UH-1H · S/N 68-16104Built 1968 · Army Aviation Heritage FoundationN16315Bell UH-1H · S/N 70-16315Built 1971 · Army Aviation Heritage Foundation And Flg MuseumN1643Pitts S-2S · S/N 3008Built 1982 · Elias Bernard JN195LEBell AH-1F · S/N 79-23195Army Aviation Heritage Foundation And Museum IncN197LEBell AH-1F · S/N 83-24197Built 1983 · Army Aviation Heritage Foundation And Museum IncN209CADassault/Sud FAN JET FALCON · S/N 71Aloft Aviation LLCN218CADassault/Sud FAN JET FALCON SER D · S/N 218Aloft Aviation LLCN221HFBell UH-1H · S/N 70-16221Army Aviation Heritage Foundation IncN2327TPiper PA-28R-200 · S/N 28R-7135216Sale reportedBuilt 1971N233LEBell AH-1F · S/N 79-23233Built 1979 · Army Aviation Heritage Foundation And Museum IncN28075Piper J3C-65 · S/N 4563Built 1940 · Baker NealN283HFBell AH-1F · S/N 66-15283Built 1966 · Army Aviation Heritage Foundation And Museum IncN283MPBell OH-58A · S/N 68-16918Army Aviation Heritage FoundationN294CMCostruzioni Aeronautiche Tecna P2006T · S/N 294/USBuilt 2019 · Lag Drywall IncN2971QCessna 310Q · S/N 310Q1074Built 1974 · On The Beam Aviation IncN2APBeech TC-45J · S/N 48-9493Built 1954 · Nipper Samuel MN313KDassault-Breguet FALCON 20 · S/N 404Built 1979 · Aloft Aviation LLCN32FLCessna 305E · S/N 24020Built 1957 · Army Aviation Heritage Foundation And MuseumN3354QCessna 310L · S/N 310L-0204Built 1967 · On The Beam Aviation IncN354HFBell UH-1H · S/N 69-15354Built 1964 · Army Aviation Heritage FoundationN426HFBell UH-1H · S/N 70-16426Built 1970 · Army Aviation Heritage Foundation IncN481HFBell AH-1F · S/N 67-15481Army Aviation Heritage Foundation And MuseumN5281WPiper PA-28-160 · S/N 28-330Built 1962 · Thomaston Mitchell EN589HFBell AH-1F · S/N 67-15589Built 1967 · Army Aviation Heritage Foundation And MuseumN605HFGrumman OV-1D · S/N 69-17005Army Aviation Heritage FoundationN6160ECessna 172 · S/N 46260Built 1958 · Burnette Richard AN624HFBell UH-1H · S/N 66-16624Built 1966 · Army Aviation Heritage Foundation IncN7006QCessna 172L · S/N 17260306Built 1971 · Toney Edward LN711PABeech H35 · S/N D-5206Built 1957 · Kimball Spruce LN72269Bell OH-58A · S/N 71-20541Built 1971 · Army Aviation Heritage FoundationN744VROTT Melvyn J CURTISS FALCON 0-38 · S/N 001Built 2000 · Elias Bernard JN7498JPiper PA-28R-180 · S/N 28R-30860Built 1968 · Sawyer Steven A MdN757QJCessna 152 · S/N 15279917Built 1977 · Waters Thomas JN766HFBell AH-1F · S/N 67-15766Army Aviation Heritage Foundation And MuseumN7732Bell-K-Copter 47G · S/N T-514Built 1965 · South Atlanta Helicopters LLCN802FSPiper PA-28-140 · S/N 28-7125398Built 1971 · Shelton ShannonN81PKPiper PA-32R-301 · S/N 3213023Tier-1 Helicopters LLCN820HFBell AH-1F · S/N 68-17082Army Aviation Heritage Foundation And MuseumN826HFBell AH-1F · S/N 67-15826Built 1967 · Army Aviation Hertiage Foundation And MuseumN8529RBernard J Elias SNS-7 · S/N 275Built 2021 · Elias Bernard JN854HFBell AH-1F · S/N 67-15854Army Aviation Heritage Foundation And MuseumN87861Piper J3C-65 · S/N 15479Built 1946 · Keahey Jody HN9176Just RC PITTS S-1S · S/N 28PBuilt 1970 · Elias Bernard JN942HFBell AH-1F · S/N 70-15942Army Aviation Heritage Foundation And MuseumN950LEBell AH-1F · S/N 66-15295Army Aviation Heritage Foundation And MuseumN9567RBeech K35 · S/N D-6137Bentivogio MarianoN97RGBeech 95-B55 (T42A) · S/N TF-20Army Aviation Heritage FoundationN998HFBell AH-1F · S/N 71-20998Built 1971 · Army Aviation Heritage Foundation And Museum
Back to Hampton, GA