AD 81-18-04 R2

Registered aircraft · 81,733

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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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.

N9159VSmith Darryl Edward · Houston, TXS/N 690033N9159WDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 28-10778N915AJb Efta Farms Inc · Argyle, MNFirst renewal noticeBuilt 1951 · S/N 22-218N915AAHoecher Robert T · Anchorage, AKFirst renewal noticeBuilt 1977 · S/N 15280359N915AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13546N915AZN915az LLC · Miami, FLBuilt 1974 · S/N 34-7450199N915CMVaayu Aviation LLC · Newark, CABuilt 1972 · S/N 17261229N915CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8335N915DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12071N915DDWest Michigan Aviation Academy · Grand Rapids, MIBuilt 1999 · S/N 172S8149N915GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881073N915GWWills Gary W · Channahon, ILBuilt 2012 · S/N 71267N915HPAnderson Austin C · Washington, DCBuilt 1966 · S/N 24-4371N915JBKruger Karl A · Monterey, TNBuilt 2018 · S/N 73660N915JCCannata Jack P · Roselle, ILBuilt 2000 · S/N 14674N915JDDowling Jeffrey T · Poplar Grove, ILBuilt 2003 · S/N 20098N915KKKramer Kurt J · Volcano, CABuilt 2022 · S/N 25744N915LCardinal Flying Corp · San Jose, CABuilt 1976 · S/N 17267355N915LFLingo Joshua B · Oak Grove, LABuilt 1998 · S/N 390-98N915LSBlack Bear Aviation LLC · Camden, DEBuilt 2023 · S/N 18283235N915MBBarras David G · Breaux Bridge, LABuilt 2004 · S/N 1N915NCMiller Nevin D · Naples, IDBuilt 2009 · S/N 91522N915PSmith Jr Franklin R · Rock Hill, SCBuilt 2012 · S/N 90856N915PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843304N915PBLease Lawrence · Royal Oaks, CABuilt 2010 · S/N 91523N915RDDavis Richard L · Kenai, AKBuilt 2007 · S/N 122284N915RSHayward Houston C · Lansdale, PABuilt 1999 · S/N 1260-99N915RVWiegand Jeffrey L · Ocean Isle Beach, NCBuilt 1999 · S/N 22356RV6N915TAAurora Aircraft LLC · Waterford, MIBuilt 2006 · S/N 172S10358N915TTLake Elmo Aero LLC · Lake Elmo, MNBuilt 1977 · S/N 28-7890158N915WBBordelon Warren P · Breaux Bridge, LABuilt 1972 · S/N 17261221N915WMChambers David N · Cullman, ALBuilt 1976 · S/N 28-7310107N915WVSmith Aviation LLC · Springer, OKBuilt 1959 · S/N TD-236N9160DMalsby Thomas H · Blairsville, GABuilt 1958 · S/N 22-6212N9160HTodd Media Inc · Tuscaloosa, ALBuilt 1975 · S/N 17265984N9160JMohan Aditya · Rancho Cordova, CAS/N 28-3218N9160VLangis Maximus · Newburyport, MABuilt 1969 · S/N 690029N9160WAmerican Aviator LLC · Arlington, TXBuilt 1966 · S/N 28-10779N9161FHuie John E · Burnet, TXBuilt 2002 · S/N 001N9161HAir Athens LLC · Athens, GABuilt 1975 · S/N 17265985N9161JNortheast Nebraska Aviators Inc · Wayne, NEBuilt 1966 · S/N 28-3220N9161SCarr Jack Willson · East Lansing, MIBuilt 1975 · S/N MB-785N9161TMenagerie Enterprises Inc DBA · Denison, TXBuilt 2011 · S/N 172S11093N9161VKaroki Jonah · Strasburg, COBuilt 1969 · S/N 690034N91622Utterback Karl D · Fort Wayne, INBuilt 2002 · S/N M-II-1820N9162HStratus Aviation LLC DBA · Vacaville, CABuilt 1975 · S/N 17265986N9162JHillelson Lawrence E · Grosse Ile, MIBuilt 1966 · S/N 28-3221N9162NMann Aviation LLC · Wilmington, DEBuilt 1998 · S/N 24-3421N9162WYanka Anthony Joseph · Moorestown, NJBuilt 1968 · S/N 28-11096N91631Seale Taylor Edward · Madison, WIBuilt 1993 · S/N 2890177
Back to AD 81-18-04 R2