Schnake Lester F

Earlier aircraft under this name · 66

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'SCHNAKE LESTER F' OR list_contains(d.other_registrant_names, 'SCHNAKE LESTER F')
  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.

N1399HBeech 1900C · S/N 28-7725143Cancelled Sep 16, 1985 · Administratively canceled · Monjar Jane, Downey, CAN1556QCessna 150L · S/N 15072856Cancelled Feb 12, 1985 · Administratively canceled · Clinch John A, North Platte, NEN1554QCessna 150L · S/N 15072854Cancelled Jan 8, 1985 · Administratively canceled · Rivel Rafael, Long Beach, CAN149PABeech E18S · S/N BA-412Cancelled Oct 25, 1984 · Administratively canceled · Dole James A, Coventry, RIN13676Cessna 177B · S/N 17702452Cancelled Oct 5, 1984 · Administratively canceled · Commander Lease Ltd, Town & Country, MON146JSThorp T-18 · S/N 135Cancelled Aug 6, 1984 · Administratively canceled · Shinn Jeffrey N, Scotia, NYN1506RBeech 95 · S/N TD-139Cancelled Jul 24, 1984 · Administratively canceled · The Hughes Corporation, Las Vegas, NVN1547JRockwell International 112TC · S/N 13017Cancelled Jul 21, 1984 · Administratively canceled · Taylor William H Md, East Orange, NJN1437JCessna 210A · S/N 21057754Cancelled Jul 11, 1984 · Administratively canceled · Hoersch Raymond C, Chalfont, PAN13742Fairchild C-119C · S/N 49-194Cancelled Jul 3, 1984 · Administratively canceled · Hemet Valley Flying Serivce Co, Hemet, CAN1442FCessna 172H · S/N 17254937Cancelled Jul 3, 1984 · Administratively canceled · Neff Phil E DBA, Elko, NVN1479Lee BENSEN GYRO 83PB · S/N RL-1Cancelled Jul 3, 1984 · Administratively canceled · Lee Charles R, Virginia Beach, VAN1494WBell 206A · S/N 429Cancelled Jul 3, 1984 · Administratively canceled · Keystone Helicopter Corp Of Va, West Chester, PAN1443WBell 206B · S/N 372Cancelled Apr 17, 1984 · Administratively canceled · Bell Helicopter Textron Inc, Ft Worth, TXN1370XBell 47G-5 · S/N 7837Cancelled Feb 18, 1984 · Administratively canceled · Condor Helicopters & Aviation Inc, Oxnard, CAN1530KLuscombe 8A · S/N 4257Cancelled Dec 17, 1983 · Administratively canceled · Bates Arthur E, Poway, CAN1381GCessna 340A · S/N 340A0080Cancelled Nov 23, 1983 · Administratively canceled · Casper Air Service Inc, Casper, WYN1410ZBeech D-45 · S/N BG-287Cancelled Nov 23, 1983 · Administratively canceled · US Navy Owner, Lemoore, CAN1434QCessna 150L · S/N 15072734Cancelled Nov 23, 1983 · Administratively canceled · Flowers T Earl, Hartsville, SCN1378LCessna T337H · S/N 33701870Cancelled Sep 14, 1983 · Administratively canceled · Agri Till Leasing Co, Five Points, CAN1411MCessna 411 · S/N 411-0160Cancelled Sep 14, 1983 · Administratively canceled · Clubb Burt H, Bokeelia, FLN1498UCessna 172M · S/N 17267165Cancelled Sep 14, 1983 · Administratively canceled · Central Ohio Flyers Association, Columbus, OHN1548JPiper PA-28-140 · S/N 28-23952Cancelled Aug 2, 1983 · Administratively canceled · Annapolis Flying Service Inc, Edgewater, MDN14168Piper PA-23-250 · S/N 27-4732Cancelled Jun 25, 1983 · Administratively canceled · Nordquist Neil H, Novato, CAN1361LCessna 337H · S/N 33701853Cancelled May 14, 1983 · Administratively canceled · September Leasing Corporation, San Antonio, TXN1458APiper PA-22 · S/N 22-360Cancelled Apr 16, 1983 · Administratively canceled · Furey James Jr, Wesson, MSN1553TCessna 402B · S/N 402B0317Cancelled Apr 16, 1983 · Administratively canceled · Schroeder Leonard F DBA, Houston, TXN1432GCessna 340A · S/N 340A0095Cancelled Feb 16, 1983 · Administratively canceled · Tom Fairey Company, Kyle, TXN1365QCessna 150L · S/N 15072665Cancelled Feb 12, 1983 · Administratively canceled · Whipple Dennis R, Modesto, CAN1402GCessna 402B · S/N 402B0575Cancelled Dec 31, 1982 · Administratively canceled · Weiser H G, Dallas, TXN1489XPiper PA-28R-200 · S/N 28R-7535298Cancelled Dec 11, 1982 · Administratively canceled · Family Travel Inc, Greenville, ILN149JAMitsubishi MU-2B-40 · S/N 402 SACancelled Dec 11, 1982 · Administratively canceled · J A Baldwin Manuf Co, Kearney, NEN14926Munninghoff WAR FW-190 · S/N 70Cancelled Dec 9, 1982 · Administratively canceled · Drury Edward D, Manville, NJN15197Piper PA-28R-200 · S/N 28R-7335035Cancelled Nov 11, 1982 · Administratively canceled · Sumter Airways Inc, Sumter, SCN1392FCessna 172G · S/N 17254887Cancelled Nov 6, 1982 · Administratively canceled · Borner Arthur, Los Angeles, CAN1373APiper PA-18-125 · S/N 18-1202Cancelled Nov 4, 1982 · Administratively canceled · Hannon Harry R, Anchorage, AKN144EPiper PA-23 · S/N 23-819Cancelled Nov 4, 1982 · Administratively canceled · Jahnke Phyllis C, American Falls, IDN1499FCessna 172H · S/N 17254994Cancelled Nov 4, 1982 · Administratively canceled · Crater David L, Edmond, OKN1387TPiper PA-34-200 · S/N 34-7250305Cancelled Oct 7, 1982 · Administratively canceled · Burnside Ott Avn Training Center Inc, Opa Locka, FLN155HAHiller UH-12E · S/N HA3055Cancelled Oct 2, 1982 · Administratively canceled · Murrayair Limited, Honolulu, HIN1433JRockwell International 112A · S/N 433Cancelled Sep 23, 1982 · Administratively canceled · Butler James J Jr, Costa Mesa, CAN148AFPiper PA-23-250 · S/N 27-266Cancelled Sep 23, 1982 · Administratively canceled · Evans N K, Edinburg, TXN1502XPiper PA-28-151 · S/N 28-7515401Cancelled Sep 16, 1982 · Administratively canceled · Ambrose L Jackson Co Inc, Willingboro, NJN14755Bellanca 17-31ATC · S/N 74-31080Cancelled Sep 11, 1982 · Administratively canceled · Porter Robert J, Venice, CAN1423RGrumman American Avn. AA-1B · S/N AA1B-0523Cancelled Aug 12, 1982 · Administratively canceled · Gulf Aire Enterprises Inc, Thibodaux, LAN14779Bellanca 17-30A · S/N 74-30683Cancelled Aug 12, 1982 · Administratively canceled · Shelton David C, Columbus, MSN1485TPiper PA-28-140 · S/N 28-7225532Cancelled Aug 12, 1982 · Administratively canceled · Palm George D, San Diego, CAN140ALBell 212 · S/N 30683Cancelled Jun 3, 1982 · Administratively canceled · Manufacturers Hanover Leasing Corp, New York, NYN13589Cessna 177B · S/N 17702439Cancelled May 29, 1982 · Administratively canceled · Darby John E Jr, Dunwoody, GAN145DCBeech C-45H · S/N AF-564Cancelled May 8, 1982 · Administratively canceled · M & S Acft Svc Inc, Lake City, FL
Back to Schnake Lester F