Watford City, ND
Registered aircraft · 42
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 = 'WATFORD 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 = 'ND' AND g.registrant_city = 'WATFORD 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.
N103FRCessna 150L · S/N 15075569N11927Cessna 150L · S/N 15075712N1237BLuscombe 8A · S/N 5760First renewal noticeN1296GCessna 310R · S/N 310R0698N2129DCessna 182H · S/N 18256143N231BNMooney M20K · S/N 25-0083N2341XCessna 182H · S/N 18256241N2467HErcoupe 415-C · S/N 3092N24KFRobert Omlid II · S/N 660N3027FCessna 182J · S/N 18257127Sale reported, pending cancellationN352MAAviat A-1B · S/N 2107N35505Piper J3C-65 · S/N 6410N38103Stinson 108-3 · S/N 1083800N38211Piper PA-28-161 · S/N 28-7716232N382MAriston E Johnson VANS ACFT RV-14 · S/N 140459N38837Piper J3C-65 · S/N 7324N40260Piper PA-16 · S/N 16-244N4043XRobinson Helicopter R66 · S/N 0878N44AFMitsubishi MU-2B-60 · S/N 790SAN462DMBeech P35 · S/N D-6848N50652Cessna 150J · S/N 15069461N5150NBoeing A75N1(PT17) · S/N 75-6897N5186ACessna 172 · S/N 28186N531ADTextron T206H · S/N T20609634N5878VPiper PA-28-181 · S/N 28-7790506N5970TCessna 150D · S/N 15060670N6131KAir Tractor AT-802A · S/N 802A-0016N6171ANorth American SNJ-4 · S/N 88-13585N6199SCessna T182T · S/N T18208269N6303NChampion 7KCAB · S/N 24N6546UMooney M20C · S/N 2329N7458JPiper PA-28R-180 · S/N 28R-30810N75944Cessna 172N · S/N 17268060N8024SCessna 150F · S/N 15061624N8042VCessna 188 · S/N 188-0292Sale reportedN8116FCessna 150F · S/N 15064216N836DECR Dreams Charters CCK-2000 · S/N CCK-2000-0002N8370WPiper PA-28-180 · S/N 28-2567N8481VRockwell International S-2R · S/N 2314RN910SSTextron 680A · S/N 680A0236N9272KNorth American AT-6D · S/N 88-15693N92MJRoberts John G SUPER BEAR · S/N 2144
Back to Watford City, ND