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.

N8523ZEskue Jerry W PUSHER · S/N 5299753Cancelled Nov 8, 1983 · Administratively canceled · Eskue Jerry W, Tennessee Colony, TXN907DCDouglas DC-9-33F · S/N 47476Cancelled Sep 24, 1983 · Administratively canceled · Mcdonnell Douglas Corp, Yuma, AZN8531WPiper PA-28-235 · S/N 28-10032Cancelled Sep 14, 1983 · Administratively canceled · The Dekalb Bank, Dekalb, ILN81350Grumman American Avn. AA-5B · S/N AA5B0504Cancelled Sep 7, 1983 · Administratively canceled · Taylor Colin V, Broomfield, CON8135BPiper PA-28-161 · S/N 28-8016172Cancelled Jul 22, 1983 · Administratively canceled · Atlantic Aero Corp, Bridgeport, NJN85FCessna 175 · S/N 55727Cancelled Jul 22, 1983 · Administratively canceled · Griffith Edward L, Poplar Bluff, MON8017UDouglas DC-8-21 · S/N 45591Cancelled Jun 25, 1983 · Administratively canceled · Tropical Aircraft Leasing Inc, Miami, FLN80661Nicholson Kenneth J KN05 QUICKIE · S/N QAC-0238Cancelled Jun 25, 1983 · Administratively canceled · Nicholson Kenneth J, Kill Devil Hills, NCN8163JBell 206B · S/N 552Cancelled Jun 25, 1983 · Administratively canceled · Verticare, Salinas, CAN81814Piper PA-28-161 · S/N 288016302Cancelled Jun 25, 1983 · Administratively canceled · Gryphon Aviation Services, Tulare, CAN1179WBollinger Corey D HUMMER-A · S/N 0076ACancelled Jun 22, 1983 · Administratively canceled · Bollinger Corey D, Hanover, PAN83286Piper PA-18-150 · S/N 18-7709048Cancelled Jun 8, 1983 · Administratively canceled · Plains Helicopter Inc DBA, Slaton, TXN7652UCessna 150M · S/N 15077778Cancelled May 28, 1983 · Administratively canceled · Four Winds Corp, Wilmington, DEN8109FCessna 150F · S/N 15064209Cancelled May 25, 1983 · Administratively canceled · Chapman Kirkman John, Mamou, LAN8526WPiper PA-28-235 · S/N 28-10027Cancelled May 25, 1983 · Administratively canceled · Cherokee Flyers Inc, Chambersburg, PAN8050FCessna 150F · S/N 15064150Cancelled May 21, 1983 · Administratively canceled · Sheer Bernard, W Palm Beach, FLN8169MCessna 310I · S/N 310I0169Cancelled May 21, 1983 · Administratively canceled · Waltom Investments, Oxnard, CAN8250JPiper AEROSTAR 601P · S/N 61P07198063348Cancelled May 21, 1983 · Administratively canceled · West Coast Insulation Co Inc, Ft Myers, FLN8253BCessna 172 · S/N 36053Cancelled May 21, 1983 · Administratively canceled · Gibbons Sam, Torrance, CAN8380EMooney M20A · S/N 1558Cancelled May 21, 1983 · Administratively canceled · Lazaros Harber DBA, Twin Falls, IDN8432XCessna 172C · S/N 17248932Cancelled May 21, 1983 · Administratively canceled · Lynch Lake Flying Club Inc, Benson, MNN8469EBell 47G-3B · S/N 2644Cancelled May 21, 1983 · Administratively canceled · Chem Air Of Mississippi Inc, Shreveport, LAN85580Aeronca 7AC · S/N 7AC-4322Cancelled May 21, 1983 · Administratively canceled · Milk-A-Way Acres, Granton, WIN8127MCessna 310I · S/N 310I0127Cancelled May 5, 1983 · Administratively canceled · Turel Gary J, Portland, ORN8188HBeech C-45H · S/N AF-407Cancelled May 5, 1983 · Administratively canceled · San Jose State University, San Jose, CAN8449RPiper PA-28-140 · S/N 28-22334Cancelled May 5, 1983 · Administratively canceled · Lowry Samuel A, Cincinnati, OHN8394Sud SA316B ALOUETTE III · S/N 1867Cancelled Apr 23, 1983 · Administratively canceled · Hosking Helicopters Inc, Bountiful, UTN8474VRockwell International S-2R · S/N 2374RCancelled Apr 23, 1983 · Administratively canceled · Mcginty Flying Service Inc, Jones, LAN8612YPiper PA-30 · S/N 30-1752Cancelled Apr 23, 1983 · Administratively canceled · Engler Gerald R, Milwaukie, WAN8094FPiper PA-28RT-201T · S/N 28R-7931306Cancelled Apr 9, 1983 · Administratively canceled · Vallone John C, Los Angeles, CAN812DMPiper PA-34-200 · S/N 34-7350106Cancelled Apr 9, 1983 · Administratively canceled · Air Services Inc, Livingston, TNN8173LCessna 172H · S/N 17256373Cancelled Apr 9, 1983 · Administratively canceled · 73 L Aircraft Corporation, Roseville, CAN8406XCessna 172C · S/N 17248906Cancelled Apr 4, 1983 · Administratively canceled · Sottile Joseph S Sr, Monroe, MIN8286DBeech 95 · S/N TD-29Cancelled Mar 29, 1983 · Administratively canceled · Visador Company, Jasper, TXN8478WPiper PA-28-180 · S/N 28-2720Cancelled Mar 19, 1983 · Administratively canceled · Enginaires Aero Club Inc, Savoy, ILN8240JPiper AEROSTAR 601P · S/N 61P06447963297Cancelled Mar 15, 1983 · Administratively canceled · Ted Smith Aero StarN8412VAero Commander CALLAIR A-9 · S/N 1612Cancelled Mar 15, 1983 · Administratively canceled · Wilder Ralph, Lavonia, GAN8060CDouglas DC-4 · S/N 10563Cancelled Mar 12, 1983 · Administratively canceled · Tiburon Aircraft Inc, Corrales, NMN8100ZCessna 210-5 · S/N 205-0100Cancelled Mar 12, 1983 · Administratively canceled · Sullivan Thomas James, San Diego, CAN8267HCallair A-9 · S/N 1140Cancelled Mar 3, 1983 · Administratively canceled · Dixie Dusters Inc, Philadelphia, TNN8435QCessna U206F · S/N U20603294Cancelled Mar 3, 1983 · Administratively canceled · Clark Harry C Jr DBA, Aniak, AKN8061JPiper AEROSTAR 601P · S/N 61P-0544-232Cancelled Feb 26, 1983 · Administratively canceled · Commonwealth National Bank, Lancaster, PAN8076ECessna 172N · S/N 17272132Cancelled Feb 26, 1983 · Administratively canceled · Gillen Larry G, Colorado Springs, CON80703Boeing 707-321 · S/N 17599Cancelled Feb 20, 1983 · Administratively canceled · Del Air Inc, Miami, FLN8244FCessna 150F · S/N 15064344Cancelled Feb 16, 1983 · Administratively canceled · Mcdonald Gary E, Garland, TXN8260JVarga 2150A · S/N VAC-106-78Cancelled Feb 16, 1983 · Administratively canceled · Bedford Peter H DBA, Garden Grove, CAN82622Piper PA-18-150 · S/N 18-7909020Cancelled Feb 16, 1983 · Administratively canceled · Foster Ranches, Starling City, TXN8251HCallair A-9 · S/N 1121Cancelled Feb 10, 1983 · Administratively canceled · Brooks John C, Nashville, TNN839TADouglas DC-6B · S/N 45523Cancelled Feb 10, 1983 · Administratively canceled · Atlas Aircraft Corporation, Miami, FLN813BNDouglas DC-8-51 · S/N 45642Cancelled Feb 5, 1983 · Administratively canceled · Sonico Inc, Kent, WA
Back to Day James H