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.

N919ZATextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 172S13350N91ABMac Services Of Ocala LLC · Ocala, FLBuilt 1991 · S/N 2423N91AHMgp Enterprises LLC · Gainesville, FLBuilt 2020 · S/N 3352N91ANWright William B · Holland, PABuilt 2003 · S/N 90229N91ARBarrier Gary W · Mount Pleasant, NCBuilt 1983 · S/N 7446CN91BLLloyd Aviation LLC · Spring Branch, TXBuilt 1988 · S/N 764N91BSDt Aviation LLC · Bountiful, UTBuilt 1999 · S/N 1076N91CGRick Jelinek Trucking Inc · Palmyra, WIBuilt 1964 · S/N 28-20214N91CKBurril Benjamin D · Locust, NCS/N 20883N91CMNoyes John Paul · Kalispell, MTBuilt 2003 · S/N 21236N91CNBroecker Keith A · Roseville, CABuilt 1992 · S/N 20284N91CPBas Part Sales LLC · Greeley, COS/N 24-0694N91CUSampson Gabriel · Huntsville, UTBuilt 2023 · S/N 3425N91CXValiair Ltd Co Trustee · Casper, WYBuilt 1992 · S/N 566N91CZZavatson Christopher J · Woodland, CABuilt 1997 · S/N 899-320-740N91DHHildreth Jon R · Spencer, WVBuilt 2004 · S/N 20027N91DTSantimaw James · Goodyear, AZBuilt 2003 · S/N 70033N91DWHarlow James Patrick · Liberty Hill, TXBuilt 1967 · S/N 28-10857N91EBHoldsworth Randy L · Zoar, OHBuilt 1998 · S/N 80222N91EENorthern Tier Private Investg & Security Cnslg Inc · Towanda, PABuilt 1982 · S/N 28-8390005N91EMFrazeur Matthew · Aromas, CAS/N 1773N91ETAnchor Aviation LLC · Myrtle Beach, SCBuilt 1979 · S/N 32R-7985083N91EWToussaint David F · Lakeville, MNS/N WA-30N91FAAdams Kenneth J · Marana, AZS/N 1758N91FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12951N91FHP3 Aviation Services LLC · Wilmington, DEBuilt 1991 · S/N 2033N91FNScheck Christopher R · Troutdale, ORBuilt 2006 · S/N 90787N91FTLegassey Matthew G · Millinocket, MEBuilt 1966 · S/N 107N91GBBettis Gary W · Bakersfield, CABuilt 2011 · S/N 064N91GCSilver Bear Transport LLC · Santa Ana, CABuilt 2011 · S/N 40.1128N91GFNew Mexico Dept Of Game And Fish · Santa Fe, NMBuilt 2009 · S/N 454-10/OTCN91GGKlarich Richard S · Louisville, KYBuilt 2004 · S/N 25628N91GKKearns Gary W · New Athens, ILBuilt 2008 · S/N 70184N91HAHoneybee Air LLC · Newark, NJBuilt 2000 · S/N 18280913N91HBSale Reported · Hickory, NCSale reportedBuilt 1985 · S/N 2004N91HLWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1982 · S/N 15285648N91HUSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2017 · S/N 3291N91HWNortheast Cubs LLC · Wilmington, DEBuilt 2018 · S/N 2537N91HYPeterson Daniel · Healy, AKBuilt 2004 · S/N 2269N91JCAdams Rodney M · Garner, NCBuilt 1990 · S/N 1357N91JFYohe Kent David · Dallas, TXBuilt 1998 · S/N 2977N91JHShatz Randy S · Prescott, AZBuilt 1978 · S/N 7238CN91JVJv Aviation Group Inc · La Puente, CABuilt 1976 · S/N 28-7615117N91JWDash Marilyn · Sparks, NVS/N 1-0023N91KRLandry James J · Simi Valley, CABuilt 2003 · S/N 2240N91KWLavell Michael J · Blue Mounds, WIBuilt 1997 · S/N 1354N91LCBowersox Kenneth D · Houston, TXBuilt 2005 · S/N 40.FC002N91LEElders Lawrence Cl · Deland, FLBuilt 2012 · S/N 25018N91LHHammer Bruce C · Lafayette, LABuilt 1997 · S/N 549N91LJPullum Kevin W · Goddard, KSBuilt 1992 · S/N 1
Back to AD 81-18-04 R2