Registered aircraft · 23

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'COUPEVILLE' ORDER BY g.n_number

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 = 'COUPEVILLE'
  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 = 'COUPEVILLE'
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.

N144PZDavid A Goodman GOODMAN SABERWING-KF · S/N DG002Built 2019 · Goodman David A N15620Baumer Martin GLASTAR · S/N 5529Built 2005 · Bayles Mark S N19268Cessna 150L · S/N 15074289First renewal noticeBuilt 1973 · Youderian Kenneth E N301RPGlasflugel H 301 LIBELLE · S/N 56Built 1967 · Horigan Shawn R N3127PPiper PA-23 · S/N 23-1050Thorn Blake A N3495LCessna U206B · S/N U206-0795Built 1967 · Saqul'Aq Air LLC N440SCSix Chuter West LEGEND XL · S/N 3189Built 2018 · Kumpf Eric W N453MDUrban Air Sro SAMBA XXL · S/N SAXL46Built 2007 · Clark Michael D N51369Cessna 150J · S/N 15069956Thorn Blake A N562YBeech A36 · S/N E-2633Built 1991 · Dion William N6068DPiper PA-22-150 · S/N 22-4721Thorn Blake A N6612UMooney M20D · S/N 107Built 1963 · Giem James L N693KMMeehan D B/King M L VANS ACFT RV6A · S/N 22683Built 1997 · Meehan Donald B N71188Cessna 182M · S/N 18259525Built 1968 · Youderian Kenneth E N725SRProgressive Aerodyne SEAREY LSA · S/N 1033Built 2015 · Schricker Karl N736PWCessna R172K · S/N R1722690Built 1977 · Theno Steven M N779KTTurner Keith R RV-7A · S/N 72880Built 2021 · Turner Keith R N819DSHall D/Hall S RANS S-19 · S/N 060800014Built 2011 · Buerk Lawrence A N825DEMiles Allen Z SKYBOLT 1 · S/N 01Built 1981 · Youderian Kenneth E N86DWGrumman American Avn. AA-5 · S/N AA5-0357Built 1973 · Whidbey Flight Services LLC N891SKCirrus Design SR22T · S/N 0819Built 2014 · Wasik Donald F N9177DPiper PA-22-160 · S/N 22-6234Built 1958 · Cheyann Jordan N988NADion William J GLASAIR IIS-FT · S/N 2088Built 2006 · Dion William J

Back to Coupeville, WA