Atlantic Aero Inc
Earlier aircraft under this name · 19
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 = 'ATLANTIC AERO INC' OR list_contains(d.other_registrant_names, 'ATLANTIC AERO 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 = 'ATLANTIC AERO INC' OR list_contains(d.other_registrant_names, 'ATLANTIC AERO 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.
N33AAAtlantic Aero CGS HAWK · S/N AH-0001N9653FCessna 208 · S/N 20800114N555SACessna 208B · S/N 208B0578N76UCessna 208B · S/N 208B0775N1958ECessna 208B · S/N 208B0834N599BACessna 208B · S/N 208B0773N209AACessna 208B · S/N 208B0879N32AAAtlantic Aero ATLANTIC AERO AW2 · S/N AW2-001N1229ACessna 208B · S/N 208B0663N4875UCessna 210N · S/N 21064828N9330BCessna 208B · S/N 208B0053N8229EPiper PA-28-181 · S/N 28-8090010N81410Piper PA-28-181 · S/N 28-8090210N2916NPiper PA-44-180 · S/N 44-7995306N2187PPiper PA-28RT-201 · S/N 28R-7918049N5399VCessna 210L · S/N 21060934N9902LGrumman American Avn. AA-1B · S/N AA1B-0202N93047Cessna 210L · S/N 21060240N13509Cessna 172M · S/N 17262806
Back to Atlantic Aero Inc