Birmingham, AL

Cancelled registrations · 305

Query with SQL
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 = 'BIRMINGHAM'
  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.

N3025VBeech 35 · S/N D-429Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1947 · Beech Nuts LLCN51CJGrimes Charles J BD-5B · S/N 2185Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1990 · Southern Museum Of Flight Foundation IncN14RHHayes PITTS S1C · S/N RMH1Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1977 · Southern Museum Of Flight Foundation IncN8090RBeech D55 · S/N TE-727Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1969 · Cloud Nine LLCN68PKPilatus PC-12/45 · S/N 265Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1999 · Regions Equipment Finance CorpN54196Fairchild M-62A · S/N T437048Cancelled Nov 20, 2017 · Revoked, canceled · Built 1943 · Missildine Thomas CN1389CPiper PA-18A-135 · S/N 18-2651Cancelled Oct 28, 2017 · Revoked, canceled · Built 1953 · Clark L RN125DCGrumman G-1159 · S/N 55Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1969 · Drummond Co IncN723EACirrus Design SR22 · S/N 1512Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Built 2005 · M & W Aviation LLCN2416WSchweizer SGS 1-26C · S/N 364Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1967 · Ward John PN662TBDJI PHANTOM 2 VISION + · S/N PH645319681 V2.0Cancelled Aug 18, 2017 · Barber Companies IncN39696Piper PA-32RT-300T · S/N 32R-7887147Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1978 · Daniel H.A.N131JGAero Commander 680 · S/N 680-515-185Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1957 · Southern Museum Of Flight Foundation IncN7689ZPiper PA-25-235 · S/N 25-3846Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1966 · Farmers Air ServiceN6388KRepublic RC-3 · S/N 617Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1947 · Seabee Training CorpN1615MBoeing E75 · S/N 75-8410Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1943 · Pittman John MN6SZSzybowcowy Zaklad Doswiadczaln SZD-36-A · S/N W813Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1977 · Miller Brenda L AdministratorN510BCMitsubishi MU-300 · S/N A057 S.A.Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1983 · Happy Trails LLCN904ACFokker D-VII · S/N 03Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Southern Museum Of Flight Foundation IncN700RJSmith AEROSTAR 601P · S/N 61P-0288-068Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1976 · M&W Aviation LLCN17799Aeronca K · S/N K-66Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Southern Museum Of Flight Foundation IncN3051DCessna 310 · S/N 35251Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1956 · Southern Museum Of Flight FoundationN3580SCessna 172E · S/N 17250780Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1963 · Enterprises Of S And T IncN14VYBeech A45 · S/N BG-74Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Southern Museum Of Flight FoundationN1065HAeronca 15AC · S/N 15AC-83Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1948 · Southern Museum Of Flight Foundation IncN56588Laister-Kauffman LK-10A · S/N 71Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Southern Museum Of Flight Foundation IncN111JBBrantley Junius STARDUSTER-I · S/N JB-01Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Southern Museum Of Flight Foundation IncN2699CCessna 310 · S/N 35099Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1955 · Maddox Daniel FN7540WPiper PA-28-180 · S/N 28-1473Cancelled Feb 22, 2017 · Sale reported · Built 1963N122STAero Commander 1121B · S/N 122Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1967 · Plain Old Plane LLCN7246VIntermountain CALLAIR A-9 · S/N 1283Cancelled Feb 4, 2017 · Revoked, canceled · Built 1966 · Clark L RN101EZFrierson VARIEZE · S/N 1182Cancelled Aug 9, 2016 · Third renewal notice · Built 1978 · Southern Museum Of Flight Foundation IncN937PJBrophy John W GLASTAR · S/N 5760Cancelled May 20, 2015 · Registration pending, canceled · Built 1999N41712Culver LCA · S/N 419Cancelled May 19, 2015 · Registration expired, pending cancellation · Southern Museum Of Flight FoundationN7XLLund Bruce R MUSTANG-II · S/N M-II-707Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1983 · Southern Museum Of Flight IncN532XCrews Ken AIR COMMAND 532 · S/N 091986Cancelled Dec 24, 2014 · Registration expired, pending cancellation · Crews KenN14529Tullis KR-2 · S/N 220Cancelled Dec 18, 2014 · Sale reported, canceled · Built 1978N1517CRochester DAVIS DA-2A · S/N 37Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1971 · Southern Museum Flight Foundation IncN2788YBeech 95 · S/N TD-170Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1958 · Mason Hugh C JrN7363ZPiper PA-25-235 · S/N 25-3316Cancelled Dec 8, 2014 · Exported to Mexico · Built 1965 · Cobb Trucking LLCN98316Piper PA-28-140 · S/N 28-26166Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1969 · Gilmer Virginia CN511RMReynolds Robert F CHALLENGER 1 SPECIAL · S/N 1098-CW-0703Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Reynolds Robert FN91368Grumman S2F-1 (TS-2A) · S/N 136560Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Southern Museum Of Flight Foundation IncN75GHHarrison MINI MAC · S/N 3Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1974 · Southern Museum Of Flight IncN7574CForney F-1 · S/N 5691Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1959 · Southern Museum Of Flight IncN76872Cessna 120 · S/N 11306Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1946 · Spivey Kenneth R JrN734ZPCessna 172N · S/N 17269247Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1977 · Drg FlyersN188DCGrumman American Avn. G-1159 · S/N 188Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1976 · Avion LLCN4719VBellanca 17-30 · S/N 30059Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1967 · Tyson Murray LN14TACessna 210B · S/N 21058007Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1962 · Thomas Truman A III
Back to Birmingham, AL