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.

N8334YOncore Aviation LLC · Rochester, NYBuilt 1981 · S/N 28-8116151N8334ZUfly Vi LLC · St Thomas, VIBuilt 1981 · S/N 28-8116152N83354Stephl Matt J · Anchorage, AKBuilt 1976 · S/N 18-7609094N83358Minikey Jack DBA · Stanton, MIBuilt 1976 · S/N 18-7609098N83359Magalsky Jacob J · Wilsall, MTBuilt 1976 · S/N 18-7609099N8335EMillheim Roger L · Frankston, TXBuilt 1959 · S/N 1513N8335VLisoski Derek L · Clark Fork, IDBuilt 1966 · S/N 474N8335WHiatt Ronald G · Forestburgh, NYBuilt 1965 · S/N 28-2516N83362Magnuson Robert L Jr · Mc Grath, AKBuilt 1976 · S/N 18-7609092N83364Rhoads Eric S · Costa Mesa, CABuilt 1982 · S/N 28-8390035N83367Peterson Leland C Co Trustee · Anchorage, AKBuilt 1976 · S/N 18-7609100N83368High Mountain Air LLC · Missoula, MTBuilt 1976 · S/N 18-7609091N8336GGolden Age N8336g LLC · Norwalk, IABuilt 1981 · S/N 28-8190167N8336HNeel Aviation LLC · Lakeland, FLBuilt 1981 · S/N 28-8190168N8336PWyatt Gary D · Sun City West, AZS/N 24-3590N8336RSmith Gerald A Trustee · Bow, NHBuilt 1966 · S/N 28-22209N8336WJd Aviation LLC · Omaha, TXBuilt 1965 · S/N 28-2518N8336XConway Brian R · Fallbrook, CABuilt 1996 · S/N 0228N8336YPatterson Thomas A · Minerva, OHBuilt 1967 · S/N 30-1481N8336ZGreene Tom · Mesquite, NVBuilt 1996 · S/N 0262N83378Aldridge Brett A · Soldotna, AKBuilt 1976 · S/N 18-7609105N83379Nei Jeffrey G · Bemidji, MNBuilt 1976 · S/N 18-7609107N8337APn4 Aviation Holdings LLC · Bishop, CABuilt 1981 · S/N 28-8111051N8337EC & S Aerial Photography LLC · Ponca, NEBuilt 1959 · S/N 1515N8337HRegistered aircraftBuilt 1981 · S/N 32-8106042N8337VWydronek Joseph A · Tucson, AZBuilt 1966 · S/N 422N8337YBorden William · Commerce Township, MIBuilt 1967 · S/N 30-1483N8338Aviation Hub Inc Trustee · Cheyenne, WYBuilt 2023 · S/N 172S13006N83381Fishfull Thinking LLC · Cordova, AKBuilt 1976 · S/N 18-7609111N83386Treit Marlowe · Aurora, ORBuilt 1976 · S/N 18-7609112N8338CBean Eric J · Canton, NCBuilt 1976 · S/N 28-7625103N8338DPlant Galen M · Crown Point, INBuilt 1981 · S/N 28-8116156N8338LTreimer Aviation LLC · Davenport, IABuilt 1968 · S/N 17256538N8338PHerndon Properties LLC · Walterboro, SCS/N 24-3593N8338RMarshall Rodney V · Riverton, UTBuilt 1966 · S/N 28-22211N8338VGustafson Cody A · Corvallis, ORBuilt 1966 · S/N 401N8338WL A S LLC · Fort Leavenworth, KSBuilt 1965 · S/N 28-2520N83392Guy James L P · Wasilla, AKS/N 18-7609117N83394Hard Luck Aviation LLC · Tok, AKBuilt 1976 · S/N 18-7609118N83395Jorgensen Spike C · Tok, AKBuilt 1976 · S/N 18-7609119N83397Gila Aviation Co LLC · Whitefish, MTBuilt 1976 · S/N 18-7609120N8339CEberle Michael Thomas · Plato, MOBuilt 1975 · S/N 28-7615089N8339DLd Flight LLC · Houston, TXBuilt 1982 · S/N 28-8316030N8339GAudia Roger S · Pennington Gap, VABuilt 1996 · S/N 0243N8339LRohrbaugh David J · Oakland, MDBuilt 1968 · S/N 17256539N8339QDingler Isaac C · Langtry, TXBuilt 1996 · S/N 2633N8339RGonzalez Karina · Bloomfield, NJFirst renewal noticeBuilt 1966 · S/N 28-22213N8339WYoung Stanley K · Edmond, OKBuilt 1965 · S/N 28-2522N8339YBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 30-1485N833AMessinger Kevin R · Palmerton, PAS/N 22-135
Back to AD 81-18-04 R2