Bainbridge Island, WA
Registered aircraft · 39
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 = 'BAINBRIDGE ISLAND' 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 = 'BAINBRIDGE ISLAND' 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.
N12FYLorenz Eber DAKOTA HAWK · S/N 003N1595Fairchild 24R-9 · S/N R9-427N2097PPipistrel SINUS 912 · S/N 206S9121106KIT49First renewal noticeN2170NPiper PA-44-180 · S/N 44-7995224N223MKCirrus Design SR22 · S/N 1003N25KBeech D17S · S/N 6881N289RWRobinson Helicopter R66 · S/N 1187N2920KCessna 180K · S/N 18053130N3037JCessna 150E · S/N 15061137N321CUStambaugh Scot D F1 · S/N 019N388STCirrus Design SR22T · S/N 2410N39716Waco UPF-7 · S/N 5849N399MECessna 182S · S/N 18280878N40820Donahue Mark T KITFOX IV · S/N 1530N421ANCessna 421C · S/N 421C1028N427KSScurlock John H VANS ACFT RV-6 · S/N 21011N449CCObrien Terence CCK-1865 · S/N CCK-1865-00118N459MJMark T Donahue DONAHUE MARK RV-9A · S/N 91216N504CDAviat A-1C-180 · S/N 3413N5106ZPiper PA-22-108 · S/N 22-8746N52056Cessna 162 · S/N 16200023N5213UCessna 162 · S/N 16200039Registration pendingN589DBBurgess Daniel J SPORTSMAN GS-2 · S/N 7424N5902LAmerican AA-1 · S/N AA1-0202N611WPBeech C-45H · S/N AF-875N61FSTurpen Kenneth P RV-8 · S/N 83145N6645UMooney M20D · S/N 140N677BEBeech A36 · S/N E-1090N6799GCessna 150L · S/N 15072299N680BBGulfstream Aerospace GVI (G650ER) · S/N 6425N739RDCessna 172N · S/N 17270737First renewal noticeN779XCCub Crafters CC19-180 · S/N CC19-0030N788WLancair LC-40-550FG · S/N 40022N803DCColliander Richard J COLLIANDER VANS RV-8 · S/N 80192N8713CPiper PA-28-140 · S/N 28-7625127N87SMBeech 58 · S/N TH-1587N96890Cessna R172E · S/N R172-0118N9744ACessna 170A · S/N 19205N99BVBrian N Vickers VANS RV-4 · S/N 3001
Back to Bainbridge Island, WA