OpenAirDocs.org
Madison, SD

Registered aircraft · 68

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

N1335PPiper PA-23 · S/N 23-380Riggin Flight Service IncN1396HAeronca 15AC · S/N 15AC-447Riggin Flight Service IncN1612NFunk B85C · S/N 410Built 1947 · Hoffman ConradN2091Xag P100 PRO · S/N 1863FPEG8219352G307XXact Aerial Sd LLCN2114PPiper PA-23-150 · S/N 23-705Riggin Flight Service IncN2172PPiper PA-23 · S/N 23-778Built 1956 · Riggin Flight Service IncN2205APiper PA-18-135 · S/N 18-1881Built 1952 · Riggin Flight Service IncN22709Cessna 150H · S/N 15068463Riggin Flight Service IncN2576LCessna 172H · S/N 17255776Riggin Flight Service IncN2642LCessna 172H · S/N 17255842Riggin Flight Service IncN2645MPiper PA-12 · S/N 12-979Built 1946 · Schwenke-Cram KimN3064YCessna 182E · S/N 18254064Stemper Pete LN3280PPiper PA-23 · S/N 23-679Built 1956 · Riggin Flight Service IncN3335MPiper PA-12 · S/N 12-2193Riggin Flight Service IncN3349EAeronca 11AC · S/N 11AC-1681Built 1947 · Brown Tim JN3483ZPiper PA-18 · S/N 18-7315Built 1960 · Riggin Flight Service IncN34BZBeech A45 · S/N CG-209Built 1958 · Dimich Milan CN3763EAeronca 11AC · S/N 11AC-S-6Flywithgeorge IncN37RPPearson Richard L RV-3 · S/N 811-6Built 1992 · Pearson Landon SN39841Bellanca 17-30A · S/N 30484Riggin Flight Service IncN4002NCessna 140 · S/N 13460Riggin Flight Service IncN4014NCessna 140 · S/N 13472Built 1947 · Hoffman Conrad DN405FLPiper PA-28-140 · S/N 28-7125181Built 1971 · Riggin Flight Service IncN40950Piper J3F-65 · S/N 7620Built 1941 · Riggin Flight Service IncN4121PPiper PA-23-160 · S/N 23-1601Built 1959 · Riggin Flight Service IncN4124JPiper PA-28-140 · S/N 28-22443Built 1966 · Riggin Flight Service IncN4199TCessna 182S · S/N 18280372Built 1998 · Enga James CraigN42BYBolster PITTS SPECIAL S-1S · S/N 476B1077Knuth MatthewN43665Taylorcraft BC12-D · S/N 7324Built 1946 · Stoeppler HeidiN4586YPiper PA-25-235 · S/N 25-4264Built 1967 · Riggin Flight Service IncN4856EChampion AERONCA 7GC · S/N 7GC-48Built 1959 · Riggin Flight Service IncN4885MPiper PA-11 · S/N 11-410Built 1947 · Riggin Flight Service IncN4903DCessna 182A · S/N 51003Built 1958 · Sam Air LLCN497FLPiper PA-28-140 · S/N 28-7125314Built 1971 · Riggin Flight Service IncN5019MTaylorcraft BC12-D · S/N 10319Built 1946 · Olinger Gary EN50834Piper J3C-65 · S/N 10278Built 1943 · Riggin Flight Service IncN508XAHuida Tech HD580 · S/N 212985300C7BBXact Aerial Sd LLCN5682WPiper PA-28-160 · S/N 28-938Built 1962 · Riggin Flight Service IncN5719WPiper PA-28-150 · S/N 28-1344Riggin Flight Service IncN5752UPiper PA-28-140 · S/N 28-26575Riggin Flight ServiceN600JSGrumman G-164A · S/N 835Riggin Flight Service IncN60202Taylorcraft DCO-65 · S/N 5661Built 1943 · Hanson Robb DN6341KCessna 150M · S/N 15077654Built 1975 · Riggin Flight Service IncN645DBeech C35 · S/N D-2910Built 1951 · Riggin Flight Service IncN65688Boeing E75 · S/N 75-8469Riggin Flight Service IncN6630WPiper PA-28-140 · S/N 28-20728Riggin Flight Service IncN6909GCessna 150L · S/N 15072409Built 1970 · Stemper Peter LN7038XCessna 150A · S/N 15059138Built 1960 · Brown Timothy JN70819Piper J3C-65 · S/N 17836Built 1946 · Knuth MatthewN7229VIntermountain CALLAIR A-9 · S/N 1266Built 1966 · Riggin Flight Service Inc
Back to Madison, SD