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.

N8839YMcguinness William V IV · Houston, TXBuilt 1969 · S/N 39-2N883ACPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 28R-7535156N883ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496320N883CFolkers Daniel E · Norwalk, IABuilt 1973 · S/N 28-7325345N883CGBrock Gary G · Roseboro, NCBuilt 2008 · S/N 90904N883CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282200N883DFAerial Ag Services LLC · Hillsboro, TXBuilt 2006 · S/N 11212N883EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13529N883JJJaffe Jordan E · Horseshoe Bay, TXBuilt 2003 · S/N 910-2003N883MMoffett James D · North East, MDBuilt 1969 · S/N 28-26047N883RVMann Allen W Trustee · Post Falls, IDBuilt 1993 · S/N 21677N883TCCoughlin Brian T · Cazenovia, NYBuilt 2023 · S/N 001N883TTRoser John E · Lake St Louis, MOBuilt 2003 · S/N 60576N88401Kimball Clayton Scott · Richland, WABuilt 1974 · S/N 122-75N88405Mulhern Georgia · Waddell, AZS/N 784-75N88408Steel Mimi · Caldwell, IDBuilt 1974 · S/N 1062-75N8840FPinchorski Ronald G · Wiconisco, PABuilt 1963 · S/N 33-0185N8840NBouillon Gloria J · Somerville, MABuilt 1969 · S/N 28-25691N8840WLee Ronald A · Bend, ORBuilt 1964 · S/N 28-10389N88412Rider Shawna · Anchorage, AKS/N 779-75N88417Alaska Department Of Fish And Game · Fairbanks, AKS/N 123-75N8841JE & G Flying Club LLC · Alliance, OHBuilt 1965 · S/N 28-2798N8841WRegistration Pending · Dilley, TXRegistration pendingBuilt 1964 · S/N 28-10390N8841YHoffman Avery E · Bethel, AKBuilt 1973 · S/N 18-7309025N88421Dular Emil M · Elizabethtown, KYBuilt 1974 · S/N 785-75N88424Iowa Aerial Advertising LLC · Perry, IAS/N 305-75N88425Klamar Spraying Inc · Gatzke, MNBuilt 1974 · S/N 786-75N88428Mason Fred B · Waterford, OHBuilt 1974 · S/N 162-75N8842CTerry Jay F · Rome City, INBuilt 1953 · S/N 22-1455N8842DVan Bergeyk Ronald J · Trapper Creek, AKBuilt 1958 · S/N 22-6012N8842JCrowe Steven A · Bend, ORBuilt 1965 · S/N 28-2799N8842WMott Terry W · Hampton, IABuilt 1964 · S/N 28-10392N8842YQuest Aviation Inc · Houlton, MEBuilt 1969 · S/N 30-2000N88437Vst Aviation LLC · Ball Ground, GABuilt 1974 · S/N 490-75N8843JDiorio Christopher J · Melba, IDS/N 28-2801N8843LPolries Larry J · Jamestown, NDS/N 25-5354N8843WDay Eric N · Weatherford, TXBuilt 1964 · S/N 28-10393N8843YBw Aviation LLC · Wilmington, DES/N 32R-8013061N88443Jkt LLC · Douglas, WYBuilt 1974 · S/N 130-75N88446Gall Peter D · Morgantown, WVS/N 1064-75N8844JCave Anthony B · Round Rock, TXBuilt 1965 · S/N 28-2802N8844NBruegmann Fred R III · Northfield, ILBuilt 1969 · S/N 28-25695N8844YStreater Aviation LLC · Weirsdale, FLBuilt 1969 · S/N 39-3N8845Rudloff Uwe K · Lake Village, INBuilt 1973 · S/N 365-73N88451Williams Charles S · Pearland, TXS/N 131-75N88453Tribfelner Lance J · St Charles, MIBuilt 1974 · S/N 1065-75N88458Cole John R · Greenfield, INBuilt 1975 · S/N 790-75N88459Carnevale Victor N · Fayetteville, NCBuilt 1974 · S/N 1067-75N8845FDowning Darrell W · Drakesville, IABuilt 1963 · S/N 53-0208N8845JWilliams Daniel · Wallingford, KYBuilt 1965 · S/N 28-2803
Back to AD 81-18-04 R2