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

N1816FCessna 210F · S/N 21058716Built 1965 · Malcom Scott O N2675APiper PA-20-135 · S/N 20-952Troyer Robert Earl N269LRSerge Avramenko SCOUT ONE · S/N 894Avramenko Serge N321RBCessna 180J · S/N 18052677Built 1976 · Messmore Micheal Henry N32TTVans RV-12 · S/N 120392Built 2014 · Skyhawk Flight LLC N3936PPiper PA-22-150 · S/N 22-3611Built 1956 · Troyer Robert E N4328MPiper PA-12 · S/N 12-3262Built 1947 · Misch Gordon L N5263ZPiper PA-22-108 · S/N 22-8950Built 1961 · Wilkins Jerry D N53494Cessna 172P · S/N 17274765Built 1981 · Gandarillas Andrew J N536ACAir Creation USA SKYPPER · S/N T13017Pruitt Jerry L N53855Bellanca 7ECA · S/N 1149-76Messmore Michael H N555BEPiper PA-28R-200 · S/N 28R-7335254Built 1973 · Crocker William D N6457GCessna 150K · S/N 15071957N19752 LLC N6717NMooney M20C · S/N 680048Built 1968 · Gaskill David E N676SXTroyer Robert E SONEX · S/N 0676Built 2023 · Troyer Robert E N717LBeech 95-B55 · S/N TC-1495Built 1973 · N717l LLC N735WLCessna 182Q · S/N 18265742Built 1977 · Scott Lindsey N800SCEnstrom Helicopter 280C · S/N 1067Built 1976 · Malcom Scott O N8423LCessna 172I · S/N 17256623Young James A N9095MCessna 180H · S/N 18052195Built 1971 · Schramm Dale N9208BCessna 175 · S/N 55008Built 1958 · Young James A N9702CPiper PA-28-161 · S/N 28-7816519Built 1978 · Toledo Flying Club Inc N987JBrice A Johnson RV-9A · S/N J90897Built 2013 · Johnson Brice A

Back to Toledo, WA