Skip to content

Cancelled registrations · 27

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_state = 'OH' AND d.registrant_city = 'HARRISON' 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_state = 'OH' AND d.registrant_city = 'HARRISON'
  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_state = 'OH' AND d.registrant_city = 'HARRISON'
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.

N937AMEurocopter AS 350 B2 · S/N 2654Cancelled Mar 31, 2022 · Exported to Canada · Built 1992 · East West Helicopter Inc N9044XInfinity Power Parachutes INFINITY 2002 · S/N IPP2-097Cancelled Aug 18, 2018 · Built 2002 · Anderson Richard P N5736ACessna 172 · S/N 28336Cancelled Apr 5, 2018 · Revoked, canceled · Built 1956 · Allen Ronald L N4875GCessna 172N · S/N 17273422Cancelled May 25, 2011 · Exported to Canada · Built 1979 · Robins Nest Aviation LLC N5095GLinfert Thomas HORIZON 1 · S/N H0114Cancelled Aug 6, 2009 · Triennial form not returned · Built 2002 · Linfert Thomas W N1006BRyan NAVION L-17B · S/N NAV-4-1718Cancelled Jun 25, 2009 · Registration revoked · Built 1960 · Curtis Richard E N42EWSikorsky S-76B · S/N 760319Cancelled Mar 16, 1999 · Exported to Australia · East West Helicopter Inc N14UVBell 412 · S/N 33199Cancelled Jun 8, 1998 · Exported to Italy N104EWFokker F.28 MK 1000 · S/N 11099Cancelled Nov 18, 1997 · Exported to Canada · East West Helicopter Inc N103EWFokker F.28 2000 · S/N 11062Cancelled Sep 18, 1996 · East West Helicopter Inc N1139XPiper PA-28R-200 · S/N 28R7535257Cancelled May 18, 1992 · Triennial form not returned · Wood Theodore W Jr N53068Bell 206B · S/N 2077Cancelled May 10, 1990 · Exported to Canada · East West Helicopter Inc N5306TBell 212 · S/N 30758Cancelled Jan 13, 1989 · Exported to Canada · East West Helicopter Inc N55183Piper PA-28-140 · S/N 287325339Cancelled Jul 17, 1984 · Otte Carl N3661VCessna 210C · S/N 21058161Cancelled Mar 30, 1984 · Built 1963 · Roudebush Frank A N8163PPiper PA-28-161 · S/N 28-8016275Cancelled Jan 10, 1984 · Administratively canceled · Piper 161 Inc N4034AHiller UH-12E · S/N 5186Cancelled Apr 30, 1982 · Exported to Venezuela · East West Helicopter Inc N3502JCessna 150E · S/N 15061202Cancelled Oct 13, 1981 · Jacobs Tom N59629Bell 206B · S/N 1531Cancelled May 22, 1981 · Exported to Canada · East West Helicopter Inc N2754XBell Helicopter Textron 206L-1 · S/N 45264Cancelled Sep 17, 1980 · Exported to Canada · Built 1979 · East West Helicopter Inc N31DMBell 206L · S/N 45021Cancelled Jul 14, 1980 · Exported to Canada · East West Helicopter Inc N80225Hughes 369HS · S/N 860857SCancelled Mar 18, 1980 · Exported to New Zealand · Polco N217RMBell Helicopter Textron 206B · S/N 2151Cancelled Jul 31, 1978 · Exported to Canada · East West Helicopter Inc N77231Cessna 120 · S/N 11693Cancelled May 12, 1971 · Heim W M N1914CCessna 170B · S/N 26059Cancelled Sep 30, 1970 · Harrison Flying Service N79486Fairchild M-62C(PT-23A) · S/N FE-47Cancelled May 24, 1965 · Kitchen William H N99087Ercoupe 415-C · S/N 1710Cancelled Feb 28, 1956 · Harrison Airport Inc

Back to Harrison, OH