OpenAirDocs.org
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.

N450JAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496150N450KSGreene Tammy G · Alpharetta, GAS/N 1978N450MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 4496546N450PMStroede Scott E · King Salmon, AKBuilt 1958 · S/N 22-6206N450RBurns Richard · Wasilla, AKBuilt 2003 · S/N 450RN450RSMcpherson Norman B · Woodland Park, COBuilt 2009 · S/N 60425N450VVCarver Aero LLC · Muscatine, IABuilt 2002 · S/N 4496113N450WMArbuthnot Michael D · Pagosa Springs, COBuilt 1996 · S/N 3125N450ZRCasey William · Celina, TXBuilt 2021 · S/N 2881481N4510AGarvey James R · Fairhope, PABuilt 1956 · S/N 22-3815N4510DCamwhit Air Corp · Montgomery, NYBuilt 1979 · S/N 28-8016015N4510RMcmichael Steven G · Eden, NCBuilt 1979 · S/N 28-8090036N4510YFrost John David Trustee · Anchorage, AKBuilt 1972 · S/N 18-8931N4510ZLamphere Michael T · Whitehall, NYBuilt 1960 · S/N 22-8012N45110Bluebeck Ltd · East Norwich, NYBuilt 1979 · S/N 28-7911294N4511BGcbc LLC · Norman, OKBuilt 1979 · S/N 28-8090037N4511EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271619N4511HVeritas Urbis Economics LLC · Groveland, CABuilt 1978 · S/N 24-0755N4511JNoyes Tony · Lewisville, TXS/N 28R-30367N4511VOraz Aviation LLC · Oregon City, ORBuilt 1979 · S/N 28-7911293N4511YWab Air LLC · Boulder, MTBuilt 1971 · S/N 18-8932N4511ZKim Andrew · Upland, CABuilt 1960 · S/N 22-8013N45128Bowker James K · Ponca City, OKBuilt 1976 · S/N 177RG1093N4512LA&J Aircraft Leasing Inc · Burlington, COS/N 28-8016016N4512RElder Abuse Air Force · Rcho Sta Marg, CAS/N 28-21213N4512XSullivan Bradley · Tomball, TXBuilt 1975 · S/N 28-7625047N4512YNohrenberg Redge O · Pingree, NDBuilt 1966 · S/N 25-4078N45134Last Chance Lance Auto Sales LLC · Ardmore, OKBuilt 1978 · S/N AA5B0627N45135Warren Jeremy D · Bloomington, INBuilt 1978 · S/N AA5B0829N4513DRkm Aviation LLC · Lexington, NCBuilt 1979 · S/N 28-8090038N4513FDeripaska Gary Stanley · Owasso, OKBuilt 1976 · S/N 28R-7635413N4513JMalone Ronald · Englewood, TNBuilt 1968 · S/N 28R-30370N4513NRspp Group LLC · Friendswood, TXBuilt 1978 · S/N AA5B0994N4513RRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1965 · S/N 28-21214N4513YAlbertson James M · Slocomb, ALBuilt 1966 · S/N 25-4019N45141T45141 LLC · Orange, CABuilt 1978 · S/N AA5B1006N4514AJones N Robert II · Indianapolis, INBuilt 1978 · S/N AA5B0998N4514BNiemann Professionals P A · Melbourne Beach, FLS/N AA5B0999N4514FBy The Grace Of God LLC · Miami, FLBuilt 1978 · S/N AA5B1000N4514JTrinity Aviation Ltd · Wilmington, DEFirst renewal noticeBuilt 1968 · S/N 28R-30371N4514NAbc Flying Club Inc · West Mifflin, PABuilt 1978 · S/N AA5B1003N4514VTorelli Bruce L · Memphis, TNBuilt 1978 · S/N AA5B1005N4515DTucker Gary · Youngsville, LABuilt 1978 · S/N AA5B1009N4515LBegich Michael James · Brea, CABuilt 1978 · S/N AA5B1010N4515NAbsarokee Investment LLC · Billings, MTBuilt 1978 · S/N AA5B1011N4515PFlying W Leasing Inc · Bartlett, ILBuilt 1960 · S/N 27-18N4515TSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2002 · S/N 4496115N4515UHendrix William A · Flagstaff, AZBuilt 1978 · S/N AA5B1012N4515YArthur Aviation LLC · Arthur, NDBuilt 1966 · S/N 25-4148N45161Tonry Roger D · Los Angeles, CABuilt 1978 · S/N AA5B1024
Back to AD 81-18-04 R2