Skip to content

Registered aircraft · 108

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

N151AEEurocopter AS 350 B3 · S/N 3814Built 2004 · Tempe, AZ N153AEEurocopter AS 350 B3 · S/N 3829Built 2004 · Tempe, AZ N241PHBeech B200 · S/N BB-1182Built 1984 · Tempe, AZ N246PHBeech B200 · S/N BB-1373Built 1990 · Tempe, AZ N248PHRaytheon B200 · S/N BB-1618Built 1998 · Tempe, AZ N301PHEurocopter Deutschland EC 135 P2 · S/N 0355Built 2004 · Tempe, AZ N302PHEurocopter Deutschland EC 135 P2 · S/N 0364Built 2004 · Tempe, AZ N303PHEurocopter Deutschland EC 135 P2 · S/N 0372Built 2004 · Tempe, AZ N304PHEurocopter Deutschland EC 135 P2+ · S/N 0386Built 2005 · Tempe, AZ N305PHEurocopter Deutschland EC 135 P2 · S/N 0395Built 2005 · Tempe, AZ N308PHEurocopter Deutschland EC 135 P2+ · S/N 0401Built 2005 · Tempe, AZ N309PHEurocopter Deutschland EC 135 P2 · S/N 0403Built 2005 · Tempe, AZ N311PHEurocopter Deutschland EC 135 P2 · S/N 413Built 2005 · Tempe, AZ N312PHEurocopter Deutschland EC 135 P2 · S/N 0404Built 2005 · Tempe, AZ N314PHEurocopter Deutschland EC 135 P2 · S/N 409Built 2005 · Tempe, AZ N317PHEurocopter Deutschland EC 135 P2 · S/N 423Built 2005 · Tempe, AZ N320PHEurocopter Deutschland EC 135 P2+ · S/N 0430Built 2005 · Tempe, AZ N323PHEurocopter Deutschland EC 135 P2+ · S/N 0434Built 2005 · Tempe, AZ N324PHEurocopter Deutschland EC 135 P2+ · S/N 0571Built 2007 · Tempe, AZ N325PHEurocopter Deutschland EC 135 P2+ · S/N 0576First renewal noticeBuilt 2007 · Tempe, AZ N326PHEurocopter Deutschland EC 135 P2+ · S/N 0435Built 2006 · Tempe, AZ N327PHEurocopter Deutschland EC 135 P2+ · S/N 0445Built 2006 · Tempe, AZ N328PHEurocopter Deutschland EC 135 P2+ · S/N 0450Built 2006 · Tempe, AZ N329PHEurocopter Deutschland EC 135 P2 · S/N 0489Built 2006 · Tempe, AZ N32HHLearjet 31A · S/N 201Built 2000 · Tempe, AZ N330PHEurocopter Deutschland EC 135 P2+ · S/N 0514Built 2006 · Tempe, AZ N332PHEurocopter Deutschland EC 135 P2+ · S/N 0519Built 2006 · Tempe, AZ N337PHEurocopter Deutschland EC 135 P2+ · S/N 0456Built 2006 · Tempe, AZ N341PEurocopter AS 350 B3 · S/N 3777Tempe, AZ N344PHEurocopter Deutschland EC 135 P2+ · S/N 0459Built 2006 · Tempe, AZ N348PAirbus Helicopters AS350B3 · S/N 7998Built 2015 · Tempe, AZ N353PEurocopter AS 350 B3 · S/N 3722Built 2003 · Tempe, AZ N354PEurocopter France AS 350 B3 · S/N 3690Built 2003 · Tempe, AZ N356PAirbus Helicopters AS350B3 · S/N 8014Built 2015 · Tempe, AZ N370PHEurocopter Deutschland EC 135 P2+ · S/N 0464Built 2006 · Tempe, AZ N376PHEurocopter Deutschland EC 135 P2+ · S/N 0523Built 2006 · Tempe, AZ N381PHEurocopter Deutschland EC 135 P2+ · S/N 0611Built 2007 · Tempe, AZ N382PAirbus Helicopters AS350B3 · S/N 7920Built 2014 · Tempe, AZ N382PHEurocopter Deutschland EC 135 P2+ · S/N 0618Built 2007 · Tempe, AZ N383PHEurocopter Deutschland EC 135 P2+ · S/N 0622Built 2007 · Tempe, AZ N384PAirbus Helicopters AS350B3 · S/N 7928Built 2014 · Tempe, AZ N384PHEurocopter Deutschland EC 135 P2+ · S/N 0653Built 2008 · Tempe, AZ N385PHEurocopter Deutschland EC 135 P2+ · S/N 0670Built 2008 · Tempe, AZ N386PAmerican Eurocopter AS350B3 · S/N 7638Built 2013 · Tempe, AZ N388PHEurocopter Deutschland EC 135 P2+ · S/N 0701Built 2008 · Tempe, AZ N389PAmerican Eurocopter AS350B3 · S/N 7627Built 2013 · Tempe, AZ N389PHEurocopter Deutschland EC 135 P2+ · S/N 0710Built 2008 · Tempe, AZ N390PHEurocopter Deutschland EC 135 P2+ · S/N 0733Built 2008 · Tempe, AZ N391PAirbus Helicopters AS 350B3 · S/N 9644Built 2024 · Tempe, AZ N391PHEurocopter Deutschland EC 135 P2+ · S/N 0748Built 2008 · Tempe, AZ

Back to Phi Health LLC