OpenAirDocs.org
Madison, AL

Registered aircraft · 109

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.

N51445Maule M-4-210C · S/N 1106CBuilt 1973 · Lanier John LN5163ACessna 172 · S/N 28163Built 1955 · Passero Robert SN51975Toelaer John VARI EZ · S/N 1275Toelaer John CN5258BCessna 152 · S/N 15283818Mathis Ryan BN5272Grumman G-164A · S/N 652Lanier John L JrN530CTFlight Design CTSW · S/N 06-11-12Built 2006 · League Christopher MN5346Grumman G-164A · S/N 643Built 1969 · Lanier Flying Service IncN5389EBeech K35 · S/N D-5890Built 1959 · Wagner Paul A JrN53941Dehavilland DHC-1 CHIPMUNK · S/N 01-0088Built 1950 · Wb650 Raf Chipmunk LLCN5444CCessna 170A · S/N 19478Built 1950 · Mathis Ryan BN576BSLancair LC41-550FG · S/N 41059Built 2005 · C&J Aerobiz LLCN5997PPiper PA-24-250 · S/N 24-1092Built 1959 · N5997p LLCN6003VGriffon Aerospace VALIANT · S/N 072-010003Griffon AerospaceN6004VGriffon Aerospace VALIANT · S/N 072-010005Griffon AerospaceN602SFCessna 182Q · S/N 18267575Built 1980 · Offut Ancel M JrN60577Cessna/Air Repair 305F · S/N AR-6Built 2002 · Saving Our Flying HeritageN6195DPiper PA-18A 150 · S/N 18-5491Built 1957 · Tieszen RandalN619RVVans RV-12 · S/N 120443Built 2024 · Millhouse David SN659WPCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 08SC133Built 2008 · Burwell James MN66452Cessna 150M · S/N 15076059Built 1974 · Bedard Michael J TrusteeN6811KPiper PA-16 · S/N 16-646Built 1949 · Bashore Charles AN696RVOlivares David J RV-8A · S/N 83183Built 2022 · Olivares David JN701LEEverett Leon E ZENITH 701 · S/N 7091Built 2009 · Cancel WalterN71420Cessna 182M · S/N 18259616Built 1969 · Yeti Aviations LLCN724CCDJI PHANTOM 3 PROFESSION · S/N P77DCG2 9010851Intergraph CorpN7278DPiper PA-18A 150 · S/N 18-5691Augustin Caleb JN728MEAirey Mark E MTO SPORT KIT · S/N M00972Built 2013 · Emerald Specialty Services LLCN7354HCessna 182R · S/N 18267909Sale reportedBuilt 1981N74631Grumman American Avn. AA-5B · S/N AA5B-0303Built 1976 · Galactic Xtreme EnterpisesN74886Grumman American Avn. AA-5B · S/N AA5B-0280Built 1976 · Fisher Robert WN750XFX-Ray Foxtrot STOL CH750 · S/N 75-10095Built 2014 · X-Ray Foxtrot LLCN7732RBeech E33C · S/N CJ-7Built 1968 · Aluzion LLCN79440Cessna 172K · S/N 17258089Built 1969 · Spatiumtech LLCN7965HPiper PA-12 · S/N 12-870Built 1946 · Bedard Michael J TrusteeN7979KBeech 95-B55 (T42A) · S/N TC-689Built 1964 · Tdiation Flights LLCN8128UCessna 172F · S/N 17252028Built 1964 · Walters Stephen BN824SGAmerican Champion 8KCAB · S/N 1082-2009Built 2009 · Audenaert William NN832ETTowe Elbert S BOWERS BI-BABY · S/N 83-2Built 1987 · Towe Elbert SN83CSBurkhart Grob Flugzeugbau ASTIR CS · S/N 1237Built 1976 · Mosher Aaron YN84525Aeronca 7AC · S/N 7AC-3226Built 1946 · Augustin Caleb JN8489LCessna 172I · S/N 17256689Built 1968 · Barlow Warren PN864RVVans RV-12 · S/N 120425Built 2015 · Mccarter James WN869AGLarry A French OUTLAW G2E · S/N 041-010004-80022First renewal noticeGriffon AerospaceN869HGGriffon Aerospace OUTLAW G2E · S/N 041-010004-80020Griffon AerospaceN869KGGriffon Aerospace OUTLAW G2E · S/N 041-010004-80015Griffon AerospaceN869LGGriffon Aerospace OUTLAW G2E · S/N 041-010004-80016Griffon AerospaceN869MGGriffon Aerospace OUTLAW G2E · S/N 041-010004-80021Griffon AerospaceN869TGLarry A French OUTLAW G2E · S/N 041-010004-80010First renewal noticeGriffon AerospaceN8786SCessna 150F · S/N 15062086Built 1966 · Jae Grace ElizabethN8862GLarry A French OUTLAW G2E · S/N 041-010004-80009Griffon Aerospace
Back to Madison, AL