Sold To South Africa
Earlier aircraft under this name · 17
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 = 'SOLD TO SOUTH AFRICA' OR list_contains(d.other_registrant_names, 'SOLD TO SOUTH AFRICA') 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 SOUTH AFRICA' OR list_contains(d.other_registrant_names, 'SOLD TO SOUTH AFRICA') 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.
N2350ZRobinson Helicopter R22 BETA · S/N 2224N6444NCessna T210N · S/N 21063020N5928DPiper PA-22-150 · S/N 224591N55477Beech A36 · S/N E2712N911SSHughes 269A · S/N 370683N2082YPiper PA-28RT-201T · S/N 28R7931143N2879APiper PA-28R-201T · S/N 28R7931236N8384ZPiper PA-28RT-201T · S/N 28R8131135N43461Piper PA-28-180 · S/N 287405197N41713Piper PA-28-140 · S/N 287425270N1669XCessna T210L · S/N 21060704N8910JPiper PA-28-180 · S/N 282891N2704GCessna 335 · S/N 3350002N52898Cessna 182P · S/N 18262936N76675Cessna 140 · S/N 11115N56816Beech F33A · S/N CE1521N6434DCessna 172N · S/N 17272798
Back to Sold To South Africa