Registered aircraft · 21

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 = 'TX' AND g.registrant_city = 'VALLEY VIEW' 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 = 'TX' AND g.registrant_city = 'VALLEY VIEW'
  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 = 'TX' AND g.registrant_city = 'VALLEY VIEW'
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.

N102DMMassey Richard L TAILWIND W8 · S/N 97Built 1983 · Chisum Brian J N151APPiper J3C-65 · S/N 20760Built 1946 · Chisum Kenneth J N205GMMihlebach Gustav HATZ CB-1 · S/N 205Built 1987 · Jones Bobby J N217GMCirrus Design SR22 · S/N 3688Built 2010 · Marcom Michael D N234WWBeech F33A · S/N CE-878Built 1979 · Mcadams James P N2404ZCessna 182 · S/N 18267897Built 1981 · Sutherland Kurt Aron N249EBICP SAVANNAH S · S/N 21-10-54-0816Built 2021 · Smooth Flight LLC N27KKleber John P THORP T-18 · S/N 1067ABuilt 1987 · Hume James W N448CJCessna 525C · S/N 525C0163Built 2014 · Wings & Wheels LLC N4594NBoeing 75 · S/N 75-5843Chisum Brian J N505CBBell Helicopter Textron Canada 505 · S/N 65065Clayton Boyd Agricultural Equipment LLC N53PDEBY David R THORP T-18 · S/N 1202Built 1987 · Hume James W N660JHJames E Hardy ROTORWAY TALON A600 · S/N 8151Built 2017 · Hardy James E N661JHHardy James E YOUNGSTER V · S/N 075Built 2001 · Hardy James E N662JHJames E Hardy MILHOLLAND DE · S/N C48Built 2014 · Hardy James E N663JHJames E Hardy VANS RV7 · S/N 73996Built 2026 · Hardy James E N6784FPiper PA-28-140 · S/N 28-7725079Built 1976 · Grant James C N69HMHappy H Miles ONEX · S/N ONX0174Built 2016 · Hume James W N774RDCessna T210L · S/N 21060229Built 1974 · Demuth Roger C Trustee N829RWWessel Robin Y RV-6A · S/N 25377Caylor Michael C N87CBPilatus PC-12/45 · S/N 681Built 2005 · Clayton Boyd Agricultural Equipment LLC

Back to Valley View, TX