OpenAirDocs.org
State Of Montana

Registered aircraft · 22

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

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_name = 'STATE OF MONTANA' OR list_contains(g.other_registrant_names, 'STATE OF MONTANA')
  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.

N1095THughes Helicopters HUGHES 369D · S/N 800769DHelena, MTN1604ZMcdonnell Douglas Helicopter 369E · S/N 0341EBuilt 1989 · Helena, MT · Co-owner with Dept Of Fish Wildlife And ParksN1664RCessna R182 · S/N R18200503Built 1978 · Helena, MTN28KPBeech C90 · S/N LJ-845Built 1979 · Helena, MTN368MCessna 182S · S/N 18280598Built 1999 · Helena, MTN381MBell UH-1H · S/N 5409Helena, MT · Co-owner with Usda Forest Service FeppN384MBell 206 · S/N 3681Helena, MTN387MBell UH-1H · S/N 11769Helena, MT · Co-owner with Usda Forest Service FeppN388MBell UH-1H · S/N 73-21680Helena, MT · Co-owner with Usda Forest Service FeppN392MBell 206A · S/N 362Built 1969 · Helena, MT · Co-owner with Usda Forest Service FeppN393MCessna 185C · S/N 185-0684Built 1964 · Helena, MT · Co-owner with Usda Forest Service FeppN394MBell UH-1H · S/N 64-13685Helena, MT · Co-owner with Usda Forest Service FeppN395MBell UH-1H · S/N 65-09662Helena, MT · Co-owner with Usda Forest Service FeppN398MBell UH-1H · S/N 65-09984Helena, MT · Co-owner with Usda Forest Service FeppN447MABeech A36 · S/N E-697Built 1975 · Helena, MTN4644YPiper PA-18-150 · S/N 18-8945Built 1971 · Helena, MTN58765Bell 206B · S/N 5276Built 2001 · Helena, MTN6110APiper PA-18-150 · S/N 18-8009050Built 1979 · Helena, MTN6312BCessna 182A · S/N 34212Built 1957 · Helena, MT · Co-owner with Usda Forest Service FeppN6962CBell OH-58C · S/N 68-16962Helena, MTN8862YPiper PA-18-150 · S/N 18-7409026Built 1973 · Helena, MTN898JFEurocopter AS 350 B3 · S/N 4120Built 2007 · Helena, MT
Back to State Of Montana