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.

N88KAFreeman PITTS S-1C · S/N 496-FCancelled Apr 23, 1983 · Administratively canceled · Allan Keith A, Carrollton, TX N90396Key Wayne & Rudy SCORPION TOO · S/N 7615Cancelled Apr 23, 1983 · Administratively canceled · Key I Wayne, Ararat, NC N9234SBeech C23 · S/N M-1730Cancelled Apr 16, 1983 · Administratively canceled · Hlh Leasing Inc, Peachtree City, GA N8094FPiper PA-28RT-201T · S/N 28R-7931306Cancelled Apr 9, 1983 · Administratively canceled · Vallone John C, Los Angeles, CA N812DMPiper PA-34-200 · S/N 34-7350106Cancelled Apr 9, 1983 · Administratively canceled · Air Services Inc, Livingston, TN N8173LCessna 172H · S/N 17256373Cancelled Apr 9, 1983 · Administratively canceled · 73 L Aircraft Corporation, Roseville, CA N87681Beech C-45H · S/N AF-454Cancelled Apr 9, 1983 · Administratively canceled · Usda Aphis Vs, Mission, TX N89888Cessna 140 · S/N 8933Cancelled Apr 9, 1983 · Administratively canceled · Chapel Kenneth M, Houston, MN N9410LAmerican AA-1A · S/N AA1A-0210Cancelled Apr 9, 1983 · Administratively canceled · Woods Charles M, Corvallis, OR N8406XCessna 172C · S/N 17248906Cancelled Apr 4, 1983 · Administratively canceled · Sottile Joseph S Sr, Monroe, MI N8777SCessna 150F · S/N 15062077Cancelled Apr 4, 1983 · Administratively canceled · Coots John V, Lihue, HI N878BCBeech G35 · S/N D-4820Cancelled Apr 4, 1983 · Administratively canceled · Mustari Nick J, Chicago, IL N9109BCessna 172 · S/N 36609Cancelled Apr 4, 1983 · Administratively canceled · Dobroth Phil, Craigmont, ID N8286DBeech 95 · S/N TD-29Cancelled Mar 29, 1983 · Administratively canceled · Visador Company, Jasper, TX N9243WWeatherly 201C · S/N 1038Cancelled Mar 26, 1983 · Administratively canceled · Decker Air Ag Inc, Hood River, OR N924WBeech E18S · S/N BA-53Cancelled Mar 26, 1983 · Administratively canceled · Oliver Henry III, Santa Fe, NM N8478WPiper PA-28-180 · S/N 28-2720Cancelled Mar 19, 1983 · Administratively canceled · Enginaires Aero Club Inc, Savoy, IL N868BMooney M20 · S/N 1030Cancelled Mar 19, 1983 · Administratively canceled · Knoff Patricia Ann, Jacksonville, TX N90283Kimball Fred BARNETT 004.B · S/N 004BCancelled Mar 19, 1983 · Administratively canceled · Kimball Fred L, Gardena, CA N9218SBeech C23 · S/N M-1738Cancelled Mar 19, 1983 · Administratively canceled · Baird Donald I, Fortuna, CA N8240JPiper AEROSTAR 601P · S/N 61P06447963297Cancelled Mar 15, 1983 · Administratively canceled · Ted Smith Aero Star N8412VAero Commander CALLAIR A-9 · S/N 1612Cancelled Mar 15, 1983 · Administratively canceled · Wilder Ralph, Lavonia, GA N88254Bellanca 7ECA · S/N 1046-74Cancelled Mar 15, 1983 · Administratively canceled · Katanic Robert V, Miraloma, CA N8060CDouglas DC-4 · S/N 10563Cancelled Mar 12, 1983 · Administratively canceled · Tiburon Aircraft Inc, Corrales, NM N8100ZCessna 210-5 · S/N 205-0100Cancelled Mar 12, 1983 · Administratively canceled · Sullivan Thomas James, San Diego, CA N8800NPiper PA-28-140 · S/N 28-25645Cancelled Mar 12, 1983 · Administratively canceled · Blankenship Jack L, So Lake Tahoe, CA N8267HCallair A-9 · S/N 1140Cancelled Mar 3, 1983 · Administratively canceled · Dixie Dusters Inc, Philadelphia, TN N8435QCessna U206F · S/N U20603294Cancelled Mar 3, 1983 · Administratively canceled · Clark Harry C Jr DBA, Aniak, AK N8837LPiper PA-25-235 · S/N 25-5348Cancelled Mar 3, 1983 · Administratively canceled · Tulare Mosquito Abatement District, Tulare, CA N8898FHughes 269A · S/N 83-0275Cancelled Mar 3, 1983 · Administratively canceled · Metamora Elevator Company, Lyons, OH N88KCBeech 65-88 · S/N LP-40Cancelled Mar 3, 1983 · Administratively canceled · Basin Flying Service Inc, Midland, TX N8960FHughes 269A-1 · S/N 15-0023Cancelled Mar 3, 1983 · Administratively canceled · Plains Helicopters Inc DBA, Slaton, TX N8061JPiper AEROSTAR 601P · S/N 61P-0544-232Cancelled Feb 26, 1983 · Administratively canceled · Commonwealth National Bank, Lancaster, PA N8076ECessna 172N · S/N 17272132Cancelled Feb 26, 1983 · Administratively canceled · Gillen Larry G, Colorado Springs, CO N80703Boeing 707-321 · S/N 17599Cancelled Feb 20, 1983 · Administratively canceled · Del Air Inc, Miami, FL N8244FCessna 150F · S/N 15064344Cancelled Feb 16, 1983 · Administratively canceled · Mcdonald Gary E, Garland, TX N8260JVarga 2150A · S/N VAC-106-78Cancelled Feb 16, 1983 · Administratively canceled · Bedford Peter H DBA, Garden Grove, CA N82622Piper PA-18-150 · S/N 18-7909020Cancelled Feb 16, 1983 · Administratively canceled · Foster Ranches, Starling City, TX N8689SAir Tractor AT-301 · S/N 301-0173Cancelled Feb 16, 1983 · Administratively canceled · Kewanee Ag Service Inc, New Madrid, MO N8754MBeech 23 · S/N M-542Cancelled Feb 16, 1983 · Administratively canceled · Boskind Richard M, Indialantic, FL N89468Cessna 152 · S/N 15282758Cancelled Feb 16, 1983 · Administratively canceled · Keith Robert M Jr DBA, Laurel, MS N89501Cessna 152 · S/N 15282764Cancelled Feb 16, 1983 · Administratively canceled · Aero Services Inc, Arkadelphia, AR N8953FHughes 269C · S/N 340282Cancelled Feb 16, 1983 · Administratively canceled · Perkinson Copters Inc, Warrensburg, IL N9065SHughes TH-55A · S/N 67-18365Cancelled Feb 16, 1983 · Administratively canceled · Shelby Cnty Alabama Sheriffs Dept, Columbiana, AL N9425UCessna 150M · S/N 15078373Cancelled Feb 16, 1983 · Administratively canceled · Uran Richard L, Phoenix, AZ N9512PPiper PA-25-235 · S/N 25-7405599Cancelled Feb 16, 1983 · Administratively canceled · Suber Van F, Hartsfield, GA N87DSScherer COUGER-A · S/N 1Cancelled Feb 12, 1983 · Administratively canceled · Scherer Roland D, Manhattan Beach, CA N9011MRobinson Helicopter R22 · S/N 0005Cancelled Feb 12, 1983 · Administratively canceled · Southwest Skyways Inc, Torrance, CA N9021KPiper PA-28R-201T · S/N 28R-7803058Cancelled Feb 12, 1983 · Administratively canceled · Garden State Flying Service Inc, Albion, NJ N90238Cessna 402B · S/N 402B0817Cancelled Feb 12, 1983 · Administratively canceled · Ryan Eva P DBA, Unalakleet, AK

Back to Frey Charles