OpenAirDocs.org
Muskegon, MI

Cancelled registrations · 117

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 = 'MI' AND d.registrant_city = 'MUSKEGON'
  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.

N14959Embraer EMB-145LR · S/N 145091Cancelled Mar 3, 2023 · Registration expired, pending cancellation · Built 1998 · Aerovision Aircraft Services LLCN366DFEmbraer ERJ145MP · S/N 145406Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Avi Sales & Leasing Services LLCN177MBCessna 177B · S/N 17701844Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1972 · Beaver Marjorie FN13964Embraer EMB-145LR · S/N 145123Cancelled Oct 21, 2022 · Registration expired · Built 1999 · Avi Sales & Leasing Services LLCN13965Embraer EMB-145LR · S/N 145125Cancelled Oct 21, 2022 · Registration expired · Built 1999 · Avi Sales & Leasing Services LLCN860MJEmbraer EMB-145LR · S/N 145773Cancelled Oct 21, 2022 · Registration expired · Built 2003 · Avi Sales & Leasing Services LLCN77427Cessna 120 · S/N 11868Cancelled Mar 29, 2021 · Second renewal notice · Hughey Randal PN223SWEmbraer EMB-120ER · S/N 120.291Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1995 · Aerovision Engine Services LLCN292SWEmbraer EMB-120ER · S/N 120.319Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1996 · Aerovision Engine Services LLCN295SWEmbraer EMB-120ER · S/N 120.322Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1996 · Aerovision Engine Services LLCN857MJEmbraer EMB-145LR · S/N 145765Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 2003 · Avi Sales & Leasing Services LLCN858MJEmbraer EMB-145LR · S/N 145767Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 2003 · Avi Sales & Leasing Services LLCN648BCEmbraer ERJ 190-100 IGW · S/N 19000022Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Aerovision Aircraft Services LLCN832MJEmbraer EMB-145LR · S/N 145310Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 2000 · Aerovision Aircraft Services LLCN838MJEmbraer EMB-145LR · S/N 145384Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 2001 · Aerovision Aircraft Services LLCN849MJEmbraer EMB-145LR · S/N 145534Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 2001 · Aerovision Aircraft Services LLCN852MJEmbraer EMB-145LR · S/N 145567Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 2002 · Aerovision Aircraft Services LLCN855MJEmbraer EMB-145LR · S/N 145614Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 2002 · Aerovision Aircraft Services LLCN14925Embraer EMB-145EP · S/N 145004Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1996 · Avi Sales & Leasing Services LLCN16927Embraer EMB-145EP · S/N 145.006Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1996 · Avi Sales & Leasing Services LLCN851HKEmbraer EMB-145LR · S/N 145340Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2000 · Aerovision Aircraft Services LLCN852HKEmbraer EMB-145LR · S/N 145353Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2000 · Aerovision Aircraft Services LLCN14945Embraer EMB-145EP · S/N 145049Cancelled Jan 16, 2019 · Registration expired, pending cancellation · Built 1998 · Aerovision Aircraft Services LLCN97442Stinson 108 · S/N 108442Cancelled Jan 16, 2019 · Revoked, canceled · Built 1946 · Muskegon County Flying ClubN491PTCessna 500 · S/N 500-0102Cancelled Mar 26, 2018 · Registration expired, pending cancellation · Built 1973 · Aerovision Aircraft Services LLCN911UNDassault-Breguet FALCON 10 · S/N 122Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1979 · Aerovision International LLCN575WWGates Lear Jet 35 · S/N 043Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1976 · Aerovision International LLCN4090VHaggenmacher Scott MERLIN GT · S/N 94013Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1994 · Merlin Aircraft IncN233VPiper PA-31-310 · S/N 31-396Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1969 · Mkg Leasing LLCN2542VBuckeye BUCKEYE · S/N 5091Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 2001 · Benedict Joseph LN4295FCessna 172 · S/N 46195Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1958 · Nygren Kirk DN15948Embraer EMB-145EP · S/N 145056Cancelled Jul 11, 2016 · Exported to Senegal · Built 1998 · Msn145056 LLCN831MJEmbraer EMB-145LR · S/N 145273Cancelled Nov 17, 2015 · Built 2000 · Aerovision Aircraft Services LLCN825MJEmbraer EMB-145LR · S/N 145179Cancelled Oct 22, 2015 · Built 2000 · Aerovision Aircraft Services LLCN826MJEmbraer EMB-145LR · S/N 145214Cancelled Oct 22, 2015 · Built 2000 · Aerovision Aircraft Services LLCN828MJEmbraer EMB-145LR · S/N 145218Cancelled Oct 22, 2015 · Built 2000 · Aerovision Aircraft Services LLCN829MJEmbraer EMB-145LR · S/N 145228Cancelled Oct 22, 2015 · Built 2000 · Aerovision Aircraft Services LLCN830MJEmbraer EMB-145LR · S/N 145259Cancelled Oct 22, 2015 · Built 2000 · Aerovision Aircraft Services LLCN851MJEmbraer EMB-145LR · S/N 145572Cancelled Aug 31, 2015 · Second renewal notice · Built 2002 · Aerovision Aircraft Services LLCN854MJEmbraer EMB-145LR · S/N 145490Cancelled Aug 31, 2015 · Built 2002 · Aerovision Aircraft Services LLCN14960Embraer EMB-145LR · S/N 145100Cancelled Aug 6, 2015 · Sale reported · Built 1998N902DDCessna 500 · S/N 500-0126Cancelled Apr 6, 2015 · Sale reportedN833MJEmbraer EMB-145LR · S/N 145327Cancelled Mar 30, 2015 · Built 2000 · Aerovision Aircraft Services LLCN836MJEmbraer EMB-145LR · S/N 145359Cancelled Mar 30, 2015 · Built 2000 · Aerovision Aircraft Services LLCN837MJEmbraer EMB-145LR · S/N 145367Cancelled Mar 30, 2015 · Built 2001 · Aerovision Aircraft Services LLCN842MJEmbraer EMB-145LR · S/N 145457Cancelled Mar 30, 2015 · First renewal notice · Built 2001 · Aerovision Aircraft Service LLCN843MJEmbraer EMB-145LR · S/N 145478Cancelled Mar 30, 2015 · First renewal notice · Built 2001 · Aerovision Aircraft Services LLCN845MJEmbraer EMB-145LR · S/N 145502Cancelled Mar 30, 2015 · First renewal notice · Built 2001 · Aerovision Aircraft Services LLCN827MJEmbraer EMB-145LR · S/N 145217Cancelled Mar 13, 2015 · First renewal notice · Built 2000 · Aerovision Aircraft Services LLCN8125RAero Vodochody L39C · S/N 332449Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1983 · Jet Team LLC
Back to Muskegon, MI