OpenAirDocs.org
Sycamore, IL

Registered aircraft · 42

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

N1006LBoeger Bogie M SKYLER J1 · S/N 1234Built 2005 · Anderson Richard AN1612KAvian Balloon SKYHAWK · S/N 142Jonard Alex F IIN1616NFunk B85C · S/N 402Built 1947 · Saari Michael JN16418Piper PA-28-180 · S/N 28-7305250Built 1973 · Hallgren Mitchel TN177WCessna 195A · S/N 7642Built 1950 · Anderson David RN18641Filer Raymond W MUSTANG II · S/N M-11-258Anderson Richard AN1886APiper PA-18A · S/N 18-1719Built 1952 · Griffith Richard BN20KBBourkland-Basalay MUSTANG II · S/N M-2-570Built 1976 · Anderson David RN2418WPiper PA46-500TP · S/N 4697464Built 2011 · Sierra Tango Air LLCN2423VCessna 140 · S/N 14670Built 1948 · Dtc Flying Club LLCN2470LCessna 172H · S/N 17255670Built 1966 · Smith JosephN2785ZSchweizer SGS 1-26C · S/N 296Built 1965 · Adkins Dwain LN281BColonial C-2 · S/N 140Built 1959 · Anderson David RN2915KLuscombe 8A · S/N 5642Built 1947 · Fifer Logan JN3093SCessna 150G · S/N 15066993Built 1967 · Adkins Dwain LN32ZXAvian Balloon SKYHAWK · S/N 2ZXBuilt 2015 · Jonard Alex FN365MPSmith Miniplane JD SPECIAL · S/N 1ABuilt 1965 · Adkins Dwain LN3668EAeronca 11AC · S/N 11AC-1844Built 1947 · Anderson Richard AN46BHHollander Bruce CASSUTT IIIM · S/N A46Built 1988 · Anderson David RN5099KCessna 172N · S/N 17273969Built 1980 · Saari MichaelN5239CBeech B35 · S/N D-2630Dewitt Frederick EN5319Dwain Adkins NIEUPORT 24B1S · S/N 19-01Adkins Dwain LN5529RCessna 172F · S/N 17253109Built 1965 · Carlson Scott MN62659Boeing A75N1 · S/N 75-3027Built 1942 · Carlson Scott MN6975ACessna 172 · S/N 29075Anderson David RN71218Luscombe 8A · S/N 2645Built 1946 · Adkins Dwain LN71319Dwain Adkins J-3 KITTEN · S/N 98-01Adkins Dwain LN71436Silvaire LUSCOMBE 8A · S/N 2863Built 1946 · Adkins Dwain LN71492Luscombe 8A · S/N 2919Built 1946 · Adkins Dwain LN717FTGulfstream American AA-5A · S/N AA5A0876Built 1979 · Murtha Ronald A JrN7188HPiper J3C-65 · S/N 20450Newhouse James RN7391MCessna 175 · S/N 55691Built 1958 · Anderson Richard AN74MASocata TBM 700 · S/N 385Sierra Tango Air LLCN77918Luscombe 8A · S/N 3645Built 1946 · Dewitt Machenical And Services LLCN81DBAvian Balloon SPARROW · S/N 10Built 1980 · Jonard Monica LN82538Aeronca 7AC · S/N 7AC-1175Built 1946 · Adkins Dwain LN84FBBeech V35B · S/N D-10059Built 1977 · Johnson David PN85083Aeronca 7AC · S/N 7AC-3813Built 1946 · Adkins Dwain LN917FFHawker Beechcraft HAWKER 900XP · S/N HA-0038Built 2007 · See-More Air LLCN921BBell 47G · S/N 612Built 1952 · Adkins Dwain LN932ZXAvian Balloon FALCON II · S/N 3ZXBuilt 2016 · Jonard Alex F IIN9606BCessna 180A · S/N 32903Built 1957 · Anderson David R
Back to Sycamore, IL