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.

N9194DDaniels Daryl A · Warren, OHBuilt 1958 · S/N 22-6253N9194EMoore Weston J · Juneau, AKBuilt 1977 · S/N 7129CN9194JStange Robert C · Toledo, OHBuilt 1966 · S/N 28-3262N9194KHarry Philip · Asheville, NCBuilt 1979 · S/N AA5B-0211N9194LRussell Keith M · Ivoryton, CTBuilt 1971 · S/N 818-72N9194VAlva Aviation LLC · Nacogdoches, TXBuilt 1969 · S/N 690040N9194WWatson Paul F · Galloway, NJS/N 28-10852N9194YBanner Jeffrey D · Grove City, PABuilt 1985 · S/N 28-8511007N9195JLau-Camarena Alvaro · Euless, TXBuilt 1966 · S/N 28-3263N9195KWatson Joseph L Jr · Concord, NCBuilt 1976 · S/N 28-7690227N9195LStatewide Transportation LLC · Oklahoma City, OKBuilt 1971 · S/N 293-72N9195SBailey Thomas P · Cannelton, INBuilt 1975 · S/N MC-368N9195VHunter Robert J DBA · Montgomery, ALBuilt 1969 · S/N 690041N9195WMcguire Aviation LLC · Kalispell, MTBuilt 1967 · S/N 28-10853N91966Wings Over Texas Holdings LLC · Denton, TXS/N 17281616N9196HLaplante Rene J · Bellingham, WABuilt 1975 · S/N 17266008N9196JScarlett Seth T · Omaha, NEBuilt 1966 · S/N 28-3264N9196LRunyon Larry · Susanville, CABuilt 1971 · S/N 294-72N9196SSkyward Leasing Inc · Dallas, GABuilt 1975 · S/N MC-370N9196VScherbarth Kenneth C · Eatonville, WABuilt 1969 · S/N 690051N9196WOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281615N9197BEsteban John G · Dublin, NHBuilt 1993 · S/N 2890192N9197JDifabio Jack F · Newtown, PABuilt 1966 · S/N 28-3265N9197LSchutze Curt K · Knoxville, TNBuilt 1971 · S/N 295-72N9197SEisenhaur Timothy · Wells, MEBuilt 1975 · S/N M-1684N91984A-Line LLC · Kent, WABuilt 1973 · S/N 17261532N9198STolton Grant D · Republic, WABuilt 1975 · S/N M-1712N9198WOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281617N91996Oklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281619N9199AArgos Retail LLC · Mcallen, TXBuilt 1982 · S/N 38-82A0111N9199ZOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281618N919ASchulze Thomas A · Bloomville, OHBuilt 1951 · S/N 22-223N919AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881948N919CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8339N919DBPeterson Scott W · Garfield, KSBuilt 2001 · S/N 1198005N919DCDelaware Corp · Topping, VABuilt 1976 · S/N 177RG1055N919DJPope James D · Lewiston, IDBuilt 2005 · S/N 10644N919EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2019 · S/N 172S12378N919GPRegistration Pending · Fairburn, GARegistration pendingBuilt 1970 · S/N AA1-0390N919HGRegistered aircraftBuilt 2019 · S/N 30062N919JRByrne Ian E · Del Mar, CABuilt 2014 · S/N 70840N919KTAir One Helicopters LLC · Lincoln Park, MIBuilt 2021 · S/N 14457N919LFUnmanned Aerial Research LLC · Freeport, FLBuilt 1978 · S/N AA5B0913N919PMRegistration Pending · Atmore, ALRegistration pendingBuilt 1999 · S/N 001N919RFRegion Flyers LLC · Valparaiso, INBuilt 1981 · S/N 28-8216062N919RVSamadhi Clear Mind Yoga Retreat LLC · San Marcos, TXBuilt 2016 · S/N 72328N919TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 2000 · S/N 17280843N919TCD & S Aviation LLC · Spring, TXBuilt 2005 · S/N 172S10019N919UAKarably David P · Earleton, FLS/N 24-1720N919ZHouse Charles D · Tunkhannock, PABuilt 1965 · S/N LPK-1
Back to AD 81-18-04 R2