Skip to content

Cancelled registrations · 104

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 = 'AL' AND d.registrant_city = 'DOTHAN' 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 = 'AL' AND d.registrant_city = 'DOTHAN'
  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 = 'AL' AND d.registrant_city = 'DOTHAN'
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.

N22749Piper J3C-65 · S/N 2717Cancelled Nov 2, 2024 · Revoked, canceled · Built 1940 · Dothan Aviation Corp N9601KStinson 108-2 · S/N 108-2601Cancelled Nov 4, 2023 · Sale reported, canceled · Built 1947 N8PSPiper PA-24 · S/N 24-1415Cancelled Apr 12, 2023 · Built 1959 · Perry John A II N2331BPiper PA-38-112 · S/N 38-79A0012Cancelled Jan 4, 2023 · Sale reported, canceled · Built 1978 N1225GGonzales Mark S CHALLENGER II · S/N CH2-0697-1632Cancelled Sep 22, 2022 · Built 2021 · Gonzales Mark S N112GMBeech 58TC · S/N TK-136Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1981 · Dothan Security Inc N5507UBellanca 7ECA · S/N 1268-78Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1978 · Flowers John N3485HEngineering & Research ERCOUPE 415-C · S/N 4110Cancelled Oct 25, 2019 · Revoked, pending cancellation · Built 1946 · Martin Roy N1340RGrumman American Avn. AA-5 · S/N AA5-0740Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1975 · Monday Nicholas M N6159PPiper PA-24-250 · S/N 24-412Cancelled Dec 12, 2018 · Registration expired, pending cancellation · Built 1958 · Lockett Terrell M N95480Piper J3C-65 · S/N 8403Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1942 · Haase Steven A N804EVEvektor-Aerotechnik SPORTSTAR · S/N 2006 0804Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 2006 · Fletcher Kenneth C N612BCCessna T210L · S/N 21059566Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Movie Galllery US LLC N104SAPiper PA-28-161 · S/N 28-8016165Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1979 · Lockett Terrell M N3725CBoeing E75N1 · S/N 758126Cancelled Nov 22, 2017 · Revoked, canceled · C And H Dusting Svc N1358XBell 47G-3B-1 · S/N 6569Cancelled Jul 13, 2017 · Registration expired, pending cancellation · Built 1966 · Williams Bill N5820XBell TH-1L · S/N 157832Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Williams Bill N1299YCessna 150B · S/N 15059699Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1962 · Ragan Harvey R N746YGrumman G-164A · S/N 402Cancelled Feb 4, 2017 · Revoked, canceled · Built 1966 · Dothan Aviation Corp Inc N2832QCessna 172L · S/N 17259832Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1971 · Pharr Leonard C N7146HPiper J3C-65 · S/N 20403Cancelled Dec 22, 2014 · Revoked, canceled · Built 1946 · Dothan Aviation Corp N7073DPiper PA-18A 150 · S/N 18-5554Cancelled Dec 2, 2014 · Revoked, canceled · Built 1957 · Dolthan Avn Corp N2220MPiper J3C-65 · S/N 21012Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1946 · Hyers Bennie A Jr N1417APiper PA-22 · S/N 22-328Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1951 · Fletcher Charles E N754SCBeech B200 · S/N BB1345Cancelled Aug 22, 2014 · Exported to Canada · Flowers Paul R N22NBRockwell International NA-265-80 · S/N 380-56Cancelled Jul 10, 2014 · Built 1977 · Construction Partners Inc N6657Grumman G-164A · S/N 780Cancelled Sep 26, 2013 · Revoked, canceled · Built 1970 · Dothan Aviation Corporation Inc N6692HPiper J3C-65 · S/N 19904Cancelled Sep 26, 2013 · Revoked, canceled · Built 1946 · Dothan Aviation Corporation N205SABell 205A-1 · S/N 30130Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1973 · Williams Bill N47004Bell 205D · S/N 3211Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1967 · Williams Bill N3756BBradshaw Lon D HA-2M SPORTSTER · S/N 095Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1980 · Bradshaw Lon D N874CPBritish Aerospace BAE JETSTREAM 3201 · S/N 874Cancelled May 22, 2013 · Exported to Canada · Built 1989 · Cku Aviation LLC N6795XCessna 310F · S/N 310-0095Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1961 · Leonard Jimmy P N5687NEnstrom F-28C · S/N 463-2Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1979 · Skip-There LLC N3121PConsolidated Aeronautics LAKE LA-4-200 · S/N 983Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1979 · Cannon Glenn N5232Bell OH-13G · S/N 52-7963Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1952 · Crowley Gerald B N7905Grumman G-164A · S/N 811Cancelled Nov 8, 2012 · Sale reported, pending cancellation · Built 1971 N66490Boeing E75N1 · S/N 75-8379Cancelled Oct 11, 2012 · Sale reported, pending cancellation · Built 1943 N5269Grumman G-164A · S/N 548Cancelled Aug 14, 2012 · Revoked, canceled · Built 1968 · Warren Joseph E N66564Piper J3C-65 · S/N 4321Cancelled Aug 8, 2012 · Sale reported, pending cancellation N40743Piper J3C-65 · S/N 7457Cancelled Jun 4, 2012 · Revoked, canceled · Built 1941 · Dothan Aviation Corp Inc N7599ZPiper PA-25-235 · S/N 25-3689Cancelled Aug 2, 2011 · Expired dealer · Built 1965 · Dothan Aviation Corp Inc N6510ZPiper PA-25-235 · S/N 25-2038Cancelled Jul 18, 2011 · Expired dealer · Built 1962 · Dothan Aviation Corp Inc N30515Pearson Mark 1600R · S/N 2196P5Cancelled Apr 2, 2010 · Second triennial mailing, no response · Built 1999 · Harbert Gary J II N6384CPiper PA-28R-201 · S/N 28R7837164Cancelled Aug 18, 2008 · Exported to Australia · Willis Thomas K N84JCPiper PA-32-300 · S/N 32-7540068Cancelled Jun 6, 2008 · Triennial form not returned · Built 1974 · Byard Mark A N94GRSmith Gordon R SEA REY · S/N 1MK-025Cancelled Sep 18, 2007 · Triennial form not returned · Built 1995 · Smith Daniel O N41003Piper PA 46-350P · S/N 4622044Cancelled Feb 3, 2005 · Triennial form not returned · Built 1989 · M & M Aero LLC N4491UCessna 150D · S/N 15060491Cancelled Dec 3, 2003 · Triennial form not returned · Built 1964 · Daum Charles A Jr N606WWSmith AEROSTAR 600 · S/N 60-0278-106Cancelled Jun 23, 2003 · Exported to South Africa · Built 1975 · Trim Inc

Back to Dothan, AL