OpenAirDocs.org
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.

N5264KRmg Aviation LLC · Newark, DEBuilt 1980 · S/N 17274036N5264PBohmer James F · Tulsa, OKS/N 24-300N5264WGray Donald B Trustee · Houston, TXBuilt 1961 · S/N 28-310N5264XTank David M · Cambridge, OHBuilt 1969 · S/N 170N52654Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274576N5265DFly 172rg LLC · Peoria, AZBuilt 1979 · S/N 17272482N5265ETree Top Flying Service Inc · Clarksville, TNBuilt 1978 · S/N 17271804N5265HHarper Clayton E · Seabrook, TXBuilt 1949 · S/N 16-69N5265LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284283N5265RMoss Hill Airport Inc · Kinston, NCBuilt 1974 · S/N 17263479N5265WDwight Marketing Corporation · Caldwell, KSBuilt 1962 · S/N 28-311N5265XSwanton Peter K · Willits, CABuilt 1969 · S/N 124N52660Yancey Steven Hunter · Helenwood, TNBuilt 1977 · S/N 177RG1235N52662Aston Stuart A · New Braunfels, TXBuilt 1977 · S/N 177RG1236N52663Registration Pending · Cedar Key, FLRegistration pendingS/N 177RG1237N52667Noe Daniel P · Pittsburgh, PABuilt 1977 · S/N 177RG1240N52669F Sharp Aviation LLC · New Baltimore, MIBuilt 1977 · S/N 177RG1242N5266DColemanation Investments LLC · Naperville, ILBuilt 1979 · S/N 17272483N5266ENatchez Flight Training LLC · Natchez, MSBuilt 1978 · S/N 17271805N5266HFritz Flying Service Inc · Lincoln, NES/N 16-70N5266KCorsicana Aviation Training Services LLC · Corsicana, TXBuilt 1980 · S/N 17274037N5266LIlmberger Stephen R · San Leandro, CABuilt 1980 · S/N 15284284N5266SFogle Cooper · Mooresville, NCBuilt 1971 · S/N 28R-7135120N5266UN5266u LLC · Brookfield, ILBuilt 1980 · S/N 172RG0312N5266WMichigan Sport Aviators Inc · Midland, MIBuilt 1962 · S/N 28-312N5266XKrabbenhoft J F · Amenia, NDBuilt 1969 · S/N 191N52671Carver Aero LLC · Muscatine, IABuilt 1981 · S/N 17274577N52678Land And Sea Aviation Alaska LLC · Anchorage, AKBuilt 2026 · S/N 172S13556N5267EBrudelie Alan C · Lewisville, MNBuilt 1978 · S/N 17271806N5267LBlasi Aviation LLC · Valley Center, KSBuilt 1967 · S/N 28-4565N5267PCarter Jeffrey Lee · Cameron Park, CABuilt 1958 · S/N 24-303N5267RCastlegate Corp · Monee, ILFirst renewal noticeBuilt 2002 · S/N 172S9180N5267SAviation Psych LLC · Neptune Beach, FLBuilt 1980 · S/N R18201530N5267XShelden Seth · Palmer, AKBuilt 1969 · S/N 192N5267YCkb Management LLC · Fayetteville, ARBuilt 2002 · S/N 172S9181N52680Harris John Q · Tucson, AZBuilt 1977 · S/N 177RG1246N52683Cobb John Mark · Fayetteville, TNBuilt 1981 · S/N 17274579N52684Altair Advanced Industries Inc · Bellingham, WABuilt 1977 · S/N 177RG1248N52685Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17274580N5268BCabbage David A · Colville, WABuilt 1957 · S/N 1131N5268HGrander Aviation LLC · Panama City Beach, FLBuilt 1975 · S/N 17265389N5268JReach For Skies LLC · San Antonio, TXBuilt 1980 · S/N 17273751N5268KSorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N 17274038N5268RJohnson Steven D · Oklahoma City, OKS/N 17263482N5268TDykes Don A · Houston, TXBuilt 1972 · S/N 28-7205252N52694Sullivan Michael E Trustee · Granite Bay, CABuilt 2002 · S/N 18281161N52695Farley Ryan P · Cumberland, RIBuilt 1977 · S/N 177RG1251N52696Sladko Jeffrey · Battle Ground, WABuilt 1977 · S/N 177RG1252N5269DGeorges Aviation Services Inc · Honolulu, HIBuilt 1977 · S/N 177RG1249N5269LKarel John · Stillwater, MNBuilt 1967 · S/N 28-4567
Back to AD 81-18-04 R2