Jasper, TX
Registered aircraft · 25
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 = 'JASPER' 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 = 'JASPER' 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.
N178SCSix Chuter West LEGEND XL · S/N 3147N196RCessna 310 · S/N 35049N2223GCessna 182A · S/N 51523N2602CCessna 310 · S/N 35002N273MPJeff Ackland P85 · S/N 1N316JGBeech A36 · S/N E-2038N397ABBarber Robert L MINI-180 · S/N 1N430FDDantonio David MONARCH · S/N 69N5346BCessna 182 · S/N 33346Sale reportedN5586TCessna 172E · S/N 17251486N5859MCessna 340 · S/N 340-0057N59JBBeech A36 · S/N E-2045N59MRCessna 310C · S/N 35929N6723WPiper PA-28-140 · S/N 28-20837N704SECessna 150M · S/N 15078831N7108ECessna 182B · S/N 52108N735FNCessna 182Q · S/N 18265390N774GCPowrachute AIRWOLF · S/N A086ULSN7857ECessna 150 · S/N 17657N8070BCessna 172 · S/N 29870N8225HCessna 182N · S/N 18260681N9379BCessna 175 · S/N 55179N941SLCirrus Design SR22 · S/N 3895N9925TBeech 95-C55 · S/N TE-224N9ECAustin Steve LONGEZ · S/N 2033L
Back to Jasper, TX