OpenAirDocs.org
Brandon, MS

Registered aircraft · 117

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 = 'MS' AND g.registrant_city = 'BRANDON'
  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.

N102TLBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1234Central Ms Soaring Society LLCN10QBPiper PA-31-325 · S/N 31-7812065Built 1978 · Asc Aviation LLCN115CSPiper PA-32R-301 · S/N 32-46177Built 2000 · Burger Aviation LLCN1184BLuscombe 8A · S/N 5811Built 1947 · Nelson Fred L IIIN118MCPiper PA-31-350 · S/N 31-7952161Built 1979 · Alpha Whiskey 3 LLCN11AJTaylorcraft DCO-65 · S/N 5102Tailwinds Services And Commodities IncN1202BBeech 95-B55 (T42A) · S/N TC1825Built 1974 · Davis Aviation Inc DBAN120NCBeech B200 · S/N BB1056Built 1982 · Davis Aviation Inc DBAN1232SSchweizer SGS 2-33A · S/N 216Built 1971 · N292 Ac Flyers LLCN140RDPiper PA-31-350 · S/N 31-7552051Built 1975 · Alpha Whiskey 3 LLCN141AFSchweizer 269C-1 · S/N 0014Built 1995 · Smith Michael JN141HCBeech 35-B33 · S/N CD-604Built 1963 · Kom Terry MN154WWPiper PA-31-350 · S/N 31-7952230Alpha Whiskey 1 LLCN1560Beech A200 · S/N BC-09Davis Aviation IncN1563RBeech A36 · S/N E-2858Strength LLCN1588ECessna 172N · S/N 17271054Built 1978 · Geaux Giddum 1 LLCN1650FCessna 172H · S/N 172550454 Aces Air LLCN170HSPiper PA-34-220T · S/N 34-8233164Built 1982 · Aero Leasing LLCN180AZCessna 180J · S/N 18052433Built 1974 · Mohr Elizabeth GN182BACessna 182N · S/N 18260287Built 1970 · E&S Aviation LLCN182HCCessna TR182 · S/N R18200734Built 1978 · Drake Craig CN184FNSutton Larry Owen VANS RV-8 · S/N 80516Built 2002 · Lehr William CN185MECessna A185F · S/N 18502356Built 1974 · Strength LLCN186GAPiper PA-31T · S/N 31T-7820086Davis Aviation Inc DBAN18RLPiper PA-31-350 · S/N 31-7952090Built 1979 · Alpha Whiskey 3 LLCN201QTMooney M20J · S/N 24-0309Built 1977 · R Squared LLCN217USRaytheon B300 · S/N FL-519Built 2007 · Davis Aviation IncN22AGBeech V35B · S/N D-9499Built 1973 · Mavridoglou Theo AN22BCBellanca 7KCAB · S/N 535-75Built 1975 · Sky Shark Aviation LLCN242LFBeech F90 · S/N LA-86Built 1981 · Davis Aviation IncN2481NCessna 120 · S/N 12734C M & K Enterprises IncN2519HSchweizer SGS 2-33A · S/N 429Registration pendingBuilt 1976N25NDJames M Bowie ND ROCKET · S/N 001Bowie James MN2921WEavision EA-J70 · S/N JMZKJ070UAV612555522Midsouth Aerial Applications LLCN300AWRaytheon C90A · S/N LJ-1716Built 2004 · Davis Aviation Inc DBAN31NWPiper PA-31-350 · S/N 318152139Built 1981 · Alpha Whiskey 2 LLCN31PRPiper PA-31-350 · S/N 317952049Built 1979 · Alpha Whiskey 1 LLCN3262FMooney M20E · S/N 670055Built 1967 · Cm&K Enterprises IncN326ARMaule MX-7-180A · S/N 20064CBuilt 2006 · Bowen David RN344RVWatson Bill/Rans RANS S6ES · S/N 1195911-0803Built 2005 · Jackson Tommy SN34MFBeech E-90 · S/N LW-163Built 1975 · Davis Aviation IncN350GHilbe James D SWEARINGEN SX-300 · S/N 78Built 1993 · Smith Michael JN352MBCirrus Design SR22T · S/N 11074Built 2025 · D&D Aviation LLCN3763FGreat Lakes 2T-1A-2 · S/N 0759Built 1977 · Smith Herbert LN391WMWayne Moore CH 701 · S/N 6579Built 2022 · Lehr William CN408JHCirrus Design SR20 · S/N 8906Built 2022 · Sunshine And Tailwinds Aviation LLCN41BWLet L-23 SUPER BLANIK · S/N 917921Central Ms Soaring Society LLCN4211HMooney M20J · S/N 24-0662Rn Roofing LLCN4364CPiper PA-34-220T · S/N 34-84330754 Aces Air LLCN4375RPiper PA-46-310P · S/N 46-8508003Davis Aviation Services LLC
Back to Brandon, MS