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.

N4237TPeak 2 Peak Enterprises LLC · Sebring, FLS/N 28-7225101N4237ZYorgason Ty C · Worland, WYS/N 18-8464N42388Mccaan Jerome · Bethel, MEBuilt 2003 · S/N 27009CN4238CSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1965 · S/N EPC-155N4238FAviation Trust Company LLC · Oklahoma City, OKBuilt 1976 · S/N 28-7715010N4238MRobinson Eric C · Palmer, AKBuilt 1947 · S/N 12-3134N4238QFisch Markus J · Rock Falls, ILBuilt 1971 · S/N 17260138N4238TChopper Aviation LLC · Cahokia Heights, ILBuilt 1971 · S/N 28-7205111N42396Lawrence Jack C Jr · Saint Augustine, FLBuilt 1990 · S/N EPC-161N42399Reece Rebecca H · San Angelo, TXS/N 14658N4239HGray Steven Don · Tualatin, ORBuilt 1978 · S/N 24-0678N4239POneal Hollis R · Deridder, LABuilt 1959 · S/N 23-1737N4239QElizabeth City State University · Elizabeth City, NCS/N 17260139N4239WSmith James W · Newtown, CTS/N 21079CN4239ZLsk Aviation Corp · Wilmington, DEBuilt 1966 · S/N 18-8466N423ATWillcutt Air Tax LLC · Vicksburg, MIBuilt 1978 · S/N 14391N423CAAerochatt LLC · Cleveland, TNBuilt 2015 · S/N 172S11612N423CFMiller Lyndon J · Georgetown, TXBuilt 2008 · S/N 001N423CKBounds Keith A · Thomson, GABuilt 1981 · S/N 44-8107036N423CMHurricane Creek Flying Club LLC · Walla Walla, WABuilt 2000 · S/N 20608109N423CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 4496439N423CZRutan Aircraft Flying Experience · Waller, TXS/N 423N423DKOliveira Avelino Da Mota · Aventura, FLBuilt 1981 · S/N R18201809N423DMGga N423dm LLC · Glendale, AZBuilt 1969 · S/N 28-25683N423EWings Over Texas Holdings LLC · Denton, TXBuilt 2014 · S/N 172S11447N423FLIglewski David W · Muskego, WIBuilt 1971 · S/N 28-7125204N423FPUtah State University · Logan, UTBuilt 2006 · S/N 40.FC023N423JAGiegler Bernard · Cypress, TXBuilt 2002 · S/N 60241N423JCPeterson Daniel R · Riverview, FLBuilt 1967 · S/N 28-3922N423JWSkeens Gregory Jr · Encinitas, CAS/N 32-7840163N423LCYabsley Richard A · Santa Barbara, CABuilt 2017 · S/N 517RN423PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843463N423PWBeggs Pat · Salem, ORBuilt 2018 · S/N CC19-0039N423RElint Technology Inc · Gulf Breeze, FLBuilt 1981 · S/N 32R-8213023N423RVIndy Air Sales LLC · Anderson, INBuilt 1991 · S/N 1023N423SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12542N423SPSierra Papa LLC · Salt Lake City, UTBuilt 2000 · S/N 172S8352N423TSandpoint Aviation LLC · Sandpoint, IDBuilt 2003 · S/N 43N423TABas Part Sales LLC · Greeley, COBuilt 2003 · S/N T18208208N42404Millennium Airways LLC · Valencia, CABuilt 1974 · S/N 28-7415391N4240HSorensen Michael J · Mayer, MNBuilt 1948 · S/N 14-42N4240JBillings Christopher · St Johns, FLBuilt 1967 · S/N 28-22593N4240QPerry Nicklette Knight · Port Arthur, TXBuilt 1971 · S/N 17260140N4240TBlankenbijl Eric J · Grapeview, WAS/N 28-7205112N4240XMaule Group LLC · Danbury, CTBuilt 1999 · S/N 30004CN4240ZLoomer Orville C · Buffalo, WYS/N 18-8467N42415Barron Texas Holdings LLC · Sheridan, WYS/N EPC-162N4241HSkinner James A · Anchorage, AKS/N 14-44N4241JImmen David F · Bonanza, ORBuilt 1967 · S/N 28-22594N4242GMaritz Paul A · Mercer Island, WABuilt 2000 · S/N 867-2000
Back to AD 81-18-04 R2