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.

N74718Jordan Victor M · Carson City, NVBuilt 1961 · S/N 1900N74719Valerio Lori-Anne · Corona, CABuilt 1961 · S/N 1804N7471KFunckes William · Zeeland, MIBuilt 1950 · S/N 20-384N7471LRegistered aircraftBuilt 1975 · S/N 18-7509067N7471MN7471m LLC · Sheridan, WYBuilt 1968 · S/N 680104N7471RBalderas Jose Aaron Jr · Mission, TXBuilt 1966 · S/N 28-22019N7471VCollins Ronald Rs · Rutledge, TNBuilt 1965 · S/N 28-2284N7471WRegistered aircraftBuilt 1963 · S/N 28-1376N7471YLi Yilin · Alma, MIBuilt 1964 · S/N 30-536N74720Woods Donald E · Great Falls, MTBuilt 1961 · S/N 1720N74722Feigitsch Michael · Minot, NDS/N 1722N74723Craige Research Inc · Roslyn Heights, NYBuilt 1961 · S/N 1723N74725Oran Jamie A · Apple Valley, CAS/N 1725N74729Registration Pending · Weston, IDRegistration pending, pending cancellationBuilt 1961 · S/N 1729N7472RSouthern Jeffrey · Rayville, LABuilt 1966 · S/N 28-22021N7472WTait Ronald M · Fort Worth, TXBuilt 1963 · S/N 28-1377N74730Twin Rivers Wildlife Inc · Elko, NVBuilt 2005 · S/N 10888N74731Registration Pending · Bella Vista, ARRegistration pendingS/N 1731N74733Maxwell Stephen R · Dodge City, KSBuilt 1976 · S/N AA5B0357N74735Tipton Michael · Florissant, COBuilt 1961 · S/N 1735N74736Russell Robert C · Decatur, ALBuilt 1961 · S/N 1736N74737American Asset Leasing LLC · Aurora, ORBuilt 2020 · S/N 172S12586N7473DRezzonico John · Round Hill, VABuilt 1957 · S/N 18-5808N7473KMachado Douglas M · Kenai, AKBuilt 1950 · S/N 20-387N7473RSonntag Donald · Marengo, ILFirst renewal noticeBuilt 1966 · S/N 28-22022N7473YSale Reported · Palmer, AKSale reportedBuilt 1964 · S/N 30-538N74740Woodyatt Michael A · Byron, ILBuilt 1976 · S/N AA5B0358N74745Renfroe Daniel P · Eagleville, TNBuilt 1961 · S/N 1745N74747Dubois Alan P · Jamestown, RIBuilt 1961 · S/N 1747N74748Moore David · Amarillo, TXBuilt 1961 · S/N 1748N7474DRogue Aero LLC · Grants Pass, ORS/N 18-5809N7474GBarnett Kevin · Simi Valley, CABuilt 1970 · S/N 17259174N7474JHorton James D · Las Vegas, NVS/N 28R-30827N7474LNelson Travis E · Richland, MTBuilt 1975 · S/N 18-7509069N7474RGregorski Thomas E · Kenly, NCBuilt 1966 · S/N 28-22023N7474TWorks James K · Avalon, CABuilt 1967 · S/N 28-23432N7474WZimmerman Sandra · Henderson, NVBuilt 1963 · S/N 28-1379N74750Anderson Jonathan R · Corpus Christi, TXS/N 1750N74752Brundige Mark S · Mount Pleasant, TXBuilt 1961 · S/N 1752N74758Robins Stephen B · Hutchinson Island, FLS/N 1758N74759Page Casey P · Abilene, TXBuilt 1961 · S/N 1759N7475RTolsma Garrett J · Kirkland, WABuilt 1966 · S/N 28-22024N7475YOverseas Aviaton Inc · Wilmington, DEBuilt 1964 · S/N 30-540N74760Boyle Fred Sr · Cape May, NJBuilt 1961 · S/N 1760N74762Bulldog Aviation LLC · Kalispell, MTBuilt 1961 · S/N 1762N74763Crouse Stanley G · Greenwood, MOS/N 1763N74764Carter Dejuan Jermaine · Little Rock, ARBuilt 1961 · S/N 1764N74765Lister Thomas L · Wynnewood, OKS/N 1765N74766Reiner Henry A · Hutchinson, MNBuilt 1961 · S/N 1766N74767Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2005 · S/N 10915
Back to AD 81-18-04 R2