Registered aircraft · 18

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

N112NGDiamond Aircraft Ind DA 42 NG · S/N 42.N192Western United Aviation LLC N131AWAircraft Mfg & Development CH601XL SLSA · S/N 601-047SBuilt 2007 · Stanger Charles P N2617AQuicksilver Enterprises MX SPRINT II · S/N SPRINT II 193Lynn Ronald W N358MECessna 182S · S/N 18280847Built 2000 · Ribelin Holdings LLC N41360Piper J5C · S/N 5-1395Built 1945 · Cross Thomas Ad N512TDOstien Douglas B SKY RAIDER II · S/N 1001Built 2014 · Cross Thomas A D N58629Piper J3C-65 · S/N 8607Built 1942 · Thomas Cross Ad N619VMCessna A185F · S/N 18504284Built 1981 · Halberg Barri R N6999UMooney M20C · S/N 2720Built 1964 · Ruff Daniel D N70299Piper J-3 · S/N 17494Built 1946 · Cross Thomas Ad N73861Grayson B Rotschy KITFOX SERIES V · S/N S97050214Built 2026 · Rotschy Grayson B N7822DPiper PA-22-150 · S/N 22-5468Built 1957 · Twinco Leasing LLC N7841HPiper PA-12 · S/N 12-741Built 1946 · Cross Thomas Ad N81589Croft Robert C KITFOX 2 · S/N 307Built 1989 · Rotschy Grayson B N82749Piper PA-18-150 · S/N 18-7709188Built 1977 · Habersetzer Lon J N8539YPiper PA-30 · S/N 30-1626Built 1967 · Twinco Leasing LLC N9214VMooney M20C · S/N 690049Built 1969 · Gostomski Michael J N98400Piper J3F-90 · S/N 18588Built 1946 · Cross Thomas Ad

Back to Yacolt, WA