Wilsonville, OR
Registered aircraft · 130
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 = 'OR' AND g.registrant_city = 'WILSONVILLE' 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 = 'OR' AND g.registrant_city = 'WILSONVILLE' 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.
N105UTBalony Kubicek Spol Sro BB30XR · S/N 1384N10897Cessna 172S · S/N 172S10606N111PRBalony Kubicek Spol Sro BB70Z · S/N 866N117TTCessna 182Q · S/N 18266432N12035Kubicek Factory S R O BB51Z · S/N 2582N1228FBalony Kubicek Spol Sro BB70Z · S/N 1237N124KLVans RV-12 · S/N 120769N1330NCessna 172S · S/N 172S10396N141PRKubicek Factory S R O BB40Z · S/N 2280N1464CCessna 172S · S/N 172S9897N1510CBalloon Works FIREFLY 7-B · S/N F7B-011N15426Piper PA-28-180 · S/N 28-7305075N1567VCessna 172M · S/N 17263668N16XRBalony Kubicek Spol S R L BB16XR · S/N 2486N171LLThunder & Colt COLT 77A · S/N 2001N177HHUltramagic M-56C · S/N 56/27N184SWFairchild SA227-AC · S/N AC-647N2096HFirefly Balloons GALAXY 10 · S/N GLX-10710N22265Cessna 172S · S/N 172S10026N226KLSwearingen SA226TC · S/N TC-321N231JMooney M20K · S/N 25-0521N2376MPiper PA-12 · S/N 12-1504N238SPCessna 172S · S/N 172S8223N240THGrant Webb Cassady RV-6 · S/N 24016N24144Cessna 172S · S/N 172S10558N2446ZCessna 172S · S/N 172S10118N2459SCessna 172S · S/N 172S10036N2481TPiper PA-28-180 · S/N 28-7205058N250PRKubicek Factory S R O BB70Z · S/N 2432N259DSFairchild Dornier DORNIER 328-300 · S/N 3197N26264Cessna 182S · S/N 18280265N2691WFairchild SA227-AC · S/N AC-655BN2728GFairchild SA227-AC · S/N AC-731N272TStaudacher S-300D2 · S/N 21N276CASwearingen SA226TC · S/N TC276N27BJLearjet 24B · S/N 227N280KLSwearingen SA226TC · S/N TC-280N288HKCessna 680 · S/N 680-0313N2FPCirrus Design SF50 · S/N 0297N31171Fairchild SA227-AC · S/N AC-605N315DCFlint Cristopher FREEBIRD 300 · S/N FB-300N3251RBell Helicopter Textron Canada 429 · S/N 57359N326BASwearingen SA226TC · S/N TC 269N328HRonald Heberlein WAIEX B · S/N WXB0026N3394FCameron Balloons US Z-77 · S/N 6207N360ESCessna 172R · S/N 17280010N366DCEmbraer EMB-120ER · S/N 120.288N366JRobinson Helicopter R66 · S/N 0952N377AMBeech 36 · S/N E-63N386UZAir Adventures Balinismo Ltda AIR N-34 · S/N CAH-20090013
Back to Wilsonville, OR