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.

N5BHixon Carl J · Clayton, NCBuilt 2003 · S/N 5061N5BJLinrud Michael A · Velva, NDBuilt 1969 · S/N 187N5BKRegistered aircraftBuilt 1961 · S/N 24-2677N5BMDja Enterprises LLC · Los Angeles, CABuilt 1979 · S/N 28-8090181N5BYWolff Emanuel C Md · Tucson, AZBuilt 1963 · S/N 30-105N5CMBramall Buster I · Waxahachie, TXBuilt 1973 · S/N 17262655N5DDSeghetti Brant C · San Tan Valley, AZBuilt 1974 · S/N AF17448714N5DNStinemetze Justin T · Mojave, CABuilt 1986 · S/N 892N5DPN5dp LLC · Ann Arbor, MIBuilt 1973 · S/N 28-7405033N5EBN5eb LLC · Medina, OHBuilt 1967 · S/N 30-1474N5EECristal Air Inc · Wilmington, DEBuilt 1993 · S/N 172N5EJJones Eric M · Southbridge, MAS/N 177RG0167N5EYOshikoo LLC · Seattle, WABuilt 2004 · S/N 70267N5FMWillis Nelson W · Lebanon, TNBuilt 1994 · S/N 0001N5FNM J S Corp · Howe, INBuilt 2013 · S/N 1468-2012N5FVRegistered aircraftBuilt 1981 · S/N 2254N5GHDowin Robert R · Doylestown, PABuilt 1970 · S/N 700046N5GJNorthampton Lsa LLC · Northampton, MABuilt 1978 · S/N GA7-0006N5GNNeu Lawrence R · Marion, TXBuilt 1977 · S/N XX5N5HNBartle Henry P · Independence, ORBuilt 1991 · S/N S 55N5JBucher John R · Rch Palos Vrd, CABuilt 1966 · S/N 300N5JCSink Abram T · Hillsboro, OHBuilt 1982 · S/N 518N5JFStephens John D · Esparto, CABuilt 1973 · S/N 001N5JLRegistered aircraftBuilt 1968 · S/N TD-719N5JNOcchiuzzo Joseph A · Holyoke, MAFirst renewal noticeBuilt 1963 · S/N 28-1528N5JXFive Jx LLC · Tucson, AZBuilt 2012 · S/N 24785N5KDTexas Tailspin LLC · Amarillo, TXBuilt 1974 · S/N 155-74N5KECebeci Paul · Saint Augustine, FLBuilt 1971 · S/N 155N5KFSneddon Dale R · Carthage, MOBuilt 1986 · S/N 65N5KKClough Albert Hughes · Douglas, AKBuilt 1947 · S/N 12-1926N5LELacey Sean · Culbertson, NES/N 3023N5LGStuller Dennis · Fort Denaud, FLBuilt 1966 · S/N 28-22238N5LYLittle Karley Y · Baytown, TXBuilt 1971 · S/N 474N5MAScola Daniel B · Port Orange, FLBuilt 1967 · S/N 30-1622N5MDDunn Vincent K · Salem, ORBuilt 1966 · S/N 3317N5MFFrey Michael L III · Waco, TXBuilt 1973 · S/N 1N5NSN5ns LLC · Payson, AZBuilt 1995 · S/N NEALN5PTMunson George R · Westhampton, MABuilt 1972 · S/N 17260628N5QABear Canyon LLC · Afton, WYBuilt 1997 · S/N 1369N5QTHusky5qt LLC · Scappoose, ORBuilt 1997 · S/N 1380N5RBBanasik Associates Inc · Columbus, OHBuilt 1976 · S/N 177RG0968N5RJPilkington Lawrence O · Portland, ORS/N 739N5RQOgden Christopher S · Chewelah, WABuilt 1964 · S/N 1N5RWToms Ronald C · Lena, LABuilt 1970 · S/N 17259649N5SKKershaw Spence M · Hollywood, FLBuilt 1975 · S/N 135-HN5SMBearss Gordon M · Topeka, KSBuilt 1974 · S/N 21-0051N5SPMalley Anthony M · Arlington, TXBuilt 2005 · S/N 70144N5SRRollins Jay A · Muncie, INBuilt 1978 · S/N 73059LFN5TEBythway William M · Painesville, OHBuilt 1968 · S/N 113N5UASenneker Robert L · Dorr, MIBuilt 2001 · S/N 25103
Back to AD 81-18-04 R2