Registered aircraft · 19

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 = 'WIMBERLEY' 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 = 'WIMBERLEY'
  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 = 'WIMBERLEY'
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.

N214RBRobinson Helicopter R22 BETA · S/N 2114Built 1992 · S And S 1165 Investments LLC N285SWJ&J Ultralights SEAWING · S/N 10001234582Built 2002 · Tenny James N321RRBeech D55 · S/N TE-520Built 1968 · 321 Rr Lp N33321Piper PA-28-180 · S/N 28-7505133Built 1975 · Lauher Donna N3652QBeech A23-24 · S/N MA-239Built 1967 · Nolen David S N374SPCessna 172S · S/N 172S9503Built 2003 · Skiles Richard L N424CRRobinson Helicopter R44 II · S/N 13833S&S 1165 Investments N473CDCirrus Design SR22 · S/N 1564Built 2005 · Grupinski Stephen N4925QCessna 182T · S/N 18282326Built 2012 · Esty Effew LLC N514BKBeech A36 · S/N E-514Built 1974 · Not For Naught LLC N51RDSkystar SERIES 7 · S/N S70302022Built 2007 · Whitman Rodney A N533TPiper PA-32-260 · S/N 32721Built 1966 · Riser LLC N56285Piper PA-32-300 · S/N 32-7340168Built 1973 · Knots And Attitudes LLC N6210QCessna 152 · S/N 15285195Built 1981 · Not For Naught LLC N748DSSchmelzer David R SONEX · S/N 0867Built 2007 · Vogt Thomas Spears N750MFCessna 750 · S/N 750-0271Built 2007 · Austin Aviation Group LLC N7987LBeech A23-24 · S/N MA-148Built 1966 · Whitten Michael Neil N8304RPiper PA-28-140 · S/N 28-22171Built 1966 · Knots And Attitudes LLC N90394Globe GC-1B · S/N 389Built 1946 · Evans Douglas B

Back to Wimberley, TX