C I T Leasing Corp
Earlier aircraft under this name · 32
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 = 'C I T LEASING CORP' OR list_contains(d.other_registrant_names, 'C I T LEASING CORP') 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 = 'C I T LEASING CORP' OR list_contains(d.other_registrant_names, 'C I T LEASING CORP') 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.
N852HWEurocopter AS 350 B2 · S/N 2630N627AABoeing 757-223 · S/N 24585N811SYBoeing 737-8BK · S/N 29660N506NABoeing 757-236 · S/N 24771N244CLBoeing 737-33A · S/N 24461N647ASBoeing 737-790 · S/N 33012N645ASBoeing 737-790 · S/N 33011N629ASBoeing 737-790 · S/N 30626N375PABoeing 737-300 · S/N 23812N222DZBoeing 737-35B · S/N 23971N806BRAirbus A319-132 · S/N 2362N803BRAirbus A319-132 · S/N 2277N387UABoeing 737-322 · S/N 24662N852CTBoeing 737-300 · S/N 26852N87JEBeech B100 · S/N BE-27N754DBLearjet 25 · S/N 014N334CTBoeing 737-8BK · S/N 33014N928CTBoeing 737-5L9 · S/N 24928N265CTBoeing 737-500 · S/N 26538N859CTBoeing 737-5L9 · S/N 24859N262CTBoeing 757-200 SERIES · S/N 26246N108TYDehavilland DHC-8-300 SERIES · S/N 108N116TYBoeing/Canada DHC-8-301 · S/N 116N194TYDehavilland DHC-8-300 SERIES · S/N 194N480CTMcdonnell Douglas DC-9-82(MD-82) · S/N 48069N664GAGulfstream Aerospace G-V · S/N 664N288UEEmbraer EMB-120RT · S/N 120184N237CTBoeing 737-300 · S/N 23750N105AMMcdonnell Douglas DC-10-30F · S/N 46891N607FFBoeing 747-238B · S/N 20011N5033Boeing 737-300 · S/N 25033N287UEEmbraer EMB-120RT · S/N 120.183
Back to C I T Leasing Corp