OpenAirDocs.org
Middleton, ID

Registered aircraft · 26

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

N104DTGulfstream AM Corp Comm Div 695A · S/N 96010Built 1981 · Davis Brenda KruszewskiN1442AFish Robert Earl SISLER CYGNET SF-2A · S/N 144Built 1983 · Wilkerson William LN146PKWomack John R EUROPA XS TRIGEAR · S/N A-163Built 2005 · Womack John RN1956WBeech B19 · S/N MB-620Gasaway Chad DN1JYCessna 182A · S/N 51474Built 1958 · Ricks Electric Plus LLCN21BECessna P210N · S/N P21000456Built 1979 · Specialized Helicopter Training LLCN2306PPiper PA-22-150 · S/N 22-2717Built 1955 · Ricks Electric Plus LLCN231WLMooney M20K · S/N 25-0278Built 1979 · Obar Daniel CN2443QCessna 182K · S/N 18257643Holcomb Aviation LLCN2950SCessna 150G · S/N 15066850Johnson Aviation LLCN4768VBoeing E75 · S/N 75-5737Smith Joseph RN48307Ryan Aeronautical ST3KR · S/N 1269Built 1941 · Alexander Robert WN5413LDennis S Leblanc BELITE ULTRA CUB · S/N 270Built 2018 · Abbott Mccoy DN548PGCirrus Design SR20 · S/N 2005Built 2008 · Storey KimberlyN6056WPiper PA-28-140 · S/N 28-20068Built 1964 · Herfel Kevin RN624NRDJI AGRAS T100 · S/N 1581F8ZLC25AS00204X9Wagner William TaylorN62DHHousler Dan M KITFOX S7 SUPERSPORT · S/N KA22303546Built 2023 · Housler Dan MN647JRPiper PA-18-150 · S/N 1809020Built 1989 · Alexander RobertN714EHCessna 150M · S/N 15079116Built 1976 · Matthews David GN728DDRore James VANS RV-10 · S/N 001Rore James LN7314ACessna 172 · S/N 29414Built 1956 · Schultz DavidN739TCCessna 172N · S/N 17270784Built 1978 · Blue Skies Aviation Group LLCN8768PPiper PA-24-260 · S/N 24-4218Built 1965 · Gliege Allan CN9146XCessna 182D · S/N 18253546Built 1961 · Mangun Charles LN9620QCessna A185F · S/N 18503780Built 1979 · Obar DannyN969RHNorth American SNJ-6 · S/N 112213Alexander Robert W Jr
Back to Middleton, ID