OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N3014TSlaney Richard C · Eugene, ORBuilt 1973 · S/N BH120/212N3014XReasoner Michael L · Corvallis, ORBuilt 1979 · S/N 32-7940094N30151Miller Jacob G · Harrison, ARFirst renewal noticeS/N 17701081N30153Waters Donovan D · Peoria, AZBuilt 1968 · S/N 17701082N30157Cardinal Aviation LLC · Pelham, NHBuilt 1968 · S/N 17701086N30158Segroves Jeffrey S · Milledgeville, GABuilt 1968 · S/N 17701087N3015DFlywell Flying Club Inc · Roseville, MNBuilt 1978 · S/N 28-7990171N3015ECuevas Ernesto · Orlando, FLBuilt 1978 · S/N 17271404N3015UCoastal Fliers Inc · El Cajon, CABuilt 1979 · S/N 28-7990335N3015ZPittman Leo B · Stanfield, AZBuilt 1959 · S/N 22-6966N30166De Jager Henry · Smithville Flats, NYBuilt 1968 · S/N 17701093N3016DHuybrechts Dirk J · Los Angeles, CAFirst renewal noticeBuilt 1978 · S/N 28-7911040N3016MWild Wingdom LLC · Greenville, SCBuilt 1978 · S/N 28-7890284N3016NParker James C · Rescue, CABuilt 1979 · S/N 32-7940038N3016TWilson Michael L · Santa Maria, CABuilt 1979 · S/N 28-7916298N3016WBramble And Schaffer Aviation LLC · Raleigh, NCBuilt 1979 · S/N 28R-7918086N30173Tolman William C · Maryville, TNBuilt 1978 · S/N 32R-7887270N30179Kowatra Anil K · Lilburn, GABuilt 1968 · S/N 17701103N3017GBecker Lyle A · Anchorage, AKBuilt 1968 · S/N 511N3017HDavis Ronald C · Bloomington, MNS/N 28-7916184N3017MRwm Aviation LLC · Kalispell, MTBuilt 1947 · S/N 12-1714N3017PDragonfly Aviation LLC · Mirando City, TXBuilt 2007 · S/N 1820N30182Johnson Arnold R · Mina, SDBuilt 1968 · S/N 17701105N30184Cp Aviation Inc · Santa Paula, CABuilt 1974 · S/N 17264125N30189Onguard Aviation LLC · Cottonwood Falls, KSBuilt 1968 · S/N 17701108N3018ZGorman Robert L · Los Gatos, CABuilt 1979 · S/N 28-7916398N30195Palmer Peter L · Mission, TXBuilt 1968 · S/N 17701113N30198Thomas Mark J · Vacaville, CABuilt 1968 · S/N 17701115N3019LWatkins Daniel J · Kennett Square, PABuilt 1983 · S/N 7-0136N3019PNelson Matthew J · Frewsburg, NYBuilt 1957 · S/N 23-928N3019SSmith Jason E · Calliham, TXBuilt 2007 · S/N 4150N3019TDanner Eric C · Benton, KSBuilt 2007 · S/N 23099CN3019YSheets Jeffrey M · Salmon, IDBuilt 1979 · S/N 28-7911148N301ACFlying Squirrel Aviation LLC · Shirley, MABuilt 1995 · S/N 744-95N301AVJackson Charles A · Winchester, KYBuilt 1976 · S/N 28-7715070N301BHTraxler Shane C · West Monroe, LABuilt 1997 · S/N 3246080N301BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020284N301BPPrecision Aviators LLC · Iuka, ILBuilt 1991 · S/N 1983N301CFSunrise Aviation Inc · Ormond Beach, FLBuilt 2002 · S/N 17281135N301DTDawson Taylor Enterprises LLC · Dover, DEBuilt 1998 · S/N 0081N301EHinckley Harry W · Coralville, IABuilt 1989 · S/N 62N301ECF N A Aviation LLC · Wakefield, MABuilt 2025 · S/N 2881980N301EMMcconwell Edward A · Mission, KSBuilt 1965 · S/N 30-916N301FSNadh Development LLC · Santa Rosa, CABuilt 2022 · S/N 1565N301HEN301he LLC · Rehoboth Beach, DEBuilt 1993 · S/N 2382MN301JCGardner Jeffrey · Reno, NVBuilt 1980 · S/N 18267770N301JKKaminski John J · Torrance, CABuilt 1978 · S/N 24-0634N301JRTropitech Inc · San Juan, PRBuilt 1973 · S/N 17261555N301JSOlson Nicholas D · Ankeny, IABuilt 1993 · S/N JS001N301KARivard Robert M · Grand Haven, MIBuilt 1981 · S/N 32R8113020
Back to AD 81-18-04 R2