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.

N8262YAchamp LLC · Memphis, TNBuilt 1966 · S/N 30-1390N82631Payne Chris · Lafayette, TNBuilt 1980 · S/N 28-8111003N82634Aircraft Wings LLC · Gresham, ORBuilt 1980 · S/N 28-8111004N82635Chase 13 LLC · Wilmington, DEBuilt 1978 · S/N 18-7909024N8263JIsaacs David R · Fort Wayne, INBuilt 1978 · S/N VAC-109-78N8263NPiper Partners Mbda LLC · Fairfield, ILBuilt 1969 · S/N 28-25475N8263WViking Crown LLC · Prescott, AZBuilt 1965 · S/N 28-2414N8263ZBecker Matthew P · Covington, LABuilt 1980 · S/N 28-8111002N82644Chandler Elijah J S · Pilot Mountain, NCBuilt 1988 · S/N 0760N8264FRick Aviation Inc · Newport News, VABuilt 1980 · S/N 44-8107027N8264GFornwalt Paul A · Linden, PABuilt 1980 · S/N 28-8011016N8264HAir Dakota Flite Inc · Hettinger, NDBuilt 1965 · S/N 1137N8264JCouch James L · Cochran, GABuilt 1978 · S/N VAC-110-78N8264NRegistered aircraftRegistration pendingBuilt 1969 · S/N 28-25477N8264PChavez Raul M · Comanche, TXBuilt 1963 · S/N 24-3517N8264VRuby Jeffrey Steven · Sharon, SCBuilt 1980 · S/N 28-8116035N8264WEyrich Richard L · Cave Creek, AZBuilt 1965 · S/N 28-2415N8264YPatterson Casey Paul · Kinston, ALBuilt 1966 · S/N 30-1392N8265CDelgado Francisco Trustee · Carmel, INBuilt 1980 · S/N 28-8190037N8265GYencarelli Mark S · Riverview, FLS/N 177RG0165N8265HSlinger LLC · Laramie, WYBuilt 1980 · S/N 28-8190039N8265JConley Donald · Claude, TXBuilt 1978 · S/N VAC-111-78N8265NImmanuel Baptist Church Of Kansas City Kansas · Basehor, KSBuilt 1969 · S/N 28-25478N8265PNiemiec Andrew Josephtrustee · Anchorage, AKBuilt 1963 · S/N 24-3518N8265WRoy Kristi D · Burleson, TXS/N 28-2417N82665Schiestle Jason T · Greenville, PABuilt 1978 · S/N 18-7909026N82667Corfman Randle S · Lino Lakes, MNBuilt 1978 · S/N 18-7909028N82669Balcomb Mark S · Silt, COBuilt 1978 · S/N 18-7909029N8266CPiper 8266c LLC · Indianapolis, INBuilt 1954 · S/N 22-2341N8266EPropel Air LLC · Pottstown, PABuilt 1979 · S/N 17272156N8266GBode Todd D · Brush Prairie, WABuilt 1971 · S/N 177RG0166N8266JSumrall Olen · Tylertown, MSBuilt 1978 · S/N VAC-112-78N8266POtto David M · Gig Harbor, WABuilt 1963 · S/N 24-3519N8266WCraddock James E · Greensboro, NCBuilt 1965 · S/N 28-2419N8266YWerner Thomas E · Newark, DEBuilt 1966 · S/N 30-1394N82671Keleman Kenneth S · Bellingham, WABuilt 1976 · S/N 17266998N82676Accelerated Aviation Instruction LLC · Owatonna, MNBuilt 1980 · S/N 28-8116043N8267CMichie Robert B · Austin, TXBuilt 1954 · S/N 22-2342N8267EFlippin Steven P · Oak Ridge, NCBuilt 1971 · S/N 171N8267NGallup Asa N · Morgan, TXBuilt 1969 · S/N 28-25480N8267YMh Aviation Inc · Lancaster, CABuilt 1966 · S/N 30-1395N82682Long Jory J · Lake Ozark, MOBuilt 1970 · S/N 772-70N82688Wells Flying Services LLC · Holdrege, NEBuilt 1977 · S/N 36-7960043N8268BMarinko Christopher M · Geneva, OHBuilt 1980 · S/N 28-8190040N8268CJk Aviation LLC · Austin, TXBuilt 1980 · S/N 28-8190041N8268ERegistration Pending · Richlands, NCRegistration pending, pending cancellationBuilt 1979 · S/N 17272158N8268HAirtime Aviation LLC · Chippewa Falls, WIS/N 28-8190043N8268NDawes Roger L · Bullhead City, AZS/N 28-25481N8268WMontjar Andrew J · Shelby Township, MIBuilt 1965 · S/N 28-2421N8268YBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 30-1397
Back to AD 81-18-04 R2