Air Convoy Inc
Earlier aircraft under this name · 64
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 = 'AIR CONVOY INC' OR list_contains(d.other_registrant_names, 'AIR CONVOY 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 = 'AIR CONVOY INC' OR list_contains(d.other_registrant_names, 'AIR CONVOY 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.
N6748LPiper PA-31-310 · S/N 31-603N7683LPiper PA-31-350 · S/N 31-7305011N15781Piper PA-34-200 · S/N 34-7350123N16272Piper PA-34-200 · S/N 34-7350120N15069Piper PA-32-300 · S/N 32-7340008N4586TPiper PA-34-200 · S/N 34-7250109N4462TPiper PA-34-200 · S/N 34-7250101N4582TPiper PA-28-180 · S/N 28-7205188N4385TPiper PA-32-300 · S/N 32-7240074N8693NPiper PA-32-300 · S/N 32-7240040N14130Piper PA-23-250 · S/N 27-4698N1976TPiper PA-28-235 · S/N 28-7110025N14049Piper PA-23-250 (6PCLM) · S/N 27-4661N14022Piper PA-23-250 (6PCLM) · S/N 27-4635N14026Piper PA-23-250 (6PCLM) · S/N 27-4638N6794LPiper PA-31 · S/N 31-707N14030Piper PA-23-250 · S/N 27-4644N14033Piper PA-23-250 (6PCLM) · S/N 27-4645N14034Piper PA-23-250 (6PCLM) · S/N 27-4646N8586NPiper PA-28-235 · S/N 28-7110007N9131QBeech 95-B55 · S/N TC-1377N8618NPiper PA-32-300 · S/N 32-7140010N9298YPiper PA-31 · S/N 31-400N5249SPiper PA-32-300 · S/N 32-40937N5232SPiper PA-32-300 · S/N 32-40893N8570NPiper PA-28-235 · S/N 28-11364N6738LPiper PA-31-310 · S/N 31-643N5236SPiper PA-32-300 · S/N 3240925N6596YPiper PA-23-250 · S/N 27-4392N6614YPiper PA-23-250 · S/N 27-4396N6022YPiper PA-23-250 · S/N 27-4368N6611LPiper PA-31 · S/N 31-541N8977NPiper PA-32-300 · S/N 32-40855N2409RPiper PA-28-180 · S/N 28-5607N8515NPiper PA-28-235 · S/N 28-11304N4295RPiper PA-32-300 · S/N 32-40673N6899YPiper PA-23-250 · S/N 27-4253N4251RPiper PA-32-300 · S/N 32-40619N6860YPiper PA-23-250 · S/N 27-4205N9498WPiper PA-28-235 · S/N 28-11240N4249RPiper PA-32-300 · S/N 32-40616N9356NPiper PA-28R-200 · S/N 28R-35061N4179RPiper PA-32-300 · S/N 32-40506N4200RPiper PA-32-300 · S/N 32-40541N6725YPiper PA-23-250 · S/N 27-4057N6761YPiper PA-23-250 · S/N 27-4090N9462WPiper PA-28-235 · S/N 28-11185N4177RPiper PA-32-300 · S/N 32-40500N4943JPiper PA-28R-180 · S/N 28R-30684N4951JPiper PA-28R-180 · S/N 28R-30697
Back to Air Convoy Inc