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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N14102Boeing 757-224 · S/N 27292N14106Boeing 757-224 · S/N 27296N14107Boeing 757-224 · S/N 27297N14115Boeing 757-224 · S/N 27557N14116Embraer EMB-145XR · S/N 145672N14118Boeing 757-224 · S/N 27560N14120Boeing 757-224 · S/N 27562N14121Boeing 757-224 · S/N 27563N14125Embraer EMB-145XR · S/N 145690N14143Embraer EMB-145XR · S/N 145739N14148Embraer EMB-145XR · S/N 145751N14153Embraer EMB-145XR · S/N 145761N14158Embraer EMB-145XR · S/N 145791N14162Embraer EMB-145XR · S/N 14500808N14168Embraer EMB-145XR · S/N 14500840N14173Embraer EMB-145XR · S/N 14500872N14174Embraer EMB-145XR · S/N 14500876N14177Embraer EMB-145XR · S/N 14500888N14179Embraer EMB-145XR · S/N 14500896N14180Embraer EMB-145XR · S/N 14500900N14186Embraer EMB-145XR · S/N 14500924N14188Embraer EMB-145XR · S/N 14500929N14198Embraer EMB-145XR · S/N 14500951N14203Embraer EMB-145XR · S/N 14500964N14204Embraer EMB-145XR · S/N 14500968N14214Boeing 737-824 · S/N 28774N14219Boeing 737-824 · S/N 28781N14228Boeing 737-824 · S/N 28792N14230Boeing 737-824 · S/N 28794N14231Boeing 737-824 · S/N 28795N14235Boeing 737-824 · S/N 28947N14237Boeing 737-824 · S/N 28802N14240Boeing 737-824 · S/N 28952N14242Boeing 737-824 · S/N 28805N14249Boeing 737-824 · S/N 28809N14250Boeing 737-824 · S/N 28957N14502Airbus S A S A321-271NX · S/N 11598N14503Airbus S A S A321-271NX · S/N 11599N14504Airbus S A S A321-271NX · S/N 11708N14506Airbus S A S A321-271NX · S/N 11680N14507Airbus S A S A321-271NX · S/N 11846N14509Airbus A321-271NX · S/N 11901N14511Airbus S A S A321-271NX · S/N 11775N14512Airbus A321-271NX · S/N 11953N14515Airbus S A S A321-271NX · S/N 12049N14517Airbus S A S A321-271NX · S/N 12101N14518Airbus S A S A321-271NX · S/N 11894N14520Airbus S A S A321-271NX · S/N 12103N14521Airbus S A S A321-271NX · S/N 12175N14523Airbus S A S A321-271NX · S/N 11966
Back to Chicago, IL