Addison, TX
Registered aircraft · 231
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 = 'ADDISON' 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 = 'ADDISON' 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.
N5309GCessna 305A · S/N 21656N5342YCessna 172S · S/N 172S9361N5421SCessna 172S · S/N 172S8080N549PNCessna 208B · S/N 208B5049N5522SCessna 172S · S/N 172S11430N5548NNorth American B-25H · S/N 43-4106N577WBeech 58 · S/N TH-375N58NDRaytheon 58 · S/N TH-1906N5998VPiper PA-28-140 · S/N 28-7725264N5VNCessna O-2A · S/N 67-21334N6011FPiper PA-28-181 · S/N 28020090N6015FPiper PA-28-181 · S/N 28020091N6018FPiper PA-28-181 · S/N 28020092N6030FPiper PA-28-181 · S/N 28020093N6031FPiper PA-28-181 · S/N 28020094N6035FPiper PA-28-181 · S/N 28020095N6036NCessna T210M · S/N 21062904N6050FPiper PA-28-181 · S/N 28020097N6053FPiper PA-28-181 · S/N 28020149N6058FPiper PA-28-181 · S/N 28020150N6069FPiper PA-28-181 · S/N 28020151N6077EPiper PA-28-181 · S/N 2881548N6078FPiper PA-28-181 · S/N 28020152N6085FPiper PA-28-181 · S/N 28020153N6089FPiper PA-28-181 · S/N 28020154N6090FPiper PA-28-181 · S/N 28020155N6091FPiper PA-28-181 · S/N 28020156N6097FPiper PA-28-181 · S/N 28020157N6098FPiper PA-28-181 · S/N 28020158N612EHPiper PA-23-250 · S/N 277654161N61483Consolidated Vultee SNV-2 · S/N 79-1420N62610Whyte Howard A NIEUPORT 28 · S/N 6261N634SJCessna 172S · S/N 172S8634N6381LAmerican AA-1A · S/N AA1A-0381Sale reportedN643SACirrus Design SR20 · S/N 10461N644SACirrus Design SR20 · S/N 10466N650RACessna 650 · S/N 650-7047N65164Douglas EA-1E · S/N 55-471DHN6573KBeech 58 · S/N TH-1369N65956Cessna 172S · S/N 172S9829N66328Lockheed F-104A · S/N 56-786N6680PPiper PA-24-250 · S/N 24-1783N66919Beech A36 · S/N E-1634N6735ZBeech A36 · S/N E-1605N679TFPiper PA-28-181 · S/N 2881879N680TFPiper PA-28-181 · S/N 2881880N681TFPiper PA-28-181 · S/N 2881881N682TFPiper PA-28-181 · S/N 2881882N7086YRobinson Helicopter R44 II · S/N 13556N712SPCessna 172S · S/N 172S8640
Back to Addison, TX