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.

N64KXBurris-Meyer Peter W · Titusville, FLBuilt 2002 · S/N 20969N64LCDurham Jason K · Springfield, MOBuilt 2004 · S/N 21836N64LRRuth Lawrence J · Roselle, ILBuilt 2015 · S/N 60451N64LTMeyer Thomas R · Double Oak, TXBuilt 2018 · S/N TRM-1N64LZWilson Tony G · Bartlett, TNBuilt 1996 · S/N 1034N64MKraft Ronald S · Albuquerque, NMBuilt 1956 · S/N 23-534N64MCYounger Tyler James · Bakersfield, CABuilt 1995 · S/N 1N64MEShearer John R · The Dalles, ORBuilt 1999 · S/N MS-1N64MHJohafe Aviation LLC · Wilmington, DES/N S2122N64MKCavanaugh Sean M · Ottumwa, IABuilt 1966 · S/N 434N64MMPrins Dennis A · South Lake Tahoe, CABuilt 2001 · S/N 22554N64MSTilko Stanley L Jr · Butler, PABuilt 1973 · S/N 28-7305466N64PCReed Allan T · Danville, INBuilt 1963 · S/N 24-3583N64PDPapa Delta LLC · Eddyville, KYBuilt 1979 · S/N 17272996N64PPG3aero LLC · Chesapeake, VABuilt 1998 · S/N 60007N64PWM&G Aircraft Management LLC · Aurora, ORBuilt 2024 · S/N 172S13212N64RGKrushinski Joseph M · Stafford, VABuilt 1971 · S/N RG163N64RVN64rv LLC · Tahlequah, OKBuilt 2000 · S/N 4033N64SAWilson Cliff · Harrison, IDS/N 002N64SBCrisp Steven J · Chewelah, WAS/N 812N64SDMorrison Brian D · Ferndale, CABuilt 1992 · S/N M20010N64SEBerry Jonathan W · Albuquerque, NMS/N 70628N64SFSafe Flight Instrument Corp · White Plains, NYBuilt 1977 · S/N 17268706N64SHEbersole Scott R · Corralitos, CABuilt 2004 · S/N 001N64SSGriffiths Jon · Carson City, NVBuilt 1975 · S/N 17265345N64SZTotal Aircraft Management Inc · Acworth, GABuilt 1990 · S/N 24-3157N64TBChristensen Phillip · Pensacola, FLS/N 505N64TD377 Supplies LLC · Argyle, TXS/N 30-170N64THRaincross Aviation Services Inc · Wilmington, DES/N 22619N64TLWadsworth Harley C · Albuquerque, NMBuilt 2000 · S/N 21180N64TSLippincott George T · Thermopolis, WYBuilt 1981 · S/N 172RG0959N64TXRegistered aircraftBuilt 2008 · S/N 40378N64TZChapel Hill Flying Club DBA · Sanford, NCBuilt 1981 · S/N 28-8216081N64VCByers Forrest K · Tucson, AZBuilt 2005 · S/N 40229N64VHHealey Richard · Tracy, CABuilt 1995 · S/N 743-95N64VSSignorile Raffaele · Garfield, NJBuilt 2013 · S/N 65-8851N64WCTrahan Stewart K · Little Rock, ARBuilt 1977 · S/N 32-7740095N64WDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1996 · S/N 3246027N64WGM&G Aircraft Management LLC · Aurora, ORBuilt 2021 · S/N 172S12753N64WLLawrence Brian · Seal Beach, CABuilt 1997 · S/N 9612N64WYHoots Husky LLC · Las Vegas, NVFirst renewal noticeBuilt 2012 · S/N 3164N64XPMarshall Greg J · Alexandria, VABuilt 2026 · S/N 42864N64YBRegistration Pending · Wasilla, AKRegistration pendingS/N 30-331N64YUCane Creek Aviation LLC · Asheville, NCBuilt 2004 · S/N 25997N64ZXOros John L · Port Charlotte, FLS/N 404N65001Dornak Henry E Jr · Corpus Christi, TXBuilt 1982 · S/N 17275665N65003Major Air LLC · Charleston, SCBuilt 1982 · S/N 17275666N6500DAztec Adventures LLC · Cape Coral, FLBuilt 1960 · S/N 27-181N6500ERegistered aircraftBuilt 2005 · S/N 10246N6500JHorizon Aviation LLC · Brooks, GABuilt 1968 · S/N 28-4933
Back to AD 81-18-04 R2