Skip to content

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

N108AGAgusta A119 · S/N 14053Built 2005 · Lake Charles, LA N108TAEurocopter AS 350 B2 · S/N 3080Built 1998 · Lake Charles, LA N109DRAgusta AW139 · S/N 31311Lake Charles, LA N119MWAgustawestland Philadelphia AW139 · S/N 41307Built 2012 · Lake Charles, LA N127JLEurocopter Deutschland EC 135 P2+ · S/N 0976Built 2011 · Lake Charles, LA N145JWSikorsky S-92A · S/N 920300Built 2016 · Lake Charles, LA N159RBAgustawestland Philadelphia AW139 · S/N 41281Built 2012 · Lake Charles, LA N183EHEurocopter AS 350 B2 · S/N 2752Built 1993 · Lake Charles, LA N185EHEurocopter AS 350 B2 ECUREUIL · S/N 2823Built 1994 · Lake Charles, LA N187EHAerospatiale AS350 B2 ECUREUIL · S/N 2839Built 1994 · Lake Charles, LA N189EHAgustawestland AW189 · S/N 49018Built 2015 · Lake Charles, LA N193EHAerospatiale AS350 B2 ECUREUIL · S/N 2599Lake Charles, LA N214EHEurocopter AS 350 B2 · S/N 3163Built 1998 · Lake Charles, LA N215EHEurocopter AS 350 B2 · S/N 3172Built 1998 · Lake Charles, LA N216EHEurocopter AS 350 B2 · S/N 3184Built 1999 · Lake Charles, LA N217EHEurocopter AS 350 B2 · S/N 3197Built 1999 · Lake Charles, LA N217FDEurocopter AS 350 B2 · S/N 4221Built 2007 · Lake Charles, LA N228BJEurocopter Deutschland EC 135 P2+ · S/N 0982Built 2011 · Lake Charles, LA N302NMEurocopter Deutschland EC 135 P2+ · S/N 0987Built 2011 · Lake Charles, LA N314SSAgustawestland AW189 · S/N 49019Built 2015 · Lake Charles, LA N320TVEurocopter Deutschland EC 135 P2+ · S/N 0467Built 2006 · Lake Charles, LA N323AHEurocopter AS 350 B2 · S/N 4649Built 2008 · Lake Charles, LA N324XMEurocopter Deutschland EC 135 P2+ · S/N 0991Built 2011 · Lake Charles, LA N325DBEurocopter Deutschland EC 135 P2+ · S/N 0985Built 2011 · Lake Charles, LA N326LSLeonardo S P A AW189 · S/N 49028Built 2016 · Lake Charles, LA N328SHAgustawestland Philadelphia AW139 · S/N 41309Built 2012 · Lake Charles, LA N330JNAgusta AW119MKII · S/N 14510Built 2006 · Lake Charles, LA N334JTAgusta A109E · S/N 11738Built 2008 · Lake Charles, LA N40584Eurocopter AS 350 B2 · S/N 2924Built 1998 · Lake Charles, LA N4061GEurocopter France AS350B2 · S/N 3051Built 1997 · Lake Charles, LA N415JHAgusta Aerospace AW139 · S/N 41224Built 2009 · Lake Charles, LA N420JAEurocopter AS 350 B2 · S/N 4212Built 2007 · Lake Charles, LA N430TMEurocopter Deutschland EC 135 P2+ · S/N 0457Built 2006 · Lake Charles, LA N503JWLeonardo S P A AW189 · S/N 49025Built 2016 · Lake Charles, LA N524JDAgustawestland Philadelphia AW139 · S/N 41301Built 2012 · Lake Charles, LA N524PBSikorsky S-92A · S/N 920275Built 2015 · Lake Charles, LA N530KSAgusta A109E · S/N 11694Built 2006 · Lake Charles, LA N547WMSikorsky S-76C · S/N 760722Built 2008 · Lake Charles, LA N553RDAgustawestland Philadelphia AW139 · S/N 41369Built 2014 · Lake Charles, LA N602FBLeonardo S P A AW119 MKII · S/N 14528Built 2007 · Lake Charles, LA N603PWAgusta AW139 · S/N 31309Built 2010 · Lake Charles, LA N709CGAgusta A119 · S/N 14052Lake Charles, LA N715RTAgusta A119 · S/N 14516Built 2006 · Lake Charles, LA N726MDAgustawestland Philadelphia AW139 · S/N 41320Built 2013 · Lake Charles, LA N730VMAgustawestland Philadelphia AW139 · S/N 41362Built 2014 · Lake Charles, LA N747WBEurocopter AS 350 B2 ECUREUIL · S/N 2768Built 1993 · Lake Charles, LA N773BGKeystone Helicopter S-76C · S/N 760773Built 2009 · Lake Charles, LA N802SMAgusta Aerospace AW119 MKII · S/N 14711Lake Charles, LA N806APSikorsky S-92A · S/N 920291Built 2015 · Lake Charles, LA N811TAAgustawestland Philadelphia AW139 · S/N 41269Built 2011 · Lake Charles, LA

Back to Bristow LLC