Bothell, WA
Registered aircraft · 67
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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 = 'BOTHELL' 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 = 'BOTHELL' 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.
N109DSRyan NAVION · S/N NAV-4-1373N1216TPiper PA-28R-200 · S/N 28R-7235238N131TMExtra Flugzeugproduktions-Und EA 300/LT · S/N LT047N13938Cessna 172M · S/N 17263041N13SXRobert Garniss SONEX MODEL B · S/N SNB-0017N146NCPiper PA 46-350P · S/N 4636176N1546FBeech A36 · S/N E-2478N16CGJohn P Burke CAVALON · S/N V00493N17197Stinson SR-9C · S/N 5302N2052RPiper PA-28-180 · S/N 28-5444N20HJDiamond Aircraft Ind DA 40 · S/N 40.937N225PLCirrus Design SR22T · S/N 1546N2347BUniversal GLOBE GC-1B · S/N 3647N2367GCessna 182B · S/N 51667N2403FPiper PA-38-112 · S/N 38-79A0419N2569YPiper PA-46-310P · S/N 46-8508104N267VAVans RV-12 · S/N 12043N2891NCessna 140 · S/N 13152N2RSPiper PA-28-180 · S/N 28-7205179N300EXExtra Flugzeugbau EA 300/L · S/N 011N3015NCessna 140 · S/N 13273N3135PSalvador Sahagun TITAN TORNADO 2 · S/N T95XXXCOHK0177N32YXWells Charlie WAIEX · S/N 0095N3520LCessna 150F · S/N 15062320N369DATextron 172S · S/N 172S13041N3719MPiper PA-12 · S/N 12-2541N3776AEarthstar GULL 2000 · S/N 001188N40148Stinson 108 · S/N 108-78N430HHuntsinger Robert J RV-4 · S/N 629N4353WEarthstar THUNDER GULL J · S/N 4/15/93-16N4360UHytek HURRICANE · S/N 1948N4362ADumm G/Kolb FIREFLY · S/N 001N4446VBeech 35 · S/N D-1256N456BJJones Robert H KR-2 · S/N 108N485MMooney M-18C · S/N 239N503TTFoster Robert L FOSTER TORNADO · S/N 03296N506SRans RANS S-41 COYOTE · S/N 1948N5113RBeech B19 · S/N MB-647N5131HTitan TORNADO I · S/N T95XXXCOHK0177N5452CCessna 170A · S/N 19486N5558ECessna 150 · S/N 17058N601WZSahagun Salvador G ZENITH 601 HDS · S/N 63280N621WTSaknit Thomas K VANS RV-7A · S/N 72843N6309MStinson 108-3 · S/N 108-4309N6800KPiper PA-16 · S/N 16-628N7136VMooney M20E · S/N 21-0045N7179PPiper PA-24-250 · S/N 24-2348N72883Cessna 140 · S/N 10077N729WMCirrus Design SR22T · S/N 9220N7300WPiper PA-28-180 · S/N 28-1064
Back to Bothell, WA