Oak Harbor, WA
Registered aircraft · 48
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 = 'OAK HARBOR' 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 = 'OAK HARBOR' 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.
N106RBBixby Rex V RV-4 · S/N 1066N12687Cessna 172M · S/N 17262177N149PGPiaggio P-149D · S/N 177N183ATrophy Aero GLASAIR SHA · S/N SN-183N189PDCubcrafters CC11-160 · S/N CC11-00189N2095WPiper PA-28RT-201 · S/N 28R-7918077N21343Cessna 182P · S/N 18261575N21908Cessna 150L · S/N 15074528N2267KLuscombe 8A · S/N 4994N273TCCessna T182T · S/N T18209090N3165PPiper PA-23 · S/N 23-1097N31KFMcfee Don ELITE · S/N 607EN3809LCessna 172G · S/N 17253978Sale reportedN3823SCessna 172E · S/N 17251023N40LWPiper PA-23-250 · S/N 27-7554146N4119LCessna 172G · S/N 17254188N4248JPiper PA-28-140 · S/N 28-22604N43199Taylorcraft BC12-D · S/N 6858N4320ZPiper PA-18-150 · S/N 18-8633N4411JPiper PA-28-140 · S/N 28-22806First renewal noticeN4453ZPiper PA-18-150 · S/N 18-8800N45872Luscombe 8A · S/N 2399N5093TBeech 19A · S/N MB-378N531VCessna 175A · S/N 56685N53745Bellanca 7ECA · S/N 1111-75N543Beech D35 · S/N D-3686N5752QMooney M20C · S/N 3078N601SAAshley Stuart C ZODIAC 601XL · S/N 6-6288N61891Cessna 172M · S/N 17264872N620GWCessna 172L · S/N 17260486N6216ACessna 182 · S/N 33016N6541XAerostar International RAVEN S57-A · S/N S57A-3007N6978GCessna 150L · S/N 15072478N701ABScottish BULLDOG MDL 120/121 · S/N BH120/350N717WKDavis William E RV-6A · S/N 24737N7364ACessna 172 · S/N 29464N7387YPiper PA-30 · S/N 30-442N7416WPiper PA-28-180 · S/N 28-1304N7426GCessna 172K · S/N 17259126N752DBeech D35 · S/N D-3413N756SRobert L Savage RV7-A · S/N 70656N7782WPiper PA-28-180 · S/N 28-1789N84857Consolidated Vultee PBY-5A · S/N 1522N8737NPiper PA-28-140 · S/N 28-25553N9000LMooney M20C · S/N 680005N910RHPiper PA-46-310P · S/N 46-8408066N912JPiper PA-28-161 · S/N 28-7916064N9651LGrumman American Avn. AA-1B · S/N AA1B-0151
Back to Oak Harbor, WA