OpenAirDocs.org
Hallettsville, TX

Registered aircraft · 26

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

N155YWaco UBF · S/N 3618Built 1932 · Texas Barnstorming MuseumN16832Bell 206B · S/N 2243Built 1977 · Orgis B JN1732Timothy Mathew Barrow ROSE PARRAKEET A4C · S/N SBB032Built 2013 · Texas Barnstorming MuseumN17VVSwearingen SA227-TT · S/N TT536Built 1985 · Pro Field Services IncN2113Waco GXE · S/N 868Baker James LN265DADJI AGRAS T50 · S/N 1581F6BUB246E001EE1GThreadgill Quinton MN2867YCessna 182E · S/N 18253867Built 1962 · Cook Kevin MN288HFleet 2 · S/N 121Built 1929 · Texas Barnstorming MuseumN29954Waco UPF-7 · S/N 5451Texas Barnstorming MuseumN412XKDJI AGRAS T50 · S/N 1581F6BUB246LCO01P67RRother Kaitlyn JillN4337Waco GXE · S/N 1236Texas Barnstorming MuseumN505RLBell Helicopter Textron 206L-1 · S/N 45176Built 1978 · Orgis BjN6051Boeing A75N1(PT17) · S/N 75-3533Built 1942 · Texas Barnstorming MuseumN61009Cessna 150J · S/N 15070730Built 1969 · Jansky Michael JN656JGCessna 560 · S/N 560-0298Built 1995 · 425sr LLCN681HCurtiss Wright TRAVEL AIR B-4000 · S/N 1177Built 1929 · Baker James LN709EWaco ASO · S/N A101Baker James LN7145HPiper J3C-65 · S/N 20401Texas Barnstorming MuseumN795GRDJI AGRAS T25 · S/N 1581F6BUB23CG001XYY3Kusak Kendall WN796GRXag P150 · S/N 186324P18223449C7Y75Mk Janak LLC - Ranch Operations SeriesN81ALBell Helicopter Textron 206B · S/N 2782Built 1979 · Orgis B JN831RLBell 206B · S/N 2728Built 1979 · Orgis B JN88379Piper J3C-65 · S/N 15997Texas Barnstorming MuseumN897ALPiper PA-28R-200 · S/N 28R-7335331Built 1973 · Jansky Sand & Gravel IncN92361Piper J3C-65 · S/N 16820Built 1946 · Texas Barnstorming MuseumN975JLXag P100 PRO · S/N 1863FPEG82194185W2D0Lowery Flying Services LLC
Back to Hallettsville, TX