Amarillo, TX
Registered aircraft · 337
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 = 'AMARILLO' 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 = 'AMARILLO' 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.
N100PXCirrus Design SR22 · S/N 0953N100SBCessna 525C · S/N 525C0061N102LYYoung Frederick Lawrence RV-9A · S/N 90130N111HHFrentzen Heinz-Harald LANCAIR IV-P · S/N HHF001N1132LLake LA-4 · S/N 294N1132UCessna T210N · S/N 21064669N119TSSutton Todd K PITTS S-1 · S/N TS001N122BKRaytheon B200 · S/N BB-1651N122DSRaytheon 390 · S/N RB-100N124CHeath L'Hoste LANCAIR EVOLUTION · S/N EVO-029N128NRJoseph J Newberry CAVALON · S/N V00263N1292XMooney M20E · S/N 165N131BLRaytheon C90A · S/N LJ-1654N133ECBeech F33A · S/N CE-1679N140JCessna 414A · S/N 414A0650N141RTTextron 525C · S/N 525C0299N1460TCessna T206H · S/N T20608767N14729Bellanca 17-30A · S/N 74-30707N14UHEurocopter Deutschland MBB-BK 117 C-2 · S/N 9365N1524UBalloon Works FIREFLY 7-B · S/N 10311N1548FBeech A36 · S/N E-2489N1555ERans S-6ELS · S/N 11131976-ESN160KQQuest KODIAK 100 · S/N 100-0160N161WPRobinson Helicopter R44 · S/N 1490N1637TCessna 414 · S/N 414-0417N171MDRaytheon Corporate Jets BAE 125-800A · S/N 258251N17256Cessna 150L · S/N 15073692N174SGAmerican Champion 7GCBC · S/N 1441-2007N17LPCessna S550 · S/N S550-0111N17SNCirrus Design SR22 · S/N 0115N182ACessna 182A · S/N 33849N185MKCessna 185A · S/N 1850455N1876WBeech F33A · S/N CE-443N190JFYakovlev YAK-11 · S/N 171521N195LCCessna 195B · S/N 16144N1995BCessna 182T · S/N 18281697N1BDBeech A45 · S/N G-91N200GWBeech 200 · S/N BB-568N2029SCessna 210L · S/N 21060997N202LYVans RV-12 · S/N 120920N206JSBell 206B · S/N 3632N20LCCessna 525C · S/N 525C0102N20YStites Robert P 360 · S/N 545320292FBN210JZCessna 210N · S/N 21063793N21338Cessna 182P · S/N 18261571N2148XPiper PA-28RT-201T · S/N 28R-7931129N21KRCessna P210N · S/N P21000285N21VXClunis Kenneth RUTAN LONG-EZ · S/N 345N222ERCessna 182P · S/N 18263978N2263WRobinson Helicopter R44 · S/N 1213
Back to Amarillo, TX