Flanagan Kirmet

Earlier aircraft under this name · 22

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 = 'FLANAGAN KIRMET' OR list_contains(d.other_registrant_names, 'FLANAGAN KIRMET')
  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.

N8637ZCessna P206C · S/N P206-0437Cancelled Jan 22, 1985 · Administratively canceled · Parker Richard, Andrews, NCN86804Bellanca 14-13-2 · S/N 1165Cancelled Jan 22, 1985 · Administratively canceled · Tocher Arlen C, Carmichael, CAN8732EPiper PA-28-151 · S/N 28-7615155Cancelled Jan 22, 1985 · Administratively canceled · Turner Jay O, Woodside, CAN8738Boeing 707-331B · S/N 20067Cancelled Aug 22, 1984 · Administratively canceled · Irving Trust Co Trustee, New York, NYN8706WPiper PA-28-235 · S/N 28-10239Cancelled Aug 11, 1984 · Administratively canceled · Urban Norman A, Warren, MIN8735Boeing 707-331B · S/N 20064Cancelled Aug 6, 1984 · Administratively canceled · Aviation Sales Company Inc, Miami, FLN86869Bellanca 14-13 · S/N 1231Cancelled Aug 1, 1984 · Administratively canceled · Weir Lyon S, Los Angeles, CAN8646Bellanca 7ECA · S/N 919-73Cancelled Jul 11, 1984 · Administratively canceled · Stout Glenn L, Iowa Park, TXN8667FHughes Helicopters HUGHES 369D · S/N 280272DCancelled Apr 3, 1984 · Administratively canceled · Gatx Leasing Corporation, San Francisco, CAN8729Boeing 707-331B · S/N 20058Cancelled Apr 3, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NYN8705TBoeing 707-331B · S/N 18916Cancelled Feb 22, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NYN8725TBoeing 707-331B · S/N 18918Cancelled Feb 22, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NYN8663VBellanca 7GCBC · S/N 823-75Cancelled Nov 23, 1983 · Administratively canceled · Northern Eagle Airways Inc, Thief River Falls, MNN8691HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1470Cancelled Jul 22, 1983 · Administratively canceled · Reynolds Ernest DBA, Mccrory, ARN8721MBeech 23 · S/N M-510Cancelled Jun 8, 1983 · Administratively canceled · Coverdale Harold F, Texarkana, LAN868BMooney M20 · S/N 1030Cancelled Mar 19, 1983 · Administratively canceled · Knoff Patricia Ann, Jacksonville, TXN8689SAir Tractor AT-301 · S/N 301-0173Cancelled Feb 16, 1983 · Administratively canceled · Kewanee Ag Service Inc, New Madrid, MON8754MBeech 23 · S/N M-542Cancelled Feb 16, 1983 · Administratively canceled · Boskind Richard M, Indialantic, FLN87DSScherer COUGER-A · S/N 1Cancelled Feb 12, 1983 · Administratively canceled · Scherer Roland D, Manhattan Beach, CAN8633UCessna 172F · S/N 17252535Cancelled Oct 7, 1982 · Administratively canceled · Flytel Flying Club, Oak Park, MIN8652VBellanca 8GCBC · S/N 166-75Cancelled Oct 2, 1982 · Administratively canceled · Delta Flying Service Inc, Walls, MSN86670Hanson Starduster SA100 · S/N 13Cancelled Oct 2, 1982 · Administratively canceled · Allen George A, Scottsdale, AZ
Back to Flanagan Kirmet