Oneill, NE
Registered aircraft · 24
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 = 'NE' AND g.registrant_city = 'ONEILL' 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 = 'NE' AND g.registrant_city = 'ONEILL' 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.
N152NSCessna 152 · S/N 15279673N16686Piper-Smith PA-11 · S/N 11-JRS-3N174RRRudnick Ronald A RV-7 · S/N 70754N175NSCessna 175B · S/N 17556945N210NSCessna 210A · S/N 21057595N2543ZBellanca 8KCAB · S/N 345-77N283YSmith A J SK-2 · S/N 002N2863PPiper PA-28-181 · S/N 28-7990504N289ASEa Vision EA J100 · S/N EAVUAV502585875N322HBeech D17S · S/N 3184N33462Piper PA-28-180 · S/N 28-7505149N4216KAir Tractor AT-402A · S/N 402A-1219N50707Piper J3C-65 · S/N 10181N53519Cessna 337G · S/N 33701677N5495QCessna 152 · S/N 15285113N550RBeech 95-A55 · S/N TC-391N5995VSmith A J WS-10 · S/N AJS-1N66636Cessna 150M · S/N 15076171N734GUCessna 172N · S/N 17268850N8097MCessna 310I · S/N 310I0097N81FPiper J3C-65 · S/N 18611N883ASEa Vision EA J100 · S/N EAVUAV502585753N9779WPiper PA-28-140 · S/N 28-23267N995KTPiper PA 46-350P · S/N 4636640
Back to Oneill, NE