OpenAirDocs.org
Post, TX

Registered aircraft · 18

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N21MRBell 206B · S/N 2370Built 1978 · Macy Robert SN2222LBell Helicopter Textron Canada 407 · S/N 53306Built 1998 · Lott Jeff SN28BMPiper PA-34-200 · S/N 34-7350149Built 1973 · US Flight Academy Intl Inc DBAN3674DCessna 310 · S/N 35374Built 1956 · US Flight Academy International Inc DBAN4279JPiper PA-28-140 · S/N 28-22639Built 1967 · US Flight Academy International Inc DBAN4281UCessna 150 · S/N 15060281Built 1963 · US Flight Academy Intl IncN49230Cessna 152 · S/N 15281205Built 1977 · US Flight Academy International Inc DBAN4951HCessna 152 · S/N 15284044Built 1979 · US Flight Academy International Inc DBAN61231Cessna 150J · S/N 15070904Built 1969 · US Flight Academy International Inc DBAN7005FCessna 150F · S/N 15063605Built 1966 · US Flight Academy International Inc DBAN7134CPiper PA-28-140 · S/N 28-7625070US Flight Academy International IncN7175FCessna 150F · S/N 15063775Built 1966 · US Flight Academy International Inc DBAN72KFCessna 182T · S/N 18281361Built 2004 · Kirkpatrick John DrewN74337Bellanca 14-13-2 · S/N 1450Built 1947 · US Flight Academy International Inc DBAN7581KPiper PA-18-105 SPECIAL · S/N 18-298Built 1950 · U Lazy S RanchN77RTBeech 58P · S/N TJ-135Built 1978 · Bouchier Thomas BN8794SCessna 150F · S/N 15062094Built 1965 · US Flight Academy International Inc DBAN93570Bellanca 17-31A · S/N 73-32-116Built 1973 · Huffaker Kenneth Scott
Back to Post, TX