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.

N69CZVermeylen John B · Altamont, TNBuilt 2000 · S/N MK-0295N69DASwanson Brian W · Mount Morris, NYBuilt 2002 · S/N 60302SPT2N69DLIndy Air Sales LLC · Anderson, INS/N 24-0363N69DSSale Reported · Tomball, TXSale reportedBuilt 1981 · S/N 796-HN69DYJohnson Christopher · Tulsa, OKBuilt 1978 · S/N 32AN69ETSale Reported · Nampa, IDSale reported, pending cancellationBuilt 1948 · S/N TTN-70N69FLFlx Holding Co LLC · Boca Raton, FLS/N 27-7654162N69GSDaphnee Moise Md Pa · Sarasota, FLBuilt 1972 · S/N 28R-7235275N69HANorth County Flying LLC · North Palm Beach, FLBuilt 1990 · S/N 373N69HHTaylor Kent M · Crawford, COFirst renewal noticeBuilt 1994 · S/N 69N69HSPofahl Steven R · Brookings, SDBuilt 2025 · S/N 2361N69HUMe Time LLC · Denver, COBuilt 2026 · S/N 3465N69JBIsburgh Andrew N · Conyers, GABuilt 2006 · S/N 3341N69JCBlomquist Randall J · Cave Creek, AZS/N 1N69JDPrivate Aero LLC · Sarasota, FLBuilt 1999 · S/N 5026N69JTGranger Daphne · Pearland, TXBuilt 1991 · S/N 829N69JVRasch Hellmut G · Tomball, TXBuilt 2003 · S/N 81287N69KCShipner Robert W · Palatine, ILBuilt 1988 · S/N 862N69KPBurns Justin J · Bend, ORBuilt 1998 · S/N 1437N69KVNichols James D DBA · Williamson, GABuilt 1974 · S/N AA1B-0409N69KWWeeks Kermit A · Polk City, FLBuilt 1977 · S/N 001N69KYAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1973 · S/N 28-7305300N69LMMaynard Larry · Alpharetta, GABuilt 2008 · S/N 81427N69LNValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 24-0764N69LPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 61P-0541-0230N69MFSix Ten Ventures LLC · Grand Prairie, TXS/N 61P06267963285N69MGArizona Active Air LLC · Yuma, AZBuilt 1962 · S/N 17249282N69MJKerr Peter John H · North Charleston, SCBuilt 1970 · S/N SLA-1N69MLArnold Thomas S · Saint Augustine, FLBuilt 1968 · S/N 105N69MWOlson James H · Eleva, WIBuilt 1975 · S/N 28R-7635064N69NDShannon Christopher R · Nome, AKS/N 2204N69NNRoadrunner Contraptions LLC · Azle, TXS/N 67-16846N69NSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2012 · S/N 2203N69PAWanagel Joshua · Berwyn, PABuilt 1969 · S/N 28R-35159N69PDDemray William S · Northville, MIBuilt 1960 · S/N 24-1377N69PZParagon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020182N69RDKrens Janet E · Purcellville, VABuilt 1963 · S/N 30-183N69RJSilver Blades Inc · Wilmington, DEBuilt 1972 · S/N 2HN69RMDicicca Yolanda L · BitontoBuilt 1977 · S/N 177RG1204N69RNLeong Peng H · Sebastopol, CABuilt 1980 · S/N 412N69RRInternational Air Services Inc Trustee · Carson City, NVBuilt 1966 · S/N 32-516N69RXFlying W Aviation LLC · Aurora, COBuilt 2000 · S/N 5313N69SXShuck Michael W Trustee · Maize, KSBuilt 2003 · S/N 22064N69TUD & G Aero LLC · Lomita, CABuilt 2007 · S/N 4161N69TWHiemstra Andrew · Tuolumne, CABuilt 1976 · S/N K-046N69TZUnder The Radar LLC · Henderson, NVBuilt 2006 · S/N 2843640N69ULRed Rock Flying School LLC · Mesa, AZBuilt 1969 · S/N 413N69VPPotts Vince L · Dothan, ALFirst renewal noticeBuilt 2004 · S/N 70127N69WJBahn William L · Jackson, MOBuilt 2007 · S/N 027N69WLPhillips Aviation · Port Orange, FLS/N 1048
Back to AD 81-18-04 R2