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.
N719MTVickers SPITFIRE VIII · S/N MT719N72211Beech A36 · S/N E-2218N722HGCessna 172R · S/N 17280402N724RCCavanaugh James A CHRISTEN EAGLE · S/N 002N750ZCessna 208B · S/N 208B1054N753PSCirrus Design SR22T · S/N 0309N75ATBeech A36 · S/N E-597N7687CNorth American TB-25N · S/N 10832200N7705CDouglas B-26 · S/N 44-35710N777GACanadair CL-600 CHALLENGER · S/N 1056N77CWEurocopter EC120B · S/N 1087N78SACessna 208B · S/N 208B0467N802AACessna 208B · S/N 208B0873N803FCessna 208B · S/N 208B-1112N80744Globe GC-1B · S/N 147N807TFPiper PA-28-181 · S/N 2881700N812SBBell UH-1H · S/N 64-13553N8195JBeech A36 · S/N E-2789N81KCCessna T210N · S/N 21064386N820AFTextron 172S · S/N 172S13530N825MACessna 208B · S/N 208B5065N828JCNorth American T-28B · S/N 140012N829AFTextron 172S · S/N 172S13533N82JKLearjet 45 · S/N 2072N831AFTextron 172S · S/N 172S13531N847MACessna 208B · S/N 208B5075First renewal noticeN854AFTextron 172S · S/N 172S13536N854DPYakovlev YAK-3M · S/N 0470101N86280Grumman TBM-3E · S/N 86280N863MACessna 208B · S/N 208B1049N86493Lockheed PV-2 · S/N 15-1604N864SPCessna 172S · S/N 172S8123First renewal noticeN86678Day-Sopwith F.1 CAMEL · S/N DS-100N880AFTextron 172S · S/N 172S13537N881SACessna 208B · S/N 208B-5178N882MTBeech 58 · S/N TH1343N882MZTextron 525 · S/N 525-0882N888BPCessna 340A · S/N 340A0737N888TXCessna 750 · S/N 750-0174N888WBPiper AEROSTAR 601P · S/N 61P06107963274N893AFTextron 172S · S/N 172S13539N895AFTextron 172S · S/N 172S13540N896AFTextron 172S · S/N 172S13542N897AFTextron 172S · S/N 172S13543N900RDassault FALCON 900B · S/N 171N9022HCessna 182T · S/N 18282254N906HFBeech 65-A90-1 · S/N LM-140N906JRCessna 172S · S/N 172S10231N9073CPiper J3C-65 · S/N 13976N908KBeech C90 · S/N LJ-504
Back to Addison, TX