OpenAirDocs.org
Dragonfly Aviation LLC

Registered aircraft · 24

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 = 'DRAGONFLY AVIATION LLC' OR list_contains(g.other_registrant_names, 'DRAGONFLY AVIATION 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.

N148DADiamond Aircraft Ind DA20-C1 · S/N C0146Built 2001 · Winder, GAN225DADiamond Aircraft Ind DA20-C1 · S/N C0225Built 2003 · Winder, GAN27758Bell 206B · S/N 2791Built 1979 · Saint Ansgar, IAN284DADiamond Aircraft Ind DA 40 · S/N 40.284Built 2003 · Winder, GAN28PLRobinson Helicopter R44 II · S/N 10535Mirando City, TXN29VMRobinson Helicopter R44 · S/N 0368Laredo, TXN3017PRobinson Helicopter R44 · S/N 1820Built 2007 · Mirando City, TXN309DADiamond Aircraft Ind DA20-C1 · S/N C0309Built 2005 · Winder, GAN3500LCessna 150F · S/N 15062300Built 1965 · Winder, GAN356DADiamond Aircraft Ind DA 40 · S/N 40.356Built 2004 · Winder, GAN361DADiamond Aircraft Ind DA20-C1 · S/N C0301Built 2004 · Winder, GAN363DADiamond Aircraft Ind DA20-C1 · S/N C0303Built 2004 · Winder, GAN36KRHughes Helicopters HUGHES 369D · S/N 580315DBuilt 1978 · Mirando City, TXN41VUCirrus Design SR20 · S/N 2439Built 2018 · Winder, GAN427DADiamond Aircraft Ind DA20-C1 · S/N C0247Built 2003 · Winder, GAN464DADiamond Aircraft Ind DA20-C1 · S/N C0404Built 2006 · Winder, GAN673DADiamond Aircraft Ind DA 40 · S/N 40.673Built 2006 · Winder, GAN855DADiamond Aircraft Ind DA20-C1 · S/N C0255Built 2004 · Winder, GAN880DACub Crafters CC11-100 · S/N CC11-00008Built 2006 · Winder, GAN892MADiamond Aircraft Ind DA 42 · S/N 42.AC122Built 2008 · Winder, GAN951DAGame Composites GB1 GAMEBIRD · S/N 0095Built 2024 · Winder, GAN952RGRobinson Helicopter R44 · S/N 1257Built 2002 · Mirando City, TXN971GJRobinson Helicopter R22 BETA · S/N 1934Built 1991 · Mirando City, TXN998JGRaytheon B36TC · S/N EA-641Built 1999 · Davie, FL
Back to Dragonfly Aviation LLC