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.

N25271Byrnes Daniel P · Anchorage, AKS/N 15280564N25278Winterton Phillip C · Tucson, AZS/N 1001N2527DSidders Michael E · Big Lake, AKS/N 20679N2527PSprenger Michael D · Juneau, AKBuilt 1955 · S/N 22-2890N2527UDeljanovan Trucking LLC · Roaring Branch, PABuilt 1979 · S/N 28-8090050N2528Morrison Garrett B · Lodi, CABuilt 2016 · S/N 7149N25284Riverside Flight Center Inc · Tulsa, OKBuilt 1977 · S/N 15280572N25286Recreational Enterprises LLC · Sanford, FLS/N 15280573N25287Greenwood John R · Bellevue, NEBuilt 1980 · S/N 38-80A0107N2528AEhrhart Philip J · Narvon, PABuilt 1952 · S/N 22-836N2528BMankowski Luke Ray · Granbury, TXBuilt 1978 · S/N 38-79A0110N2528EMr Dent Inc · Manheim, PAS/N 869N2528SScola Kevin M · Marshfield, MABuilt 1979 · S/N 18-7909153N2528UPensacola Navy Flying Club · Pensacola, FLBuilt 1979 · S/N 28-8090051N2529FEvanson Scot A · Monroe, TNBuilt 1965 · S/N 149N252AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281185N252AXFrequency Change Aviation Services Inc · Nashville, TNBuilt 2004 · S/N 40.392N252CERegistration Pending · Springtown, TXRegistration pendingBuilt 2003 · S/N 4166N252CMRouse Peter L · Parkville, MOBuilt 1996 · S/N 4002N252CWNelson Shalom Z · Washington, DCBuilt 2004 · S/N 31N252DZBernardo Mark · Middleton, MABuilt 1978 · S/N AA5B0736N252ECClear Sky Ag Services LLC · Arapahoe, COBuilt 1969 · S/N 28-25277N252EJJohnson Eldridge Jr · Chicago, ILBuilt 1997 · S/N 18280044N252EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13286N252ERBeaurayne Holdings LLC · Prairieville, LABuilt 1978 · S/N 17271635N252GBrewster King Smith Jr · Gilbert, AZBuilt 1969 · S/N 28-26191N252GRMacvey Troy R · Milan, INBuilt 2017 · S/N W7N252JRJrr LLC · Fort Lauderdale, FLS/N 18282378N252KWWalker Keith A · Brighton, MIBuilt 2001 · S/N 2325N252MDFreeman Edward B · Killeen, TXBuilt 1993 · S/N 4001N252MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881444N252MTAero Quest LLC · Olive Branch, MSBuilt 1977 · S/N 15280407N252PGHard Rock Milling LLC · Spring Branch, TXBuilt 2010 · S/N 60225N252RWatkins John Jr · Summerfield, NCBuilt 1977 · S/N 32R-7780175N252RAReynolds Darryl G · Wills Point, TXBuilt 1977 · S/N 17269911N252SBRoberts Christopher E · Anchorage, AKS/N 17270764N252SFConlisk Christopher M · Hephzibah, GABuilt 2007 · S/N 66285N252SMFlying Scot LLC · Raleigh, NCBuilt 2023 · S/N 18283232N252SPSkysuite Aviation LLC · Tujunga, CAS/N 172S8228N252STEl-Li Copter Associates LLC · Spring Valley, WIBuilt 2007 · S/N 2116N252SZMitchell Jeff · Reno, NVBuilt 2006 · S/N 5705N252TJanssen Jerry D · Barnesville, MNBuilt 1953 · S/N 18-2366N252TTRex Ron · Ocala, FLBuilt 2015 · S/N 1208N252UWyatt Gregory P · Cheyenne, WYBuilt 2001 · S/N 2143N252WCMosier Paul L · Ventura, CABuilt 1979 · S/N 15284145N252WYWarner Robins Air Service Inc · Cochran, GABuilt 2016 · S/N 3252N252YUltimatetoweds LLC · Sedalia, MOBuilt 2018 · S/N 3309N252ZMason Jerry J · Lebanon, ORBuilt 1965 · S/N JM-1N25301Southern Arkansas University Technical Branch · Camden, ARBuilt 1977 · S/N 15280581N25302Steiner Jason A · Sabetha, KSBuilt 1977 · S/N 15280582
Back to AD 81-18-04 R2