OpenAirDocs.org
Ketchum, ID

Registered aircraft · 43

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 = 'ID' AND g.registrant_city = 'KETCHUM'
  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.

N12NTLink John LANCAIR PROPJET · S/N LIV-566Built 2005 · November Tango LLCN15EACessna T206H · S/N T20608333Built 2001 · Swanson Blake JN176BSCirrus Design SF50 · S/N 0234Built 2020 · Blackwood Aero LLCN1793NCessna 120 · S/N 12027Daigh Eric BN182HRCessna 182P · S/N 18261150Built 1972 · Hotel Romeo L L CN194BCAmerican Champion 8GCBC · S/N 489-2006Built 2006 · Aircraft Investments LLCN2144NPiper PA-28-236 · S/N 28-7911096Built 1979 · Paxton Matthew PN237HYAviat A-1B · S/N 2237Built 2003 · Zeus Flight LLCN250HMGulfstream Aerospace LP GULFSTREAM 200 · S/N 217Built 2008 · Pdkaa 250 Hm Partners LLCN300EMCessna 182J · S/N 18257529Built 1966 · Mark Thomas Productions LLCN3080FRaytheon B300 · S/N FL-249Built 1999 · Greyhawk Aviation LLCN30MAMitsubishi MU-2B-26A · S/N 371SABuilt 1978 · Wilson Construction Delaware CorpN374PMPilatus PC-12/47E · S/N 1438Built 2013 · Mclean Air LLCN449CASocata TBM 700 · S/N 150Built 1999 · Charlie Alpha LLCN4763NCessna 182Q · S/N 18267346Bathum DaleN4857CCessna T210N · S/N 21063647Built 1979 · Gate Holdings LLCN4867KCessna P210N · S/N P21000349Built 1979 · Mark Thomas Productions LLCN4901WChance Vought F4U-5 · S/N 124560Built 1951 · Zeus Flight II LLCN520DFCessna 525 · S/N 525-0154Built 1996 · Par Avion LLCN526CFLearjet 45 · S/N 45-124Built 2000 · Wolff 45 LLCN57924Fairchild 24W-41A · S/N W41A798Built 1945 · Penrose Michael MN581CBBeech 58P · S/N TJ-233Built 1979 · Colorado Baron LLCN59EPIai GULFSTREAM G280 · S/N 2034Built 2013 · P77 LLCN602YMCessna TU206G · S/N U20606231Built 1981 · Sawtooth Aviation Resources LLCN603SVBombardier BD-700-1A11 · S/N 60143Built 2024 · Sv Solutions LLCN6051RCessna 172G · S/N 17253720Built 1965 · Spalding DavidN626WPFoxair KITFOX LIGHT SPORT · S/N KA13233270Built 2014 · Poulsen CraigN659TCCessna T206H · S/N T20608860Built 2008 · Yokin Around LLCN706BHAviat A-1B · S/N 2354Built 2006 · Silver Lance Aviation LLCN71314Top Dog TD2 · S/N 9318Built 2007 · Schwab Randy LN731JGCessna P210N · S/N P21000474Built 1980 · Gate Air LLCN7463MCessna 175 · S/N 55763Rothgeb Michael AN795JBPiper PA-24-260 · S/N 24-4894Built 1969 · Mountain High LLCN8051ACessna 170B · S/N 20903Built 1952 · B C Aviation LLCN815SHNorth American T-28B · S/N 137793Zeus Flight LLCN82488Cessna 182G · S/N 18255745Built 1964 · Simpson Patrick EN831EFAero Vodochody L39C · S/N 332509Built 1983 · Zeus Flight LLCN8395QCessna A185F · S/N 18503680Built 1978 · N8395q LLCN852SCessna P210N · S/N P21000081Built 1978 · Dauenhauer Manufacturing IncN9358PPiper PA-24-260 · S/N 24-4858Built 1969 · Jeneson TimN9493CCessna 180 · S/N 31891Built 1955 · Blue Thunder LLCN9514MMooney M20F · S/N 670091Built 1966 · Holen Benjamin EN97DSCessna A185F · S/N 18504173Wmg Aviation LLC
Back to Ketchum, ID