OpenAirDocs.org
AD 2009-08-08 R1

Registered aircraft · 504

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

N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039N104LNPathfinder Leasing LLC · Anchorage, AKBuilt 2006 · S/N 4094N108TABristow LLC · Lake Charles, LABuilt 1998 · S/N 3080N109LNAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3995N111LNC Lou Leasing LLC · Mankato, MNBuilt 1984 · S/N 1602N114MXAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1984 · S/N 1747N117TVU S Helicopters Inc · Marshville, NCBuilt 2012 · S/N 7464N118LNAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4214N118MBMountain Air Helicopters Inc · Dover, DEBuilt 2002 · S/N 3535N11QANevada Helicopter Leasing LLC · Greenwoodvillage, COBuilt 2004 · S/N 3887N11QCNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2001 · S/N 3358N11QDMansfield Heliflight Inc · Milton, VTBuilt 2001 · S/N 3363N11QENevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2001 · S/N 3381N11QFNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 3482N11QHNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 3561N11QJNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2008 · S/N 4528N11QKNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 3639N11QLNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2003 · S/N 3738N11QMNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2003 · S/N 3751N11QNNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2003 · S/N 3758N11QPNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2009 · S/N 4715N11QRNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2005 · S/N 3992N11QUNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2009 · S/N 4758N11QWNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2010 · S/N 4929N11QXNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2011 · S/N 7198N11QYNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2011 · S/N 7229N11QZNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2008 · S/N 4663N1231ATiny Bubbles Aviation Inc · Pacoima, CABuilt 2003 · S/N 3682N124LNAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4130N124TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4405N125HDUS Helicopters Inc · Marshville, NCBuilt 2014 · S/N 7899N125SCStandard Aero (Alliance) Inc · Maryville, TNBuilt 2005 · S/N 3904N126PJHelibro LLC · Red Bluff, CABuilt 2010 · S/N 7039N127PJHelibro LLC · Red Bluff, CABuilt 2011 · S/N 7180N12FQN12fq LLC · Helena, MTBuilt 2003 · S/N 3726N12NNAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2008 · S/N 4579N12YJTiny Bubbles Aviation Inc · Pacoima, CABuilt 2008 · S/N 4443N130BUOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7132N130CLOhio Medical Transportation Inc · Columbus, OHBuilt 2012 · S/N 7499N130CRRomana Aircraft Inc · High Point, NCBuilt 2007 · S/N 4271N130CZOrbic Air LLC · Burbank, CABuilt 2006 · S/N 4060N130EEBuckeye Leasing LLC · Shreveport, LABuilt 2011 · S/N 7190N130GCMonarch Enterprises Inc · Kirkland, WABuilt 2002 · S/N 3562N130GMBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4837N130HBOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7167N130JVOhio Medical Transportation Inc · Columbus, OHBuilt 2012 · S/N 7490N130KHOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7142N130KJJackson Family Wines Inc · Santa Rosa, CABuilt 2004 · S/N 3873N130KRAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7317N130LHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 4017
Back to AD 2009-08-08 R1