Skip to content

Mccaskey Kenneth A

Earlier aircraft under this name · 33

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 = 'MCCASKEY KENNETH A' OR list_contains(d.other_registrant_names, 'MCCASKEY KENNETH A') 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 = 'MCCASKEY KENNETH A' OR list_contains(d.other_registrant_names, 'MCCASKEY KENNETH A')
  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 = 'MCCASKEY KENNETH A' OR list_contains(d.other_registrant_names, 'MCCASKEY KENNETH A')
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.

N200WJBeech 95-C55 · S/N TE-252Cancelled Oct 17, 1986 · Administratively canceled · Bethal Tom DBA, Thatcher, AZ N21HGShaulis-Homer SCORPION TOO 133 · S/N 001Cancelled Jul 25, 1985 · Administratively canceled · Shawlis Homer G Jr, Boswell, PA N208EBeech 65-B80 · S/N LD-321Cancelled Mar 20, 1985 · Administratively canceled · Roloff Evengelistic Enterprises, Corpus Christi, TX N2080WPiper PA-34-200T · S/N 34-7970135Cancelled Jan 22, 1985 · Administratively canceled · Eastway Aviation, New York, NY N203MAero Commander 1121 · S/N 120Cancelled Jan 8, 1985 · Administratively canceled · Nevis Enterprises Inc, Carson City, NV N2075TPiper PA-28R-200 · S/N 28R-7135019Cancelled Dec 11, 1984 · Administratively canceled · Loonie Leasing Inc, Dorchester, MA N2075NBeech 76 · S/N ME-93Cancelled Nov 5, 1984 · Administratively canceled · Millins Leasing Svc Inc, Lyburn, WV N202DHPiper PA-32RT-300 · S/N 32R7885266Cancelled Oct 26, 1984 · Administratively canceled · Jackson Enterprises Inc, Henderson, NC N207CBPiper PA-28-140 · S/N 28-7425372Cancelled Aug 14, 1984 · Administratively canceled · Byard John D, Wintersville, OH N2046FBalloon Works FIREFLY 6B · S/N 6609Cancelled Jul 24, 1984 · Administratively canceled · Roberts Steve Jr, Avon Park, FL N20776Piper PA-28-181 · S/N 28-7990024Cancelled Jul 3, 1984 · Administratively canceled · Western Aviaton Inc, Blackfoot, ID N19970Cessna 172M · S/N 17260897Cancelled Jun 15, 1984 · Administratively canceled · Wayne Drilling And Blasting, Galilee, PA N20576Cessna 172M · S/N 17261408Cancelled Mar 14, 1984 · Administratively canceled · Brodhead John Jr DBA, Plano, TX N20WHHorn VANCRAFT · S/N 3Cancelled Feb 22, 1984 · Administratively canceled · Brindle Gerald J, Eugene, OR N20007Taylorcraft F19 · S/N F-132Cancelled Feb 13, 1984 · Administratively canceled · Dahle Clyde M, Layton, UT N20082Cessna 177B · S/N 17702625Cancelled Nov 23, 1983 · Administratively canceled · University Of Michigan Flyers Inc, Ann Arbor, MI N2038LLake LA-4 · S/N 371Cancelled Nov 23, 1983 · Administratively canceled · Genz Lyle D, Fpo Miami, FL N200SMCessna 421B · S/N 421B0649Cancelled Sep 24, 1983 · Administratively canceled · Standard Machine And Equipment Co, Uniontown, PA N1982VCessna 172M · S/N 17263811Cancelled Aug 2, 1983 · Administratively canceled · Lawrence Flying Club Inc, Lawrence, KS N20578Cessna 172M · S/N 17261410Cancelled Aug 2, 1983 · Administratively canceled · Boltz G Brian, Lancaster, OH N2086Secor BENSEN B-8M · S/N 1Cancelled Aug 2, 1983 · Administratively canceled · Secor Dayton F, Clio, MI N2ZHBell 47J-2A · S/N 3110Cancelled Aug 2, 1983 · Administratively canceled · Corvallis Aero Service Inc, Corvallis, OR N2012HErcoupe 415-C · S/N 2635Cancelled Jun 25, 1983 · Administratively canceled · Brinkmeyer Lloyd, Hill City, KS N20642Cessna 180K · S/N 18053203Cancelled Jun 15, 1983 · Administratively canceled · Cessna Comm, Wichita, KS N2078JCessna T188C · S/N T18803368TCancelled May 25, 1983 · Administratively canceled · Alexander J D, Rio Vista, CA N2079JCessna T188C · S/N T18803369TCancelled May 25, 1983 · Administratively canceled · Alexander J D, Rio Vista, CA N1980QCessna 177RG · S/N 177RG0380Cancelled Apr 16, 1983 · Administratively canceled · Gleason Keller A, Cheyenne, WY N19889Cessna 172M · S/N 17260837Cancelled Jan 29, 1983 · Administratively canceled · Selberg Robert N, Fort Atkinson, WI N432FDassault-Breguet FALCON 20 · S/N 433Cancelled Dec 24, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJ N1997JCessna T188C · S/N T18803332TCancelled Nov 24, 1982 · Administratively canceled · Wright Ray J, Monroe, LA N19932Douglas DC3A · S/N 4928Cancelled Sep 16, 1982 · Administratively canceled · Rich David, Ormond Beach, FL N1988DBeech D18S · S/N A-829Cancelled Apr 15, 1982 · Administratively canceled · Julac Leasing Corporation, Boynton Beach, FL N19909Cessna 172M · S/N 17260853Cancelled Apr 15, 1982 · Administratively canceled · Marion David P, Colorado City, TX

Back to Mccaskey Kenneth A