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 = 'LIBERTY LAKE' 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 = 'LIBERTY LAKE'
  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 = 'LIBERTY LAKE'
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.

N1057QCessna T182T · S/N T18208794Built 2007 · Lofty Goals Aviation LLC N11JVGrumman American Avn. AA-5B · S/N AA5B0593Built 1977 · Holtz Jeff N124ANitzsche Ren SEAREY · S/N 1MK 442 CBuilt 2008 · Finck Charles F N177AJAviat A-1B · S/N 2328Built 2006 · Pnw Tin Goose LLC N2005NCessna 140 · S/N 12241Built 1947 · Moore Michael T N2454RCessna 182G · S/N 18255554Built 1964 · Brown Timothy L N2517QPiper PA-32R-300 · S/N 32R-7780250Pnw Tin Goose LLC N2600ZPiper PA-18-150 · S/N 18-8844Built 1969 · Short Seth J N366TBSocata TB-20 TRINIDAD · S/N 1724Louie Co Pilot LLC N4752QCessna A185F · S/N 18503553Built 1978 · Brown Timothy L N5720FPiper PA-28-140 · S/N 28-24933Built 1968 · Hander Robert N5920SBeech V35 · S/N D-8131Lukan Duane G Trustee N751PFMaule M-7-260C · S/N 30017CDuff Barrett N829CTFlight Design CTSW · S/N 07-07-12Built 2007 · Bellstam Gustaf N8446ZCessna 210-5 · S/N 205-0446Registration pendingBuilt 1963 N8716TCessna 182C · S/N 52616Built 1960 · Manchester International LLC N8747MBeech 23 · S/N M-535Built 1963 · Smith Peter N9158MCessna U206E · S/N U20601558Built 1970 · Scott Richard A

Back to Liberty Lake, WA