Stanwood, WA
Registered aircraft · 50
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 = 'STANWOOD' 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 = 'STANWOOD' 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.
N103BPBurkhart Grob G103C TWIN III ACRO · S/N 34172N1179MCessna 172K · S/N 17258679N124NWBitton Roger L NIEUPORT II · S/N 230N130WNBowen Lawrence C VANS RV-8 · S/N 80607N1458YCessna 172C · S/N 17249158N153SCSix Chuter LEGEND XL · S/N 3087N1586DCessna 195B · S/N 7869N180GWFlug UND Fahrzeugwerke DIAMANT 18 · S/N 079N180WHCessna 180D · S/N 18050972N182GFCessna 182S · S/N 18280058N18423Stinson SR-9C · S/N 5321N18445Stinson SR-9F · S/N 5720N185NYCessna A185F · S/N 18503787N186MBInfinity COMMANDER · S/N IPP2046N1889MSamuel Roderick Bovington VANS RV-8 · S/N 83309N19782Cessna 177B · S/N 17702594N2014XCessna 182H · S/N 18256114N2405GCessna 182B · S/N 51705N2441FPiper PA-38-112 · S/N 38-79A0443N271DGSchweizer HUGHES 269C · S/N S1288N301WBCessna 170B · S/N 25343N32157Waco UPF-7 · S/N 5554N3232DCessna 180 · S/N 32030N341KAHylio AG-216 · S/N 17906090233N341NAHylio AG-216 · S/N 17906090234N34464Cessna 177B · S/N 17701821First renewal noticeN3744DCessna 182A · S/N 34444N413USCessna 305A · S/N 23164N4414RCessna TU206G · S/N U20605111N44LTTurner Edward L RV-4 · S/N 348N4623Grumman Acft ENG Cor-Schweizer G-164A · S/N 1087N5052Cessna 310 · S/N 38091N5625KBeech S35 · S/N D-7385N5816ACessna 172 · S/N 28416N6419Amateur Built 68 · S/N 1N675WMAmerican Champion 8KCAB · S/N 1164-2015N75417Stinson VULTEE V-77 · S/N 77475N77016Cessna 120 · S/N 11462N7874FCessna 150F · S/N 15063974N7LDDiamond Aircraft Industries HK 36 TTC · S/N 36554N7THHendrickson PIEL EMERAUDE · S/N 1395N808BFCor Versluis SH-3R (GLASAIR III) · S/N 3299N818MLCessna 150F · S/N 15064017N833GHRolladen-Schneider LS8-18 · S/N 8375N8558UCessna 172F · S/N 17252458N86897Bellanca 14-13 · S/N 1259N8906TCessna 182C · S/N 52806N9213XCessna 182E · S/N 18253613N9354CCessna 180 · S/N 31752N9814GCessna U206G · S/N U20603831
Back to Stanwood, WA