OpenAirDocs.org
Piercy Ronald S

Registered aircraft · 16

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

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_name = 'PIERCY RONALD S' OR list_contains(g.other_registrant_names, 'PIERCY RONALD S')
  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.

N16533Aeronca C-3 · S/N A675Moses Lake, WAN2692HSchweizer SGS 2-33A · S/N 526Built 1978 · Moses Lake, WAN3803FGreat Lakes 2T-1A-2 · S/N 0771Built 1977 · Moses Lake, WAN41BZPdps Pzl-Bielsko SZD-41B · S/N X130Built 1976 · Moses Lake, WAN48070Let BLANIK L-13 · S/N 026036Built 1974 · Moses Lake, WAN4841APiper PA-22-150 · S/N 22-3994Moses Lake, WAN49122Taylorcraft DCO-65 · S/N L-4764Built 1943 · Moses Lake, WAN5034KBellanca 7GCBC · S/N 1073-79Built 1978 · Moses Lake, WAN5038KBellanca 8KCAB · S/N 482.79Built 1979 · Moses Lake, WAN5062PBellanca 8KCAB · S/N 568-79Built 1979 · Moses Lake, WAN7665SBellanca 7GCAA · S/N 331-76Moses Lake, WAN78420Piper J3C-65 · S/N 23159Built 1947 · Moses Lake, WAN8801XEagle EAGLE DW-1 · S/N DW-1-0010-80Built 1980 · Moses Lake, WAN9119LChampion 7GCBC · S/N 304-71Built 1970 · Moses Lake, WAN93WKBellanca 7GCBC · S/N 643-74Built 1973 · Moses Lake, WAN9940YChampion 7GCB · S/N 7GCB-136Moses Lake, WA
Back to Piercy Ronald S