OpenAirDocs.org
Morris Gerald J

Earlier aircraft under this name · 41

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL
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 = 'MORRIS GERALD J' OR list_contains(d.other_registrant_names, 'MORRIS GERALD J')
  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.

N37GTS N I A S AS350D ASTAR · S/N 1551Cancelled Mar 31, 1992 · Administratively canceled · Geneva Aviation, Everett, WAN41CCAero Commander 680FL · S/N 1411-62Cancelled Jan 14, 1988 · Administratively canceled · Rainbow Avionics Inc, Miami, FLN4404LCessna 172G · S/N 17254488Cancelled Oct 1, 1985 · Administratively canceled · School Of Metaphysics, Springfield, MON46037Cessna 172I · S/N 17257005Cancelled Sep 16, 1985 · Administratively canceled · Marks Frank, Utica, NYN4755MBeech V35B · S/N D-10129Cancelled Aug 26, 1985 · Administratively canceled · Parisotto Louis P, Copperopolis, CAN209RPCessna 421B · S/N 421B0392Cancelled Aug 8, 1985 · Administratively canceled · Nortensen Carl DBA, Las Vegas, NVN4780ZCessna U206G · S/N U20606022Cancelled Aug 8, 1985 · Administratively canceled · Roertson Rodney DBA, Del Rio, TXN3859BBeech F35 · S/N D-4126Cancelled Jul 25, 1985 · Administratively canceled · Raeburn Robert J, Fairfield, OHN400NABeech G18S · S/N BA-591Cancelled Jul 25, 1985 · Administratively canceled · Northern Air Service Inc, Grand Rapids, MIN317FCessna 401B · S/N 401B0030Cancelled Mar 20, 1985 · Administratively canceled · Jack Henry & Associates Inc, Monett, MON45480Cessna 177RG · S/N 177RG1121Cancelled Mar 20, 1985 · Administratively canceled · Bmw Partnership, Pleasanton, TXN41835Ison PDQ II · S/N 2Cancelled Feb 20, 1985 · Administratively canceled · Fahler Carlton K, Gibsonia, PAN4122VCessna 170 · S/N 18454Cancelled Feb 12, 1985 · Administratively canceled · Green Donald R, Anchorage, AKN4615Boeing 727-35 · S/N 18816Cancelled Feb 8, 1985 · Administratively canceled · Pan American World Airways Inc, New York, NYN4188XRockwell International S-2R · S/N 1950RCancelled Jan 8, 1985 · Administratively canceled · Harbour Harold, Plainview, TXN4237QCessna 172L · S/N 17260137Cancelled Dec 19, 1984 · Administratively canceled · Wedgeworth J C, Sheridan, ARN44143Taylorcraft BC12-D1 · S/N 9943Cancelled Dec 19, 1984 · Administratively canceled · Pullin Martha S, Boulder, CON451FPiper PA-28-140 · S/N 28-7325607Cancelled Dec 19, 1984 · Administratively canceled · Eilts Lawrence H, Cumberland, IAN3953MPiper PA-12 · S/N 12-2596Cancelled Dec 11, 1984 · Administratively canceled · Pohl Dale E, Palmer, AKN4047NMooney M20F · S/N 680165Cancelled Dec 11, 1984 · Administratively canceled · Skylark Flyers Inc, Las Vegas, NVN40160Ayres S2R-R3S · S/N R3S-007Cancelled Oct 26, 1984 · Administratively canceled · Aircraft Spray Inc, Kerman, CAN41783Cessna 172 · S/N 610Cancelled Oct 26, 1984 · Administratively canceled · Fleischman Robert W, Las Vegas, NVN3862HErcoupe 415-CD · S/N 4563Cancelled Oct 25, 1984 · Administratively canceled · Hilton Paul, Sacramento, CAN41022Cessna 421B · S/N 421B0402Cancelled Oct 25, 1984 · Administratively canceled · Norland Corporation, Fort Atkinson, WIN3893TPiper PA-28R-180 · S/N 28R-30222Cancelled Jul 21, 1984 · Administratively canceled · Tri Service Enterprises Inc, Clinton, MDN8193QPiper PA-28-161 · S/N 28-8216141Cancelled Jul 11, 1984 · Administratively canceled · Aeronautics Inc, Roswell, NMN82JWWard Joseph C And Judy T Q-2 · S/N 2041Cancelled Dec 7, 1983 · Administratively canceled · Ward Joseph C, El Paso, TXN907DCDouglas DC-9-33F · S/N 47476Cancelled Sep 24, 1983 · Administratively canceled · Mcdonnell Douglas Corp, Yuma, AZN1179WBollinger Corey D HUMMER-A · S/N 0076ACancelled Jun 22, 1983 · Administratively canceled · Bollinger Corey D, Hanover, PAN424FDassault-Breguet FALCON 20 · S/N 424Cancelled Nov 18, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN423FDassault-Breguet FALCON 20 · S/N 423Cancelled Nov 13, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN422FDassault-Breguet FALCON 20 · S/N 421Cancelled Nov 4, 1982 · Administratively canceled · Falcon Jet Corp, Teterboro, NJN417FDassault-Breguet FALCON 20 · S/N 418Cancelled Oct 21, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN405FDassault-Breguet FALCON 20 · S/N 405Cancelled Sep 16, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN406FDassault-Breguet FALCON 20 · S/N 407Cancelled Jul 22, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN407FDassault-Breguet FALCON 20 · S/N 409Cancelled Jun 17, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN43906Dehavilland BEAVER U-6A · S/N 54-4595Cancelled Dec 9, 1977 · Administratively canceled · United States Dept Of Agri Aphis Vs, Mission, TXN453HCPiper PA-18S-125 · S/N 18-764Cancelled Nov 30, 1977 · Administratively canceled · Miller Kenneth H, Savoonga, AKN455Lake LA-4 · S/N 430Cancelled Jul 7, 1977 · Administratively canceled · U S Department Of Interior, Homestead, FLN4207KRyan NAVION · S/N NAV-4-1207Cancelled Sep 8, 1976 · Administratively canceled · Carson Charles E, Elbow Lake, MNN4498QCessna A188B · S/N 18800898Cancelled Mar 27, 1975 · Administratively canceled · Clark Air Service Inc, Drew, MS
Back to Morris Gerald J