OpenAirDocs.org
AD 2017-19-01

Registered aircraft · 188

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.

N1103SScs 21 LLC · North Salt Lake, UTBuilt 2013 · S/N 761016N11110Arrow Aviation Co LLC · Broussard, LAS/N 760429N115MQArkansas Childrens Hospital · Little Rock, ARS/N 761009N120DTIflyajet Inc · Lawrenceville, GABuilt 1990 · S/N 760362N121NCSun Meridian Bernardino LLC · Brea, CABuilt 1998 · S/N 760491N1308Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 760667N13MQArrow Aviation Company LLC · Broussard, LAS/N 760624N141MHCinema Aircraft Executive Transportation LLC · Las Vegas, NVBuilt 1997 · S/N 760465N152AEMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 760714N155RRCas LLC · Longboat Key, FLBuilt 1996 · S/N 760464N159CMMomentum Foundation Inc · Tullahoma, TNBuilt 1987 · S/N 760333N164AMIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1994 · S/N 760427N16MQArrow Aviation Company LLC · Broussard, LAS/N 760626N176AMSpectrum Health Hospitals · Grand Rapids, MIBuilt 2007 · S/N 760665N176BAIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1985 · S/N 760317N176DPDodson International Parts Inc · Rantoul, KSS/N 760356N176FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2007 · S/N 760646N208SSugar Pine Aviation LLC · Merlin, ORBuilt 1992 · S/N 760399N2119AArrow Aviation Co LLC · Broussard, LAS/N 760640N212YS76b LLC · New York, NYBuilt 1989 · S/N 760357N2133XArrow Aviation Co LLC · Broussard, LAS/N 760638N25740Arrow Aviation Company LLC · Broussard, LAS/N 760732N269FLBlackbird Aero LLC · Boca Raton, FLBuilt 1987 · S/N 760335N26HFHeliflite Shares LLC · Kearny, NJBuilt 1998 · S/N 760488N276FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2000 · S/N 760509N276TCN276tc LLC · Chino, CABuilt 1980 · S/N 760061N276THHealth Care District Of Palm Beach County · West Palm Beach, FLBuilt 1999 · S/N 760494N278FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2008 · S/N 760750N27DXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 761069N280TRAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 1988 · S/N 760344N282SArrow Aviation Company LLC · Broussard, LABuilt 1985 · S/N 760282N30RTBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 760511N311WGPentair LLC · Palmetto, FLBuilt 1996 · S/N 760457N327VAAir Wolfpack LLC · Grand Rapids, MIBuilt 2007 · S/N 760695N328PKOnyx Aviation LLC · Needham, MABuilt 2005 · S/N 760604N34HFHeliflite Shares LLC · Kearny, NJBuilt 2005 · S/N 760608N355JSMinerd Holdings LLC · Chicago, ILBuilt 2007 · S/N 760684N35HFHeliflite Shares LLC · Kearny, NJBuilt 2008 · S/N 760746N36ENWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 761014N36HFHeliflite Shares LLC · Kearny, NJBuilt 2009 · S/N 760776N36RPMirasol Sky LLC · Dallas, TXBuilt 2013 · S/N 761037N376WHGm Leasing Company LLC · Broussard, LABuilt 2009 · S/N 760759N38HFHeliflite Shares LLC · Kearny, NJBuilt 2008 · S/N 760700N399KKRegistered aircraftBuilt 2003 · S/N 760550N39HFHeliflite Shares LLC · Kearny, NJBuilt 2011 · S/N 760808N40WHGm Leasing Co LLC · Broussard, LABuilt 2009 · S/N 760756N4514RArrow Aviation Company LLC · Broussard, LAS/N 760669N454WHGm Leasing Company LLC · Broussard, LABuilt 2010 · S/N 760802N468ZBBrown Helicopter Inc · Pensacola, FLBuilt 1988 · S/N 760345N473QHBrown Helicopter Inc · Pensacola, FLBuilt 1986 · S/N 760331
Back to AD 2017-19-01