East Wenatchee, WA
Registered aircraft · 43
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 = 'WA' AND g.registrant_city = 'EAST WENATCHEE' 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 = 'WA' AND g.registrant_city = 'EAST WENATCHEE' 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.
N111VHRolladen-Schneider OHG LS3-A · S/N 3326N14147Beech C35 · S/N D-3145N1612ZAvian Balloon SKYHAWK · S/N 150N206YACessna 206 · S/N P2060065N254BALet BLANIK L-13 · S/N 026030N2561QCessna 182K · S/N 18257761N2806ACessna 180 · S/N 30006N3070JCessna 150E · S/N 15061170N3166ACessna 170B · S/N 25810N3284YCessna 182E · S/N 18254284N3299UCessna 182F · S/N 18254699First renewal noticeN333CCCrane Conrad R SONEX · S/N 1452N359BALet L 33 SOLO · S/N 990508N384FZNorth Wing Uum SPORT X2 · S/N E7015N44CCCessna 182N · S/N 18260646N4507FCessna A185E · S/N 185-0989N456WTFlight Design CTSW · S/N 06-10-11N4630EAeronca 7CCM · S/N 7CCM-197N4654XCessna 150G · S/N 15064704N4830TRosen Maurice D INFINITY · S/N IPP4-261N4844TPiper PA-28-180 · S/N 28-7205206N4972NCessna 182Q · S/N 18267493N5009NParsons John R WAGABOND · S/N 985N511BASportine Aviacija IR Ko LAK-17B FES MINI · S/N 020N52ASLet BLANIK L-13 · S/N 027056N53902Bellanca 8KCAB · S/N 230-76First renewal noticeN616THRobinson Helicopter R66 · S/N 0687N6205FEdwards Mark S WAG-AERO EDWARDS S S · S/N 254N62691Kelly Michael KOLB MARK III · S/N M3-243N62TMSchleicher ASW-20 · S/N 20485N6541ECessna 175 · S/N 56041N666MGCessna 150L · S/N 15073977N677WHWilliam A Hungelmann CH 750 · S/N 75-8115N7254FPiper PA-28-140 · S/N 28-25172N7427ACessna 172 · S/N 29527N78726Piper PA-11 · S/N 11-1478N796WSpirit Of Wenatchee BELLANCA CH 300 REPL · S/N 3004N8008TCessna 175A · S/N 56708N8600ZCessna P206B · S/N P206-0400N8637QBeech 95-B55 (T42A) · S/N TC-781N8KSSmith Kenneth S RANS S-6S · S/N 0594622N9461QBeech V35B · S/N D-9322N99167I.C.A.-Brasov IS-28B2 · S/N 43
Back to East Wenatchee, WA