Austin, TX
Registered aircraft · 789
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 = 'AUSTIN' 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 = 'AUSTIN' 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.
N1TXEmbraer Executive EMB-500 · S/N 50000407N2011PDeeter Michel L VELOCITY STD-RG · S/N SRE044N202JHAero Commander 500 S · S/N 3145N202MLLampkins Michael SKYRAIDER II · S/N SR11015N2035PBeech V35B · S/N D-10176N203APPiper PA46-500TP · S/N 4697444N2050LBeech C23 · S/N M-1859N206HJCessna T206H · S/N T20608713N206KCessna U206D · S/N U206-1333N20747Textron 172S · S/N 172S12578N207JRReinschmidt John S VP-2 · S/N V2-2075N2083UCameron Balloons US A-105 · S/N 5445N208STSkyways Air Transportation V3 · S/N 32-10N210GGCessna 210F · S/N 21058790N211STSkyways Air Transportation V3 · S/N 32-8N2121PLearjet 45 · S/N 507N213MCBeech 300 · S/N FA-216N215TXCessna 208 · S/N 20800542N21821Piper J3C-65 · S/N 2617N218CMEiriavion PIK 20D · S/N 20601N219TXPilatus PC-12/47E · S/N 1575N219YYCanadair CL-600-2B16 · S/N 5055N22020Luscombe 8A · S/N 870N2209VPiper PA-28-181 · S/N 28-7990343N221PLCirrus Design SR22T · S/N 9609N222WDJohn Caldwell III CCX-2000 · S/N CCX-2000-0203N223FMBell Textron Canada 407 · S/N 56477N2244GCirrus Design SR22T · S/N 1222N224BBPiper PA-28-140 · S/N 28-25659N224PFCirrus Design SR22 · S/N 1917N225HRHughes Helicopters HUGHES 369D · S/N 890559DN225HYHylio HYL-150 · S/N 17906110532Registration pendingN225LCessna 310J · S/N 310J-0025N225SCTextron 525B · S/N 525B0611N2279Waco EGC-8 · S/N 5064N2279FSoucy ACRO-CUBY · S/N GC-1N227TXAirbus Helicopters AS350B3 · S/N 9786N227VCCessna 560XL · S/N 560-6150N228SBrooks Jack C EARTHSTAR ODYSSEY · S/N JB001N228WHCessna 750 · S/N 750-0233N2299Autel Robotics EVO II PRO · S/N H6R920422495N229AFApollo North America JET STAR AS-II · S/N USA 220207N2308WBeech A23A · S/N M-910N230JKCessna 560 · S/N 560-0647N231AZMooney M20K · S/N 25-0120N231DFMooney M20K · S/N 25-0151N231WBMooney M20K · S/N 25-0360N236BBCirrus Design SR22T · S/N 9366N2373UCessna 172D · S/N 17249973N2374FAirbus Helicopters AS350B3 · S/N 8817
Back to Austin, TX