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.
N228UABoeing 777-222 · S/N 30556N22992Boeing 787-9 · S/N 63634N22995Boeing 787-9 · S/N 68623N229TBSocata TB 10 · S/N 1229Registration pendingN229UABoeing 777-222 · S/N 30557N230KGTextron 172S · S/N 172S13468N23139Embraer EMB-145XR · S/N 145731N2331UBoeing 777-300ER · S/N 62642N2332UBoeing 777-300ER · S/N 62643N2332VCessna 140 · S/N 14568N2333UBoeing 777-300ER · S/N 62644N2341UBoeing 777-300ER · S/N 63721N2352UBoeing 777-300ER · S/N 66592N23707Boeing 737-724 · S/N 28768N23708Boeing 737-724 · S/N 28769N23721Boeing 737-724 · S/N 28940N237SKTextron 172S · S/N 172S13469N237STNew Piper PA-46-500TP · S/N 4697237N23983Boeing 787-9 · S/N 66140N23994Boeing 787-9 · S/N 68622N24103Embraer EMB-145XR · S/N 145645N24128Embraer EMB-145XR · S/N 145700N24202Boeing 737-824 · S/N 30429N24211Boeing 737-824 · S/N 28771N24212Boeing 737-824 · S/N 28772N24224Boeing 737-824 · S/N 28933N242MAPilatus PC-12/45 · S/N 306N24505Airbus S A S A321-271NX · S/N 11661N24508Airbus S A S A321-271NX · S/N 11706N24510Airbus S A S A321-271NX · S/N 11814N24513Airbus S A S A321-271NX · S/N 11850N24514Airbus A321-271NX · S/N 12002N24516Airbus S A S A321-271NX · S/N 12068N24519Airbus S A S A321-271NX · S/N 11965N24526Airbus S A S A321-271NX · S/N 12131N24537Airbus S A S A321-271NX · S/N 12385N24573Airbus S A S A321-271NX · S/N 13143N24702Boeing 737-724 · S/N 28763N24706Boeing 737-724 · S/N 28767N24715Boeing 737-724 · S/N 28786N24729Boeing 737-724 · S/N 28945N24736Boeing 737-724 · S/N 28803N247LLPiper PA-46-600TP · S/N 4698192N24972Boeing 787-9 · S/N 40939N24973Boeing 787-9 · S/N 40941N24974Boeing 787-9 · S/N 40942N24976Boeing 787-9 · S/N 66135N24979Boeing 787-9 · S/N 66141N24980Boeing 787-9 · S/N 66138N24988Boeing 787-9 · S/N 37449
Back to Chicago, IL