Archer City, TX
Registered aircraft · 17
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 = 'ARCHER CITY' 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 = 'ARCHER CITY' 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.
N1101NHughes Helicopters HUGHES 369D · S/N 510960DN1300VICP VENTURA 2 · S/N 16-03-62-0002RN202DNValter E Della Nebbia TUCANO REPLICA · S/N TR1604N2140HSchweizer 269C · S/N S1919N22570Cessna 150H · S/N 15068369N26841Piper J3L-65 · S/N 4210N272STTino Schleicher TUCANO REPLICA · S/N TR1604KN28798Luscombe 8A · S/N 1559N33136Piper J-3 · S/N 5854N3421VCessna 150M · S/N 15076498N386BBeech 95 · S/N TD-4N404DNValter Della Nebbia TUCANO R · S/N TR 2108N405DNValter Della Nebbia TUCANO R · S/N TR 2105N549REButner V L/Butner M D ZENITH ZODC CH601XL · S/N 64640N552QUFlying Legend Italia TUCANO LSA · S/N 1403N8089FCessna 150F · S/N 15064189N8200DBeech H35 · S/N D-5293
Back to Archer City, TX