OpenAirDocs.org
Bismarck, ND

Registered aircraft · 136

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 = 'BISMARCK'
  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.

N100KBBeech C90 · S/N LJ-820Built 1979 · Executive Air Taxi CorpN1119CCirrus Design SR22 · S/N 0487Built 2003 · Abc Transportation Co IncN111MQRaytheon B200 · S/N BB-1665Built 1999 · Bismarck Air Medical LLCN1120FCessna 172G · S/N 17254715Built 1966 · Haidle Wayne MN1139UCessna 172M · S/N 17266868Built 1976 · Fettig Peter JN1172MCessna 172K · S/N 17258672Built 1969 · Todd Kevin EN127EMWullner Bryan V LANCAIR 360 · S/N 121707Krein ChrisN141SBPiper PA 46-350P · S/N 4636244Built 1999 · Ck Aviation LLCN1494QCessna 150L · S/N 15072794Built 1971 · Sauter AllenN1664VCessna 172M · S/N 17263706Built 1974 · Bismarck Aero Center CorpN175MAPiper PA46-500TP · S/N 4697461Built 2011 · Dakota Equipment LLCN17NWCessna 414A · S/N 414A0223Built 1979 · Eye Clinic Building LllpN18402Beech A36 · S/N E-1117Built 1977 · Ohlhauser DevinN1900UCessna 172N · S/N 17273162Built 1979 · Bismarck Aero CenterN194TRBeech B200 · S/N BB-1146Built 1983 · Executive Air Taxi CorpN200NDRaytheon B200 · S/N BB-1612Built 1998 · North Dakota Department Of TransportationN201BVMooney M20J · S/N 24-0434Built 1978 · Broussard Anthony StevenN202NDRaytheon B200 · S/N BB1611Built 1998 · North Dakota Department Of TransportationN205SCCirrus Design SR22T · S/N 10630Built 2025 · 5sc LLCN20XKMooney M20K · S/N 25-2000Built 1997 · Buildings Evergreen LLCN2134HErcoupe 415-D · S/N 2757Built 1946 · Sullivan James EN2168RCessna 182G · S/N 18255368Built 1964 · Nd Aero Solutions LLCN218MBTextron 525C · S/N 525C0331Built 2020 · Mbi Leasing LLCN220PFRaytheon HAWKER 800XP · S/N 258542Built 2001 · Executive Air Taxi CorpN2247WPiper PA-28R-201T · S/N 28R-7703159Butts Alan RN2255NBeech V35B · S/N D-9580Built 1974 · Malard Darren LN227PADJI AGRAS T40 · S/N 64TBL1J002008CPro Ag Solutions LLCN228NDCessna 208 · S/N 20800520Built 2010 · North Dakota Dept Of TransportationN233SHCessna 152 · S/N 15283714Built 1979 · Sieger Aviation Services IncN2340CCessna R182 · S/N R18200155William J DavisN237FBCessna 182T · S/N 18281916Built 2007 · Gomez Preston AndreasN2484EAeronca 7AC · S/N 7AC-6063Built 1946 · Tbf LlpN2588WMooney M20C · S/N 3280Built 1965 · Johnson Mitchell RN25GFAmerican Champion 8GCBC · S/N 596-2019North Dakota Game And Fish DeptN2613WMooney M20E · S/N 959Anderson Raymond ON296BCPiper PA-18-150 · S/N 18-7877Krein Christopher LN299SPCessna T206H · S/N T20608797Built 2007 · North Dakota Highway PatrolN300AJBeech B200 · S/N BB-965Built 1981 · Asm Aviation LLCN310YFDJI AGRAS T30 · S/N 527BJ7800100CUFrontier PrecisionN31NANorth American T-28B · S/N 140031Built 1954 · Northern Flight LLCN31UEAviat A-1C-200 · S/N 3349Built 2020 · Remc Leasing LLCN334RZDJI AGRAS T30 · S/N 3U5BJ4D0010055Pro Ag Solutions LLCN351BMJborsm EPIC LT · S/N 0110Built 2007 · Jborsm LLCN357DBBecker Mark D VANS RV-8 · S/N 80635Built 2006 · Becker Mark DN3609ECessna 172N · S/N 17271606Built 1978 · Bismarck Aero Center CorpN3625QAerostar International RX 8 · S/N RX8-3041Uhlman James AN3670ZPiper PA-22-160 · S/N 22-7408Built 1960 · Faught Jeffrey RN3690APiper PA-18A 150 · S/N 18-3038Built 1953 · Johnson Mandley O JrN370KHHuwe M K RV-4 · S/N 307Duffy Edward CN383XMaule M-5-210C · S/N 6068CBuilt 1974 · Solberg Jon S
Back to Bismarck, ND