Skip to content

Solomon Mark Trustee

Earlier aircraft under this name · 28

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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 = 'SOLOMON MARK TRUSTEE' OR list_contains(d.other_registrant_names, 'SOLOMON MARK TRUSTEE') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'SOLOMON MARK TRUSTEE' OR list_contains(d.other_registrant_names, 'SOLOMON MARK TRUSTEE')
  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.

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 = 'SOLOMON MARK TRUSTEE' OR list_contains(d.other_registrant_names, 'SOLOMON MARK TRUSTEE')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N54FNGates Lear Jet 25C · S/N 25-083Cancelled Mar 23, 2023 · Registration ineffective or invalid · Built 1972 · Wilmington, DE N35WRGates Learjet 35A · S/N 234Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1979 · Wilmington, DE N26TZIsrael Aircraft Industries 1124 · S/N 293Cancelled Jan 8, 2020 · Built 1980 · Wilmington, DE N522NMShort Bros SHORTS SD3-60 · S/N SH3602Cancelled Feb 11, 2019 · First renewal notice · Wilmington, DE N110AJRockwell International NA-265-80 · S/N 380-70Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Fort Lauderdale, FL N25MTGates Lear Jet 25C · S/N 129Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1973 · Wilmington, DE N748TSHawker Siddeley DH.125-400A · S/N NA748Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1970 · Fort Lauderdale, FL N155DBGates Learjet 55C · S/N 141Cancelled Jan 23, 2018 · Exported to Venezuela · Built 1990 · Wilmington, DE N27RXCessna 421C · S/N 421C0404Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1977 · Wilmington, DE N15LNCessna 650 · S/N 650-7013Cancelled Nov 27, 2017 · Exported to Venezuela · Built 1992 · Wilmington, DE N68QBGates Learjet 35A · S/N 079Cancelled Sep 26, 2016 · Exported to Venezuela · Built 1976 · Wilmington, DE N97BDBeechcraft B200 · S/N BB-1277Cancelled Jun 24, 2016 · Exported to Venezuela · Built 1988 · Wilmington, DE N252LJGates Lear Jet 25C · S/N 097Cancelled Oct 7, 2015 · Exported to Venezuela · Built 1972 · Wilmington, DE N5QGGates Learjet 55 · S/N 055Cancelled Aug 11, 2015 · Exported to Venezuela · Built 1982 · Wilmington, DE N92TSGates Lear Jet 35 · S/N 035Cancelled May 26, 2015 · Exported to Venezuela · Built 1975 · Fort Lauderdale, FL N100RYEmbraer Executive EMB-500 · S/N 50000295Cancelled Jul 10, 2014 · Exported to Germany · Built 2013 · Wilmington, DE N9200MLearjet 60 · S/N 132Cancelled Jul 8, 2014 · Exported to Mexico · Built 1998 · Wilmington, DE N43MHIsrael Aircraft Industries 1125 WESTWIND ASTRA · S/N 043Cancelled Mar 12, 2013 · Built 1990 · Fort Lauderdale, FL N38083Beech A36 · S/N E-1799Cancelled Apr 4, 2011 · Exported to Australia · Built 1980 · Fort Lauderdale, FL N423TSAgusta AW139 · S/N 41023Cancelled Jul 22, 2010 · Exported to Mexico · Built 2008 · Fort Lauderdale, FL N22033Piper PA-34-200T · S/N 34-7870453Cancelled Apr 9, 2010 · Exported to Colombia · Built 1978 · Fort Lauderdale, FL N55GRCessna 500 · S/N 5000217Cancelled Dec 3, 2009 · Exported to Venezuela · Ft Lauderdale, FL N421AMPiper PA-34-200T · S/N 34-7970226Cancelled Nov 23, 2009 · Exported to Venezuela · Built 1979 · Wilmington, DE N7136KBritten-Norman BN2A-26 ISLANDER · S/N 900Cancelled Nov 3, 2009 · Exported to Venezuela · Built 1980 · Wilmington, DE N14FNGates Lear Jet 25C · S/N 126Cancelled Jul 6, 2009 · Exported to Venezuela · Built 1973 · Wilmington, DE N1814LBeech 58P · S/N TJ-61Cancelled Mar 4, 2009 · Exported to Venezuela · Built 1976 · Wilmington, DE N125DBeech B100 · S/N BE-114Cancelled Jan 16, 2009 · Exported to Venezuela · Built 1981 · Wilmington, DE N8449PPiper PA-34-220T · S/N 34-8133271Cancelled Aug 29, 2008 · Exported to Colombia · Built 1981 · Fort Lauderdale, FL

Back to Solomon Mark Trustee