OpenAirDocs.org
Madison, GA

Registered aircraft · 28

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

N1086QMooney M20J · S/N 24-3168Built 1990 · Barnhardt PaulN127LCAmerican Legend AL3 · S/N AL-1178Built 2013 · Lindsey Charles AN18PVVisscher Paul J RV-8 · S/N 81367Built 2004 · Visscher Paul JN201NJMooney M20J · S/N 24-0252Built 1977 · Barnhardt Paul BradyN212SFAeromere F.8L FALCO · S/N 212Built 1960 · Crowder Alan LN2208TPiper PA-28-180 · S/N 28-7105185Thurmond DonaldN22KABellanca 7KCAB · S/N 468-74Built 1974 · Holder Jeffrey JN3525WPiper PA-32-260 · S/N 32-411Built 1966 · Davis Micihael KN3603YCessna 210 · S/N 21058103Built 1962 · Carter Duane LeeN3727WPiper PA-32-260 · S/N 32-640Built 1966 · Triple C Air LLCN3771XAero Commander 100 · S/N 263Registration pendingBuilt 1968N3824KTemco GC-1B · S/N 3513Built 1948 · Jones James MiltonN3899WPiper PA-32-260 · S/N 32-845Built 1966 · Mauldin BrettN4073XAero Commander 100-180 · S/N 5173Built 1970 · Wakenigg Michael CN4075PPiper PA-23-160 · S/N 23-1537Built 1958 · Holder Jeffrey JN50GAMaule M-5-220C · S/N 5003CBuilt 1974 · Cantrell James E TrusteeN55528Boeing PT-17 · S/N 75-4611Built 1943 · Roberts James PN5844YBeech 58 · S/N TH-1148Built 1980 · Lindsey Charles AN726TRTextron B300 · S/N FL-1268Built 2021 · Dss Aviation IncN72RPPiper PA-18 · S/N 18-2214Built 1952 · Visscher Fred DN7384ECessna 172N · S/N 17272100Built 1978 · Fierman Jo AngelaN7767TCessna 172A · S/N 47367Built 1960 · Visscher Paul JN78070Globe GC-1B · S/N 2070Built 1946 · Visscher Paul JN803HCBeech F90 · S/N LA-99H J King Air LLCN9097FBarker John HOME BUILT · S/N 01Built 2002 · Fowler David JN9106KStinson 108-1 · S/N 108-2106Built 1947 · Stinson 47 LLCN92407Piper J3C-65 · S/N 16870Built 1946 · Taylor Larry JN9742WPiper PA-28-140 · S/N 28-23224Thurmond Donald
Back to Madison, GA