Three Forks, MT

Registered aircraft · 35

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 = 'THREE FORKS'
  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.

N110AGXag P100 PRO · S/N 1863FPEG8219418M5D11Millers Operations LLCN1120UPiper PA-18-150 · S/N 186723Built 1959 · Nistler Matthew JN1266DCessna 170A · S/N 19842Built 1950 · A T Enterprises LtdN1359VMcgowan Michael R KITFOX-SPEEDSTER · S/N IBS-063Folkvord CodyN153WNaefels MODEL 1 · S/N 0021Woodrieff Dr R LeeN15449Air Tractor AT-401 · S/N 401-0868Built 1992 · Headwaters Flying Service LLCN17WSStinson 108-3 · S/N 108-4499Wise River Aviation LLCN185RACessna 185 · S/N 185-1209Built 1967 · A-T Enterprises LtdN1968DBeech D55 · S/N TE-576Built 1968 · Bellamy IncN211WBBellanca 7KCAB · S/N 491-75Built 1974 · Bargatze Robert FN2408TNavion NAVION G · S/N NAV-4-2408Built 1962 · R E Green IncN307JHCessna T207A · S/N 207-00584Built 1980 · Roundy JosephN315PMP&M QUIK · S/N 8704Built 2015 · Woodriff Lee RN3361APiper PA-20-135 · S/N 20-1067Nimmick Robert AN401HXCessna 172M · S/N 17263490Built 1974 · Three Forks Flying Club IncN406TWMooney M20A · S/N 1217T C Willis LLCN41024Thrush S2RHG-T65 · S/N T65HG-020GBuilt 2006 · Headwaters Flying Service LLCN5001KBell 206B · S/N 2408Built 1978 · Montana Air Tankers LLCN500MWPilatus PC-12/47E · S/N 2111Built 2021 · Folkvord Family Aviation LLCN5041DCessna 182A · S/N 51141Built 1958 · 5041 Delta LLCN53AWAirborne Windsports PTY EDGE XT-912-L · S/N XT-912-0182Built 2008 · Woodriff LeeN550MTCessna T210N · S/N 21064580Built 1982 · Living Sky Grains LLCN5765BCessna 182 · S/N 33765Built 1956 · 5765 Bravo LLCN63VMVander Molen Harold AVID FLYER · S/N 619Built 1990 · Dreyer Gary DN6596MCessna 182P · S/N 18263771Built 1975 · Ejs Enterprises IncN71450Cessna 182M · S/N 18259627Built 1969 · Ejs Enterprises IncN73132Air Tractor AT-401 · S/N 401-0670Headwaters Flying Service LLCN7507PAirborne Australia XT OUTBACK 912 · S/N XT-912-0167Built 2007 · Woodriff Roger LeeN75478Infinity Power Parachutes C-912S · S/N IPP8-366Built 2008 · Woodriff LeeN76HRLake Larry HARMON ROCKET II · S/N 74Headwaters Flying Service LLCN78BRBell 206B · S/N 4001Built 1988 · Montana Air Tankers LLCN8595SAir Tractor AT-301 · S/N 301-0159Built 1978 · Headwaters Flying Service LLCN9832DPiper PA-22-150 · S/N 22-6723Built 1959 · Nimmick Robert AN9965XCessna 185 · S/N 185-0165Built 1961 · Nistler Matt JN9973DPiper PA-22-150 · S/N 22-6764Roadarmel Brandon L
Back to Three Forks, MT