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.

N823NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881162N823PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881250N823PBBrown Scott · Aguanga, CABuilt 1979 · S/N 49N823PPPsm Aviation LLC · Lewes, DEBuilt 1975 · S/N M-1650N823RMRegistration Pending · Las Vegas, NVRegistration pending, pending cancellationBuilt 1977 · S/N 35N823RSBearhawk Ventures LLC · Plano, TXBuilt 2025 · S/N ZJ70482RN823RVScott J Pias · Raleigh, NCS/N 81368N823SHBlue Air Training Corp · Las Vegas, NVBuilt 1975 · S/N 12N823SPUberti Christopher · Brighton, MIBuilt 1976 · S/N 24-0003N823SSArchipelago Immobilien LLC · Jacksonville Beach, FLBuilt 2000 · S/N 0001N823SWMiley Gregg E · Melba, IDBuilt 2000 · S/N 24000N823TABlue Air Training Corp · Las Vegas, NVBuilt 1981 · S/N 71N823TRAirknocker Inc · Wilmington, DEBuilt 2013 · S/N 11487N823WLigon Robert E III · Warner Robins, GABuilt 1976 · S/N 25N823WTHillerman David A · Denair, CABuilt 1976 · S/N 24N823YHoyt Charles · Wadsworth, OHBuilt 1982 · S/N 06N82405Womack Bert E · Anchorage, AKBuilt 1979 · S/N 18-7909096N8240CLewis Jonathan · Hadley, MABuilt 1954 · S/N 22-2326N8240DLindee Justin T · Owatonna, MNBuilt 1980 · S/N 28-8011125N8240ESimplelife Skys LLC · Van Buren, ARBuilt 1980 · S/N 28-8011126N8240NStein Kenneth A · Rapid City, SDBuilt 1969 · S/N 28-25448N8240PForsgren Keith · Wasilla, AKBuilt 1963 · S/N 18-8045N8240WGeiger Nathaniel · Omaha, NES/N 28-2383N8241CL & S Aircraft Holdings LLC · Yukon, OKBuilt 1975 · S/N 28-7690109N8241GSilvers Clarence W III · Holden, MOBuilt 1971 · S/N 177RG0141N8241PRegistered aircraftBuilt 1963 · S/N 24-3495N8241WLuckey Jeffrey E · Camarillo, CABuilt 1965 · S/N 28-2385N8241ZInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316079N82422Bishop Boyd · Gillette, WYBuilt 1979 · S/N 18-7909098N82423Aeronautical Development LLC · Richland, MIBuilt 1980 · S/N 28-8011127N82424Skow Perry M · Harrison, IDS/N 18-7709163N8242GValdez Acela Rangel · Maricopa, AZS/N 177RG0142N8242NBrezina Douglas P · Broadview, ILBuilt 1969 · S/N 28-25450N8242PLake Donald T · Green Valley, AZFirst renewal noticeBuilt 1963 · S/N 24-3496N8243EMacon Air LLC · Franklin, NCBuilt 1979 · S/N 17272155N8243GGebauer David Lee · Jackson, CABuilt 1971 · S/N 177RG0143N8243PMountain Mooney Inc · Idaho Falls, IDS/N 24-3497N8243WHill Andrew M · Spokane, WAS/N 28-2389N8243YHampton Brent · Edgewood, TXBuilt 1966 · S/N 30-1369N82443Dolat Jacqueline M · Kenai, AKBuilt 1977 · S/N 18-7709166N82448Fejes Guide Service Ltd · Anchorage, AKBuilt 1979 · S/N 18-7909099N8244GHughes Jeffrey D · Roseburg, ORBuilt 1971 · S/N 177RG0144N8244JTonys Aerial Service Inc · Great Bend, KSBuilt 1979 · S/N 61P06487963299N8244PWright Russell · Ocala, FLBuilt 1964 · S/N 24-3499N8244QAeroplane Co LLC · Sylvania, OHBuilt 1980 · S/N 44-8107011N8244SExtreme Helicopter Service LLC · Alice, TXBuilt 1994 · S/N 2430N8244UFaherty Michael F · Greensboro, NCBuilt 1980 · S/N 28-8016371N8244VVaughn Anthony D · Monticello, KYBuilt 1980 · S/N 32-8006063N8244XDestiny Ministries International Inc · Kissimmee, FLS/N P648RN8244YDow Jeff · Port Hadlock, WABuilt 1965 · S/N 30-917
Back to AD 81-18-04 R2