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.

N529HJsh Farms Inc · Hermiston, ORBuilt 1976 · S/N 1042N529JAAnton Aaron · Poplar Grove, ILBuilt 1965 · S/N TD-617N529JHCoconut Racing Group LLC · North Miami, FLBuilt 1976 · S/N AA1B0669N529JSNorthgate Enterprises LLC · Anchorage, AKBuilt 2005 · S/N 81846N529LFEnterprise Aviation Services LLC · Albuquerque, NMBuilt 1976 · S/N 17267970N529LJRad Equipment Leasing Inc · Austin, TXBuilt 2004 · S/N 40.436N529LSMcnatt Shaun M · Snohomish, WABuilt 1969 · S/N 727-70N529LWNelson Harry H · Orting, WABuilt 2005 · S/N 089N529MCRhoads Eric S · Costa Mesa, CABuilt 1981 · S/N 17274639N529NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10981N529PNPitzer Peter Nelson Jr · Nevada, TXBuilt 2023 · S/N 3420N529RBBusby Ralph H III Trustee · Newport, ORBuilt 1960 · S/N TD-417N529SWFrick Kurtis W · Larned, KSBuilt 1973 · S/N 28-7305450N529TDJohnson Timothy Dean · Walton, KYBuilt 1972 · S/N 17260741N529VMCgm Aviation LLC · Gainesville, FLBuilt 1993 · S/N 14582N52AAWebster Patrick Edward · Elk Grove, CABuilt 1975 · S/N MB-760N52AHSomax LLC · Dudley, MOBuilt 2021 · S/N 3378N52AJMccarty Aaron T · Wasilla, AKBuilt 1977 · S/N R18200089N52ATPowell Michael R · Anchorage, AKBuilt 1977 · S/N 1003N52BRed Baron LLC · Middletown, DEBuilt 1988 · S/N 8-0084N52BCCottle Kevin Patrick · Daniels, WVBuilt 2008 · S/N 011N52BJTca LLC · Fountain Hills, AZBuilt 1977 · S/N 177RG1183N52CAAllison Charles L · Park Rapids, MNBuilt 1993 · S/N 1335N52CLDannebrog Air LLC · Grand Island, NEBuilt 1971 · S/N 28R-7135042N52DLeblanc Brent C · Breaux Bridge, LABuilt 1977 · S/N 62-1N52DAHusky Aero LLC · Grand Forks, NDS/N 2033N52DKPierson Janice Trustee · Scio, ORBuilt 1975 · S/N DE892N52DMPetersen Stephanie Ann Trustee · Coronado, CABuilt 1963 · S/N E3B-624-2224N52DRJbpm LLC · Otisfield, MEBuilt 1973 · S/N 15075506N52DSGiaretta David · Arlington, TXBuilt 2009 · S/N 1107N52ERFly Safe Southwest LLC · Vail, AZBuilt 1979 · S/N AA5B1095N52EVPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-8054006N52FKSixgun Aviation LLC · Eddyville, KYBuilt 1991 · S/N 1122N52FSGreseth Harold · Buffalo, MNBuilt 1972 · S/N 426-73N52GBBurkett Gary L Trustee · Murfreesboro, TNBuilt 1977 · S/N 0761N52GDVilimek Mark William · Milpitas, CABuilt 2007 · S/N 001N52GKLanthrum Joseph G · Port Hadlock, WABuilt 2002 · S/N 28015CN52GMSchneider Jeffrey A · Pensacola, FLBuilt 1973 · S/N 70-73N52HAAssociated Packaging Inc · Gallatin, TNS/N 18282226N52HMMead Charles Reese · Lake Havasu, AZS/N HM045N52HWBurns Robert B · Placerville, CABuilt 1966 · S/N 28-3466N52HYNorstegaard Brian M · Gillette, WYBuilt 2003 · S/N 2220N52JGMalloy Marc · Fletcher, NCS/N 670N52JHMonroe Scott E · Antelope, CABuilt 1981 · S/N 1N52JPBrush Wesley A · Sparks, NVBuilt 1983 · S/N 1235N52JQQuaid Jeffrey G · Paso Robles, CABuilt 2015 · S/N 70595N52JSSweeney Jack R · Parker, AZBuilt 1988 · S/N RAM 01N52JXPinhoc Inc · Winter Garden, FLS/N 15281088N52KBRisjan Randy D · Westfield, NYBuilt 1995 · S/N 272N52KDWhite Taylor D · Gainesville, GABuilt 2016 · S/N 20465
Back to AD 81-18-04 R2