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.

N789WTGabrys Ronald B · Wisconsin Rapids, WIBuilt 2006 · S/N 89N78AHCenturion Aviation LLC · Virginia Beach, VABuilt 2013 · S/N 3172N78AJHamlin Curits · North Pole, AKBuilt 1978 · S/N 18-7809111N78AKFreytag Ronald D · Stockton, CAS/N 075N78ATSchrage Rodney L · Steamboat Springs, COBuilt 1985 · S/N 1029N78BGKdrd Holdings LLC · Texas City, TXBuilt 1977 · S/N 28-7890100N78BKKang Byung · Kansas City, MOBuilt 2024 · S/N 18283277N78BYNorthwestern Michigan College · Traverse City, MIBuilt 2005 · S/N 974-2005N78CWPotter Justin D · Eagle River, AKS/N 12-1907N78DFBurkett Robert S · Baytown, TXS/N 1120N78DJKing David V · Mars, PABuilt 1978 · S/N 28R-7837171N78DLBruns Luke · Flower Mound, TXBuilt 2003 · S/N 80243N78DRWhitehead Michelle W · Centralia, WABuilt 2007 · S/N 22541N78DWNeu Lawrence R · San Antonio, TXBuilt 1980 · S/N 844N78EFFearnow Rolland E · Wabash, INBuilt 2007 · S/N 72174N78FMFraker Gregory M · Plymouth, MIBuilt 1978 · S/N 24-0768N78GCMh Aviation LLC · Foster City, CABuilt 2001 · S/N 892-2001N78GPBailey Eric C · Lake Havasu City, AZS/N 001N78GTBennett Wayne M Jr · Puyallup, WABuilt 1978 · S/N AA5B-0853N78HBValiair Lc Trustee · Casper, WYS/N 2066N78HYD A Lamont Public Adjusters LLC · Springtown, TXBuilt 1999 · S/N 2048N78JDArtigas Gonzalo J · Cambridge, MABuilt 2010 · S/N 2086N78JFRace39 LLC · Kenmore, WABuilt 2018 · S/N 3068N78JHPlane Fun Inc Tr Trustee · Snellville, GABuilt 1985 · S/N SN523RN78JMDye William M · Atlanta, GABuilt 1976 · S/N 28-7690430N78JNMuseum Of Flight Foundation · Seattle, WABuilt 1971 · S/N 434N78JRFocus Air LLC · Wilmington, DEBuilt 2020 · S/N 1214N78JSJet South LLC · Medford, NJBuilt 1978 · S/N 32R-7885152N78KPYoungblood Dennis L · Crystal River, FLBuilt 1978 · S/N AA5B0758N78KVShore Dog Aviation LLC · Dover, DEBuilt 1978 · S/N AA5A0632N78LLLawnchair Pilots Association LLC · Wilmington, DES/N SSVTS-001N78LSNor-Cal Air LLC · Kalispell, MTBuilt 1978 · S/N 60-0546-176N78MJTalley Patricia · Asheboro, NCBuilt 1973 · S/N 28-7325319N78MTBrady William P · Banner, WYBuilt 1998 · S/N 199N78MUKoonce John P · Jefferson City, MOBuilt 2007 · S/N 40428N78MVWhittington Rankin A Trustee · Lenoir, NCBuilt 1999 · S/N 836-99N78NJBessie Aviation LLC · Lexington Park, MDBuilt 1978 · S/N 61P05747963250N78NPHeaton Justin · Lufkin, TXBuilt 2002 · S/N 444N78NSRobertson Lester M · Hamilton, OHBuilt 1982 · S/N JAN1975-SKN78PDBryant Jerry L · Punta Gorda, FLBuilt 2003 · S/N 919-2003N78PJRothrock John W Jr · Danville, INBuilt 1978 · S/N 363-78N78PLDunaway Dennis G Jr · Port Orange, FLBuilt 1978 · S/N 32R-7885040N78PPToman Gregory R · Caledonia, MIBuilt 2002 · S/N 25392N78PWPower Joe D · Seguin, TXBuilt 1963 · S/N 24-3434N78QBPandion Aviation LLC · West Chester, PABuilt 1978 · S/N 28R-7837308N78QPHilyer Bruce W Trustee · Seattle, WABuilt 1966 · S/N 18-8469N78RFFairchild Maxwell D · Morristown, TNBuilt 1958 · S/N 22-6243N78RGBubber Inc · Lake Providence, LABuilt 1977 · S/N R18200057N78RJUsaeroflight LLC · Greenville, SCBuilt 1970 · S/N 39-21N78RLDavis Murray L · Fair Play, CABuilt 1984 · S/N 447
Back to AD 81-18-04 R2