Skip to content

Sold To United Kingdom

Earlier aircraft under this name · 30

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 = 'SOLD TO UNITED KINGDOM' OR list_contains(d.other_registrant_names, 'SOLD TO UNITED KINGDOM') 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 = 'SOLD TO UNITED KINGDOM' OR list_contains(d.other_registrant_names, 'SOLD TO UNITED KINGDOM')
  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 = 'SOLD TO UNITED KINGDOM' OR list_contains(d.other_registrant_names, 'SOLD TO UNITED KINGDOM')
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.

N5MSSanders Roger N RUTAN VARIEZE · S/N RS8673345Cancelled Sep 2, 1993 · Exported to United Kingdom · Oklahoma City, OK N10RXFulper Lester David TRI-Q200 XT · S/N 1Cancelled May 12, 1993 · Exported to United Kingdom · Xxx, OK N512AAHarris Roland W FALCON XP · S/N 600179Cancelled May 10, 1993 · Exported to United Kingdom · None, OK N11SNYakovlev/Anderson YAK-11 · S/N N1701231Cancelled May 5, 1993 · Exported to United Kingdom · None, OK N9SSherrill PITTS SPECIAL S-1 · S/N 362HCancelled Jan 29, 1993 · Exported to United Kingdom · None, OK N68556Bellanca 7ACA · S/N 6272Cancelled Dec 18, 1992 · Exported to United Kingdom · Xxx, OK N50RAWaco YKS-7 · S/N 4693Cancelled May 6, 1992 · Exported to United Kingdom · Warrenton, OR N1964VCessna 172M · S/N 17263806Cancelled Apr 20, 1992 · Exported to United Kingdom · Xxx, OK N25928Cessna 152 · S/N 15280862Cancelled Mar 16, 1992 · Exported to United Kingdom · Xxx, OK N3458EAeronca 11AC · S/N 11AC1759Cancelled Jan 16, 1992 · Exported to United Kingdom · Xxx, OK N29DHHendry PITTS S-1C · S/N 192177Cancelled Dec 11, 1991 · Exported to United Kingdom · Oklahoma City, OK N1498XPiper PA-28R-200 · S/N 28R7535300Cancelled Sep 11, 1991 · Exported to United Kingdom · Xxx, OK N41013Piper J3C-65 · S/N 7647Cancelled Aug 29, 1991 · Exported to United Kingdom · Xxx, OK N9152EAeronca 11AC · S/N 11AC785Cancelled Aug 29, 1991 · Exported to United Kingdom · Xxx, OK N3081TPiper PA-34-200 · S/N 347350002Cancelled Jul 26, 1991 · Exported to United Kingdom · Xxxx, OK N1189XPiper PA-28R-200 · S/N 28R7535270Cancelled Jul 23, 1991 · Exported to United Kingdom · Xxx, OK N8379HPiper PA-28-161 · S/N 288116212Cancelled Jul 19, 1991 · Exported to United Kingdom · Na, OK N31878Piper PA-28-161 · S/N 287816590Cancelled Jun 19, 1991 · Exported to United Kingdom · Xxx, OK N82697Piper PA-28-161 · S/N 288116044Cancelled May 9, 1991 · Exported to United Kingdom · Xxx, OK N22575Cessna 150H · S/N 15068371Cancelled Apr 26, 1991 · Exported to United Kingdom · Xxx, OK N5091JCessna T310R · S/N 310R0211Cancelled Jan 30, 1991 · Exported to United Kingdom · Xxx, OK N23661Piper PA-38-112 · S/N 3881A0146Cancelled Jan 29, 1991 · Exported to United Kingdom · Xxx, OK N2009VCessna 120 · S/N 14220Cancelled Jan 23, 1991 · Exported to United Kingdom · Xxx, OK N9315TPiper PA-38-112 · S/N 3878A0025Cancelled Jan 23, 1991 · Exported to United Kingdom · Xxx, OK N440XSavage Arthur P ACRO SPORT II · S/N 1468Cancelled Dec 26, 1990 · Exported to United Kingdom · Oklahoma City, OK N3403EAeronca 11AC · S/N 11AC1727Cancelled Dec 17, 1990 · Exported to United Kingdom · Oklahoma City, OK N74658Grumman American Avn. AA-5B · S/N AA5B0327Cancelled Dec 13, 1990 · Exported to United Kingdom · Oklahoma City, OK N4373ZPiper PA-28-161 · S/N 288416121Cancelled Dec 10, 1990 · Exported to United Kingdom · Oklahoma City, OK N4374DPiper PA-28-161 · S/N 288416125Cancelled Dec 3, 1990 · Exported to United Kingdom · Oklahoma City, OK N4374FPiper PA-28-161 · S/N 288416126Cancelled Dec 3, 1990 · Exported to United Kingdom · Oklahoma City, OK

Back to Sold To United Kingdom