Dallas, TX
Registered aircraft · 1,858
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 = '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.
N1002SMaule MX-7-180A · S/N 20056CN100DPBellanca 8KCAB · S/N 130-74N100VBeech C90 · S/N LJ-796N101BSBeech B90 · S/N LJ-375N101RFNorth American SNJ-5 · S/N 90649N101XNorth American SNJ-5 · S/N 88-9450N103JCFairchild M-62A-3 · S/N FC-119N103LTNorth American SNJ-4 · S/N 88-12097N10601North American/Aero Classics P-51D · S/N 44-73843N106JTCessna 525B · S/N 525B0106N1078ZS & S Special Grumman 5 F6F - 5 · S/N 27354801-66N1079PMooney M20J · S/N 24-3163N1088MMooney M20M · S/N 27-0020N108TLCessna T182T · S/N T18208217N109JCCessna 550 · S/N 550-0099N109LWLearjet 45 · S/N 071N10FLCessna T210M · S/N 21062892N10TRCessna 525B · S/N 525B0354N1101ACanadair CL-600-2B16 · S/N 5354N1107MBombardier BD-100-1A10 · S/N 20039N11171North American AT-6B · S/N 84-7800N111PVBeech 200 · S/N BB-772N1125TPiper PA-28R-200 · S/N 28R-7635448N112CWCessna 560XL · S/N 560-5065N113BTConsolidated Vultee BT-13A · S/N 1624N113FACessna 152 · S/N 15285090Sale reported, canceledN11535Embraer EMB-145LR · S/N 145518N11539Embraer EMB-145LR · S/N 145536N1156VStinson L-5 · S/N 60507N1159DMooney M20K · S/N 25-0652N115BGBoyd Geoffrey M STOL 750 · S/N 001N12038Hasenbalg Russel TAILWIND W-10 · S/N 982N1206APiper PA-30 · S/N 301206N12166Embraer EMB-145XR · S/N 14500831N1221JBombardier BD-100-1A10 · S/N 20364N12253Beech A45 · S/N G-705N1226NCurtiss Wright P-40N · S/N 29629N122DLCzech Sport Aircraft A S SPORTCRUISER · S/N C0567N124JPAero Commander 560-A · S/N 312N12540Embraer EMB-145LR · S/N 145537N125AZNorth American TB-25N · S/N 43-35972AN125YPiper PA-23-250 · S/N 27-2366N1297JRockwell International 112A · S/N 297N12BACessna 750 · S/N 7500222N12MPPiper PA-30 · S/N 30-284N13123Embraer EMB-145XR · S/N 145688N131AKConstrucciones Aeronauticas C.A.S.A. 1.131E · S/N E3B-216N131RHAmerican Champion 7EC · S/N 1009-2007N131SJBeech 200 · S/N BB-131N1320JRockwell International 112A · S/N 320
Back to Dallas, TX