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.

N8980YTomu Fly LLC · Vero Beach, FLS/N 39-146N89811Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1983 · S/N 17276013N89812Fremont Aviation Inc · Fremont, NEBuilt 1978 · S/N 15282879N89815Pinnacle Aviation Services Inc · Encinitas, CABuilt 1978 · S/N 15282881N8981AAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1978 · S/N 32-7840190N8981RBlock Raymond J · Palmer, AKS/N 7GCB-10N8981YGrey Enterprises Holdings LLC · Kalispell, MTBuilt 1972 · S/N 39-138N8982DNorth Sound Aviation Inc · Sedro Woolley, WABuilt 1958 · S/N 18-6377N8982RBoo Steven R · Chisago City, MNBuilt 1960 · S/N 7GCB-15N8982VHirsch John K Trustee · Gerald, MOBuilt 1974 · S/N 17264338N8982WTorres Lewis A · Pasadena, CABuilt 1966 · S/N 28-10815N8982YCovington James P · Poplar Grove, ILBuilt 1972 · S/N 39-147N8983JStensrud Maynard R · Waseca, MNBuilt 1966 · S/N 28-3006N8983LSale Reported · Austin, TXSale reportedBuilt 1974 · S/N AA1B-0433N8983PBlum Kenneth J · Truckee, CABuilt 1966 · S/N 24-4442N8983VMoon Reagan E · Bossier City, LABuilt 1974 · S/N 17264339N8984CBaldwin Alexander L · Saint Charles, MOBuilt 1953 · S/N 22-1560N8984JKlassen Wayne V · New Ulm, MNBuilt 1965 · S/N 28-3007N89859Hess Garrett J · Fullerton, CABuilt 1978 · S/N 15282894N8985WKeskintepe Levent · Las Vegas, NVBuilt 1964 · S/N 28-10564N89863Ruess Richard M · Anchorage, AKBuilt 1978 · S/N 15282896N89869Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282897N8986JKleinberg Kenneth A · Saugerties, NYBuilt 1965 · S/N 28-3009N8986LHenrichs Jason · Pearland, TXBuilt 1974 · S/N AA1B-0436N8986RYarbanton John Robert · Muskegon, MIBuilt 1960 · S/N 7GCB-16N8986VAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1974 · S/N 17264342N8986WCandler Derrick · Tampa, FLBuilt 1964 · S/N 28-10565N89877Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282900N89878Corwin Shawn M · Tucson, AZBuilt 1983 · S/N 17276015N8987LScholten John E · Marne, MIBuilt 1974 · S/N AA1B-0437N8987VPiper Capital Growth Fund LLC · Scottsdale, AZBuilt 1974 · S/N 17264343N8987WSonrise Aviation LLC · Lake Havasu City, AZBuilt 1964 · S/N 28-10566N8987YHanson William D · Soldotna, AKBuilt 1974 · S/N 18-7409132N89881Fulton Gene · Spartanburg, SCBuilt 1978 · S/N 15282903N89887Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15282904N8988CEastin Toby M · Jefferson City, MOS/N 22-1566N8988JMerkle Hunter T · Mattawa, WABuilt 1966 · S/N 28-3011N8988RYoung Andrew J · Eagle River, AKBuilt 1960 · S/N 7EC-732N8988VWahle Daniel C · Missoula, MTBuilt 1974 · S/N 17264344N8988WGonzaga Michaelr · Chino Hills, CABuilt 1965 · S/N 28-10567N8989JJohnston Family Clinic Inc · Meridian, MSS/N 28-3012N8989XCascadia Aircraft LLC · Sandpoint, IDBuilt 2016 · S/N 001N898AMyers D M · Vancouver, WARevoked, canceledBuilt 1951 · S/N 22-202N898AMWyatt LLC · Hot Springs, SDBuilt 1998 · S/N 1427N898ATCxk1 LLC · Wilmington, DEBuilt 2026 · S/N 4496630N898DANopat LLC · North Charleston, SCBuilt 2000 · S/N 2843377N898DKPratt Christopher J · Dallas, TXBuilt 2005 · S/N 80898N898GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881470N898JRKokosa Vernon R · Dennis, MABuilt 1975 · S/N AA5-0706N898JWWeiswasser Jonathan M · Montclair, NJBuilt 2004 · S/N 81639
Back to AD 81-18-04 R2