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.

N1560UCessna 207 · S/N 20700160Cancelled May 26, 1972 · Exported to Panama · Northwood Realty IncN7801FCessna 150F · S/N 150-63901Cancelled Dec 7, 1971 · West Allis Flying Club IncN999WPiper PA-23 · S/N 23-73Cancelled Dec 1, 1971 · Pokrass WillardN199NBeech G35 · S/N D-4653Cancelled Oct 26, 1971 · Exported to Canada · Ac Schulz Litho CoN6518DNorth American F-51 · S/N 44-63872Cancelled Oct 22, 1971 · Kuchinsky Thomas JN71350Luscombe 8A · S/N 2777Cancelled Oct 14, 1971 · Frank H James And Keller Gerald AN2280CCessna 180 · S/N 30580Cancelled Aug 17, 1971 · Frank A BartnikN5649VDehavilland BEAVER DHC-2 MK.1 · S/N 1285Cancelled Jun 16, 1971 · Exported to Canada · Robert HaackN3283RCessna 411A · S/N 411-0283Cancelled Apr 23, 1971 · Peck Meat Packing CorpN87352Ercoupe 415-C · S/N 525Cancelled Feb 19, 1971 · Whitecotton Fred GN7880PPiper PA-24 · S/N 24-3106Cancelled Jan 27, 1971 · Fliten IncN3870CGutzmann Gerald/Peterburs Carl LITTLE DEVIL/GP-1 · S/N 1Cancelled Jan 20, 1971 · Gutzmann Gerald E And Peterburs Carl FN32448Rearwin 175 · S/N 1537Cancelled Jan 19, 1971 · Block Robert SN47435Fairchild M-62A · S/N 9574AECancelled Jan 12, 1971 · Howard WearingN7757RBeech 36 · S/N E-111Cancelled Dec 30, 1970 · Mitchell Aero IncN2074PPiper PA-23 · S/N 23-668Cancelled Dec 4, 1970 · Bryant Harry LN2385VCessna 140 · S/N 14624Cancelled Dec 4, 1970 · Radlein Alexander WN61820Fairchild M-62A · S/N T42-1954Cancelled Oct 27, 1970 · Harvey Albert J JrN30850Piper J5A · S/N 5-269Cancelled Aug 31, 1970 · George GruenbergerN5736DPiper PA-22-150 · S/N 22-4436Cancelled Aug 19, 1970 · Exported to Guyana · South American Diamond Mining CoN30164Cessna 177 · S/N 17701092Cancelled Jun 29, 1970 · Midwest Airways IncN4393KRyan NAVION A · S/N NAV-4-1393Cancelled Jun 29, 1970 · Ottow Burton KeithN4733JBeech A23-19 · S/N MB-181Cancelled Jun 27, 1970 · Exported to Canada · Mitchell Aero IncN1869YCessna 172C · S/N 17249469Cancelled Jun 25, 1970 · Built 1962 · Monfre Peter RN2279Beech D18S · S/N A-266Cancelled Jun 1, 1970 · Judith Realty CorpN6794DBrantly B-2 · S/N 16Cancelled May 6, 1969 · Thomas H Grede/ Edward A GredeN6828UMooney M20D · S/N 187Cancelled Feb 11, 1969 · Built 1963 · West Allis Flying Club IncN84285Aeronca 7CCM · S/N 7AC-2979Cancelled Dec 30, 1968 · Sylvester H SchmidN7688CNorth American T-6G · S/N 49-3224Cancelled Oct 8, 1968 · Sixco IncN3005JCessna 150E · S/N 15061105Cancelled Sep 17, 1968 · Midwest Airways IncN6042TCessna 150D · S/N 150 60742Cancelled Sep 17, 1968 · Gran Aire IncN1173VGrumman G-44 · S/N 1345Cancelled Mar 3, 1967 · Nissen C GN1054ZLockheed T-33 · S/N 53-5994Cancelled May 18, 1966 · Milwaukee Vocational And Adult SchoolsN2402GCessna 182B · S/N 51702Cancelled Jan 4, 1966 · Hatco CorpN5091CBeech B35 · S/N D2353Cancelled Nov 29, 1965 · W A IncN286CStinson 108-2 · S/N 108-3286Cancelled Sep 27, 1965 · Hicks Donald KN89098Cessna 140 · S/N 8102Cancelled May 26, 1965 · Ken Cook CompanyN5884ECessna 150 · S/N 17384Cancelled May 24, 1965 · Gran Aire IncN6877DDehavilland VAMPIRE MK-3 · S/N 17069Cancelled May 23, 1965 · Exported to Canada · Ken Cook CoN4383APiper PA-18 · S/N 18-4790Cancelled May 20, 1965 · Wamser Carl HN5635HPiper PA-16 · S/N 16-246Cancelled May 20, 1965 · Alexander SmithN71439Luscombe 8A · S/N 2866Cancelled May 20, 1965 · Reinhardt Jerome WN9907HFairchild M-62A-4 · S/N T42-4070Cancelled May 20, 1965 · Lee Donald DN2417VCessna 140 · S/N 14663Cancelled May 19, 1965 · Weeks Leonard JrN1053ZLockheed T-33 · S/N 53-5995Cancelled May 18, 1965 · Milwaukee Vocational And Adult SchoolsN28582Luscombe 8C · S/N 1411Cancelled Oct 14, 1964 · Wayne R MyersN2043HEngineering & Research 415-D · S/N 2666Cancelled Jun 19, 1964 · Wisconsin Air Guard Aero ClubN9247EAeronca 11AC · S/N 11AC-881Cancelled Jun 15, 1964 · Exported to Mexico · Weber Carl JN63357Cessna T-50 · S/N 3825Cancelled Jan 6, 1964 · Air Shuttle LtdN50887Ryan Aeronautical ST3KR · S/N 2240Cancelled Sep 26, 1963 · Helminiak Raymond
Back to Milwaukee, WI