OpenAirDocs.org
Pendleton, KY

Cancelled registrations · 25

Query with SQL
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 = 'KY' AND d.registrant_city = 'PENDLETON'
  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.

N464TCCessna 172N · S/N 17268490Cancelled Sep 28, 2016 · Exported to Brazil · Fast Track Flight LLCN369JRBeech V35B · S/N D-9232Cancelled May 21, 2014 · Exported to Brazil · Built 1971 · Fast Track Flight LLCN7940DBeech H35 · S/N D-5204Cancelled May 21, 2014 · Exported to Brazil · Built 1957 · Fast Track Flight LLCN1710QCessna 150L · S/N 15073010Cancelled Jan 22, 2014 · Exported to Brazil · Built 1971 · Fast Track Flight LLCN417RACessna 172S · S/N 172S8150Cancelled Oct 30, 2013 · Exported to Brazil · Built 1999 · Fast Track Flight LLCN4396WBeech V35B · S/N D9592Cancelled Aug 21, 2013 · Exported to Brazil · Fast Track Flight LLCN8250MCessna 210K · S/N 21059250Cancelled Jul 25, 2013 · Exported to Brazil · Fast Track Flight LLCN9982VCessna 172M · S/N 17264600Cancelled Jul 25, 2013 · Exported to Brazil · Built 1974 · Fast Track Flight LLCN567SPCessna 172S · S/N 172S8491Cancelled Jul 23, 2013 · Exported to Brazil · Built 2000 · Fast Track Flight LLCN3001QCessna 182K · S/N 18258001Cancelled Jul 2, 2013 · Exported to Brazil · Built 1967 · Fast Track Flight LLCN6022QCessna 172S · S/N 172S9672Cancelled Mar 11, 2013 · Exported to Brazil · Built 2004 · Fast Track Flight LLCN120MECessna T206H · S/N T20608151Cancelled Feb 26, 2013 · Exported to Paraguay · Built 2000 · Fast Track Flight LLCN583PMCessna 210-5A(205A) · S/N 205-0571Cancelled Feb 7, 2013 · Exported to Brazil · Built 1964 · Fast Track Flight LLCN360TRRogers Thomas RV-7 · S/N 70159Cancelled Jan 25, 2013 · Exported to Brazil · Built 2003 · Fast Track Flight LLCN193KBBeech B-60 · S/N P-424Cancelled Dec 26, 2012 · Exported to Brazil · Built 1977 · Fast Track Flight LLCN7388Cessna 150M · S/N 15076125Cancelled Dec 26, 2012 · Exported to Brazil · Built 1974 · Fast Track Flight LLCN46439Cessna 152 · S/N 15283050Cancelled Dec 21, 2012 · Exported to Brazil · Built 1978 · Fast Track Flight LLCN5412FPiper PA-34-200T · S/N 34-7770017Cancelled Aug 20, 2012 · Exported to Brazil · Built 1976 · Fast Track Flight LLCN254YRaytheon G36 · S/N E-3689Cancelled Aug 2, 2012 · Exported to Brazil · Fast Track Flight LLCN2400KPiper PA46-500TP · S/N 4697441Cancelled Jul 9, 2012 · Exported to Brazil · Built 2010 · Fast Track Flight LLCN2124SCessna 210L · S/N 21061086Cancelled Apr 5, 2012 · Exported to Brazil · Built 1975 · Fast Track Flight LLCN58WCBeech 58 · S/N TH-766Cancelled Jan 6, 2012 · Exported to Brazil · Built 1976 · Fast Track Flight LLCN200KHRaytheon 58 · S/N TH-2102Cancelled Jan 4, 2012 · Exported to Brazil · Fast Track Flight LLCN46PDCessna 182S · S/N 18280834Cancelled Dec 1, 2011 · Exported to Brazil · Built 2000 · Fast Track Flight LLCN2352JCessna T206H · S/N T20608575Cancelled Nov 16, 2011 · Exported to Brazil · Built 2005 · Fast Track Flight LLC
Back to Pendleton, KY