Schlitter Randy J

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 = 'SCHLITTER RANDY J' OR list_contains(d.other_registrant_names, 'SCHLITTER RANDY J')
  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.

N8073USchlitter Randy J RANS S-16 SHEKARI · S/N 0295002Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Hays, KSN2163XSchlitter Randy RANS S-12 AIRAILE · S/N 1289001Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Hays, KSN8072USchlitter Randy J RANS S-16 SHEKARI · S/N 0295001Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1995 · Hays, KSN2213LSchlitter Randy J RANS S-16 SPR SAKOTA · S/N 0294002Cancelled May 19, 2015 · Registration expired, pending cancellation · Hays, KSN5234USchlitter Randy RANS S 10 SAKOTA · S/N 0190082Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Hays, KSN5234WSchlitter Randy RANS S-12 AIRAILE · S/N 0492203Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Hays, KSN485TCSchlitter Randy RANS S-7 · S/N S785001Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1985 · Hays, KSN2197ESchlitter Randy RANS S-7 COURIER · S/N 1093123Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Hays, KSN6183ZSchlitter Randy J RANS S6ES COYOTE II · S/N 0193420Cancelled May 6, 2013 · Registration expired, pending cancellation · Hays, KSN5287XSchlitter Randy J RANS S-16 SPR SAKOTA · S/N 0294003Cancelled Jul 19, 2011 · Exported to Germany · Built 1994 · Hays, KSN4299YSchlitter Randy RANS S-11 PURSUIT · S/N 0291004Cancelled Mar 15, 2001 · Triennial form not returned · Hays, KSN80459Schlitter Randy RANS S-12 AIRAILE · S/N 1294539Cancelled Apr 23, 1998 · Exported to Colombia · Hays, KSN70301Schlitter Randy RANS S-10 · S/N 0488010Cancelled Sep 3, 1997 · Exported to Germany · Hays, KSN7082CSchlitter Randy RANS S-12 AIRAILE · S/N 1292340Cancelled Oct 26, 1995 · Exported to Germany · Hays, KSN8046USchlitter Randy J RANS S6ES COYOTE II · S/N 1294702Cancelled Oct 26, 1995 · Exported to Germany · Hays, KSN2163KSchlitter Randy RANS S-7 COURIER · S/N 0293108Cancelled Sep 26, 1995 · Exported to France · Hays, KSN86567Ferguson John H VANS RV7A · S/N 09940518Cancelled Aug 10, 1995 · Hays, KSN2164KSchlitter Randy RANS S-11 PURSUIT · S/N 1089002Cancelled Feb 4, 1994 · Triennial form not returned · Hays, KSN7010LSchlitter Randy J RANS S6ES COYOTE II · S/N 1092363Cancelled Dec 8, 1993 · Exported to Germany · Hays, KSN7157KChase John D RANS S7S · S/N 0288044Cancelled Oct 6, 1993 · Exported to Italy · Hays, KSN7048CCascade Aircraft Development CHANUTE · S/N 1088001Cancelled Mar 16, 1992 · Exported to Canada · Hays, KSN7016LSchlitter Randy RANS S 10 SAKOTA · S/N 1287003Cancelled Nov 26, 1991 · Exported to Japan · Hays, KS
Back to Schlitter Randy J