Conroe, TX
Registered aircraft · 161
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 = 'CONROE' 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 = 'CONROE' 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.
N1024TBeech V35B · S/N D-9941N104DSAutogyro Certification CAVALON · S/N RSUK/V00673N108SGPiper PA-24-250 · S/N 24-149N10LKRobinson Helicopter R66 · S/N 1193N1144APiper PA-18A · S/N 18-737N119RVMark J Coplon VANS RV-9A · S/N 90780N123NADiamond Aircraft Ind DA 40 · S/N 40.484N1256DCessna 170A · S/N 19810N128BCNorth American T-28A · S/N 436N144AFRobinson Helicopter R44 · S/N 1787N1471TPiper PA-28-140 · S/N 28-7225528N152RFTextron T206H · S/N T20609611N159KMTextron T206H · S/N T20609606N15PTThyssen Patrick RV10 · S/N 40257N163MDGulfstream Aerospace G-IV · S/N 1302N171LEAeryon Labs SKY RANGER · S/N SR7017979N172HPCessna 172R · S/N 17280274N175WBPiper PA46-500TP · S/N 4697181N18258Beech 77 · S/N WA-299N182JKCessna 182P · S/N 18263595N18529Cessna 177B · S/N 17702542N185MNCessna A185F · S/N 18503803N186GMckelvey George R RV6A · S/N 60495N197MBMatthias P Bell RISEN SV 916IS · S/N 58N199GSRosado J A/Wallis D J GLASTAR GS-1 · S/N 5025N20008Cessna 177B · S/N 17702621N201RMooney M20J · S/N 24-0203N2343DCessna 170B · S/N 20495N241ARCessna 320F · S/N 320F-0012N251WCAmerican Champion 8GCBC · S/N 424-2000N2561FChampion 7ECA · S/N 191N2618EAeronca 7AC · S/N 7AC-6200N26454Grumman American Avn. AA-5A · S/N AA5A0598N2807UCessna 172D · S/N 17250407N28507Grumman American Avn. AA-5B · S/N AA5B0646N2860XS C Aerostar S A YAK-52TW · S/N 0112227N28651Grumman American Avn. AA-5B · S/N AA5B0724N2919FCessna 182J · S/N 18257019N291MWTextron T206H · S/N T20609601N292MBonsteel Wayne RV-4 · S/N WB001N2937JCessna 150G · S/N 15065737N2944VPiper PA-28-236 · S/N 28-7911258N297CMTextron T206H · S/N T20609602N3051XPiper PA-34-200T · S/N 34-7970190N3089GJohnson Jeffrey A KR 1.5 · S/N 01N30UTChristopher W Hare JA-30 SUPERSTOL · S/N JA 340-01-14N332ZBeech M35 · S/N D-6504N333HSCessna 510 · S/N 510-0370N3476WPiper PA-32-260 · S/N 32-352N3558XPiper PA-31-350 · S/N 31-8052073
Back to Conroe, TX