Skip to content

Earlier aircraft under this name · 31

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 = 'ANDREAS GARY M' OR list_contains(d.other_registrant_names, 'ANDREAS GARY M') 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 = 'ANDREAS GARY M' OR list_contains(d.other_registrant_names, 'ANDREAS GARY M')
  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 = 'ANDREAS GARY M' OR list_contains(d.other_registrant_names, 'ANDREAS GARY M')
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.

N1884HCessna 310C · S/N 35984Cancelled Aug 8, 1985 · Administratively canceled · Randle Donald W, San Rafael, CA N1845QCessna 177RG · S/N 177RG0245Cancelled Aug 31, 1984 · Administratively canceled · Clark Drennan A, Reno, NV N18711Boeing 707-331B · S/N 19225Cancelled Aug 14, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N1858TPiper PA-28-140 · S/N 28-7225007Cancelled Jul 11, 1984 · Administratively canceled · Spence William C, Kissimmee, FL N18790Beech B19 · S/N MB-851Cancelled Jul 11, 1984 · Administratively canceled · Air Service Inc, Greensboro, NC N1845TPiper PA-28-140 · S/N 28-7125278Cancelled Jul 3, 1984 · Administratively canceled · Cramer Robert J, Racine, WI N18712Boeing 707-331B · S/N 19226Cancelled Jul 3, 1984 · Administratively canceled · Air Trans Of Golden Beach Inc, Golden Beach, FL N18710Boeing 707-331B · S/N 19224Cancelled May 5, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N187QBeech D95A · S/N TD-609Cancelled Apr 17, 1984 · Administratively canceled · Angus I Hines Inc, Suffolk, VA N18702Boeing 707-331B · S/N 18979Cancelled Apr 10, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N18707Boeing 707-331B · S/N 18983Cancelled Mar 23, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N18704Boeing 707-331B · S/N 18981Cancelled Mar 7, 1984 · Administratively canceled · Boeing Co, Wichita, KS N18708Boeing 707-331B · S/N 18984Cancelled Feb 22, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N1879XCessna 182H · S/N 18255979Cancelled Feb 13, 1984 · Administratively canceled · Burke Dale A, Las Vegas, NV N18881Beech C23 · S/N M-1960Cancelled Feb 13, 1984 · Administratively canceled · Barbosa Richard J, Miami Lakes, FL N1882DBeech C35 · S/N D-3154Cancelled Jan 17, 1984 · Administratively canceled · Wyche Cyril Jr, Boston, MA N18706Boeing 707-331B · S/N 18982Cancelled Jan 7, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N1866VCessna 140 · S/N 14077Cancelled Nov 15, 1983 · Administratively canceled · Kinback Alan C, Woodbridge, VA N18842Aerospatiale SA341G GAZELLE · S/N 1107Cancelled Oct 28, 1983 · Administratively canceled · Aerospatiale Helicopter Corporation, Grand Prairie, TX N18736Cessna 150L · S/N 15074074Cancelled Sep 24, 1983 · Administratively canceled · Eagle Air Inc, Hagerstown, MD N18850Stewart BD-5B · S/N 2535Cancelled Jun 25, 1983 · Administratively canceled · Stewart Lawrence W, Albuquerque, NM N1846RCessna A185F · S/N 18502561Cancelled Jun 22, 1983 · Administratively canceled · Wishman Bros, Geraldine, MT N188CBBeech J35 · S/N D-5611Cancelled Dec 18, 1982 · Administratively canceled · Boggs Franklin D DBA, Gilley, KY N18616Cessna 150L · S/N 15073990Cancelled Dec 11, 1982 · Administratively canceled · Mosher Inc, Mt Gilead, OH N18727Cessna 150L · S/N 15074065Cancelled Oct 30, 1982 · Administratively canceled · Otis Schmidt Enterprises Inc, Schaumburg, IL N18660Cessna 150L · S/N 15074022Cancelled Aug 12, 1982 · Administratively canceled · Wesley Martin R, Knob Noster, MO N1887HPiper PA-32R-300 · S/N 32R-7780198Cancelled Jun 19, 1982 · Administratively canceled · Langley Richard H, Clermont, FL N18551Cessna 150L · S/N 15073936Cancelled Apr 15, 1982 · Administratively canceled · East Denver Flying Service Inc, Aurora, CO N18687Cessna 150L · S/N 15074042Cancelled Apr 15, 1982 · Administratively canceled · Keppler Richard J, Price, UT N1859GChampion 7KCAB · S/N 95Cancelled Jan 21, 1982 · Administratively canceled · Gibson James L, Oakland, MD N18669Cessna 150L · S/N 15074029Cancelled Oct 15, 1981 · Administratively canceled · Liberty Aviation Inc, Fiarfield, NJ

Back to Andreas Gary M