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.

N3621RPiper PA-28-180 · S/N 28-5719Cancelled May 17, 1974 · Exported to Australia · Oklahoma City, OKN9320PPiper PA-24-260 · S/N 24-4817Cancelled May 17, 1974 · Exported to Australia · Built 1969 · Oklahoma City, OKN717SFPiper PA-24-250 · S/N 24-2351Cancelled May 10, 1974 · Exported to Canada · Oklahoma City, OKN100DSPiper PA-31 · S/N 31-286Cancelled Apr 24, 1974 · Exported to Australia · Built 1968 · Oklahoma City, OKN8805YPiper PA-30 · S/N 30-1961Cancelled Apr 18, 1974 · Exported to Australia · Oklahoma City, OKN6253DAero Commander 680 · S/N 680-521-191Cancelled Mar 14, 1974 · Exported to Bolivia · Oklahoma City, OKN6281YPiper PA-23-250 · S/N 27-3528Cancelled Mar 5, 1974 · Exported to New Zealand · Oklahoma City, OKN100EMPiper PA-39 · S/N 39-100Cancelled Jan 10, 1974 · Exported to Australia · Oklahoma City, OKN7785RBeech D55 · S/N TE-635Cancelled Dec 18, 1973 · Exported to Australia · Okla City, OKN2030WBeech 95-B55 (T42A) · S/N TC-966Cancelled Nov 23, 1973 · Exported to New Zealand · Oklahoma City, OKN5550JPiper PA-32-260 · S/N 32-1012Cancelled Nov 23, 1973 · Exported to New Zealand · Okla City, OKN8454NBeech D55 · S/N TE-573Cancelled Nov 23, 1973 · Exported to Australia · Built 1968 · Okc, OKN20GEAero Commander 680-F · S/N 680F-971-28Cancelled Nov 5, 1973 · Exported to Canada · Built 1960 · Oklahoma City, OKN16391Piper PA-28-140 · S/N 28-7325263Cancelled Nov 1, 1973 · Exported to Canada · Oklahoma City, OKN1202TPiper PA-34-200 · S/N 34-7250262Cancelled Oct 17, 1973 · Exported to United Kingdom · Okla City, OKN6RPiper PA-39 · S/N 39-78Cancelled Oct 12, 1973 · Exported to New Zealand · Oklahoma City, OKN90877Hughes 269B · S/N 0409Cancelled Oct 4, 1973 · Exported to New Zealand · Oklahoma City, OKN91066Cessna 207 · S/N 20700053Cancelled Sep 26, 1973 · Exported to New Zealand · Built 1969 · Oklahoma City, OKN6137YPiper PA-23-250 · S/N 27-4373Cancelled Aug 15, 1973 · Exported to United Kingdom · Oklahoma City, OKN9395YBeech N35 · S/N D-6602Cancelled Jul 24, 1973 · Exported to Australia · Okc, OKN1691TPiper PA-28-140 · S/N 28-7125008Cancelled Jul 16, 1973 · Exported to Australia · Okc, OKN9367WPiper PA-28-235 · S/N 28-11057Cancelled Jul 16, 1973 · Exported to Canada · Okc, OKN5075SPiper PA-28R-200 · S/N 28R-7135078Cancelled Jun 27, 1973 · Exported to Australia · Oklahoma City, OKN5260TPiper PA-28-140 · S/N 28-7225379Cancelled Jun 25, 1973 · Exported to Australia · Built 1972 · Okc, OKN682FLPiper PA-28-140 · S/N 28-7125614Cancelled Jun 21, 1973 · Exported to Canada · Okla City, OKN5148UCessna 206 · S/N 206-0148Cancelled Jun 8, 1973 · Exported to New Zealand · Oklahoma City, OKN2158TPiper PA-28-180 · S/N 28-7205008Cancelled Jun 4, 1973 · Exported to Austria · Oklahoma City, OKN3348XCessna 310L · S/N 310L-0198Cancelled Apr 12, 1973 · Exported to New Zealand · Oklahoma City, OKN660FLPiper PA-28-140 · S/N 28-7125578Cancelled Dec 15, 1972 · Exported to Canada · Okc, OKN9105YPiper PA-31 · S/N 31-142Cancelled Nov 14, 1972 · Exported to Australia · Oklahoma City, OKN687FLPiper PA-28-140 · S/N 28-7125622Cancelled Oct 4, 1972 · Exported to Canada · Oklahoma City, OKN6142XAero Commander 500-B · S/N 500B-964-10Cancelled Sep 21, 1972 · Exported to South Africa · Okla City, OKN4607PPiper PA-23 · S/N 27118Cancelled Aug 9, 1972 · Exported to Canada · Built 1960 · Oklahoma City, OKN418ZBeech E18S · S/N BA-277Cancelled Aug 8, 1972 · Exported to Canada · Oklahoma City, OKN4565QCessna 402A · S/N 402A-0065Cancelled Jun 21, 1972 · Exported to New Zealand · Built 1969 · Oklahomacity, OKN4633JPiper PA-28R-180 · S/N 28R-30521Cancelled Jan 18, 1972 · Exported to Canada · Oklahoma City, OKN8945PPiper PA-24-260 · S/N 27-4401Cancelled Jan 3, 1972 · Exported to Australia · Oklahoma City, OKN5791UPiper PA-28-140 · S/N 28-26617Cancelled Nov 24, 1971 · Exported to Canada · Oklahoma City, OKN6633LPiper PA-31 · S/N 31-569Cancelled Jul 2, 1971 · Exported to United Kingdom · Built 1970 · Oklahoma City, OKN3445RPiper PA-28-180 · S/N 28-5683Cancelled Jul 7, 1970 · Exported to Canada · Okla City, OKN9328NPiper PA-28R-200 · S/N 28R-35028Cancelled Nov 3, 1969 · Exported to Canada · Built 1969 · Oklahoma City, OKN6582WPiper PA-28-140 · S/N 28-20663Cancelled Sep 13, 1968 · Exported to Canada · Built 1965 · Oklahoma City, OKN2506APiper PA-22-135 · S/N 22-822Cancelled Aug 19, 1968 · Exported to Canada · Oklahoma City, OKN3907KPiper PA-28-140 · S/N 28-23773Cancelled Jun 19, 1968 · Exported to Canada · Oklahoma City, OKN4943LPiper PA-28-180 · S/N 28-4312Cancelled Jun 10, 1968 · Exported to Canada · Oklahoma City, OKN4901UCessna 210E · S/N 210-58601Cancelled May 31, 1968 · Exported to Canada · Oklahoma City, OKN9537JPiper PA-28-180 · S/N 28-3665Cancelled Apr 26, 1968 · Exported to Canada · Built 1966 · Oklahoma City, OKN9715TCessna 172A · S/N 47515Cancelled Apr 26, 1968 · Exported to Canada · Built 1960 · Oklahomacity, OKN5179YPiper PA-23-250 · S/N 27-2225Cancelled Apr 25, 1968 · Exported to South Africa · Oklahoma City, OKN7389TCessna 172A · S/N 46989Cancelled Mar 18, 1968 · Exported to Canada · Oklahoma City, OK
Back to Catlin Aviation Co