OpenAirDocs.org
Urbana, IL

Registered aircraft · 34

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

N10DDDale BREEZY DALE-1 · S/N 1Built 1974 · Frasca Air Museum IncN11201Mooney M20J · S/N 24-0058Built 1976 · Moment Stuart LN2660NCessna 120 · S/N 12918Built 1947 · Moment Lisa AN29HSAS+ AC 4 · S/N 022Built 1996 · Cocatre-Zilgien Jan HN335FGBombardier BD-100-1A10 · S/N 20974Built 2023 · N335fg LLCN34298Schweizer SGS 2-33A · S/N 420Built 1976 · Frasca Air MuseumN34JTTison PITTS S-1C · S/N 14JTShowerman Mike TN380MMMooney M20R · S/N 29-0068Built 1995 · Folk Daniel HN3830QCessna 172L · S/N 17259930Built 1971 · Aero Place Flyers IncN4002KRobinson Helicopter R22 BETA · S/N 1390Built 1990 · Summerskyz IncN40PECurtiss Wright P-40E · S/N AK905Built 1942 · Frasca Lucille AN42733Piper J3C-65 · S/N 15033Built 1945 · Frasca Air Museum IncN435FGBombardier BD-100-1A10 · S/N 20982Built 2023 · N435fg LLCN451LMustang BM-1 · S/N 177Frasca Lucille AN4729ZPiper PA-22-108 · S/N 22-8275Built 1961 · Sublogic CorpN54RFBeech A45 · S/N G-140Built 1957 · Frasca Lucille AN571MMBarrett Bruce M STOLP STARLET SA500 · S/N 06118Built 2008 · Moment Stv LN6025TBeech V35B · S/N D-10213Built 1979 · Vtales LLCN6290CGrumman FM-2 · S/N 5804Built 1945 · Frasca Lucille AN643RRaffensparger BD-4 · S/N 643Built 1978 · Showerman MichaelN71312Luscombe 8A · S/N 2739Built 1946 · Frasca Air MuseumN716FGLearjet 45 · S/N 549Built 2016 · N716fg LLCN720AREnyu Luo IBQR 1 · S/N IBQR001001University Of Illinois At Urbana-ChampaignN7389VBellanca 17-30 · S/N 30224Built 1969 · Lascar Amado JN7679HRobinson Helicopter R22 BETA · S/N 3540Built 2004 · Summerskyz IncN7780HRobinson Helicopter R22 BETA · S/N 2682Built 1997 · Summerskyz IncN7986CNorth American SNJ-5 · S/N 51698Built 1943 · Frasca Lucille AN815PTTestory Perry E TESTORY RV-3 · S/N 11028Built 2009 · Testory Perry EN816FGLearjet 45 · S/N 550Built 2016 · N816fg LLCN9118QBeech V35B · S/N D-9225Bonanza Life LLCN919FGBombardier BD-700-2A12 · S/N 70025Built 2019 · N919fg LLCN9825CNorth American SNJ-6B · S/N 111987Built 1945 · Frasca Lucille AN9840ZBeech C-45H · S/N AF-886Built 1960 · Mcdaniel PeterN992DNNetanel Niv RANS S6S · S/N 06001378Built 2003 · Testory Perry E
Back to Urbana, IL