Naperville, IL
Registered aircraft · 139
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.
N38757Piper J3C-85 · S/N 7234N39944Piper PA-32RT-300T · S/N 32R-7887171N4018FSpirit Engineering SE-1 · S/N 012N4084SBeech V35B · S/N D-9729N417JSPiper PA 46-350P · S/N 4636183N4216RPiper PA-32-300 · S/N 32-40581N427AGCirrus Design SF50 · S/N 0528N440TMCessna LC41-550FG · S/N 411028N4413UCessna 150D · S/N 15060413N4495Waco 10 · S/N 1322N4509XPiper PA-28R-200 · S/N 28R-7635067N45204Gulfstream American AA-5B · S/N AA5B1067N463RNPiper PA-28R-200 · S/N 28R-7135050N49192Piper PA-28-235 · S/N 28-7410025N494BEAviat PITTS S-2B · S/N 5329N495GCBeech A36 · S/N E-1876N522PWCirrus Design SR22T · S/N 2210N5266DCessna 172N · S/N 17272483N5315WAerostar International AEROSTAR S53H · S/N S53H-3002N5399KCessna 172P · S/N 17274095N53BRBeech A45 · S/N G-152N54578Zenadrone Trading ZENADRONE 1000 · S/N 00007N54CLPiper PA-31 · S/N 31-652N5677UPiper PA-28-140 · S/N 28-26474N577CFDassault FALCON 7X · S/N 145N5804PPiper PA-24-250 · S/N 24-884N5907RCessna 172G · S/N 17253576N597RFDJI PHANTOM 2 VISION + · S/N PH645383938N6003RBeech 76 · S/N ME-126N60065Cessna 150J · S/N 15070048N636CACentrair 101A · S/N 101A0120N6374Eaglerock A-3 · S/N 681N645EMCirrus Design SR22 · S/N 1634N6517KRepublic RC-3 · S/N 783N6549HPiper J3C-65 · S/N 19740N6670Beech 3N · S/N CA-98N67FDSIAI Marchetti F.260C · S/N 728N6897CPiper PA-28-181 · S/N 28-7890384N6929Cessna 182M · S/N 18259853N693WBenell Ronald E HATZ CB-1 CLASSIC · S/N 693N694CSSmith Christopher C CLEANEX · S/N 1002N701VVCessna 550 · S/N 550-1033N71291Luscombe 8A · S/N 2718N7135WPiper PA-28-180 · S/N 28-934N713LSPiper PA-28-181 · S/N 28-7890400N725EBCirrus Design SR22 · S/N 4333N72CDPiper PA-28-180 · S/N 28-7205013N740XCSchempp Hirth Flugzeugbau ARCUS M · S/N 64N747LCMooney M20J · S/N 24-3259N748BBeech A35 · S/N D-1756
Back to Naperville, IL