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.

N16709Boeing 737-724 · S/N 28779Built 1998 · United Airlines IncN16713Boeing 737-724 · S/N 28784Built 1998 · United Airlines IncN16732Boeing 737-724 · S/N 28948Built 1999 · United Airlines IncN168DPPiper PA-28-180 · S/N 28-4402Built 1967 · Johnson Eldridge JrN1693VDiamond Aircraft Ind DA 40 NG · S/N 40.NC113Built 2020 · B4c LLCN17002Boeing 787-10 · S/N 40930Built 2018 · United Airlines IncN17015Boeing 787-10 · S/N 66984Built 2023 · United Airlines IncN17017Boeing 787-10 · S/N 66986Built 2022 · United Airlines IncN17104Boeing 757-224 · S/N 27294Built 1994 · United Airlines IncN17105Boeing 757-224 · S/N 27295Built 1994 · United Airlines IncN17122Boeing 757-224 · S/N 27564Built 1997 · United Airlines IncN17126Boeing 757-224 · S/N 27566Built 1998 · United Airlines IncN17128Boeing 757-224 · S/N 27567Built 1998 · United Airlines IncN17133Boeing 757-224 · S/N 29282Built 1998 · United Airlines IncN17138Embraer EMB-145XR · S/N 145727Built 2003 · United Airlines IncN17139Boeing 757-224 · S/N 30352Built 2000 · United Airlines IncN17146Embraer EMB-145XR · S/N 145746Built 2003 · United Airlines IncN17159Embraer EMB-145XR · S/N 145792Built 2004 · United Airlines IncN17169Embraer EMB-145XR · S/N 14500844Built 2004 · United Airlines IncN17185Embraer EMB-145XR · S/N 14500922Built 2005 · United Airlines IncN17196Embraer EMB-145XR · S/N 14500945Built 2005 · United Airlines IncN171UABoeing 747-422 · S/N 24322Built 1989 · United Airlines IncN17233Boeing 737-824 · S/N 28943Built 1999 · United Airlines IncN17244Boeing 737-824 · S/N 28954Built 1999 · United Airlines IncN17245Boeing 737-824 · S/N 28955Built 1999 · United Airlines IncN17272Boeing 737-8 · S/N 67527Built 2022 · United Airlines IncN17279Boeing 737-8 · S/N 64613Built 2022 · United Airlines IncN17285Boeing 737-8 · S/N 61853Built 2022 · United Airlines IncN17289Boeing 737-8 · S/N 60712Built 2023 · United Airlines IncN17294Boeing 737-8 · S/N 67551Built 2023 · United Airlines IncN17312Boeing 737-8 · S/N 64609Built 2019 · United Airlines IncN17315Boeing 737-8 · S/N 67597Built 2024 · United Airlines IncN17317Boeing 737-8 · S/N 67570Built 2023 · United Airlines IncN17328Boeing 737-8 · S/N 67583Built 2023 · United Airlines IncN17341Boeing 737-8 · S/N 67605Built 2024 · United Airlines IncN17344Boeing 737-8 · S/N 67622Built 2024 · United Airlines IncN17346Boeing 737-8 · S/N 67626Built 2024 · United Airlines IncN17347Boeing 737-8 · S/N 67618Built 2024 · United Airlines IncN17349Boeing 737-8 · S/N 67620Built 2024 · United Airlines IncN17355Boeing 737-8 · S/N 67617Built 2024 · United Airlines IncN17356Boeing 737-8 · S/N 67625Built 2024 · United Airlines IncN17358Boeing 737-8 · S/N 67628Built 2024 · United Airlines IncN17359Boeing 737-8 · S/N 67634Built 2025 · United Airlines IncN17361Boeing 737-8 · S/N 67632Built 2024 · United Airlines IncN17362Boeing 737-8 · S/N 68808Built 2024 · United Airlines IncN17363Boeing 737-8 · S/N 67629Built 2025 · United Airlines IncN17364Boeing 737-8 · S/N 67637Built 2025 · United Airlines IncN17373Boeing 737-8 · S/N 68814Built 2025 · United Airlines IncN17417Boeing 737-9 · S/N 64448Built 2025 · United Airlines IncN17421Boeing 737-9 · S/N 67744Built 2025 · United Airlines Inc
Back to Chicago, IL