Chicago, IL

Registered aircraft · 1,567

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

N14524Airbus S A S A321-271NX · S/N 12061Built 2024 · United Airlines IncN14527Airbus S A S A321-271NX · S/N 12056Built 2024 · United Airlines IncN14529Airbus S A S A321-271NX · S/N 12120Built 2024 · United Airlines IncN14530Airbus S A S A321-271NX · S/N 12218Built 2024 · United Airlines IncN14531Airbus S A S A321-271NX · S/N 12217Built 2025 · United Airlines IncN14533Airbus S A S A321-271NX · S/N 12300Built 2025 · United Airlines IncN14534Airbus S A S A321-271NX · S/N 12307Built 2025 · United Airlines IncN14536Airbus S A S A321-271NX · S/N 12424Built 2025 · United Airlines IncN14539Airbus S A S A321-271NX · S/N 12589Built 2025 · United Airlines IncN14541Airbus S A S A321-271NX · S/N 12591Built 2025 · United Airlines IncN14544Airbus S A S A321-271NX · S/N 12671Built 2025 · United Airlines IncN14546Airbus S A S A321-271NX · S/N 12672Built 2025 · United Airlines IncN14548Airbus S A S A321-271NX · S/N 12701Built 2025 · United Airlines IncN14549Airbus S A S A321-271NX · S/N 12742Built 2025 · United Airlines IncN14554Airbus S A S A321-271NX · S/N 12871Built 2025 · United Airlines IncN14557Airbus S A S A321-271NX · S/N 13070Built 2026 · United Airlines IncN14559Airbus S A S A321-271NX · S/N 13017Built 2026 · United Airlines IncN14560Airbus S A S A321-271NX · S/N 12842Built 2026 · United Airlines IncN14563Airbus S A S A321-271NX · S/N 12947Built 2025 · United Airlines IncN14564Airbus S A S A321-271NX · S/N 12977Built 2026 · United Airlines IncN14565Airbus S A S A321-271NX · S/N 13011Built 2025 · United Airlines IncN14566Airbus S A S A321-271NX · S/N 13046Built 2026 · United Airlines IncN14567Airbus S A S A321-271NX · S/N 12975Built 2026 · United Airlines IncN14575Airbus S A S A321-271NX · S/N 13263United Airlines IncN14576Airbus S A S A321-271NX · S/N 13332Built 2026 · United Airlines IncN14704Boeing 737-724 · S/N 28765Built 1998 · United Airlines IncN14731Boeing 737-724 · S/N 28799Built 1999 · United Airlines IncN14735Boeing 737-724 · S/N 28950Built 1999 · United Airlines IncN149UDCessna 172R · S/N 17281185Built 2003 · W Air LLCN152WFPiper PA46-500TP · S/N 4697035Built 2001 · Mcmanus RusselN15710Boeing 737-724 · S/N 28780Built 1998 · United Airlines IncN15712Boeing 737-724 · S/N 28783Built 1998 · United Airlines IncN15751Boeing 737-71Q · S/N 29047Built 1999 · United Airlines IncN15969Boeing 787-9 · S/N 60142Built 2017 · United Airlines IncN15TDBeech A60 · S/N P-232Registration pendingBuilt 1973N16008Boeing 787-10 · S/N 60138Built 2019 · United Airlines IncN16009Boeing 787-10 · S/N 40938Built 2019 · United Airlines IncN16107Cessna 150L · S/N 15073481Built 1972 · Scheck Robert CN16147Embraer EMB-145XR · S/N 145749Built 2003 · United Airlines IncN16149Embraer EMB-145XR · S/N 145753Built 2003 · United Airlines IncN16151Embraer EMB-145XR · S/N 145758Built 2003 · United Airlines IncN16170Embraer EMB-145XR · S/N 14500850Built 2004 · United Airlines IncN16178Embraer EMB-145XR · S/N 14500889Built 2005 · United Airlines IncN16183Embraer EMB-145XR · S/N 14500914Built 2005 · United Airlines IncN16217Boeing 737-824 · S/N 28777Built 1998 · United Airlines IncN16234Boeing 737-824 · S/N 28946Built 1999 · United Airlines IncN162JKTextron 172S · S/N 172S13466Built 2026 · Alf Ix LLCN16429Piper PA-28R-200 · S/N 28R-7335112Built 1973 · Hilbish David BN16701Boeing 737-724 · S/N 28762Built 1998 · United Airlines IncN16703Boeing 737-724 · S/N 28764Built 1998 · United Airlines Inc
Back to Chicago, IL