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.

N81959Hiller UH-12E · S/N 1262Cancelled Feb 5, 1983 · Administratively canceled · Waterhouse Wallace T, Honolulu, HIN8078JPiper AEROSTAR 601P · S/N 61P05657963245Cancelled Feb 2, 1983 · Administratively canceled · Research Group 79 17, Hayward, CAN86066Aeronca 11AC · S/N 11AC-489Cancelled Feb 2, 1983 · Administratively canceled · Young Laurence M, Flowery Branch, GAN86247Aeronca 11AC · S/N 11AC-51Cancelled Feb 2, 1983 · Administratively canceled · Young Laurence M, Flowery Branch, GAN8401Boeing 707-323C · S/N 19581Cancelled Jan 13, 1983 · Administratively canceled · American Airlines Inc, Dallas, TXN8565FBell 47J-2A · S/N 3712Cancelled Jan 13, 1983 · Administratively canceled · Sky King Airways Inc, Allentown, PAN8525DPiper PA-22-160 · S/N 22-5753Cancelled Jan 8, 1983 · Administratively canceled · Cossman Laverne W, Pawnee Rock, KSN8403Boeing 707-323C · S/N 19583Cancelled Dec 16, 1982 · Administratively canceled · American Airlines Inc, Dallas, TXN424FDassault-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, NJN86197Aeronca 11BC · S/N 11AC-628Cancelled Oct 24, 1982 · Administratively canceled · Franklin Nels C, Manokotak, AKN417FDassault-Breguet FALCON 20 · S/N 418Cancelled Oct 21, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN8451UCessna 172F · S/N 17252351Cancelled Oct 7, 1982 · Administratively canceled · Mader John F, Vineland, NJN8586UCessna 150M · S/N 15077954Cancelled Sep 29, 1982 · Administratively canceled · Colonial City Aviation Inc, Mt Vernon, OHN405FDassault-Breguet FALCON 20 · S/N 405Cancelled Sep 16, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN9194MBoeing 707-436 · S/N 17713Cancelled Sep 16, 1982 · Administratively canceled · Aero Equipment Co DBA, Meriden, CTN406FDassault-Breguet FALCON 20 · S/N 407Cancelled Jul 22, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN92217Stehle John C VP-1 · S/N 2Cancelled Jul 15, 1982 · Administratively canceled · Stehle John C, St Joseph, MON407FDassault-Breguet FALCON 20 · S/N 409Cancelled Jun 17, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJN108KMBoles Robert S QUICKIE · S/N 108Cancelled Oct 17, 1981 · Administratively canceled · Boles Robert S, Soldotna, AKN34266Schweizer SGS 1-35 · S/N 46Cancelled Aug 16, 1980 · Administratively canceled · Freedy Allan L, Aurora, ILN6998ZPiper PA-25-235 · S/N 25-2750Cancelled Aug 9, 1980 · Administratively canceled · US Dept Of Agriculture Ars, Yakima, WAN710UFairchild FH-227B · S/N 554Cancelled Jul 1, 1978 · Administratively canceled · Agency For International Development, Washington, DCN708UFairchild FH-227B · S/N 549Cancelled May 13, 1978 · Administratively canceled · Agency For International Development, Washington, DCN709UFairchild FH-227B · S/N 552Cancelled Apr 1, 1978 · Administratively canceled · Agency For Intl Development, Washington, DCN280FLockheed 188A · S/N 1076Cancelled Jan 26, 1978 · Administratively canceled · Integrity Aircraft Sales Inc, Pompano Beach, FLN705UFairchild FH-227B · S/N 545Cancelled Jan 18, 1978 · Administratively canceled · Agency For Intl Development, Washington, DCN43906Dehavilland BEAVER U-6A · S/N 54-4595Cancelled Dec 9, 1977 · Administratively canceled · United States Dept Of Agri Aphis Vs, Mission, TXN2788DCessna 170B · S/N 25330Cancelled Dec 7, 1977 · Administratively canceled · Jecklin Donald L, Peosta, IAN453HCPiper PA-18S-125 · S/N 18-764Cancelled Nov 30, 1977 · Administratively canceled · Miller Kenneth H, Savoonga, AKN73382Cessna 172M · S/N 17267415Cancelled Sep 1, 1977 · Administratively canceled · Colvin Ralph M Jr, Salem, ORN74159Hiller UH-12E · S/N 63-12774Cancelled Jul 18, 1977 · Administratively canceled · U S Dept Of Interior, Menlo Park, CAN455Lake 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, MNN7403Bell UH-1F · S/N 65-7961Cancelled May 27, 1976 · Administratively canceled · Department Of The Interior, Reston, VAN74160Hiller UH-12E · S/N 64-15125Cancelled May 27, 1976 · Administratively canceled · U S Department Of The Interior, Menlo Park, CAN62396Hughes 269A · S/N 160440Cancelled May 26, 1976 · Administratively canceled · Caddo Bossier Civil Defense Agency, Shreveport, LAN779FTDouglas DC-8-63F · S/N 45989Cancelled May 21, 1976 · Administratively canceled · Flying Tiger Line Inc, Los Angeles, CAN4498QCessna A188B · S/N 18800898Cancelled Mar 27, 1975 · Administratively canceled · Clark Air Service Inc, Drew, MS
Back to Day James H