Registered aircraft · 18

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

N178MPiper PA-23-250 · S/N 27-7954028Built 1979 · South Texas Weather Modification Association N2206RCessna T210H · S/N T210-0356Built 1968 · Kahonees Travel Services LLC N247WHHenderson Woodrow C RV-7 · S/N 73917Built 2014 · Henderson Woodrow C N412DBeech 58 · S/N TH-464Built 1974 · Pickens Ray T N4162FCessna 172 · S/N 46062Built 1958 · Powell Clinton J N4271JPiper PA-28-140 · S/N 28-22630Double P Creative LLC N443RCessna 414 · S/N 414-0361Salinas Construction Technologies Ltd N57AAPiper PA-24-250 · S/N 24-3303Built 1962 · South Texas Weather Modification Association N5984GCessna 150K · S/N 15071484Clifton Raymond L N6408DPiper L-21A · S/N 18-908Ruple Farms Inc N6579FCessna 150F · S/N 15063179Built 1966 · Pratka Rhett A N65WPCessna R172K · S/N R1722232Built 1977 · Warnken James V N7309PPiper PA-24-250 · S/N 24-2484Evergreen Underground Water Conservation District N77391Cessna 140 · S/N 11832Sawyer Andrew N8160PPiper PA-24-250 · S/N 24-3415Built 1963 · South Texas Weather Modification Association N8625SCessna 150F · S/N 15061925Mendoza Erik N8847PPiper PA-24-260 · S/N 24-4302Built 1965 · South Texas Weather Modification Association N9744YBeech P35 · S/N D-7141Built 1963 · Double P Creative LLC

Back to Pleasanton, TX