Addison, TX
Registered aircraft · 232
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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.
N100CUDassault-Breguet FALCON 10 · S/N 104N1031PCessna 208B · S/N 208B0404N1037NCessna 208B · S/N 208B0334N1041LCessna 208B · S/N 208B0337N107KACessna 208B · S/N 208B1107N108TCCessna 172S · S/N 172S8801N109GUHispano-Aviacion S A La HA-1112M-1-L · S/N 235N10XTCessna 750 · S/N 750-0230N1119VCessna 208B · S/N 208B0383N1120WCessna 208B · S/N 208B0388N1121MMikoyan Gurevich MIG 21 · S/N 4685145N1126DCessna 140A · S/N 15675N115PWMikoyan Gurevich SB LIM-2 · S/N 512036N116BDRaytheon A36 · S/N E-3454N1194ABeech 36 · S/N E-159N1200BLuscombe 8A · S/N 5827N1207Boeing A75 · S/N 75207N12155Cessna 208B · S/N 208B0562N121BCBeech A45 · S/N G-123N121KSCessna 180J · S/N 18052683N121MGMikoyan Gurevich MIG 21 · S/N 433372128N1254DCessna 172S · S/N 172S10127N1258Osborne James L OSBORNE FOKKER D-VII · S/N 1N1258BCessna 208B · S/N 208B1258N131PAPiper PA-28-181 · S/N 28020055N1369QCessna 172S · S/N 172S9946N138LGMarvin L Gardner II F1 ROCKET · S/N 152N1400HCessna 172S · S/N 172S10410N140SBeech 58 · S/N TH-1155N145WACessna 208B · S/N 208B1145N185VMCessna A185F · S/N 18504422N187EAEclipse EA500 · S/N 000187N187SRCirrus Design SR22 · S/N 1950N18840Dehavilland TIGER MOTH DH-82C · S/N 1317N18PGrumman FM-2 · S/N 6014N190LPCessna 172S · S/N 172S9190N1961UCessna TU206F · S/N U20602312N1983XCessna 208B · S/N 208B1013N199XPCessna 750 · S/N 750-0019N2026WBeech 58 · S/N TH-976N2064VBeech 58 · S/N TH-1004N208EECessna 208B · S/N 208B1213N208TFCessna 208B · S/N 208B0592N21022Cessna 172S · S/N 172S9660N215JCCavanaugh James A JR PITTS S-1S · S/N 21546N220XWCessna 208B · S/N 208B0822N228TSNorth American NA-200 · S/N 200-422N230SATextron 172S · S/N 172S13435N236CHBeech A36 · S/N E-502N245TFPiper PA-44-180 · S/N 4496595
Back to Addison, TX