OpenAirDocs.org
Madison, MS

Registered aircraft · 67

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N1092YRaytheon A36 · S/N E-3045Built 1996 · Cbg Properties LLCN1157QCessna U206F · S/N U20602848Built 1975 · Rrc IncN117WJCessna 150L · S/N 15075427Built 1973 · Myles WinnfortN118SMPiper PA-18-135 · S/N 18-2175Mars Samuel CN1191HPiper PA-28-181 · S/N 28-7790294Burford John W TrusteeN13623Cessna 172M · S/N 17262890Built 1974 · Cloer Mark Flynt SrN136JLHawker Beechcraft G36 · S/N E-3891Built 2009 · Redline Aviation LLCN153ABButton Richard M CHRISTAVIA MK-I · S/N 153Built 1989 · Ochs Mark AN159RVRounds William F VANS RV-9A · S/N 90362Built 2003 · Tullos George EN15VECirrus Design SR22 · S/N 3954Built 2013 · Cajunodysea Outfitters LLCN164DMBell 206B · S/N 153Wcf Aerospace LLCN1692TPiper PA-28-140 · S/N 28-7125009Built 1970 · Dhawan GautamN169GCGame Composites GB1 GAMEBIRD · S/N 0027Built 2021 · Flying Eagle LLCN18993Beech C24R · S/N MC-550Built 1977 · Ochs Mark AN191SHCessna 172K · S/N 17257232Built 1968 · Hutton StephenN203VMyers Daniel Kenneth QUESTAIR VENTURE · S/N 22Built 2007 · Myers Daniel KennethN206BCCessna 206H · S/N 20608025Built 1999 · Skelton Thomas NN206SMCirrus Design SR22T · S/N 0171Built 2011 · Augusta Aviation LLCN2228TCessna T182T · S/N T18208480Built 2005 · Hulsey HunterN2238LBeech C24R · S/N MC-459Built 1976 · Deris Jeffrey JN225RPCirrus Design SR20 · S/N 9246Built 2023 · Skt Aviation LLCN231BZMooney M20K · S/N 25-0142Built 1979 · Fortney Bradley AN286MZDJI AGRAS T40 · S/N 4LGCK6A0071WB4Drone Ops 360 LLCN286NADJI AGRAS T40 · S/N 4LGCK680071THTDrone Ops 360 LLCN3029VCessna 150M · S/N 15076358Flyt LLCN31249Head Balloons AX8-88 · S/N 312Built 2003 · Treetop Balloons LLCN3181CCessna 180 · S/N 30980Built 1954 · Four Boys Aviation LLCN352DSDiamond Aircraft Ind DA 40 · S/N 40.252Built 2002 · Wesley Flyers IncN357HMCessna 182T · S/N 18281338Built 2004 · H & M Aviation LLCN36REPiper PA 46-350P · S/N 4636573Built 2013 · Ciconia Aeronautics LLCN415JBAviat A-1A · S/N 1463Built 1999 · Brewer Allen EN4237JPiper PA-28-140 · S/N 28-22589Moppert Stephen KylerN424MRClarence Michael Osborne MC SPECIAL · S/N 1Built 2019 · Osborne Clarence MichaelN43DZAeronest Holdings GP AL18 · S/N AL-349Built 2021 · Warhawk Aviation LLCN4468SBeech A36 · S/N E-696Built 1975 · Kyle Robert KN455MAPiper PA-32R-301T · S/N 32-57205Built 2001 · A & J Aviation LLCN469DMIsrael Aerospace Industriesltd GULFSTREAM G150 · S/N 257Built 2008 · Nac Flight Service LLCN503SDCessna 150M · S/N 15076056Built 1974 · Simmons MarkN511ECCessna 525 · S/N 525-0013Built 1993 · Mississippi Air Express LLCN517CPCirrus Design SR22 · S/N 3323Built 2008 · Information Management Systems IncN5193LPiper PA-28-180 · S/N 28-4482Built 1967 · C And H Aviation LLCN5278QCessna 150L · S/N 15073178Registration pending, canceledBuilt 1972N5660YMaule M-7-235 · S/N 10016CP2 Aviation LLCN566EACirrus Design SR22T · S/N 2460Built 2021 · Kbs Air LLCN601AJPiper PA-31T1 · S/N 31T-1104013Built 1984 · Shamrock Aviation LLCN6180KCessna 150M · S/N 15077573Built 1975 · Hutton StephenN631RSSchaub Ralph A TITAN TORNADO II · S/N D99220JSOHK0328Ragsdale John WN675PCRaytheon B300 · S/N FL-352Built 2002 · Air Transportation LLCN688JFCessna 182M · S/N 18259510Built 1968 · Crothers TravisN7168RPiper PA-28-140 · S/N 28-21877Built 1966 · Parham Maxwell V
Back to Madison, MS