Skip to content

Dynamic Aviation Group Inc

Earlier aircraft under this name · 34

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

N327ENBoeing Of Canada/Dehav Div DHC-8-311 · S/N 261Cancelled Aug 27, 2023 · Built 1991 · Bridgewater, VA N301KDehavilland DHC-8-301 · S/N 190Cancelled Jul 26, 2023 · Bridgewater, VA N328ENBoeing Of Canada/Dehav Div DHC-8-311 · S/N 281Cancelled Jul 26, 2023 · Built 1991 · Bridgewater, VA N7043DBeech 65-A90-1 · S/N LM-35Cancelled May 27, 2023 · Bridgewater, VA N7051KBeech 65-A90-1 · S/N LM-44Cancelled May 27, 2023 · Bridgewater, VA N7169UBeech 65-A90-1 · S/N LM-122Cancelled May 27, 2023 · Bridgewater, VA N590KDehavilland DHC-8-315 · S/N 590Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 2002 · Bridgewater, VA N320XDehavilland DHC-8-311 · S/N 320Cancelled Jun 22, 2021 · Built 1992 · Bridgewater, VA N308HDehavilland DHC-8-315 · S/N 374Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Bridgewater, VA N41RBeech A200 · S/N BC-31Cancelled Oct 20, 2015 · Second renewal notice · Bridgewater, VA N1340LBeech B200 · S/N BB-1340Cancelled Jun 25, 2014 · First renewal notice · Bridgewater, VA N7071HBeech 65-A90-1 · S/N LM-58Cancelled May 6, 2014 · Third renewal notice · Bridgewater, VA N71597Beech 65-A90-1 · S/N LM-118Cancelled Apr 1, 2014 · Second renewal notice · Bridgewater, VA N39UBeech E-90 · S/N LW-109Cancelled Mar 25, 2014 · Built 1974 · Bridgewater, VA N70879Beech 65-A90-1 · S/N LM-76Cancelled Mar 25, 2014 · Second renewal notice · Bridgewater, VA N71581Beech 65-A90-1 · S/N LM-116Cancelled Mar 25, 2014 · Second renewal notice · Bridgewater, VA N7165JBeech 65-A90-1 · S/N LM-119Cancelled Mar 25, 2014 · Second renewal notice · Bridgewater, VA N7201ZBeech 65-A90-1 · S/N LM-100Cancelled Mar 25, 2014 · Second renewal notice · Bridgewater, VA N638DBeech B90 · S/N LJ-424Cancelled May 10, 2013 · First renewal notice · Built 1968 · Bridgewater, VA N1149WBeech A200 · S/N BC-72Cancelled Feb 7, 2013 · First renewal notice · Built 1977 · Bridgewater, VA N1290ABeech 65-90 · S/N LJ-30Cancelled Feb 7, 2013 · First renewal notice · Built 1965 · Bridgewater, VA N654CBeech 65-90 · S/N LJ-12Cancelled Feb 7, 2013 · First renewal notice · Built 1964 · Bridgewater, VA N90NMBeech B90 · S/N LJ-404Cancelled Feb 7, 2013 · First renewal notice · Built 1968 · Bridgewater, VA N93RYBeech 65-A90 · S/N LJ-174Cancelled Feb 7, 2013 · First renewal notice · Built 1966 · Bridgewater, VA N28CBeech A100 · S/N B-216Cancelled Feb 6, 2013 · First renewal notice · Bridgewater, VA N45ABeech A200 · S/N BC48Cancelled Dec 7, 2012 · First renewal notice · Bridgewater, VA N90RGBeech C90 · S/N LJ-546Cancelled Jul 31, 2012 · First renewal notice · Built 1971 · Bridgewater, VA N49KBeech A200 · S/N BD26Cancelled May 8, 2012 · First renewal notice · Bridgewater, VA N525JKBeech 65-A90 · S/N LJ-305Cancelled Nov 15, 2011 · First renewal notice · Built 1967 · Bridgewater, VA N850BCBeech C-45H · S/N 51-11844ACancelled Aug 30, 2011 · First renewal notice · Built 1951 · Bridgewater, VA N3221QGrumman G-164A · S/N 1184Cancelled Jul 14, 2011 · Bridgewater, VA N63DGrumman Acft ENG Cor-Schweizer G-164B · S/N 301BCancelled Sep 25, 2008 · Built 1977 · Bridgewater, VA N299MSBeech B90 · S/N LJ-457Cancelled Sep 3, 2008 · Built 1969 · Bridgewater, VA N9TWBeech B90 · S/N LJ379Cancelled Jun 15, 2001 · Triennial form not returned · Bridgewater, VA

Back to Dynamic Aviation Group Inc