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.
N6185NCessna 208B · S/N 208B2150N2255RCessna 208B · S/N 208B2098N362MHBell Helicopter Textron Canada 412EP · S/N 36495N2051ACessna 525A · S/N 525A0436N1152UCessna LC41-550FG · S/N 411069N368AWBell Helicopter Textron Canada 407 · S/N 53896N208GHCessna 208B · S/N 208B2001N2246GCessna 208B · S/N 208B2103N2208YCessna 208B · S/N 208B2055N2212XCessna 208B · S/N 208B2072N2268VCessna 208B · S/N 208B2063N2067VCessna 560XL · S/N 560-5808N2664BBell 206-L4 · S/N 52367N872CPCessna 172R · S/N 17280713N21716Cessna 208B · S/N 208B1315N20527Cessna 208B · S/N 208B1307N5167UBell 412EP · S/N 36447N51682Bell 412EP · S/N 36453N5168XBell 412EP · S/N 36441N23681Cessna 172R · S/N 17280979N20718Cessna 208 · S/N 20800417N2123SCessna 208B · S/N 208B1311N340TEBritish Aerospace BAE JETSTREAM 3201 · S/N 939N338TEBritish Aerospace BAE JETSTREAM 3201 · S/N 932N2572YBell Helicopter Textron Canada 206B · S/N 4638N1180TCessna 172S · S/N 172S10462N41132Cessna 208B · S/N 208B1280N1189TCessna 182T · S/N 18281915N2273KCessna 206H · S/N 20608293N801AACessna 208B · S/N 208B0857N10966Cessna 208B · S/N 208B1260N1239YCessna 208B · S/N 208B1262N35062Cessna 172R · S/N 17281063N3516UCessna 172R · S/N 17281045N1203SCessna 208B · S/N 208B1255N1106KCessna 208B · S/N 208B1247N1167LCessna 208B · S/N 208B1249N12686Cessna 208B · S/N 208B1248N1226XCessna 208B · S/N 208B1243N21463Cessna 172R · S/N 17280678N1084YCessna 208B · S/N 208B1230N102TJCessna 172R · S/N 17280956N1320VCessna 208B · S/N 208B1222N408MNCessna 208B · S/N 208B0830N1318PCessna 208B · S/N 208B1203N13162Cessna 208B · S/N 208B1192N1257MCessna 208B · S/N 208B1029N1258UCessna 208B · S/N 208B0688N9EUCessna 208B · S/N 208B0570N1308NCessna 208B · S/N 208B1170
Back to Africair Inc