Minot, ND

Cancelled registrations · 146

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 = 'ND' AND d.registrant_city = 'MINOT'
  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.

N7034FCessna 150F · S/N 15063634Cancelled Jan 22, 1991N10094Cessna 150L · S/N 15074790Cancelled Sep 4, 1990 · Registration expired, pending cancellation · Built 1973 · Pietsch Flying ServiceN6095QMooney M20C · S/N 3262Cancelled Oct 14, 1981 · Pietsch Alfred CN6335LAmerican AA-1B · S/N AA1B-0035Cancelled Jan 12, 1981 · Crosswinds Aero ClubN8585VBellanca 7KCAB · S/N 49975Cancelled Apr 25, 1980 · Exported to Canada · And Mar IncN11719Bellanca 8KCAB · S/N 27-72Cancelled Dec 4, 1979 · Exported to Canada · Silverman Michael WN758BBCessna R172K · S/N R1722955Cancelled Dec 6, 1978 · Exported to Canada · Aero Flight IncN65553Cessna 152 · S/N 152-81615Cancelled Nov 20, 1978 · Exported to Canada · Aero Flight IncN2774WMooney M20C · S/N 3358Cancelled Apr 5, 1978 · Exported to Canada · Pietsch Flying ServiceN481YTPiper PA-28-140 · S/N 28-24081Cancelled Mar 25, 1977 · Exported to Canada · Brothers Robert & Peterson John CN6946VMooney M20F · S/N 22-1319Cancelled Jan 21, 1977 · Exported to Canada · Pietsch Alfred CN35572Cessna 172I · S/N 17256843Cancelled Dec 28, 1976 · Exported to Canada · Built 1968 · Pietsch Alfred C DBA Pietsch Flying ServiceN6060JCessna A150L · S/N A1500360Cancelled Nov 23, 1976 · Exported to Canada · And-Mar IncN7094TCessna 172 · S/N 46694Cancelled May 26, 1976 · Anderson Leonard EN7663JPiper PA-28R-180 · S/N 28R-30968Cancelled Mar 17, 1976 · Exported to Canada · Built 1968N53926Bellanca 7ECA · S/N 114776Cancelled Feb 25, 1976 · Exported to Canada · Alfred Pietsch DBA Pietsch Flying ServiceN8715VBellanca 7KCAB · S/N 522-75Cancelled Feb 10, 1976 · Exported to Canada · Pietsch AlfredN6800VMooney M20C · S/N 700087Cancelled Feb 2, 1976 · Revoked, canceled · Built 1970 · Cloud Modification Service IncN2231JCessna 150G · S/N 15065431Cancelled Oct 30, 1975 · Exported to Canada · Air Mart IncN7705VAero Commander CALLAIR A-9B · S/N 1456Cancelled Oct 29, 1975 · Sale reported · Built 1969N8268BCessna 172 · S/N 36068Cancelled Sep 2, 1975 · Exported to Canada · Stanley Jordan HN61650Cessna 172M · S/N 17264701Cancelled Aug 22, 1975 · Exported to Canada · Aero Flight IncN1508QCessna 150L · S/N 15072808Cancelled Jul 1, 1975 · Aero Flight IncN35583Cessna 172 · S/N 17256850Cancelled May 28, 1975 · Exported to Canada · Built 1968 · And-Mar IncN87081Bellanca 8GCBC · S/N 65-74Cancelled May 7, 1975 · Exported to Canada · Pietsch Flying Service/ Alfred C PietschN2460HEngineering & Research ERCOUPE 415-C · S/N 3085Cancelled Apr 25, 1975 · Exported to Canada · Curle Kenneth JN4165CStinson 108-3 · S/N 108-5165Cancelled Dec 23, 1974 · Exported to Canada · Built 1950 · Anderson LeonardN34089Cessna 177B · S/N 17701634Cancelled Dec 11, 1974 · Exported to Canada · Aero Flight IncN5507PPiper PA-24-250 · S/N 24534Cancelled Sep 19, 1974 · Exported to Canada · Gelking Victor LN1761PPiper PA-18-150 · S/N 18-4084Cancelled Jul 10, 1974 · Bischke KentonN20461Cessna 172M · S/N 17261306Cancelled Jul 5, 1974 · Exported to Canada · Aero Flight IncN9888DPiper PA-18-150 · S/N 18-6912Cancelled Jul 5, 1974 · Goodman Myron MN8122BCessna 172 · S/N 29922Cancelled May 29, 1974 · Exported to Canada · Lohse VernonN9508LAmerican AA-5 · S/N AA5-0108Cancelled Feb 1, 1974 · Exported to Canada · Built 1972 · Pietsch Alfred CN90922Bellanca 7KCAB · S/N 340-73Cancelled Nov 8, 1973 · Pietsch Alfred CN25163Luscombe 8A · S/N 1087Cancelled Oct 18, 1973 · Exported to Canada · Anderson Leonard E Anderson Evelyn HN36029Bellanca 7GCBC · S/N 537-73Cancelled Sep 17, 1973 · Exported to Canada · Built 1973 · Pietsch Alfred C DBAN6733BPiper PA-22-150 · S/N 22-4066Cancelled May 1, 1973 · Exported to Canada · Muus Donald GN5846LAmerican AA-5 · S/N AA5-0046Cancelled Apr 3, 1973 · Exported to Canada · Pietsch Alfred CN1273XMooney M20E · S/N 146Cancelled Nov 29, 1972 · Exported to Canada · Alfred PietschN135SSeverson CVJETKOVIC CA61 · S/N S-1Cancelled Nov 15, 1972 · Meryl A SeversonN8363EMooney M20A · S/N 1541Cancelled Oct 24, 1972 · Exported to Canada · Pietsch Flying ServiceN4861BCessna 310 · S/N 35161Cancelled Oct 28, 1971 · Tarasen E CN3844LCessna 172G · S/N 17254013Cancelled Oct 14, 1971 · Aero Flight IncN6783UMooney M20E · S/N 178Cancelled Aug 5, 1971 · Exported to Canada · Mb & F Aircraft CompanyN74532Mooney M20B · S/N 1843Cancelled Mar 29, 1971 · Exported to Canada · Pietsch Flying Service/ Pietsch Alfred CN9756MMooney M20C · S/N 670050Cancelled Dec 17, 1970 · Exported to Canada · Pietsch Alfred C DBA Pietsch Flying ServiceN8051Benson B-8D · S/N 1Cancelled Sep 24, 1970 · Wengel Harold AN6475QMooney M20F · S/N 680017Cancelled Sep 11, 1970 · Exported to Canada · Built 1967 · Pietsch AlfredN354AMooney Mite M-18 · S/N 15Cancelled Aug 28, 1970 · Exported to Canada · Bruce N Van Sickle
Back to Minot, ND