OpenAirDocs.org
Aurora, IL

Registered aircraft · 40

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 = 'AURORA'
  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.

N133GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 397Finch Aircraft LLCN155RAFlight Design CTLS · S/N F-10-09-06Built 2011 · Starling Aircraft LLCN1567SBeech P35 · S/N D-6993Built 1962 · Wegener Properties LLC Series BonanzaN188WARemos REMOS G-3/600 · S/N 188Registration pendingBuilt 2007N2029GCessna 182A · S/N 51329Hendry Jeremiah DN212GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 336Built 2009 · Starling Aircraft LLCN234HBeech C-50 · S/N CH-133Built 1954 · Westphal Ronald RN274RARemos REMOS G-3/600 · S/N 235Built 2007 · Dccc LLCN293CKEmbraer Executive EMB-505 · S/N 50500701Built 2022 · M&M Aircraft Group LLCN3608MPiper PA-28-161 · S/N 28-7816359Built 1978 · Roman Peter AN4036AGraham Damien ZODIAC 601-HD · S/N 6-4462Kaleekal Rajan MN418RARemos REMOS G-3/600 · S/N 238Built 2008 · Finch Aircraft LLCN447BRBeech A36 · S/N E-2991Built 1995 · Cordogan Clark & Associates IncN505PPTextron 182T · S/N 18283318Built 2025 · Onionaire LLCN5155UCessna 172RG · S/N 172RG0263Built 1980 · Flying Unicorn LLCN5342CCessna 140A · S/N 15565Built 1950 · Pig Aero LLCN5413DUrbanczyk Miroslaw RANS S-12 XL · S/N 08960737Built 1997 · Barba JorgeN54219Cessna 172P · S/N 17274925Built 1981 · Kleb John SN5488TPiper PA-28-180 · S/N 28-7205264Built 1972 · Westphal Ronald RN55695Piper PA-28R-200 · S/N 28R-7335273Built 1973 · Straight Arrow Aviation LLCN5701FPiper PA-28-140 · S/N 28-24885Built 1968 · Kaspar RogerN6144BCessna 182A · S/N 34144Built 1957 · Rieser RobertN6264GCessna 150K · S/N 15071764Built 1970 · Odush & Sayush IncN661CCAndros Chris GLASAIR · S/N 303Markey John J JrN66DKKoster Douglas D COZY MARK IV · S/N 23Built 1994 · Koster Douglas DN676PBCirrus Design SR22T · S/N 11017Built 2025 · Cobalt Ventures LLCN724FLPiper PA-28-140 · S/N 28-7225417Built 1972 · Uncle Tommy LLCN7250BBeech J35 · S/N D-5586Built 1958 · Baird William BN77GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 282Built 2008 · Starling Aircraft LLCN797SPiper PA-32R-301T · S/N 3257003Built 1997 · Low Wing 797 LLCN79GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 284Built 2008 · Starling Aircraft LLCN825QTRaytheon HAWKER 800XP · S/N 258497Built 2000 · Kjm Air LLCN8344ZCessna 210-5(205) · S/N 205-0344Built 1963 · Mccoy Dell KN8379YPiper PA-30 · S/N 30-1534Built 1967 · Spaeth Alexander HN86GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 309Built 2009 · Finch Aircraft LLCN86YUYu Jinquan VELOCITY RG/ELITE · S/N DMO385Built 1998 · Yu JinquanN87DXDavid Lasala RV-7 · S/N 73247Built 2013 · Neal Joseph PN87HJHonda HA-420 · S/N 42000087Built 2017 · Aviation Industries LLCN924BMCirrus Design SR22 · S/N 4178Built 2015 · Aviation Industries LLCN924LMRobinson Helicopter R22 BETA · S/N 4260Built 2008 · Aviation Industries LLC
Back to Aurora, IL