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.

N228UABoeing 777-222 · S/N 30556Built 2002 · United Airlines IncN22992Boeing 787-9 · S/N 63634Built 2025 · United Airlines IncN22995Boeing 787-9 · S/N 68623Built 2025 · United Airlines IncN229TBSocata TB 10 · S/N 1229Registration pendingN229UABoeing 777-222 · S/N 30557Built 2002 · United Airlines IncN230KGTextron 172S · S/N 172S13468Built 2026 · Alf Ix LLCN23139Embraer EMB-145XR · S/N 145731Built 2003 · United Airlines IncN2331UBoeing 777-300ER · S/N 62642Built 2016 · United Airlines IncN2332UBoeing 777-300ER · S/N 62643Built 2016 · United Airlines IncN2332VCessna 140 · S/N 14568Built 1948 · Malato Lawrence MN2333UBoeing 777-300ER · S/N 62644Built 2017 · United Airlines IncN2341UBoeing 777-300ER · S/N 63721Built 2017 · United Airlines IncN2352UBoeing 777-300ER · S/N 66592Built 2020 · United Airlines IncN23707Boeing 737-724 · S/N 28768Built 1998 · United Airlines IncN23708Boeing 737-724 · S/N 28769Built 1998 · United Airlines IncN23721Boeing 737-724 · S/N 28940Built 1999 · United Airlines IncN237SKTextron 172S · S/N 172S13469Built 2026 · Alf Ix LLCN237STNew Piper PA-46-500TP · S/N 4697237Built 2005 · Illuminus Aviation LLCN23983Boeing 787-9 · S/N 66140Built 2020 · United Airlines IncN23994Boeing 787-9 · S/N 68622Built 2025 · United Airlines IncN24103Embraer EMB-145XR · S/N 145645Built 2002 · United Airlines IncN24128Embraer EMB-145XR · S/N 145700Built 2003 · United Airlines IncN24202Boeing 737-824 · S/N 30429Built 2000 · United Airlines IncN24211Boeing 737-824 · S/N 28771Built 1998 · United Airlines IncN24212Boeing 737-824 · S/N 28772Built 1998 · United Airlines IncN24224Boeing 737-824 · S/N 28933Built 1998 · United Airlines IncN242MAPilatus PC-12/45 · S/N 306Built 2000 · 242ma LLCN24505Airbus S A S A321-271NX · S/N 11661Built 2023 · United Airlines IncN24508Airbus S A S A321-271NX · S/N 11706Built 2024 · United Airlines IncN24510Airbus S A S A321-271NX · S/N 11814Built 2024 · United Airlines IncN24513Airbus S A S A321-271NX · S/N 11850Built 2024 · United Airlines IncN24514Airbus A321-271NX · S/N 12002Built 2024 · United Airlines IncN24516Airbus S A S A321-271NX · S/N 12068Built 2024 · United Airlines IncN24519Airbus S A S A321-271NX · S/N 11965Built 2024 · United Airlines IncN24526Airbus S A S A321-271NX · S/N 12131Built 2024 · United Airlines IncN24537Airbus S A S A321-271NX · S/N 12385Built 2025 · United Airlines IncN24573Airbus S A S A321-271NX · S/N 13143Built 2026 · United Airlines IncN24702Boeing 737-724 · S/N 28763Built 1998 · United Airlines IncN24706Boeing 737-724 · S/N 28767Built 1998 · United Airlines IncN24715Boeing 737-724 · S/N 28786Built 1998 · United Airlines IncN24729Boeing 737-724 · S/N 28945Built 1999 · United Airlines IncN24736Boeing 737-724 · S/N 28803Built 1999 · United Airlines IncN247LLPiper PA-46-600TP · S/N 4698192Built 2021 · Finco LucaN24972Boeing 787-9 · S/N 40939Built 2018 · United Airlines IncN24973Boeing 787-9 · S/N 40941Built 2018 · United Airlines IncN24974Boeing 787-9 · S/N 40942Built 2018 · United Airlines IncN24976Boeing 787-9 · S/N 66135Built 2020 · United Airlines IncN24979Boeing 787-9 · S/N 66141Built 2020 · United Airlines IncN24980Boeing 787-9 · S/N 66138Built 2020 · United Airlines IncN24988Boeing 787-9 · S/N 37449Built 2024 · United Airlines Inc
Back to Chicago, IL