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.

N3194RCessna 182L · S/N 18258594Cancelled May 30, 1984 · Administratively canceled · Styhr Karsten H, Rancho Palos Verde, CA N361VDehavilland DHC-6 TWIN OTTER · S/N 361Cancelled May 30, 1984 · Administratively canceled · 61 Victor Associates, Tucson, AZ N8021FPiper PA-28-151 · S/N 28-7715254Cancelled May 30, 1984 · Administratively canceled · Hillstead Ted W, Ogden, UT N8059WPiper PA-28-180 · S/N 28-2136Cancelled May 26, 1984 · Administratively canceled · Duff Kenneth R, Buckeye, AZ N8463GCessna 150F · S/N 15062563Cancelled May 26, 1984 · Administratively canceled · Edwards Lawrence O Jr, Medford, OR N87626Douglas C-47A · S/N 9988Cancelled May 26, 1984 · Administratively canceled · Acme Aircraft Company, Tucson, AZ N87627Douglas C-47A · S/N 13660Cancelled May 26, 1984 · Administratively canceled · Acme Aircraft Company, Tucson, AZ N87665Douglas C-47D · S/N 32572Cancelled May 26, 1984 · Administratively canceled · Acme Aircraft Co, Tucson, AZ N87985General Dynamics 240-27 · S/N 338Cancelled May 26, 1984 · Administratively canceled · Niswonger Scott M, Greeneville, TN N91354Douglas B-26C · S/N 41-39468Cancelled May 26, 1984 · Administratively canceled · Reeder Flying Service Inc, Twin Falls, ID N9155Failing-Falconer Teal AMPHIBIAN 121 · S/N 121.199BCancelled May 26, 1984 · Administratively canceled · Olsen David A, Machias, ME N9275AVan Manen BIRDMAN TL-1A · S/N 137Cancelled May 15, 1984 · Administratively canceled · Vanmanen Donald, Noxon, MT N29171Cessna U206C · S/N U206-1138Cancelled Apr 17, 1984 · Administratively canceled · Tyree F Keith, Del Norte, CO N30545Cessna 172M · S/N 17264144Cancelled Apr 10, 1984 · Administratively canceled · Blue Valley Flying Club Inc, Hebron, NE N8071FCessna 150F · S/N 15064171Cancelled Apr 10, 1984 · Administratively canceled · Peterson Byron C, Collinsville, OK N880PABoeing 707-321B · S/N 20019Cancelled Apr 10, 1984 · Administratively canceled · Maushardt Bernard L Trustee, San Francisco, CA N8904WPiper PA-28-235 · S/N 28-10470Cancelled Apr 10, 1984 · Administratively canceled · Osborn Construction Co, Sapulpa, OK N9365SBeech C23 · S/N M-1661Cancelled Apr 10, 1984 · Administratively canceled · Smith Jay H Jr, Trapper Creek, AK N2606MHarris Jack R QUICKSILVER MX II · S/N 4024Cancelled Apr 3, 1984 · Administratively canceled · Harris Jack R, Gilbert, AZ N8667FHughes Helicopters HUGHES 369D · S/N 280272DCancelled Apr 3, 1984 · Administratively canceled · Gatx Leasing Corporation, San Francisco, CA N8729Boeing 707-331B · S/N 20058Cancelled Apr 3, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N2677RCessna 182K · S/N 18258377Cancelled Mar 27, 1984 · Administratively canceled · North American Aerodynamics Inc, Flemington, NJ N2795QCessna A185F · S/N 18503531Cancelled Mar 27, 1984 · Administratively canceled · Missionary Aviation Fellowship, Redlands, CA N2827ACessna 180 · S/N 30027Cancelled Mar 27, 1984 · Administratively canceled · Baim V R, Anchorage, AK N3098HErcoupe 415-C · S/N 3723Cancelled Mar 27, 1984 · Administratively canceled · Schmoe Earl E, Gower, MO N8360BCessna 172 · S/N 36160Cancelled Mar 27, 1984 · Administratively canceled · Bryan John C, Smithfield, NC N8590JCessna 150G · S/N 15066490Cancelled Mar 27, 1984 · Administratively canceled · Hamilton G B III, Laredo, TX N90595Beech T-34B · S/N BG396Cancelled Mar 17, 1984 · Administratively canceled · US Navy Owner Flyg, Fpo Miami, FL N2834JCessna T188C · S/N T18803528TCancelled Mar 14, 1984 · Administratively canceled · Morgan Boyd J, Belgrade, MT N9227XCessna 182E · S/N 18253627Cancelled Mar 14, 1984 · Administratively canceled · Fries Kenneth F, Bloomsburg, PA N8435CPiper PA-28-151 · S/N 28-7615109Cancelled Mar 10, 1984 · Administratively canceled · Barnes John E, Knoxville, TN N8463RPiper PA-28-140 · S/N 28-22366Cancelled Mar 10, 1984 · Administratively canceled · Kilpatrick Herman J, Fort Lawn, SC N90019Cessna 140 · S/N 9077Cancelled Mar 10, 1984 · Administratively canceled · Prescott Robert G, Manchester, NH N28714Boeing 707-331B · S/N 18408Cancelled Mar 7, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N30460Piper PA-28-181 · S/N 28-7990091Cancelled Mar 7, 1984 · Administratively canceled · Sporborg Anthony, Katonah, NY N85JKCessna 340A · S/N 340A0700Cancelled Mar 7, 1984 · Administratively canceled · Goodman Melvyn J, Chicago, IL N208EHBell 206B · S/N 3348Cancelled Mar 3, 1984 · Administratively canceled · Bell Helicopter Textron Inc, Fort Worth, TX N2990FBeech H-18 · S/N BA-753Cancelled Feb 25, 1984 · Administratively canceled · Airtour Acquisition Corp, Honolulu, HI N8415TCessna 182B · S/N 52315Cancelled Feb 22, 1984 · Administratively canceled · C Air Inc, Racine, WI N8705TBoeing 707-331B · S/N 18916Cancelled Feb 22, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N8725TBoeing 707-331B · S/N 18918Cancelled Feb 22, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N8781VBellanca 17-30A · S/N 30321Cancelled Feb 22, 1984 · Administratively canceled · Donelson Martin Jr, Danville, VA N8356ZCessna 210-5A(205A) · S/N 205-0356Cancelled Feb 13, 1984 · Administratively canceled · Palmer Norman D, Gainesville, FL N9164MCessna 182P · S/N 18264713Cancelled Feb 13, 1984 · Administratively canceled · Par Electrical Contractors Inc, North Kansas City, MO N9301FHughes 269B · S/N 0003Cancelled Feb 13, 1984 · Administratively canceled · Harrington Vet Service Inc, Guymon, OK N2889UCessna 172D · S/N 17250489Cancelled Jan 21, 1984 · Administratively canceled · Mc Guire And Son, Seymour, TX N8147Kenneth Carter B8M · S/N C-1Cancelled Jan 21, 1984 · Administratively canceled · Carter Kenneth H, Hartford, AR N84660Cessna 172K · S/N 17258567Cancelled Jan 13, 1984 · Administratively canceled · Palma Aviation Inc, Byron Center, MI N8554SCessna 182H · S/N 18256654Cancelled Jan 13, 1984 · Administratively canceled · Marlowe James M Md, New Port Richey, FL N8876UCessna 150M · S/N 15078010Cancelled Jan 13, 1984 · Administratively canceled · Dixie Air Inc, Tuscaloosa, AL

Back to Frey Charles