AD 2017-19-01

Registered aircraft · 187

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:2017-19-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-19-01')
  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.

N763DXSikorsky Aircraft Corp · Stratford, CTBuilt 2011 · S/N 761003N763MHGm Leasing Co LLC · Broussard, LAS/N 760230N7644SIslander Holdings Ltd · Ft Lauderdale, FLS/N 760314N764AMNorth Flight Aero Med · Grand Rapids, MIBuilt 2009 · S/N 760764N7654ZWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 761054N765MHGm Leasing Co LLC · Broussard, LABuilt 1983 · S/N 760236N7663PBank Of Utah Trustee · Salt Lake City, UTS/N 761063N7664WBank Of Utah Trustee · Salt Lake City, UTS/N 761064N7675VNevada Aircraft Corp · Henderson, NVS/N 761075N767JSikorsky Aircraft Corp · West Palm Beach, FLBuilt 2012 · S/N 761007N7685CSikorsky Aircraft Corp · Stratford, CTS/N 761085N7686QSikorsky Aircraft Corp · Stratford, CTS/N 761086N7687LSikorsky Aircraft Corp · Stratford, CTS/N 761087N7688PSikorsky Aircraft Corp · Stratford, CTS/N 761088N7689LSikorsky Aircraft Corp · Stratford, CTS/N 761089N768ALSikorsky Aircraft Corp · Stratford, CTS/N 760031N768AMSpectrum Health Hospitals · Grand Rapids, MIBuilt 2009 · S/N 760710N768MHGm Leasing Co LLC · Broussard, LABuilt 1981 · S/N 760189N768SXRentco LLC · Deer Park, TXFirst renewal noticeBuilt 1991 · S/N 760372N7690LSikorsky Aircraft Corp · Stratford, CTS/N 761090N769MHGm Leasing Co LLC · Broussard, LAS/N 760278N769PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760671N76CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1989 · S/N 760355N76DNFastboy Equipment LLC · Beasley, TXS/N 760351N76EXIsland Express Helicopters Inc · Henderson, NVBuilt 1988 · S/N 760342N76FLHelinet Aviation Services LLC · Van Nuys, CABuilt 1988 · S/N 760347N76FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2005 · S/N 760585N76GATurbine Holdings II LLC · New York, NYBuilt 1999 · S/N 760498N76HHHallecopter LLC · Wilmington, DEBuilt 2010 · S/N 760807N76PCSo Much For Subtlety LLC · Dover, DEBuilt 2005 · S/N 760597N76VRArrow Aviation Co LLC · Broussard, LABuilt 1989 · S/N 760360N76ZAN76za LLC · New York, NYBuilt 2007 · S/N 760653N772PPhi Aviation LLC · Lafayette, LABuilt 2008 · S/N 760730N773BGBristow LLC · Lake Charles, LABuilt 2009 · S/N 760773N776DPDelaware Park LLC · Wilmington, DEBuilt 1991 · S/N 760367N780JCoulson Aviation (USA) Inc · Portland, ORS/N 760352N781PPhi Health LLC · Tempe, AZFirst renewal noticeBuilt 2006 · S/N 760630N781RLGm Leasing Company LLC · Broussard, LABuilt 2007 · S/N 760673N782RLGm Leasing Company LLC · Broussard, LABuilt 2007 · S/N 760666N783RLGm Leasing Company LLC · Broussard, LABuilt 2008 · S/N 760735N784RLGm Leasing Company LLC · Broussard, LABuilt 2008 · S/N 760721N785PSale Reported · Robert, LASale reported, canceledBuilt 2006 · S/N 760635N785RLGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 760639N786RLGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 760618N787RLGm Leasing Company LLC · Broussard, LABuilt 2009 · S/N 760778N794PPhi Aviation LLC · Lafayette, LABuilt 2008 · S/N 760737N797PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760742N7TPDt Connect II LLC · New York, NYBuilt 1989 · S/N 760353N800SGWhirlybird LLC · Los Angeles, CABuilt 2015 · S/N 761004N803SPma 1 LLC · Wilmington, DEBuilt 2001 · S/N 760520
Back to AD 2017-19-01