Registered aircraft · 17

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 = 'OAK POINT' 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 = 'OAK POINT'
  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 = 'OAK POINT'
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.

N105MJBilly Billy Balloons BB-SS1 · S/N B5-65-001Built 2024 · Auras Adventures LLC N1255ZBeech N35 · S/N D-6717Built 1961 · Keepem Flying LLC N1267GCessna 310Q · S/N 310Q1118Built 1974 · Chesnut James Scott N12776Cessna 172M · S/N 17262249Built 1973 · Oviedo Juan N1311NCameron Balloons Z-90 · S/N 6407Built 2005 · Auras Adventures LLC N137CTFlight Design CTSW · S/N 06-11-06Built 2006 · Patterson David B N161RBBurt SPECIAL MODEL A · S/N RB2Built 1961 · Jones Anthony M N167LBLindstrand Balloons 90A · S/N 5142Built 2000 · Moreno Zachary G N4510LCameron Balloons US Z-105 · S/N 6321Built 2002 · Auras Adventures LLC N45WBCessna 180C · S/N 50748Built 1960 · Dfw Aero Mechanix Inc N464SACessna 140 · S/N 8973Built 1946 · Noyes Daniel W N4686KCessna 182P · S/N 18263687Built 1975 · Mcdonald Robert M N50GBCessna 340 · S/N 340-0163Built 1975 · Oviedo Juan M III N5327WPiper PA-28 · S/N 28-384Built 1962 · Noyes Daniel W N710TDCessna T210L · S/N 21061424Built 1976 · Duke Ray J N7273ACessna 172 · S/N 29373Built 1956 · Martin Randal O N73LLCessna T210M · S/N 21062163Built 1977 · T3 Aviation LLC

Back to Oak Point, TX