Africair Inc
Earlier aircraft under this name · 323
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 = 'AFRICAIR INC' OR list_contains(d.other_registrant_names, 'AFRICAIR INC') 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 = 'AFRICAIR INC' OR list_contains(d.other_registrant_names, 'AFRICAIR INC') 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.
N1307VCessna 208B · S/N 208B1155N208FKCessna 208B · S/N 208B-0714N1275ZCessna 208B · S/N 208B1109N750LKCessna 208B · S/N 208B0750N4630UCessna U206G · S/N U20605012N910HECessna 208B · S/N 208B0706N21458Cessna T206H · S/N T20608441N1266PCessna 208B · S/N 208B1031N12554Cessna 208B · S/N 208B1030N1247VCessna 208B · S/N 208B1026N282FVCessna 208B · S/N 208B-0571N9MUCessna 208B · S/N 208B0582N12383Cessna 208B · S/N 208B0999N1129YCessna 208B · S/N 208B0965N40435Cessna 550 · S/N 550-1008N1130TCessna 208B · S/N 208B0950N1132WCessna 208B · S/N 208B0923N12396Cessna 208B · S/N 208B0920N373MECessna 206H · S/N 20608131N227VCessna U206G · S/N U20606202N35479Cessna 206H · S/N 20608168N3YTCessna U206G · S/N U20605338N3531KCessna 206H · S/N 20608156N1239BCessna 208B · S/N 208B0891N2VZPiper PA-31T3 · S/N 31T8275011N1294KCessna 208B · S/N 208B0872N259MECessna 206H · S/N 20608114N21079Cessna 182P · S/N 18261399N1253MCessna 208B · S/N 208B0784N954SPCessna 172S · S/N 172S8154N1298XCessna 560 · S/N 560-0502N1126TCessna 208B · S/N 208B0683N1286NCessna 208B · S/N 208B0674N4158RCessna 182S · S/N 18280173N1256GCessna 208B · S/N 208B0665N9617FCessna 208 · S/N 20800107N6236GCessna 208B · S/N 208B0367N1123FCessna 208B · S/N 208B0626N12386Cessna 208B · S/N 208B0634N92173Bell 206-L4 · S/N 52160N798ACessna 404 · S/N 4040207N1215KCessna 208B · S/N 208B0568N397TACessna 208B · S/N 208B0397N50938Cessna 208B · S/N 208B0558N1328KCessna 208B · S/N 208B0487N9147NCessna 208B · S/N 208B0472N1287NCessna 208B · S/N 208B0473N57ACessna T303 · S/N T30300218N12922Cessna 208B · S/N 208B0446N733DFCessna U206G · S/N U20604758
Back to Africair Inc