Skip to content

Registered aircraft · 44

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

N184SWFairchild SA227-AC · S/N AC-647Built 1986 · Wilsonville, OR N226KLSwearingen SA226TC · S/N TC-321Built 1979 · Wilsonville, OR N227LEFairchild SA227-DC · S/N DC837BBuilt 1993 · Tualatin, OR N259DSFairchild Dornier DORNIER 328-300 · S/N 3197Built 2001 · Wilsonville, OR N2691WFairchild SA227-AC · S/N AC-655BBuilt 1986 · Wilsonville, OR N2728GFairchild SA227-AC · S/N AC-731Built 1989 · Wilsonville, OR N276CASwearingen SA226TC · S/N TC276Built 1978 · Wilsonville, OR N27BJLearjet 24B · S/N 227Built 1971 · Wilsonville, OR N280KLSwearingen SA226TC · S/N TC-280Built 1978 · Wilsonville, OR N31171Fairchild SA227-AC · S/N AC-605Built 1985 · Wilsonville, OR N326BASwearingen SA226TC · S/N TC 269Built 1978 · Wilsonville, OR N328DCFairchild Dornier DORNIER 328-300 · S/N 3136Tualatin, OR N356SKFairchild Dornier DORNIER 328-300 · S/N 3163Built 2000 · Tualatin, OR N358SKDornier 328-300 · S/N 3188Built 2001 · Tualatin, OR N366DCEmbraer EMB-120ER · S/N 120.288Built 1994 · Wilsonville, OR N394DCFairchild Dornier DORNIER 328-300 · S/N 3174Built 2001 · Wilsonville, OR N395DCFairchild Dornier DORNIER 328-300 · S/N 3178Built 2001 · Wilsonville, OR N398DCFairchild Dornier DORNIER 328-300 · S/N 3206Built 2002 · Wilsonville, OR N425MAFairchild SA227-AC · S/N AC-640Built 1986 · Wilsonville, OR N508FASwearingen SA227-AC · S/N AC508Built 1982 · Wilsonville, OR N538KLFairchild SA227-AC · S/N AC-538Wilsonville, OR N542FASwearingen SA227-AC · S/N AC-542Wilsonville, OR N571KLFairchild SA227-AC · S/N AC-571Wilsonville, OR N677DCDornier 328-300 · S/N 3126Built 1999 · Wilsonville, OR N730DCDornier Luftfahrt DORNIER 328-300 · S/N 3180Wilsonville, OR N740DCFairchild Dornier DORNIER 328-300 · S/N 3207Wilsonville, OR N769KLFairchild SA227-AC · S/N AC769BBuilt 1991 · Wilsonville, OR N779BCFairchild SA227BC · S/N BC-779BBuilt 1991 · Wilsonville, OR N787CSwearingen SA227-AC · S/N AC-550Wilsonville, OR N787KLFairchild SA227BC · S/N BC-787BBuilt 1991 · Wilsonville, OR N820DCFairchild SA227-DC (C26B) · S/N DC820BBuilt 1993 · Wilsonville, OR N832HKEmbraer EMB-145LR · S/N 145771Built 2003 · Wilsonville, OR N835HKEmbraer EMB-145LR · S/N 145670Built 2003 · Wilsonville, OR N882DCFairchild SA227-DC · S/N DC882BWilsonville, OR N885DCFairchild SA227-DC · S/N DC838BBuilt 1993 · Englewood, CO N889DCFairchild SA227-DC (C26B) · S/N DC-812BBuilt 1992 · Englewood, CO N970DCEmbraer EMB-145LR · S/N 14500837Built 2004 · Wilsonville, OR N971DCEmbraer EMB-145LR · S/N 14500821Built 2004 · Wilsonville, OR N972DCEmbraer EMB-145LR · S/N 14500812Built 2004 · Wilsonville, OR N973DCEmbraer EMB-145LR · S/N 145393Built 2001 · Wilsonville, OR N974DCEmbraer EMB-145XR · S/N 14501186Built 2013 · Wilsonville, OR N975DCEmbraer EMB-145XR · S/N 14501185Built 2013 · Wilsonville, OR N976DCEmbraer EMB-145LR · S/N 145514Built 2001 · Englewood, CO N977DCEmbraer EMB-145LR · S/N 145370Built 2001 · Englewood, CO

Back to Cbg LLC