OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N121DBTexins Flying Club · Mckinney, TXBuilt 1972 · S/N 28R-7335024N121DDRowlands Owen D · Pueblo West, COBuilt 2013 · S/N 12136N121DSGarvison Paul L · Hillsville, VABuilt 1995 · S/N 22373N121DWFlight World Inc · San Juan, PRBuilt 1972 · S/N 312N121EConger Martin D · Pasco, WABuilt 1963 · S/N 173N121ECN121ecfllyers LLC · South Jordan, UTBuilt 1967 · S/N 17700036N121ERFreedom Aviation LLC · Dover, DES/N 1510N121ESWell Bilt Industries USA LLC · Ocala, FLBuilt 1971 · S/N 28-7125383N121FTBowman William K · Raleigh, NCBuilt 1982 · S/N 28-8216191N121GBAviation Academy LLC · Wichita, KSBuilt 1968 · S/N 17257308N121GKBook Thomas D · Loveland, COBuilt 2003 · S/N 2767N121GRSimmons Scott J · Palm Springs, CABuilt 1978 · S/N 2159N121HEJarrett Air LLC · Ashland City, TNBuilt 1979 · S/N 32-7940127N121HHTimm Robert S · Minneapolis, MNBuilt 1992 · S/N 1209N121HSCharles Dan H · Des Allemands, LAS/N 121N121JAAlbers Edward J Jr · Oviedo, FLBuilt 1991 · S/N 121N121JCNewsom William A · Cheraw, SCBuilt 2000 · S/N F0010N121JLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1993 · S/N ODOM 0001N121JMBullet Aviation LLC · Missoula, MTBuilt 2025 · S/N 18283317N121JZZack Jay T · Cloquet, MNBuilt 2002 · S/N 0121N121KAAir Ally Asset Management LLC · Chisago City, MNS/N 17263836N121LCJolisea Wings LLC · Palm Bay, FLBuilt 2003 · S/N 21161N121LMGolden Age N121lm LLC · Des Moines, IABuilt 2022 · S/N 2881529N121LTDream 10 LLC · Dunnellon, FLBuilt 2024 · S/N 42367N121MDBaggarly Michael · Newnan, GABuilt 1969 · S/N 28-25613N121MNNielsen Mark C · Green Bay, WIBuilt 1997 · S/N MN-01N121MSDarcy Aviation LLC · Danbury, CTBuilt 1978 · S/N 17271893N121PGGinter Jon A · Marlton, NJBuilt 2005 · S/N 70731N121PRPaulich John III · Naples, FLBuilt 2005 · S/N 71295N121RFRafamedia LLC · Stamford, CTBuilt 1976 · S/N 13048N121RLZaytsev Petr · Pflugerville, TXBuilt 1969 · S/N 690072N121SClark William H IV · Thurmont, MDBuilt 1966 · S/N 32-835N121SESpitzer Helicopter LLC · Woodland Hills, CABuilt 1997 · S/N 2747N121SGTaliaferro Leigh · Abilene, TXBuilt 2006 · S/N 1036-2007N121SXRegistered aircraftBuilt 2018 · S/N 14147N121TCDonney Tom J · Sturgis, SDBuilt 1978 · S/N 32-7840105N121UCEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1998 · S/N 17280420N121VAAerodynamic LLC · Aurora, ORBuilt 2021 · S/N 1034N121VKOcala Aviation Services Inc · Ocala, FLBuilt 1984 · S/N 17276101N121VTWilliams Ralph J · Essex Junction, VTBuilt 2007 · S/N 99-1131N121VUThomason Stewart A · Charleston, SCBuilt 1991 · S/N 10057N121WN121w LLC · Union Gap, WABuilt 2019 · S/N 172S12276N121WEMidwest Aviation Inc · Mayfield, KYBuilt 2019 · S/N 172S12322N121WMBarnes Robert B · Chico, CABuilt 1980 · S/N 638-80N121WPRoy Frank W · Millinocket, MES/N 1382N121WWArensmeyer Michael W · Longmont, COBuilt 2021 · S/N 001N12200Dunahoo Steven W · Cleveland, GABuilt 1973 · S/N 17261880N12202Hudson Kent O · Anchorage, AKBuilt 1972 · S/N 339-72N12206Hth LLC · Merigold, MSBuilt 1972 · S/N 299-72N12207Faris Isaac · Swartz Creek, MIBuilt 1972 · S/N 34272
Back to AD 81-18-04 R2