Skip to content

Earlier aircraft under this name · 495

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

Query with SQL

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N907DCDouglas DC-9-33F · S/N 47476Cancelled Sep 24, 1983 · Administratively canceled · Mcdonnell Douglas Corp, Yuma, AZ N8531WPiper PA-28-235 · S/N 28-10032Cancelled Sep 14, 1983 · Administratively canceled · The Dekalb Bank, Dekalb, IL N9136RCessna A188B · S/N 18802127TCancelled Sep 14, 1983 · Administratively canceled · Babcock James N, Cameron, MO N81350Grumman American Avn. AA-5B · S/N AA5B0504Cancelled Sep 7, 1983 · Administratively canceled · Taylor Colin V, Broomfield, CO N9320UCessna 150M · S/N 15078270Cancelled Sep 3, 1983 · Administratively canceled · Sky Brezze Aviation Inc, Lubbock, TX N900ECessna 421B · S/N 421B0359Cancelled Aug 16, 1983 · Administratively canceled · Knight Paul B, Englewood, CO N9211CCessna 180 · S/N 31310Cancelled Aug 6, 1983 · Administratively canceled · Mcwaid Russell E, Buckeye, AZ N8824Sikorsky CH-19 · S/N 56-4263Cancelled Jul 29, 1983 · Administratively canceled · Indian Hills Community College, Ottumwa, IA N8135BPiper PA-28-161 · S/N 28-8016172Cancelled Jul 22, 1983 · Administratively canceled · Atlantic Aero Corp, Bridgeport, NJ N85FCessna 175 · S/N 55727Cancelled Jul 22, 1983 · Administratively canceled · Griffith Edward L, Poplar Bluff, MO N8691HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1470Cancelled Jul 22, 1983 · Administratively canceled · Reynolds Ernest DBA, Mccrory, AR N9079BRobinson Helicopter R22 · S/N 0294Cancelled Jul 22, 1983 · Administratively canceled · University Of North Dakota, Grand Forks, ND N9366EAeronca 11AC · S/N 11AC-1004Cancelled Jul 22, 1983 · Administratively canceled · Marymee V E, Sparks, NV N9201Richard E Franklin JEANIES TEENIE · S/N RF013Cancelled Jul 20, 1983 · Administratively canceled · Dearinger Bill F, Prescott, AR N8017UDouglas DC-8-21 · S/N 45591Cancelled Jun 25, 1983 · Administratively canceled · Tropical Aircraft Leasing Inc, Miami, FL N80661Nicholson Kenneth J KN05 QUICKIE · S/N QAC-0238Cancelled Jun 25, 1983 · Administratively canceled · Nicholson Kenneth J, Kill Devil Hills, NC N8163JBell 206B · S/N 552Cancelled Jun 25, 1983 · Administratively canceled · Verticare, Salinas, CA N81814Piper PA-28-161 · S/N 288016302Cancelled Jun 25, 1983 · Administratively canceled · Gryphon Aviation Services, Tulare, CA N922Lawson Special DG 1 · S/N 3Cancelled Jun 25, 1983 · Administratively canceled · Rhymer William R, Carthage, MO N1179WBollinger Corey D HUMMER-A · S/N 0076ACancelled Jun 22, 1983 · Administratively canceled · Bollinger Corey D, Hanover, PA N9221NAero Commander 685 · S/N 12033Cancelled Jun 15, 1983 · Administratively canceled · Ozenbaugh Donald Ward Jr, Merced, CA N83286Piper PA-18-150 · S/N 18-7709048Cancelled Jun 8, 1983 · Administratively canceled · Plains Helicopter Inc DBA, Slaton, TX N8721MBeech 23 · S/N M-510Cancelled Jun 8, 1983 · Administratively canceled · Coverdale Harold F, Texarkana, LA N7652UCessna 150M · S/N 15077778Cancelled May 28, 1983 · Administratively canceled · Four Winds Corp, Wilmington, DE N8109FCessna 150F · S/N 15064209Cancelled May 25, 1983 · Administratively canceled · Chapman Kirkman John, Mamou, LA N8526WPiper PA-28-235 · S/N 28-10027Cancelled May 25, 1983 · Administratively canceled · Cherokee Flyers Inc, Chambersburg, PA N8816QAero Commander S2R · S/N 1516RCancelled May 25, 1983 · Administratively canceled · Cordele Flying Service Inc, Cordele, GA N9015RRobinson Helicopter R22 · S/N 0010Cancelled May 25, 1983 · Administratively canceled · Colerain Investment Co, Cincinnati, OH N9034LChampion 7GCBC · S/N 261-70Cancelled May 25, 1983 · Administratively canceled · Kirk Donald D, Fairbanks, AK N8050FCessna 150F · S/N 15064150Cancelled May 21, 1983 · Administratively canceled · Sheer Bernard, W Palm Beach, FL N8169MCessna 310I · S/N 310I0169Cancelled May 21, 1983 · Administratively canceled · Waltom Investments, Oxnard, CA N8250JPiper AEROSTAR 601P · S/N 61P07198063348Cancelled May 21, 1983 · Administratively canceled · West Coast Insulation Co Inc, Ft Myers, FL N8253BCessna 172 · S/N 36053Cancelled May 21, 1983 · Administratively canceled · Gibbons Sam, Torrance, CA N8380EMooney M20A · S/N 1558Cancelled May 21, 1983 · Administratively canceled · Lazaros Harber DBA, Twin Falls, ID N8432XCessna 172C · S/N 17248932Cancelled May 21, 1983 · Administratively canceled · Lynch Lake Flying Club Inc, Benson, MN N8469EBell 47G-3B · S/N 2644Cancelled May 21, 1983 · Administratively canceled · Chem Air Of Mississippi Inc, Shreveport, LA N85580Aeronca 7AC · S/N 7AC-4322Cancelled May 21, 1983 · Administratively canceled · Milk-A-Way Acres, Granton, WI N8861LGrumman American Avn. AA-1B · S/N AA1B-0361Cancelled May 18, 1983 · Administratively canceled · A W Languille Enterprises, Mission, KS N8127MCessna 310I · S/N 310I0127Cancelled May 5, 1983 · Administratively canceled · Turel Gary J, Portland, OR N8188HBeech C-45H · S/N AF-407Cancelled May 5, 1983 · Administratively canceled · San Jose State University, San Jose, CA N8449RPiper PA-28-140 · S/N 28-22334Cancelled May 5, 1983 · Administratively canceled · Lowry Samuel A, Cincinnati, OH N9040WWeatherly 201C · S/N 1020Cancelled May 5, 1983 · Administratively canceled · Owings Donald L DBA, Niota, IL N91115Cessna T207 · S/N 20700078Cancelled May 5, 1983 · Administratively canceled · Disney Inc DBA, Salmon, ID N95KTDouglas DC3C-S1C3G · S/N 6255Cancelled May 5, 1983 · Administratively canceled · Miami Air Lease, Miami, FL N8847Unknown model · S/N 1Cancelled Apr 27, 1983 · Administratively canceled · Keith Nelson G, Uniontown, KS N8862BCessna 172 · S/N 36562Cancelled Apr 27, 1983 · Administratively canceled · Lamunyon Harold E, Durango, CO N8394Sud SA316B ALOUETTE III · S/N 1867Cancelled Apr 23, 1983 · Administratively canceled · Hosking Helicopters Inc, Bountiful, UT N8474VRockwell International S-2R · S/N 2374RCancelled Apr 23, 1983 · Administratively canceled · Mcginty Flying Service Inc, Jones, LA N8612YPiper PA-30 · S/N 30-1752Cancelled Apr 23, 1983 · Administratively canceled · Engler Gerald R, Milwaukie, WA N8762SAir Tractor AT-301 · S/N 301-0185Cancelled Apr 23, 1983 · Administratively canceled · Woods Aviation Inc, East Prarie, MO

Back to Frey Charles