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.

N888WBMassad Daren · Addison, TXBuilt 1979 · S/N 61P06107963274N888WNPropeller Nomad LLC · Mendota Heights, MNBuilt 2015 · S/N 83229N888WTBoatman John Jr · Smyrna, TNS/N K-1N888XDJohnson Rick A · Quinn, SDBuilt 2005 · S/N 2310N888ZGNess Aviation LLC · Moriarty, NMBuilt 1974 · S/N 28-7525109N888ZMHester Daniel R · Round Rock, TXBuilt 2005 · S/N 81688N8890JBlease Ronald B II · Moultrie, GABuilt 1965 · S/N 28-2865N8890KFgds Aviation LLC · North Fort Myers, FLBuilt 1967 · S/N 28-23761N8890VBig Q Aviation · Helena, MTBuilt 1974 · S/N 17264248N88914Wasik Marvin B · Hernando, FLBuilt 1975 · S/N 30N8891CSchroeder Thomas M · Georgetown, TXBuilt 1953 · S/N 22-1478N8891JAdamson Steven C · Stockbridge, GABuilt 1965 · S/N 28-2866N8891LSchendel-Adolf · Elk Grove, CABuilt 1974 · S/N AA5-0695N8891NAlred Steven J · Centre, ALBuilt 1969 · S/N 28-25755N8891VPropel Air LLC · Pottstown, PABuilt 1974 · S/N 17264249N8891YGreat Plains Aero Inc · Iowa City, IABuilt 1970 · S/N 39-49N8892JA&R Aviation LLC · Houston, TXBuilt 1965 · S/N 28-2867N8892VBillingsley Carl R · Henderson, TXBuilt 1974 · S/N 17264250N8893CAirquest Aviation Lp · Butler, PABuilt 1976 · S/N 28-7615132N8893JWare Wilson · Rockwall, TXS/N 28-2868N8893VEast Tennessee Pilots Club · Knoxville, TNBuilt 1974 · S/N 17264251N8894Buth Elizabeth · Wasilla, AKBuilt 1973 · S/N 478-73N8894CBrent Thomas P · Walnut, MSBuilt 1953 · S/N 22-1475N8894DPyle Jarod H · Wasilla, AKBuilt 1958 · S/N 18-6368N8894JMenees B Martin · Little Rock, ARBuilt 1965 · S/N 28-2870N8894VBeckworth Brad T · Jacksonville, FLBuilt 1974 · S/N 17264252N8895JCherokee N8895j Inc · Westminster, MDBuilt 1965 · S/N 28-2871N8895NLuque Michael J · Shinnston, WVS/N 28-25759N8895YRegistered aircraftS/N 39-52N8896Ausbun Taylor J · North Pole, AKBuilt 1973 · S/N 480-73N8896DGidzinski David A · Weirsdale, FLBuilt 1958 · S/N 18-6370N8896EN8896e LLC · Lake City, FLBuilt 1976 · S/N 28-7625165N8896JClark Kenneth A · Mount Pleasant, ARBuilt 1965 · S/N 28-2872N8896WClarke William Christopher · Palm Coast, FLBuilt 1964 · S/N 28-10460N8897JShreve Gene · Fayetteville, TNBuilt 1965 · S/N 28-2873N8897NAnderson Leroy H · San Angelo, TXBuilt 1969 · S/N 28-25761N8897YAvion LLC · Lewes, DEBuilt 1970 · S/N 39-54N8898DWelty Donald Robert Jr · Glennallen, AKBuilt 1958 · S/N 18-6374N8898JColt 45 LLC · Tulsa, OKS/N 28-2874N8898NTaylor Danny H · Defuniak Springs, FLBuilt 1969 · S/N 28-25762N8898WWade Harry Jr · Helotes, TXBuilt 1964 · S/N 28-10462N8898YWickenheiser Kenneth W · Sun City, AZBuilt 1970 · S/N 39-33N8899ERgp Aviation LLC · Wilmington, DES/N 28-7690215N8899LSujet Dylan P · Hampton, NJBuilt 1974 · S/N AA5-0698N8899YSture Joel M · Anchorage, AKBuilt 1974 · S/N 18-7409031N889DQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N AA5B-0706N889DALeik Aviation LLC · Dousman, WIBuilt 2023 · S/N 80814N889EHMillhouse Eric L · Cheyenne, WYBuilt 2002 · S/N 1184N889FNe Ia Helicopter LLC · Tekamah, NEBuilt 2016 · S/N CC19-0010N889GSKlock Dexter F · Driggs, IDBuilt 2000 · S/N 853-99
Back to AD 81-18-04 R2