OpenAirDocs.org
Elmhurst, IL

Registered aircraft · 16

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 = 'IL' AND g.registrant_city = 'ELMHURST'
  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.

N10507Cessna 150L · S/N 15074896Built 1973 · Pch Aviation LLCN117WWCessna 320D · S/N 320D0096Nowak Jerome SN1221QIsrael Aircraft Industries GALAXY · S/N 045Built 2001 · Nonstop Leasing LLCN12791Cessna 172M · S/N 17262263Built 1973 · Neo Flites Flying Club IncN226SAEurocopter Deutschland EC 135 P2+ · S/N 0559Built 2007 · Bennett Aviation LLCN231PZMooney M20K · S/N 25-0351Built 1980 · Turner Robert A JrN245TMThomas W Mason RV-10 · S/N 40664Mason Thomas WN252SAEurocopter Deutschland EC 135 P2+ · S/N 0707Built 2008 · Bennett Aviation LLCN253SAEurocopter Deutschland EC 135 P2+ · S/N 0890Built 2010 · Bennett Aviation LLCN316JWPipistrel Lsa S R L ALPHA TRAINER · S/N 692 AT 912 LSABuilt 2015 · Wiley John AN426SALearjet 45 · S/N 426Built 2011 · Superior Ambulance Aviation IncN429SALearjet 45 · S/N 392Superior Ambulance Aviation IncN4460SBeech A36 · S/N E-691Built 1975 · 300 Dollar Burger LLCN505EDGodfrey JR Edward W RV-10 · S/N 40717Built 2020 · Godfrey Edward W JrN5156QCessna T210L · S/N 21059656Built 1972 · N5156q IncN529CStinson 108-3 · S/N 108-3529Built 1947 · Price Aune H
Back to Elmhurst, IL