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.

N776MWAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13475N776NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881044N776NHHylton Nathaniel Dean · Pleasant Plain, OHBuilt 1965 · S/N 567N776PAMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N ME-284N776RMiano Steven Mitchell · Clearwater, FLBuilt 2002 · S/N 22232N776RVThams Kurt T · Soquel, CABuilt 1998 · S/N 002N776SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12444N776SHExplore Helicopters LLC · Lexington, ALBuilt 2004 · S/N 3552N776WBcww LLC · Bakersfield, CABuilt 1980 · S/N 31-8052165N7770BDunning John L · East Hampton, NYBuilt 1974 · S/N 28-7515108N7770CMcgee Ronald S · Waco, KYBuilt 1975 · S/N 28-7625083N7770DJenkins Robert H · Kill Devil Hills, NCBuilt 1972 · S/N 28R-7235220N7770GMyers Keith R Trustee · Fond Du Lac, WIBuilt 1970 · S/N 17259470N7770HTregellas William B · Booker, TXBuilt 1946 · S/N 12-668N7770NThompson Brad J · Pleasant View, TNBuilt 1969 · S/N 28-5217N7770PGlau Jon E · Englewood, COBuilt 1961 · S/N 24-2986N7770WN7770w LLC · Sheridan, WYBuilt 1964 · S/N 28-1771N7771GEmpire Aero Club Inc · Sebastopol, CABuilt 1970 · S/N 17259471N7771NSale Reported · Copper Center, AKSale reported, pending cancellationS/N 28-5218N7771RWeatherbee Mark B · Lincoln, MEBuilt 1995 · S/N 687N7771WWhitman Edward G · River Falls, WIBuilt 1964 · S/N 28-1773N7771YDakota Executive Flight Inc · Miller, SDBuilt 1965 · S/N 30-857N7772CCummings David P · Grayson, LABuilt 1975 · S/N 28-7625084N7772DWilliams Stephen M · Fort Walton Beach, FLBuilt 1957 · S/N 18-5958N7772GWings Over Texas Holdings LLC · Denton, TXBuilt 1970 · S/N 17259472N7772NZmq Aviation LLC · Minneapolis, MNBuilt 1968 · S/N 28-5219N7773NDmac Aircraft LLC · Savannah, GABuilt 1968 · S/N 28-5221N7773PJenkins John R · Fairmont, WVBuilt 1962 · S/N 24-2989N7773WVida Kenneth J · Harrison Township, MIBuilt 1964 · S/N 28-1776N7773YBismuth Robert · Seattle, WABuilt 1965 · S/N 30-859N7774CTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1973 · S/N 0093N7774DPosson John L Trustee · Petaluma, CABuilt 1957 · S/N 18-5957N7774GElliott Miles · Porterville, CABuilt 1970 · S/N 17259474N7774NRai Jeff · Nazareth, PABuilt 1968 · S/N 28-5222N7774TPanjab Aviation · Las Vegas, NVBuilt 1979 · S/N ME-191N7774WSanto Chanselor L · Pasco, WABuilt 2008 · S/N 115MN7774YReed John · Seattle, WABuilt 1965 · S/N 30-860N7775ACarbon Cub 5x LLC · Sun Valley, IDBuilt 2025 · S/N CCK-2000-0112N7775GMondragon Vidahk D · Reseda, CAFirst renewal noticeBuilt 1970 · S/N 17259475N7775HDunshee Kevin G · Laluz, NMBuilt 1946 · S/N 12-673N7775MDennis Bruce · Rapid City, MIBuilt 1974 · S/N 20-0021N7775NHarris Mark · Greenville, SCBuilt 1968 · S/N 28-5223N7775SWildes Thomas · Chippewa Falls, WIBuilt 1976 · S/N 227-76N7776DSecond Delaware Corp · Moorestown, NJBuilt 1957 · S/N 18-5961N7776GGulf Atlantic Airways Inc · Gainesville, FLBuilt 1970 · S/N 17259476N7776MPinckney Robert L · Elgin, SCFirst renewal noticeBuilt 1974 · S/N 21-0032N7776NSkylark Flight Training LLC · Wilmington, DEBuilt 1968 · S/N 28-5224N7776PHardin Gerald A · Port Clinton, OHFirst renewal noticeBuilt 1962 · S/N 24-2993N7776ZThatcher William Scott · Eau Claire, WIBuilt 1966 · S/N 18-8483N7777CSouthern Sky LLC · Henderson, NVBuilt 1976 · S/N 17267334
Back to AD 81-18-04 R2