Skip to content

Cae Doss Aviation Inc

Registered aircraft · 59

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

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 = 'CAE DOSS AVIATION INC' OR list_contains(g.other_registrant_names, 'CAE DOSS AVIATION INC') ORDER BY g.n_number

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 = 'CAE DOSS AVIATION INC' OR list_contains(g.other_registrant_names, 'CAE DOSS AVIATION 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 = 'CAE DOSS AVIATION INC' OR list_contains(g.other_registrant_names, 'CAE DOSS AVIATION 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.

N143TXDiamond Aircraft Ind DA20-C1 · S/N C0412Built 2006 · Pueblo, CO N144TXDiamond Aircraft Ind DA20-C1 · S/N C0414Built 2007 · Pueblo, CO N240JPDiamond Aircraft Ind DA20-C1 · S/N C0192Built 2002 · Pueblo, CO N380GFDiamond Aircraft Ind DA20-C1 · S/N C0380Built 2006 · Pueblo, CO N493PADiamond Aircraft Ind DA20-C1 · S/N C0293Built 2004 · Pueblo, CO N916DADiamond Aircraft Ind DA20-C1 · S/N C0386Built 2006 · Pueblo, CO N917DADiamond Aircraft Ind DA20-C1 · S/N C0391Built 2006 · Pueblo, CO N918DADiamond Aircraft Ind DA20-C1 · S/N C0392Built 2006 · Pueblo, CO N919DADiamond Aircraft Ind DA20-C1 · S/N C0393Built 2006 · Pueblo, CO N920DADiamond Aircraft Ind DA20-C1 · S/N C0394Built 2006 · Pueblo, CO N921DADiamond Aircraft Ind DA20-C1 · S/N C0395Built 2006 · Pueblo, CO N922DADiamond Aircraft Ind DA20-C1 · S/N C0396Built 2006 · Pueblo, CO N923DADiamond Aircraft Ind DA20-C1 · S/N C0397Built 2006 · Pueblo, CO N924DADiamond Aircraft Ind DA20-C1 · S/N C0398Built 2006 · Pueblo, CO N925DADiamond Aircraft Ind DA20-C1 · S/N C0399Built 2006 · Pueblo, CO N926DADiamond Aircraft Ind DA20-C1 · S/N C0400Built 2006 · Pueblo, CO N928DADiamond Aircraft Ind DA20-C1 · S/N C0418Built 2007 · Pueblo, CO N930DADiamond Aircraft Ind DA20-C1 · S/N C0419Built 2007 · Pueblo, CO N931DADiamond Aircraft Ind DA20-C1 · S/N C0420Built 2007 · Pueblo, CO N932DADiamond Aircraft Ind DA20-C1 · S/N C0421Built 2007 · Pueblo, CO N933DADiamond Aircraft Ind DA20-C1 · S/N C0422Built 2007 · Pueblo, CO N934DADiamond Aircraft Ind DA20-C1 · S/N C0423Built 2007 · Pueblo, CO N935DADiamond Aircraft Ind DA20-C1 · S/N C0424Built 2007 · Pueblo, CO N936DADiamond Aircraft Ind DA20-C1 · S/N C0496Built 2008 · Pueblo, CO N937DADiamond Aircraft Ind DA20-C1 · S/N C0497Built 2008 · Pueblo, CO N938DADiamond Aircraft Ind DA20-C1 · S/N C0504Built 2008 · Pueblo, CO N939DADiamond Aircraft Ind DA20-C1 · S/N C0402Built 2006 · Pueblo, CO N940DADiamond Aircraft Ind DA20-C1 · S/N C0511Built 2008 · Pueblo, CO N941DADiamond Aircraft Ind DA20-C1 · S/N C0512Built 2008 · Pueblo, CO N942DADiamond Aircraft Ind DA20-C1 · S/N C0462Built 2007 · Pueblo, CO N943DADiamond Aircraft Ind DA20-C1 · S/N C0513Built 2008 · Pueblo, CO N944DADiamond Aircraft Ind DA20-C1 · S/N C0611Built 2012 · Pueblo, CO N946DADiamond Aircraft Ind DA20-C1 · S/N C0446Built 2007 · Pueblo, CO N947DADiamond Aircraft Ind DA20-C1 · S/N C0447Built 2007 · Pueblo, CO N948DADiamond Aircraft Ind DA20-C1 · S/N C0448Pueblo, CO N953DADiamond Aircraft Ind DA20-C1 · S/N C0449Built 2007 · Pueblo, CO N954DADiamond Aircraft Ind DA20-C1 · S/N C0450Built 2007 · Pueblo, CO N955DADiamond Aircraft Ind DA20-C1 · S/N C0451Built 2007 · Pueblo, CO N956DADiamond Aircraft Ind DA20-C1 · S/N C0536Built 2008 · Pueblo, CO N957DADiamond Aircraft Ind DA20-C1 · S/N C0467Built 2007 · Pueblo, CO N958DADiamond Aircraft Ind DA20-C1 · S/N C0468Built 2007 · Pueblo, CO N959DADiamond Aircraft Ind DA20-C1 · S/N C0216Built 2003 · Pueblo, CO N960DADiamond Aircraft Ind DA20-C1 · S/N C0470Built 2007 · Pueblo, CO N963DADiamond Aircraft Ind DA20-C1 · S/N C0471Built 2007 · Pueblo, CO N965DADiamond Aircraft Ind DA20-C1 · S/N C0320Built 2005 · Pueblo, CO N968DADiamond Aircraft Ind DA20-C1 · S/N C0578First renewal noticeBuilt 2011 · Pueblo, CO N971DADiamond Aircraft Ind DA20-C1 · S/N C0487Built 2008 · Pueblo, CO N972DADiamond Aircraft Ind DA20-C1 · S/N C0482Built 2008 · Pueblo, CO N973DADiamond Aircraft Ind DA20-C1 · S/N C0483Built 2008 · Pueblo, CO N978DADiamond Aircraft Ind DA20-C1 · S/N C0485Built 2008 · Pueblo, CO

Back to Cae Doss Aviation Inc