Day James H

Earlier aircraft under this name · 290

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 = 'DAY JAMES H' OR list_contains(d.other_registrant_names, 'DAY JAMES H')
  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.

N3194RCessna 182L · S/N 18258594Cancelled May 30, 1984 · Administratively canceled · Styhr Karsten H, Rancho Palos Verde, CAN361VDehavilland DHC-6 TWIN OTTER · S/N 361Cancelled May 30, 1984 · Administratively canceled · 61 Victor Associates, Tucson, AZN8021FPiper PA-28-151 · S/N 28-7715254Cancelled May 30, 1984 · Administratively canceled · Hillstead Ted W, Ogden, UTN8059WPiper PA-28-180 · S/N 28-2136Cancelled May 26, 1984 · Administratively canceled · Duff Kenneth R, Buckeye, AZN8463GCessna 150F · S/N 15062563Cancelled May 26, 1984 · Administratively canceled · Edwards Lawrence O Jr, Medford, ORN29171Cessna U206C · S/N U206-1138Cancelled Apr 17, 1984 · Administratively canceled · Tyree F Keith, Del Norte, CON30545Cessna 172M · S/N 17264144Cancelled Apr 10, 1984 · Administratively canceled · Blue Valley Flying Club Inc, Hebron, NEN8071FCessna 150F · S/N 15064171Cancelled Apr 10, 1984 · Administratively canceled · Peterson Byron C, Collinsville, OKN2677RCessna 182K · S/N 18258377Cancelled Mar 27, 1984 · Administratively canceled · North American Aerodynamics Inc, Flemington, NJN2795QCessna A185F · S/N 18503531Cancelled Mar 27, 1984 · Administratively canceled · Missionary Aviation Fellowship, Redlands, CAN2827ACessna 180 · S/N 30027Cancelled Mar 27, 1984 · Administratively canceled · Baim V R, Anchorage, AKN3098HErcoupe 415-C · S/N 3723Cancelled Mar 27, 1984 · Administratively canceled · Schmoe Earl E, Gower, MON8360BCessna 172 · S/N 36160Cancelled Mar 27, 1984 · Administratively canceled · Bryan John C, Smithfield, NCN8590JCessna 150G · S/N 15066490Cancelled Mar 27, 1984 · Administratively canceled · Hamilton G B III, Laredo, TXN2834JCessna T188C · S/N T18803528TCancelled Mar 14, 1984 · Administratively canceled · Morgan Boyd J, Belgrade, MTN8435CPiper PA-28-151 · S/N 28-7615109Cancelled Mar 10, 1984 · Administratively canceled · Barnes John E, Knoxville, TNN8463RPiper PA-28-140 · S/N 28-22366Cancelled Mar 10, 1984 · Administratively canceled · Kilpatrick Herman J, Fort Lawn, SCN28714Boeing 707-331B · S/N 18408Cancelled Mar 7, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NYN30460Piper PA-28-181 · S/N 28-7990091Cancelled Mar 7, 1984 · Administratively canceled · Sporborg Anthony, Katonah, NYN85JKCessna 340A · S/N 340A0700Cancelled Mar 7, 1984 · Administratively canceled · Goodman Melvyn J, Chicago, ILN208EHBell 206B · S/N 3348Cancelled Mar 3, 1984 · Administratively canceled · Bell Helicopter Textron Inc, Fort Worth, TXN2990FBeech H-18 · S/N BA-753Cancelled Feb 25, 1984 · Administratively canceled · Airtour Acquisition Corp, Honolulu, HIN8415TCessna 182B · S/N 52315Cancelled Feb 22, 1984 · Administratively canceled · C Air Inc, Racine, WIN8356ZCessna 210-5A(205A) · S/N 205-0356Cancelled Feb 13, 1984 · Administratively canceled · Palmer Norman D, Gainesville, FLN2889UCessna 172D · S/N 17250489Cancelled Jan 21, 1984 · Administratively canceled · Mc Guire And Son, Seymour, TXN8147Kenneth Carter B8M · S/N C-1Cancelled Jan 21, 1984 · Administratively canceled · Carter Kenneth H, Hartford, ARN84660Cessna 172K · S/N 17258567Cancelled Jan 13, 1984 · Administratively canceled · Palma Aviation Inc, Byron Center, MIN8554SCessna 182H · S/N 18256654Cancelled Jan 13, 1984 · Administratively canceled · Marlowe James M Md, New Port Richey, FLN2958FHandley Page HP-137 MK1 · S/N 201Cancelled Jan 10, 1984 · Administratively canceled · Apollo Airways Inc, Goleta, CAN8035UDouglas DC-8-52 · S/N 45302Cancelled Jan 10, 1984 · Administratively canceled · United Air Lines Inc, Chicago, ILN8054WPiper PA-28-180 · S/N 28-2128Cancelled Jan 10, 1984 · Administratively canceled · Perrin Kyle, Texarkana, TXN8163PPiper PA-28-161 · S/N 28-8016275Cancelled Jan 10, 1984 · Administratively canceled · Piper 161 Inc, Harrison, OHN8347XCessna 172C · S/N 17248847Cancelled Jan 10, 1984 · Administratively canceled · Odell Don W, Ontario, CAN862JABritten-Norman BN-2A · S/N 184Cancelled Jan 7, 1984 · Administratively canceled · Vieques Air Link Inc, Vieques, PRN3006RCessna T210F · S/N T210-0038Cancelled Dec 31, 1983 · Administratively canceled · Rockbridge Aviation Inc, Glasgow, VAN3101QDouglas DC-3A-S1C3G · S/N 42-4911Cancelled Dec 31, 1983 · Administratively canceled · Atc Inc, Reno, NVN8009UDouglas DC-8-51 · S/N 45286Cancelled Dec 31, 1983 · Administratively canceled · United Air Lines Inc, Chicago, ILN8196JPiper PA-32-301T · S/N 32-8024013Cancelled Dec 14, 1983 · Administratively canceled · Horizon Enterprises Ltd, Santa Ana, CAN82FPiper J4A · S/N 4-1017Cancelled Dec 7, 1983 · Administratively canceled · Frese Donald, Columbus, NEN82JWWard Joseph C And Judy T Q-2 · S/N 2041Cancelled Dec 7, 1983 · Administratively canceled · Ward Joseph C, El Paso, TXN8327ACessna 170B · S/N 25179Cancelled Dec 7, 1983 · Administratively canceled · Dias Gerry R, Cold Bay, AKN8174LCessna 172H · S/N 17256374Cancelled Nov 29, 1983 · Administratively canceled · Singleton Patricia M, San Pedro, CAN2711QCessna 182K · S/N 18257911Cancelled Nov 23, 1983 · Administratively canceled · Timberlane Lumber Company, Eugene, ORN8052EGoss Ronald G PDQ-D · S/N RGG-1Cancelled Nov 23, 1983 · Administratively canceled · Goss Ronald G, Elkhart, INN8110RPiper PA-34-200T · S/N 34-8070019Cancelled Nov 23, 1983 · Administratively canceled · Seminole Air Charter Associates, Pittsford, NYN8111CPiper PA-22-135 · S/N 22-2257Cancelled Nov 23, 1983 · Administratively canceled · Gowan Richard E, Falconer, NYN81416Rockwell International 690A · S/N 11306Cancelled Nov 23, 1983 · Administratively canceled · Trask Allen N, Wilmington, NCN8314NBeech E33 · S/N CD-1155Cancelled Nov 23, 1983 · Administratively canceled · Dennison Robert A, Austin, TXN8368MCessna A150K · S/N A15000068Cancelled Nov 23, 1983 · Administratively canceled · Neeves Arthur E, Mahopac Falls, NYN2954KCessna 180K · S/N 18053137Cancelled Nov 15, 1983 · Administratively canceled · State Of Georgia, Atlanta, GA
Back to Day James H