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.
N243PWTextron 208B · S/N 208B5855N243TXPilatus PC-12/47E · S/N 1328N2442KLuscombe 8E · S/N 5169N247HBClement J / Kazmierczak A SORRELL SNS-7 · S/N 247N248SPCirrus Design SR22T · S/N 10519N24AFCessna 172R · S/N 17280439N24EGCirrus Design SR22 · S/N 4877N24YYCarl G Stattin RV-14A · S/N 140235N250RLNanchang China CJ-6A · S/N 2432066N2522FLancair LC41-550FG · S/N 41049N254FJDassault FALCON 2000 · S/N 054N257CHHughes Harry M RV-9A · S/N 91548N25JJAgusta A109S · S/N 22043N26098Grumman American Avn. AA-5A · S/N AA5A0423N260MGEdwin L French VANS RV 10 · S/N 40297N262GBGame Composites GB1 GAMEBIRD · S/N 0026N2655QCessna 182K · S/N 18257855N269TSCirrus Design SR20 · S/N 8847N26CForney F-1 · S/N 5661N2702VCessna 340A · S/N 340A0904N270PWAirbus Helicopters AS350B3 · S/N 9374N2722KLuscombe 8E · S/N 5449N2749NAir Creation TANARG · S/N T05075N276WYAviat A-1C-180 · S/N 3276N2795UCessna 172D · S/N 17250395N27AZNicholas H Zimmerman BEARHAWK · S/N 1217N27TYMiller Ernie RV-7 · S/N 70965N2822SPiper PA-28-181 · S/N 28-7990470N28298Grumman American Avn. AA-5B · S/N AA5B0536N282HGPiper PA-28-161 · S/N 2842007N28345Grumman American Avn. AA-5B · S/N AA5B0575N2840UCessna 172D · S/N 17250440N2841MPiper PA-28-181 · S/N 28-7890273N284HGPiper PA-28-161 · S/N 2842009N284ZMDJI AGRAS T20P · S/N 1581F574B224K00100JJN291ABurns Stephen A TRIKE · S/N 0020N292WPiper PA-28-181 · S/N 28010001N292WYAviat A-1C-180 · S/N 3292N2973ZBellanca 7GCAA · S/N 359-78N2977GChampion 7ECA · S/N 293N297ABurns Stephen A TRIKE · S/N 0030N29801Cameron Balloons V-65 · S/N 5087First renewal noticeN29941North American AT-6D · S/N 52026N2MMMccluskey Michael D M3 · S/N M-3018N2RMCessna 500 · S/N 500-0153N3010XRobinson Helicopter R44 II · S/N 11685N3036TCameron Balloons N-105 · S/N 2868N304SHBeech 300 · S/N FA-89N3050GQuicksilver QUICKSILVER SPORT 2S · S/N 0080N30686Cessna 177B · S/N 17701405
Back to Austin, TX