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.

N926CAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 2881040N926CKFly By Numbers LLC · Tallahassee, FLBuilt 1976 · S/N 28-7690327N926CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8914N926CRAero Tech Services Inc · Lititz, PABuilt 2020 · S/N 172S12537N926DGPerkins James W · Georgetown, TXBuilt 2000 · S/N 20473N926DKSuthar Jay P · Danville, VABuilt 2002 · S/N 22867N926EZEcho Zulu LLC · Middletown, DES/N HSLE 2-95N926GG2 Aviation LLC · Franklin, WIBuilt 2017 · S/N 41141N926JAMustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10926N926JGGutwein Jan · Venice, FLBuilt 2005 · S/N 024-39/40-680N926JPJl Aviation LLC · Crestwood, KYBuilt 2004 · S/N 490-2004N926MKToothman John C · Fairmont, WVBuilt 1971 · S/N 28-7125138N926MMGurewitz Alan · Thousand Oaks, CABuilt 2003 · S/N EP-01-80809N926MNPtw Consulting LLC · Atlanta, GABuilt 1971 · S/N 17260325N926NLRemington Robert J · Sheboygan Falls, WIS/N 172S8812N926PACoco Aircraft Inc · Merritt Island, FLBuilt 1999 · S/N 2843289N926RUPottratz Dwane L · Beaverton, ORBuilt 1998 · S/N 23327N926TCTango Charlie LLC · Gig Harbor, WABuilt 1997 · S/N 18280052N926TEAnderson & Associates Inc · Little Rock, ARBuilt 2002 · S/N 10205N926TMSwanson Richard E · Livermore, COBuilt 2008 · S/N 72184N926WBBender Walter F Jr · Virginia Beach, VABuilt 2000 · S/N 18280819N926WTArmadillo Aviation LLC · Scottsdale, AZBuilt 2002 · S/N 60587N92704Gull Wing Flight LLC · Pt Pleas Bch, NJBuilt 1973 · S/N 17261605N9270DDowns Dennis D · Sterling, AKS/N 18-6569N9270KSlc Service Leasing Company LLC · Tipton, IAFirst renewal noticeBuilt 1974 · S/N 28-7410027N9270MMcmanus Nicholas A · Versailles, KYBuilt 1966 · S/N 1211N9270SVinson Raymond R III · Mckinney, TXBuilt 1975 · S/N MC-392N9270VPhilippi Harrold Mark · Metairie, LABuilt 1969 · S/N 690073N92713Laughter John Eric · Brookhaven, GABuilt 1946 · S/N 12-148N92719Mood Glen M · Ward Cove, AKBuilt 1946 · S/N 12-155N9271DGrasser Edward K · Palmer, AKBuilt 1958 · S/N 18-6572N9271MCantelmi Richard L · Bethlehem, PABuilt 1966 · S/N 3459N9271RUpwind Aviation LLC · Mitchell, SDBuilt 1978 · S/N R18200676N9271SLife Is A Beech LLC · Commerce City, COBuilt 1976 · S/N M-1757N9271WMcelwee Jerilyn · South Riding, VABuilt 1967 · S/N 28-10944N92720Registration Pending · Champaign, ILRegistration pendingS/N 17261608N92722Bryant David A · Walhalla, SCBuilt 1973 · S/N 17261609N92727Routh David A · New Richland, MNS/N 12-163N9272DMummy Mountain Med LLC · Paradise Valley, AZBuilt 1958 · S/N 18-6573N9272HBlackbird 71 LLC · Rockford, ILBuilt 1975 · S/N 17266060N9272JEast Fork Flyers LLC · Lu Verne, IABuilt 1966 · S/N 28-3350N9272LValira Aviation II LLC · Oakland, CABuilt 1997 · S/N 2843077N9272MSearle Jacob · Kuna, IDBuilt 1966 · S/N 3460N92731Plane@Work LLC · Blaine, MNBuilt 1946 · S/N 12-167N92732Hagman Jeffrey W · St Bonifacius, MNBuilt 1946 · S/N 12-168N92733Airborne Extreme LLC · Wasilla, AKBuilt 1946 · S/N 12-170N92736Larkin Marion J · Salome, AZBuilt 1946 · S/N 12-173N9273BAll-In Aviation LLC · Fort Myers, FLBuilt 1996 · S/N 3246035N9273JWhite Raymond · Jasper, ARBuilt 1966 · S/N 28-3351N9273PNormark Nancy B · Weirsdale, FLBuilt 1972 · S/N 18-8994
Back to AD 81-18-04 R2