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.

N76JEReedy Dana J · Columbus, INBuilt 1976 · S/N 1915N76JGSublett Farms · Ardmore, ALBuilt 2000 · S/N 2061N76JKKrajewski Jason · Portland, ORBuilt 1976 · S/N 177-02435N76JMWalton Daniel · Schaumburg, ILBuilt 1987 · S/N JM 2N76JRWeiner Lupita A · Mineola, TXBuilt 1977 · S/N JR-1N76JVLeonardo David · Hollister, CAS/N 21071N76JYYoder Jeremy L · Sarasota, FLBuilt 2021 · S/N 74315N76KCCulhane Mark E · South Windsor, CTBuilt 1983 · S/N 1168N76KDSchneider Aaron J · Chugiak, AKBuilt 1986 · S/N 76N76KFRegistration Pending · Grenada, MSRegistration pendingBuilt 1974 · S/N 153-74N76KRSorensen Bjarne K · Vero Beach, FLBuilt 1983 · S/N 353N76KSSchroepfer Ken J · Pecatonica, ILBuilt 2007 · S/N 70229N76LCHacienda Hills Skyhawk LLC · Laveen, AZBuilt 1977 · S/N 17268925N76LMPavlovich Martin · Menomonee Falls, WIS/N 22604N76LNHillsboro Aero Academy LLC · Hillsboro, ORS/N 957N76LYYonge Laurie W Jr · Oklawaha, FLBuilt 1964 · S/N 302N76MBHolt Helicopter Inc · Uvalde, TXBuilt 2006 · S/N 1661N76MKMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N ME186N76MLDunn Courtland E Jr · West Grove, PABuilt 1974 · S/N 446-74N76MMRichardson John H · Monticello, NMBuilt 1957 · S/N 18-6031N76NATri Flying Tigers Inc · Wilmington, DEBuilt 1960 · S/N 23-1909N76NCDonald K Ashley · Bradenton, FLBuilt 1976 · S/N M-1787N76NKNaples Jet Management LLC · Naples, FLS/N ME-334N76NNSale Reported · Middletown, OHSale reported, canceledBuilt 1979 · S/N ME-158N76NPCollins Shannan S · Justin, TXS/N SA-300-726N76PFRodriguez Amable Omar · Hialeah, FLBuilt 1982 · S/N 28-8216151N76PPGround Effect Aviation LLC · Ogden, UTBuilt 2007 · S/N 494-2007N76PQBoyd Benjamin L · Kila, MTBuilt 1976 · S/N 18-7609130N76PTMcmurtrey Michael · Farmington, MNBuilt 1974 · S/N MC228N76RMMj Aero LLC · College Station, TXBuilt 2011 · S/N 001N76RSCocke James A · Clarendon, TXBuilt 1976 · S/N 683-HN76RVVandevort Lynn A · Manitowoc, WIBuilt 1999 · S/N 23420N76RWThomas Allen C · Willow, AKBuilt 1953 · S/N 18-1886N76SBAdams Simmie A · Bealeton, VABuilt 1975 · S/N M-1776N76SHConrad Edgar · Mc Alpin, FLBuilt 1995 · S/N 22886N76SLLarsh Steven S · Libby, MTBuilt 2004 · S/N 1001N76SRTangipahoa Mosquito Abatement District # 1 · Hammond, LABuilt 1972 · S/N 27-7304976N76SSNorth Texas Aeronautics LLC · Burleson, TXS/N 17263711N76SWHendricks Blair · Charleston, SCBuilt 1980 · S/N 28-8011123N76TAAhlhorn Travis W · New Braunfels, TXS/N 17276025N76TCCox Thomas R · Kirkland, WABuilt 2001 · S/N 80500N76TDWillmott Wilson R · Huntington Station, NYBuilt 1979 · S/N 32R-8013027N76TJBais Tim · Escondido, CABuilt 1994 · S/N 21675N76TRSwaney Mark J · Oxnard, CABuilt 2015 · S/N 031N76TXBrenner Kurt · Saint Ann, MOBuilt 1976 · S/N 28-7625102N76UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12091N76VAHartzell Propeller Emp Flg Club · Piqua, OHBuilt 1976 · S/N M-1786N76VMSwartz Aviation Group LLC · Argyle, TXBuilt 2010 · S/N 82155N76WLBuckel Joseph T · Ellison Bay, WIBuilt 1976 · S/N VAC-57-76N76WNCorben David Meyer · Lafayette, INBuilt 1978 · S/N 433H
Back to AD 81-18-04 R2