Pontiac, MI

Cancelled registrations · 159

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

N41PCDassault/Sud FAN JET FALCON · S/N 19Cancelled Jul 8, 1996 · Exported to Canada · Agl IncN70903Cessna U206F · S/N U20602108Cancelled Jan 10, 1996 · 2501 Williams IncN77CZBeech D18S · S/N A198Cancelled Jun 6, 1995 · Triennial form not returned · Royal Air IncN93604Cessna 152 · S/N 15285526Cancelled Oct 24, 1994 · Second triennial mailing, no response · Tradewinds Aviation IncN440YGreat Lakes 2T-1 · S/N 157Cancelled Aug 3, 1994 · Triennial form not returned · Abc Flight Service IncN3891SCessna 172E · S/N 17251091Cancelled Jun 16, 1993 · Triennial form not returned · Hylift Aero IncN2668NDouglas C-47 · S/N 11982Cancelled May 14, 1991 · Exported to Spain · Century Airlines IncN4252UMattoon Floyd HUMMER-B · S/N 0060BCancelled Apr 16, 1991 · Triennial form not returned · Mattoon Floyd KN563WBeech E18S · S/N BA139Cancelled Mar 29, 1991 · Triennial form not returned · Royal Air Freight IncN6750PBeech G18S · S/N BA496Cancelled Feb 4, 1991 · Exported to Venezuela · Royal Air Freight IncN5692LEnstrom Helicopter 280C · S/N 1177Cancelled May 14, 1985 · Pdq Air Service IncN30618Cessna 177A · S/N 17701364Cancelled Jan 11, 1982 · Exported to Sri Lanka · Built 1969 · Barbara Flying Service IncN9633RBeech G18S · S/N BA-479Cancelled Jan 5, 1981 · Sale reported · Built 1959N427QBeech D18S · S/N A336Cancelled Dec 17, 1980 · Built 1946 · Wyman Pilot Service IncN11ZBBeech G18S · S/N BA-510Cancelled Dec 16, 1980 · Built 1960 · Wyman Pilot Service IncN180PBeech G18S · S/N BA-478Cancelled Dec 16, 1980 · Built 1959 · Wyman Pilot Service IncN438ABeech E18S · S/N BA452Cancelled Dec 16, 1980 · Wyman Pilot Service IncN80369Beech D18S · S/N A-157Cancelled Nov 12, 1980 · Wyman Pilot Service IncN50713Bellanca 8KCAB-180 · S/N 62280Cancelled Oct 9, 1980 · Exported to Canada · Tradewinds Aircraft Sales IncN1812DBeech D18S · S/N A-826Cancelled Jul 1, 1980 · Built 1952 · Wyman Pilot Service IncN5CQAerotek PITTS S-2A · S/N 2110Cancelled Mar 12, 1980 · Exported to United Kingdom · Built 1975 · Chappell Harold R JrN955GPBeech H-18 · S/N BA-620Cancelled Mar 10, 1978 · Northern Flying ServiceN2135LBeech A36 · S/N E-891Cancelled Nov 8, 1977 · Roy LilleyN4906BBeech E18S · S/N BA-89Cancelled Jul 6, 1977 · Wyman Morrey LN150GLCessna 150M · S/N 15075904Cancelled May 10, 1977 · Exported to Canada · Built 1974 · G.B. Dupont Co Incdba Great Lakes AeroN201GLMooney M20J · S/N 24-0029Cancelled Mar 25, 1977 · Exported to Canada · G B Dupont Co Inc DBA Great Lakes AeroN7507GCessna 150L · S/N 15074675Cancelled May 19, 1976 · Exported to Canada · G B Dupont Co IncN172GLCessna 172M · S/N 172-63630Cancelled May 3, 1976 · Exported to Canada · G B Dupont Co IncN66066Cessna 150M · S/N 15075811Cancelled Mar 12, 1976 · Exported to Canada · G B Dupont Co IncN19357Cessna 150L · S/N 15074361Cancelled Nov 20, 1975 · Exported to Canada · Built 1973 · G B Dupont Co IncN2368Beale BENSEN B-8M · S/N 1Cancelled Oct 6, 1975 · Built 1970 · Beale James AN74181Douglas C54B-DC · S/N 27236Cancelled Sep 26, 1975 · Cryderman Air ServiceN5268WPiper PA-28-160 · S/N 28-314Cancelled Aug 30, 1975 · Exported to Canada · Built 1962 · Martin Aviation Sales Co IncN11RLCessna 172M · S/N 17262868Cancelled Aug 11, 1975 · Exported to Canada · Built 1974 · G B Dupont Co IncN12660Cessna 172M · S/N 172 62155Cancelled Jul 16, 1975 · Exported to Canada · Great Lakes Aero Div Of G B/ Dupont Co IncN7590GCessna 172L · S/N 17259290Cancelled Jul 15, 1975 · Pontiac Flight Service IncN7333RBeech B-60 · S/N P-276Cancelled May 29, 1975 · Exported to France · Aerodynamics IncN193CPBeech D18S · S/N A-830Cancelled May 7, 1975 · Wyman Morrey LN5990GCessna 150K · S/N 15071490Cancelled Jan 9, 1975 · Exported to Canada · Commander Flight Service IncN6463SCessna 150H · S/N 15067263Cancelled Dec 31, 1974 · Jones Denver SrN74182Douglas C54D-DC · S/N 10746Cancelled Dec 11, 1974 · Exported to Belgium · Cryderman Air ServiceN7511JPiper PA-28R-180 · S/N 28R-30878Cancelled Oct 9, 1974 · Exported to Canada · Pontiac Piper IncN8548GCessna 150G · S/N 15066908Cancelled Sep 25, 1974 · Mcgran Wilfred EN51403Cessna 150J · S/N 15069984Cancelled Jun 20, 1974 · Exported to Canada · Built 1968 · Martin Aviation Sales Co IncN6922GCessna 150L · S/N 150-72422Cancelled Jun 14, 1974 · Exported to Canada · Martin Aviation Sales Co IncN6594SCessna 150 · S/N 15067394Cancelled Jun 7, 1974 · Exported to Canada · Detroit Aviation Sales CorpN7385QCessna 182P · S/N 18261025Cancelled May 9, 1974 · Exported to Canada · Great Lakes AeroN387BBeech E18S-9700 · S/N BA-410Cancelled Feb 12, 1974 · Wyman Morrey LN42282Cessna 182 · S/N 18258943Cancelled Jan 11, 1974 · Exported to Canada · Built 1968 · Martin Aviation Salses Co IncN6652GCessna 150L · S/N 15072152Cancelled Nov 21, 1973 · Exported to Canada · Martin Aviation Sales Co Inc
Back to Pontiac, MI