Skip to content

Earlier aircraft under this name · 28

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

N1218LConsolidated Aeronautics LAKE LA-4 · S/N 721Cancelled Apr 10, 1995 · Exported to Brazil · Xxx, OK N8091JBoeing 707-351C · S/N 19776Cancelled May 18, 1994 · Exported to Brazil · Xxx, OK N2296SCessna 210L · S/N 21061239Cancelled Sep 23, 1993 · Exported to Brazil · Xxx, OK N6367DCessna 172N · S/N 17272753Cancelled May 19, 1993 · Exported to Brazil · Xxx, OK N1859DBeech 58 · S/N TH1301Cancelled Apr 29, 1993 · Exported to Brazil · Xxx, OK N4492DBeech C90 · S/N LJ927Cancelled Mar 10, 1993 · Exported to Brazil · Xxx, OK N114AEMBB BK 117 A-3 · S/N 7094Cancelled Nov 6, 1992 · Exported to Brazil · Oklahoma City, OK N10RNAero Commander 681 · S/N 6021Cancelled Jul 7, 1992 · Exported to Brazil · Na, OK N120JMBeech 65-A90 · S/N LJ125Cancelled Jul 7, 1992 · Exported to Brazil · Na, OK N161XXAero Commander 680V · S/N 170379Cancelled Jul 7, 1992 · Exported to Brazil · Na, OK N1769GCessna 310R · S/N 310R0039Cancelled Jul 7, 1992 · Exported to Brazil · Na, OK N758UECessna R172K · S/N R1723364Cancelled Jun 2, 1992 · Exported to Brazil · Xxx, OK N91CMMitsubishi MU-2B-26A · S/N 388SACancelled Apr 1, 1992 · Exported to Brazil · Xxx, OK N1838VBeech V35B · S/N D10382Cancelled Aug 16, 1991 · Exported to Brazil · Xxx, OK N500AQPiper PA-31T1 · S/N 31T8004039Cancelled Aug 14, 1991 · Exported to Brazil · Xxx, OK N409NDBeech C90 · S/N LJ985Cancelled Aug 12, 1991 · Exported to Brazil · Na, OK N63761Beech 58 · S/N TH1350Cancelled Aug 12, 1991 · Exported to Brazil · Na, OK N18254Beech 95-B55 (T42A) · S/N TC2407Cancelled Aug 5, 1991 · Exported to Brazil · Xxx, OK N805CAPiper PA-31T1 · S/N 31T8104041Cancelled Jul 18, 1991 · Exported to Brazil · Dallas N96677Cessna 182Q · S/N 18266806Cancelled Jun 24, 1991 · Exported to Brazil · Xxx, OK N24FJMitsubishi MU-2B-40 · S/N 453SACancelled Apr 25, 1991 · Exported to Brazil · Xxx, OK N3079QBeech 58 · S/N TH1522Cancelled Apr 10, 1991 · Exported to Brazil · Okla City, OK N6416PBeech F90 · S/N LA187Cancelled Mar 25, 1991 · Exported to Brazil · Xxx, OK N200BMBeech F90 · S/N LA49Cancelled Feb 28, 1991 · Exported to Brazil · Xxx, OK N29FACessna 550 · S/N 5500357Cancelled Jan 16, 1991 · Exported to Brazil · Xxx, OK N14026Aerofab LAKE LA-250 · S/N 29Cancelled Dec 11, 1990 · Exported to Brazil · None, OK N6684NBeech 95-B55 (T42A) · S/N TC2284Cancelled Nov 28, 1990 · Exported to Brazil · Xxx, OK N310WWCessna 310Q · S/N 310Q0478Cancelled Oct 16, 1989 · Exported to Brazil · Xxx, OK

Back to Sold To Brazil