AD 2016-15-05

Registered aircraft · 588

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-15-05')
    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-15-05')
  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.

N353BLBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 049N353WWBramac LLC · Denver, COBuilt 2012 · S/N 246N355MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 265N356LGRegistered aircraftBuilt 2009 · S/N 243N358DATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 003N35KVMit Oregon LLC · Portland, ORBuilt 2001 · S/N 083N360FCNbftm LLC · Saint Paul, MNBuilt 2004 · S/N 042N360GBHanging Valley Aviation LLC · Green Bay, WIBuilt 2025 · S/N 422N360MAir4 Aviation LLC · Houston, TXBuilt 2005 · S/N 68N361DDWeco West LLC · Catarina, TXBuilt 2000 · S/N 72N365AGAga Holdings LLC · Waterford, MIBuilt 2004 · S/N 50N365LTProductivity Advantage Inc · Mosinee, WIBuilt 2023 · S/N 405N370MHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 126N3712CF900ex LLC · Minneapolis, MNBuilt 1996 · S/N 04N372EXReal Estate Services International LLC · Conshohocken, PABuilt 2003 · S/N 12N373EFEmpirical Foods Inc · Dakota Dunes, SDBuilt 2014 · S/N 275N373RSKalamazoo Group II LLC · Kalamazoo, MIBuilt 2015 · S/N 291N374RVLmrv Falcon LLC · Phoenix, AZBuilt 2018 · S/N 745N375GKKs Air 3-7-12 V LLC · Charlotte, NCBuilt 2004 · S/N 46N376SFSmithfield Packaged Meats Corp · Smithfield, VABuilt 2009 · S/N 176N377AGCrest Operations LLC · Pineville, LABuilt 2004 · S/N 032N37DFWillamette Flight Management LLC · Mcminnville, ORBuilt 2004 · S/N 37N37EATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 58N38015Registered aircraftBuilt 2014 · S/N 718N380FJAviation Resource Group Inc · Fort Lauderdale, FLS/N 80N382KUMaverick Aire LLC · New Castle, COBuilt 1999 · S/N 47N387TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 018N388FJKey Corp · Cleveland, OHBuilt 2021 · S/N 388N38CPRegistered aircraftBuilt 2009 · S/N 208N39NPWilmington Trust Co Trustee · Wilmington, DEBuilt 1998 · S/N 39N400THDuke Vacation LLC · Wilmington, DEBuilt 2007 · S/N 612N401GJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 187N404FWcf Aircraft LLC · Detroit, MIBuilt 1999 · S/N 49N405DDillon Aviation LLC · Detroit, MIBuilt 2006 · S/N 101N405EKArlington Aircraft Of Nevada LLC · Sun Lakes, AZBuilt 2013 · S/N 277N408LSJokyal LLC · White Plains, NYBuilt 2008 · S/N 167N40LBFirst Premier Corp · Sioux Falls, SDBuilt 2013 · S/N 272N40NSf1 Holdings LLC · Darien, CTBuilt 2009 · S/N 195N412ECBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 144N413CGRegistered aircraftBuilt 2007 · S/N 124N416KCSpenaero Lc · Salt Lake City, UTBuilt 2007 · S/N 618N419DFSwitch Ltd · Las Vegas, NVBuilt 2024 · S/N 419N41MBRivers Equipment LLC · Nashville, TNBuilt 1998 · S/N 32N420PDKms Air LLC · West Bend, WIBuilt 2001 · S/N 84N421SCStryker Corp · Portage, MIBuilt 2016 · S/N 331N422FJHca Squared LLC · Nashville, TNBuilt 2025 · S/N 429N424UAeronavis LLC · Wilmington, DEBuilt 2002 · S/N 105N425RJFant Aircraft Enterprises LLC · Houston, TXBuilt 2014 · S/N 285N427MJ427mj LLC · Hazel Crest, ILBuilt 2013 · S/N 717N428DRMaverick Air II LLC · Deer Park, WABuilt 2005 · S/N 154
Back to AD 2016-15-05