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.

N962HMoth 60-GM · S/N 62Cancelled May 15, 1939 · Built 1929 · Spangler EdmundN373HMoth 60-GM · S/N 1LCancelled Jan 28, 1938 · Martine Arlo Et AlN12070Raymond B Malley MALLEY · S/N M-3Cancelled Feb 15, 1937 · Raymond B MalleyN850KGreat Lakes GREAT LAKES 4A-1 · S/N 100Cancelled Apr 15, 1936 · Built 1929 · Trier PaulN809VWaco NAZ · S/N 4007Cancelled Apr 1, 1936 · Homer F TangneyN12996Ray Besasie BESASIE · S/N 2Cancelled Mar 15, 1936 · Built 1933 · Besasie RayN13608Pietenpol AIR CAMPER · S/N 1-A-ACancelled Jan 27, 1936 · Built 1933 · Runte Roman J JN12077Ashton Charles Johnson JOHNSON J-1 · S/N 101ACancelled Jun 1, 1935 · Walter P KetterN10312Aeronca C-2 · S/N A-78Cancelled Feb 13, 1935 · Gettelman RobertN14090Aeronca C-3 · S/N A-313Cancelled Oct 12, 1934 · Pewaukee Seaplane Base IncN12094N M Rowinski TM-1 · S/N M-200Cancelled Aug 8, 1934 · Oscar SchmidtN13613Falke Carl PARASOL · S/N 1Cancelled Jul 1, 1934 · Built 1933 · Falke CarlN12089Ralph Kofler KOFLER SPECIAL · S/N 5Cancelled Jun 27, 1934 · Ralph R KoflerN12038Harry Flasch FLASCH PARASOL · S/N 100Cancelled Aug 1, 1933 · Flasch HarryN844MWilliam H Getzin JR CABIN MONOPLANE · S/N 1-CDCancelled Feb 9, 1933 · Getzin William H JrN1155Standard J-1 · S/N 22610Cancelled Feb 3, 1933 · Roman Frank Harry Pedersen & Vern CanningN10498Meyer Ben MEYER GLIDER · S/N BM-1Cancelled Jan 7, 1933 · Built 1930 · Meyer BenedictN11139Great Lakes 2T-1A · S/N 187Cancelled Aug 24, 1932 · Built 1931 · Holterhoff Flying Service IncN7909Curtiss Robertson Airplane Mfg B · S/N 35Cancelled Jun 8, 1931 · George L LandisN522NCurtiss THRUSH J · S/N 1001Cancelled Apr 23, 1931 · Curtiss Wright Flying Service A Maine CorpN9498Harved HARVED MONOPLANE · S/N 4Cancelled Jul 23, 1930 · Calbo HarveyN686Curtiss Wright JN4C · S/N UNKNOWNCancelled May 22, 1930 · Francke George CN798KPriebe Chris PRIEBE · S/N 1Cancelled May 22, 1930 · Built 1929 · Priebe ChrisN5562Hamilton Metalplane H-45 · S/N 43Cancelled May 19, 1930 · Exported to Peru · Boeing Airplane Co Hamilton Metaplane DivisionN371HHamilton Metalplane H47 · S/N 61Cancelled May 9, 1930 · Exported to Canada · Boeing Airplane CoN2283Curtiss JN4D · S/N 17Cancelled May 7, 1930 · Peterson Thor HN1878Hess HESS BLUE BIRD · S/N 36Cancelled Apr 30, 1930 · Built 1927 · Phoenix Aircraft CorpN93NW W Gehde GEHDE SPORT BIPLANE · S/N 1 SUBCancelled Apr 30, 1930 · Weyher Fred JN466EHamilton Metalplane H47 · S/N 58Cancelled Mar 14, 1930 · Hamilton Metalplane CoN416EHamilton Metalplane H-45 · S/N 59Cancelled Feb 7, 1930 · Built 1929 · Hamilton Metalplane CompanyN133EHamilton Metalplane H47 · S/N 57Cancelled Apr 19, 1929 · Hamilton Metalplane CoN533Hamilton Metalplane H47 · S/N 64Cancelled Apr 19, 1929 · Hamilton Metalplane CompanyN1804Curtiss STANDARD J-1 · S/N N-138Cancelled Feb 14, 1929 · Built 1927 · Nevell R CN5694Waco 10 · S/N A-8Cancelled Oct 20, 1928 · Auer Stuart FN1158Waco 9 · S/N 388Cancelled Apr 28, 1928 · Built 1927 · Bukolt Alexander AN19003Taylorcraft A · S/N 109Cancellation date not recorded · Poberezny Paul HN2400EAeronca 7AC · S/N 7AC-5980Cancellation date not recorded · Built 1946 · Anderson Air ActivitiesN29346Waco UPF-7 · S/N 5373Cancellation date not recorded · Fliteways IncN6509Waco 10 · S/N 1680Cancellation date not recorded · Alfred B Ferko
Back to Milwaukee, WI