OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N320RKegin Kevin M · Salem, ILBuilt 1992 · S/N 1N320RBLogan David J · Saint Helens, ORBuilt 1963 · S/N 27-2389N320RCEastern Properties LLC · Burlington, NJBuilt 2004 · S/N 18281352N320RPRoss Timothy D · Sunbury, PABuilt 2000 · S/N 690N320RSSpace Roy D · Windsor, COBuilt 2009 · S/N 439-320-189-FBN320RVVan Dyke Stewart D · Carmel, INBuilt 1999 · S/N 24652N320SSinclair William Robert · Lafayette, CABuilt 2000 · S/N 368-320-124-14PN320SCEcho Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13352N320SHMoore Michael C · Anchorage, AKBuilt 1956 · S/N 185060N320SLHelmuth Jesse N · Willow, AKS/N 03206N320SPLundstrom Aviation LLC · Ankeny, IABuilt 2003 · S/N 172S9490N320STGuaglione Anthony · El Dorado Hills, CABuilt 2006 · S/N S-10002N320TDHalvorson Scott B · Fremont, WIBuilt 2025 · S/N 07200125N320THN63e LLC · Fallon, NVBuilt 1996 · S/N 225N320UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020227N320WWatson R Samuel · Hartsville, SCBuilt 1996 · S/N 1001AN320WSLamb Phillip D · Odessa, MOBuilt 1995 · S/N 1298N320XPBoggs Larry Joseph · Westfield, INBuilt 2023 · S/N 82249N320ZPrzestrzelski John M · Frankfort, NYBuilt 2021 · S/N 11000N3210Perry Daryl C · Sanford, NCBuilt 1961 · S/N 22-8079N32101Speed Hunter Aviation LLC · Franklin, OHBuilt 1974 · S/N 28-7505024N32103Freeman David B · Liberty, NCS/N 28-7505026N3210EGrove Douglas W · Flemington, PABuilt 1947 · S/N 12-1473N32115Kowatra Anil K · Lilburn, GAFirst renewal noticeBuilt 1974 · S/N 28-7505027N3211EApm Leasing LLC · Casper, WYBuilt 1978 · S/N 17271470N3211PJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1957 · S/N 23-1152N32123Kell Matthew D · Kodiak, AKBuilt 1974 · S/N 28-7515076N32124Howard John D · Palm Bay, FLBuilt 1974 · S/N 28-7515077N32128David William Christy Trustee · Willis, TXBuilt 1974 · S/N 28-7505028N32129Weaver Arnold G · Sandusky, MIS/N 28R-7535028N3212FMcdonald Ronald W · Olive Branch, MSBuilt 1967 · S/N 670005N3212QBrighters David E Trustee · Baton Rouge, LABuilt 1977 · S/N 28-7790443N3212TRichmond Timothy R · Deland, FLBuilt 1967 · S/N 17700512N3213NRegistered aircraftBuilt 1946 · S/N 22403N3213WElmore Terry · Berry, ALS/N 32-13N3213ZDasher Daryl L · Boring, ORBuilt 1959 · S/N 22-7153N3214DHill James P · Eagle Point, ORS/N 18-8209025N3214FPicker Larry L · Stanfield, ORBuilt 1967 · S/N 670007N3214TJohnson Hugh S · Rochester, NYBuilt 1967 · S/N 17700514N32151Wilson James E III · Brentwood, CAS/N 28-7505030N32156Fier Michael A Sr · Mundelein, ILBuilt 1974 · S/N 28-7525029N3215FWinick Scott R · Jay, VTBuilt 1967 · S/N 670008N3215TMcgee Debra L · Tuscola, TXBuilt 1967 · S/N 17700515N3215WDiederich Chad · Chesapeake, VABuilt 1965 · S/N 32-16N3215ZCastle Richard E · Callao, MOS/N 22-7155N3216Ropp Dwight F · Pasco, WAS/N 30-796N32160Emmons Thomas M · Millington, MIBuilt 1974 · S/N 28-7525030N32161Helseth Keith A · Kirksville, MOBuilt 1974 · S/N 28-7515082N32165Cole Charles V · Sparta, TNBuilt 1974 · S/N 28-7515084N32169Airleasing LLC · Beverly Hills, CABuilt 1974 · S/N 28-7505031
Back to AD 81-18-04 R2