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.

N37GTS N I A S AS350D ASTAR · S/N 1551Cancelled Mar 31, 1992 · Administratively canceled · Geneva Aviation, Everett, WA N9271Enstrom F-28A · S/N 246Cancelled Sep 17, 1990 · Administratively canceled · Fluet Romeo E, Hollis, NH N30BLPitts S-1S · S/N L2Cancelled Feb 17, 1990 · Administratively canceled · Paxton Jack, Paducah, KY N41CCAero Commander 680FL · S/N 1411-62Cancelled Jan 14, 1988 · Administratively canceled · Rainbow Avionics Inc, Miami, FL N7688VAero Commander CALLAIR A-9B · S/N 1434Cancelled Dec 22, 1987 · Administratively canceled · Killion Air Corp, Lodi, CA N31412Piper PA-32RT-300 · S/N 32R-7885095Cancelled Oct 17, 1986 · Administratively canceled · Negronrosa Luis A, Gurabo, PR N5648XAero Commander S2R · S/N 1848RCancelled Sep 11, 1986 · Administratively canceled · Grand Prairie Flying Service Inc, Almyra, AR N4404LCessna 172G · S/N 17254488Cancelled Oct 1, 1985 · Administratively canceled · School Of Metaphysics, Springfield, MO N3010ACessna 170B · S/N 25654Cancelled Sep 27, 1985 · Administratively canceled · Fauser Gene C, Anchorage, AK N340JCessna 310D · S/N 39130Cancelled Sep 27, 1985 · Administratively canceled · Burbach Larry K, Bakersfield, CA N3812JCessna 150G · S/N 15065112Cancelled Sep 27, 1985 · Administratively canceled · Hutchison Johnny D, Allen, TX N35758Piper J5A · S/N 5-749Cancelled Sep 16, 1985 · Administratively canceled · Gobin Albert A, Newport, NH N46037Cessna 172I · S/N 17257005Cancelled Sep 16, 1985 · Administratively canceled · Marks Frank, Utica, NY N50843Cessna 150J · S/N 15069589Cancelled Sep 16, 1985 · Administratively canceled · Isley Wayne, Margate, FL N51785Cessna 172P · S/N 17274345Cancelled Sep 16, 1985 · Administratively canceled · Martin James E, East Wenatchee, WA N8189HPiper PA-34-200T · S/N 34-8070187Cancelled Sep 16, 1985 · Administratively canceled · Earnest Inc, Okmulgee, OK N8759DPiper PA-22-160 · S/N 22-5943Cancelled Sep 16, 1985 · Administratively canceled · Chitiea Andrew D, Aurora, CO N143HKKrause Hugh O SKYRAIDER SS · S/N 584Cancelled Sep 3, 1985 · Administratively canceled · Kaause Hugh O, Spicer, MN N4755MBeech V35B · S/N D-10129Cancelled Aug 26, 1985 · Administratively canceled · Parisotto Louis P, Copperopolis, CA N209RPCessna 421B · S/N 421B0392Cancelled Aug 8, 1985 · Administratively canceled · Nortensen Carl DBA, Las Vegas, NV N4780ZCessna U206G · S/N U20606022Cancelled Aug 8, 1985 · Administratively canceled · Roertson Rodney DBA, Del Rio, TX N3413ECessna 172N · S/N 17271536Cancelled Jul 25, 1985 · Administratively canceled · Pearson Aircraft Inc, Port Angeles, WA N3859BBeech F35 · S/N D-4126Cancelled Jul 25, 1985 · Administratively canceled · Raeburn Robert J, Fairfield, OH N400NABeech G18S · S/N BA-591Cancelled Jul 25, 1985 · Administratively canceled · Northern Air Service Inc, Grand Rapids, MI N3060EPiper PA-28-236 · S/N 28-7911046Cancelled Mar 20, 1985 · Administratively canceled · Dakota Group, Dixon, IL N317FCessna 401B · S/N 401B0030Cancelled Mar 20, 1985 · Administratively canceled · Jack Henry & Associates Inc, Monett, MO N3719PPiper PA-22-150 · S/N 22-3437Cancelled Mar 20, 1985 · Administratively canceled · Merritt Howard F, Largo, FL N45480Cessna 177RG · S/N 177RG1121Cancelled Mar 20, 1985 · Administratively canceled · Bmw Partnership, Pleasanton, TX N89757Cessna 152 · S/N 15282855Cancelled Mar 20, 1985 · Administratively canceled · Boardman Flight Academy Inc, Fort Worth, TX N36274Piper PA-34-200T · S/N 34-7870307Cancelled Mar 7, 1985 · Administratively canceled · Southwest Skyways Inc, Torrance, CA N41835Ison PDQ II · S/N 2Cancelled Feb 20, 1985 · Administratively canceled · Fahler Carlton K, Gibsonia, PA N820AJConvair 22 · S/N 39Cancelled Feb 20, 1985 · Administratively canceled · Eight Twenty A/J, Ligonier, IN N37174Cessna 414A · S/N 414A0252Cancelled Feb 14, 1985 · Administratively canceled · Gimbel Aviation Inc, Jackson, MI N80044Consolidated Aeronautics LAKE LA-4-200 · S/N 1032Cancelled Feb 14, 1985 · Administratively canceled · Ogrady Donald F, Acton, MA N9196ACessna 170A · S/N 18957Cancelled Feb 14, 1985 · Administratively canceled · Mcleod Albert D, Moss Point, MS N9513DPiper PA-22-160 · S/N 22-6429Cancelled Feb 14, 1985 · Administratively canceled · Smith Howard C, Spring, TX N4122VCessna 170 · S/N 18454Cancelled Feb 12, 1985 · Administratively canceled · Green Donald R, Anchorage, AK N4615Boeing 727-35 · S/N 18816Cancelled Feb 8, 1985 · Administratively canceled · Pan American World Airways Inc, New York, NY N8205YPiper PA-30 · S/N 30-1330Cancelled Jan 31, 1985 · Administratively canceled · Christiansen T W, Stevensville, MI N8450RPiper PA-28-140 · S/N 28-22335Cancelled Jan 31, 1985 · Administratively canceled · Brown Deforest L, Weeping Water, NE N8539QCessna U206F · S/N U20603395Cancelled Jan 31, 1985 · Administratively canceled · Braman Daniel Hawes Jr, Victoria, TX N8917VCessna 172M · S/N 17264274Cancelled Jan 31, 1985 · Administratively canceled · Civil Air Patrol Inc, Maxwell Afb, AL N9002QBeech V35B · S/N D-9166Cancelled Jan 31, 1985 · Administratively canceled · Swoboda Robert H, Cairo, IL N9050DPiper PA-22-160 · S/N 22-6189Cancelled Jan 31, 1985 · Administratively canceled · Faber Harold E, Bonners Ferry, ID N9094PPiper PA-24-260 · S/N 24-4569Cancelled Jan 31, 1985 · Administratively canceled · Phoenix Flyers Inc, Phoenix, AZ N141KTBauer Lawrence L EASY RISER · S/N LB-1Cancelled Jan 23, 1985 · Administratively canceled · Bauer Lawrence L, Rockford, MI N8559LPiper PA-25-260 · S/N 25-4980Cancelled Jan 22, 1985 · Administratively canceled · Steier Ag Aviation Inc, Whittemore, IA N8637ZCessna P206C · S/N P206-0437Cancelled Jan 22, 1985 · Administratively canceled · Parker Richard, Andrews, NC N86804Bellanca 14-13-2 · S/N 1165Cancelled Jan 22, 1985 · Administratively canceled · Tocher Arlen C, Carmichael, CA N8732EPiper PA-28-151 · S/N 28-7615155Cancelled Jan 22, 1985 · Administratively canceled · Turner Jay O, Woodside, CA

Back to Frey Charles