OpenAirDocs.org
AD 2012-22-13

Registered aircraft · 101

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-22-13')
    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-22-13')
  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.

N121NCSun 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 760624N152AEMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 760714N155RRCas LLC · Longboat Key, FLBuilt 1996 · S/N 760464N16MQArrow Aviation Company LLC · Broussard, LAS/N 760626N176AMSpectrum Health Hospitals · Grand Rapids, MIBuilt 2007 · S/N 760665N176FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2007 · S/N 760646N2119AArrow Aviation Co LLC · Broussard, LAS/N 760640N2133XArrow Aviation Co LLC · Broussard, LAS/N 760638N25740Arrow Aviation Company LLC · Broussard, LAS/N 760732N26HFHeliflite Shares LLC · Kearny, NJBuilt 1998 · S/N 760488N276FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2000 · S/N 760509N276THHealth Care District Of Palm Beach County · West Palm Beach, FLBuilt 1999 · S/N 760494N278FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2008 · S/N 760750N30RTBank 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 760746N36HFHeliflite Shares LLC · Kearny, NJBuilt 2009 · S/N 760776N376WHGm 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 760802N478XWestwind Helicopters Inc · Santa Fe, TXS/N 760493N495RLSugar Pine Aviation LLC · Merlin, ORBuilt 2005 · S/N 760595N4989Arrow Aviation Company LLC · Broussard, LAS/N 760377N547WMBristow LLC · Lake Charles, LABuilt 2008 · S/N 760722N548GBAviation Instrument Services Inc · Miami, FLBuilt 1995 · S/N 760426N576DTArea 109 LLC · Brooklyn, NYBuilt 2001 · S/N 760514N614JCKnight Helo LLC · Wilmington, DES/N 760694N653LHBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 760420N664BCFlow Line Transportation LLC · Dallas, TXBuilt 1998 · S/N 760492N67MECas LLC · Longboat Key, FLBuilt 1997 · S/N 760469N707DSCas LLC · Longboat Key, FLBuilt 1997 · S/N 760471N709PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760716N709UCArrow Aviation Co LLC · Broussard, LAS/N 760631N711DSPentair LLC · Palmetto, FLBuilt 1997 · S/N 760473N718PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760686N725MFArrow Aviation Company LLC · Broussard, LABuilt 2002 · S/N 760532N725PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760692N72EHHelinet Aviation Services LLC · Van Nuys, CABuilt 2008 · S/N 760712N745PPhi Aviation LLC · Lafayette, LABuilt 2006 · S/N 760619N753PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760726
Back to AD 2012-22-13