Skip to content

Cancelled registrations · 53

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 = 'BESSEMER' 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 = 'BESSEMER'
  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 = 'BESSEMER'
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.

N46766Aeronca 0-58A · S/N 7797Cancelled May 23, 2020 · Revoked, canceled · Built 1941 · Faulk Rex N46371Fairchild M-62A · S/N 5313AECancelled Nov 14, 2019 · Revoked, pending cancellation · Built 1943 · Roberson A L Jr N80895Klass CRUISE · S/N G10M707743Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Built 2004 · Wood Charles K N25864Piper J4A · S/N 4827Cancelled Oct 28, 2017 · Revoked, canceled · Built 1939 · Mcdaniel R C N499BACessna 208B · S/N 208B-0689Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1998 · Air Carriers Inc N93885Cessna 210L · S/N 21060444Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1974 · Air Carriers Inc N84853Aeronca 7AC · S/N 7AC-3572Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Church Of God Of Prophecy N8554CPiper PA-32R-300 · S/N 32R-7680122Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1976 · Air Carriers Inc N3793Dehavilland DH104 DOVE 2A · S/N 04331Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1952 N22165Cessna 150H · S/N 15068110Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1967 · Prestridge John M N640GFKlass CRUISE · S/N G10-498640Cancelled Aug 5, 2013 · Sale reported, canceled · Built 2006 N9726DPiper PA-22-150 · S/N 22-6633Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1959 · Toole L Lewis N9240UCessna 150M · S/N 15078190Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1976 · Red Barron Aviation N8327UCessna 172F · S/N 17252227Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1964 · Aero Group LLC N71859Cessna 182M · S/N 18259782Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1969 · Hughes James H N6489DNavion NAVION A · S/N NAV-4-1675Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1959 · Thomas Roy N1399GCessna 402B · S/N 402B0573Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1974 · Air Carriers Inc N504AAAuthier Anthony P TIERRA II · S/N 504505559Cancelled Apr 2, 2013 · Sale reported, canceled N81864Aeronca 7AC · S/N 7AC-487Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1946 N6147GCessna 150K · S/N 15071647Cancelled Feb 11, 2013 · Sale reported, canceled · Built 1970 N1565VDehavilland DH104 DOVE 6A · S/N 4451Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1954 · Hudson Thomas C Jr N13GJRuschke Gerald James SONERAI II L · S/N 1947RCancelled Jan 25, 2013 · Sale reported, pending cancellation N5263YPiper PA-23-250 · S/N 27-2326Cancelled Aug 14, 2012 · Revoked, canceled · Built 1963 · Aviation Services N5097WPiper PA-28-160 · S/N 28-109Cancelled Jan 24, 2012 · Revoked, pending cancellation · Built 1961 · Clark L R N5013ZPiper PA-22-108 · S/N 22-8620Cancelled Jan 12, 2012 · Revoked, pending cancellation · Built 1961 · Clark L R N4691ZPiper PA-22-108 · S/N 22-8229Cancelled Sep 12, 2011 · Revoked, pending cancellation · Built 1961 · Clark L R N546BBeech A35 · S/N D-1564Cancelled Sep 10, 2009 · Triennial form not returned · Built 1948 · Brown Sterling R N7PJCessna 210L · S/N 21060754Cancelled Apr 9, 2008 · Exported to Mexico · Built 1975 · Air Carriers Inc N9004GAerospatiale AS350BA · S/N 1031Cancelled Oct 31, 2007 · Exported to Canada · Built 1978 · Aerotec LLC N82049Champion 7AC · S/N 7AC-675Cancelled Apr 7, 2006 · Triennial form not returned · Built 1946 · Champion Flyers Flying Club Inc N9455MCessna 210K · S/N 21059355Cancelled Aug 18, 2005 · Exported to Mexico · Built 1970 · Air Carriers Inc N7376UCessna 411 · S/N 411-0076Cancelled Jul 25, 2005 · Second triennial mailing, no response · Built 1965 · H And W Aviation N3996LWeekley/Weekley TURNER SUPER T-40A · S/N 247Cancelled Nov 9, 2004 · Triennial form not returned · Weekley Lebbeous E Jr N699RFSmith AEROSTAR 600 · S/N 600169074Cancelled Mar 12, 2004 · Triennial form not returned · Built 1974 · Air Carriers Inc N91WWSmith AEROSTAR 600 · S/N 60-0262-105Cancelled Mar 11, 2004 · Triennial form not returned · Built 1975 · Air Carriers Inc N6554BCessna 210M · S/N 21062785Cancelled Apr 23, 2002 · Exported to Hungary · Built 1978 · Air Carriers Inc N5105GCessna 172H · S/N 17256222Cancelled Nov 16, 2000 · Triennial form not returned · Young Robert C N9759QSmith AEROSTAR 600 · S/N 60-0380-135Cancelled May 9, 2000 · Exported to South Africa · Alabama Bancserv Inc N395WMHughes 369HS · S/N 760828SCancelled May 5, 2000 · Vertical Air Inc N2332WBeech A23A · S/N M-929Cancelled Mar 10, 2000 · Triennial form not returned · Stokes Ronald K N848TMPiper AEROSTAR 600 · S/N 6005987961192Cancelled Sep 28, 1999 · Exported to South Africa · Alabama Bancserv Inc N11GTAero Commander 680FL · S/N 135736Cancelled Apr 13, 1992 · Administratively canceled · Mclaughlin We DBA N152CMC E Mccarley SPECIAL 1600 · S/N 53122Cancelled Jul 4, 1980 · Administratively canceled · Mccarley C E N6149SAir & Space America 18A · S/N 18-60Cancelled Dec 30, 1970 · Robinson Carl R N81114Funk B75L · S/N 244Cancelled Dec 16, 1970 · Built 1946 · Dunlavy Marvin H Jr N82128Aeronca 7AC · S/N 7AC-754Cancelled Oct 27, 1970 · Built 1946 · Pratt Jack E N3741MPiper PA-12 · S/N 122682Cancelled May 20, 1965 · Outlaw K G N25503Timm N2T-1 · S/N 348Cancelled May 21, 1960 · David P Phillips N4289EAeronca 11CC · S/N 11CC159Cancelled Jan 12, 1960 · Roszell Marcus A N2114MPiper J3C-65 · S/N 20897Cancelled Nov 30, 1955 · Ayers Grady L

Back to Bessemer, AL