Casselton, ND
Registered aircraft · 32
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 = 'ND' AND g.registrant_city = 'CASSELTON' 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 = 'ND' AND g.registrant_city = 'CASSELTON' 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.
N108FHFarrel Helm VANS RV-8 · S/N 81955N113PAPiper PA-14 · S/N 14-113N116PPitts Special S-1C · S/N M79470N127MMiller Robert J MILLER RV-8 · S/N 81608N14078Piper PA-23-250 · S/N 27-4679N156TPiper PA-18-105 SPECIAL · S/N 18-2270Sale reported, canceledN172GCessna 172N · S/N 17271959N1907EAeronca 7AC · S/N 7AC-5474N2039CNorth American HARVARD II A · S/N 88-12048N2087VCessna 140 · S/N 14317N211FHPiper PA-11 · S/N 19044N240MRDJI AGRAS T40 · S/N 64TBK8R001007UN2484JCessna 150G · S/N 15065584N2667GCessna 182B · S/N 51967N3135ACessna 170B · S/N 25779N3243NPiper J3C-65 · S/N 22435N3606ECessna 172N · S/N 17271604N4114LCessna 172G · S/N 17254183N4923MPiper PA-11 · S/N 11-1626N5146HPiper PA-14 · S/N 14-156N588RSVector HD 580 · S/N 212985300C6B0N6030HPiper J3C-65 · S/N 19173N613UGrumman G-164 · S/N 341N6642ACessna 172 · S/N 28742N69626Boeing B75N1 · S/N 75-6547N76114Cessna 140 · S/N 10511N77719Mcclish FUNK B85C · S/N 349N8982TCessna 182C · S/N 52882N9336CCessna 180 · S/N 31734N9501HBoeing A75L3 · S/N 756821N97045Cessna 172P · S/N 17276148N9756VCessna 188 · S/N 188-0206
Back to Casselton, ND