OpenAirDocs.org
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.

N50384Anderson Donald · Simmesport, LAS/N 1292-79N50389Sale Reported · Kissimmee, FLSale reportedBuilt 1979 · S/N 485-79N5038AWild River Flying Club · Saint Croix Falls, WIBuilt 1979 · S/N 376-79N5038CHonea Richard S · Canton, GABuilt 1979 · S/N 1289-79N5038EHohman Brent A · Fulton, SDBuilt 1979 · S/N 481-79N5038GStarros John P · Los Angeles, CAFirst renewal noticeBuilt 1979 · S/N 377-79N5038KPiercy Ronald S · Moses Lake, WABuilt 1979 · S/N 482.79N5038LStopher Patrick K · Anchorage, AKS/N 495N5038MMiller Aviation Group LLC · Coon Rapids, MNBuilt 1979 · S/N 1290-79N5038PMidyett Charles O · Cambridge, MDBuilt 1958 · S/N 24-41N5038SRegistration Pending · Fort Worth, TXRegistration pendingS/N 28R-35806N5038TBennett Howard N · Georgetown, KYBuilt 1972 · S/N 28-7225326N5038UButler Industries Inc · Amarillo, TXBuilt 1979 · S/N 484-79N5038WMarx Karl E · Juneau, AKBuilt 1961 · S/N 28-40N5038YAileron Buzz LLC · Daytona Beach, FLBuilt 1962 · S/N 27-2044N50395Registered aircraftBuilt 1979 · S/N 493-79N50397Wright Preston T · Deeth, NVBuilt 1979 · S/N 1108-79N5039GPhronesis LLC · Tucson, AZBuilt 1979 · S/N 490-79N5039HBig Mountain Aviation Inc · Whitefish, MTBuilt 1975 · S/N 17265311N5039LGreyhawk Aviation LLC · Erie, COBuilt 1979 · S/N 1107-79N5039NGutman Bradley J · Titusville, FLBuilt 1979 · S/N 492-79N5039RSmooth Landings Inc · Cary, ILBuilt 1974 · S/N 17263280N5039TMitchell Robert D · Freehold, NYBuilt 1972 · S/N 28-7225328N5039ZWeatherford John A · Kinder, LABuilt 1961 · S/N 22-8659N503AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020003N503AMAlpha Aviation LLC · Spartanburg, SCBuilt 1982 · S/N 17275767N503CAThompson Paul W Jr · Yachats, ORBuilt 1974 · S/N 17263757N503CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283100N503DMLau Wolfgang · Cap Canaveral, FLBuilt 1974 · S/N 150-74N503DS503 Delta Sierra LLC · Silsbee, TXBuilt 2015 · S/N 1099N503ETCarnahan Eric Q · Sardinia, OHBuilt 1965 · S/N 28-10598N503GLWomack Thomas G · Lonoke, ARS/N 0503N503JNTailwind Investments LLC · Zeeland, MIBuilt 2000 · S/N 0104N503JSAlmont Orchards Inc · Chico, CABuilt 2017 · S/N 18283009N503LWWechter William P · Ravenel, SCBuilt 2008 · S/N 357N503MAHobart Aviation Inc · Akron, OHBuilt 1975 · S/N 17266089N503MZWight Schuyler III · Goldsmith, TXBuilt 1998 · S/N 1405N503PVMichaels Scott R · Saint Augustine, FLBuilt 2004 · S/N 3FX014N503QDSchroth Charles D · Gustavus, AKBuilt 1977 · S/N 1170643N503RFNovember Tango LLC · Richmond, VABuilt 2005 · S/N 40.493N503RTPew Don E · Queen Creek, AZBuilt 1959 · S/N 769N503SBLeemon Ronald D · Prairie Du Sac, WIBuilt 2016 · S/N 5053N503SPNew Horizon Aviation Inc · Warwick, RIBuilt 1998 · S/N 172S8040N503UAlba Leasing Services LLC · Scottsdale, AZBuilt 2019 · S/N 103/USN503WAThree Rivers Aero Inc · Three Rivers, MIBuilt 1975 · S/N 17265025N5040MHulme Aviation LLC · Gilbert, AZBuilt 1978 · S/N MB-895N5040POld Seale Properties LLC · Ft Mitchell, ALBuilt 2001 · S/N 2843447N5040RShirley Craig T · Ennis, MTBuilt 1974 · S/N 17263281N5040TGamblin Ryan · Perry, GABuilt 1972 · S/N 28-7205241N50412Ride The Kite LLC · Le Claire, IABuilt 1979 · S/N 598-80
Back to AD 81-18-04 R2