Frey Charles

Earlier aircraft under this name · 495

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'FREY CHARLES' OR list_contains(d.other_registrant_names, 'FREY CHARLES')
  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.

N8586UCessna 150M · S/N 15077954Cancelled Sep 29, 1982 · Administratively canceled · Colonial City Aviation Inc, Mt Vernon, OHN8854ABeech B35 · S/N D-2509Cancelled Sep 29, 1982 · Administratively canceled · Gruhl Corp, Louisville, KYN89154Cessna 152 · S/N 15282652Cancelled Sep 29, 1982 · Administratively canceled · Showalter Flying Service Inc, Orlando, FLN9333RCessna A188B · S/N 18802240TCancelled Sep 25, 1982 · Administratively canceled · Blue Spring Bank, Blue Spring, MON8985FHughes 269C · S/N 830233Cancelled Sep 23, 1982 · Administratively canceled · Mackay Jack DBA, Columbus, MSN90258Manazzi Blaine K SCOTT CR 19 · S/N BKM1-7706Cancelled Sep 23, 1982 · Administratively canceled · Minazzi Blaine K, San Antonio, TXN9099AAnderson Richard SCORPION 133 · S/N 007RJACancelled Sep 23, 1982 · Administratively canceled · Anderson Richard J, Lake Arrowhead, CAN9170KStinson 108-1 · S/N 108-2170Cancelled Sep 23, 1982 · Administratively canceled · Clapp Tire Co Inc, Knoxville, TNN9219BCessna 175 · S/N 55019Cancelled Sep 23, 1982 · Administratively canceled · Hardee Mack F, Calgary AlbertaN9228ABowers-Robert SMITH MINIPLANE DSA1 · S/N 91676Cancelled Sep 23, 1982 · Administratively canceled · Bowers Robert S, Tiskilwa, ILN9281TPiper PA-38-112 · S/N 38-78A0316Cancelled Sep 23, 1982 · Administratively canceled · Dussault Lawrence O, Marion, OHN9310TPiper PA-38-112 · S/N 38-78A0020Cancelled Sep 23, 1982 · Administratively canceled · Air Care Inc, Rocky Mount, NCN405FDassault-Breguet FALCON 20 · S/N 405Cancelled Sep 16, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN9080WWeatherly 201C · S/N 1025Cancelled Sep 16, 1982 · Administratively canceled · Geouge E Truman, Miami, OKN9194MBoeing 707-436 · S/N 17713Cancelled Sep 16, 1982 · Administratively canceled · Aero Equipment Co DBA, Meriden, CTN9355LAmerican AA-1A · S/N AA1A-0055Cancelled Sep 16, 1982 · Administratively canceled · Thomason Investments, Harrison, ARN9510GCessna A188B · S/N 18801509TCancelled Sep 16, 1982 · Administratively canceled · Sss Inc, Pierre, SDN9314KStinson 108-2 · S/N 108-2314Cancelled Aug 14, 1982 · Administratively canceled · Dominy Edward R, Colton, NYN9471SBeech D18S · S/N A-463Cancelled Jul 29, 1982 · Administratively canceled · Johnston James M, Nome, AKN406FDassault-Breguet FALCON 20 · S/N 407Cancelled Jul 22, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN92217Stehle John C VP-1 · S/N 2Cancelled Jul 15, 1982 · Administratively canceled · Stehle John C, St Joseph, MON407FDassault-Breguet FALCON 20 · S/N 409Cancelled Jun 17, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN9420ASpedding-Clive BUSHBY MUSTANG-I · S/N 554Cancelled May 22, 1982 · Administratively canceled · Spedding Clive I, Glenwood, MDN9424LAmerican AA-1A · S/N AA1A-0224Cancelled Apr 8, 1982 · Administratively canceled · Stenson Orice O, Milwaukee, WIN108KMBoles Robert S QUICKIE · S/N 108Cancelled Oct 17, 1981 · Administratively canceled · Boles Robert S, Soldotna, AKN34266Schweizer SGS 1-35 · S/N 46Cancelled Aug 16, 1980 · Administratively canceled · Freedy Allan L, Aurora, ILN6998ZPiper PA-25-235 · S/N 25-2750Cancelled Aug 9, 1980 · Administratively canceled · US Dept Of Agriculture Ars, Yakima, WAN710UFairchild FH-227B · S/N 554Cancelled Jul 1, 1978 · Administratively canceled · Agency For International Development, Washington, DCN708UFairchild FH-227B · S/N 549Cancelled May 13, 1978 · Administratively canceled · Agency For International Development, Washington, DCN709UFairchild FH-227B · S/N 552Cancelled Apr 1, 1978 · Administratively canceled · Agency For Intl Development, Washington, DCN280FLockheed 188A · S/N 1076Cancelled Jan 26, 1978 · Administratively canceled · Integrity Aircraft Sales Inc, Pompano Beach, FLN705UFairchild FH-227B · S/N 545Cancelled Jan 18, 1978 · Administratively canceled · Agency For Intl Development, Washington, DCN43906Dehavilland BEAVER U-6A · S/N 54-4595Cancelled Dec 9, 1977 · Administratively canceled · United States Dept Of Agri Aphis Vs, Mission, TXN2788DCessna 170B · S/N 25330Cancelled Dec 7, 1977 · Administratively canceled · Jecklin Donald L, Peosta, IAN453HCPiper PA-18S-125 · S/N 18-764Cancelled Nov 30, 1977 · Administratively canceled · Miller Kenneth H, Savoonga, AKN73382Cessna 172M · S/N 17267415Cancelled Sep 1, 1977 · Administratively canceled · Colvin Ralph M Jr, Salem, ORN74159Hiller UH-12E · S/N 63-12774Cancelled Jul 18, 1977 · Administratively canceled · U S Dept Of Interior, Menlo Park, CAN455Lake LA-4 · S/N 430Cancelled Jul 7, 1977 · Administratively canceled · U S Department Of Interior, Homestead, FLN4207KRyan NAVION · S/N NAV-4-1207Cancelled Sep 8, 1976 · Administratively canceled · Carson Charles E, Elbow Lake, MNN7403Bell UH-1F · S/N 65-7961Cancelled May 27, 1976 · Administratively canceled · Department Of The Interior, Reston, VAN74160Hiller UH-12E · S/N 64-15125Cancelled May 27, 1976 · Administratively canceled · U S Department Of The Interior, Menlo Park, CAN62396Hughes 269A · S/N 160440Cancelled May 26, 1976 · Administratively canceled · Caddo Bossier Civil Defense Agency, Shreveport, LAN779FTDouglas DC-8-63F · S/N 45989Cancelled May 21, 1976 · Administratively canceled · Flying Tiger Line Inc, Los Angeles, CAN91285Dehavilland BEAVER U-6 · S/N 51-16569Cancelled May 7, 1975 · Administratively canceled · United States Department Of Interior, Prescott, AZN4498QCessna A188B · S/N 18800898Cancelled Mar 27, 1975 · Administratively canceled · Clark Air Service Inc, Drew, MS
Back to Frey Charles