Southern Aircraft Sales
Earlier aircraft under this name · 60
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 = 'SOUTHERN AIRCRAFT SALES' OR list_contains(d.other_registrant_names, 'SOUTHERN AIRCRAFT SALES') 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 = 'SOUTHERN AIRCRAFT SALES' OR list_contains(d.other_registrant_names, 'SOUTHERN AIRCRAFT SALES') 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.
N16FCBeech C23 · S/N M-2069N22514Cessna 150H · S/N 15068328N3726QBeech 77 · S/N WA-165N38031Beech 77 · S/N WA-209N38482Beech 77 · S/N WA-245N38671Beech 77 · S/N WA-255N48756Cessna 152 · S/N 15280955N5119RBeech B19 · S/N MB-654N6457LCessna 152 · S/N 15284399N64822Cessna 152 · S/N 15281437N65412Cessna 152 · S/N 15281535N67645Cessna 152 · S/N 15285304N7140GCessna 172K · S/N 17258840N9592HCessna 172M · S/N 17266251N4802RCessna 172RG · S/N 172RG0035N1746QCessna 150L · S/N 15073046N6345MCessna 152 · S/N 15284685N4900GCessna 172N · S/N 17273447N94098Cessna 152 · S/N 15285596N916JHCessna 152 · S/N 15280114N79112Cessna 172K · S/N 17257888N5271DCessna 172S · S/N 172S9188N714XZCessna 152 · S/N 15279526N102XLCessna 152 · S/N 15285068N8447MCessna A150K · S/N A15000147N5334PCessna 152 · S/N 15284918N5121BCessna 152 · S/N 15283758N23436Piper PA-38-112 · S/N 38-81A0141N68739Cessna 152 · S/N 15285335N2547NPiper PA-38-112 · S/N 38-79A0909N96625Cessna 152 · S/N 15286015N94239Cessna 152 · S/N 15285629N94555Cessna 152 · S/N 15285720N24495Cessna 152 · S/N 15280287N47281Cessna 152 · S/N 15283208N25290Cessna 152 · S/N 15280574N95501Cessna 152 · S/N 15285908N95895Cessna 152 · S/N 15285981N4761PCessna 152 · S/N 15284811N96846Cessna 152 · S/N 15286025N94703Cessna 152 · S/N 15285768N89926Cessna 152 · S/N 15282917N6513LCessna 152 · S/N 15284426N43MZCessna 152 · S/N 15282659N4766PCessna 152 · S/N 15284812N67327Cessna 152 · S/N 15281757N4735BCessna 152 · S/N 15283607N25834Cessna 152 · S/N 15280807N65493Cessna 152 · S/N 15281586N68487Cessna 152 · S/N 15282314
Back to Southern Aircraft Sales