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.

N2359QBean Glen A · Damascus, ORS/N M-428N2359TChopco Ltd · Columbus, OHS/N 2359N2359UUden Plumbing & Heating Inc · Grand Island, NES/N 28-7911305N2359YWadsworth Edwin Allen · Sarasota, FLBuilt 1967 · S/N 17700159N235ACLetourneau University · Longview, TXBuilt 2005 · S/N 1394-2005N235AKJain Arun J · Palmer, AKBuilt 1983 · S/N 7448CN235ALStinair LLC · Millville, CABuilt 2000 · S/N 23067CN235AUNorcross Ashley S · Anchorage, AKS/N 22-9772N235AZSchlenker David D · Marine St Crx, MNBuilt 1980 · S/N R18201658N235BBMidland Truss Inc · Wagener, SCBuilt 1973 · S/N 28-7410048N235BDDondi Beda C · Fort Lauderdale, FLBuilt 2011 · S/N 1686NN235BGMcdonald Russell · Rock Island, WAS/N 18002CN235BKWagner Nathan D · Dane, WIBuilt 1998 · S/N 011N235BPPaulson Brent Linn · Henderson, NVBuilt 1966 · S/N 2810776N235CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13084N235CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881504N235CFNathans David · Chambersburg, PABuilt 1963 · S/N 28-10155N235CLAtomic 235 LLC · Irvine, CABuilt 1991 · S/N 70N235CMReed Michael · Chino Hills, CAS/N 32-786N235CPVee Christopher Shawn · East Bethel, MNBuilt 1976 · S/N 28-7610076N235CRRegistration Pending · Killeen, TXRegistration pendingBuilt 1973 · S/N 28-7310099N235CWGreen Michael L · Midlothian, VAS/N 18009CN235DAMarc Aircraft Holding LLC · Soldotna, AKS/N 27-582N235DBDelledera Steven D · Livermore, CABuilt 1966 · S/N 28-10722N235DEAcro Aviation LLC · Littleton, COBuilt 1948 · S/N 108-4566N235DGProp Air Inc · Allen Park, MIBuilt 1969 · S/N 28-11097N235DMDouble W Air LLC · Salt Lake City, UTBuilt 1978 · S/N 7247CN235ECMoore Dylan D · Lakeville, MABuilt 2011 · S/N 1001N235EDBeggs Kevin Robert · Lincolnton, GABuilt 1963 · S/N 28-10097N235EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13099N235ESQualitair LLC Trustee · MichelstadtBuilt 2000 · S/N 18046CN235FPoirot Steven James · Anchorage, AKBuilt 1967 · S/N 28-10875N235FBFlorida Power And Light · West Palm Beach, FLBuilt 2021 · S/N TRC0001N235FSOehmke Adam A · Camarillo, CABuilt 1988 · S/N 4052CN235FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 1989 · S/N 2841285N235GHHunter Gary A · Lake Jackson, TXBuilt 1984 · S/N 1855N235HBabin Richard T · Arnold, MDBuilt 1973 · S/N 28-7310176N235HP235hp LLC · Norwood, NCBuilt 1998 · S/N 18280333N235JKDetert Bradley · Valparaiso, INBuilt 1963 · S/N 27-587N235JTWings And Prop LLC · Montgomery, TXBuilt 1963 · S/N 28-10080N235JWMax Power Aircraft LLC · Kenosha, WIBuilt 2008 · S/N 059N235KMckinney Steve R · Hamersville, OHBuilt 2005 · S/N 2N235LHMaupin Dean C · Davenport, IABuilt 2001 · S/N 80844N235LKCluff Dustin · Saint Helens, ORS/N 128N235LWWatkins James R · Granbury, TXBuilt 1964 · S/N 28-10536N235MAMorgantown Aero Corporation · Elverson, PABuilt 1967 · S/N 28-10867N235MERegistered aircraftBuilt 2000 · S/N 18280753N235MHCharlie Papa LLC · Las Vegas, NVS/N 28-10553N235MJWanner Robin · Lufkin, TXBuilt 2004 · S/N 85-04N235MKWright Curtis B · Roy, UTBuilt 2003 · S/N 9904-0183
Back to AD 81-18-04 R2