Catlin Aviation Co
Earlier aircraft under this name · 112
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 = 'CATLIN AVIATION CO' OR list_contains(d.other_registrant_names, 'CATLIN AVIATION CO') 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 = 'CATLIN AVIATION CO' OR list_contains(d.other_registrant_names, 'CATLIN AVIATION CO') 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.
N3621RPiper PA-28-180 · S/N 28-5719N9320PPiper PA-24-260 · S/N 24-4817N717SFPiper PA-24-250 · S/N 24-2351N100DSPiper PA-31 · S/N 31-286N8805YPiper PA-30 · S/N 30-1961N6253DAero Commander 680 · S/N 680-521-191N6281YPiper PA-23-250 · S/N 27-3528N100EMPiper PA-39 · S/N 39-100N7785RBeech D55 · S/N TE-635N2030WBeech 95-B55 (T42A) · S/N TC-966N5550JPiper PA-32-260 · S/N 32-1012N8454NBeech D55 · S/N TE-573N20GEAero Commander 680-F · S/N 680F-971-28N16391Piper PA-28-140 · S/N 28-7325263N1202TPiper PA-34-200 · S/N 34-7250262N6RPiper PA-39 · S/N 39-78N90877Hughes 269B · S/N 0409N91066Cessna 207 · S/N 20700053N6137YPiper PA-23-250 · S/N 27-4373N9395YBeech N35 · S/N D-6602N1691TPiper PA-28-140 · S/N 28-7125008N9367WPiper PA-28-235 · S/N 28-11057N5075SPiper PA-28R-200 · S/N 28R-7135078N5260TPiper PA-28-140 · S/N 28-7225379N682FLPiper PA-28-140 · S/N 28-7125614N5148UCessna 206 · S/N 206-0148N2158TPiper PA-28-180 · S/N 28-7205008N3348XCessna 310L · S/N 310L-0198N660FLPiper PA-28-140 · S/N 28-7125578N9105YPiper PA-31 · S/N 31-142N687FLPiper PA-28-140 · S/N 28-7125622N6142XAero Commander 500-B · S/N 500B-964-10N4607PPiper PA-23 · S/N 27118N418ZBeech E18S · S/N BA-277N4565QCessna 402A · S/N 402A-0065N4633JPiper PA-28R-180 · S/N 28R-30521N8945PPiper PA-24-260 · S/N 27-4401N5791UPiper PA-28-140 · S/N 28-26617N6633LPiper PA-31 · S/N 31-569N3445RPiper PA-28-180 · S/N 28-5683N9328NPiper PA-28R-200 · S/N 28R-35028N6582WPiper PA-28-140 · S/N 28-20663N2506APiper PA-22-135 · S/N 22-822N3907KPiper PA-28-140 · S/N 28-23773N4943LPiper PA-28-180 · S/N 28-4312N4901UCessna 210E · S/N 210-58601N9537JPiper PA-28-180 · S/N 28-3665N9715TCessna 172A · S/N 47515N5179YPiper PA-23-250 · S/N 27-2225N7389TCessna 172A · S/N 46989
Back to Catlin Aviation Co