OpenAirDocs.org
Monroe, MI

Cancelled registrations · 62

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 = 'MONROE'
  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.

N491NXJoseph P Davis JR ONEX · S/N ONX0056Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 2012 · Smith Karl DN4491RCessna 172M · S/N 17263233Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1974 · Monroe Aviation School Of Flight LLCN2188EAeronca 7AC · S/N 7AC5762Cancelled Oct 25, 2019 · Revoked, canceled · Built 1946 · Bt 13 Flying ClubN619VHPiper PA 46-350P · S/N 4636402Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 2006 · Triple F Aviation LLCN777PQMesserschmitt-Bolkow-Blohm HANSA HFB 320 · S/N 1050Cancelled May 23, 2017 · Registration expired, pending cancellation · Grand Aire Express IncN168GASwearingen SA226TC · S/N TC207Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1973 · Grand Aire Express IncN266JJerred Jack KITFOX 2 · S/N 632Cancelled Mar 10, 2016 · Registration expired, pending cancellation · Built 1995 · Fry Richard NN7860UCessna 172F · S/N 17251860Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1964 · SottilesN6931LCessna 310K · S/N 310K0031Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1966 · SottilesN3600DCessna 310 · S/N 35300Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1956 · Sottile Joseph S Jr OwnerN3095MPiper PA-12 · S/N 12-1782Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1947 · Terrell Alton BN324AFHamburger Flugzeugbau HFB 320 HANSA · S/N 1064Cancelled Aug 23, 2013 · Sale reported, canceledN136MWHamburger Flugzeugbau HFB 320 HANSA · S/N 1036Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1969N35078Challenger CHALLENGER II · S/N CH2-0396Cancelled Aug 13, 2013 · Sale reported, canceled · Built 2007N2106NCessna 140 · S/N 12342Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Built 1947 · Sottile Joseph SN322AFHamburger Flugzeugbau HFB 320 HANSA · S/N 1058Cancelled Jul 30, 2013 · Sale reported, canceledN323AFHamburger Flugzeugbau HFB 320 HANSA · S/N 1062Cancelled Jul 30, 2013 · Sale reported, canceledN210RSDassault/Sud FAN JET FALCON SER C · S/N 18Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1965N105TFMesserschmitt-Bolkow-Blohm HANSA HFB 320 · S/N 1055Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1973N321AFHamburger Flugzeugbau HFB 320 HANSA · S/N 1060Cancelled Feb 27, 2013 · Sale reported, canceledN325AFHamburger Flugzeugbau HFB 320 HANSA · S/N 1065Cancelled Feb 21, 2013 · Sale reported, canceledN3634BBeech C-50 · S/N CH-197Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1955 · Architonics IncN320AFHamburger Flugzeugbau HFB 320 HANSA · S/N 1061Cancelled Sep 5, 2012 · Sale reported, canceledN7802WRoy Roger J SAVANNAH · S/N 02-10-51-174Cancelled Nov 16, 2010 · Exported to Australia · Built 2005 · Arsenault Maurice RN44389Piper PA-34-200 · S/N 34-7450208Cancelled Jul 27, 2010 · Exported to Mexico · Built 1974 · Ky-Syn Air LtdN1272Cessna 310G · S/N 310G0150Cancelled Jun 30, 2009 · Registration revoked · Built 1962 · Martin L Selvidge Excavating IncN4211GArsenault Maurice SAVANNAH · S/N 03-12-51-258Cancelled Aug 13, 2007 · Exported to Canada · Built 2004 · Arsenault Maurice RN128SDHamburger Flugzeugbau HFB 320 HANSA · S/N 1035Cancelled Jun 26, 2007 · Second triennial mailing, no response · Built 1969 · Grand Aire Express IncN1PTAero Commander 1121 · S/N 93Cancelled Apr 3, 1996 · Sale reportedN8406XCessna 172C · S/N 17248906Cancelled Apr 4, 1983 · Administratively canceled · Sottile Joseph S SrN63232Cessna 150M · S/N 15077190Cancelled Jan 24, 1983 · Sottile'SN68310Cessna 152 · S/N 152-82247Cancelled Aug 31, 1982 · Sottile Aviation IncN6609BCessna 310B · S/N 35709Cancelled May 8, 1981 · Settile Joseph S SrN73606Cessna 172M · S/N 17267575Cancelled Feb 21, 1980 · Exported to Canada · Sottile Aviation IncN7689KPiper PA-20 · S/N 20-511Cancelled Jun 9, 1975 · Fletcher William DavidN4508RPiper PA-28-140 · S/N 28-21208Cancelled Dec 11, 1973 · Exported to Canada · Brasher Martin WN3432DCessna 170B · S/N 26975Cancelled Aug 17, 1971 · Fox ErbyN63852Stinson L-5 · S/N 4620Cancelled Jul 14, 1971 · James IlgenfritzN604BBeech A35 · S/N D-1625Cancelled Nov 23, 1970 · Zorn William FN5668NCessna T-50 · S/N 2214Cancelled Oct 8, 1965 · Monroe Airways IncN3861KGlobe GC-1B · S/N 3561Cancelled May 20, 1965 · Jager DonaldN64425Consolidated Vultee BT-13B (SNV-2) · S/N 79-206Cancelled May 20, 1965 · Hoyt Kenneth CN9555HCessna T-50 · S/N 6295Cancelled May 20, 1965 · Hoyt Kenneth C SrN7270HPiper J3C-65 · S/N 20520Cancelled Apr 19, 1957 · Exported to Canada · Lambert JosephN34310Meyers OTW-145 · S/N 54Cancelled Feb 20, 1956 · Built 1941 · Giebel August H Et AlN5652NConsolidated Vultee BT-13A · S/N 8719Cancelled Feb 16, 1956 · B T Flying ClubN54958Cessna T-50 · S/N 5136Cancelled Nov 30, 1955 · Zorn William FN9461EAeronca 11AC · S/N 11AC-1099Cancelled Nov 17, 1955 · William F ZornN88676Piper J-3 · S/N 16304Cancelled Oct 24, 1955 · Oerther A WN51072Cessna T-50 · S/N 4497Cancelled Oct 20, 1955 · Cook Norman E
Back to Monroe, MI