Caddo Mills, TX
Registered aircraft · 34
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 = 'CADDO MILLS' 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 = 'CADDO MILLS' 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.
N149SEPowrachute PEGASUS 912ULS · S/N A 052 ULSN172PMCessna 172H · S/N 17256117N214DYYarbrough Donald D VANS RV-8 · S/N 81448N221WAPiper PA-28-140 · S/N 28-26840N22308Cessna 150H · S/N 15068208N2415LCessna 172H · S/N 17255615N25117Cessna 172L · S/N 17259514N2699LCessna 172H · S/N 17255899N4017PPiper PA-23-160 · S/N 23-1492N4043FCessna 172 · S/N 36943N4096DCessna 182A · S/N 34796N42662Cessna 182L · S/N 18259128N4449YBeech A36 · S/N E-657N44ECCessna T210N · S/N 21063972N462XPFairchild M-62A · S/N T41-730N4781JBeech A23-19 · S/N MB-231N5154MBeech C23 · S/N M-2037N532VSSetzler Von Dietrich AIR COMMND 532 COMDR · S/N 7001N5344CCessna 170 · S/N 18529N5415SPiper PA-28-140 · S/N 28-7125113N5666BCessna 182 · S/N 33666N5771WPiper PA-28-150 · S/N 28-1579N5904BCessna 182A · S/N 33904N6180YPiper PA-23-250 · S/N 27-3406N6214ACessna 182 · S/N 33014N641RVLogansport Rv-6 BG RV-6 · S/N 20894N6554FCessna 150F · S/N 15063154N6912GCessna 150L · S/N 15072412N785DKBeech C23 · S/N M-2250N8202FCessna 150F · S/N 15064302N8558MBeech P35 · S/N D-7216N9098XCessna 182D · S/N 18253498N9724RBeech M35 · S/N D-6196N9818WPiper PA-28-140 · S/N 28-23320
Back to Caddo Mills, TX