AD 2014-18-01

Registered aircraft · 5,009

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:2014-18-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:2014-18-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.

N105GPP-1048 LLC · Nashville, TNS/N 1048N105SLSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 2003 · S/N 1068N105TDJcd-Gp LLC · Center, TXBuilt 2002 · S/N 560-0632N106CJCitation 525 Inc · Eugene, ORBuilt 1993 · S/N 525-0006N106CKBlt Net Charter Inc · Stamford, CTBuilt 2008 · S/N 214N106EXChefs Warehouse Transportation LLC · Ridgefield, CTBuilt 2002 · S/N 106N106JTMountain Air Charter LLC · Dallas, TXBuilt 2006 · S/N 525B0106N106MJAngstrom Aviation LLC · Southfield, MIBuilt 2015 · S/N 525-0897N106VPTeam Aero LLC · Shawnee, KSBuilt 2002 · S/N 560-0628N107GLLeep Enterprises LLC · Mishawaka, INBuilt 2002 · S/N 199N107JGGrundy Aviation LLC · Horsham, PABuilt 2019 · S/N 525-1020N107PTPapa Tango LLC · Petaluma, CABuilt 2006 · S/N 525B0127N107RGFalcon 2000ex Msn 157 Leasing LLC · West Harrison, NYBuilt 2008 · S/N 157N107SLSouthwest Aviation Specialties LLC · Tulsa, OKFirst renewal noticeBuilt 2003 · S/N 1073N1088Fmc Corp · Philadelphia, PABuilt 2009 · S/N 5798N1088RHampton Railway LLC · Eugene, ORBuilt 2013 · S/N 560-6156N108BKKent Aviation LLC · Midland, TXBuilt 2001 · S/N 305N108ELucky Stars LLC · Missoula, MTBuilt 2015 · S/N 525B0476N108FJBuffalo Valley Ventures Of Tn LLC · Cookeville, TNBuilt 1991 · S/N 108N108HPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 525-1422N108KJRab Aviation LLC · Tulsa, OKS/N 525A0416N108LAPrice Services Inc · Monticello, ARBuilt 2007 · S/N 525B0176N108PHYoung Family Aviation LLC · Sugar Grove, ILBuilt 1990 · S/N 87N108VRDraughn Aviation LLC · Salado, TXBuilt 2002 · S/N 560-0601N1099Carolina View Aviation LLC · Greensboro, NCBuilt 2019 · S/N 525-1028N109APCj2 131 LLC · Milwaukee, WIBuilt 2002 · S/N 525A0131N109MSCavallino Rampante Inc · Dover, DEBuilt 1991 · S/N 1008N109TWLegacy Jets LLC · Wilmington, DEBuilt 2010 · S/N 525B0338N10DQTextron Aviation Inc · Wichita, KSS/N 525-1426N10KJKtkj Challenger LLC · Houston, TXBuilt 2020 · S/N 6155N10LCRegistered aircraftBuilt 2008 · S/N 155N10MAlset Holding Co LLC · Charlotte, NCBuilt 2009 · S/N 220N10MDMiss Blackwell Aviation LLC · Pawleys Island, SCBuilt 2017 · S/N 525-0967N10MMSarma Aviation LLC · Fort Wayne, INBuilt 1988 · S/N 5033N10PFAqua Lift LLC · Key Largo, FLBuilt 2003 · S/N 525A0165N10PHBlue Sky Harbour LLC · Hummelstown, PABuilt 2013 · S/N 560-6142N10QS25p150c LLC · Oklahoma City, OKBuilt 2026 · S/N 560-6507N10TDPrairie Air LLC · Aberdeen, SDBuilt 1991 · S/N 560-0096N10TRNtr Aviation LLC · Dallas, TXBuilt 2011 · S/N 525B0354N10UTOut Aviation LLC · Fort Wayne, INBuilt 2008 · S/N 525A0407N10XBmd Leasing LLC · Portland, ORBuilt 2001 · S/N 190N1101AHeritage Aviation Services LLC · Dallas, TXBuilt 1997 · S/N 5354N110ABTbf Group Aviation LLC · Great Neck, NYBuilt 2000 · S/N 125N110CPPruitt Corp · Leesburg, VABuilt 2024 · S/N 6211N110DTTillman Self Storage Inc · Wilmington, DEBuilt 2001 · S/N 560-5145N110EXKm 900 LLC · Chesterfield, MOBuilt 2000 · S/N 71N110FDYellowstone Leasing LLC · Pray, MTBuilt 2006 · S/N 525A0308N110RFGyansys Equipment LLC · Carmel, INBuilt 2022 · S/N 525B0682N1111SStockbridge General Contracting Inc · Clovis, CABuilt 2022 · S/N 525-1111N111CCWilmington Trust Co Trustee · Wilmington, DEBuilt 1996 · S/N 5192
Back to AD 2014-18-01