Sterling City, TX
Registered aircraft · 25
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 = 'STERLING 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 = 'STERLING 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.
N100EERobinson Helicopter R44 II · S/N 11028N1097APiper PA-18 · S/N 18-685N11ZAMaule MX-7-235 · S/N 10005CN151GFSchweizer 269C · S/N S1929N1728LCessna T206H · S/N T20608776N196JGRobinson Helicopter R22 BETA · S/N 2909N222GHRobinson Helicopter R22 BETA · S/N 0714N224VRRobinson Helicopter R22 BETA · S/N 3038N244RARobinson Helicopter R44 II · S/N 10662N429AFRobinson Helicopter R44 II · S/N 11547N4386WRobinson Helicopter R44 II · S/N 12847N442JERobinson Helicopter R44 II · S/N 10250N449ASRobinson Helicopter R44 II · S/N 10108N512ATCessna 210L · S/N 21060721N550RWCessna A185E · S/N 18502015N554GLRobinson Helicopter R22 BETA · S/N 3399N61709Cessna 172M · S/N 17264748N644AKRobinson Helicopter R44 II · S/N 10364N7007XRobinson Helicopter R22 BETA · S/N 2785N77MYRobinson Helicopter R66 · S/N 0481N802AHAir Tractor AT-802A · S/N 802A-1014N802JHAir Tractor AT-802A · S/N 802A-0436N866JSRobinson Helicopter R44 II · S/N 14406N945URobinson Helicopter R44 II · S/N 10763N955SKRobinson Helicopter R22 BETA · S/N 3969
Back to Sterling City, TX