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.

N27948Piper PA-31-350 · S/N 31-7952059Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Sac Air IncN27044Balloon Works FIREFLY 6B · S/N 6648Cancelled Sep 20, 2012 · Registration expired, pending cancellation · Sheeks Steven HN25583Cessna 152 · S/N 15280747Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1977 · Nichols Thomas JN324RKKempka Russell A JR RAF 2000 GTX SE · S/N 9694121000Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 2002 · Kempka Russell A JrN5NPAero Commander 681 · S/N 6042Cancelled Aug 10, 2012 · Revoked, canceled · Built 1970 · SpadN473TVEsselstyn Chris QUICKIE · S/N 473Cancelled Aug 7, 2012 · Registration pending, canceledN47313Interstate S-1B1 · S/N 97Cancelled Aug 6, 2012 · Revoked, canceled · Built 1943 · Mcbride George JN54595Lockheed 382C · S/N 382-4595Cancelled Jul 3, 2012 · Registration expired · Derco Aerospace IncN123VBeech 65-A90 · S/N LJ-258Cancelled Jun 12, 2012 · Registration expired, pending cancellation · Built 1967 · Milwaukee Area Technical CollegeN103RSmith Miniplane DSA-1 · S/N 00012Cancelled May 11, 2012 · Registration expired, pending cancellation · Built 1966 · Kalas John JN58DDShort Bros SD3-30 200 · S/N SH 3008Cancelled Feb 17, 2012 · Built 1977 · Acc Integrated Services IncN260AGShort Bros. & Harland SD3-30 · S/N SH3107Cancelled Feb 15, 2012 · Acc Integrated Services IncN939MAShort Bros. & Harland SD3-30 · S/N SH3047Cancelled Feb 15, 2012 · Built 1980 · Acc Integrated Services Inc DBAN330ACShort Bros. & Harland SD3-30 · S/N SH3007Cancelled Jan 26, 2012 · Built 1976 · Acc Integrated Services IncN3564Clark AQUA-GLIDER PG-1 · S/N 2014Cancelled Aug 19, 2011 · Revoked, pending cancellation · Clark Bentley WN2195WBeech B24R · S/N MC-285Cancelled Jun 28, 2011 · Registration pending, canceled · Built 1974N330KKDehavilland DHC-7-102 · S/N 33Cancelled Mar 30, 2011 · Exported to Canada · Aacme LLCN770DDDehavilland DHC-7-102 · S/N 77Cancelled Mar 30, 2011 · Exported to Canada · Aacme LLCN348LTin Wind 3 · S/N 5-400Cancelled Dec 22, 2010 · Revoked, pending cancellation · Built 1960 · Podawiltz Norbert JN900UCessna 152 · S/N 15285303Cancelled Apr 5, 2010 · Exported to Philippines · Built 1981 · Safe Air CorpN699CZBeech 99A · S/N U-133Cancelled Feb 3, 2010 · Triennial form not returned · Built 1969 · Freight Runners Express IncN8433PPiper PA-24-400 · S/N 26-18Cancelled Sep 15, 2009 · Registration revoked · Built 1964 · Synergetics IncN728QACessna 402A · S/N 402A0068Cancelled Aug 18, 2009 · Triennial form not returned · Built 1969 · Freight Runners Express IncN32325Porterfield LP-65 · S/N 783Cancelled Jul 27, 2009 · Registration revoked · Built 1940 · Kobus James AN1368RGrumman American Avn. AA-5 · S/N AA5-0768Cancelled Jun 30, 2009 · Registration revoked · Built 1975 · Panther Aero LtdN937MAShort Bros. & Harland SD3-30 · S/N SH-3040Cancelled Jun 16, 2009 · Triennial form not returned · Built 1980 · Air Cargo Carriers IncN106HBeech D18S · S/N A-526Cancelled May 1, 2009 · Registration revoked · Built 1950 · Central Air FreightingN748CCShort Bros SD3-60 · S/N SH3748Cancelled Feb 15, 2008 · Triennial form not returned · Built 1988 · Air Cargo Carriers IncN8422CLeclercq John F RANS S-6S/XL · S/N 0895873Cancelled Dec 7, 2007 · Exported to New Zealand · Built 2000N65875Cessna 172P · S/N 17275910Cancelled Nov 21, 2007 · Triennial form not returned · Built 1983 · Grand-Aire IncN9390XCessna 182E · S/N 18253790Cancelled Dec 14, 2006 · Triennial form not returned · Built 1962 · Hy Sky Promotions IncN9239GLockheed 382C · S/N 382-4988Cancelled May 25, 2006 · Exported to NetherlandsN14781Lockheed 382C · S/N 382-4781Cancelled May 23, 2006 · Exported to Netherlands · Derco Aerospace IncN3735WShort Bros SD 3-60-100 · S/N SH-3735Cancelled Apr 18, 2006 · Air Cargo Carriers IncN50923Cessna 172P · S/N 17274234Cancelled Nov 29, 2005 · Exported to Mexico · Built 1980 · Gran Aire IncN335MVShort Bros. & Harland SD3-30 · S/N SH 3017Cancelled Feb 25, 2005 · Triennial form not returned · Built 1978 · Air Cargo Carriers IncN55ANShort Bros. & Harland SD3-30 · S/N SH-3025Cancelled Sep 27, 2004 · Triennial form not returned · Air Cargo Carriers IncN691AShort Bros SHORTS SD3-60 · S/N SH3618Cancelled Sep 7, 2004 · Triennial form not returned · Built 1983 · Air Cargo Carriers IncN399CZBeech 99 · S/N U52Cancelled Aug 20, 2004 · Triennial form not returned · Built 1969 · Freight Runners Express IncN501MEDouglas DC-9-32 · S/N 47132Cancelled Jun 3, 2004 · Exported to South Africa · Built 1968 · Midwest Airlines IncN301MEDouglas DC-9-32 · S/N 47190Cancelled Mar 25, 2004 · Exported to South Africa · Built 1968 · Midwest Airlines IncN302MEDouglas DC-9-32 · S/N 47102Cancelled Mar 5, 2004 · Exported to South Africa · Midwest Airlines IncN401MEDouglas DC-9-32 · S/N 47133Cancelled Dec 23, 2003 · Exported to Colombia · Built 1968 · Midwest Airlines IncN205MEDouglas DC-9-32 · S/N 47601Cancelled May 16, 2003 · Exported to Swaziland · Built 1974 · M And I First National Leasing CorpN80MEDouglas DC-9-14 · S/N 45795Cancelled Jan 3, 2003 · Triennial form not returned · Built 1966 · Midwest Express Airlines IncN900MEMcdonnell Douglas DC-9-15 · S/N 45841Cancelled Dec 17, 2002 · Exported to Colombia · Midwest Express Airlines IncN800MEDouglas DC-9-14 · S/N 45842Cancelled Oct 29, 2002 · Exported to Colombia · Built 1966 · Midwest Express Airlines IncN3729UBeech 77 · S/N WA-144Cancelled Oct 3, 2002 · Second triennial mailing, no response · Built 1980 · Krogstad Bruce HN400MEDouglas DC-9-14 · S/N 45727Cancelled Apr 29, 2002 · Triennial form not returned · Built 1966 · Midwest Express Airlines IncN4532QCessna 402A · S/N 402A0032Cancelled Oct 3, 2001 · Triennial form not returned · Built 1969 · Freight Runners Express Inc
Back to Milwaukee, WI