Gig Harbor, WA
Registered aircraft · 155
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 = 'GIG 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 = 'GIG 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.
N1000TBeech H35 · S/N D-4980N1118BLuscombe 8E · S/N 5745N111SEPiper PA-24-260 · S/N 24-4462N1185FCessna 172N · S/N 17272963N123PTPiper PA-31-325 · S/N 31-8112020N14394Piper PA-23-250 · S/N 27-7304991N145RLPiper J3C-65 · S/N 10969N14ZPNovotny Gregory S VANS RV14A · S/N 140209N1546CCessna 180 · S/N 30246N17569Piper J-2 · S/N 1069N17572Cessna 182T · S/N 18281628N17722Beech 95-B55 (T42A) · S/N TC-2045N1808JRockwell International 112TC · S/N 13028N180JLCessna 180A · S/N 32858N19582Cessna 150L · S/N 15074505N201WMooney M20J · S/N 24-0184N202WTRobinson Helicopter R44 · S/N 1847N203AMPiper PA-31-310 · S/N 31-7912037N21150Cessna 182P · S/N 18261448N2174XPiper PA-28-181 · S/N 28-7990362N222KHPiper PA-23-250 · S/N 27-7305097N225SBodenheimer Thurman E RV-7 · S/N 71150N2278YCessna T182T · S/N T18208736N2308ECessna 172N · S/N 17271228N231KWMooney M20K · S/N 25-0146N23297Piper J3C-65 · S/N 3048N23PJThielsen T Keeling-Garcia RV-4 · S/N 2420First renewal noticeN2544MPiper PA-12 · S/N 12-1033N254MRShannon Ronald D MURPHY REBEL · S/N 254RN255WSWild Sky GOAT · S/N 2243N25785Cessna 152 · S/N 15280783N2726YBeech 95 · S/N TD-76N2825FCessna 182J · S/N 18256925N2897DBeech 35 · S/N D-898N3032FCessna 162 · S/N 16200104N3032UCessna 162 · S/N 16200106N3083SCessna 150G · S/N 15066983N30TSShanks Theodore E VANS RV-4 · S/N 156N3125QCessna 182K · S/N 18258125N3150Alexander Schleicher ASH 31 MI · S/N 31167N324RBBumstead Richard ROTORWAY ELETE · S/N 003N3255VBeech 35 · S/N D-702N33BEBiggs J T/Ellis D A EXPRESS · S/N 100298N341VTBeech S35 · S/N D-7589N34275Cessna 177B · S/N 17701743N361CStinson 108-2 · S/N 108-3361N3625LCessna 172G · S/N 17253794N3640MPiper PA-12 · S/N 12-2495N3660RPiper PA-28-180 · S/N 28-5764N369ELRobinson Helicopter R44 · S/N 1590First renewal notice
Back to Gig Harbor, WA