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.
N24935Piper J3C-65 · S/N 3536N259BKHughes 369A · S/N 301376N262MVBell 47G-2 · S/N 2232N284CPiper PA-28-181 · S/N 2881698N287Consolidated-Vultee 28-5ACF · S/N 48287N292CSTextron 182T · S/N 18283292N308SPCessna 172S · S/N 172S9487N31SACessna 208B · S/N 208B1210N327SPCessna 172S · S/N 172S8254N34DWCessna R182 · S/N R18201522N359BRDassault-Breguet FALCON 20 · S/N 359N361BCBeech 36 · S/N E1331N36673Beech 58 · S/N TH-1143N37AMGrumman S-2B · S/N 136431N38LGBoeing/Gardner PT-17 · S/N 3851N39403North American AT-6 · S/N 88-15838N3946KCessna L-19E · S/N 24716N39606Douglas SKYRAIDER AD-6 · S/N 139606N40PNCurtiss Wright P-40N · S/N 44-7369N4118KCessna 208B · S/N 208B1283N4125FCessna 172 · S/N 46025Sale reportedN415SPCessna 172S · S/N 172S8346N451FGGoodyear FG1D · S/N 92399N459SPCessna 172S · S/N 172S8325N46217Ryan Aeronautical ST3KR · S/N 1363N4625BCessna 208B · S/N 208B0159N4655BCessna 208B · S/N 208B0160N46648Cessna 152 · S/N 15283084N4687BCessna 208B · S/N 208B0167N4689HCanadair F-86E MK.6 · S/N 1083N474MJGulfstream Aerospace G-V · S/N 524N489TSStinson L-5G · S/N 4629N495SATextron 208B · S/N 208B5942N496SATextron 208B · S/N 208B5943N49USCessna 182S · S/N 18280886N504AFPiper PA-28-181 · S/N 28020004N504SACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 048/USN505AFPiper PA-28-181 · S/N 28020005N507AFPiper PA-28-181 · S/N 28020006N509AFPiper PA-28-181 · S/N 28020008N512AFPiper PA-28-181 · S/N 28020043N516AFPiper PA-28-181 · S/N 28020045N517AFPiper PA-28-181 · S/N 28020046N518URRichardson Andrew P RICHARDSON-75 · S/N 007N51JCNorth American/Aero Classics P-51D · S/N 44-72339N520AFPiper PA-28-181 · S/N 28020049N52424North American T-28B · S/N 137789N524PGCirrus Design SR20 · S/N 1986N524SHWsk-Pzl-Mielec TS-11 ISKRA · S/N 1H0524N525DFRaytheon B300 · S/N FL-306
Back to Addison, TX