Skip to content

November Alpha LLC

Registered aircraft · 33

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

N112JJRobinson Helicopter R44 II · S/N 10568Built 2004 · Dover, DE N165PTRobinson Helicopter R44 II · S/N 10604Built 2005 · Dover, DE N175KMRobinson Helicopter R44 II · S/N 12106Built 2008 · Dover, DE N199GKCirrus Design SR22 · S/N 2644Built 2007 · Los Angeles, CA N223KCRobinson Helicopter R22 BETA · S/N 3435Built 2003 · Dover, DE N256SCRobinson Helicopter R22 BETA · S/N 4007Built 2006 · Dover, DE N3004XRobinson Helicopter R22 BETA · S/N 4152Built 2007 · Dover, DE N3231JRobinson Helicopter R44 II · S/N 11633Built 2007 · Dover, DE N323THRobinson Helicopter R66 · S/N 0624Built 2015 · Dover, DE N357JPRobinson Helicopter R44 II · S/N 10943Built 2005 · Los Angeles, CA N38GMRobinson Helicopter R22 BETA · S/N 3222Built 2001 · Dover, DE N40479Robinson Helicopter R44 II · S/N 14979Built 2026 · Dover, DE N4126ARobinson Helicopter R44 II · S/N 12096Built 2008 · Dover, DE N440SHRobinson Helicopter R44 II · S/N 10784Built 2005 · Dover, DE N443SARobinson Helicopter R44 II · S/N 10921Built 2005 · Los Angeles, CA N448SHRobinson Helicopter R44 II · S/N 10368Built 2004 · Los Angeles, CA N4537GRobinson Helicopter R44 II · S/N 12535Built 2009 · Dover, DE N484SHRobinson Helicopter R44 II · S/N 10678Dover, DE N556SHRobinson Helicopter R22 BETA · S/N 3581Built 2004 · Dover, DE N619RBRobinson Helicopter R44 II · S/N 11087Built 2006 · Dover, DE N74564Robinson Helicopter R22 BETA · S/N 3908Built 2005 · Dover, DE N74602Robinson Helicopter R44 II · S/N 11098Built 2006 · Dover, DE N75175Robinson Helicopter R44 · S/N 1331Built 2003 · Dover, DE N7523TRobinson Helicopter R44 II · S/N 10311Built 2004 · Dover, DE N7534LRobinson Helicopter R22 BETA · S/N 3650Built 2004 · Los Angeles, CA N7683HRobinson Helicopter R22 BETA · S/N 3885Built 2005 · Dover, DE N794YTRobinson Helicopter R44 II · S/N 11541Built 2006 · Dover, DE N831HRobinson Helicopter R44 II · S/N 11791Built 2007 · Dover, DE N8372RRobinson Helicopter R22 BETA · S/N 2805Built 1998 · Dover, DE N861MPRobinson Helicopter R44 II · S/N 14646Built 2023 · Dover, DE N899LRRobinson Helicopter R44 · S/N 1856Built 2008 · Dover, DE N907THRobinson Helicopter R22 BETA · S/N 3907Built 2005 · Dover, DE N979SHRobinson Helicopter R22 BETA · S/N 4073Built 2006 · Los Angeles, CA

Back to November Alpha LLC