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.

N46791Fairchild M-62A · S/N T43-5870Cancelled Oct 26, 1953 · Gulczynski Frank JN86634Grumman G-44A · S/N 1460Cancelled Oct 7, 1953 · Everbrite Electric Signs IncN1163EAeronca 7AC · S/N 7AC-4719Cancelled Jul 7, 1953 · Bobs Air ServiceN95024Taylorcraft BC12-D · S/N 9424Cancelled Aug 6, 1952 · Jonas Ralph GN95122Taylorcraft BC12-D · S/N 9522Cancelled Aug 6, 1952 · Gehler Walter EN91576North American NAVION · S/N NAV-4-357Cancelled Feb 6, 1952 · Thill E George Dr.N3604KPiper J3C-65 · S/N 22295Cancelled Oct 16, 1951 · Pilling Lloyd ON6565KRepublic RC-3 · S/N 835Cancelled Oct 1, 1951 · Anderson Air ActivitiesN90087Cessna 140 · S/N 9148Cancelled Aug 14, 1951 · Hurin TonyN47230Fairchild M-62A · S/N T43-5511Cancelled Mar 12, 1951 · Drott Manufacturing CorpN36563Aeronca 65-LB · S/N LB16361Cancelled Oct 24, 1950 · Built 1941 · Sarinske WalterN6464KRepublic RC-3 · S/N 715Cancelled Oct 9, 1950 · Browne JackN498BBeech A35 · S/N D-1519Cancelled Jul 20, 1950 · General Door Manufacturing CoN98122Piper J3C-65 · S/N 18275Cancelled Jun 19, 1950 · Miller Lorraine GN77949Luscombe 8A · S/N 3676Cancelled Mar 24, 1950 · Lange Aviation CorpN6630KRepublic RC-3 · S/N 903Cancelled Jan 30, 1950 · Thiele Clarence EN48681Piper J3C-65 · S/N 10728Cancelled Jan 26, 1950 · Freese CharlesN3198NCessna 140 · S/N 13456Cancelled Dec 13, 1949 · Rapps ArthurN13566Waco UIC · S/N 3822Cancelled Aug 30, 1949 · Built 1933 · Kiefert ArthurN2399EAeronca 7AC · S/N 7AC-5979Cancelled Jun 6, 1949 · Capitol Drive Airport IncN73831Commonwealth/Irish 185 SKYRANGER · S/N 1890Cancelled Feb 24, 1949 · Mccotter Aviation CoN73834Commonwealth/Irish 185 SKYRANGER · S/N 1893Cancelled Feb 24, 1949 · Mccotter Aviation CoN73837Commonwealth/Irish 185 SKYRANGER · S/N 1896Cancelled Feb 24, 1949 · Mccotter Aviation CoN51373Fairchild M-62A · S/N T43-5063Cancelled Feb 9, 1949 · Fliteways IncN52458Ryan Aeronautical ST3KR · S/N 1394Cancelled Nov 22, 1948 · Brunt Bradlee Van JrN29350Waco UPF-7 · S/N 5377Cancelled Aug 4, 1948 · Fliteways IncN8487Parks P-2-A · S/N 103Cancelled Jul 14, 1948 · Badger Airways IncN5399Travel Air 4000 · S/N 505Cancelled Jul 13, 1948 · Milwaukee Airways IncN6614Waco GXE · S/N 1545Cancelled Jul 13, 1948 · Skelton Darold M And Skelton Donald PN21971Porterfield CP-50 · S/N 557Cancelled Jun 23, 1948 · Built 1939 · Badger Airways IncN7610National Airways System AIR KING · S/N 101Cancelled May 25, 1948 · Parks George JN37851Porterfield LP-65 · S/N 998Cancelled May 11, 1948 · Built 1941 · Young William DurantN16526Aeronca LB · S/N 2035Cancelled Apr 26, 1948 · Swan Clyde H JrN5060Hess HESS BLUE BIRD · S/N 22Cancelled Mar 11, 1948 · Built 1927 · Rosecrons John ON165HAeromarine-Klemm L-25 · S/N 2-23Cancelled Feb 18, 1948 · Built 1930 · Haasch George FerdinandN264HCurtiss Wright FLEDGLING · S/N B-41Cancelled Dec 16, 1947 · Central Aerial Corp Dustung CoN367KCurtiss Wright B · S/N 483Cancelled Oct 7, 1947 · Built 1931 · Pateman Ralph WaldoN11461Waco QCF · S/N 3536Cancelled Oct 3, 1947 · Built 1931 · Pilots IncN35101Piper J3C-65 · S/N 6106Cancelled Aug 7, 1947 · Fliteways IncN99615Engineering & Research 415-C · S/N 2238Cancelled Jun 24, 1947 · Anderson Air ActivitiesN99254Ercoupe 415-C · S/N 1877Cancelled Mar 13, 1947 · Huettner FrankN48224Fairchild M-62A · S/N 310SLCancelled Feb 3, 1947 · Anderson Air ActivitiesN93524Engineering & Research 415-C · S/N 847Cancelled Feb 3, 1947 · Built 1946 · Anderson Air ActivitiesN94371Ercoupe 415-C · S/N 1594Cancelled Feb 3, 1947 · Anderson Air ActivitiesN51193Cessna UC-78 · S/N 3878Cancelled Nov 7, 1945 · Board Of School DirectorsN51438Consolidated Vultee BT-13A · S/N 10107Cancelled Oct 29, 1945 · Board Of School DirectorsN14067Waco YMF · S/N 3963Cancelled Jan 22, 1941 · Built 1934 · Milwaukee Airways IncN379HGreat Lakes 2T-1 · S/N 14Cancelled Dec 23, 1940 · Laird Joseph JackN15883Porterfield 35-70 · S/N 183Cancelled Jul 23, 1939 · Milwaukee Flight ClubN18239Miller Irven A MILLER TWIN M-6 · S/N 4Cancelled May 28, 1939 · Irven Miller
Back to Milwaukee, WI