Skip to content

Diamondhead, MS

Cancelled registrations · 37

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 = 'MS' AND d.registrant_city = 'DIAMONDHEAD' 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 = 'MS' AND d.registrant_city = 'DIAMONDHEAD'
  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 = 'MS' AND d.registrant_city = 'DIAMONDHEAD'
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.

N15938Piper PA-28-235 · S/N 28-7310075Cancelled Oct 12, 2022 · Registration pending, canceled · Built 1973 N7239QCessna 172L · S/N 17260539Cancelled Apr 9, 2022 · First renewal notice · Diamondhead Aerolease LLC N225QBeech D95A · S/N TD-622Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1965 · Botts Shawn K N7792BBoeing E75 · S/N 75-5904Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Botsay Earl J N444HLTM LANCAIR LEGACY · S/N L2K-330Cancelled Jan 31, 2019 · Registration expired, pending cancellation · Built 2010 · Breen Berni P N212WGLeon Alejandro A LANCAIR 360 · S/N 874-320-671SKICancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 2000 · Breen Berni P N9856DPiper PA-18A 150 · S/N 18-6937Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Vaughan Robert W N76559Cessna 140 · S/N 10995Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1946 · Gooding James G N232HJohnson Hugh SEAREY · S/N 1MK-188Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 2002 · Richard R Dean N7BMMccullough Bobby H KR-1 · S/N KR-15896Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Mccullough Bobby H N3571QCessna 172M · S/N 17261675Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1973 · Farnsworth Brent E N14785Fairchild 22 C7G · S/N 1804Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1962 · Duke James M N8124DPiper PA-22-160 · S/N 22-5615Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1957 · Griggs Todd C N935DDaberkow Dayton W GLASTAR · S/N 079Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1999 · Daberkow Dayton W N4088SBeech A36 · S/N E-644Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1975 · Beeson Jesse L N7630NBeech 95-B55 (T42A) · S/N TC-1164Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1968 · Jacob Charles A N76003Cessna 140 · S/N 10397Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1946 N372JRAnderson Irvin H JR KOLB TWINSTAR · S/N 29Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1989 N77262Cessna 140 · S/N 11333Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1956 · Roche Porter A N794DBeech C35 · S/N D-3063Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1952 · Munns Dana K N11LCChristie Larison CHRISTEN EAGLE II · S/N CHRISTIE 0001Cancelled Dec 18, 2012 · Sale reported, pending cancellation · Built 1987 N387DMCirrus Design SR22 · S/N 2880Cancelled Aug 9, 2012 · Exported to Australia · Built 2007 · Breen Berni P N11403Cessna 150L · S/N 15075392Cancelled Apr 13, 2012 · Registration expired · Built 1973 · Jelinski James C N6367ECessna 172 · S/N 46467Cancelled Apr 13, 2012 · Third renewal notice · Built 1959 · Jelinski James C N12685Cessna 172M · S/N 17262175Cancelled Sep 21, 2009 · Triennial form not returned · Built 1973 · Feola Mario N74136Grumman American Avn. AA-5B · S/N AA5B-0152Cancelled Nov 12, 2008 · Triennial form not returned · Built 1975 · Pedersen Dennis M N96762Cessna 152 · S/N 15286020Cancelled Nov 8, 2007 · Triennial form not returned · Built 1985 · Rollins Dale G N3647YCessna 210C · S/N 21058147Cancelled Aug 21, 2007 · Triennial form not returned · Built 1963 · Carroll Egan G N83HYAviat A-1B · S/N 2183Cancelled Nov 9, 2006 · Triennial form not returned · Built 2002 · Thomas John D N7370LGrumman American Avn. AA-5 · S/N AA5-0270Cancelled Oct 11, 2006 · Triennial form not returned · Built 1972 · Wolfe Eugene N511WDDurr Wendell LANCAIR LEGACY · S/N L2K-147Cancelled Aug 11, 2006 · Triennial form not returned · Built 2003 · C & D Aircraft Sales Inc N9699WPiper PA-28-140 · S/N 28-23172Cancelled Apr 17, 2006 · Triennial form not returned · Built 1967 · Yordy William R Sr N49CStinson 108-2 · S/N 108-3249Cancelled Apr 5, 2006 · Triennial form not returned · Built 1947 · Greenwood Andrew W N2126ZPiper PA-28-161 · S/N 28-7916373Cancelled Mar 28, 2006 · Triennial form not returned · Built 1979 · Mear Management Agency N1618BLittle William L JR KOLB MARK III · S/N M3-127Cancelled Nov 30, 2004 · Built 1994 · Little William L Jr N9XVNelson Burl N RV9A · S/N 90218Cancelled Aug 20, 2004 · Exported to New Zealand · Nelson Burl N N95825Cessna 152 · S/N 15285971Cancelled Sep 20, 1994 · Exported to India · Parker Rhett Aircraft Sales Inc

Back to Diamondhead, MS