Dallas, TX
Registered aircraft · 1,865
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 = 'DALLAS' 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 = 'DALLAS' 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.
N13596Cessna 177B · S/N 17702440N137AHAirbus Helicopters AS350B3 · S/N 9672N1387VBoeing E75 · S/N 75-8291N138WSPerry William L GLASTAR · S/N 2038N13975Embraer EMB-145LR · S/N 145163N13978Embraer EMB-145LR · S/N 145180N13979Embraer EMB-145LR · S/N 145181N13988Embraer EMB-145LR · S/N 145265N13989Embraer EMB-145LR · S/N 145271N13992Embraer EMB-145LR · S/N 145284N14105Embraer EMB-145XR · S/N 145649N1419NPiper J3C-65 · S/N 22947Registration revokedN141JRDouglas DC3C-S1C3G · S/N 19366N143BZEmpresa Brasileira De Aero S A ERJ 190-200 LR · S/N 19000276N14542Embraer EMB-145LR · S/N 145547N145AZBeech D18S · S/N A-235N146SRProgressive Aerodyne SEAREY LSA · S/N 1021N147AZDouglas DC3C · S/N 9380N147PHBellanca 17-30A · S/N 74-30679Sale reported, canceledN14904Embraer EMB-145LR · S/N 145477N14916Embraer EMB-145LR · S/N 145415N149TSStratton Billy G VANS RV-8 · S/N 81006N14BCPiper PA 46-350P · S/N 4636014N14FMBeech S35 · S/N D-7802N1510LBell 206B · S/N 4613N1511LBell 206B · S/N 4618N151RPitts Special S-1C · S/N WA-1N151ZEDouglas DC3 · S/N 50783N152BXRoberts Bradley E ONEX · S/N ONX0116N152EZGulfstream Aerospace G-V · S/N 673N152GEvolution REVO · S/N 000588N15483Piper PA-28-180 · S/N 28-7305082N155MFFolkers Milford C BAKENG DUCE · S/N 551N1577GBeech 35-C33 · S/N CD-1103N15797Canadian Car & Foundry HARVARD MK IV · S/N CCF4-199N15799Canadian Car & Foundry HARVARD MK IV · S/N CCF4-117N1584KColumbia Aircraft Mfg LC41-550FG · S/N 41779N15912Embraer EMB-145LR · S/N 145439N15983Embraer EMB-145LR · S/N 145239N15ERDiamond Aircraft Ind DA 62 · S/N 62.C083N15NGulfstream Aerospace GVII-G600 · S/N 73173N1617MBoeing B75 · S/N 75-8498N161TSRaytheon A36 · S/N E-3519N1631MBoeing E75 · S/N 75-8509N16441Piper PA-32-300 · S/N 32-7340087N164GBDassault-Breguet FALCON 50 · S/N 164N16541Embraer EMB-145LR · S/N 145542N1673TBeech A36 · S/N E-1895N16981Embraer EMB-145LR · S/N 145208N16987Embraer EMB-145LR · S/N 145261
Back to Dallas, TX