OpenAirDocs.org
Delogra Aviation Corp

Earlier aircraft under this name · 34

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 = 'DELOGRA AVIATION CORP' OR list_contains(d.other_registrant_names, 'DELOGRA AVIATION CORP')
  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.

N6817CBeech C-45F · S/N 44-47693Cancelled Jun 5, 2020 · Revoked, canceled · Ft Lauderdale, FLN6819CBeech C-45F · S/N 44-47083Cancelled Jun 5, 2020 · Revoked, canceled · Ft Lauderdale, FLN6816CBeech C-45F · S/N 44-47688Cancelled May 29, 2020 · Revoked, canceled · Ft Lauderdale, FLN6818CBeech C-45F · S/N 44-47054Cancelled May 5, 2020 · Revoked, pending cancellation · Ft Lauderdale, FLN8010HBeech C-45F · S/N 44-47340Cancelled Sep 24, 2018 · Revoked, canceled · Fort Lauderdale, FLN8013HBeech C-45F · S/N 44-47648Cancelled Sep 20, 2018 · Revoked, canceled · Fort Lauderdale, FLN8017HBeech C18S · S/N 43-43469Cancelled Sep 20, 2018 · Revoked, canceled · Fort Lauderdale, FLN8019HBeech C18S · S/N 42-56766Cancelled Sep 20, 2018 · Revoked, canceled · Fort Lauderdale, FLN8022HBeech AT-7A · S/N 41-21153Cancelled Sep 20, 2018 · Revoked, canceled · Fort Lauderdale, FLN8023HBeech AT-7 · S/N 42-2495Cancelled Sep 20, 2018 · Revoked, canceled · Fort Lauderdale, FLN8024HBeech AT-7 · S/N 43-33320Cancelled Sep 20, 2018 · Revoked, canceled · Fort Lauderdale, FLN8026HBeech AT-7 · S/N 43-33372Cancelled Sep 20, 2018 · Revoked, canceled · Fort Lauderdale, FLN8027HBeech AT-7C · S/N 43-33505Cancelled Sep 20, 2018 · Revoked, canceled · Fort Lauderdale, FLN8028HBeech C18S · S/N 42-43497Cancelled Sep 20, 2018 · Revoked, canceled · Fort Lauderdale, FLN6793CBeech C-45F · S/N 44-47163Cancelled Sep 18, 2018 · Revoked, canceled · Ft Lauderdale, FLN6796CBeech C-45F · S/N 44-47303Cancelled Sep 7, 2018 · Revoked, canceled · Ft Lauderdale, FLN6798CBeech C-45F · S/N 44-47358Cancelled Sep 7, 2018 · Revoked, canceled · Ft Lauderdale, FLN6802CBeech C-45F · S/N 44-47497Cancelled Sep 7, 2018 · Revoked, canceled · Ft Lauderdale, FLN6809CBeech C-45F · S/N 44-47618Cancelled Aug 28, 2018 · Revoked, canceled · Ft Lauderdale, FLN8006HBeech C-45F · S/N 44-47180Cancelled Aug 23, 2018 · Revoked, canceled · Fort Lauderdale, FLN8012HBeech C-45F · S/N 44-47453Cancelled Jul 19, 2018 · Revoked, pending cancellation · Fort Lauderdale, FLN8018HBeech C18S · S/N 42-56728Cancelled Jul 19, 2018 · Revoked, pending cancellation · Fort Lauderdale, FLN8029HBeech AT-7 · S/N 42-56817Cancelled Jul 19, 2018 · Revoked, pending cancellation · Fort Lauderdale, FLN6400CBeech C18S · S/N 42-43493Cancelled Apr 10, 2018 · Revoked, canceled · Ft Lauderdale, FLN6274CBeech C-45 · S/N 44-47689Cancelled Nov 21, 2017 · Revoked, canceled · Ft Lauderdale, FLN6275CBeech C-45 · S/N 43-35742Cancelled Nov 21, 2017 · Revoked, canceled · Ft Lauderdale, FLN6276CBeech C-45 · S/N 44-87042Cancelled Nov 21, 2017 · Revoked, canceled · Ft Lauderdale, FLN6277CBeech C-45 · S/N 43-35879Cancelled Nov 21, 2017 · Revoked, canceled · Ft Lauderdale, FLN6279CBeech AT-7 · S/N 43-33396Cancelled Nov 21, 2017 · Revoked, canceled · Ft Lauderdale, FLN6280CBeech AT-7 · S/N 42-2481Cancelled Nov 21, 2017 · Revoked, canceled · Ft Lauderdale, FLN8005HBeech C-45F · S/N 44-47161Cancelled Nov 21, 2017 · Revoked, canceled · Fort Lauderdale, FLN8009HBeech C-45F · S/N 44-47217Cancelled Nov 21, 2017 · Revoked, canceled · Fort Lauderdale, FLN6811CBeech C-45F · S/N 44-47665Cancelled Oct 23, 2013 · Revoked, canceled · Ft Lauderdale, FLN6273CBeech C-45 · S/N 43-35747Cancelled Aug 5, 2013 · Revoked, canceled · Ft Lauderdale, FL
Back to Delogra Aviation Corp