Skip to content

Cancelled registrations · 49

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 = 'TN' AND d.registrant_city = 'KINGSPORT' 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 = 'TN' AND d.registrant_city = 'KINGSPORT'
  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 = 'TN' AND d.registrant_city = 'KINGSPORT'
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.

N2544JBalloon Works FIREFLY 7-15 · S/N F7-816Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Thurman Joshua T N230MGJohn A Brewer ELA AVIACION 10 ECLI · S/N 1014Cancelled Nov 30, 2020 · Second renewal notice · Aims Air LLC N3956HErcoupe 415-CD · S/N 4657Cancelled Nov 18, 2020 · Built 1947 · Summers James H N754KMDJI INSPIRE 1 · S/N W13DCE15030432Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Cumberland Marketing LLC N2452Dawson VOLKSPLANE · S/N 32842Cancelled Aug 2, 2019 · Revoked, canceled · Built 1970 · Dawson Ralph E N3DARaytheon A36 · S/N E3112Cancelled Apr 25, 2019 · Built 1997 · Airalley LLC N1370Baby Ace JR E · S/N 4251926Cancelled Jul 19, 2018 · Revoked, canceled · Clark James J N729KWWork Kevin D CHALLENGER 1 · S/N 1298-B-0715Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1999 · Flanagan Gerald N4432GBuckeye DREAM MACHINE · S/N 6007Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 2002 · Jones David L N4301PPiper PA-23-160 · S/N 23-1802Cancelled Jun 20, 2017 · Registration expired, pending cancellation · Built 1959 · Cantley James B Jr N2811ANicely Vincent A MONI · S/N VN-3Cancelled Nov 2, 2016 · Built 2010 · Nicely Vincent A N8233GNicely Vincent A KOLB FIRESTAR II · S/N FS-424Cancelled Nov 2, 2016 · Built 1995 · Nicely Vincent A N96828Taylorcraft BC12-D1 · S/N 9128Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1946 · Stallard Harry E N2166XSanders Ronald G MAXAIR XP 503 · S/N RGS42843Cancelled Sep 25, 2013 · Registration expired, pending cancellation · Sanders Ronald G N549SDDennison Sammy K CGS HAWK · S/N H-6192-CCancelled Aug 5, 2013 · Registration expired, pending cancellation · Dennison Sammy K N27MDAero Commander 1121 · S/N 102Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Mason Dixon Lines Inc N8702CPiper PA-22-135 · S/N 22-1350Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1953 · Varnadoe Theodore R Jr N6311QWhittaker Gary S AVID MK IV · S/N 1576DCancelled May 9, 2011 · Exported to Canada · Built 1999 · Whittaker Gary S N76TSThunder & Colt Airborne Amer COLT 77A · S/N 2054Cancelled Jan 6, 2011 · Sale reported · Built 1991 N15218Balloon Works FIREFLY 7-B · S/N 11063Cancelled Mar 3, 2010 · Triennial form not returned · Built 1981 · Flying Machine Company N48898Cessna 152 · S/N 15281038Cancelled Dec 14, 2007 · Exported to Philippines · Built 1977 · Campbell Bea Jr N6378UNicely Vincent A SONERAI II LST · S/N VN-2Cancelled Jul 10, 2006 · Triennial form not returned · Built 2001 · Nicely Vincent A N31195Summers KR-1 · S/N 1Cancelled Sep 6, 2002 · Triennial form not returned · Built 1976 · Summers James H N9361JPiper PA-28-180 · S/N 28-3460Cancelled Mar 5, 2001 · Triennial form not returned · Cooper Kevin J N7LHHardee Leroy BENSEN B 80 · S/N 248133172Cancelled Apr 12, 1999 · Triennial form not returned · Hardee Leroy N40297Adams Balloon A55 · S/N 147Cancelled Oct 14, 1997 · Triennial form not returned · Tri-Cities Mazda Dealers N19AMMorehead BENSEN B8M · S/N 40081Cancelled Nov 23, 1994 · Triennial form not returned · Morehead Arthur O N447RGGalloway Ray D GROVER · S/N 84020Cancelled Aug 4, 1994 · Triennial form not returned · Galloway Ray D N6523XCessna 210 · S/N 57523Cancelled Oct 27, 1993 · Triennial form not returned · Grecol Aviation Inc N444MEPiper PA-32R-300 · S/N 32R-7680220Cancelled Aug 30, 1982 · Built 1976 · Harris David L N4407EAeronca 7AC · S/N 7AC-7185Cancelled Feb 5, 1982 · Built 1948 · Sportwings Inc N71757Cessna 182M · S/N 18259742Cancelled Jan 4, 1982 · Skycrafters Inc N7129ACessna 172 · S/N 29229Cancelled Sep 16, 1977 · Bradley Larry H N8312TCessna 175C · S/N 17557012Cancelled Jun 9, 1975 · Poe Roy W N60125Cessna 150J · S/N 15070088Cancelled May 8, 1975 · Tri-City Aviation Inc N57958Boeing A75N1(PT17) · S/N 75-2253Cancelled Jun 25, 1973 · Baker Corbett E N50119Taylorcraft DCO-65 · S/N L-5471Cancelled Dec 3, 1971 · Phillips Thomas N102CMooney M-18L · S/N 63Cancelled Dec 29, 1970 · Mason Don F N20505Taylorcraft A · S/N 506Cancelled Oct 7, 1970 · James O Dean N288SEDouglas DC3A · S/N 2222Cancelled Jun 25, 1970 · Southeastern Aviation Inc N18941Douglas DC3A · S/N 2007Cancelled Jan 30, 1959 · Southeastern Aviation Inc N52370Consolidated Vultee BT-13A · S/N 5095Cancelled Jan 26, 1954 · Cleek John R N49678Boeing A75N1 · S/N 75-2049Cancelled Jul 6, 1953 · James N Camp N52229North American AT-6B · S/N 84-7788Cancelled Jul 24, 1951 · Built 1946 · Cleek John R N46821Taylorcraft DCO-65 · S/N 0-4295Cancelled May 31, 1950 · Hobbs J H N38842Piper J3L-65 · S/N 7329Cancelled Jan 10, 1950 · Built 1941 · Staton Ollis J N88594Piper J3C-65 · S/N 16220Cancelled Oct 9, 1947 · Kingsport Air Service Inc N952WWelch Orin OWX · S/N 1Cancelled Jun 1, 1937 · Houser Charles W N5042Waco 10 · S/N 1331Cancelled Feb 12, 1931 · Built 1928 · Dorsett Jack

Back to Kingsport, TN