OpenAirDocs.org
Quest Diagnostics Clinical Laboratories Inc

Registered aircraft · 18

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
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 = 'QUEST DIAGNOSTICS CLINICAL LABORATORIES INC' OR list_contains(g.other_registrant_names, 'QUEST DIAGNOSTICS CLINICAL LABORATORIES INC')
  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.

N119QDPilatus PC-12/45 · S/N 119Built 1995 · Reading, PAN120QDPilatus PC-12/45 · S/N 120Built 1995 · Reading, PAN149QDPilatus PC-12/45 · S/N 149Built 1996 · Reading, PAN288DXEmbraer-Empresa Brasileira De EMB-500 · S/N 50000166Built 2010 · Reading, PAN338QDPilatus PC-12/45 · S/N 338Built 2000 · Reading, PAN399SAPilatus PC-12/45 · S/N 407Built 2001 · Reading, PAN412MDPilatus PC-12/45 · S/N 412Built 2001 · Reading, PAN453PCPilatus PC-12/45 · S/N 453Built 2002 · Reading, PAN465QDPilatus PC-12/45 · S/N 465Built 2002 · Reading, PAN546PBPilatus PC-12/45 · S/N 546Built 2004 · Reading, PAN552TCPilatus PC-12/45 · S/N 443Built 2002 · Reading, PAN567QDPilatus PC-12/45 · S/N 567Built 2004 · Reading, PAN636QDPilatus PC-12/45 · S/N 636Built 2005 · Reading, PAN648DXEmbraer-Empresa Brasileira De EMB-500 · S/N 50000176Built 2010 · Reading, PAN687QDPilatus PC-12/47 · S/N 687Built 2006 · Reading, PAN758QDPilatus PC-12/47 · S/N 758Built 2006 · Reading, PAN88QDPilatus PC-12/45 · S/N 478Built 2002 · Reading, PAN899DXEmbraer-Empresa Brasileira De EMB-500 · S/N 50000216Built 2010 · Reading, PA
Back to Quest Diagnostics Clinical Laboratories Inc