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.

N12641Cessna 172M · S/N 17262136Wanda Collins Professional Pilot Services LLCN12976Cessna 172M · S/N 17262421Built 1973 · Wanda Collins Professional Pilot Services LLCN1710VCessna 140 · S/N 13895Built 1947 · Wanda Collins Professional Pilot Services LLCN175SEBoeing B75N1 · S/N 75-7287Built 1943 · Wanda Collins Professional Pilot Services LLCN2014ECessna 172N · S/N 17271118Built 1978 · Wanda Collins Professional Pilot Services LLCN2080JCessna T188C · S/N T18803370TBuilt 1978 · Woelfel Tim AN218RPadgett Robert W VANS RV-6 · S/N 24943Padgett Steven WN230NSDJI AGRAS T40 · S/N 5X5BLGR0020ER1Standley Feed & Seed IncN2868ZBellanca 7ECA · S/N 1237-78Built 1978 · Wanda Collins Professional Pilot Services LLCN301YSDJI T40 · S/N 64TBL8F00200D0Standley Feed & Seed IncN344DCDJI AGRAS T40 · S/N 64TBL7N00200AAStandley Feed And Seed IncN4160EAeronca 7AC · S/N 7AC-7135Built 1947 · Wanda Collins Professional Pilot Services LLCN5042DBellanca 7GCAA · S/N 378-79Collins WandaN5299TDJI AGRAS T50 · S/N 1581F6BUB24B4001PLE1Tm Ag Service LLCN581WAXag P150 · S/N 186324P182234430KQ87Davis John CN6001JCessna A150L · S/N A1500301Built 1971 · Wanda Collins Professional Pilot Services LLCN651YTDJI AGRAS T50 · S/N 1581F6BUB24B200193KQTm Ag Service LLCN733ZACessna 172N · S/N 17268668Wanda Collins Professional Pilot Services LLCN749DCDJI AGRAS T40 · S/N 64TBL7K0020053Wj Ag Services LLCN8696MBeech P35 · S/N D-7282Sale reportedBuilt 1963N925PCCirrus Design SR22 · S/N 1633Built 2005 · Lee Investment Services LLCN9800EAeronca 11AC · S/N 11AC1450Word Of Truth Inc
Back to Madisonville, TX