OpenAirDocs.org
Selma, AL

Cancelled registrations · 42

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

N2509NCessna 140 · S/N 12766Cancelled Aug 8, 2023 · Sale reported · Built 1947N4562BFrye Leonard W BENSEN B-8M · S/N 111450Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1979 · Frye Leonard WN22520Stinson HW75 · S/N 7091Cancelled Jul 26, 2018 · Revoked, canceled · Built 1939 · Mccormick John MaconN4389GM-Squared BREESE 2 · S/N 000595Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 2004 · Godwin CecilN3131EAeronca 7AC · S/N 7AC-6728Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1946 · Frith Andrew LN4927JCessna T188C · S/N T18803782TCancelled May 20, 2015 · Registration expired, pending cancellation · Built 1981 · Mccormick Eugene C DBAN1080EBellanca 7GCBC · S/N 978-77Cancelled Oct 17, 2014 · Registration expired, pending cancellation · Built 1977 · Aerial Patrol Co LLCN46942Bell UH-1B · S/N 63-8521Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1963 · Precision Air Service IncN5314GCessna 305A · S/N 22490Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1951 · Frith Andrew LN160FBConstrucciones Aeronauticas C-212-CC · S/N 160Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Aim Leasing CorpN9907JCessna T188C · S/N T18803861TCancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1981 · Mccormick Eugene C DBAN68632Bell 47D1 · S/N WH5003Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1963 · Avico IncN4729RCessna A188B · S/N 18802308TCancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1975 · Mccormick Eugene C DBAN90873Brown VOLKSPLANE VP-2 · S/N 1698Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1973N4608XCessna 150G · S/N 15064658Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1966 · Parker Edgar EarlN43176Taylorcraft 19 · S/N 6835Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1946 · Weeks Aubrey FN121NRHiller UH-12E · S/N 1594Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1964 · Mccormick Eugene C DBAN45696Cessna 177RG · S/N 177RG1127Cancelled Nov 14, 2012 · Sale reported, canceled · Built 1977N2962GCallair A-5T · S/N 317Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1961 · Wiseman RexN554ABensen B-8M · S/N BTS8-MCancelled Sep 21, 2012 · Sale reported, pending cancellation · Built 1962N265RDBell 47G-3 · S/N 2637Cancelled Sep 20, 2012 · Revoked, canceled · Built 1961 · Aerial Application Technologies LLCN6712DBell 47G-3B · S/N 2203Cancelled Sep 20, 2012 · Revoked, canceled · Built 1957 · Aerial Application Technologies LLCN48357Bell 206B · S/N 776Cancelled Apr 12, 2012 · Exported to Canada · Built 1972N313MCCurrent Mike KITFOX · S/N 313Cancelled Sep 22, 2005 · Triennial form not returned · Built 1990 · Coffee Ronald TN2243WBell 47G-3B-2 · S/N 6755Cancelled Nov 13, 2003 · Triennial form not returned · Built 1969 · Aerial Application Technologies LLCN26937Gulfstream American AA-5A · S/N AA5A0824Cancelled Jul 24, 2001 · Triennial form not returned · Lerner Aaron CN818HJBell 47G-2A · S/N 2764Cancelled Dec 14, 2000 · Aerial Application Technologies LLCN205MYBell UH-1H · S/N 6509790Cancelled Sep 4, 1997 · Exported to Mexico · Precision Air Services IncN2859ZPiper PA-22-150 · S/N 226856Cancelled Sep 15, 1992 · Triennial form not returned · Agee Jerome ZN13571Cessna 172M · S/N 17262855Cancelled Aug 26, 1991 · Cammack Norphlet GN7936Grumman Acft ENG Cor-Schweizer G-164A · S/N 821Cancelled Oct 3, 1980 · Jewell Flying Service IncN10102Cessna 150L · S/N 15074795Cancelled Oct 6, 1975 · Built 1973 · Sky Harbor AviationN3318ZPiper PA-22-150 · S/N 22-7253Cancelled Dec 29, 1970 · Gibbons Aviation CompanyN8135CPiper PA-22-135 · S/N 22-2280Cancelled Oct 26, 1970 · Norris HermanN246RWiseman Rex RYAN SSPECIAL · S/N 1644Cancelled Sep 15, 1970 · Wiseman Rex WN3083JCessna 150E · S/N 15061183Cancelled Aug 31, 1970 · Selma Flg Svc IncN5871WPiper PA-28-160 · S/N 28-2480Cancelled Nov 24, 1965 · Selma Flying Service IncN64680Consolidated Vultee BT-13B (SNV-2) · S/N 79-249Cancelled Feb 17, 1956 · Stroop Robert CN1292KLuscombe 8A · S/N 4019Cancelled Oct 17, 1955 · Built 1946 · Van Kesteren HenryN27275Porterfield LP-65 · S/N 756Cancelled Nov 3, 1954 · Esco Ralph EN89108Cessna 140 · S/N 8116Cancelled Sep 11, 1950 · Judson T/Sgt. Darrell CN3064Advance WACO 9 · S/N 368Cancellation date not recorded · Built 1927 · Saffold Airplane Co
Back to Selma, AL