Downers Grove, IL
Registered aircraft · 86
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 = 'DOWNERS GROVE' 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 = 'DOWNERS GROVE' 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.
N107VSocata TB 10 · S/N 601N108WDLorenz George W HATZ BANTAM · S/N 001N1234LBeech B-60 · S/N P-320N13HTRobinson Helicopter R66 · S/N 0491N156Cessna T182T · S/N T18209064N1586ZBeech P35 · S/N D-6882N171HZCirrus Design SR22T · S/N 2022N173SNPiper PA-32-260 · S/N 32-912N174HACessna 172N · S/N 17272235N177CSRobinson Helicopter R44 · S/N 1269N1975KBeech V35B · S/N D-9715N2003RCessna 182G · S/N 18255203N20318Beech V35B · S/N D-10173N21116Piper PA-28-161 · S/N 28-7916025N2197HMooney M20R · S/N 29-0208N2243ECessna 172N · S/N 17271202N2270KRockwell International 114 · S/N 14182N250KKPilatus PC-12/47E · S/N 2383N2557WMooney M20E · S/N 923N262WJGame Composites GB1 GAMEBIRD · S/N 0088N279CMCessna 182M · S/N 18259822N28230Gulfstream American AA-5B · S/N AA5B0953N2858PPiper PA-22-150 · S/N 22-3159N28866Grumman American Avn. AA-5B · S/N AA5B0872N2932DCessna 170B · S/N 26875N3060BPiper PA-28-181 · S/N 28-7990139N30VRCessna 525 · S/N 5250481N31XTAlexander Schleicher ASH 31 MI · S/N 31113N3262LCessna 172H · S/N 17256162N335FBExtra Flugzeugproduktions-Und EA 300/LC · S/N LC006N33804Piper PA-28R-200 · S/N 28R-7535195N3530XMooney M20F · S/N 670067N3563QCessna 172M · S/N 17261673N3977AJones Peter M BOEING/JONES 75 · S/N AR-27N4113YBellanca 7KCAB · S/N 591-76N41301Piper J-3C · S/N 7955N4332VCessna 195 · S/N 7238N447RARemos REMOS GX · S/N 256N4486CCessna 195B · S/N 16070N473WDewitt Richard DEWITT RV6 · S/N 20497N47LKTL Ultralight Sro TL-3000 SIRIUS · S/N 14SI191N499JYJay A Nielsen/William E Ford KOLB/FIRESTAR · S/N 82270N5000QBeech H35 · S/N D-5000N501JAAlongi John J GLASAIR RG · S/N 501-RN506CERobert Frank Richards PITTS S1-SS · S/N BR1N526ZMoravan ZLIN 526F · S/N 1288N53818Bellanca 8KCAB · S/N 216-75N53FBCessna 172N · S/N 17273291N540GDodge Douglas MACHAIRA · S/N 090N55809Boeing A75N1(PT17) · S/N 75-4690
Back to Downers Grove, IL