OpenAirDocs.org
Hamilton, TX

Registered aircraft · 27

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

N1043JAero Commander 112 · S/N 127Built 1974 · Lanmon Herman JrN10GKSchleicher ASW-19 · S/N 19021Built 1976 · Long TaylorN113ADSchleicher ASW-20BL · S/N 20688Stiles Paul WN126CPSchweizer SGS 1-26E · S/N 612Built 1974 · Hamilton Soaring Club IncN1477KLuscombe 8A · S/N 4204Registration pendingBuilt 1946N1971MPiper J3C-65 · S/N 10035Lee James RN2396GCessna 182B · S/N 51696Built 1958 · Lee James RN253SKSchempp-Hirth NIMBUS 3 · S/N 22Built 1982 · Hamilton Soaring Club IncN2741ZSchweizer SGS 1-26C · S/N 248Built 1966 · Hamilton Soaring Club IncN2811HSchweizer SGS 2-33A · S/N 511Built 1978 · Hamilton Soaring Club IncN542HEnstrom F-28C · S/N 343Built 1976 · Graham Jack DN5727SSchweizer SGS 2-33 · S/N 71Hamilton Soaring Club IncN6465HPiper J3C-65 · S/N 19645Little John LN65967Schweizer SGS 1-26E · S/N 607Built 1974 · Hamilton Soaring ClubN69LHPiper PA-32R-300 · S/N 32R-7780323Built 1977 · Graham JackN71528Champion 7ECA · S/N 7ECA-326Little JohnN7221SCessna 182P · S/N 18265083Built 1976 · Gardner Riley FN7262TBellanca 14-19-3 · S/N 4155Little JohnN735THDJI PHANTOM 3 PROFESSION · S/N P76DCI07017392Hansard John DN7765SSchweizer SGS 2-32 · S/N 65Built 1968 · Hamilton Soaring Club IncN7792Grob-Werke Gmbh And TWIN ASTIR · S/N 3149Built 1978 · Hamilton Soaring ClubN8814RDowner BELLANCA 14-19-3 · S/N 4166Little John LN8891XCessna 182D · S/N 18253291Hamilton Soaring Club IncN9054MCessna 180H · S/N 18052154Built 1970 · Muxworthy Neil WN931SLAlexander Schleicher ASH 31 MI · S/N 31064Built 2012 · Stiles Paul WN9565SChampion 7ECA · S/N 373Little Lambert WN95784Taylorcraft BC12-D · S/N 8084Built 1946 · Little John L
Back to Hamilton, TX