Registered aircraft · 56

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

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

N139PHAgusta Aerospace AW139 · S/N 41253Lafayette, LA N140PHAgusta Aerospace AW139 · S/N 41254Built 2010 · Lafayette, LA N141PHAgusta Aerospace AW139 · S/N 41266Lafayette, LA N146PHAgusta Aerospace AW139 · S/N 41280Built 2011 · Lafayette, LA N149PHAgustawestland Philadelphia AW139 · S/N 41303Built 2012 · Lafayette, LA N151PHAgustawestland Philadelphia AW139 · S/N 41312Built 2012 · Lafayette, LA N152PHAgustawestland Philadelphia AW139 · S/N 41316Built 2012 · Lafayette, LA N153PHAgustawestland Philadelphia AW139 · S/N 41317Built 2012 · Lafayette, LA N192PHSikorsky S-92A · S/N 920021Built 2005 · Lafayette, LA N327PHEurocopter Deutschland EC 135 P2+ · S/N 0445Built 2006 · Lafayette, LA N328PHEurocopter Deutschland EC 135 P2+ · S/N 0450Built 2006 · Lafayette, LA N343PHAirbus Helicopters Deutschland MBB-BK 117 D-2 · S/N 20120Built 2017 · Lafayette, LA N392PHSikorsky S-92A · S/N 920015Built 2005 · Lafayette, LA N393PHAirbus Helicopters Deutschland MBB-BK 117 D-2 · S/N 20122Built 2017 · Lafayette, LA N411PHBell 407 · S/N 53637Built 2005 · Lafayette, LA N412PHBell Helicopter Textron Canada 407 · S/N 53862Built 2008 · Lafayette, LA N415PHBell 407 · S/N 53390Built 1999 · Lafayette, LA N417PHBell 407 · S/N 53038Built 1996 · Lafayette, LA N418PHBell 407 · S/N 53640Built 2005 · Lafayette, LA N420PHBell 407 · S/N 53747Built 2007 · Lafayette, LA N421PHBell 407 · S/N 53749Built 2007 · Lafayette, LA N422PHBell 407 · S/N 53675Built 2005 · Lafayette, LA N424PHBell 407 · S/N 53682Built 2006 · Lafayette, LA N430PHBell Helicopter Textron Canada 407 · S/N 53870Built 2008 · Lafayette, LA N433PHBell Helicopter Textron Canada 407 · S/N 53421Built 2000 · Lafayette, LA N438PHBell 407 · S/N 53622Built 2004 · Lafayette, LA N439PHBell Helicopter Textron Canada 407 · S/N 53999Built 2010 · Lafayette, LA N440PHBell Helicopter Textron Canada 407 · S/N 53327Built 1998 · Lafayette, LA N441PHBell Helicopter Textron Canada 407 · S/N 54081Built 2011 · Lafayette, LA N442PHBell Helicopter Textron Canada 407 · S/N 54089Built 2011 · Lafayette, LA N443PHBell Helicopter Textron Canada 407 · S/N 54090Built 2012 · Lafayette, LA N445PHBell Helicopter Textron Canada 407 · S/N 54096Built 2012 · Lafayette, LA N448PHBell Helicopter Textron Canada 407 · S/N 54111Built 2012 · Lafayette, LA N452PHBell 407 · S/N 53457Built 2000 · Lafayette, LA N454PHBell 407 · S/N 53435Built 2000 · Lafayette, LA N457PHBell 407 · S/N 53121Built 1997 · Lafayette, LA N492PHSikorsky S-92A · S/N 920016Lafayette, LA N495PHBell 407 · S/N 53397Built 1999 · Lafayette, LA N496PHBell 407 · S/N 53398Built 1999 · Lafayette, LA N592PHSikorsky S-92A · S/N 920027Lafayette, LA N718PKeystone Helicopter S-76C · S/N 760686Built 2007 · Lafayette, LA N724PHSikorsky S-76C-2 · S/N 760688Built 2007 · Lafayette, LA N725PSikorsky S-76C · S/N 760692Built 2007 · Lafayette, LA N738PSikorsky S-76C-2 · S/N 760668Lafayette, LA N745PSikorsky S-76C · S/N 760619Built 2006 · Lafayette, LA N769PSikorsky S-76C · S/N 760671Built 2007 · Lafayette, LA N772PSikorsky S-76C · S/N 760730Built 2008 · Lafayette, LA N794PKeystone Helicopter S-76C · S/N 760737Built 2008 · Lafayette, LA N838PHLeonardo S P A AW189 · S/N 89038Lafayette, LA N839PHLeonardo S P A AW189 · S/N 89039Lafayette, LA

Back to Phi Aviation LLC