Vancouver, WA
Registered aircraft · 201
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 = 'VANCOUVER' 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 = 'VANCOUVER' 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.
N1032SBirch Robert J PITTS S-1 · S/N 144-HN10785Robert E Burton JR SKYOTE · S/N 85N107AMAviat A-1 · S/N 1385N1086MCessna 182P · S/N 18264222N110VCessna 140 · S/N 8748N1144KMooney M20J · S/N 24-1185N12188Cessna 172M · S/N 17261871N13461Cessna 172M · S/N 17262768N137AZVans RV-12 · S/N 120585N1384HAeronca 15AC · S/N 15AC-434N13CVUpright Alan M RV-6A · S/N 103N1429VPiper PA-11 · S/N 11-339N1449QCessna 150L · S/N 15072749N1529CCessna 180 · S/N 30229N1591XPiper PA-32-300 · S/N 32-7540180N16221Cessna 150L · S/N 15073553N17051Cessna C-34 · S/N 334N1708ASteve William Branson RV-8A · S/N 80968N172RACessna 172S · S/N 172S9919N180CZAberg Larry COZY MK IV · S/N 0180N180YYCessna 180J · S/N 18052485N184FCook James Davis BARRACUDA · S/N 184N186XCessna 185A · S/N 1850437N190CDCirrus Design SR20 · S/N 1099N19298Cessna 150L · S/N 15074316N2007YCessna 172C · S/N 17249507N2017ECessna T182 · S/N 18268183N20589Cessna 172M · S/N 17261421N2123YCessna 182T · S/N 18281893N21538Mooney M20M · S/N 27-0255N2174KPiper PA-28RT-201T · S/N 28R-7931003N2197XKukura Dave VANS RV 6 · S/N 23293N223HDVans RV-12 · S/N 120606N22413Air Creation CLIPPER · S/N T02091N2266VCessna 140 · S/N 14521N2292VCessna 140 · S/N 14528N2306HErcoupe 415-C · S/N 2931N231HFMooney M20K · S/N 25-0258N2326XCessna 182H · S/N 18256226N2344DCessna 170B · S/N 20496N2383WBeech A23-19 · S/N MB-18N23WWWright-Wesser CHRISTEN EAGLE II · S/N WRIGHT/WESSER-1N25210Erwin KINGFISHER · S/N 76N256JMAviat A-1B · S/N 2095N2703VCessna 177RG · S/N 177RG0663N27867Crary George W CYGNET 2F-2A · S/N 127N280CPCirrus Design SR22 · S/N 3222N29236Aerostar International RX-7 · S/N RX7-3022N292VAVans RV-12IS · S/N 121083N296DBBenua Daniel R VANS RV-6A · S/N 23615
Back to Vancouver, WA