OpenAirDocs.org
Madison, AL

Registered aircraft · 108

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

N1009Chris Sargent RV-7A · S/N 73142Built 2019 · Sargent Chris LN1178KAeronca 0-58B · S/N 058B-2472Built 1947 · Little Darlin Air Corps LLCN12134Piper PA-24-250 · S/N 24-3598Built 1964 · Everson Corey AN138EZToelaer John C DEFIANT · S/N 138Built 1995 · Toelaer John CN1456NPiper J-3C · S/N 22990Gentile AnthonyN150TPiper PA-18-125 · S/N 18-2264Built 1953 · Towe Lannie KN1533DCessna 195 · S/N 7755Built 1952 · Zimmerman Luke GN1650WBeech A36 · S/N E-352Built 1972 · Griffin Michael DN165NAeropro CZ EUROFOX LSA · S/N 24607Built 2008 · Arnold Frank EN167LAAir Tractor AT-602 · S/N 602-1167Built 2008 · Towe Boys Agri Service IncN177QCessna 177B · S/N 17702218Built 1974 · Floyd RandyN179WBHawker Beechcraft B300 · S/N FL-773Built 2011 · Shaken Aviation LLCN202EAEclipse EA500 · S/N 000202Built 2008 · Sierra Tango LLCN2055HHead Balloons AX8-88 · S/N 349Built 2007 · Swann Phyllis RuthN214GCessna 210L · S/N 21061237Built 1976 · Gilpin Sean FN21992Piper PA-32RT-300 · S/N 32R-7885265Built 1978 · Gilpin Sean FN23621Beech A36 · S/N E-1192Built 1977 · Excellance IncN2481Flug & Fahrzeugwerke DIAMANT 16.5 · S/N 062Built 1969 · Barnett Jerry LN257NHDJI AGRAS T40 · S/N 64TBL5A00200Q6Aerial Spray Services LLCN285LFLarry A French GH-800A · S/N GCFX1007B19BGriffon AerospaceN30464Cessna 177A · S/N 17701272Built 1968 · Cunningham Augustus BruceN3091UYanda Nelvin L LANCAIR 320 · S/N 001Built 1994 · Exaqt Consultant GroupN3116YCessna 182E · S/N 18254116Built 1962 · Gorrell Nena SN316AMVans RV-12 · S/N 120706Built 2018 · Olive JayN316UELloyd J Stables SEAREY LSX · S/N 1MK465CBuilt 2016 · O3 Aviation LLCN344PAAyres S-2R · S/N 2431RBuilt 1978 · Towe Lannie Kent SrN3508XMooney M20F · S/N 670046Pietrs Robert AN3675QBeech A23-24 · S/N MA-266Built 1967 · Swann Phyllis RN3785NPiper J3C-65 · S/N 14432Built 1945 · Bedard Michael J TrusteeN38JCCrabb Jeffrey A RV-6A · S/N 60173Built 2000 · Crabb Jeffrey AN3EBSchleicher ASW-20L · S/N 20351Burch James R IIN4214XRockwell International S-2R · S/N 1971RBuilt 1974 · Towe Boys Agri ServiceN4223GAir Tractor AT-502B · S/N 502B-2675Built 2009 · Towe Flying ServiceN4387MPiper PA-12 · S/N 12-3325Built 1947 · Bedard Michael J TrusteeN4449KRyan NAVION · S/N NAV-4-1449Built 1948 · Holder ToddN4521XPiper PA-28-151 · S/N 28-7615023Built 1975 · Clemmons Philip BN4529BGulfstream American AA-5B · S/N AA5B1144Built 1979 · Cianfaglione Peter WN46167Cessna 172I · S/N 17257085Towe LannieN465KBBelue Kevin RV-10 · S/N 40261Built 2008 · Belue Kevin DN4762XCessna 150G · S/N 15064812Built 1966 · Spatiumtech LLCN4831MBeech A36 · S/N E-1273Built 1978 · Boty Aero LLCN484XCostruzioni Aeronautiche Tecna P2008 · S/N 076Built 2013 · Piciullo Angelo MN4894TCessna R182 · S/N R18201782Built 1981 · Bar Aviation LLCN48AMCessna 414A · S/N 414A0609Built 1980 · Gwc Air LLCN48DEEdgemon George D RV-8 · S/N 82816Built 2009 · Edgemon George DN5016XRockwell International S-2R · S/N 5048RBuilt 1975 · Towe Lannie KN501KTLearjet 45 · S/N 435Built 2012 · Shaken Aviation LLCN5088MPiper PA-28-235 · S/N 28-10928Built 1967 · General Aviation Partners LLCN5140RCessna 172RG · S/N 172RG0041Built 1979 · Ashby Artie Dale JrN51445Maule M-4-210C · S/N 1106CBuilt 1973 · Lanier John L
Back to Madison, AL