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.

N601GS1 Trophy Husband LLC · Omaha, NEBuilt 2007 · S/N 184N603CNChickasaw Nation · Ada, OKBuilt 2016 · S/N 739N603GJRegistered aircraftBuilt 2004 · S/N 035N609CQFalki LLC · Winter Springs, FLBuilt 2012 · S/N 265N609GJBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 732N610GJDirect Ventures Management LLC · Knoxville, TNBuilt 2015 · S/N 731N610RLFalconrl LLC · Missoula, MTBuilt 1988 · S/N 68N611EPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 335N611TXMegaequipment LLC · Wilmington, NCBuilt 2005 · S/N 143N613BDLynx Medical Transport LLC · Cincinnati, OHBuilt 2004 · S/N 218N613BHBoz Holdings LLC · St Thomas, VIBuilt 2005 · S/N 159N613CSAvlease Company LLC · Ann Arbor, MIBuilt 2019 · S/N 354N615FJMegatel Group Services LLC · Dallas, TXS/N 102N615MSMss Falcon 900 LLC · Denver, COBuilt 2006 · S/N 160N617DVCae III Ltd · Wilmington, DEBuilt 1997 · S/N 20N61JEJce Leasing LLC · Little Rock, ARBuilt 1999 · S/N 72N620DXAdams Aviation Services Inc Trustee · Wilmington, DES/N 620N621HDXls Aviation LLC · Effingham, ILBuilt 2019 · S/N 747N622WMCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 147N623HDK & M Aviation Holdings I LLC · Hartville, OHBuilt 1996 · S/N 35N623RMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 53N626AWHfl Aviation LLC · Dallas, TXBuilt 2006 · S/N 168N627CRArrowhead Aviation Inc · Batesville, ARBuilt 1999 · S/N 048N627LGLive Mas Enterprises LLC · Greenwood Village, COBuilt 1995 · S/N 14N62LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 162N62NWE7 Alpha LLC · Austin, TXBuilt 2009 · S/N 233N630BANix Patterson Llp · Austin, TXBuilt 2013 · S/N 712N630VCAnanim LLC · Lincolnwood, ILBuilt 1998 · S/N 071N632PBModern Transportation Company Inc · Owensboro, KYBuilt 1995 · S/N 17N636SJHrm Aviation LLC · Chesterfield, MOS/N 104N639MWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 733N63FSIron Senergy Legacy LLC · Louisville, KYBuilt 2000 · S/N 132N63JPZap Magic LLC · New Castle, DEBuilt 2010 · S/N 249N640MSArtis 1 LLC · Miami, FLBuilt 2004 · S/N 31N644RVFrankcrum Corporate Inc · Clearwater, FLBuilt 1996 · S/N 22N649TTTownes Aircraft Sales LLC · Paris, TXBuilt 2005 · S/N 342N655TCTlc Aircraft Leasing LLC · Vero Beach, FLBuilt 2002 · S/N 195N659FMThayer Acquisitions LLC · Mclean, VABuilt 2004 · S/N 045N661MSLone Star Avalanche LLC · Marble Falls, TXBuilt 1987 · S/N 011N666TRDrt Falcon LLC · New York, NYBuilt 2014 · S/N 283N667HFBd Plane Inc · Chicago, ILBuilt 1987 · S/N 25N66FJAlpha Mike Aviation LLC · Murfreesboro, TNBuilt 2000 · S/N 66N66MDWorthida Co LLC · Palm Beach, FLBuilt 2007 · S/N 113N670JDAmber Services Inc · Chicago, ILBuilt 1988 · S/N 45N671HSEvans Aviation Holdings LLC · College Grove, TNBuilt 2002 · S/N 194N672WBRegistered aircraftN-number assigned (import), not yet registeredS/N 437N672WVWrbc Transportation Inc · Greenwich, CTBuilt 2014 · S/N 280N673HBSigma Equity LLC · San Francisco, CABuilt 2005 · S/N 153N675AZJetco LLC · Kalamazoo, MIBuilt 2012 · S/N 268N67AFAir4 Aviation LLC · Houston, TXBuilt 1997 · S/N 48
Back to AD 2016-19-13