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.

N6137WPrepmasters Inc · Boynton Beach, FLS/N 28-20134N61385Grady Will M · Gallatin, MOBuilt 1992 · S/N 4107CN6138VGlover Michael M · Mechanicsville, VABuilt 1968 · S/N 28-23988N61398Ali Rizwan Rajab · Richmond, TXBuilt 2008 · S/N 18282066N6139AN6139a Corp Trustee · Wilmington, DEBuilt 1990 · S/N 10079CN6139LGdg LLC · Lewes, DEBuilt 1970 · S/N AA1-0339N6139MKelly David M · Issaquah, WAFirst renewal noticeBuilt 1980 · S/N 15284630N6139WFleetwood James D · French Lick, INBuilt 1964 · S/N 28-20157N613ADhs Operations LLC · Wilmington, DEBuilt 1997 · S/N 17280248N613ACBas Part Sales LLC · Greeley, COBuilt 2014 · S/N 2843757N613AMW & A Flight LLC · Greenville, SCBuilt 2004 · S/N 20-1038N613APThomas Lucas G · Beebe, ARBuilt 1976 · S/N 190-76N613ARHigh Plains Heli LLC · Texico, NMBuilt 2025 · S/N 1393N613BKMaxwell Roy J · Kenai, AKBuilt 1948 · S/N 1084795N613EHart David E · Bartlett, TNBuilt 1984 · S/N CRC-3N613FPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N 39-45N613FLOwens William N · Lexington, NCBuilt 1971 · S/N 28-7125492N613KBPrecision Aero LLC · Wilmington, DEBuilt 1999 · S/N 835-99N613LCostigan George J · Nashua, NHBuilt 2016 · S/N 40434N613LGRidgeline Assets LLC · Wilmington, DEBuilt 2002 · S/N 172S9252N613PCPrivitt Bret J · Forest Hill, TXBuilt 1999 · S/N 1255-98N613RBFly Amphibious Aircraft LLC · Tampa, FLS/N 22N613RVFlege Jordan T · Morrow, OHBuilt 2000 · S/N 80266N613SCMorgan John P · Atlanta, GABuilt 1994 · S/N 1N613SPAirmart Inc · Lexington, KYBuilt 2000 · S/N 172S8597N613VTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1986 · S/N VERMONT 0001N613XEMalinchak Louis · Bristow, OKBuilt 2007 · S/N 270N6140EIorio Jeffrey M · Tucson, AZBuilt 1958 · S/N 46240N6140JWeldy Mark L · Etna Green, INBuilt 1976 · S/N 28-7615311N6140KHepner Glenn L · New Port Richey, FLBuilt 1980 · S/N 17274169N6140PBrake It LLC · Pensacola, FLBuilt 1959 · S/N 24-1241N6140WKing Donna K · Mount Pleasant, MIBuilt 1964 · S/N 28-20158N6140ZConnecticut Soaring Association Inc · New London, CTS/N 25-164N61411Vincent Tarissa · Westminster, COS/N 1151N6141JRnt Air LLC · Mitchell, SDBuilt 1976 · S/N 28-7615312N6141LJohnson Stephen M · Westlake, TXBuilt 1970 · S/N AA1-0341N6141PRs Agricultural Operations LLC · Dell City, TXS/N 24-1242N6141TMilligan David L · Fresno, CAFirst renewal noticeBuilt 1982 · S/N R18201918N6141VWright Lawrence D · West Chester, PABuilt 1965 · S/N TD-614N6141ZRotor And Wing · Tioga, NDBuilt 1960 · S/N 25-165N61422Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13087N6142DManbeck Michael R · Summerville, SCBuilt 1957 · S/N 22-4786N6142PAllison Trent Van · Southlake, TXBuilt 1959 · S/N 24-1243N6142SKelly Robert D · Sheboygan, WIFirst renewal noticeBuilt 1965 · S/N 18-50N6142WBurns Robert J · Loxahatchee, FLBuilt 1964 · S/N 28-20160N6142XHurt Ronald L · Smithville, TNBuilt 1977 · S/N 17269169N6143NTorikawa Domingojason K · Ewa Beach, HIBuilt 1969 · S/N MB-414N6143QSt Onge Andre E · Hooksett, NHBuilt 1981 · S/N 15285166N6143TWong Antonio L · Santa Rosa, CAS/N R18201919N61447Overton Tommy · Cumberland Gap, TNBuilt 1995 · S/N 0007
Back to AD 81-18-04 R2