Fargo, ND

Cancelled registrations · 189

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

N200PNPiper PA-31P · S/N 31P-7630019Cancelled Nov 3, 2008 · Exported to Canada · Built 1976 · Ness Rent A Car Inc DBAN91640North American NAVION A · S/N NAV-4-400Cancelled Sep 7, 2007 · Triennial form not returned · Built 1946 · Syverson John ON182RZCessna R182 · S/N R18200717Cancelled Jan 5, 2007 · Exported to Canada · Built 1978 · Aerolease LLCN232PSPiper PA-31T · S/N 31T-7620018Cancelled Jun 26, 2006 · Exported to Greece · Built 1976 · Weather Modification IncN5275KCessna 172S · S/N 172S9202Cancelled Feb 6, 2006 · Exported to Poland · Built 2002 · Fargo Jet Center IncN6574BCessna 152 · S/N 15283952Cancelled Oct 21, 2005 · Exported to Canada · Built 1979 · Gelking Victor L DBAN19JPPlummer PITTS S-1 · S/N 397HCancelled Sep 15, 2005 · Triennial form not returned · Built 1974 · Fargo Air MuseumN62199Cessna 172P · S/N 17275227Cancelled Apr 1, 2005 · Exported to Thailand · Built 1981 · Gelking Victor L DBAN966LKPiper PA-23-250 · S/N 27-2932Cancelled Jan 6, 2005 · Exported to Canada · Built 1965 · Hillsboro Aero LtdN7382YPiper PA-30 · S/N 30-436Cancelled Apr 2, 2004 · Triennial form not returned · Built 1945 · Weather Modification IncN6259TBell UH-1H · S/N 67-19485Cancelled Oct 9, 2003 · Exported to Chile · Dakota Air Parts International IncN62615Bell UH-1H · S/N 67-17247Cancelled Oct 9, 2003 · Exported to Chile · Dakota Air Parts International IncN3904GCessna 340A · S/N 340A0228Cancelled Jul 15, 2003 · Triennial form not returned · Built 1977 · Weather Modification IncN647FBell UH-1H · S/N 65-10118Cancelled Jun 2, 2003 · Exported to Chile · Dakota Air Parts International IncN768MCBell UH-1H · S/N 63-08768Cancelled Jun 2, 2003 · Exported to Chile · Built 1963 · Dakota Air Parts International IncN7385WCessna 152 · S/N 15284502Cancelled May 1, 2003 · Triennial form not returned · Built 1980 · Hamilton Clif S JrN4067XBell UH-1H · S/N 65-09872Cancelled Oct 23, 2002 · Exported to Canada · Dakota Air Parts IntlN9696CPiper PA-34-200T · S/N 34-7870210Cancelled Oct 21, 2002 · Triennial form not returned · Built 1978 · Weather Modification IncN7314PPiper PA-24-250 · S/N 24-2490Cancelled May 12, 2000 · Gelking Victor DBAN9373CPiper PA-28-181 · S/N 28-7890402Cancelled Aug 27, 1999 · Victor Gelking DBAN1282WWeatherly 201B · S/N 636Cancelled Jul 27, 1999 · Triennial form not returned · Gust DavidN96168Hiller OH-23C · S/N 554129Cancelled Jul 29, 1998 · Triennial form not returned · Jim Bortnem Ent IncN421NPCessna 421B · S/N 421B0418Cancelled Jul 21, 1998 · Exported to Canada · Northern Pipe ProductsN258CHBeech 58 · S/N TH541Cancelled May 14, 1997 · Triennial form not returned · Hamilton Clif S JrN9042RCessna TR182 · S/N R18200659Cancelled Mar 30, 1994 · Exported to Germany · North Am LtdN3501KPiper J3C-65 · S/N 22191Cancelled Aug 4, 1993 · Exported to South Africa · Gelking SylviaN7243YPiper PA-30 · S/N 30268Cancelled Jun 17, 1993 · Weather Modification IncN5478KCessna 172P · S/N 17274144Cancelled Oct 3, 1991 · Triennial form not returned · Hamilton Clif S JrN319ERRausch Eugene RV-4 · S/N 319Cancelled Dec 5, 1990 · Triennial form not returned · Rausch Eugene NN5704MRaven Industries S-55A · S/N S55A-619Cancelled Jan 10, 1984 · Exported to Argentina · Interstate Seed CoN91026Cessna 207 · S/N 20700017Cancelled Nov 23, 1983 · Administratively canceled · Wallwork Lease And Rental Co IncN1688UCessna 207 · S/N 20700288Cancelled Sep 11, 1982 · Administratively canceled · Wallwork Lease & Rental Co IncN9990LGrumman American Avn. AA-1B · S/N AA1B-0290Cancelled Feb 5, 1981 · Valley Aviation IncN799YPiper PA-23-160 · S/N 23-1965Cancelled Jan 23, 1981 · The Akeley CoN88GSBeech D95A · S/N TD-640Cancelled Jun 19, 1978 · Hummel Paul AN7416ECessna 210 · S/N 57116Cancelled Dec 14, 1977 · Senske Harry EN1904CCessna 170B · S/N 26049Cancelled May 6, 1977 · Exported to Canada · Cole Richard AN9066DPiper PA-18-150 · S/N 18-6431Cancelled Oct 29, 1975 · Exported to Canada · Alm Harvey EN8744ABeech A35 · S/N D-2166Cancelled Oct 6, 1975 · Austin ThomasN31753Aeronca 65-TAC · S/N 6320TCancelled Mar 7, 1975 · Exported to Canada · 119 Th Fighter Group Flying ClubN32927Piper PA-28-151 · S/N 28-7515274Cancelled Feb 24, 1975 · Exported to Canada · Built 1974 · Valley AviationN1023ZGyrocopter B-8 · S/N C-3Cancelled Dec 26, 1974 · Cortese GeneN102FDBeech 19A · S/N MB-483Cancelled Dec 10, 1974 · Flight Development IncN41492Piper PA-28R-200 · S/N 28R-7435191Cancelled May 30, 1974 · Exported to Canada · Built 1974 · Valley Aviation IncN9728MMooney M20F · S/N 670288Cancelled Feb 1, 1974 · Exported to Canada · Otto Shine Car Wash IncN6632UMooney M20D · S/N 127Cancelled Sep 19, 1973 · Exported to Canada · Kerr Glenn EN3070SCessna 150G · S/N 15066970Cancelled Aug 20, 1973 · Exported to Canada · Kundert Aviation IncN3561APiper PA-22-135 · S/N 22-1835Cancelled Aug 16, 1973 · Exported to Canada · Demars David TN1SUAmerican AA-1A · S/N 287Cancelled Jul 20, 1972 · North Dakota State University ClubN192RCessna 310 · S/N 35083Cancelled Jun 22, 1972 · Exported to Canada · Otto Wash Car Shine Inc
Back to Fargo, ND