OpenAirDocs.org
Lewiston, ID

Registered aircraft · 129

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

N1197FCessna A185F · S/N 18502763Built 1975 · Schumacher Bradley MN1206SAyres S2R-600 · S/N 2470RBuilt 1978 · Gustin Aviation IncN124WHCessna TU206G · S/N U20605355Built 1979 · Hillcrest Aircraft Co IncN16163Stinson SR-8E · S/N 9736Built 1936 · Pottenger Charles RN171DCTextron B200GT · S/N BY-309Built 2017 · Echo Rental CompanyN18057Cessna 150L · S/N 15073763Palmer Jedidiah JN185AZCessna A185F · S/N 18503112Built 1976 · Heard Jesse HN197PADJI T40 · S/N 1581F574B235B00102VPCustom Air Application LLCN19GCessna 182F · S/N 18254596Built 1963 · Carlton Steve WN2055QCessna TU206F · S/N U20602965Built 1975 · Jones Jeff AN2061JBell 206B · S/N 3333Built 1982 · Hillcrest Aircraft Co IncN217MCessna 180 · S/N 31292Built 1954 · Miles Manderson LN22000Canning George CHALLENGER I · S/N CH1-0596-0614Built 1996 · Canning Delores AN224AZJesse H Heard SKIP CUB 224 · S/N SC-224-9821Built 2021 · Heard Jesse HN2303YCessna A185E · S/N 185-01868Built 1971 · Bentz Fence Company IncN23333Cessna 150H · S/N 15068880Built 1968 · Leading Edge Aviation LLCN2382GCessna 182B · S/N 51682Built 1958 · Gish Joseph BN243MVDJI MAVIC 3M · S/N 1581F5FKD238100D0K45Custom Air Application LLCN24796Piper J3C-65 · S/N 3448Scharnhorst William AN247DBRobinson Helicopter R44 II · S/N 10086Built 2003 · Pope JimN2497BPiper PA-18-150 · S/N 18-8109009Built 1980 · Howard Eldon JN256BBHonda HA-420 · S/N 42000141Built 2019 · Madair LLCN272CPPetracca Carmine GLASAIR SH-2 · S/N 272Built 1983 · Petracca Carmine O DN27423Piper PA-31-350 · S/N 31-7752173Built 1977 · Kadrmas Arnold EN3000MPiper PA-12 · S/N 12-1568Built 1947 · Long Verl LN316LHBell 212 · S/N 30817Built 1977 · Lohman Helicopter LLCN321PVAirborne Windsports XT 912 · S/N 00321Built 2003 · Peavey Jeffrey WarrenN327LHDJI T40 · S/N 1581F574B226S00102L5Agpro Marketing & ManufacturingN334MPBell 205A-1 · S/N 30274Pope James DeanN334WNWilliams Helicopter UH-1B · S/N 62-2097Built 1962 · Pope Jim D DBAN336MPBell 205A-1 · S/N 30107Pope James DeanN338MPBell 205A-1 · S/N 30278Pope James DeanN3517DCessna 170B · S/N 27060Built 1955 · Strange Willam HN3598DAerospatiale AS350B2 · S/N 1152Built 1979 · Pope James DeanN36565Beech 95-B55 · S/N TC-1142Built 1968 · Maxwell James BN36645Cessna 172 · S/N 36645Built 1958 · Kaufmann ChadN386GABeech C90 · S/N LJ-775Built 1978 · Barnes IncN39BWSulphur Creek CCX-2300 · S/N CCX-2300-0069Built 2023 · R & R Plane LLCN404LHBell 407 · S/N 53777Built 2007 · Lohman Helicopter LLCN405LHBell 407 · S/N 53240Built 1998 · Lohman Helicopter LLCN407LHBell 407 · S/N 53117Built 1997 · Lohman Helicopter LLCN413RBellanca 14-13-2 · S/N 1531Built 1947 · Palmer Earl SN4210HPiper PA-14 · S/N 14-13Built 1948 · Gage Ricky DuaneN4266QCessna 172L · S/N 17260166Built 1971 · Maxwell James BN432DWAviat A-1B · S/N 2127Built 2000 · Leading Edge Aviation LLCN43806Piper PA-18-150 · S/N 18-7409049Built 1974 · Heard Jesse HN4420WBeech B-60 · S/N P-268Built 1974 · Odonata LLCN442RNRobinson Helicopter R44 II · S/N 11047Built 2006 · Pope Jim DN44536Piper PA-18-150 · S/N 186611Dickamore Chris EN454SHRobinson Helicopter R44 II · S/N 10672Built 2005 · Hillcrest Aircraft Co
Back to Lewiston, ID