OpenAirDocs.org
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.

N40SPSmith Terry G · Liberty Twp, OHBuilt 1980 · S/N 17274099N40STAvera Stewart · Pensacola, FLBuilt 1997 · S/N T106AN40SYTouchandgo LLC · Hilton Head Island, SCBuilt 1976 · S/N 32R-7680271N40TDWinick Evan K · Allentown, PABuilt 2006 · S/N 1N40TLAugust Aero LLC · Kalispell, MTBuilt 2002 · S/N D-2N40TMN40tm LLC · Wilmington, DEBuilt 1966 · S/N 1063N40TPDraco Flight School DBA · Chino, CABuilt 1981 · S/N 17274723N40TUParrot Cay LLC · Missoula, MTBuilt 1978 · S/N 18-7809143N40VKSimply Living LLC · Fort Myers, FLBuilt 1966 · S/N 24-4473N40VVFaulkner Winthrop S · Anchorage, AKS/N 005N40VXHarder Steven R Trustee · The Sea Ranch, CABuilt 1998 · S/N 5040N40VZJump Jet LLC · Fort Worth, TXBuilt 2021 · S/N 40N40WFGrennell Brian M · Euless, TXS/N 30-971N40WNRider Rebecca L · Hyde Park, NYBuilt 1968 · S/N 17700829N40WYFlywerx LLC · Anchor Point, AKBuilt 2011 · S/N 3120N40XEFly Diamond Da40 N40xe LLC · Kalispell, MTBuilt 2002 · S/N 40.208N40XPRegistration Pending · Dallas, TXRegistration pendingBuilt 1976 · S/N K-040N40YLMeggers Roger D · Baker, MTBuilt 1996 · S/N 1327N40YRHelicopter Services LLC · Cheyenne, WYBuilt 2019 · S/N 4797N41007Registered aircraftBuilt 1991 · S/N 243220N4100FGoldberg Mark · Massapequa Park, NYBuilt 1976 · S/N 28-7715006N4100PValley Flying LLC · Stuarts Draft, VABuilt 1959 · S/N 23-1580N4100YLofton Charles T · Georgetown, MNBuilt 1976 · S/N 944-76N4100ZMountain Escape LLC · Pullman, WAS/N 18-8114N4101JRichardson Howell · Gilbert, AZBuilt 1966 · S/N 28-22413N4101YBower Gary R · Miranda, SDBuilt 1976 · S/N 230-76N4102BLamay James R · Reno, NVBuilt 1977 · S/N 77-31136N4102HForeman Guy W · Valparaiso, INBuilt 1978 · S/N 240617N4102PDoran Jeffrey T · Westerville, OHBuilt 1959 · S/N 23-1582N4103MMills Air Service Inc · Marstons Mills, MABuilt 1947 · S/N 12-3000N4103NKarpik Joseph Paul · Floodwood, MNS/N 680074N4103PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1583N4104PSpooter Air II LLC · Willis, TXBuilt 1959 · S/N 23-1584N4104XBandy Carla Sr · Texarkana, TXBuilt 1968 · S/N 201N4104YBurgett Gary · Galena, AKBuilt 1976 · S/N 945-76N4104ZZelina William B III · Fort Greely, AKBuilt 1964 · S/N 18-8124N4105CJohnson Rodney R · Roseburg, ORS/N R18200322N4105HBonanza Valley Air LLC · Alexandria, MNBuilt 1978 · S/N 24-0621N4105MMameli Laurie K · Thomaston, GABuilt 1947 · S/N 12-2999N4105ZMccaughey Steven A · Winter Haven, FLBuilt 1964 · S/N 18-8126N4106CAir Data Solutions LLC · Natchitoches, LABuilt 1978 · S/N R18200323N4106JFlander Donald D · What Cheer, IABuilt 1966 · S/N 28-22419N4106NGioia Matthew M · Stafford, VABuilt 1968 · S/N 680035N4106XRossiter Andrew J · Vancouver, WAS/N 203N4106ZJohnson Royce D · Clinton, ARBuilt 1964 · S/N 188127N4107MBeckham John T · Steelville, MOFirst renewal noticeBuilt 1947 · S/N 12-3005N4107NWest Main Auto Sales Inc · Tupelo, MSS/N 680075N4107PTm Aero Marine Inc · North Miami, FLBuilt 1959 · S/N 23-1562N4107XRedsun Oren Daniel · Fairfield, CAS/N 205N4107ZMissaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1964 · S/N 18-8128
Back to AD 81-18-04 R2