AD 2012-23-02

Registered aircraft · 79

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2012-23-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-23-02')
  ORDER BY 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.

N6JEEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11095N6VZLeonardo Helicopters US Corp · Philadelphia, PABuilt 2000 · S/N 11099N71NMNorth Memorial Health Care · Brooklyn Center, MNBuilt 2009 · S/N 22146N73AZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 22004N749SDRocklyn Leasing LLC · Duluth, GABuilt 2002 · S/N 11155N75GGA109s LLC · Pinecrest, FLBuilt 2009 · S/N 22141N770PATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 22022N7ADEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11098N7UCRegistration Pending · Greenwood Village, CORegistration pendingBuilt 2000 · S/N 11088N80NYWgb Holdings LLC · Sparta, NJS/N 11214N81NMNorth Memorial Health Care · Brooklyn Center, MNBuilt 2008 · S/N 22086N820FTBristow LLC · Lake Charles, LABuilt 2007 · S/N 11701N827KUEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11609N85KVKhosla Ventures LLC · San Jose, CABuilt 2002 · S/N 11145N901CMLifeflight Of Maine LLC · Bangor, MEBuilt 2004 · S/N 11611N901EMLifeflight Of Maine LLC · Bangor, MEBuilt 2004 · S/N 11614N90NMNorth Memorial Health Care · Minneapolis, MNBuilt 2007 · S/N 22044N910LBBristow LLC · Lake Charles, LABuilt 2006 · S/N 11682N91LFInternational Defense & Aerospace Group LLC · Glen Mills, PABuilt 2002 · S/N 11509N91SVSaint Vincent Mercy Medical Center · Toledo, OHS/N 11627N921LFLife Flight Network LLC · Aurora, ORBuilt 2002 · S/N 11142N922LFEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11149N923LFEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2003 · S/N 11220N92LFEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2004 · S/N 11604N94AHEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11081N95RZSt Vincent Mercy Medical Center · Toledo, OHBuilt 2002 · S/N 11147N962JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 22047N963JERegistered aircraftAssigned (import), pending cancellationS/N 22016N9CWGran Cosecha LLC · Lake Wales, FLBuilt 2008 · S/N 11732
Back to AD 2012-23-02