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.

N9036ZBohls Richard N WIND WAGON · S/N GW10Cancelled Feb 12, 1983 · Administratively canceled · Bohls Richard N Sr, Arlington, TX N9050HCessna 172M · S/N 17265919Cancelled Feb 12, 1983 · Administratively canceled · Brenneke Richard L, Woodburn, IN N90560Hardin Rodney BENSEN B8M · S/N RH93046Cancelled Feb 12, 1983 · Administratively canceled · Hardin Rodney P, Bartlett, TN N9158UCessna 150M · S/N 15078109Cancelled Feb 12, 1983 · Administratively canceled · Agape Air Inc, Durham, NH N9195AWagner-David VOLKSPLANE-I · S/N V12741Cancelled Feb 12, 1983 · Administratively canceled · Steere Joseph D, Gleneden Beach, OR N9307UCessna 150M · S/N 15078257Cancelled Feb 12, 1983 · Administratively canceled · Zgrabik Donald, Thousand Oaks, CA N9445GCessna U206E · S/N U20601645Cancelled Feb 12, 1983 · Administratively canceled · Bowling Green Airlease Co, Borling Green, OH N8251HCallair A-9 · S/N 1121Cancelled Feb 10, 1983 · Administratively canceled · Brooks John C, Nashville, TN N839TADouglas DC-6B · S/N 45523Cancelled Feb 10, 1983 · Administratively canceled · Atlas Aircraft Corporation, Miami, FL N9316DCessna 210 · S/N 57509Cancelled Feb 10, 1983 · Administratively canceled · Merritt Earl B, Simi, CA N9478CCessna 180 · S/N 31876Cancelled Feb 10, 1983 · Administratively canceled · Dennis Leslie E Jr, Anchorange, AK N813BNDouglas DC-8-51 · S/N 45642Cancelled Feb 5, 1983 · Administratively canceled · Sonico Inc, Kent, WA N81959Hiller UH-12E · S/N 1262Cancelled Feb 5, 1983 · Administratively canceled · Waterhouse Wallace T, Honolulu, HI N8078JPiper AEROSTAR 601P · S/N 61P05657963245Cancelled Feb 2, 1983 · Administratively canceled · Research Group 79 17, Hayward, CA N86066Aeronca 11AC · S/N 11AC-489Cancelled Feb 2, 1983 · Administratively canceled · Young Laurence M, Flowery Branch, GA N86247Aeronca 11AC · S/N 11AC-51Cancelled Feb 2, 1983 · Administratively canceled · Young Laurence M, Flowery Branch, GA N8401Boeing 707-323C · S/N 19581Cancelled Jan 13, 1983 · Administratively canceled · American Airlines Inc, Dallas, TX N8565FBell 47J-2A · S/N 3712Cancelled Jan 13, 1983 · Administratively canceled · Sky King Airways Inc, Allentown, PA N8525DPiper PA-22-160 · S/N 22-5753Cancelled Jan 8, 1983 · Administratively canceled · Cossman Laverne W, Pawnee Rock, KS N9180Schleicher AS-K13 · S/N 13178Cancelled Jan 8, 1983 · Administratively canceled · Adrian Soaring Club Inc, Toledo, OH N8403Boeing 707-323C · S/N 19583Cancelled Dec 16, 1982 · Administratively canceled · American Airlines Inc, Dallas, TX N424FDassault-Breguet FALCON 20 · S/N 424Cancelled Nov 18, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJ N423FDassault-Breguet FALCON 20 · S/N 423Cancelled Nov 13, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJ N9053NAhearn James SCORPION TOO · S/N 1350Cancelled Nov 11, 1982 · Administratively canceled · Ahearn James P, Tampa, FL N422FDassault-Breguet FALCON 20 · S/N 421Cancelled Nov 4, 1982 · Administratively canceled · Falcon Jet Corp, Teterboro, NJ N9042KPiper PA-28-181 · S/N 28-7890172Cancelled Nov 4, 1982 · Administratively canceled · Campbell James F, Montecito, CA N86197Aeronca 11BC · S/N 11AC-628Cancelled Oct 24, 1982 · Administratively canceled · Franklin Nels C, Manokotak, AK N9069EMaule M-5-235C · S/N 7079CCancelled Oct 24, 1982 · Administratively canceled · J S J Pipe Inc, Portland, OR N9225TPiper PA-38-112 · S/N 38-78A0283Cancelled Oct 24, 1982 · Administratively canceled · Sun Aviation Inc, Vero Beach, FL N417FDassault-Breguet FALCON 20 · S/N 418Cancelled Oct 21, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJ N9292TPiper PA-38-112 · S/N 38-78A0331Cancelled Oct 16, 1982 · Administratively canceled · Koba Timothy, Elvria, OH N9292DPiper PA-18A 150 · S/N 18-6599Cancelled Oct 14, 1982 · Administratively canceled · Ace Aviation Services Inc, Atlantic City, NJ N94322Cessna 182Q · S/N 18266408Cancelled Oct 14, 1982 · Administratively canceled · Szajvolt Bela, Sunnyvale, CA N9503LAmerican AA-5 · S/N AA5-0205Cancelled Oct 14, 1982 · Administratively canceled · Weaver B R DBA, Duncanville, TX N8451UCessna 172F · S/N 17252351Cancelled Oct 7, 1982 · Administratively canceled · Mader John F, Vineland, NJ N8633UCessna 172F · S/N 17252535Cancelled Oct 7, 1982 · Administratively canceled · Flytel Flying Club, Oak Park, MI N8963LGrumman American Avn. AA-1B · S/N AA1B-0413Cancelled Oct 7, 1982 · Administratively canceled · Miller Robert O, Lavra, OH N93130Cessna A185F · S/N 18503182Cancelled Oct 7, 1982 · Administratively canceled · Bennett John C, Anchorage, AK N938Owens-James OWENS SPECIAL · S/N 1Cancelled Oct 7, 1982 · Administratively canceled · Owens James P, Birmingham, AL N9437PPiper PA-24-260 · S/N 24-4945Cancelled Oct 7, 1982 · Administratively canceled · G & R Farms Inc, Champaign, IL N9482FHughes 269B · S/N 1160288Cancelled Oct 7, 1982 · Administratively canceled · C Q Air, Garrett Park, MD N8652VBellanca 8GCBC · S/N 166-75Cancelled Oct 2, 1982 · Administratively canceled · Delta Flying Service Inc, Walls, MS N86670Hanson Starduster SA100 · S/N 13Cancelled Oct 2, 1982 · Administratively canceled · Allen George A, Scottsdale, AZ N8894LGrumman American Avn. AA-1B · S/N AA1B-0394Cancelled Oct 2, 1982 · Administratively canceled · Abc Inc, San Antonio, TX N8948KUniversal Stinson 108-1 · S/N 1081948Cancelled Oct 2, 1982 · Administratively canceled · Schumaker Robert J, Huntsville, AL N8988SCessna 150F · S/N 15062288Cancelled Oct 2, 1982 · Administratively canceled · Campbell Tommy Ray DBA, Arkadelphia, AR N8999ASmith AEROSTAR 601P · S/N 61P-0501-206Cancelled Oct 2, 1982 · Administratively canceled · Balf Co, Newington, CT N9001NAerospatiale SA315B · S/N 2523Cancelled Oct 2, 1982 · Administratively canceled · Farm Development Corporation, Boise, ID N9036WWeatherly 201C · S/N 1017Cancelled Oct 2, 1982 · Administratively canceled · Mac Donald Keith H, Ashland, ME N925RZBeech A23A · S/N M-969Cancelled Oct 2, 1982 · Administratively canceled · Kecle Donald E, Fallon, NV

Back to Frey Charles