Registered aircraft · 16

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

N12045Dean Allen Franklin VANS ACFT INC RV-6A · S/N 21256Built 2019 · Robinson Claudius E N132RKKaweck Ralph D KAWECK MUSTANG II · S/N 132Cross Craig N13307Cessna 177B · S/N 17702410Built 1976 · Burden Richard M Trustee N18934Beech C24R · S/N MC-530Built 1977 · Gray Van D N1913TPiper PA-28-140 · S/N 28-7125474Built 1971 · Williams Ronald P N2083LBeech V35B · S/N D-9904Horizon Chaser LLC N20HKCessna 414A · S/N 414A0088Gill John H N2671LCessna 172H · S/N 17255871Built 1967 · Nbl Aviation LLC N269SHCessna T182T · S/N T18208729Built 2007 · Dan Julian LLC N28769Grumman American Avn. AA-5B · S/N AA5B0800Built 1978 · Cook Jeff E N3498WPiper PA-32-260 · S/N 32-378Built 1966 · Kanz Robin Lea N3631UCessna 182F · S/N 18255031Built 1963 · Burden Richard M N715BFPiper PA-28-180 · S/N 28-4084Built 1967 · Plante Dennis M N727NSCessna 182T · S/N 18281809Built 2006 · Barrett Kemberly N735DLCessna 182Q · S/N 18265341Built 1977 · George Robert C N96781Taylorcraft BC12-D · S/N 9081Built 1946 · Samarija Gary A

Back to Woodway, TX