Fargo, ND
Registered aircraft · 209
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 = 'FARGO' 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 = 'FARGO' 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.
N110CAPiper PA-34-200T · S/N 34-7570219N113SWPiper PA-28-181 · S/N 28-7890298N115FJCessna 172S · S/N 172S10784N117PHCessna 182Q · S/N 18265492N121WAPiper PA-34-200T · S/N 34-7970435N127ZWBeech C90A · S/N LJ1369N1289HAeronca 15AC · S/N 15AC-306N1354DCessna 170A · S/N 19930N13583Aeronca C-3 · S/N A-277N13AGPiper PA-34-200T · S/N 34-7770115N14HYAviat A-1C-180 · S/N 3327N150YDRaytheon B200 · S/N BB-1561N15TRMitsubishi MU-2B-40 · S/N 446 S.A.N1627HPiper PA-28-161 · S/N 28-7716028N164RDPilatus PC-12/47E · S/N 2225N16556Piper PA-28-235 · S/N 28-7310105Sale reported, pending cancellationN165RDBombardier BD-100-1A10 · S/N 20745N166RDCessna 560XL · S/N 560-5740N167RDBombardier BD-100-1A10 · S/N 20363N1689MCessna 182P · S/N 18264414N185BKTextron T206H · S/N T20609555N1943TPiper PA-28-180 · S/N 28-7105156N19AOdegaard STEEN SKYBOLT · S/N 0100N2009QCessna 177RG · S/N 177RG0409N201YBMooney M20J · S/N 24-0473N20MFFletcher Marvin LANCAIR 320 · S/N 723-320-566FBN2173LBeech F33A · S/N CE-666N21778Cessna 172S · S/N 172S10483N220WPiper PA 46-350P · S/N 4622052N22330Aeronca S-65-C · S/N C3329N227PGCirrus Design SR22 · S/N 3675N2293MPiper PA-28R-201 · S/N 28R-7837082N22BMButler Francis J RV-8 · S/N 80471N232RJDassault FALCON 2000 · S/N 130N2355CCessna 180 · S/N 30655N243PBTextron B300 · S/N FL-1359N249AKRupp-Roger STARDUSTER TOO SA300 · S/N 1747N26QLCessna 560 · S/N 560-0498N2727SCessna 150G · S/N 15066627N2751QCessna 182K · S/N 18257951N285DVCessna T206H · S/N T20608171N29070Cessna TR182 · S/N R18200639N2990NCessna 140 · S/N 13248N29HWAero Vodochody L-39 · S/N 131912N3036YCessna 182E · S/N 18254036N303RRRaytheon B300 · S/N FL-178N307LSCessna 680 · S/N 680-0066N317KSThorstad Vaughn A VALLEY WINGS LLC MER · S/N 95055N33144Piper PA-34-200T · S/N 34-7570094N331JPRaytheon C90GT · S/N LJ-1756
Back to Fargo, ND