OpenAirDocs.org
Lapeer, MI

Cancelled registrations · 46

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

N7376BBeech E35 · S/N D-3839Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1954 · Bostick Douglas EN2958RPiper PA-34-200T · S/N 34-7970403Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1979 · Sweetwater Drilling Supplies IncN105ACAmerican Champion 8KCAB · S/N 647-91Cancelled Sep 25, 2013 · Registration expired, pending cancellation · Built 1991 · Lumley Allan CN374FGInfinity Power Parachutes INFINITY 984IP-262 · S/N ITP4-262Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Goode Danny DN1468ACessna 172S · S/N 172S10445Cancelled Feb 19, 2013 · Exported to New Zealand · Built 2007 · Stargate Holdings LLCN4343XPiper PA-32-260 · S/N 32-7600001Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1975 · Linton Royce Alton DrN8048UDestiny Powered Parachute DESTINY 2000 · S/N 1B0040Cancelled Sep 12, 2012 · Registration pending, canceled · Built 2007N444CJCurtiss Charles W EIPPER/CURTISS MXL-2 · S/N 1034Cancelled Apr 13, 2009 · Triennial form not returned · Curtiss Charles WN55CWBellanca 7ECA · S/N 1294-79Cancelled Apr 8, 2009 · Triennial form not returned · Built 1979 · Sutton Aviation IncN711WKBellanca 7ECA · S/N 111575Cancelled Jan 23, 1996 · Exported to Mexico · Dupont Lapeer Enterprises IncN5396UCessna 210N · S/N 21064887Cancelled Jan 22, 1991 · Exported to Brazil · G B Dupont Co IncN6659FCessna 150F · S/N 15063259Cancelled Sep 26, 1984 · Matas John LN7088ACessna 172 · S/N 29188Cancelled Jan 31, 1978 · Exported to Canada · G B Dupont Co IncN4293CSchleicher KA 6 CR · S/N 6395Cancelled Apr 4, 1975 · Exported to Canada · Built 1967 · Tucker Robert HN1446CPiper PA-22-135 · S/N 22-1198Cancelled Nov 15, 1972 · Exported to Canada · G. B. Dupont Co IncN24291Aeronca 65-C · S/N C-7570Cancelled Jul 14, 1971 · Built 1940 · Slate James LN40184Stinson 108 · S/N 108-114Cancelled Apr 29, 1971 · G B Dupont Co IncN7715JPiper PA-32-260 · S/N 32-1117Cancelled Aug 14, 1970 · Exported to New Zealand · G B Dupont Co IncN3492KPiper PA-28-140 · S/N 28-23583Cancelled Oct 25, 1968 · G B Dupont Co IncN5067HPiper PA-11 · S/N 11-966Cancelled Sep 27, 1963 · Exported to Canada · G B Dupont Co IncN94059Ercoupe 415-C · S/N 1382Cancelled Jun 21, 1962 · Exported to Canada · G B Dupont Co IncN929APiper PA-22 · S/N 22-234Cancelled Jun 20, 1962 · Exported to Canada · G B Dupont Co IncN1586BLuscombe 8E · S/N 6213Cancelled May 9, 1960 · Exported to Canada · Built 1948 · Gb Dupont Co IncN55874Cessna T-50 · S/N 4334Cancelled Jan 23, 1960 · Harris JamesN8893CPiper PA-22-135 · S/N 22-1473Cancelled Nov 19, 1959 · Exported to Canada · G B Dupont Co IncN3457EAeronca 7AC · S/N 7AC 6846Cancelled May 1, 1959 · Exported to Canada · G B Dupont CoN85467Aeronca 7AC · S/N 7AC-4207Cancelled Sep 2, 1958 · Exported to Canada · Frank LoweN97027Consolidated Vultee BT-13A · S/N 8095Cancelled Aug 4, 1949 · Built 1946 · Sturgeon Sam C.N97067Consolidated/Nocco C VULTEE BT-13 · S/N 2763Cancelled Aug 4, 1949 · Built 1941 · Sturgeon Sam C.N36972Aeronca 65-TAF · S/N 4212Cancelled Jan 5, 1949 · Lapeer Airport IncN52305Aeronca L-3C · S/N 6732Cancelled Nov 18, 1948 · Built 1945 · Lapeer Airport IncN52452Aeronca L-3 · S/N 058B1882Cancelled Nov 18, 1948 · Built 1945 · Lapeer Airport IncN51405Taylorcraft DCO-65 · S/N 5560Cancelled Nov 15, 1948 · Lapeer Airport IncN51410Taylorcraft BL-65 · S/N 3062Cancelled Nov 10, 1948 · Lapeer Airport IncN49664Boeing A75N1 · S/N 75-2464Cancelled Nov 9, 1948 · Noble J FreudenthalN49651Boeing PT-17 · S/N 75-2463Cancelled Nov 4, 1948 · Lapeer Airport IncN26495Berk Glen W A · S/N 3Cancelled Sep 28, 1948 · Lapeer Airport IncN38844Piper J3L-65 · S/N 7331Cancelled Sep 16, 1948 · Built 1941 · Lapeer Airport IncN33794Aeronca 65-TL · S/N 9531Cancelled Aug 20, 1948 · Lapeer Airport IncN33834Aeronca 65-TL · S/N 9681Cancelled Aug 20, 1948 · Lapeer Airport IncN34612Stinson 10A · S/N 8012Cancelled Aug 17, 1948 · Lapeer Airport IncN97008Consolidated Vultee BT-13 · S/N 3026Cancelled Aug 4, 1948 · Sturgeonsam C.N47246Taylorcraft DC-65 · S/N 4009Cancelled Jun 17, 1948 · Freudenthal NobleN9942HConsolidated Vultee BT-13A · S/N 5335Cancelled Apr 29, 1948 · Freudenthal Noble JN9943HConsolidated Vultee BT-13A · S/N 9324Cancelled Apr 28, 1948 · Freudenthal Noble JN34300Meyers OTW · S/N 44Cancelled Nov 19, 1945 · Lapeer Airport Inc
Back to Lapeer, MI