OpenAirDocs.org
Hamilton, OH

Registered aircraft · 70

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 = 'OH' AND g.registrant_city = 'HAMILTON'
  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.

N115UTMikoyan Gurevich MIG 15UTI · S/N 31040Built 1955 · Roberts Aviation LLCN1346BLuscombe 8E · S/N 5973Built 1948 · Fugate David WN1388QAlderfer Edward A ALDERFER GYROPLANE · S/N 13132-2Built 1984 · Alderfer Edward AN14650Aeronca C-3 · S/N A-536Brewer Stephen FN1769HParker Cory J MK3 XTRA · S/N M3X00200011Parker Cory JN1840LManley Lynn K AIR COMMAND · S/N 31Built 1991 · Alderfer Edward AN18HRCessna 172H · S/N 17256269Built 1967 · J & R Aviation LLCN190JKCessna 560 · S/N 560-0303Built 1995 · Answers Collective IncN19338Aeronca K · S/N K-206Brewer Stephen FN1978BBarry R Kropelin XTRACT · S/N BK2012Built 2013 · Alderfer EdwardN22528Cessna 150H · S/N 15068339Built 1968 · Hhd Aviation LLCN23971Aeronca 65-C · S/N C6289Built 1939 · Hogan Frederick DN2531FChampion 7GCBC · S/N 22Built 1966 · Fishwick Steve KN262RLTalos Drones TALOS T60X · S/N 2104F7EZW255P001S20JHesselbrock Gary JN2871EAeronca 7AC · S/N 7AC-6454Built 1946 · Koedel Greg AN308TMTM Sportsman SPORTSMAN GS-2 · S/N 7417Built 2014 · Marconi JosephN31378Aeronca 65-TC · S/N L-8020-THogan Frederick DN31488Aeronca 65-LB · S/N L10960Built 1940 · Brewer Stephen FN31789Aeronca 65-TL · S/N 6580TBuilt 1940 · Brewer Stephen FN31997Aeronca 65-CA · S/N C12741Built 1941 · Hogan Frederick DN32026Waco UPF-7 · S/N 5657Upf-Sevens LLCN33744Aeronca 65-CA · S/N CA-13071Brewer Stephen FN34428Aeronca 65-CA · S/N C14541Brewer Stephen FN351VAPiper PA-28-236 · S/N 28-8111056Built 1981 · Victory Aviation Club IncN352VAPiper PA-28-181 · S/N 28-7690224Built 1976 · Victory Aviation Club IncN355VACessna 172M · S/N 17267135Built 1976 · Victory Aviation Club IncN356VAPiper PA-32-301 · S/N 32-8206008Built 1981 · Victory Aviation Club IncN394WDWilliam J Duffy VANS RV-9A · S/N 91592Built 2022 · Duffy William JN39717Waco UPF-7 · S/N 5850Upf-Sevens LLCN40649Phoenix LIBERTY · S/N 0555Built 2006 · Parker Cory JamesN407ESBell Helicopter Textron Canada 407 · S/N 54877Built 2019 · Darana Aviation Services LLCN46058Aeronca 0-58B · S/N 058B13514Built 1944 · Brewer Stephen FN47881Piper PA-28-161 · S/N 28-7816151Built 1977 · Griffin Jack DN4805KCessna P210N · S/N P21000327Built 1979 · H & M Aviation LLCN49114Aeronca 0-58B · S/N 058B-10873Built 1943 · Brewer Stephen FN4922VCessna 172RG · S/N 172RG0417Built 1973 · Hhd Aviation LLCN503XPNicely James R XP DRIFTER · S/N 211Built 1985 · Gmoser Michael TN505MGPoland Mig17 LIM 6 · S/N 1J0505Roberts Aviation LLCN5136TMikoyan Gurevich SB LIM-2 · S/N 1A11014Roberts Aviation LLCN5281QCessna 150L · S/N 15073181Hhd Aviation LLCN529TGCessna 560 · S/N 560-0497Built 1999 · Jet Connection LLCN5382EBeech K35 · S/N D-5876Built 1959 · Gmoser Michael TN54QExline Ace-C ACE-C · S/N EX-1Built 1960 · Weaver David AN5509HPiper PA-11 · S/N 11-1011Built 1949 · Shamrock Aviators LLCN601SRRichmond Curtiss R ZENITH ZODIAC 601XL · S/N 6-5701Built 2004 · Brooks Scott CN630JLBeech A36 · S/N E-821Built 1976 · Gilday Aviation LLCN6314QAerostar International RAVEN S49A · S/N S49A-3023Terranova Ronald MN6431PCessna P210N · S/N P21000182Built 1978 · Hhd Aviation LLCN6955SCessna 150H · S/N 15067655Built 1967 · Hhd Aviation LLCN698BCRobinson Helicopter R44 II · S/N 14581Built 2022 · Butler County Commissioners
Back to Hamilton, OH