OpenAirDocs.org
Abc Inc

Earlier aircraft under this name · 57

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 = 'ABC INC' OR list_contains(d.other_registrant_names, 'ABC 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.

N102WDDJI PHANTOM 4 · S/N 07DDD490B10868Cancelled Aug 5, 2026 · Secaucus, NJN103WDDJI INSPIRE 1 · S/N W13DDA27061599Cancelled Aug 5, 2026 · Secaucus, NJN106WDDJI INSPIRE 1 · S/N W13DDH09060206Cancelled Aug 5, 2026 · Secaucus, NJN107WDDJI INSPIRE 1 · S/N W13DDH09060657Cancelled Aug 5, 2026 · Secaucus, NJN109WDDJI PHANTOM 4 · S/N 07DDD6J0B11302Cancelled Aug 5, 2026 · Secaucus, NJN110WDDJI INSPIRE 1 · S/N W13DDA27060800Cancelled Aug 5, 2026 · Secaucus, NJN112WDDJI INSPIRE 1 · S/N W13DDK24060819Cancelled Aug 5, 2026 · Secaucus, NJN118WDDJI PHANTOM 4 · S/N 07DDD6M0B11503Cancelled Aug 5, 2026 · Secaucus, NJN119WDDJI INSPIRE 1 · S/N W13DDH09060217Cancelled Aug 5, 2026 · Secaucus, NJN121WDDJI INSPIRE 1 · S/N W13DDH09060177Cancelled Aug 5, 2026 · Secaucus, NJN203WDDJI PHANTOM 4 · S/N 07DDD6N0B10397Cancelled Aug 5, 2026 · Secaucus, NJN209WDDJI PHANTOM 4 · S/N 07DDD640B11202Cancelled Aug 5, 2026 · Secaucus, NJN219WDDJI PHANTOM 4 · S/N 07DDD620B12306Cancelled Aug 5, 2026 · Secaucus, NJN309ABDJI INSPIRE 1 · S/N W130DH09060172Cancelled Aug 5, 2026 · Secaucus, NJN318ABDJI INSPIRE 1 · S/N W130DE21060105Cancelled Aug 5, 2026 · Secaucus, NJN342ABDJI INSPIRE 1 · S/N W130DA27061183Cancelled Aug 5, 2026 · Secaucus, NJN344ABDJI INSPIRE 1 · S/N W13DDH09060180Cancelled Aug 5, 2026 · Secaucus, NJN436WDDJI PHANTOM 4 PRO V2.0 · S/N 11UDH18R700107Cancelled Aug 5, 2026 · Secaucus, NJN451ABDJI PHANTOM 4 · S/N 07DDD670B11531Cancelled Aug 5, 2026 · Secaucus, NJN459ABDJI MAVIC PRO · S/N 08QDE190120064Cancelled Aug 5, 2026 · Secaucus, NJN463ABDJI PHANTOM 4 · S/N 07DDD6M0B11220Cancelled Aug 5, 2026 · Secaucus, NJN464ABDJI MAVIC PRO · S/N 08QDDA6A1R029KCancelled Aug 5, 2026 · Secaucus, NJN474ABDJI MAVIC PRO · S/N 08QUE3D0010393Cancelled Aug 5, 2026 · Seacaucus, NJN580ABDJI INSPIRE 1 · S/N W13DCD16030387Cancelled Aug 5, 2026 · Secaucus, NJN581ABDJI INSPIRE 1 · S/N W13DCD06030168Cancelled Aug 5, 2026 · Secaucus, NJN582ABDJI INSPIRE 1 · S/N W13DCD08030247Cancelled Aug 5, 2026 · Secaucus, NJN583ABDJI INSPIRE 1 · S/N W13DCD08030450Cancelled Aug 5, 2026 · Secaucus, NJN998WDDJI PHANTOM 4 · S/N 07DDD4GOA11205Cancelled Aug 5, 2026 · Secaucus, NJN339ABDJI INSPIRE 1 · S/N W13DDE21060259Cancelled Mar 21, 2023 · Secaucus, NJN207WDDJI PHANTOM 4 · S/N 07DDD5R0B12502Cancelled Mar 14, 2023 · Secaucus, NJN336ABDJI INSPIRE 1 · S/N W130DH09060330Cancelled Mar 14, 2023 · Seacaucus, NJN433WDDJI MAVIC 2 PRO · S/N 163CG9MR0A215WCancelled Oct 28, 2022 · New York, NYN205WDDJI PHANTOM 4 · S/N 07DDD6M0B10403Cancelled Aug 6, 2022 · New York, NYN53WDDJI PHANTOM 4 PRO · S/N 07DDD6J0B11251Cancelled Apr 22, 2020 · New York, NYN116WDDJI INSPIRE 1 · S/N W13DDH09060173Cancelled Apr 9, 2020 · Registration expired, pending cancellation · New York, NYN215WDDJI PHANTOM 4 · S/N 07DDD6M0B11768Cancelled Apr 9, 2020 · First renewal notice · New York, NYN465ABDJI MAVIC PRO · S/N 08QUE3D001040ZCancelled Apr 9, 2020 · New York, NYN471ABDJI PHANTOM 4 · S/N 07DDD5K0B10986Cancelled Apr 9, 2020 · First renewal notice · New York, NYN588ABDJI INSPIRE 1 · S/N W13DCD21031429Cancelled Apr 9, 2020 · New York, NYN801WDDJI PHANTOM 4 · S/N 07DDD790B11923Cancelled Apr 9, 2020 · New York, NYN33WDDJI PHANTOM 4 · S/N 07DDD3H0B10113Cancelled Feb 28, 2020 · Registration expired, pending cancellation · New York, NYN92WDDJI PHANTOM 4 · S/N 07DDD6J0B11498Cancelled Feb 28, 2020 · Registration expired, pending cancellation · New York, NYN284ABDJI MAVIC 2 PRO · S/N 163DFCE001W4SGCancelled Nov 13, 2019 · New York, NYN227WDDJI PHANTOM 2 VISION + · S/N PH645490808Cancelled Oct 23, 2019 · Third renewal notice · New York, NYN328ABDJI INSPIRE 1 · S/N W13DDA27060324Cancelled Oct 23, 2019 · First renewal notice · New York, NYN586ABDJI INSPIRE 1 · S/N W13DCD16030063Cancelled Oct 23, 2019 · Third renewal notice · New York, NYN589ABDJI INSPIRE 1 · S/N W13DCD10030236Cancelled Oct 23, 2019 · Third renewal notice · New York, NYN650WDDJI PHANTOM 3 ADVANCED · S/N P76DCG07010208Cancelled Oct 23, 2019 · Second renewal notice · New York, NYN651WDDJI PHANTOM 3 ADVANCED · S/N P76DCG08011336Cancelled Oct 23, 2019 · Third renewal notice · New York, NYN652WDDJI PHANTOM 2 VISION + · S/N PH645491221Cancelled Oct 23, 2019 · Third renewal notice · New York, NY
Back to Abc Inc