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.

N14102Boeing 757-224 · S/N 27292Built 1994 · United Airlines IncN14106Boeing 757-224 · S/N 27296Built 1994 · United Airlines IncN14107Boeing 757-224 · S/N 27297Built 1994 · United Airlines IncN14115Boeing 757-224 · S/N 27557Built 1995 · United Airlines IncN14116Embraer EMB-145XR · S/N 145672Built 2002 · United Airlines IncN14118Boeing 757-224 · S/N 27560Built 1997 · United Airlines IncN14120Boeing 757-224 · S/N 27562Built 1997 · United Airlines IncN14121Boeing 757-224 · S/N 27563Built 1997 · United Airlines IncN14125Embraer EMB-145XR · S/N 145690Built 2003 · United Airlines IncN14143Embraer EMB-145XR · S/N 145739Built 2003 · United Airlines IncN14148Embraer EMB-145XR · S/N 145751Built 2003 · United Airlines IncN14153Embraer EMB-145XR · S/N 145761Built 2003 · United Airlines IncN14158Embraer EMB-145XR · S/N 145791Built 2004 · United Airlines IncN14162Embraer EMB-145XR · S/N 14500808Built 2004 · United Airlines IncN14168Embraer EMB-145XR · S/N 14500840Built 2004 · United Airlines IncN14173Embraer EMB-145XR · S/N 14500872Built 2004 · United Airlines IncN14174Embraer EMB-145XR · S/N 14500876Built 2004 · United Airlines IncN14177Embraer EMB-145XR · S/N 14500888Built 2005 · United Airlines IncN14179Embraer EMB-145XR · S/N 14500896Built 2005 · United Airlines IncN14180Embraer EMB-145XR · S/N 14500900Built 2005 · United Airlines IncN14186Embraer EMB-145XR · S/N 14500924Built 2005 · United Airlines IncN14188Embraer EMB-145XR · S/N 14500929Built 2005 · United Airlines IncN14198Embraer EMB-145XR · S/N 14500951Built 2006 · United Airlines IncN14203Embraer EMB-145XR · S/N 14500964Built 2006 · United Airlines IncN14204Embraer EMB-145XR · S/N 14500968Built 2006 · United Airlines IncN14214Boeing 737-824 · S/N 28774Built 1998 · United Airlines IncN14219Boeing 737-824 · S/N 28781Built 1998 · United Airlines IncN14228Boeing 737-824 · S/N 28792Built 1999 · United Airlines IncN14230Boeing 737-824 · S/N 28794Built 1999 · United Airlines IncN14231Boeing 737-824 · S/N 28795Built 1999 · United Airlines IncN14235Boeing 737-824 · S/N 28947Built 1999 · United Airlines IncN14237Boeing 737-824 · S/N 28802Built 1999 · United Airlines IncN14240Boeing 737-824 · S/N 28952Built 1999 · United Airlines IncN14242Boeing 737-824 · S/N 28805Built 1999 · United Airlines IncN14249Boeing 737-824 · S/N 28809Built 1999 · United Airlines IncN14250Boeing 737-824 · S/N 28957Built 1999 · United Airlines IncN14502Airbus S A S A321-271NX · S/N 11598Built 2023 · United Airlines IncN14503Airbus S A S A321-271NX · S/N 11599Built 2023 · United Airlines IncN14504Airbus S A S A321-271NX · S/N 11708Built 2024 · United Airlines IncN14506Airbus S A S A321-271NX · S/N 11680Built 2024 · United Airlines IncN14507Airbus S A S A321-271NX · S/N 11846Built 2024 · United Airlines IncN14509Airbus A321-271NX · S/N 11901Built 2024 · United Airlines IncN14511Airbus S A S A321-271NX · S/N 11775Built 2024 · United Airlines IncN14512Airbus A321-271NX · S/N 11953Built 2024 · United Airlines IncN14515Airbus S A S A321-271NX · S/N 12049Built 2024 · United Airlines IncN14517Airbus S A S A321-271NX · S/N 12101Built 2024 · United Airlines IncN14518Airbus S A S A321-271NX · S/N 11894Built 2024 · United Airlines IncN14520Airbus S A S A321-271NX · S/N 12103Built 2024 · United Airlines IncN14521Airbus S A S A321-271NX · S/N 12175Built 2024 · United Airlines IncN14523Airbus S A S A321-271NX · S/N 11966Built 2024 · United Airlines Inc
Back to Chicago, IL