Skip to content

Cancelled registrations · 66

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 = 'KY' AND d.registrant_city = 'PADUCAH' 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 = 'KY' AND d.registrant_city = 'PADUCAH'
  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 = 'KY' AND d.registrant_city = 'PADUCAH'
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.

N170MVMichael Visser CH750 STOL · S/N 75-10389Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 2016 · Thompson Steven B N383DBBabenco Henry D VANS RV-7A · S/N 72319Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 2011 · Babenco Henry D N181AGNew Piper PA-32R-301T · S/N 3257416Cancelled Aug 24, 2022 · First renewal notice · Built 2006 · Cloud Hugger Transportation LLC N242RZCessna P206 · S/N P206-0064Cancelled Jul 2, 2020 · Exported to Mexico · Built 1965 · Yopp Air LLC N2037MPiper J3C-65 · S/N 20805Cancelled Nov 25, 2019 · Revoked, canceled · Built 1946 · Kentucky Inst Of Aero Inc N4967Wiley Dennis C JN4D · S/N 1Cancelled May 30, 2018 · Sale reported, canceled N62190Orvedal Benjamin I QCKSLVR MXL II SPORT · S/N 576Cancelled May 30, 2018 · Sale reported, canceled · Built 1996 N408GBRans S-14 · S/N 1092046Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1993 · Spear Gary B N89706Cessna 140 · S/N 8755Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Hoffman Melvin N1489QCessna 150L · S/N 15072789Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1971 · Cherry Knox G N904ASAir & Space America 25 · S/N 25-104Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1995 · Air And Space America Inc N923CACessna 310R · S/N 310R0094Cancelled May 7, 2015 · Registration expired, pending cancellation · Starnes Leasing Corp N6164KGraves Stephen F SG2 · S/N 101Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1992 · Graves Stephen F N1177TDe Saar Bart SAAR PROGRESSOR · S/N P01Cancelled Nov 17, 2014 · Registration expired, pending cancellation · De Saar Bart N3789YHughett John W B8M · S/N 414742071Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1981 · Hughett John W N6129SAir & Space America 18A · S/N 18-35Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1965 · Farrington Aircraft Corp N68551Bellanca 7KCAB · S/N 324-72Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1972 · Witte Earl L N6159SAir & Space America 18A · S/N 18-70Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1966 · Farrington Aircraft Corporation N4325GMcculloch J-2 · S/N 035Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1971 N905ASAir & Space America 18A · S/N 18-9Cancelled Jun 27, 2012 · Registration expired, pending cancellation · Farrington Aircraft Corporation N903ASAir & Space America 18A · S/N 18-101Cancelled Jul 15, 2011 · Expired dealer · Air & Space America Inc N441YACessna 441 · S/N 441-0231Cancelled Mar 20, 2008 · Exported to Australia · Built 1981 · Paxton Media Group Inc N515CMMuth Craig M 5151 RG · S/N 25Cancelled Mar 23, 2007 · Triennial form not returned · Muth Craig M N2409ECanaday Benjamin TWINSTARR · S/N TS98-018Cancelled May 12, 2003 · Exported to Ireland · Canaday Benjamin N97EDRiley Edwin E CHALENGER II SPECIAL · S/N 1Cancelled Jan 15, 2002 · Triennial form not returned · Built 1996 · Riley Edwin E N4354YAnderson Clem KB3 · S/N 3957482Cancelled Mar 1, 2001 · Triennial form not returned · Anderson Clem N345RTLane R T JR RTAIRA · S/N 01Cancelled Oct 27, 2000 · Triennial form not returned · Lane Raymond T Jr N22516Cessna 150H · S/N 15068330Cancelled Jun 25, 1999 · Exported to Greece · Farrington Acft Corp N5962TCessna 150D · S/N 15060662Cancelled Mar 1, 1999 · Triennial form not returned · Farrington Aircraft Corp N21579Farrington GYTRAN · S/N 01Cancelled Feb 7, 1997 · Exported to Sri Lanka · Farrington Acft Corp N28PHocker Orville K DRAGONFLY · S/N 268Cancelled Jul 18, 1994 · Triennial form not returned · Hocker Orville K N6228CAir & Space America 18A · S/N 18-44Cancelled Feb 9, 1994 · Exported to South Africa · Farrington Aircraft Corp N5559BRaven Industries RALLY RX7 · S/N RX7149Cancelled Feb 8, 1994 · Exported to South Africa · Farrington I D N74DCBeech V35B · S/N D9610Cancelled Nov 30, 1993 · Midwest Aviation Inc N902ASAir & Space America 18A · S/N 18100Cancelled Nov 17, 1993 · Exported to South Africa · Air & Space America Inc N7370RBeech 95-B55 (T42A) · S/N TC1719Cancelled Jul 1, 1991 · Exported to Guatemala · Midwest Aviation Inc N30BLPitts S-1S · S/N L2Cancelled Feb 17, 1990 · Administratively canceled · Paxton Jack N714BZCessna 150M · S/N 15079062Cancelled Mar 13, 1986 · White Harvey E N704FCCessna 150M · S/N 15078568Cancelled Oct 12, 1983 · Farrington Aircraft Corp N5562PPiper PA-24-180 · S/N 24626Cancelled Apr 12, 1983 · Farrington Aircraft Corp N42RPPayne BENSEN B-8M · S/N PAY-111Cancelled Dec 23, 1981 · Payne John R N2309SHunt-William BENSEN B-8M · S/N 3615Cancelled Oct 1, 1981 · Built 1979 · Hunt William N N1678VCessna 172M · S/N 17263710Cancelled Dec 4, 1979 · Exported to Japan · Ohio Valley Aviation Inc N6108SAir & Space America 18A · S/N 18-14Cancelled Jan 10, 1979 · Exported to Sweden · Farrington Acft Corp N6161SAir & Space America 18A · S/N 18-73Cancelled Sep 14, 1978 · Exported to Sweden · Farrington Aircraft Corp N6116SAir & Space America 18A · S/N 18-22Cancelled May 26, 1977 · Exported to Sweden · Farrington Aircraft Corp N12JVVilleneuve OSPREY 1-V · S/N 11Cancelled Nov 4, 1975 · Villeneuve John J N60391Cessna 150J · S/N 15070276Cancelled Jul 16, 1975 · Exported to Canada · Moyers Sally N97944Stinson 108 · S/N 108-944Cancelled Jun 11, 1975 · Dave Cornell N72197Cessna 120 · S/N 9370Cancelled Jun 10, 1975 · James W Mckenzie

Back to Paducah, KY