Skip to content

Aero Controls Inc

Earlier aircraft under this name · 32

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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 = 'AERO CONTROLS INC' OR list_contains(d.other_registrant_names, 'AERO CONTROLS INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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

N7055UBoeing 727-22 · S/N 18862Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 1966 · Auburn, WA N218USBoeing 737-201 · S/N 20216Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1969 · Auburn, WA N1992Boeing 727-23 · S/N 18448Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1965 · Auburn, WA N14247Boeing 737-247 · S/N 20133Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1969 · Auburn, WA N10238Boeing 737-214 · S/N 19682Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1968 · Auburn, WA N7011UBoeing 727-22 · S/N 18303Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1964 · Auburn, WA N902WAMcdonnell Douglas DC-10-10 · S/N 46928Cancelled Apr 23, 2014 · Third renewal notice · Auburn, WA N7829ABoeing 727-116 · S/N 20217Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1969 · Auburn, WA N314ASBoeing 727-21 · S/N 18992Cancelled Sep 27, 2012 · Registration expired, pending cancellation · Built 1965 · Auburn, WA N289USBoeing 727-251 · S/N 21377Cancelled May 27, 2004 · Built 1977 · Auburn, WA N297USBoeing 727-251 · S/N 21789Cancelled May 27, 2004 · Built 1979 · Auburn, WA N459JSBoeing 747-200 · S/N 20459Cancelled Apr 1, 2002 · Auburn, WA N960JSBoeing 747-200 · S/N 19960Cancelled Apr 1, 2002 · Auburn, WA N727SHBoeing 727-284 · S/N 20005Cancelled Jan 17, 2002 · Triennial form not returned · Auburn, WA N727SRBoeing 727-284 · S/N 20006Cancelled Jan 17, 2002 · Triennial form not returned · Auburn, WA N94314Boeing 727-231 · S/N 20047Cancelled Jul 13, 1999 · Auburn, WA N7632UBoeing 727-222 · S/N 19905Cancelled Sep 11, 1997 · Triennial form not returned · Auburn, WA N202AUBoeing 737-201 · S/N 19419Cancelled Apr 30, 1997 · Triennial form not returned · Augurn, WA N40484Boeing 727-22 · S/N 18791Cancelled Oct 10, 1996 · Triennial form not returned · Auburn, WA N18480Boeing 727-76 · S/N 18741Cancelled Oct 8, 1996 · Triennial form not returned · Auburn, WA N487GXBoeing 747-230B · S/N 20493Cancelled Sep 10, 1996 · Auburn, WA N7006UBoeing 727-22 · S/N 18298Cancelled May 21, 1996 · Triennial form not returned · Auburn, WA N7010UBoeing 727-22 · S/N 18302Cancelled May 21, 1996 · Triennial form not returned · Auburn, WA N7013UBoeing 727-22 · S/N 18305Cancelled Apr 18, 1996 · Triennial form not returned · Auburn, WA N7014UBoeing 727-22 · S/N 18306Cancelled Apr 18, 1996 · Triennial form not returned · Auburn, WA N7018UBoeing 727-22 · S/N 18310Cancelled Apr 18, 1996 · Triennial form not returned · Auburn, WA N7019UBoeing 727-22 · S/N 18311Cancelled Apr 18, 1996 · Triennial form not returned · Auburn, WA N7021UBoeing 727-22 · S/N 18313Cancelled Apr 18, 1996 · Triennial form not returned · Auburn, WA N7005UBoeing 727-22 · S/N 18297Cancelled Apr 17, 1996 · Triennial form not returned · Auburn, WA N7008UBoeing 727-22 · S/N 18300Cancelled Apr 17, 1996 · Triennial form not returned · Auburn, WA N7012UBoeing 727-22 · S/N 18304Cancelled Apr 17, 1996 · Triennial form not returned · Auburn, WA N7023UBoeing 727-22 · S/N 18315Cancelled Apr 17, 1996 · Triennial form not returned · Auburn, WA

Back to Aero Controls Inc