Woodstock, IL
Registered aircraft · 37
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 = 'WOODSTOCK' 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 = 'WOODSTOCK' 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.
N1062GAdams Balloon A55S · S/N 078N1063TAdams Balloon A50S · S/N 113N1237UCessna 172M · S/N 17266932N123XCCirrus Design SR22 · S/N 0345N17798Aeronca K · S/N K-64N17854Piper J-2 · S/N 1289N1812ZBeech 77 · S/N WA-280N1943EAeronca 7AC · S/N 7AC-5510N2058BLuscombe T-8F · S/N 6485N223BCClements Kenneth Brian ROTORWAY 162F KIT · S/N 6269N226CDCirrus Design SR20 · S/N 1130N27053Piper J5A · S/N 5-20N270ASSchleicher ASW-27 · S/N 27147N281WYAviat A-1C-180 · S/N 3281N2922MPiper PA-12 · S/N 12-1446N29361Piper PA-28-236 · S/N 28-7911176N3194ZPiper PA-18 · S/N 18-7190N421MLCessna 421C · S/N 421C0880N4539LGrumman American Avn. AA-5B · S/N AA5B1300N4611FCessna P206A · S/N P206-0211N5277VCessna 210L · S/N 21060892N5287NNorth American SNJ-4 · S/N 88-9551N5878FCessna 210G · S/N 21058878N5974LAmerican AA-1 · S/N AA1-0274N7044GCessna 172K · S/N 17258744N728RAAdkins Clifton R RV-9A · S/N 90381N73423Cessna 172M · S/N 17267447N7554UNorth American HARVARD 4 · S/N 20428N7984CNorth American SNJ-6 · S/N 112123N81856Aeronca 7AC · S/N 7AC-479N8484ZCessna 210-5A(205A) · S/N 2050484N85920Aeronca 11AC · S/N 11AC-332N88510Piper J3C-65 · S/N 16134N9158QBeech V35B · S/N D-9217N9458JPiper PA-28-180 · S/N 28-3571N98006Piper J3C-65 · S/N 18144N9921ECessna 182P · S/N 18263981
Back to Woodstock, IL