Skip to content

Earlier aircraft under this name · 86

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

N1667ECessna 172N · S/N 17271087Cancelled Aug 8, 1985 · Administratively canceled · Hiegel Aviation Inc, Little Rock, AR N1678SSnow 600-S2C · S/N 600-1253CCancelled Aug 8, 1985 · Administratively canceled · Farmers Flying Service Inc, Bancroft, WI N1635GChampion 7KCAB · S/N 110Cancelled Jul 25, 1985 · Administratively canceled · Chase William H, Coopersville, MI N1711ZCessna 336 · S/N 336-0011Cancelled Jul 25, 1985 · Administratively canceled · Shatz Sheldon S Dr, Malone, NY N1776BTaylorcraft BC12-D · S/N 10388Cancelled Jul 25, 1985 · Administratively canceled · Gathright Custom Homes Co, Richardson, TX N1825MCurtiss Wright C-46F · S/N 22525Cancelled Jul 25, 1985 · Administratively canceled · La Mesa Leasing Inc, West Linn, OR N177GACessna 210M · S/N 21062131Cancelled Mar 20, 1985 · Administratively canceled · Aaron Glen D Sr, Midland, TX N179BVBoeing-Vertol 179 · S/N 101Cancelled Feb 12, 1985 · Administratively canceled · Boeing Equipment Holding Company, Philadelphia, PA N172HCessna 172 · S/N 17268129Cancelled Feb 4, 1985 · Administratively canceled · Azami Aharon, Van Nuys, CA N1709ECessna 172N · S/N 17271104Cancelled Oct 25, 1984 · Administratively canceled · Air Service International Inc, Honolulu, HI N16663Bell 206B · S/N 2199Cancelled Aug 14, 1984 · Administratively canceled · Papillon Helicopters Ltd, Hanalei Kauai, HI N170HCCessna 170A · S/N 20047Cancelled Aug 6, 1984 · Administratively canceled · Copeland Harold C, Lafollette, TN N16524Piper PA-28-140 · S/N 28-7325290Cancelled Jul 21, 1984 · Administratively canceled · C A Mccluney Co Inc, Honolulu, HI N16659Bell 206B · S/N 2076Cancelled Jun 15, 1984 · Administratively canceled · Houston Helicopters Inc, Pearland, TX N1780DCessna 170A · S/N 20223Cancelled Jan 25, 1984 · Administratively canceled · Nixon Viola M, Port Angeles, WA N17169Messerschmitt-Boelkow-Blohm-Gm BO-105C · S/N S115Cancelled Nov 29, 1983 · Administratively canceled · Mbb Helicopter Corporation, West Chester, PA N1776QBoeing 720-048 · S/N 18041Cancelled Nov 23, 1983 · Administratively canceled · Aeroamerica Inc, Seattle, WA N17962Schweizer SGS 2-33A · S/N 262Cancelled Sep 24, 1983 · Administratively canceled · Central Indiana Soaring Society, Zionsville, IN N165MAMitsubishi MU-2B-30 · S/N 541Cancelled Sep 21, 1983 · Administratively canceled · Campbell Taggart Inc, Dallas, TX N17006Cessna 150L · S/N 15073576Cancelled Sep 14, 1983 · Administratively canceled · Teeter Edward R, Clarksville, AR N17135Cessna 150L · S/N 15073634Cancelled Jul 22, 1983 · Administratively canceled · J Kenneth Forester Inc DBA, Teterboro, NJ N1714HPiper PA-32R-300 · S/N 32R-7780178Cancelled Jun 25, 1983 · Administratively canceled · Roberts Flying Service Inc, Lakeland, FL N17198Messerschmitt-Boelkow-Blohm-Gm BO-105C · S/N S118Cancelled Jun 25, 1983 · Administratively canceled · Petroleum Helicopters Inc, Lafayette, LA N1721UCessna 207 · S/N 20700321Cancelled Jun 25, 1983 · Administratively canceled · Foster Neil W DBA, Nome, AK N1819TPiper PA-28-140 · S/N 28-7125171Cancelled Jun 25, 1983 · Administratively canceled · Fischer Robert Lee, Simi Valley, CA N164ASP Z L -Warszawa-Cnpsl PZL-104 WILGA 35A · S/N 96317Cancelled Jun 15, 1983 · Administratively canceled · Melex USA Inc, Raleigh, NC N18016Cessna 150L · S/N 15073733Cancelled May 14, 1983 · Administratively canceled · Zoolkoski Thomas X, Pine Brook, NJ N16738Boeing 707-131B · S/N 19568Cancelled May 5, 1983 · Administratively canceled · Bankers Trust Company Trustee, New York, NY N18120Cessna 150L · S/N 15073800Cancelled May 5, 1983 · Administratively canceled · Ferris Bonnie J, Dillon, MT N1729UCessna 207 · S/N 20700329Cancelled Apr 23, 1983 · Administratively canceled · Cook Inlet Aviation Inc, Homer, AK N17705Beech 58TC · S/N TK-47Cancelled Apr 23, 1983 · Administratively canceled · Executive Beechcraft Inc, Kansas City, MO N16541Piper PA-28-235 · S/N 28-7310104Cancelled Mar 26, 1983 · Administratively canceled · Flying Chargers Inc, Thornton, CO N1824DBeech D18S · S/N A-812Cancelled Jan 19, 1983 · Administratively canceled · Pacific Missionary Aviation Inc, Agana, GU N1791JPiper PA-28-140 · S/N 28-24215Cancelled Jan 15, 1983 · Administratively canceled · Abeywickrema Lionel A, Albuquerque, NM N171WSBellanca 7GCAA · S/N 384-79Cancelled Dec 11, 1982 · Administratively canceled · Smylie Dean R, Van Nuys, CA N1773TPiper PA-28-140 · S/N 28-7125092Cancelled Dec 11, 1982 · Administratively canceled · Garcia Solomon, Calexico, CA N1792FCessna 172H · S/N 17255187Cancelled Dec 9, 1982 · Administratively canceled · Fielding Elvis H, Abilene, TX N1806TPiper PA-32-260 · S/N 32-7100019Cancelled Nov 28, 1982 · Administratively canceled · Bastrop Aircraft Inc, Bastrop, LA N16386Piper PA-28-180 · S/N 28-7305243Cancelled Nov 24, 1982 · Administratively canceled · Mcafee Roger, Lancaster, OH N1686RCessna R182 · S/N R18200515Cancelled Nov 11, 1982 · Administratively canceled · Hi Land Aviation Inc, Fort Morgan, CO N1800NRussell SCHREDER HP-18 · S/N 18-8Cancelled Nov 6, 1982 · Administratively canceled · Russell William Mason, La Jolla, CA N17294Cessna 150L · S/N 15073707Cancelled Nov 4, 1982 · Administratively canceled · Pedigo William E DBA, Bridgeport, TX N1788ZCessna 336 · S/N 336-0088Cancelled Nov 4, 1982 · Administratively canceled · Zapata Menendez Raymond, Cabo Rojo, PR N1686HPiper PA-28-161 · S/N 28-7716044Cancelled Oct 30, 1982 · Administratively canceled · Woodbridge Airport Inc, Woodbridge, VA N1762SAero Commander S2R · S/N 1462RCancelled Oct 28, 1982 · Administratively canceled · Custom Air Inc, Roe, AR N1649HPiper PA-28-181 · S/N 28-7790323Cancelled Sep 23, 1982 · Administratively canceled · Wetzel Nelson, Hillsboro, OR N16436Piper PA-28-180 · S/N 28-7305255Cancelled Sep 16, 1982 · Administratively canceled · Henderson Leon J, Warner, NH N1688UCessna 207 · S/N 20700288Cancelled Sep 11, 1982 · Administratively canceled · Wallwork Lease & Rental Co Inc, Fargo, ND N16380Piper PA-28-180 · S/N 28-7305240Cancelled Aug 12, 1982 · Administratively canceled · Clouser Aviation Svc, Ashland, PA N1657UCessna 207 · S/N 20700257Cancelled Aug 12, 1982 · Administratively canceled · Aurora Air Service Inc, Fairbanks, AK

Back to Block James V