OpenAirDocs.org
Hamilton, MT

Registered aircraft · 114

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

N1048APiper PA-18-125 · S/N 18-626Built 1951 · Underdahl Kirby LN116WCRodney W Hilton VANS RV-4 · S/N 3481White Crown IncN11VAIar Sa Brasov IAR 823 · S/N 20Built 1975 · Brutsman Ross WN126TFCessna 550 · S/N 550-0815Built 1997 · Fox Lumber Sales IncN128CDCirrus Design SR20 · S/N 1024Built 2000 · Metamorphosis Publishing LLCN141LSRobinson Helicopter R44 II · S/N 12275Built 2008 · Mthh ManagementN144LHBeech/Bond E50 · S/N RLH14Paul John RN1534FCessna 185D · S/N 185-0877Built 1965 · Dieckman Raymond DBAN154LHBeech/Bond E50 · S/N LH154Paul John RN155TEllis Robert J VANS RV-9A · S/N 90720Built 2006 · Av8 LLCN162JHHomer K Bell ROTORWAY EXEC 162F · S/N 6404Tronaas Chris EN1681BDJI MAVIC 3 CLASSIC · S/N 1581F67PE22BU00300U6Bitter Root Land Trust IncN171JBeech S35 · S/N D-7957Built 1965 · Tropicaire LLCN171JDBeech 95-55 · S/N TC-90Built 1961 · Stoffel Duane LN182AJCessna T182 · S/N 18267758Built 1980 · N182aj LLCN185HCessna A185F · S/N 18504313Built 1981 · N185h LLCN18FTPiper PA-32R-300 · S/N 32-R-7780126Built 1976 · Sk Ventures LLCN1954UCessna A185E · S/N 18501665Built 1970 · Aircraft Structural Repair IncN19RJEpic E1000 · S/N K009Built 2020 · Walhalla Air LLCN205GENorthwest Rotorcraft UH-1H · S/N 69-15198Built 1969 · Av8-Orr Helicopter Services IncN206SABell 206B · S/N 1013Built 1973 · Garlick Joyce MN206SLBell Helicopter Textron 206L-1 · S/N 45245Built 1979 · Av8-Orr Helicopter Services IncN222SVCessna 414 · S/N 414-0164Ellsworth Jason WN226ACCessna 182Q · S/N 18267019Built 1979 · Title 46 LLCN226CACessna 172M · S/N 17266762Built 1976 · Choice Aviation LLCN2300CCessna 180 · S/N 30600Built 1953 · Wasp Air LLCN2302GCessna 182B · S/N 51602Built 1958 · Dolce Aviation LLCN233SBCirrus Design SR22 · S/N 0242Built 2002 · C2c LLCN24097Bell UH-1M · S/N 66-15069Paul John RN264CACessna 172M · S/N 17266035Built 1975 · Choice Aviation LLCN2689RCessna 182K · S/N 18258389Built 1967 · Mortensen Mark SN273DADiamond Aircraft Ind DA20-A1 · S/N 10173Metamorphosis Publishing LLCN2889RCessna 182K · S/N 18258489Built 1967 · Aircraft Structural Repair IncN29210Cessna TU206C · S/N U206-1165Built 1968 · Hawkes Brian RN292CACessna 172M · S/N 17266685Built 1976 · Choice Aviation LLCN293CACessna 172M · S/N 17266259Built 1975 · Choice Aviation LLCN2RXCessna P210N · S/N P21000030Jbs Enterprises LLCN308MBGary A Boothe PIETENPOL AIRCAMPER · S/N 001Boothe Gary AN316CACessna 172M · S/N 17265960Choice Aviation LLCN3227PPiper PA-23 · S/N 23-1114Built 1957 · Tucker Patricia AN3259MPiper PA-12 · S/N 12-2032Built 1947 · Greenfield James RN342HAmerican Champion 7GCBC · S/N 1245-98Built 1998 · Trautman MichaelN3517NMooney M20F · S/N 680080Built 1967 · Tronaas Chris EN3601YCessna 210C · S/N 21058101Built 1962 · First Cut Excavation LLCN360HUAviat A-1 · S/N 1341Built 1996 · Parker John JN362CACessna 172K · S/N 17258976Built 1970 · Choice Aviation LLCN3828GCessna 310R · S/N 310R0923Choice Aviation LLCN391DWSorrels GLASTAR · S/N 5293Built 2000 · Francis Richard PN3GBucker-Jungmann E3B · S/N E3B-474Meloche Michael S TrusteeN415TWentzel CCX-2000 · S/N CCX-2000-0079Built 2019 · Landing Adventures DBA
Back to Hamilton, MT