Registered aircraft · 20

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'CHOTEAU' ORDER BY g.n_number

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

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 = 'CHOTEAU'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1139DCessna 140A · S/N 15702Built 1951 · Oborny Alan R N1151LHiller UH-12E · S/N 1233Built 1960 · Classic Helicopters LLC N14311Piper PA-18-150 · S/N 18-7409075Hodgskiss Ben N188RCBeech A36 · S/N E-2189Built 1984 · Hodgskies Holdings LLC N2190GCessna 182A · S/N 51490Built 1958 · Scapegoat Aviation LLC N234PCessna 510 · S/N 510-0450Built 2014 · Hirschfeld David N394FBBierman Frederick W III ZODIAC 650 · S/N 65-8514Built 2017 · Gunderson Eric N4830KCessna P210N · S/N P21000338Built 1979 · Ramaker LLC N518HAHiller UH-12E · S/N 5018Built 1977 · Classic Helicopters LLC N527GCubcrafters CC11-160 · S/N CC11-00102Built 2009 · Oborny Alan R N6029ACessna 172 · S/N 28629Built 1956 · Hofer Phillip N6145NAirborne Windsports PTY EDGE XT-912-L · S/N XT-912-0212Built 2007 · Hirschfeld David J N62372Hiller UH-12E · S/N 1229Built 1960 · Classic Helicopters LLC N7059QKirstein Thomas J EDGE X-582 · S/N EDGE X-582-617Built 2001 · Howard Steven M N734EDCessna 172N · S/N 17268789Built 1977 · Scapegoat Aviation LLC N736HSCessna R172K · S/N R1722545Built 1977 · Hodgskiss Ben N752BGBarry Abernathy RV7 · S/N 71992Built 2017 · Oborny Alan R N82093Aeronca 7AC · S/N 7AC-719Built 1946 · Oborny Alan R N9610BChristen Industries A-1 · S/N 1169Built 1990 · Goodman Aviation LLC N967ADEric Gunderson M24 XTREME · S/N 24245396Built 2024 · Gunderson Eric G

Back to Choteau, MT