OpenAirDocs.org
Sugar Grove, IL

Registered aircraft · 55

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

N108PHDassault-Breguet MYSTERE FALCON 900 · S/N 87Built 1990 · Young Family Aviation LLCN1125CPiper PA-20-135 · S/N 20-958Built 1953 · Crosta Michael AN112CAAero Commander 112 · S/N 23Built 1972 · Wickter Lawrence D JrN11682Cessna 172S · S/N 172S10365Built 2006 · Jahawk Leasing LLCN1224AHonda HA-420 · S/N 42000131Built 2018 · Efn 63 LLCN12DRDouglas Ripley PITTS MODEL 12 · S/N 281Built 2013 · Bunker Aviation LLCN137FLRaytheon B300 · S/N FL137Built 1996 · Charlie-001 LLCN150JACessna 150M · S/N 15075916Built 1974 · Jahawk Leasing LLCN1593JPiper PA-28-140 · S/N 28-24003Rindeikis BronN182VPCessna 182S · S/N 18280247Built 1998 · Jobsight Delta IncN1873MCessna 337G · S/N 33701473Built 1973 · Asmus Edward W IIIN18JACessna 172P · S/N 17274513Built 1980 · Jahawk Leasing LLCN19364Cessna 150L · S/N 15074366Built 1973 · Ja Flight Services LLCN2094RPiper PA-28-180 · S/N 28-5459Ott Rusty SN212VZGulfstream Aerospace GIV-X (G450) · S/N 4325Built 2014 · Napleton Aviation Group LLCN2155EMooney M20R · S/N 29-0165Built 1998 · Cavu Aviation LLCN228XCostruzioni Aeronautiche Tecna P2008 · S/N 085Built 2014 · Midgley Edward SN236RMBeech A36TC · S/N EA-43Built 1979 · Conrad Harold MN2537HErcoupe 415-C · S/N 3162Maddock Jay BN277USCessna 182S · S/N 18280894Built 2000 · Cooper RobertN28PHDassault-Breguet FALCON 50 · S/N 194Young Family Aviation LLCN30JACessna 172N · S/N 17268043Built 1976 · Jahawk Leasing LLCN310BJCessna 310Q · S/N 310Q0759Built 1973 · J A Flight Services LLCN310VVCessna 310R · S/N 310R1561Msl Air IncN319PBTed Setzer SUPER SPORTMAN GS-2 · S/N 7317Built 2022 · Giordano David JrN354WFWilliam B Frymark JR VANS AIRCRAFT RV-7 · S/N 72969Built 2019 · Frymark William B JrN400WTRaytheon B36TC · S/N EA-690Built 2001 · Artspret Aviation LLCN4639HPiper PA-17 · S/N 17-52Built 1948 · Barnstormers Holdings IncN48JACessna 172M · S/N 17265312Built 1975 · Jahawk Leasing LLCN5198VCessna 210L · S/N 21060859Maddock Jay BN525CABeech A36 · S/N E-1797Built 1981 · Wb Aviation LLCN5299QCessna 150L · S/N 15073199Built 1972 · Ja Flight Services LLCN5514YSix Chuter SR7 XL · S/N 981899Built 1998 · Doucette Perry JN570JACessna 172S · S/N 172S10575Built 2007 · J A Flight Services LLCN571JACessna 172S · S/N 172S10549Built 2007 · Ja Flight Services LLCN572JACessna 172S · S/N 172S10553Built 2007 · J.A. Flight Services LLCN65JACessna 172N · S/N 17268591Built 1977 · Jahawk Leasing LLCN66099Cessna 150M · S/N 15075832Built 1974 · Maddock Jay AN704UWCessna 150M · S/N 15078894Built 1976 · Jahawk Leasing LLCN73170Cessna 172M · S/N 17267297Built 1976 · Jahawk Leasing LLCN737ZPCessna 172N · S/N 17269804Built 1977 · Jahawk Leasing LLCN76JACessna 172M · S/N 17263122Built 1974 · Jahawk Leasing LLCN77034Ted Glowiak MXL 2 · S/N 501182MGlowiak TedN79533Cessna 172K · S/N 17258156Built 1969 · Eby William JN806RGGray Richard D RV4 · S/N 806Built 2006 · Lamberson Jay MarkN807RVMayerhofer Andrew M RV-7 · S/N 70604Built 2004 · Mayerhofer Andrew MN827PACessna 172S · S/N 172S10155Built 2006 · Ja Flight Services LLCN828MBeech 95-B55 (T42A) · S/N TC-2299Built 1980 · Ja Flight Services LLCN846LCCessna 182S · S/N 18280240Built 1998 · Wegner Scott AN900JACessna 208B · S/N 208B0935Built 2002 · J A Aero Inc
Back to Sugar Grove, IL