OpenAirDocs.org
Miles City, MT

Registered aircraft · 32

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 = 'MILES CITY'
  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.

N1097WBeech A36 · S/N E-426Built 1973 · Fred Wacker Agency IncN143HADave Hartman RV-7 · S/N 74318Built 2021 · Hartman DaveN171XBeech K35 · S/N D-5857Built 1962 · Lifto Patrick JN172NDPiper PA-28R-201 · S/N 2837007Built 1988 · Blue Max Aero LLCN229EEDJI AGRAS T50 · S/N 1581F6BUB245A001ST8PHorizon Drone Solutions LLCN2616SCessna T210L · S/N 21061342Built 1976 · Montana Alpha Omega Ranch LLCN2695PPiper PA-18 · S/N 18-4384Built 1955 · Dodge Alan JN399HCessna 182Q · S/N 18266519Built 1978 · Lon Air LLCN40HUAviat A-1 · S/N 1315Built 1996 · Moore Charles BN430VSDJI AGRAS T50 · S/N 1581F6BUB245P001J506Sneaky Creek Drone Spraying LLCN44182Taylorcraft BC12-D · S/N 9982Built 1946 · Lifto Patrick JN4533MPiper PA-11 · S/N 1138Gaskill Douglas DN453ECDJI AGRAS T50 · S/N 1581F6BUB248T00120RNSneaky Creek Drone Spraying LLCN4797HDJI AGRAS T50 · S/N 1581F6BUB249T001X0NHHorizon Drone Solutions LLCN47TTRockwell International 690C · S/N 11600Built 1979 · Lon Air LLCN5360JCessna 172N · S/N 17273763Built 1980 · Fly Montana LLCN588QCDJI AGRAS T50 · S/N 1581F6BUB24CJ001Q69SSneaky Creek Drone Spraying LLCN6683WBeech B200 · S/N BB-1154West Dakota Flight Co LLCN6798JPiper PA-28-140 · S/N 28-24529Built 1968 · Dead Frog LLCN690HDEavision EA-J150 · S/N JMZKJ150UAV602596058Horizon Drone Solutions LLCN7029CAerostar International S-60A · S/N S60A-3197Built 1994 · High Plains Drifter Hot Air Balloons LLCN7098XAerostar International RX 8 · S/N RX8-3221Built 1995 · High Plains Drifter Hot Air Balloons LLCN71189Luscombe 8A · S/N 2616Built 1946 · Carlson Tom HN7139FAerostar International RX-7 · S/N RX7-3316Built 1995 · High Plains Drifter Hot Air Balloons LLCN717TBCa Tecnam P2004 BRAVO · S/N 095Built 2007 · Curtis Steven EN74212Bellanca 14-13-2 · S/N 1325Hartman DaveN7506BChampion 7EC · S/N 7EC-571Built 1957 · Doeden Bridger JN8568MBeech P35 · S/N D-7215Built 1963 · Moore Charles BN9099FAerostar International RXS-8 · S/N RXS8-3013Built 1993 · High Plains Drifter Hot Air Balloons LLCN9105UAerostar International RXS-8 · S/N RXS8-3023High Plains Drifter Hot Air Balloons LLCN9494DPiper PA-18A · S/N 18-6746Built 1958 · Reder Monte DN9814PPiper PA-18-150 · S/N 18-7609033First renewal noticeBuilt 1976 · Beardsley Taylor J
Back to Miles City, MT