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.

N24990Boeing 787-9 · S/N 38276Built 2024 · United Airlines IncN24993Boeing 787-9 · S/N 38269Built 2025 · United Airlines IncN25201Boeing 737-824 · S/N 28958Built 1999 · United Airlines IncN2525AGeorge M Dunn III REV X · S/N X1022Built 2022 · Dunn George M IIIN252BBCessna 195A · S/N 7571Built 1950 · Jagmin MichaelN252EJCessna 182S · S/N 18280044Built 1997 · Johnson Eldridge JrN2534UBoeing 777-300ER · S/N 62645Built 2017 · United Airlines IncN253TSTextron 172S · S/N 172S13470Built 2026 · Alf Ix LLCN253TXCessna 680 · S/N 680-0253Built 2008 · Jssi Parts LLCN256AAPiper PA-44-180 · S/N 4496476Built 2019 · Alf Ix LLCN25705Boeing 737-724 · S/N 28766Built 1998 · United Airlines IncN25982Boeing 787-9 · S/N 66139Built 2020 · United Airlines IncN2606LPiper PA-38-112 · S/N 38-79A0778Built 1979 · Matts Services LLCN26141Embraer EMB-145XR · S/N 145733Built 2003 · United Airlines IncN26208Boeing 737-824 · S/N 30580Built 2000 · United Airlines IncN26210Boeing 737-824 · S/N 28770Built 1998 · United Airlines IncN26215Boeing 737-824 · S/N 28775Built 1998 · United Airlines IncN26226Boeing 737-824 · S/N 28935Built 1998 · United Airlines IncN26232Boeing 737-824 · S/N 28942Built 1999 · United Airlines IncN2639UBoeing 777-300ER · S/N 62650Built 2017 · United Airlines IncN263ADassault FALCON 7X · S/N 263Built 2015 · Marmon Group LLCN2644UBoeing 777-300ER · S/N 63724Built 2017 · United Airlines IncN2645UBoeing 777-300ER · S/N 64989Built 2018 · United Airlines IncN26902Boeing 787-8 · S/N 34822Built 2012 · United Airlines IncN26906Boeing 787-8 · S/N 34829Built 2012 · United Airlines IncN26909Boeing 787-8 · S/N 34827Built 2014 · United Airlines IncN26910Boeing 787-8 · S/N 34826Built 2014 · United Airlines IncN26952Boeing 787-9 · S/N 36403Built 2015 · United Airlines IncN26960Boeing 787-9 · S/N 36408Built 2015 · United Airlines IncN26966Boeing 787-9 · S/N 60143Built 2016 · United Airlines IncN26967Boeing 787-9 · S/N 60144Built 2016 · United Airlines IncN26970Boeing 787-9 · S/N 60146Built 2017 · United Airlines IncN26996Boeing 787-9 · S/N 68624Built 2025 · United Airlines IncN27015Boeing 777-224 · S/N 28678Built 2000 · United Airlines IncN27152Embraer EMB-145XR · S/N 145759Built 2003 · United Airlines IncN27190Embraer EMB-145XR · S/N 14500934Built 2005 · United Airlines IncN27200Embraer EMB-145XR · S/N 14500956Built 2006 · United Airlines IncN27205Boeing 737-824 · S/N 30577Built 2000 · United Airlines IncN27213Boeing 737-824 · S/N 28773Built 1998 · United Airlines IncN27239Boeing 737-824 · S/N 28951Built 1999 · United Airlines IncN27246Boeing 737-824 · S/N 28956Built 1999 · United Airlines IncN27267Boeing 737-8 · S/N 67522Built 2022 · United Airlines IncN27268Boeing 737-8 · S/N 67523Built 2022 · United Airlines IncN27269Boeing 737-8 · S/N 67524Built 2022 · United Airlines IncN27270Boeing 737-8 · S/N 67525Built 2022 · United Airlines IncN27271Boeing 737-8 · S/N 67526Built 2022 · United Airlines IncN27273Boeing 737-8 · S/N 67528Built 2022 · United Airlines IncN27274Boeing 737-8 · S/N 67529Built 2022 · United Airlines IncN27276Boeing 737-8 · S/N 64611Built 2021 · United Airlines IncN27277Boeing 737-8 · S/N 64612Built 2022 · United Airlines Inc
Back to Chicago, IL