Madisonville, TX
Registered aircraft · 22
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 = 'MADISONVILLE' 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 = 'MADISONVILLE' 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.
N12641Cessna 172M · S/N 17262136N12976Cessna 172M · S/N 17262421N1710VCessna 140 · S/N 13895N175SEBoeing B75N1 · S/N 75-7287N2014ECessna 172N · S/N 17271118N2080JCessna T188C · S/N T18803370TN218RPadgett Robert W VANS RV-6 · S/N 24943N230NSDJI AGRAS T40 · S/N 5X5BLGR0020ER1N2868ZBellanca 7ECA · S/N 1237-78N301YSDJI T40 · S/N 64TBL8F00200D0N344DCDJI AGRAS T40 · S/N 64TBL7N00200AAN4160EAeronca 7AC · S/N 7AC-7135N5042DBellanca 7GCAA · S/N 378-79N5299TDJI AGRAS T50 · S/N 1581F6BUB24B4001PLE1N581WAXag P150 · S/N 186324P182234430KQ87N6001JCessna A150L · S/N A1500301N651YTDJI AGRAS T50 · S/N 1581F6BUB24B200193KQN733ZACessna 172N · S/N 17268668N749DCDJI AGRAS T40 · S/N 64TBL7K0020053N8696MBeech P35 · S/N D-7282Sale reportedN925PCCirrus Design SR22 · S/N 1633N9800EAeronca 11AC · S/N 11AC1450
Back to Madisonville, TX