Dynamic Aviation Group Inc
Registered aircraft · 45
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'DYNAMIC AVIATION GROUP INC' OR list_contains(g.other_registrant_names, 'DYNAMIC AVIATION GROUP INC') ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'DYNAMIC AVIATION GROUP INC' OR list_contains(g.other_registrant_names, 'DYNAMIC AVIATION GROUP INC') ORDER BY g.n_number
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.
N469NTravel Air 4000 · S/N 1383N7007GBeech 65-A90-1 · S/N LM-02First renewal noticeN7010LBeech 65-A90-1 · S/N LM-07First renewal noticeN7014LBeech 65-A90-1 · S/N LM-10First renewal noticeN7018FBeech 65-A90-1 · S/N LM-13N70292Beech 65-A90-1 · S/N LM-18First renewal noticeN70356Beech 65-A90-1 · S/N LM-25First renewal noticeN7036LBeech 65-A90-1 · S/N LM-26First renewal noticeN7038YBeech 65-A90-1 · S/N LM-28First renewal noticeN7039TBeech 65-A90-1 · S/N LM-30First renewal noticeN7043NBeech 65-A90-1 · S/N LM-38First renewal noticeN7047DBeech 65-A90-1 · S/N LM-41First renewal noticeN7052XBeech 65-A90-1 · S/N LM-45First renewal noticeN7052YBeech 65-A90-1 · S/N LM-47First renewal noticeN7062WBeech 65-A90-1 · S/N LM-49First renewal noticeN7063DBeech 65-A90-1 · S/N LM-50First renewal noticeN70648Beech 65-A90-1 · S/N LM-53First renewal noticeN7064QBeech 65-A90-1 · S/N LM-52First renewal noticeN7066XBeech 65-A90-1 · S/N LM-54First renewal noticeN7067SBeech 65-A90-1 · S/N LM-55First renewal noticeN7069FBeech 65-A90-1 · S/N LM-56First renewal noticeN7078LBeech 65-A90-1 · S/N LM-69First renewal noticeN70926Beech 65-A90-1 · S/N LM-84First renewal noticeN7112TBeech 65-A90-1 · S/N LM-88First renewal noticeN7120PBeech 65-A90-1 · S/N LM-90First renewal noticeN7126UBeech 65-A90-1 · S/N LM-93First renewal noticeN7128HBeech 65-A90-1 · S/N LM-94First renewal noticeN7132ZBeech 65-A90-1 · S/N LM-95First renewal noticeN71347Beech 65-A90-1 · S/N LM-96First renewal noticeN71351Beech 65-A90-1 · S/N LM-97First renewal noticeN7137GBeech 65-A90-1 · S/N LM-99First renewal noticeN7139ZBeech 65-A90-1 · S/N LM-101First renewal noticeN7146XBeech 65-A90-1 · S/N LM-104First renewal noticeN7155SBeech 65-A90-1 · S/N LM-112First renewal noticeN7157KBeech 65-A90-1 · S/N LM-115N7169ZBeech 65-A90-1 · S/N LM-123First renewal noticeN71797Beech 65-A90-1 · S/N LM-131First renewal noticeN7181HBeech 65-A90-1 · S/N LM-134First renewal noticeN7181JBeech 65-A90-1 · S/N LM-135First renewal noticeN7193MBeech 65-A90-1 · S/N LM-139First renewal noticeN7198BBeech 65-A90-1 · S/N LM-141First renewal noticeN735EBoeing 737-524 · S/N 26339N92JBeech 65-A90-4 · S/N LU-12First renewal noticeN93VBeech 65-A90-4 · S/N LU-03First renewal noticeN97TBeech 65-A90-1 · S/N LM-127First renewal notice
Back to Dynamic Aviation Group Inc