Strong Tower Services LLC Trustee
Earlier aircraft under this name · 43
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 = 'STRONG TOWER SERVICES LLC TRUSTEE' OR list_contains(d.other_registrant_names, 'STRONG TOWER SERVICES LLC 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 = 'STRONG TOWER SERVICES LLC TRUSTEE' OR list_contains(d.other_registrant_names, 'STRONG TOWER SERVICES LLC 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.
N304TABeech 58PA · S/N TJ-342N6070YPiper PA-23-250 · S/N 27-3268N550MACessna 404 · S/N 4040443N905GPBeech 200 · S/N BB-789N18GCPiper PA-23-250 · S/N 27-4490N16KAPiper PA-31-350 · S/N 31-7952010N647SCPiper PA-31P · S/N 31P-7300129N14178Piper PA-23-250 · S/N 27-4743N8887YPiper PA-23-250 · S/N 27-3984N66778Cessna 150M · S/N 15076271N73BFCessna 404 · S/N 404-0664N717EATomark Aero CZ Sro VIPER SD-4 · S/N 0017N693RCCessna 404 · S/N 404-0692N717ALGulfstream Aerospace G-IV · S/N 1484N4269SBeech 58P · S/N TJ-96N72FSPiper PA-31-310 · S/N 31-7401203N440AZLearjet 45 (LEARJET 40) · S/N 45-2050N6405NCessna T210N · S/N 21062981N981PARaytheon A36 · S/N E-3599N2613BCessna 402C · S/N 402C0083N55500North American T-28B · S/N 53-137716N8574North American T-28B · S/N 138291N2033HMooney International M20TN · S/N 31-0142N59813Piper PA-31-325 · S/N 31-7612039N4305RCessna TR182 · S/N R18200588N663LFCirrus Design SR22T · S/N 0415N555DAPiper PA-23-250 · S/N 27-7554139N73187Cessna 172M · S/N 17267314N417AFPiper PA-28-180 · S/N 28-3985N6144JPiper PA-28R-200 · S/N 28R-7635302N365GPiper PA-28-180 · S/N 28-7105103N4711PCessna P210N · S/N P21000083N702ASMaule M-7-235 · S/N 4106CN9475BCessna 172RG · S/N 172RG0834N4285EPiper PA-38-112 · S/N 38-78A0528N245WSCessna 210L · S/N 21060295N13936Embraer EMB-145EP · S/N 145025N4487FPiper PA-32-300 · S/N 32-7640116N9880JCessna A150M · S/N A1500689N440VCPiper PA-31-310 · S/N 31-486N14937Embraer EMB-145EP · S/N 145026N1776ARaytheon HAWKER 850XP · S/N 258750N433GMIsrael Aircraft Industries 1124A · S/N 433
Back to Strong Tower Services LLC Trustee