OpenAirDocs.org
AD 2016-01-01

Registered aircraft · 412

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:2016-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:2016-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.

N382DMJpt United LLC · Adel, IABuilt 2014 · S/N 4697581N385KCChang Bill K · Friendswood, TXBuilt 2008 · S/N 4697385N388HPRk Enterprises Of Lake Mary LLC · Orlando, FLBuilt 2008 · S/N 4697388N388TWTl Lobo Group LLC · Rockwall, TXBuilt 2000 · S/N 4697018N391CCSimply Living LLC · Fort Myers, FLS/N 4697147N392MASch Aviation Inc · Sporle Kings LynnBuilt 2018 · S/N 4697642N395SMNortheastern Gastroenterology Associates Pa · Teaneck, NJBuilt 2002 · S/N 4697129N3CVMc Investment Services Inc · Inlet Beach, FLBuilt 2009 · S/N 4697409N406CDGold Sky LLC · Albuquerque, NMBuilt 2001 · S/N 4697046N40MAIndia Juliet Mike LLC · Youngsville, LABuilt 2008 · S/N 4697354N410HPS&W Air LLC · Santa Clara, CAS/N 4697413N411HBTex Richman Properties LLC · Little Falls, MNBuilt 2007 · S/N 4697303N411RSm1019 LLC · Polson, MTBuilt 2006 · S/N 4697241N415BCTeichroeb Jacob · Seminole, TXBuilt 2014 · S/N 4697552N4174VDalmore Estates LLC · Los Angeles, CABuilt 2000 · S/N 4697014N4180ARgb Air Services Inc · Corpus Christi, TXBuilt 2002 · S/N 4697151N4185LWdw Aviation Leasing Inc · Knoxville, TNBuilt 2000 · S/N 4697025N418HPPonashomu LLC · Reston, VABuilt 2009 · S/N 4697418N420PYQuantum Electrical Contractors Inc · Palm Coast, FLBuilt 2006 · S/N 4697265N424PMCdhnv LLC · Santa Fe Springs, CABuilt 2007 · S/N 4697288N424SGAt Holdco LLC · San Antonio, TXBuilt 2001 · S/N 4697039N42BGGtw Aviation LLC · San Jose, CABuilt 2008 · S/N 4697369N431PMAcadia Aviation LLC · Denver, COBuilt 2014 · S/N 4697557N433PJHotel Golf Aviation LLC · Brownfield, TXBuilt 2005 · S/N 4697198N43VMN43vm LLC · Fremont, CABuilt 2000 · S/N 46-97005N4429THeartland Air Leasing LLC · Coon Rapids, MNBuilt 2014 · S/N 4697571N444RRAccess Yacht Sales Inc · Norwalk, CTBuilt 2006 · S/N 4697278N446MARegistration Pending · New York, NYRegistration pendingBuilt 2025 · S/N 4697721N447CHBruce Alexander Company LLC · Elkhart, INS/N 4697374N450KMPa46 Capital LLC · Oakland, CABuilt 2008 · S/N 4697361N455LGBas Part Sales LLC · Greeley, COBuilt 2005 · S/N 4697203N455RSTfr Inc · Steamboat Springs, COBuilt 2005 · S/N 4697214N455SGDdog LLC · San Angelo, TXBuilt 2001 · S/N 4697096N460ABCrouse Aviation LLC · Napa, CABuilt 2010 · S/N 4697431N461BBFlite Level Zero LLC · Stanfield, ORBuilt 2000 · S/N 4697016N461JADesign Builds LLC · West Point, VABuilt 2003 · S/N 4697168N462MWest Bay Management LLC · Gardnerville, NVBuilt 2011 · S/N 4697462N462PJFacklair LLC · Granville, OHS/N 4697249N464CCrane Air LLC · Sheridan, WYBuilt 2009 · S/N 4697393N464HPOrion Aviation LLC · Boise, IDBuilt 2006 · S/N 4697254N464PATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 4697451N464RTThekkath Chandramohan · Palo Alto, CABuilt 2001 · S/N 4697058N465MENorthlake Capital LLC · Ridgeland, MSBuilt 2005 · S/N 4697233N465SKAv8 LLC · Paso Robles, CABuilt 2000 · S/N 4697013N465TPMountain Holding Inc · Cody, WYBuilt 2005 · S/N 4697204N466ABSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 4697105N466CPRedman Company LLC · Troy, MIBuilt 2009 · S/N 4697419N469SBK-Town Aviation LLC · Louisville, TNBuilt 2003 · S/N 4697162N46GRGr Partners LLC · Bow, WABuilt 2006 · S/N 4697270N46MEFishlover'S Management LLC · Chandler, AZBuilt 2005 · S/N 4697207
Back to AD 2016-01-01