OpenAirDocs.org
Styles Aviation Inc

Earlier aircraft under this name · 20

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

N67315Cessna 152 · S/N 15285293Cancelled Mar 15, 2006 · Triennial form not returned · Lagrangeville, NYN87519Cessna 421B · S/N 421B0962Cancelled Mar 15, 2006 · Second triennial mailing, no response · Built 1975 · Pleasant Valley, NYN334RAS.O.C.A.T.A. RALLYE 150 ST · S/N 3096Cancelled Feb 2, 1999 · Triennial form not returned · La Grangeville, NYN9072ARobinson Helicopter R22 · S/N 0206Cancelled Jul 15, 1998 · Triennial form not returned · Lagrangeville, NYN392ACFairchild Heli-Porter PILATUS PC6/B2-H2 · S/N 2071Cancelled Sep 19, 1997 · Exported to France · Lagrangeville, NYN6251UPilatus PC-6-H2 · S/N 518Cancelled May 21, 1997 · Exported to France · Lagrangeville, NYN2851TPilatus PC-6/B-H2 · S/N 569Cancelled May 1, 1997 · Exported to Canada · Lagrangeville, NYN119SAPilatus PC-6/B2-H2 · S/N 779Cancelled May 23, 1996 · Exported to Germany · Lagrangeville, NYN117SAPilatus PC-6/B2-H2 · S/N 778Cancelled Apr 29, 1996 · Exported to Denmark · Lagrangeville, NYN5325PCessna 152 · S/N 15284916Cancelled Jul 27, 1995 · Triennial form not returned · Lagrangeville, NYN3552DPiper PA-31-325 · S/N 318012025Cancelled Feb 23, 1994 · Exported to Costa Rica · Lagrangeville, NYN9191PPiper PA-34-220T · S/N 3433132Cancelled Sep 14, 1992 · Exported to Switzerland · Lagrangeville, NYN100SECessna 411 · S/N 4110196Cancelled Aug 7, 1992 · Administratively canceled · Pleasant Valley, NYN2237MPiper PA-32R-300 · S/N 32R7880055Cancelled Feb 10, 1992 · Exported to South Africa · Lagrangeville, NYN72JPPiper PA-32-300 · S/N 327640117Cancelled Feb 7, 1992 · Exported to South Africa · Lagrangeville, NYN4299TPiper PA-28-180 · S/N 28-7205135Cancelled Nov 8, 1976 · Exported to Canada · Pleasant Valley, NYN662FLPiper PA-28-140 · S/N 28-7125582Cancelled Feb 4, 1976 · Exported to Canada · Pleasant Valley, NYN35531Cessna 172 · S/N 172-56818Cancelled Jul 11, 1975 · Exported to Canada · Built 1968 · Pleasant Valley, NYN46422Cessna 172K · S/N 17257258Cancelled Jul 7, 1975 · Exported to Canada · Built 1968 · Pleasant Valley, NYN9952XCessna 185 · S/N 1850152Cancelled Apr 7, 1971 · Exported to Canada
Back to Styles Aviation Inc