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.

N8973WPlasek Christopher · Owatonna, MNBuilt 1966 · S/N 28-10810N8973YAire Ryder LLC · Roseville, MNS/N 39-139N89743Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15282850N8974P4papa LLC · Gig Harbor, WABuilt 1966 · S/N 24-4432N8974WRassmussen Troy · Fayetteville, NCBuilt 1966 · S/N 28-10811N89753Aerohead Planes LLC · Savannah, GAS/N 15282853N8975VMauser James E · Zionsville, PABuilt 1974 · S/N 17264331N8976Bouchard Paul Marcel · Yellville, ARBuilt 1998 · S/N 3318N89764South Aero LLC · Albuquerque, NMS/N 15282857N8976CPetruso Rosemary D Co-Trustee · Saint Louis, MOBuilt 1953 · S/N 22-1554N8976DWilliams Aircraft LLC · Anchorage, AKBuilt 1956 · S/N 18-4887N8976JGreat Plains Aviation LLC · Lincoln, NEBuilt 1966 · S/N 28-2999N8976YAfricano Aircraft Management LLC DBA · Chicago, ILS/N 39-142N89770Seals Richard W · Torrance, CAS/N 15282860N8977DWilliams Aircraft LLC · Anchorage, AKBuilt 1956 · S/N 18-5083N8977JJohnson Bradley F · West Babylon, NYBuilt 1966 · S/N 28-3000N8977LSarigul Klijn Nesnn · Dixon, CABuilt 1974 · S/N AA1B-0427N8977RCozine Mark R · Cherokee, IABuilt 1960 · S/N 7KC-1N8977WRice Elden · Black Hawk, SDBuilt 1965 · S/N 28-10555N89780Huffman Jacob M III · Burleson, TXBuilt 1978 · S/N 15282865N8978CMenke Clint A · Cozad, NEBuilt 1953 · S/N 22-1558N8978DShuman Cecil R Trustee · Chugiak, AKBuilt 1958 · S/N 18-6418N8979DBurnett Kris W · Anchorage, AKBuilt 1975 · S/N 18-7509053N8979MBean George W Jr · Fort Worth, TXBuilt 1964 · S/N TD-564N8979PShortridge Mary E · Bennet, NEBuilt 1966 · S/N 24-4438N8979RSeeley Lenard D · Osage, WYBuilt 1960 · S/N 13N8979VAvel Aircraft Inc · West Chicago, ILBuilt 1974 · S/N 17264335N897ALJansky Sand & Gravel Inc · Hallettsville, TXBuilt 1973 · S/N 28R-7335331N897ATCxk1 LLC · Wilmington, DEBuilt 2026 · S/N 4496628N897CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282395N897DCRed Baron LLC · Middletown, DES/N 20012CN897DSHolliday Richard A · Fort Worth, TXBuilt 1996 · S/N 1928N897ECMatacia Thomas Eugene · Evergreen, NCBuilt 1969 · S/N 28R-35376N897EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12689N897GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881072N897GAPruim Bradley · Dorr, MIBuilt 1991 · S/N 10076N897HParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020244N897JSMurray James P · Parrish, FLBuilt 2004 · S/N 90430N897JWAmh Properties LLC · Auburn, ALFirst renewal noticeBuilt 2011 · S/N 2843698N897MGlenn David H · Big Lake, AKBuilt 1989 · S/N 4064CN897MAPate Jimmy B · Fredericksburg, TXBuilt 1997 · S/N 3246083N897MBJts Aircraft LLC · Rock Hill, SCBuilt 1966 · S/N 28-21978N897NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496604N897RVPorter David T · Martinsburg, WVBuilt 2017 · S/N 74311N897SCPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 2881801N897SMDomich Jeffrey E · Petaluma, CABuilt 2011 · S/N 18282309N89800Ballesteros Irlena · Glendale, CAS/N 15282872N8980RHolmes Aviation Inc · Cannon Falls, MNBuilt 1960 · S/N 7GCB-14N8980VSweitz-Air Inc · Stewartstown, PAS/N 17264336N8980WAddis Timothy David · Mount Vernon, OHBuilt 1965 · S/N 28-10559
Back to AD 81-18-04 R2