Skip to content

Earlier aircraft under this name · 290

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

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

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.

N37GTS N I A S AS350D ASTAR · S/N 1551Cancelled Mar 31, 1992 · Administratively canceled · Geneva Aviation, Everett, WA N30BLPitts S-1S · S/N L2Cancelled Feb 17, 1990 · Administratively canceled · Paxton Jack, Paducah, KY N41CCAero Commander 680FL · S/N 1411-62Cancelled Jan 14, 1988 · Administratively canceled · Rainbow Avionics Inc, Miami, FL N7688VAero Commander CALLAIR A-9B · S/N 1434Cancelled Dec 22, 1987 · Administratively canceled · Killion Air Corp, Lodi, CA N31412Piper PA-32RT-300 · S/N 32R-7885095Cancelled Oct 17, 1986 · Administratively canceled · Negronrosa Luis A, Gurabo, PR N5648XAero Commander S2R · S/N 1848RCancelled Sep 11, 1986 · Administratively canceled · Grand Prairie Flying Service Inc, Almyra, AR N4404LCessna 172G · S/N 17254488Cancelled Oct 1, 1985 · Administratively canceled · School Of Metaphysics, Springfield, MO N3010ACessna 170B · S/N 25654Cancelled Sep 27, 1985 · Administratively canceled · Fauser Gene C, Anchorage, AK N340JCessna 310D · S/N 39130Cancelled Sep 27, 1985 · Administratively canceled · Burbach Larry K, Bakersfield, CA N3812JCessna 150G · S/N 15065112Cancelled Sep 27, 1985 · Administratively canceled · Hutchison Johnny D, Allen, TX N35758Piper J5A · S/N 5-749Cancelled Sep 16, 1985 · Administratively canceled · Gobin Albert A, Newport, NH N46037Cessna 172I · S/N 17257005Cancelled Sep 16, 1985 · Administratively canceled · Marks Frank, Utica, NY N50843Cessna 150J · S/N 15069589Cancelled Sep 16, 1985 · Administratively canceled · Isley Wayne, Margate, FL N51785Cessna 172P · S/N 17274345Cancelled Sep 16, 1985 · Administratively canceled · Martin James E, East Wenatchee, WA N8189HPiper PA-34-200T · S/N 34-8070187Cancelled Sep 16, 1985 · Administratively canceled · Earnest Inc, Okmulgee, OK N143HKKrause Hugh O SKYRAIDER SS · S/N 584Cancelled Sep 3, 1985 · Administratively canceled · Kaause Hugh O, Spicer, MN N4755MBeech V35B · S/N D-10129Cancelled Aug 26, 1985 · Administratively canceled · Parisotto Louis P, Copperopolis, CA N209RPCessna 421B · S/N 421B0392Cancelled Aug 8, 1985 · Administratively canceled · Nortensen Carl DBA, Las Vegas, NV N4780ZCessna U206G · S/N U20606022Cancelled Aug 8, 1985 · Administratively canceled · Roertson Rodney DBA, Del Rio, TX N3413ECessna 172N · S/N 17271536Cancelled Jul 25, 1985 · Administratively canceled · Pearson Aircraft Inc, Port Angeles, WA N3859BBeech F35 · S/N D-4126Cancelled Jul 25, 1985 · Administratively canceled · Raeburn Robert J, Fairfield, OH N400NABeech G18S · S/N BA-591Cancelled Jul 25, 1985 · Administratively canceled · Northern Air Service Inc, Grand Rapids, MI N3060EPiper PA-28-236 · S/N 28-7911046Cancelled Mar 20, 1985 · Administratively canceled · Dakota Group, Dixon, IL N317FCessna 401B · S/N 401B0030Cancelled Mar 20, 1985 · Administratively canceled · Jack Henry & Associates Inc, Monett, MO N3719PPiper PA-22-150 · S/N 22-3437Cancelled Mar 20, 1985 · Administratively canceled · Merritt Howard F, Largo, FL N45480Cessna 177RG · S/N 177RG1121Cancelled Mar 20, 1985 · Administratively canceled · Bmw Partnership, Pleasanton, TX N36274Piper PA-34-200T · S/N 34-7870307Cancelled Mar 7, 1985 · Administratively canceled · Southwest Skyways Inc, Torrance, CA N41835Ison PDQ II · S/N 2Cancelled Feb 20, 1985 · Administratively canceled · Fahler Carlton K, Gibsonia, PA N820AJConvair 22 · S/N 39Cancelled Feb 20, 1985 · Administratively canceled · Eight Twenty A/J, Ligonier, IN N37174Cessna 414A · S/N 414A0252Cancelled Feb 14, 1985 · Administratively canceled · Gimbel Aviation Inc, Jackson, MI N80044Consolidated Aeronautics LAKE LA-4-200 · S/N 1032Cancelled Feb 14, 1985 · Administratively canceled · Ogrady Donald F, Acton, MA N4122VCessna 170 · S/N 18454Cancelled Feb 12, 1985 · Administratively canceled · Green Donald R, Anchorage, AK N4615Boeing 727-35 · S/N 18816Cancelled Feb 8, 1985 · Administratively canceled · Pan American World Airways Inc, New York, NY N8205YPiper PA-30 · S/N 30-1330Cancelled Jan 31, 1985 · Administratively canceled · Christiansen T W, Stevensville, MI N8450RPiper PA-28-140 · S/N 28-22335Cancelled Jan 31, 1985 · Administratively canceled · Brown Deforest L, Weeping Water, NE N8539QCessna U206F · S/N U20603395Cancelled Jan 31, 1985 · Administratively canceled · Braman Daniel Hawes Jr, Victoria, TX N141KTBauer Lawrence L EASY RISER · S/N LB-1Cancelled Jan 23, 1985 · Administratively canceled · Bauer Lawrence L, Rockford, MI N8559LPiper PA-25-260 · S/N 25-4980Cancelled Jan 22, 1985 · Administratively canceled · Steier Ag Aviation Inc, Whittemore, IA N827NADouglas C-47D · S/N 43-49526Cancelled Jan 17, 1985 · Administratively canceled · Nasa Dryden Flight Research Center, Edwards, CA N833NABoeing 720-027 · S/N 18066Cancelled Jan 17, 1985 · Administratively canceled · Nasa Dryden Flt Research Fac, Edwards, CA N8470FPiper PA-28-181 · S/N 28-7790244Cancelled Jan 17, 1985 · Administratively canceled · Carmichael Cary W, Abbeville, AL N3244WPiper PA-32-260 · S/N 32-60Cancelled Jan 8, 1985 · Administratively canceled · Fayssoux Richard Jr, Greensboro, NC N34452Cessna 177B · S/N 17701813Cancelled Jan 8, 1985 · Administratively canceled · Pylate Jimmy, Eudora, AR N35520Cessna 172I · S/N 17256811Cancelled Jan 8, 1985 · Administratively canceled · Michaels B J, Goodwin, AR N4188XRockwell International S-2R · S/N 1950RCancelled Jan 8, 1985 · Administratively canceled · Harbour Harold, Plainview, TX N8507VRockwell International S-2R · S/N 2267RCancelled Jan 8, 1985 · Administratively canceled · Aerial Ag Leasing Inc, Yuma, AZ N33866Piper PA-34-200T · S/N 34-7570173Cancelled Dec 20, 1984 · Administratively canceled · Crocker National Bank, Fullerton, CA N4237QCessna 172L · S/N 17260137Cancelled Dec 19, 1984 · Administratively canceled · Wedgeworth J C, Sheridan, AR N44143Taylorcraft BC12-D1 · S/N 9943Cancelled Dec 19, 1984 · Administratively canceled · Pullin Martha S, Boulder, CO N451FPiper PA-28-140 · S/N 28-7325607Cancelled Dec 19, 1984 · Administratively canceled · Eilts Lawrence H, Cumberland, IA

Back to Day James H