OpenAirDocs.org
AD 2011-01-01

Registered aircraft · 48

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-01-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-01-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.

N106ECAurogold Aviation Inc Trustee · Wilmington, DEBuilt 2009 · S/N 14501106N10HCKba LLC · Dover, DEBuilt 2008 · S/N 14501080N135SCBallator Equipment Leasing LLC · Beech Mountain, NCBuilt 2006 · S/N 14500972N135SGValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 145706N135SKZed Aerocapital LLC · Dover, DEBuilt 2007 · S/N 14500989N135SLZed Aerocapital LLC · Dover, DEBuilt 2003 · S/N 145711N145DBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 14501045N157MGValiair Lc Trustee · Casper, WYBuilt 2007 · S/N 14500999N224LDCloud Enterprise Holdings LLC · Roslyn Heights, NYBuilt 2006 · S/N 14500971N305TKFat Cloud Aviation LLC · Miami, FLBuilt 2006 · S/N 14500950N317PJCl30 LLC · Bethany, OKBuilt 2007 · S/N 14501007N32SFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 14501060N333BHBlh Flight LLC · Las Vegas, NVBuilt 2013 · S/N 14501167N470DCRance King Properties Inc · Long Beach, CABuilt 2006 · S/N 14500946N484WM484wm LLC · Bend, ORBuilt 2008 · S/N 14501058N494TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 145678N529GBBmh Air LLC · Fredericksburg, TXBuilt 2007 · S/N 14500994N600WBBd Advisors LLC · Beaumont, TXBuilt 2008 · S/N 14501032N605WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 14500980N611BVD&B Truck & Trailer Services LLC · Nashville, TNBuilt 2002 · S/N 145-637N642TKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2002 · S/N 145642N645PMPag Management LLC · White Plains, NYBuilt 2006 · S/N 14500974N650JFWasatch Aviation Group Six LLC · Sandy, UTBuilt 2015 · S/N 14501215N650LYValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 14500825N650MLValiair Lc Trustee · Casper, WYS/N 14500967N650RJTvpx Aircraft Solutions Inc Trustee · Salt Lake City, UTBuilt 2013 · S/N 14501174N650TBBorland Caryn H Trustee · Prescott, AZBuilt 2017 · S/N 14501204N661ECPalu Aviation LLC · Oklahoma City, OKBuilt 2007 · S/N 14501001N661JMSas Aviation Holdings LLC · Scottsdale, AZBuilt 2003 · S/N 145730N6GDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 14500983N700LZRegistered aircraftN-number assigned (import), not yet registeredS/N 14500952N725BDBdg Aircharter Inc · Syosset, NYBuilt 2008 · S/N 14501034N728PH728 Services LLC · New York, NYBuilt 2007 · S/N 14500985N742SPOur Plane LLC · Kingwood, TXBuilt 2011 · S/N 14501122N752SPPrincipal Aviation Partners LLC · Camden, DEBuilt 2005 · S/N 14500903N7965MChasing The Sun LLC · Bronx, NYBuilt 2012 · S/N 14501164N809TDAero Aircraft Holdings II LLC · Van Nuys, CABuilt 2004 · S/N 14500809N818HRHr Inv LLC · Omaha, NEBuilt 2009 · S/N 14501105N8587HUp Management LLC · Rock Island, ILS/N 14501175N877SVBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 145789N882ACBd Advisors LLC · Beaumont, TXBuilt 2004 · S/N 145770N888ATAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2004 · S/N 14500802N88MFDmjg Holdings LLC · Wallace, NCBuilt 2010 · S/N 14501117N900EMEwm Investments LLC · Las Vegas, NVBuilt 2006 · S/N 14500976N904FLFlight Options LLC · Cleveland, OHS/N 145780N905FLFlight Options LLC · Cleveland, OHS/N 145775N909TTTranscon International Inc · Wilmington, DEBuilt 2008 · S/N 14501044N939AJContinental 678 Fund LLC · Leesburg, VABuilt 2005 · S/N 14500939
Back to AD 2011-01-01