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.
N14524Airbus S A S A321-271NX · S/N 12061N14527Airbus S A S A321-271NX · S/N 12056N14529Airbus S A S A321-271NX · S/N 12120N14530Airbus S A S A321-271NX · S/N 12218N14531Airbus S A S A321-271NX · S/N 12217N14533Airbus S A S A321-271NX · S/N 12300N14534Airbus S A S A321-271NX · S/N 12307N14536Airbus S A S A321-271NX · S/N 12424N14539Airbus S A S A321-271NX · S/N 12589N14541Airbus S A S A321-271NX · S/N 12591N14544Airbus S A S A321-271NX · S/N 12671N14546Airbus S A S A321-271NX · S/N 12672N14548Airbus S A S A321-271NX · S/N 12701N14549Airbus S A S A321-271NX · S/N 12742N14554Airbus S A S A321-271NX · S/N 12871N14557Airbus S A S A321-271NX · S/N 13070N14559Airbus S A S A321-271NX · S/N 13017N14560Airbus S A S A321-271NX · S/N 12842N14563Airbus S A S A321-271NX · S/N 12947N14564Airbus S A S A321-271NX · S/N 12977N14565Airbus S A S A321-271NX · S/N 13011N14566Airbus S A S A321-271NX · S/N 13046N14567Airbus S A S A321-271NX · S/N 12975N14575Airbus S A S A321-271NX · S/N 13263N14576Airbus S A S A321-271NX · S/N 13332N14704Boeing 737-724 · S/N 28765N14731Boeing 737-724 · S/N 28799N14735Boeing 737-724 · S/N 28950N149UDCessna 172R · S/N 17281185N152WFPiper PA46-500TP · S/N 4697035N15710Boeing 737-724 · S/N 28780N15712Boeing 737-724 · S/N 28783N15751Boeing 737-71Q · S/N 29047N15969Boeing 787-9 · S/N 60142N15TDBeech A60 · S/N P-232Registration pendingN16008Boeing 787-10 · S/N 60138N16009Boeing 787-10 · S/N 40938N16107Cessna 150L · S/N 15073481N16147Embraer EMB-145XR · S/N 145749N16149Embraer EMB-145XR · S/N 145753N16151Embraer EMB-145XR · S/N 145758N16170Embraer EMB-145XR · S/N 14500850N16178Embraer EMB-145XR · S/N 14500889N16183Embraer EMB-145XR · S/N 14500914N16217Boeing 737-824 · S/N 28777N16234Boeing 737-824 · S/N 28946N162JKTextron 172S · S/N 172S13466N16429Piper PA-28R-200 · S/N 28R-7335112N16701Boeing 737-724 · S/N 28762N16703Boeing 737-724 · S/N 28764
Back to Chicago, IL