Champaign, IL
Registered aircraft · 60
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 = 'CHAMPAIGN' 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 = 'CHAMPAIGN' 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.
N101JJBell Textron Canada 429 · S/N 57443N103EZLearjet 45 · S/N 418N11GHHast WOODEN BABY A · S/N 1N1218Beech D-45 · S/N BG-163N12502Cessna 172M · S/N 17262025N18CNBeech E33A · S/N CE-208N18TUBeech V35 · S/N D-8450N1958BCessna 172M · S/N 17261839Sale reportedN20BUPiper PA-23-250 · S/N 27-7754063N2269HMerrill Timothy D COZY MARK IV · S/N MK0212N256SRCirrus Design SR22 · S/N 2553N26810Piper J3L-65 · S/N 4190N288PKCirrus Design SR20 · S/N 2089N2897QPiper PA-28-236 · S/N 28-7911232N29992Waco UPF-7 · S/N 5489N31010Cameron Balloons US ZL-70 · S/N 6967N3476HBeech T-34B · S/N 144039N3572CCessna 170B · S/N 26616N3792GBeech A45 · S/N G-770N3966Rans S-12XL · S/N 01960674N3CNBeech-Nogle D-45 · S/N BG-198N3GWCirrus Design SR22T · S/N 10381N4020PBeech T-34C-1 · S/N GM-91N4021ABeech T-34C-1 · S/N GM-61N410LSLearjet 45 · S/N 420N4144VCessna 170 · S/N 18622N4170Beech A45 · S/N G-270N422MNBeech A45 · S/N G833N4240VCessna 170 · S/N 18596N436JSSowalsky John W STALLION · S/N 024N4374YEa Vision EA J100 · S/N 85695N437NDEa Vision EA J100 · S/N 85539Registration pendingN451PCAmerican Champion 8KCAB · S/N 1220-2024N45MSRaytheon A36 · S/N E-3384N4645Owens WITTMAN TAILWIND-W-8 · S/N 189N470HBDJI AGRAS T50 · S/N 1581F6BUB24A400162CUN482FBXag P150 · S/N 1863FPEG8223512VL021N50GECirrus Design SF50 · S/N 0275N5192BDJI AGRAS T100 · S/N 1581F8ZLC2564002YRV8N601RTThoma Roy E III ZODIAC CH601HDS · S/N 63314N6404DBeech A45 · S/N G-124N64172Fairchild M-62C(PT-23A) · S/N 260-HON652LBEa Vision EA J100 · S/N EAVUAV502586363N6539GCessna 150L · S/N 15072039N74010Beech A45 · S/N G-103N7433PHomer Purtle SERIES V · S/N S95030115N747BKBlackshape BS115-BK160 · S/N BCV 21007N7710JDavid N Boyd PIETENPOL AIR CAMPER · S/N 001N7829CBeech A45 · S/N G-95N787BKBlackshape BS115-BK160 · S/N BCV 21006
Back to Champaign, IL