Skip to content

Kluting Richard C

Earlier aircraft under this name · 55

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 = 'KLUTING RICHARD C' OR list_contains(d.other_registrant_names, 'KLUTING RICHARD C') 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 = 'KLUTING RICHARD C' OR list_contains(d.other_registrant_names, 'KLUTING RICHARD C')
  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 = 'KLUTING RICHARD C' OR list_contains(d.other_registrant_names, 'KLUTING RICHARD C')
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 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 N17169Messerschmitt-Boelkow-Blohm-Gm BO-105C · S/N S115Cancelled Nov 29, 1983 · Administratively canceled · Mbb Helicopter Corporation, West Chester, PA 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 N164ASP Z L -Warszawa-Cnpsl PZL-104 WILGA 35A · S/N 96317Cancelled Jun 15, 1983 · Administratively canceled · Melex USA Inc, Raleigh, NC N16738Boeing 707-131B · S/N 19568Cancelled May 5, 1983 · Administratively canceled · Bankers Trust Company Trustee, New York, NY N1729UCessna 207 · S/N 20700329Cancelled Apr 23, 1983 · Administratively canceled · Cook Inlet Aviation Inc, Homer, AK N16541Piper PA-28-235 · S/N 28-7310104Cancelled Mar 26, 1983 · Administratively canceled · Flying Chargers Inc, Thornton, CO N171WSBellanca 7GCAA · S/N 384-79Cancelled Dec 11, 1982 · Administratively canceled · Smylie Dean R, Van Nuys, CA 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 N17294Cessna 150L · S/N 15073707Cancelled Nov 4, 1982 · Administratively canceled · Pedigo William E DBA, Bridgeport, TX 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 N1726UCessna 207 · S/N 20700326Cancelled Aug 12, 1982 · Administratively canceled · Dalton John J, Mccleary, WA N172KACessna 172M · S/N 17261431Cancelled Aug 12, 1982 · Administratively canceled · Robinson William T, Seattle, WA N16752Bell Helicopter Textron 206L-1 · S/N 45154Cancelled Jul 17, 1982 · Administratively canceled · Textron Inc, Fort Worth, TX N1727Bensen B-8M · S/N WR-1Cancelled Apr 17, 1982 · Administratively canceled · Claudio Alverio Enrique, Caguas, PR N1695XCessna 210L · S/N 21060730Cancelled Apr 15, 1982 · Administratively canceled · Air Associates, Hereford, TX N1702UCessna 207 · S/N 20700302Cancelled Apr 15, 1982 · Administratively canceled · Ross Raymond G, Oakdale, CA N1711JPiper PA-28-140 · S/N 28-24121Cancelled Apr 15, 1982 · Administratively canceled · Ramsey Kevin M, Columbiana, AL N1722UCessna T207 · S/N 20700322Cancelled Apr 15, 1982 · Administratively canceled · Kodiak Western Alaska Airlines, Kodiak, AK N1736Hoffman X-2 M · S/N 2Cancelled Apr 15, 1982 · Administratively canceled · Hoffman Edward C, Tarpon Springs, FL N17361Ryan Aeronautical ST-A · S/N 166Cancelled Apr 15, 1982 · Administratively canceled · Berkowitz Aaron, Phoenix, AZ N17523Beech V35B · S/N D-9979Cancelled Apr 15, 1982 · Administratively canceled · Southern National Leasing Corp, Charlotte, NC N176LDBeech 76 · S/N ME-7Cancelled Apr 15, 1982 · Administratively canceled · Beech Aircrft Corporaton, Wichita, KS N1690HPiper PA-28R-201 · S/N 28R-7737009Cancelled Apr 1, 1982 · Administratively canceled · Loughlin Nicholas J, Upper Saddle River, NJ N1717FCessna 172H · S/N 17255112Cancelled Feb 6, 1982 · Administratively canceled · Caminos Frank, Leonia, NJ N16666Piper PA-31-310 · S/N 31-299Cancelled Jan 21, 1982 · Administratively canceled · Dolphin Aviation Inc, Sarasota, FL N1680UCessna 207 · S/N 20700280Cancelled Jan 21, 1982 · Administratively canceled · Harolds Air Service Inc, Galena, AK N1734VCessna 172M · S/N 17263730Cancelled Jan 21, 1982 · Administratively canceled · Pimentel Raoul S Jr, N Chelmsford, MA N1740KLuscombe 8E · S/N 4467Cancelled Jan 21, 1982 · Administratively canceled · Lathrop Harold W, Gouldsboro, ME

Back to Kluting Richard C