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.

N889JDByxbee John · Greenville, SCBuilt 1981 · S/N 28-8111061N889MSturza Allen J · Boyne City, MIS/N CK0-1N889MHExtreme Helicopter Service LLC · Alice, TXBuilt 2001 · S/N 3160N889NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496602N889RMSands Kevin A · North Chili, NYBuilt 1982 · S/N 160N889SCCrawford Stevan L · Woodinville, WABuilt 2005 · S/N 2476N889SDMedary Aviation LLC · Brookings, SDBuilt 2025 · S/N 172S13322N889SPLeading Edge Aviation Inc · Spencer, IABuilt 2002 · S/N 172S9088N889TJvs LLC · Santa Rosa, CABuilt 1957 · S/N 18-5540N889TTFlying Farmer LLC · Wilmington, DEBuilt 2018 · S/N 087N88ABBrown James L · Athens, ALBuilt 1973 · S/N 17262739N88ACSegerstrom William C · Sunriver, ORBuilt 1965 · S/N TD-621N88AHScott Cody · Eagle, COBuilt 2018 · S/N 3300N88AKState Of Alaska · Anchorage, AKBuilt 1965 · S/N 18-8311N88ALChristenson Lloyd Gregory · Side Lake, MNBuilt 1946 · S/N 12-971N88APLangdon Brian B · Newcastle, WABuilt 1964 · S/N 30-456N88AVN88av LLC · Fort Myers, FLS/N 525N88BELee George M · Queen City, TXBuilt 1988 · S/N 1317N88BSBachman Jared R S · Elbert, COBuilt 1981 · S/N 2N88BWRegistered aircraftBuilt 1976 · S/N 817N88CTCameron John W · Canby, ORS/N 882N88CVAllen David L · Sturgis, SDBuilt 1999 · S/N 80327N88DAAnderson Darin D · Eatonville, WABuilt 2021 · S/N 41667N88DEMatta Figueroa Eduardo · Chapman, KSBuilt 1959 · S/N 23-1618N88DKPitts Cabot J · Palmer, AKBuilt 1977 · S/N 7088CN88DRAkerson Charles J · Clarksville, TNBuilt 1965 · S/N 3170N88EStarlite Aviation Technologies LLC · Las Vegas, NVBuilt 1973 · S/N 17261476N88EFPeyton Craig L · Rhinebeck, NYBuilt 1979 · S/N 24-0815N88EHSale Reported · Pismo Beach, CASale reported, pending cancellationS/N EHH-1N88ETGelfan Russell A · Bellingham, WABuilt 1980 · S/N 202N88FVandivort Aaron · Jacksonville, FLBuilt 1959 · S/N 24-1245N88FBGeary Travis S · Viroqua, WIBuilt 1975 · S/N 28-7510108N88FCSandlapper Aviation Of De Inc · Bennington, VTBuilt 1998 · S/N 80061N88FNSaline County Flyers Association LLC · Little Rock, ARBuilt 1969 · S/N 28-26119N88FRAero Solutions Inc · Henderson, NVBuilt 2011 · S/N 82920N88FXScronce Anthony W · Reno, NVBuilt 1986 · S/N DEW3923883N88GCHuth-Weiss Kathryn W · Prescott, AZBuilt 2004 · S/N 80505N88GEGothreaux William A · Deridder, LAS/N 1934N88GGSchneck Doreen Trustee · Albany, GABuilt 1970 · S/N 3N88GKSale Reported · Crestview, FLSale reportedBuilt 2003 · S/N 80271N88GRLewis Brad D · Eugene, ORBuilt 1985 · S/N 10006CN88GT9q Partners LLC · West Caldwell, NJBuilt 2001 · S/N 2083N88GVAllen Timothy J · Petersburgh, NYBuilt 1988 · S/N 413N88HGBagwell Harold G · Garner, NCBuilt 2008 · S/N 3011N88HUSchultz Peter G · La Jolla, CABuilt 2017 · S/N 3288N88HYRegistered aircraftBuilt 2024 · S/N 3441N88JCFarooq Tayab · Allen, TXS/N 675N88JLSummit Concepts Inc · Wilmington, DES/N 463N88JVVan Grunsven Gerald B · Hillsboro, ORBuilt 2001 · S/N 80088N88KAStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1972 · S/N 34-7350029
Back to AD 81-18-04 R2