Dickinson, ND
Registered aircraft · 39
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 = 'DICKINSON' 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 = 'DICKINSON' 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.
N1276LColumbia Aircraft Mfg LC41-550FG · S/N 41651N1896JPiper PA-28-140 · S/N 28-24342N20159Cessna 172M · S/N 17261055N201JEMooney M20J · S/N 24-0741N2202MSummit RAVEN S20 · S/N 09200094N222MKBeech F33A · S/N CE-881N238RLTalos Drones T60X · S/N 2104F7EZW259900157U2N2412WCessna 172S · S/N 172S10557N2471DCessna 182S · S/N 18280892N2733VCessna 177RG · S/N 177RG0676N2950BBeech D35 · S/N D-3591N2988PPiper PA-18-150 · S/N 18-4501N3131BBellanca 17-30A · S/N 73-30565N326UWTextron T182T · S/N T18209184N3411SCessna 182G · S/N 18255811N3890ZPiper PA-18-150 · S/N 18-7706N3990KPiper PA-28-140 · S/N 28-23881N406ZHHylio HYL-150 · S/N 17906110408Sale reportedN418MBCessna 182Q · S/N 18266154N441BKCessna 441 · S/N 441-0215N4645YHylio HYL-150 · S/N 17906110406Sale reportedN4646YHylio HYL-150 · S/N 17906110407Sale reportedN517LMCirrus Design SR22 · S/N 3715N51PMClaridge Tommy J KITFOX IV · S/N 1452N5386BCessna 182 · S/N 33386N58771Cessna 182P · S/N 18262284N627PAviat A-1 · S/N 1297N6631CCessna 414A · S/N 414A0038N6771VMooney M20C · S/N 700078N683EAHawker Beechcraft G36 · S/N E3863N7129PPiper PA-24-180 · S/N 24-2292N738GSCessna 172N · S/N 17269971N7659XStinson 108-3 · S/N 1084859N771WBPilatus PC-12/45 · S/N 240N87410Ercoupe 415-D · S/N 583N917PPDJI AGRAS T40 · S/N 1581F574B234U00100SAN9697VCessna 172M · S/N 17264476N990FCDJI AGRAS T30 · S/N 3U5BJ6D00100M9N9944DPiper PA-18A · S/N 18-7013
Back to Dickinson, ND