Copter Lease LLC Trustee
Earlier aircraft under this name · 35
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 = 'COPTER LEASE LLC TRUSTEE' OR list_contains(d.other_registrant_names, 'COPTER LEASE 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 = 'COPTER LEASE LLC TRUSTEE' OR list_contains(d.other_registrant_names, 'COPTER LEASE 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.
N585TWBell Helicopter Textron 212 · S/N 31105N767ECSikorsky S-76C · S/N 760613N707ECKeystone Helicopter S-76C · S/N 760775N412HSBell Helicopter Textron Canada 412EP · S/N 36144N412THBell Helicopter Textron Canada 412EP · S/N 36162N53CLSikorsky S-76C · S/N 760660N358EHBell 212 · S/N 31211N412HABell Helicopter Textron Canada 412EP · S/N 36399N206FHBell Helicopter Textron 206L-1 · S/N 45322N991BABell 206B · S/N 70N3108EBell 206L-3 · S/N 51498N398EHBell Helicopter Textron 212 · S/N 30766N354DLAmerican Eurocopter AS350B3 · S/N 7343N407KWBell 407 · S/N 53551N412AHBell 412 · S/N 33041N692QSCessna 560XL · S/N 560-5092N350JRaytheon B300 · S/N FL-314N407CLBell Helicopter Textron Canada 407 · S/N 53597N998PTEurocopter EC 130 B4 · S/N 3755N58126Bell 205A-1 · S/N 30136N996PTEurocopter EC 130 B4 · S/N 3855N102TVBell 212 · S/N 30964N994PTEurocopter Deutschland EC 135 P2 · S/N 0197N202ECBell Helicopter Textron 206L-1 · S/N 45447N993PTEurocopter Deutschland MBB-BK 117 C-2 · S/N 9087N997PTEurocopter EC 130 B4 · S/N 3809N5628TBell Helicopter Textron Canada 412EP · S/N 36457N7529HBell Helicopter Textron Canada 412EP · S/N 36459N42489Bell 206L-3 · S/N 51474N552BAEurocopter Deutschland EC 135 P2 · S/N 0190N205XPBell 205A-1 · S/N 30017N20840Aerospatiale AS350BA · S/N 1070N215ELBell 212 · S/N 31115N997GMBell 206B · S/N 2366N922GMBell 212 · S/N 30798
Back to Copter Lease LLC Trustee