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.

N61761Hawk Aviation Inc · Rush City, MNBuilt 1975 · S/N 17264782N61763Bortoto Da Silva Alexandre · Fort Lauderdale, FLBuilt 1975 · S/N 17264784N61764Wohlgemuth Terry D · Squaw Valley, CABuilt 1994 · S/N 1N61765Dean Mark T · Van Alstyne, TXBuilt 1975 · S/N 17264785N61769Jackson Lynn B · Cocoa Beach, FLBuilt 1975 · S/N 17264787N6176DSawyer Stephen W · Brigham City, UTBuilt 1957 · S/N 22-4823N6176GGaruda Flight Training LLC · Miami, FLBuilt 1979 · S/N 17273575N6176JWertz Joseph S Jr · Shoemakersville, PABuilt 1976 · S/N 28-76-15321N61770Mwbw LLC · Shawano, WIBuilt 1975 · S/N 17264788N61772Henry Donald R · Lake Stevens, WABuilt 1975 · S/N 17264789N61778Cambridge Valley Flying Club Inc · Shushan, NYBuilt 1975 · S/N 17264793N6177NDesmarais Dan · Soldotna, AKBuilt 1993 · S/N 839N61780Delaney Kevin P · Germantown, TNBuilt 1975 · S/N 17264794N61783Copper River Airmotive LLC · Copper Center, AKBuilt 1975 · S/N 17264797N61785Fort Sam Houston Flying Club · San Antonio, TXBuilt 1975 · S/N 17264799N61786Northwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 17264800N61789Padilla Frank J · Vacaville, CAS/N 17264802N6178PFolse Eldred J · North Las Vegas, NVBuilt 1959 · S/N 24-1280N61794Dm Asset Management LLC · Plain City, OHBuilt 1975 · S/N 17264807N61799Flf Aviation LLC · West Columbia, SCBuilt 1975 · S/N 17264810N6179HCriss Enterprises LLC · Titusville, FLBuilt 1979 · S/N 15284139N6179PHarris Robert C · Spring Hill, FLS/N 90849N6179RMcclinton Charles R · Cape Coral, FLBuilt 1979 · S/N 172RG0104N617ARReeves Douglas G · Lewisville, TXBuilt 2002 · S/N 24968N617AVSouthern Aviation Ga LLC · Anchorage, AKFirst renewal noticeBuilt 2016 · S/N GA8-16-230N617CMGravatt Eric Kenneth · Ammon, IDBuilt 1967 · S/N 28-10899N617DGFournier Jean Paul R · Ocala, FLBuilt 2003 · S/N 60185N617DRRadford David M · Glen Cove, NYBuilt 2018 · S/N 4791N617EMarsh Michael B · Freeland, MIBuilt 2013 · S/N 75-8234N617EPEpic Aviation Inc DBA · New Smyrna Beach, FLBuilt 2017 · S/N 172S12042N617EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12717N617FGRidgeline Assets LLC · Wilmington, DEBuilt 2020 · S/N 172S12597N617FLHarris Nancy B · Christiansburg, VABuilt 1971 · S/N 28-7125502N617FMBurruss Lawrence R Jr · Charlottesville, VABuilt 1998 · S/N 22557N617GYagues Kevin B · Boise, IDBuilt 2006 · S/N 5752N617JAYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 28020265N617JBDoll Joseph L · Patterson, NCBuilt 2023 · S/N 69N617JLHeli Concepts LLC · Austin, TXBuilt 2006 · S/N 11161N617MPowers Gilbert · Warrensburg, MOBuilt 2015 · S/N 3246N617MAAs The Crow Flies LLC · Belmont, WIBuilt 2003 · S/N 444-2003N617MCCigal Mark A · Hendersonville, NCBuilt 2004 · S/N 81530N617MZDouglas Weske P · Blaine, MNS/N 81064N617TCCamp Thomas H · Melbourne, FLBuilt 1974 · S/N 18-7409120N617TNNichols Todd Eric · Kansas City, MOBuilt 2024 · S/N 001N617TWTango Whiskey Aviation LLC · Cody, WYBuilt 2002 · S/N 18281176N617WWood Jim · Seminole, TXBuilt 1973 · S/N 579-73N617WGGerszewski Wayne C · Park River, NDBuilt 2025 · S/N 014N61801Tampa Aviation Club Inc · Tampa, FLBuilt 1975 · S/N 17264811N61803N61803 LLC · Manassas, VABuilt 1975 · S/N 17264812N61804Skyhawk Virginia LLC · Chester, VABuilt 1975 · S/N 17264813
Back to AD 81-18-04 R2