Skip to content

Catlin Aviation Co

Earlier aircraft under this name · 112

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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

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.

N75003Piper PA-31-350 · S/N 31-7405162Cancelled Mar 15, 1984 · Exported to Canada · Oklahoma City, OK N6948UMooney M20E · S/N 318Cancelled Nov 4, 1981 · Exported to Canada · Oklahoma City, OK N707FRPiper PA-31 · S/N 31-262Cancelled Jul 27, 1981 · Exported to Canada · Okla City, OK N8350QPiper PA-34-220T · S/N 348133033Cancelled May 19, 1981 · Exported to Canada · Oklahoma City, OK N6528XCessna 210 · S/N 57528Cancelled May 6, 1981 · Exported to Canada · Oklahoma City, OK N67NDPiper PA-31 · S/N 31-7612108Cancelled Apr 23, 1981 · Exported to Canada · Okc, OK N808ERPiper PA-23-250 · S/N 272985Cancelled Mar 10, 1981 · Exported to Canada · Oklahoma City, OK N1024PPiper PA-31-310 · S/N 31-158Cancelled Dec 2, 1980 · Exported to Canada · Built 1968 · Oklahoma City, OK N8643MBeech D95A · S/N TD-550Cancelled Sep 17, 1980 · Exported to Canada · Oklahoma City, OK N5027PPiper PA-24-180 · S/N 2430Cancelled Jul 31, 1980 · Exported to Canada · Oklahoma City, OK N7960GCessna 172L · S/N 17259660Cancelled May 28, 1980 · Exported to Canada · Oklahoma City, OK N55280Piper PA-28-235 · S/N 287310118Cancelled Apr 11, 1980 · Exported to Canada · Oklahoma City, OK N41373Piper PA-28R-200 · S/N 28R-7435175Cancelled Jan 9, 1980 · Exported to Canada · Built 1974 · Oklahoma City, OK N64544Cessna 172M · S/N 17265298Cancelled Sep 26, 1979 · Exported to Canada · Oklahoma City, OK N8884PPiper PA-24-260 · S/N 24-4343Cancelled Feb 14, 1979 · Exported to Canada · Oklahoma City, OK N9457CPiper PA-28-161 · S/N 28-7816478Cancelled Nov 13, 1978 · Exported to Canada · Oklahoma City, OK N1078VCessna R172K · S/N R1722108Cancelled Sep 27, 1978 · Exported to Canada · Built 1976 · Oklahomacity, OK N9021NAero Commander 500 S · S/N 3057Cancelled Sep 19, 1978 · Exported to Australia · Oklahoma City, OK N9034NAero Commander 500 S · S/N 3060Cancelled Aug 30, 1978 · Exported to Australia · Okc, OK N75240Piper PA-28R-200 · S/N 28R7635286Cancelled Jun 30, 1978 · Exported to Canada · Built 1976 · Okla City, OK N8534FPiper PA-28-181 · S/N 28-7790256Cancelled Apr 24, 1978 · Exported to Australia · Okc, OK N662WRPiper PA-31-350 · S/N 317405166Cancelled Apr 20, 1978 · Exported to Australia · Oklahoma City, OK N7695LPiper PA-34-200T · S/N 34-7670062Cancelled Apr 19, 1978 · Exported to Canada · Okla City, OK N1772RCessna A185F · S/N 18502491Cancelled Apr 14, 1978 · Exported to Canada · Built 1974 · Okc, OK N506VPiper PA-31 · S/N 31-681Cancelled Feb 28, 1978 · Exported to United Kingdom · Oklahoma City, OK N9508QBeech 65-B80 · S/N LD-282Cancelled Feb 13, 1978 · Exported to Venezuela · Built 1966 · Oklahoma City, OK N86568Piper PA-31-350 · S/N 317305025Cancelled Jan 3, 1978 · Exported to Australia · Okla City, OK N5635PPiper PA-24 · S/N 24-705Cancelled Dec 12, 1977 · Exported to Canada · Okc, OK N88224Bellanca 8GCBC · S/N 96-74Cancelled Aug 19, 1977 · Exported to Canada · Built 1974 · Oklahoma City, OK N7887LPiper PA-34-200 · S/N 34-7250112Cancelled Aug 8, 1977 · Exported to Canada · Okc, OK N59838Piper PA-31-310 · S/N 31-7612047Cancelled Jun 24, 1977 · Built 1976 · Oklahoma City, OK N4345TPiper PA-28R-200 · S/N 28R7235013Cancelled Jun 21, 1977 · Exported to Canada · Built 1971 · Oklahoma City, OK N7985FPiper PA-28-181 · S/N 28-7790231Cancelled Feb 17, 1977 · Exported to Australia · Okc, OK N61412Piper PA-31-350 · S/N 31-7405451Cancelled Feb 7, 1977 · Exported to Canada · Oklahoma City, OK N75028Piper PA-28-181 · S/N 28-7690281Cancelled Nov 8, 1976 · Exported to Australia · Oklahoma City, OK N8287CPiper PA-28-181 · S/N 28-7690111Cancelled Sep 14, 1976 · Exported to Australia · Oklahoma City, OK N66890Piper PA-31-350 · S/N 317405189Cancelled Aug 24, 1976 · Exported to Australia · Oklahoma City, OK N4577JPiper PA-28R-180 · S/N 28R-30445Cancelled Apr 27, 1976 · Exported to Canada · Built 1968 · Oklahoma City, OK N32995Piper PA-32-300 · S/N 32-7540078Cancelled Dec 12, 1975 · Exported to Canada · Okla City, OK N15155Piper PA-28-140 · S/N 28-7325025Cancelled Aug 12, 1975 · Exported to Canada · Oklahoma City, OK N1225TPiper PA-28-140 · S/N 28-7225429Cancelled Aug 5, 1975 · Exported to Canada · Built 1972 · Oklahoma City, OK N70638Cessna 182M · S/N 18259336Cancelled May 20, 1975 · Exported to Bolivia · Oklahoma City, OK N4985SPiper PA-28R-200 · S/N 28R-35705Cancelled Oct 15, 1974 · Exported to United Kingdom · Built 1970 · Oklahoma City, OK N92266Cessna 182N · S/N 18260120Cancelled Oct 15, 1974 · Exported to Bolivia · Oklahoma City, OK N4632PPiper PA-23-250 · S/N 27-151Cancelled Aug 5, 1974 · Exported to Canada · Built 1960 · Oklahoma City, OK N5461SPiper PA-28-140 · S/N 287125124Cancelled Aug 2, 1974 · Oklahoma City, OK N120BBPiper PA-23-250 · S/N 27-2048Cancelled Jul 18, 1974 · Exported to Canada · Oklahoma City, OK N7007QCessna 172L · S/N 17260307Cancelled Jun 25, 1974 · Exported to Canada · Oklahoma City, OK N66876Piper PA-31-350 · S/N 317405406Cancelled Jun 18, 1974 · Exported to Niger · Oklahoma, OK N62525Piper PA-23-250 · S/N 27-407Cancelled May 20, 1974 · Exported to Canada · Oklahoma City, OK

Back to Catlin Aviation Co