OpenAirDocs.org
Somerton, AZ

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
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 = 'AZ' AND g.registrant_city = 'SOMERTON'
  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.

N14WTAirborne Windsports PTY EDGE XT-912-L · S/N XT-912-0319Registration pendingBuilt 2009N1545GCessna T210G · S/N T210-0208Built 1966 · Saltzer Eric RN2034JCessna T188C · S/N T18803339TBuilt 1978 · Md Aero LLCN2180DBeech D35 · S/N D-3548Built 1953 · Kent JamesN399FCessna 180 · S/N 31478Built 1955 · Fieldgrove Matt LN415CMEngineering & Research ERCOUPE 415-CD · S/N 4259Built 1947 · Fieldgrove MattN4172VCessna 170 · S/N 18505Built 1948 · Md Aero LLCN4223VCessna 170 · S/N 18579Built 1948 · Mcdermotts Letsfly LLCN44127Taylorcraft BC12-D · S/N 9927Built 1946 · Saltzer Eric RN55939Stinson VULTEE V-77 · S/N 77-257Fieldgrove MattN5988MCessna 421B · S/N 421B0231Built 1972 · Saltzer EricN60742Cessna 150J · S/N 15070539Built 1969 · Greene Daniel WN6682YPiper PA-23-250 · S/N 27-4003Built 1968 · Mcdermott James RN67DVCessna 180B · S/N 50359Arizona Airplay LLCN6918MStinson 108-3 · S/N 108-4918Built 1948 · Md Aero LLCN737JHCessna 172N · S/N 17269449Built 1977 · Mcdermotts Letsfly LLCN757JKCessna 152 · S/N 15279775Built 1977 · Mcdermotts Letsfly LLCN7598TCessna 172A · S/N 47198Fieldgrove Matt LN7769ECessna 150 · S/N 17569Built 1959 · Fieldgrove MattN7HWPiper PA-23-250 · S/N 27-3718Built 1967 · Altieri Frank JN8084WPiper PA-28-180 · S/N 28-2174Built 1965 · Fieldgrove Matt LN88778Cessna R172E · S/N R172-0128Hubbard Austin LN9391WPiper PA-28-235 · S/N 28-11087Nunez Jesus
Back to Somerton, AZ