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.

N757UDDau Anuar · Colfax, NCBuilt 1977 · S/N 15280007N757UFAviation Capital Management LLC · San Jose, CABuilt 1977 · S/N 15280009N757UG2lyons Enterprises LLC · Wellington, FLBuilt 1967 · S/N 32-862N757URRichmor Aviation Inc · Hudson, NYBuilt 1977 · S/N 15280018N757USPeasley Robert E · Lonsdale, MNBuilt 2019 · S/N 526-2019N757UTIfly LLC · Wichita, KSBuilt 1977 · S/N 15280020N757UZCoulliette Brian K · Jacksonville, FLBuilt 1977 · S/N 15280026N757VAStoup Lyndal K · Cordell, OKS/N 15280027N757VBGanesh Prabhandhakavi · Cerritos, CABuilt 1977 · S/N 15280028N757VWHeckert Dale L · Nikiski, AKBuilt 1977 · S/N 15280047N757VYRice Timyn J · Saint Petersburg, FLBuilt 1979 · S/N R18201268N757WBReineke John S · Powell, OHBuilt 1979 · S/N R18201269N757WTElectrical Management Services · North Andover, MABuilt 1979 · S/N R18201230N757XRosenberger R Scott · Baltimore, MDBuilt 2003 · S/N 70497N757XDSouth Texas War Birds LLC · Santa Fe, TXBuilt 1979 · S/N R18201272N757XGJohnson Shawn A · Joliet, MTBuilt 1977 · S/N 15280081N757XHSteinhauser Raymond P · Ashland, OHBuilt 1977 · S/N 15280082N757XUHighflight Inc · Perkinsville, VTBuilt 1979 · S/N R18201273N757XWPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1977 · S/N 15280095N757YARule John D · Nampa, IDS/N 15280099N757YGDayton Pilots Club Inc · Springboro, OHBuilt 1979 · S/N R18201274N757YMDarcy Aviation LLC · Danbury, CTS/N 15280110N757YSJohn Mccaskill Enterprises LLC · Tifton, GABuilt 1977 · S/N 15280115N757YUTechnical Education Services Inc T/A · Virginia Beach, VABuilt 1977 · S/N 15280117N757ZKodysh Peter J · North Ridgeville, OHBuilt 2000 · S/N 863N757ZAAdventure Flight Aviation Inc · Springdale, ARBuilt 1977 · S/N 15280123N757ZNJin Jin Aviation LLC · Anchorage, AKBuilt 1977 · S/N 15280135N757ZRBishops' Ltd · Virginia Beach, VABuilt 1977 · S/N 15280138N757ZSDevereaux Mishelle · Raleigh, NCBuilt 1977 · S/N 15280139N757ZTRiya Aviation LLC · Tracy, CABuilt 1977 · S/N 15280140N75801Hartland Aviation LLC · New Smyrna Beach, FLBuilt 1976 · S/N 17267960N75803Kuntz Donald Alan · Whitefish, MTBuilt 1976 · S/N 17267962N75805Roney Howard D · Salem, ORBuilt 1976 · S/N 17267964N75806Jones Bros Amc Jeep Inc · Harrison, ARBuilt 1976 · S/N 17267965N75807Pearl River Community College · Poplarville, MSS/N 17267966N75809C & S Flyers LLC · Grand Lake, LABuilt 1976 · S/N 17267967N7580FLybbert Randal Lorin · Moses Lake, WAS/N 736-70N7580HFurjesi Steve J · Chehalis, WABuilt 1946 · S/N 12-460N7580KCrop Care By Air Inc · Lantry, SDBuilt 1950 · S/N 18-297N7580PWiseman Charles D · Orlando, FLS/N 24-2791N7580TBushgoair LLC · Chicago, ILBuilt 1978 · S/N R18200043N7580VBinzel Charles P · Bristol, WIBuilt 1976 · S/N 177RG0871N7580YMeekin Michael · Sutton, AKBuilt 1965 · S/N 18-8300N75816Lns Aviation LLC · Chandler, AZBuilt 1976 · S/N 17267973N7581CGurr James E · Alden, MIBuilt 1957 · S/N 186N7581DAllen Stephen W · Fredericksburg, TXBuilt 1957 · S/N 18-5875N7581GManasco Inc · Tucson, AZBuilt 1970 · S/N 17259281N7581HMartinez Anthony III · Great Bend, KSBuilt 1946 · S/N 12-451N7581KU Lazy S Ranch · Post, TXBuilt 1950 · S/N 18-298N7581LPruitt Kerry P · Nacogdoches, TXBuilt 1975 · S/N 18-7509079
Back to AD 81-18-04 R2