OpenAirDocs.org
AD 2010-19-06 R1

Registered aircraft · 214

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:2010-19-06-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:2010-19-06-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 9039N108TABristow LLC · Lake Charles, LABuilt 1998 · S/N 3080N111LNC 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 7464N11QDMansfield Heliflight Inc · Milton, VTBuilt 2001 · S/N 3363N1231ATiny 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 3904N12FQN12fq 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 4443N130PFOrlando Helicopter Partners LLC · Orlando, FLBuilt 2009 · S/N 4760N134TVNexstar Broadcasting Inc · Albuquerque, NMBuilt 2007 · S/N 4291N135MCWings Up IV LLC · Allen Park, MIBuilt 2004 · S/N 3826N135TGAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0298N141THTemsco Helicopters Inc · Ketchikan, AKBuilt 1979 · S/N 1167N143GKN143gk LLC · Sheridan, WYBuilt 2002 · S/N 3606N143THTemsco Helicopters Inc · Ketchikan, AKBuilt 2002 · S/N 9043N145GRegistered aircraftBuilt 2015 · S/N 20044N145KKato Aviation LLC · Henderson, MNBuilt 1979 · S/N 1157N145THTemsco Helicopters Inc · Ketchikan, AKBuilt 2003 · S/N 9060N146THTemsco Helicopters Inc · Ketchikan, AKBuilt 2004 · S/N 9065N147THTemsco Helicopters Inc · Ketchikan, AKBuilt 2005 · S/N 9070N148THTemsco Helicopters Inc · Ketchikan, AKBuilt 2008 · S/N 4623N149THTemsco Helicopters Inc · Ketchikan, AKBuilt 2005 · S/N 9071N153AEPhi Health LLC · Tempe, AZBuilt 2004 · S/N 3829N15NSChopper 3 LLC · Dover, DEBuilt 1997 · S/N 3014N187AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3846N1SDPinellas County Sheriffs Office · Clearwater, FLBuilt 2015 · S/N 8024N203CHCoastal Helicopters Inc · Juneau, AKBuilt 1981 · S/N 1430N2127SEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 1989 · S/N 2213N214GHCobalt Holdings Inc · Pacoima, CABuilt 1991 · S/N 2537N216CHCoastal Helicopters Inc · Juneau, AKBuilt 2002 · S/N 3619N216EHBristow LLC · Lake Charles, LABuilt 1999 · S/N 3184N217FDBristow LLC · Lake Charles, LABuilt 2007 · S/N 4221N226PDAnaheim Police Dept · Fullerton, CABuilt 2004 · S/N 3879N234BUHeli-USA Corp · Houston, TXS/N 1210N244TXBrenthel Industries LLC · Helena, MTBuilt 2008 · S/N 4408N249GSPau Hana Enterprises LLC Series III · Las Vegas, NVBuilt 1988 · S/N 2167N251HIsland Helicopters Kauai Inc · Lihue, HIBuilt 2005 · S/N 3975N261AWAll Wool Aviation LLC · Coral Gables, FLBuilt 2014 · S/N 7869N273AMAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0273N27WAWings Air Helicopters LLC · West Harrison, NYBuilt 1994 · S/N 2792N282SArrow Aviation Company LLC · Broussard, LABuilt 1985 · S/N 760282N28LBCity Of Long Beach · Long Beach, CABuilt 2003 · S/N 3757N296PDCity Of Philadelphia · Philadelphia, PABuilt 2013 · S/N 7705N297PDCity Of Philadelphia · Philadelphia, PABuilt 2014 · S/N 7810
Back to AD 2010-19-06 R1