OpenAirDocs.org
AD 2016-19-13

Registered aircraft · 960

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-19-13')
    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-19-13')
  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.

N90GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1987 · S/N 29N90HCFalcon Aviation LLC · Jupiter, FLS/N 208N90MCAirex 3 LLC · Romulus, MIBuilt 2015 · S/N 322N90THJ & J Capital Ventures LLC · Wilmington, DEBuilt 1999 · S/N 180N90YCAmerican Cruise Lines Inc · Guilford, CTBuilt 2010 · S/N 250N910NMTriangle Real Estate LLC · Saint Peters, MOS/N 95N910SCSunchasing LLC · Newark, DEBuilt 1994 · S/N 144N910TX900 Consulting LLC · Austin, TXBuilt 1998 · S/N 172N912BDBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 162N9147HLenox Aviation II LLC · Lawrenceville, NJBuilt 2013 · S/N 709N914LDSdl Management Company LLC · Santa Ana, CABuilt 2003 · S/N 25N914MCMountaire Corp · Little Rock, ARBuilt 2015 · S/N 310N914SSMeregrass Inc · Dublin, TXBuilt 2001 · S/N 188N914TV1365 Swan Ridge Road LLC · New York, NYBuilt 1987 · S/N 14N915FGFgf Sovereign LLC · Dallas, TXBuilt 2006 · S/N 107N915LGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 182N915TPGlobe Resources Group LLC · Wichita, KSBuilt 1992 · S/N 122N916KPKp Aviation Management LLC · Mather, CABuilt 2000 · S/N 301N917BCFlyaway Inc · Fort Worth, TXS/N 193N917JFAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1999 · S/N 179N918JM999 Aviation LLC · Northbrook, ILBuilt 2008 · S/N 199N918MJRegistered aircraftBuilt 2013 · S/N 270N918MVGuardian Aviation Services LLC · Short Hills, NJBuilt 1996 · S/N 156N919CHLeipold Aircraft LLC · Racine, WIS/N 205N919SACsc Delaware Trust Co Trustee · Wilmington, DES/N 124N919WTAir Waukegan LLC · Waukegan, ILBuilt 2001 · S/N 313N91MSLabbe LLC · Huntington Valley, PABuilt 1987 · S/N 10N920CERmhco LLC · Denver, COBuilt 2023 · S/N 399N920MDN920md LLC · Oklahoma City, OKBuilt 2000 · S/N 120N921TBBluemaxx Air LLC · Friendswood, TXS/N 85N923GGYia Falcon LLC · Coconut Grove, FLBuilt 2009 · S/N 201N923JEUnder Par LLC · Overland Park, KSBuilt 1999 · S/N 094N926JCJcd Leasing LLC · Orlando, FLBuilt 2000 · S/N 106N926JTVanderpenn LLC · Big Sky, MTBuilt 2014 · S/N 283N9273N2973 LLC · Wayzata, MNBuilt 2015 · S/N 317N927AACapital Holdings 238 LLC · Waco, TXBuilt 1999 · S/N 046N927BRFur Management & Consulting LLC · Junction, TXBuilt 2002 · S/N 196N928PWOld Harbour Aviation LLC · North Palm Beach, FLBuilt 2003 · S/N 13N928WKRegistered aircraftBuilt 2010 · S/N 183N92CJSkyview LLC · Wilmington, DEBuilt 1982 · S/N 092N935SFLujo Equipo LLC · Odessa, TXBuilt 2014 · S/N 290N940CLDfn26pa LLC · Plymouth, MABuilt 1998 · S/N 031N942SSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 622N943MRFrist Aviation LLC · Nashville, TNBuilt 2015 · S/N 295N946MMHeathrow Enterprises LLC · Orlando, FLBuilt 2006 · S/N 082N947DTTkr Aviation LLC · Ballwin, MOBuilt 1992 · S/N 117N94HARene Air Falcon LLC · Louisville, KYBuilt 2003 · S/N 02N950HIsland Aviation Inc · Houston, TXBuilt 2000 · S/N 307N950JBKlc 158 LLC · Dallas, TXBuilt 2005 · S/N 602N950RLR L R Investments LLC · Wilmington, OHBuilt 2005 · S/N 221
Back to AD 2016-19-13