OpenAirDocs.org
AD 2011-27-01

Registered aircraft · 49

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:2011-27-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:2011-27-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.

N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039N111LNC Lou Leasing LLC · Mankato, MNBuilt 1984 · S/N 1602N114MXAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1984 · S/N 1747N11QDMansfield Heliflight Inc · Milton, VTBuilt 2001 · S/N 3363N130PFOrlando Helicopter Partners LLC · Orlando, FLBuilt 2009 · S/N 4760N135TGAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0298N145GRegistered aircraftBuilt 2015 · S/N 20044N153AEPhi Health LLC · Tempe, AZBuilt 2004 · S/N 3829N187AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3846N234BUHeli-USA Corp · Houston, TXS/N 1210N273AMAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0273N27WAWings Air Helicopters LLC · West Harrison, NYBuilt 1994 · S/N 2792N30EZHover Air LLC · Anchorage, AKBuilt 2011 · S/N 7285N345HEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 1357N350MPCity Of Memphis Police Department · Memphis, TNBuilt 2004 · S/N 3783N351HDT Scott Dunn Construction Inc · Phoenix, ORBuilt 2001 · S/N 3508N352PAPathfinder Leasing LLC · Anchorage, AKBuilt 2000 · S/N 3378N352RNs Air Leasing LLC · Wilmington, DEBuilt 2002 · S/N 3664N352VHElt Holdings LLC · Cottonwood, AZBuilt 1985 · S/N 1838N353PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3722N354PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3690N357PAPathfinder Leasing LLC · Anchorage, AKBuilt 2003 · S/N 3675N358TVTiny Bubbles Aviation Inc · Pacoima, CABuilt 2004 · S/N 3788N375AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20227N376AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20239N387AK387ak LLC · Anchorage, AKS/N 3730N401MFDare County · Manteo, NCBuilt 2015 · S/N 20024N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615N498AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3687N5805TStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N 1836N585AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3736N590AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3733N596WAFleet Unlimited Inc · Pasadena, CABuilt 1990 · S/N 2329N611TCAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1988 · S/N 2123N6UXHelicopters Inc · Cahokia, ILBuilt 2003 · S/N 3749N744HDU S Helicopters Inc · Marshville, NCBuilt 1981 · S/N 1449N804PAPathfinder Leasing LLC · Anchorage, AKBuilt 2004 · S/N 3782N827NARoberts Aircraft LLC · Cheyenne, WYBuilt 1998 · S/N 3144N888HVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1990 · S/N 2386N888TVU S Helicopters Inc · Marshville, NCBuilt 1978 · S/N 2007N90DKDekalb County Police · Tucker, GABuilt 2004 · S/N 3807N919SFAir Er LLC · Corinth, TXBuilt 1991 · S/N 760370N927LBElt Holdings LLC · Cottonwood, AZBuilt 1990 · S/N 2347N929WBAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1990 · S/N 2335N945DCJs Leasing LLC · Frisco, TXBuilt 2015 · S/N 20059N963ESFast Helicopters Inc Trustee · Wilmington, DEBuilt 1979 · S/N 1089N970AEPhi Health LLC · Tempe, AZBuilt 1999 · S/N 3235N979CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 20161N99523Ns Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3461
Back to AD 2011-27-01