Naperville, IL
Registered aircraft · 138
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 = 'NAPERVILLE' 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 = 'NAPERVILLE' 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.
N101JTHonda HA-420 · S/N 42000130N117NKDavid Liang Hu RV-9A · S/N DLH-001N12BJCessna 172M · S/N 17264570N13011Karner Gary C-3 AERONCA REPRODCT · S/N 571833N130HBird A · S/N 1019N131EGCirrus Design SR20 · S/N 1248N144QBDallman DEGEAR STARDUSTER II · S/N 001N146YCessna 180 · S/N 32098N147PSPzl-Swidnik PW-5 · S/N 17 07 019N1489LCessna 182T · S/N 18281901N152CJCessna 152 · S/N 15281682N1563EBeech A36 · S/N E-2473N165MFinney Michael E ACRO SPORT II · S/N 1092N182SPCessna TR182 · S/N R18201003N194LPiper L-4B · S/N 9931N1970BLuscombe 8A · S/N 6397N1973BWaco GXE · S/N 755N19WHMackenzie Rod ACRO SPORT II · S/N 498N200TYYake Terry J RUTAN LONG-EZ · S/N 1374N2027WBeech 35-C33 · S/N CD-976N2104ZPiper PA-28RT-201T · S/N 28R-7931153N2190FCessna U206 · S/N U206-0390N23EZFogerson Richard D RV-3 · S/N 11351N240DBBeaird Brian W GLASAIR II RG · S/N 1032N244RFFuji T34A-B45 · S/N FM96-59-01096N24EZBeech B-45 · S/N CG-154N250RVWilloughby Stewart G RV-6 · S/N 25715N260NSSwanson Norman G SONERAI II · S/N 736Registration pendingN2635NCessna 140 · S/N 12893N2755MPiper PA-12 · S/N 12-1240N282LBeech B19 · S/N MB-700N2842KLuscombe 8A · S/N 5569N2954DCessna 170B · S/N 26897N30068Martin MINIPLANE · S/N 101MN3028YCessna 182E · S/N 18254028N308WEaglerock A-12 · S/N 957N3158FCessna 182J · S/N 18257258N315GTCirrus Design SR22T · S/N 0922N3161CCessna 180 · S/N 30960N321EWAutogyro Certification CAVALON · S/N V00664N32755Piper PA-34-200T · S/N 34-7570049N32CEMooney M20K · S/N 25-0747N33135Piper J3C-65 · S/N 5853N331SYValmet VALMET L70 VINKA · S/N 7N3457BCessna 310 · S/N 35032N37014Luscombe 8A · S/N 1675N374DMTalos Drones TALOS T60X · S/N 2104F7EZB251J001Z8T0N3779TPiper PA-28R-180 · S/N 28R-30091N37853Porterfield LP-65 · S/N 1000N381PCPiper L-4H · S/N 12416
Back to Naperville, IL