OpenAirDocs.org
AD 2016-18-05

Registered aircraft · 1,378

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

N100JADolce Vita Assets LLC · Saint Petersburg, FLBuilt 2007 · S/N 865N100YCFirst View Aviation LLC · Burlington, COBuilt 1999 · S/N 281N101JEJeva Air Corp · Plantation, FLBuilt 2004 · S/N 569N101LRegistered aircraftBuilt 2023 · S/N 2302N101PKMassey Air Inc · Lucdale, MSBuilt 2016 · S/N 1610N102TP2 T Partnership Ltd · Pecos, TXBuilt 2025 · S/N 2439N104SCLsac Enterprises LLC · Marshalltown, IABuilt 2020 · S/N 2032N1056BCorral Ventures LLC · Atlantic Beach, FLBuilt 2003 · S/N 499N106TWTw Leasing LLC · Oxford, CTS/N 1109N107HMSterling Air Service LLC · Corpus Christi, TXBuilt 1999 · S/N 248N108JCR J Young Co · Nashville, TNBuilt 2008 · S/N 883N10DFGulf States Toyota Inc · Houston, TXS/N 1241N10FBRad Runner LLC · Newton, NCBuilt 2006 · S/N 748N10WAReinbeck Motors Co Inc · Reinbeck, IABuilt 2022 · S/N 2187N110GNWell Adjusted LLC · Naples, FLBuilt 2013 · S/N 1404N110GWGew Aircraft Leasing LLC · Naples, FLBuilt 2013 · S/N 2457N111WGAhuva LLC · Port Alsworth, AKBuilt 2004 · S/N 555N112VFVictor Foxtrot LLC · Scott City, KSBuilt 2008 · S/N 882N1130DDevonair Enterprises LLC · Rockford, MIBuilt 2007 · S/N 823N113BDBlack Dog Leasing LLC · Gardnerville, NVBuilt 2024 · S/N 2414N1150HLbj Air LLC · Helena, MTBuilt 2009 · S/N 1150N1150NBlack Falcon Leasing LLC · Gallatin, TNBuilt 2009 · S/N 1156N116SKAir Methods LLC · Greenwood Village, COBuilt 1995 · S/N 116N11898Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 456N118APRoadkill Aviation LLC · Indianapolis, INBuilt 1997 · S/N 175N118NGAvodah Blue LLC · Logan, UTBuilt 2018 · S/N 1833N119QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 119N119UTUnited Therapeutics Corp · Silver Spring, MDBuilt 2015 · S/N 1520N11AGDg + Ag LLC · Albuquerque, NMBuilt 2000 · S/N 343N11BYRj Aviation LLC · Ronkonkoma, NYBuilt 2023 · S/N 2295N11NXDiscovery Associates Inc · Midland, TXBuilt 2020 · S/N 2010N11NYKup Air LLC · Mccook, NEBuilt 2016 · S/N 1647N120AHWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 1582N120QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 120N120WLN120wl LLC · Del Mar, CABuilt 2024 · S/N 2418N1211AStar Child 3 LLC · Sanibel, FLBuilt 2005 · S/N 663N121QIq Worldwide Solutions LLC · Tampa, FLBuilt 2011 · S/N 1299N1220ARivers End Ranch LLC · Lakeview, ORBuilt 2015 · S/N 1568N1227QFly Signature LLC · Newark, DEBuilt 2023 · S/N 2324N122GXFlan Air LLC · Flandreau, SDBuilt 2020 · S/N 2020N122JMBuessli Aviation LLC · Menlo Park, CABuilt 2015 · S/N 1523N122NDAircraft Fidelity Corp Trustee · Dover, DEBuilt 2009 · S/N 1146N123CFPc-12 Aircraft LLC · Sanford, FLS/N 286N123NXHeimdal Aviation LLC · Seattle, WABuilt 2009 · S/N 1123N123SLSo Lucky One LLC · Wilmington, NCBuilt 2015 · S/N 1573N1245XKalinin Partners LLC · Juneau, AKBuilt 2003 · S/N 496N1247EBozeman Technology Incubator Inc · Bozeman, MTBuilt 2017 · S/N 1762N124LTTurner Lyle C Trustee · Santa Barbara, CABuilt 2019 · S/N 1889N124N124 North LLC · Laguna Beach, CAS/N 2072N124PSDuck Pond Aviation II LLC · Livermore, CABuilt 2018 · S/N 1811
Back to AD 2016-18-05