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.
N578ALCessna 208B · S/N 208B2378N342CCCessna 680 · S/N 680-0342N81450Cessna 208B · S/N 208B5031N8135FCessna 208B · S/N 208B5020N8134LCessna 208B · S/N 208B5015N20288Cessna 208B · S/N 208B2384N8145KCessna 208B · S/N 208B2434N30609Thrush S2R-T34 · S/N T34-404N2025XCessna 208B · S/N 208B2348N465XBBell Helicopter Textron Canada 429 · S/N 57083N466ABBell Helicopter Textron Canada 429 · S/N 57084N20168Cessna 208B · S/N 208B2356N208LFCessna 208B · S/N 208B0725N3060SThrush S2R-T34 · S/N T34-385N20194Cessna 208B · S/N 208B2372N9204QCessna 172R · S/N 17281611N9205QCessna 172R · S/N 17281612N2004DCessna 525C · S/N 525C0092N208AECessna 208B · S/N 208B2164N21635Cessna 172S · S/N 172S10425N92037Cessna 172R · S/N 17281603N9204DCessna 172R · S/N 17281604N9084YCessna 172R · S/N 17281585N9084ZCessna 172R · S/N 17281587N439FBBell Helicopter Textron Canada 407 · S/N 54074N1141HCessna 208B · S/N 208B1234N70159Thrush S2R-T34 · S/N T34-364N60207Cessna 208B · S/N 208B2318N3034DCessna 208B · S/N 208B2282N425HSBell 407 · S/N 54006N3041ECessna 208B · S/N 208B2278N7018JThrush S2R-T34 · S/N T34-344N776MGCessna T206H · S/N T20608337N6242RCessna 680 · S/N 680-0273N30423Cessna 560XL · S/N 560-6067N60313Cessna 208B · S/N 208B2251N9026WCessna 206H · S/N 20608321N427PRBell 427 · S/N 56012N5242APiper PA-34-220T · S/N 3449207N91277Cessna 172S · S/N 172S11029N91275Cessna 172S · S/N 172S11027N91276Cessna 172S · S/N 172S11028N91278Cessna 172S · S/N 172S11030N91279Cessna 172S · S/N 172S11031N9132NCessna 172S · S/N 172S11032N1008PCessna 208B · S/N 208B2189N1029JCessna 208B · S/N 208B2188N602RLCessna 208B · S/N 208B0962N6104MCessna 208B · S/N 208B2107N6178NCessna 208B · S/N 208B2156
Back to Africair Inc