Skip to content

Hot Springs, AR

Cancelled registrations · 122

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 = 'AR' AND d.registrant_city = 'HOT SPRINGS' 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 = 'AR' AND d.registrant_city = 'HOT SPRINGS'
  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 = 'AR' AND d.registrant_city = 'HOT SPRINGS'
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.

N8837VBellanca 17-30A · S/N 30369Cancelled Aug 8, 2026 · Registration pending, canceled · Built 1971 N238PCPiper PA-42 · S/N 42-8001029Cancelled Jul 28, 2023 · Built 1981 · Blue Water Solutions Inc N706NBDJI PHANTOM 2 VISION · S/N PH645168611Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Beber Charles C N8587PPiper PA-24-260 · S/N 24-4044Cancelled Dec 14, 2022 · Registration expired, pending cancellation · Built 1964 · Mcdonald Sharon N311ARRobinson Jerry L ROBINSON LITTLE WING · S/N R0001Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 2015 · Robinson Jerry L N340ACessna 340A · S/N 340A0014Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 1975 · Skymed LLC N802WMDJI PHANTOM 3 STANDARD · S/N P5ADDG2307009RCancelled Oct 25, 2019 · Sale reported, canceled N246RBMooney M20F · S/N 22-1431Cancelled Jul 19, 2018 · Registration expired, pending cancellation · Built 1976 · Sanson Jodi N4458GBuckeye DREAM MACHINE · S/N 3500Cancelled Apr 10, 2018 · Sale reported, pending cancellation · Built 1996 N218RSButler Ralph G EUROPA · S/N A008Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1999 · Butler Ralph G N279USBoeing 727-251 · S/N 21158Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1975 · Airlease International Inc N856AABoeing 727-223 · S/N 20997Cancelled Jun 22, 2017 · Registration expired, pending cancellation · Built 1976 · Airlease International Inc N180AXBoeing 727-222 · S/N 20041Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1969 · Airlease International Inc N981UABoeing 737-291 · S/N 21546Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1978 · Ljh Aviation Management Services Corp N99WLLynch BEDE 4 · S/N 212Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1971 · Lacey Michael G N3536RBeech A23 · S/N M-694Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1965 · Yeager Jack B N295ASBoeing 727-290 · S/N 22147Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1980 · Airlease International Inc N3605QBeech A23-24 · S/N MA-205Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1967 · Leidy Ralph R N7268UBoeing 727-222 · S/N 21415Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1978 N7295UBoeing 727-222 · S/N 21573Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1979 N2483SAirborne Windsports EDGE X CLASSIC · S/N 582-847Cancelled Aug 14, 2013 · Sale reported, pending cancellation · Built 2007 N71889Luscombe 8A · S/N 3316Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1946 · Stephenson Hugh S N7256UBoeing 727-222 · S/N 21403Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1977 N2087WBeech 95-C55 · S/N TE-33Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1965 N98PDDickson Philip G BENSEN GYROPLANE · S/N 98-7442Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1986 · Dickson Philip G N1269YBoeing 727-243 · S/N 21269Cancelled May 3, 2013 · Registration expired, pending cancellation · Airlease International Inc N1085DBeech A36 · S/N E-2985Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1995 · Cooper Aviation LLC N61899Cessna 172M · S/N 17264879Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1975 · Cobb Aircraft Inc N8351EMooney M20A · S/N 1529Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1959 N7071FCessna 150F · S/N 15063671Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1966 N7290UBoeing 727-222 · S/N 21568Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1979 N47FPiper PA-18A 150 · S/N 18-4898Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1956 · De Maine William A N40BBeech C35 · S/N D-3000Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1951 · Intra Corporaton N3785SAvcat Airframes GOBLER · S/N A03JDCCancelled Aug 16, 2012 · Exported to Belize · Built 2004 · Crooks James D N49851Cessna 152 · S/N 15281358Cancelled Aug 9, 2012 · Revoked, canceled · Built 1978 · Hot Springs Aero Inc N80453Beech 35 · S/N D-69Cancelled Jan 27, 2012 · Built 1947 · Turpin Ralph N8346RPiper PA-28-140 · S/N 28-22221Cancelled Oct 31, 2011 · Built 1966 · Tipton James F N69735Boeing 727-224 · S/N 20664Cancelled Jul 29, 2011 · Exported to Brazil · Built 1974 · Airlease International Inc N7650UCessna 150M · S/N 15077776Cancelled Jun 13, 2011 · Exported to Brazil · Built 1975 · Diamond Lakes Aviation Inc N69242Cessna 152 · S/N 15282581Cancelled Jun 10, 2011 · Exported to Sri Lanka · Built 1978 · Diamond Lakes Aviation Inc N750USBoeing 727-214 · S/N 21512Cancelled Feb 3, 2010 · Exported to Brazil · Built 1978 · Airlease International Inc N4045JCessna 150G · S/N 15065345Cancelled Oct 26, 2009 · Exported to Brazil · Mallon J P N751USBoeing 727-214 · S/N 21513Cancelled Apr 20, 2009 · Exported to Brazil · Built 1978 · Airlease International Inc N412ESBeech 95-B55 (T42A) · S/N TC-2198Cancelled Mar 5, 2009 · Triennial form not returned · Built 1978 · Secrest Gregory L N7252UBoeing 727-222 · S/N 21399Cancelled Jun 28, 2006 · Built 1977 · Ljh Aviation Management Services Corp N7263UBoeing 727-222 · S/N 21410Cancelled Jun 28, 2006 · Built 1978 · Ljh Aviation Management Services Corp N7264UBoeing 727-222 · S/N 21411Cancelled Jun 28, 2006 · Built 1978 · Ljh Aviation Management Services Corp N7265UBoeing 727-222 · S/N 21412Cancelled Jun 28, 2006 · Built 1978 · Ljh Aviation Management Services Corp N7267UBoeing 727-222 · S/N 21414Cancelled Jun 28, 2006 · Built 1978 · Ljh Aviation Management Services Corp N7269UBoeing 727-222 · S/N 21416Cancelled Jun 28, 2006 · Triennial form not returned · Built 1978 · Ljh Aviation Management Services Corp

Back to Hot Springs, AR