Registered aircraft · 21

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

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 = 'WALKER RAY A' OR list_contains(g.other_registrant_names, 'WALKER RAY A') 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_name = 'WALKER RAY A' OR list_contains(g.other_registrant_names, 'WALKER RAY A')
  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_name = 'WALKER RAY A' OR list_contains(g.other_registrant_names, 'WALKER RAY A')
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.

N170SBeech D17S · S/N 4817Built 1945 · Sanger, TX N2038KLuscombe 8E · S/N 4765Built 1947 · Sanger, TX N3174Travel Air Mfg 2000 · S/N 248Sanger, TX N36407Taylorcraft DC-65 · S/N 4148Built 1942 · Sanger, TX N420EBeech D17S · S/N 6671Built 1944 · Sanger, TX N43295Taylorcraft BC12-D · S/N 6954Built 1946 · Sanger, TX N43622Taylorcraft BC12-D · S/N 7281Sanger, TX N44258Taylorcraft BC12-D1 · S/N 10058Sanger, TX N45692Silvaire LUSCOMBE 8A · S/N 2219Sanger, TX N4882EChampion 7GC · S/N 7GC-59Built 1959 · Sanger, TX N4891NBoeing E75 · S/N 75-8142Sanger, TX N501VTravel Air 4000 · S/N A-1Built 1929 · Sanger, TX N54034Boeing D75N1 · S/N 753994Built 1941 · Sanger, TX N65047Howard DGA-15P · S/N 712Built 1943 · Sanger, TX N6653VBeech V35B · S/N D-10253Built 1979 · Sanger, TX N71428Luscombe 8A · S/N 2855Built 1946 · Sanger, TX N78209Globe GC-1B · S/N 2209Built 1946 · Sanger, TX N9005Curtiss Wright TRAVEL AIR 4000 · S/N 806Sanger, TX N95082Taylorcraft BC12-D · S/N 9482Sanger, TX N95208Taylorcraft BC12-D · S/N 9608Built 1958 · Sanger, TX N95739Taylorcraft BC12-D · S/N 8039Sanger, TX

Back to Walker Ray A