Draken International LLC
Registered aircraft · 36
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 = 'DRAKEN INTERNATIONAL LLC' OR list_contains(g.other_registrant_names, 'DRAKEN INTERNATIONAL LLC') 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 = 'DRAKEN INTERNATIONAL LLC' OR list_contains(g.other_registrant_names, 'DRAKEN INTERNATIONAL LLC') 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.
N141EMDouglas TA-4K · S/N 157915N142EMDouglas A-4K · S/N 154904N144EMDouglas A-4K · S/N 154908N145EMDouglas A-4K · S/N 155052N146EMDouglas A-4K · S/N 155063N147EMDouglas A-4K · S/N 155069N149EMDouglas A-4K · S/N 14085N161EMMcdonnell Douglas A4N · S/N 159805N162EMMcdonnell Douglas A4N · S/N 159542N163EMMcdonnell Douglas A4N · S/N 159815N164EMMcdonnell Douglas A4N · S/N 159078N166EMMcdonnell Douglas A4N · S/N 159545N167EMMcdonnell Douglas A4N · S/N 159530N2215DNorth American T-28C · S/N 146281N258EMAero Vodochody Aerospace L-159 · S/N 156022N266EMAero Vodochody Aerospace L-159 · S/N 156023N278EMAero Vodochody VODOCHODY L-159A · S/N 156043N556EMDassault MIRAGE F-1 · S/N B506N557EMDassault MIRAGE F1 M · S/N 04N558EMDassault MIRAGE F-1 · S/N 18N559EMDassault MIRAGE F-1 · S/N 21N561EMDassault MIRAGE F-1 · S/N 36N562EMDassault MIRAGE F-1 · S/N 41N563EMDassault MIRAGE F-1 · S/N 42N564EMDassault MIRAGE F-1 · S/N 43N565EMDassault MIRAGE F-1 · S/N 44N566EMDassault MIRAGE F-1 · S/N 54N568EMDassault MIRAGE F-1 · S/N 57N569EMDassault MIRAGE F-1 · S/N 60N570EMDassault MIRAGE F-1 · S/N 63N571EMDassault MIRAGE F-1 · S/N 64N572EMDassault MIRAGE F-1 · S/N 67N573EMDassault MIRAGE F-1 · S/N 68N574EMDassault MIRAGE F-1 · S/N 70N575EMDassault MIRAGE F-1 · S/N 72N576EMDassault MIRAGE F-1 · S/N 73
Back to Draken International LLC