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.

N777LTYates Deborah L · Pioneer, CABuilt 1978 · S/N 24-0691N777LYUmpqua Flying Organization LLC · Roseburg, ORBuilt 1974 · S/N 32-7440079N777MKPecori Emil R · Oakdale, PABuilt 1978 · S/N 61P-0478-192N777MRRutherford Michael A · Medina, OHBuilt 1974 · S/N 1068-75N777PWAerowest LLC · Independence, ORBuilt 1976 · S/N AA5B-0389N777PYMark Britain Productions LLC · Amarillo, TXBuilt 2009 · S/N 12385N777RHLarson Peter T Trustee · Coraopolis, PABuilt 1965 · S/N 30-908N777RLLandau Management Services Inc · Toranga, CABuilt 2000 · S/N 0744N777SNichols Max E · Great Bend, KSBuilt 1981 · S/N 18-8109040N777SDBoomerang Air LLC · Cedar Park, TXBuilt 1980 · S/N 28-8190125N777SKDj Internet Commerce LLC · Crowley, LABuilt 1977 · S/N 32R-7780017N777SRWilkie David J · Nashua, NHS/N 28-20268N777SWRegistered aircraftBuilt 2007 · S/N 40507N777SXSkinner Norman D · Osceola, IABuilt 1993 · S/N 3025N777TGWeder Erwin M · Sand Springs, MTBuilt 1951 · S/N 18-1118N777TRBlack Vernon N · Hildale, UTS/N 1859N777UFTaylor Douglas M · Dallas, TXBuilt 1960 · S/N 166N777UHRobinson Helicopter Company Inc · Torrance, CABuilt 2004 · S/N 3548N777VAVolante Aircraft LLC · South Jordan, UTBuilt 1980 · S/N 1N777VCChaney Van G · Niceville, FLBuilt 2003 · S/N 70410N777VJTucker Billy J · Arley, ALBuilt 1979 · S/N R18200870N777VLFirst Aerial Assault Inc · Williamston, NCBuilt 1991 · S/N 474-320-219FBN777VPFlightwing Equipment Corp · Beverly Hills, CABuilt 1974 · S/N 28-7415632N777VXGutierrez Ruben E · Fontana, CABuilt 1968 · S/N 28-24298N777WBClark Lloyd E · Hanover, MDBuilt 1973 · S/N 28-7305219N777WJMorrison Mark W · Bloomingdale, ILBuilt 2014 · S/N 40060N777YTKeyt LLC · Missoula, MTBuilt 1981 · S/N 18268029N777ZBKingfisher Air Inc · Kodiak, AKBuilt 2000 · S/N 30N777ZPCamp Clinton · Castle Rock, COBuilt 2010 · S/N 055N777ZZMiller Jordan Raul · Columbus, OHFirst renewal noticeS/N 24-1495N7780DMathews Development Co Inc · Santa Rosa Beach, FLBuilt 1957 · S/N 18-5969N7780GAero Quest LLC DBA · Olive Branch, MSBuilt 1970 · S/N 17259480N7780PMolinari Eugene A Jr · Milton, FLBuilt 1961 · S/N 24-2997N7780YKeller Zachary T · Wasilla, AKBuilt 1962 · S/N 18-7886N77812Wildman Gary C Trustee · Germantown, TNBuilt 2005 · S/N 18281549N7781CDrake Donald J · Rochester, NYBuilt 2013 · S/N 590N7781DCraig Adam J · Anchorage, AKBuilt 1957 · S/N 18-5970N7781EGibson Paul Trustee · Groveland, CABuilt 2005 · S/N 18281621N7781GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259481N7781HMittelstadt Kevin J · Oakfield, WIBuilt 1946 · S/N 12-679N7781KEvans Thomas Sidney · Wilmer, ALBuilt 1951 · S/N 20-607N7781NKns Asset Management LLC · Lumberton, TXBuilt 1968 · S/N 28-5229N7781PBallard William S · Sanford, NCBuilt 1962 · S/N 24-2998N7781ZBrandywine Soaring Association · Hockessin, DEBuilt 1966 · S/N 25-3983N7782MEvans Richard C · Shepherd, MIBuilt 1974 · S/N 22-0030N7782WDavies Kenneth A · Oak Harbor, WABuilt 1964 · S/N 28-1789N7783MOrourke James Kevin · Omaha, NES/N 22-0031N7783NForbes Aviation LLC · Boise, IDBuilt 1968 · S/N 28-5231N7784GAll2fly LLC · Atlanta, GABuilt 1970 · S/N 17259484N7784HBuice Carl U · Newbury Park, CABuilt 1946 · S/N 12-681
Back to AD 81-18-04 R2