Bearry Lonnie H

Earlier aircraft under this name · 104

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 = 'BEARRY LONNIE H' OR list_contains(d.other_registrant_names, 'BEARRY LONNIE H')
  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.

N15908Piper PA-28-180 · S/N 28-7305183Cancelled Sep 27, 1985 · Administratively canceled · Khaler Robert B, Phoenix, AZN13225Cessna 172M · S/N 17262588Cancelled Sep 16, 1985 · Administratively canceled · Hittle Wayne, Topeka, KSN1399HBeech 1900C · S/N 28-7725143Cancelled Sep 16, 1985 · Administratively canceled · Monjar Jane, Downey, CAN1586MCessna A188A · S/N 18800686Cancelled Feb 20, 1985 · Administratively canceled · Turner Danny L, Bruce, MSN1615PPiper PA-22-150 · S/N 22-2429Cancelled Feb 14, 1985 · Administratively canceled · Bass Perry D, Merry Hill, NCN1556QCessna 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, CAN1589ECessna 172N · S/N 17271055Cancelled Jan 8, 1985 · Administratively canceled · Martin William H Jr, Wichita, KSN1575APiper PA-22 · S/N 22-352Cancelled Oct 26, 1984 · Administratively canceled · Hansen Douglas J, Little Canada, MNN149PABeech 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, MON1338QCessna 150L · S/N 15072638Cancelled Oct 3, 1984 · Administratively canceled · Teach Victor DBA, Beeville, TXN146JSThorp 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, PAN1631RGrumman American Avn. AA-1B · S/N AA1B-0631Cancelled Jul 3, 1984 · Administratively canceled · Keller Robert T DBA, Richmond Hts, OHN1326RGrumman American Avn. AA-5 · S/N AA5-0726Cancelled Jun 15, 1984 · Administratively canceled · Key To The City Inc, Rochester, NYN1443WBell 206B · S/N 372Cancelled Apr 17, 1984 · Administratively canceled · Bell Helicopter Textron Inc, Ft Worth, TXN13336Cessna 172M · S/N 17262680Cancelled Mar 27, 1984 · Administratively canceled · Allen Jack L, Hayward, CAN1370XBell 47G-5 · S/N 7837Cancelled Feb 18, 1984 · Administratively canceled · Condor Helicopters & Aviation Inc, Oxnard, CAN1349VCessna R172K · S/N R1722177Cancelled Jan 10, 1984 · Administratively canceled · Spalsbury Coleen, Westminster, CAN1530KLuscombe 8A · S/N 4257Cancelled Dec 17, 1983 · Administratively canceled · Bates Arthur E, Poway, CAN1317ZBeech N35 · S/N D-6751Cancelled Nov 29, 1983 · Administratively canceled · Bonanza 17 Zulu, Baton Rouge, LAN1381GCessna 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, SCN15651Piper PA-28-180 · S/N 28-7305108Cancelled Nov 23, 1983 · Administratively canceled · Rio Creek Aviators Inc, Algoma, WIN1598UCessna 172M · S/N 17267177Cancelled Nov 23, 1983 · Administratively canceled · Gensler William DBA, Racine, WIN1378LCessna 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, OHN16086Cessna 150 · S/N 17985Cancelled Sep 14, 1983 · Administratively canceled · Baker Richard D, Saegertown, PAN1548JPiper PA-28-140 · S/N 28-23952Cancelled Aug 2, 1983 · Administratively canceled · Annapolis Flying Service Inc, Edgewater, MDN158TCBeech 58TC · S/N TK-1Cancelled Aug 2, 1983 · Administratively canceled · Beech Aircraft Corporation, Wichita, KSN1582VCessna 172M · S/N 17263679Cancelled Jul 22, 1983 · Administratively canceled · Tacot Gustave A Jr, Tallahassee, FLN1327QCessna 150L · S/N 15072627Cancelled Jun 25, 1983 · Administratively canceled · Jim Ratliff Air Service Inc, Columbus, MSN1330UCessna 172M · S/N 17267018Cancelled Jun 25, 1983 · Administratively canceled · Lakso John A, Sacramento, CAN14168Piper PA-23-250 · S/N 27-4732Cancelled Jun 25, 1983 · Administratively canceled · Nordquist Neil H, Novato, CAN1585DCessna 195A · S/N 7868Cancelled Jun 25, 1983 · Administratively canceled · Mccaslin Ben H, Lexington, OKN1633UCessna 207 · S/N 20700233Cancelled Jun 22, 1983 · Administratively canceled · Yukon Air Service Inc, Fairbanks, AKN1361LCessna 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, CA
Back to Bearry Lonnie H