OpenAirDocs.org
Madison, WI

Cancelled registrations · 176

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'WI' AND d.registrant_city = 'MADISON'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N8084DOtterback BOWERS FLYBABY 1A · S/N 7030Cancelled Oct 31, 1991 · Triennial form not returned · Otterback James HN2331CPiper PA-38-112 · S/N 3879A0155Cancelled Mar 28, 1991 · Triennial form not returned · Four Lakes Aeronautics Sch IncN739GZCessna 172N · S/N 17270544Cancelled Mar 22, 1991 · Exported to Germany · Frickelton C JN6144VBeech 35-C33 · S/N CD-868Cancelled Dec 11, 1985 · Parsons Timothy MN209DWWilson J Dale OSPREY-2 · S/N 05Cancelled Oct 26, 1984 · Administratively canceled · Wilson J DaleN3882XSteffes Robert G ASCENDER II+2 · S/N 1264Cancelled Oct 3, 1984 · Administratively canceled · Steffesrobert GN93SMWittman Tailwind W-8 · S/N 21Cancelled Sep 18, 1984 · Administratively canceled · Mockrud Stanley CN5277XChampion 7KCAB · S/N 213Cancelled Jul 12, 1984 · Roberts James HN732CDCessna T210L · S/N 21061402Cancelled Mar 30, 1984 · Wisconsin Airmens IncN4244RMockrud Stanley C VP-1 · S/N 22Cancelled Nov 17, 1983 · Mockrud Stanley CN7406FHughes 269C · S/N 850430Cancelled Feb 24, 1983 · Exported to Venezuela · Rotor Aire IncN714WLCessna 152 · S/N 15279489Cancelled Dec 13, 1982 · University Of Wisconsin Flying Club IncN200AJSchweizer SGS 1-26E · S/N 652Cancelled May 11, 1981 · Exported to Canada · Built 1976 · Woodford John EN3684JCessna 150G · S/N 15064984Cancelled Mar 24, 1981 · Built 1966 · University Of Wisconsin Flying Club IncN8092LCessna 172H · S/N 17256292Cancelled Jan 12, 1981 · Steinmetz George P JrN5695KEnstrom Helicopter 280C · S/N 1211Cancelled Dec 15, 1980 · Exported to Switzerland · Rotor Aire IncN758NWCessna R172K · S/N R1723238Cancelled Dec 1, 1980 · Exported to Canada · Aviconorth LtdN714SYCessna 152 · S/N 15279408Cancelled Jul 7, 1980 · Two Do Enterprises IncN97070Cessna 182Q · S/N 18266961Cancelled Jun 22, 1979 · Exported to Australia · Aviconorth LtdN54824Piper PA-23-250 (6PCLM) · S/N 277554121Cancelled Jun 24, 1977 · Exported to Canada · Bormans IncN7184YPiper PA-30 · S/N 30-208Cancelled May 16, 1977 · Wilson J DaleN6275FCessna 337A · S/N 337-0275Cancelled Jun 9, 1976 · Exported to Canada · West Park Professional Offices IncN7727TCessna 172A · S/N 47327Cancelled May 28, 1976 · Story Richard MN6976MStinson 108-3 · S/N 108-4976Cancelled Aug 29, 1974 · Exported to Canada · Kleinheinz Carl JN2440QCessna 150G · S/N 15066900Cancelled Aug 1, 1974 · Mt Horeb Flying ClubN89678Cessna 120 · S/N 8726Cancelled Aug 1, 1974 · Built 1946 · Hetzler Ronald L/Lynch GaryN6622YPiper PA-23-250 · S/N 273929Cancelled Jul 31, 1974 · Exported to France · Four Lakes Aviation CorpN1914NCessna 140 · S/N 12158Cancelled Jul 10, 1974 · Built 1947 · Four Lakes Aviation CorpN76072Cessna 120 · S/N 10466Cancelled May 3, 1974 · Molstad Richard GN1439Bensen B-8M · S/N 1000ACancelled Feb 21, 1974 · Built 1968 · Tealey Timothy AN36030Bellanca 7GCBC · S/N 538-73Cancelled Jul 17, 1973 · Exported to Canada · Frickelton School Of Aeronautics IncN2690BAero Commander 560 · S/N 190Cancelled Jun 21, 1973 · Built 1955 · Professional Office Bldgs IncN6073KRepublic RC-3 · S/N 253Cancelled Feb 3, 1971 · National Discount CoN2634MPiper PA-12 · S/N 12-1070Cancelled Oct 6, 1970 · Built 1946 · Four Lakes Aviation CorpN4984NDouglas B-26 · S/N 29231Cancelled Aug 20, 1970 · Dec Aviation CorpN70696Cessna 182M · S/N 18259361Cancelled Jun 30, 1970 · Frickelton School Of Aeronautics IncN6800SAero Commander 680 · S/N 680-429-102Cancelled Jun 20, 1970 · Marshall Erdman & Associates IncN3452VCessna 195A · S/N 7149Cancelled Jun 4, 1970 · Week D C Richard AN4336HPiper PA-15 · S/N 15-120Cancelled Jul 3, 1969 · University Of Wisconsin Flying ClubN8624BCessna 172 · S/N 36324Cancelled Mar 7, 1969 · Built 1958 · Mad-Cap Flying Club IncN3819EAeronca 11AC · S/N 11AC-S-35Cancelled Feb 12, 1969 · Pernot Laverne IN6343RPiper PA-28-140 · S/N 28-21512Cancelled Feb 11, 1969 · Built 1966 · Four Lakes Aviation CorporationN3278EAeronca 11AC · S/N 11AC-1651Cancelled Sep 17, 1968 · Bennett Cleo LN963JBeech C18S · S/N 7189Cancelled May 1, 1968 · Exported to Canada · Four Lakes Aviation CorpN1796HCessna 310C · S/N 35896Cancelled Jan 31, 1968 · Wisonsin Culvert CoN43313Taylorcraft BC12-D · S/N 6972Cancelled Oct 11, 1967 · Built 1946 · Ostlind Catharine CN89174Cessna 140 · S/N 8188Cancelled May 1, 1967 · Exported to Canada · Gerald TownsendN4573VBeech 35 · S/N D-1404Cancelled May 25, 1965 · Jerry DurcanN9573ACessna 170A · S/N 19134Cancelled May 21, 1965 · Clack Robert JN1688EAeronca 7AC · S/N 7AC-5253Cancelled Jul 7, 1964 · Exported to Canada · Weber James M
Back to Madison, WI