OpenAirDocs.org
Milwaukee, WI

Cancelled registrations · 389

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

N493CMeyers Industries 200A · S/N 257Cancelled Aug 22, 1963 · Milwaukee AviationN1395HAeronca 15AC · S/N 15AC-446Cancelled Aug 16, 1962 · Bartnik Frank AN9338EAeronca 11AC · S/N 11AC-977Cancelled Sep 19, 1961 · Built 1946 · Nitz ArthurN23271Piper J3C-65 · S/N 3029Cancelled Jul 27, 1961 · Sobotta Alois LN5460BCessna 182 · S/N 33460Cancelled Jul 24, 1961 · Ehlert Manufacturing CoN3394BPiper PA-18 · S/N 18-3381Cancelled Jul 17, 1961 · Haack Mining Co LtdN8759HNorth American NAVION · S/N NAV-4-759Cancelled Nov 23, 1960 · Nashban Barrel & Container Co IncN6864BPiper PA-22-150 · S/N 22-4164Cancelled Jul 6, 1959 · Exported to Canada · Hurley Don LN4621NBeech C18S · S/N 452Cancelled Jun 30, 1958 · Exported to Canada · Built 1943 · Wisconsin Steel Treating And Blasting CoN2091DBeech D35 · S/N D-3436Cancelled Jun 23, 1958 · Anderson Air ActivitiesN2971NCessna 140 · S/N 13229Cancelled Feb 27, 1958 · Anderson Martin JN9495CCessna 180 · S/N 31893Cancelled Oct 31, 1957 · Exported to Canada · Everbrite Electric Signs IncN8936ABeech D18S · S/N A-584Cancelled Apr 3, 1957 · Anderson Air ActivitiesN9088EAeronca 11AC · S/N 11AC-721Cancelled Oct 11, 1956 · Hinkens George H & June L HinkensN61825Cessna T-50 · S/N 5664Cancelled Jul 4, 1956 · Gran Aire IncN1185HAeronca 15AC · S/N 15AC-196Cancelled May 24, 1956 · Exported to Canada · Everbrite Electric Signs IncN1229APiper PA-18 · S/N 18-846Cancelled May 11, 1956 · Haeusler GeneN220APiaggio P.136-L1 · S/N 197Cancelled Apr 13, 1956 · Exported to Canada · Royal Aircraft CorpN39282Taylorcraft BC12-D · S/N 6536Cancelled Feb 28, 1956 · Skyway Privateers IncN17432Aeronca C-3 · S/N A-739Cancelled Feb 22, 1956 · Browne JackN1032KLuscombe 8A · S/N 3759Cancelled Feb 14, 1956 · Bowman CharlesN48071Aeronca 0-58B · S/N 058B-3162Cancelled Nov 25, 1955 · Tichacek Earl JN47352Aeronca 0-58B · S/N 058B-13574Cancelled Nov 18, 1955 · Marquette Flying ClubN70093Stinson V77 · S/N 77-255Cancelled Oct 25, 1955 · Reinert GlennN63943Timm N2T-1 · S/N 344Cancelled Oct 24, 1955 · Sarinske WalterN26387Aeronca 65-TC · S/N 1060Cancelled Oct 21, 1955 · Built 1940 · Fischer Walter C And Ash Clifford PN53307Cessna T-50 · S/N 5830Cancelled Oct 21, 1955 · Aldrich ArthurN1479KLuscombe 8A · S/N 4206Cancelled Oct 17, 1955 · Kalliomaa Elmer CN3773EAeronca 11AC · S/N 11AC-S 9Cancelled Oct 17, 1955 · Capital Drive Airport IncN63936Consolidated Vultee BT-13A · S/N 7141Cancelled Oct 13, 1955 · Gran AireN92600Piper J3C-65 · S/N 16965Cancelled Oct 12, 1955 · Club 13 IncN5732NPiper J3C-65 · S/N 13678Cancelled Oct 6, 1955 · William F LymanN17045Commonwealth REARWIN 7000 · S/N 523-SCancelled Oct 5, 1955 · Ray AndersonN86970Ercoupe 415-C · S/N 143Cancelled Aug 18, 1955 · Nicholas Paul MN76247Cessna 140 · S/N 10652Cancelled Aug 3, 1955 · Gehring ClydeN1676CCessna 180 · S/N 30376Cancelled Jul 5, 1955 · Exported to New Zealand · E A Knab Heating & Plumbing CoN81843Aeronca 7AC · S/N 7AC-466Cancelled May 23, 1955 · Anderson Air ActivitiesN27057Piper J4A · S/N 4-1005Cancelled May 13, 1955 · Arthur KiefertN3360KGlobe GC-1B · S/N 1353Cancelled Mar 30, 1955 · Sherman Lewis IIIN8822Stearman C3-R · S/N 5002Cancelled Mar 18, 1955 · Built 1929 · Fliteways IncN54735Fairchild M-62A · S/N T42-3197Cancelled Feb 21, 1955 · Last George CN44MLockheed B-34 · S/N 4820Cancelled Feb 9, 1955 · Miller Brewing CompanyN63931Fairchild M-62C · S/N 259Cancelled Jan 25, 1955 · Schneider Louis FN72365Cessna 140 · S/N 9551Cancelled Nov 4, 1954 · Gran Aire IncN79579Consolidated Vultee BT-13A · S/N 5791Cancelled Oct 25, 1954 · Gullickson Cecil FN8674KStinson 108-1 · S/N 108-1674Cancelled Sep 24, 1954 · Udovc John AN69803Consolidated Vultee BT-13A · S/N 2727Cancelled Jun 14, 1954 · Paul Howard PobereznyN23058Luscombe 8A · S/N 986Cancelled Jun 11, 1954 · Exported to Canada · Lein LeonardN9760HConsolidated Vultee BT-13A · S/N 9814Cancelled Feb 4, 1954 · Russell A Doutree & Edward W HenningN45516Luscombe 8A · S/N 2043Cancelled Jan 14, 1954 · Peter Dolan Ryan
Back to Milwaukee, WI