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.

N948RRed Baron LLC · Middletown, DEBuilt 1978 · S/N 177RG1318N948RVGeer Roy R · Fort Worth, TXBuilt 2004 · S/N 82021N948SAPavlatos Plato Nicholas · Springfield, OHBuilt 1989 · S/N 948N948SMScenic Concepts LLC · La Crosse, WIBuilt 1982 · S/N 172RG1057N948TPray Aviation Inc · Augusta, KSFirst renewal noticeBuilt 1964 · S/N TD-600N948WDAndrews Aviation Two LLC · Temple, TXBuilt 2010 · S/N 71660N94901Liberty University · Lynchburg, VABuilt 2013 · S/N 172S11273N9490HNovak Rickson J · Pine City, MNBuilt 1975 · S/N 17266177N9490PSurti Freddy Rusi · Des Moines, WABuilt 1971 · S/N 24-5007N9491JRoy Thomas M Jr · Carbondale, ILBuilt 1966 · S/N 28-3609N9491LVictoria Angel Guaroa · Lewisville, TXBuilt 1971 · S/N AA1A-0291N9491NWalker Mark L · Turlock, CABuilt 1969 · S/N 28R-35212N9492FDeer Creek Helicopters LLC · Chico, CABuilt 1973 · S/N 1030245N9492HSchodack Aviation Association · Ghent, NYBuilt 1975 · S/N 17266178N9492NKnaust Kurt · Baldwinsville, NYBuilt 1969 · S/N 28R-35213N9492VRivera Jaime · San Antonio, TXBuilt 1970 · S/N 700066N9492WHixson Robert S · Los Alamos, NMBuilt 1969 · S/N 28-11232N9493DJack Browns Seaplane Base Inc · Winter Haven, FLBuilt 1958 · S/N 18-6745N9493JHayes Enterprises · Glendale, AZBuilt 1966 · S/N 28-3611N9493NHigh Prairie Aviation LLC · Washington, IABuilt 1969 · S/N 28R-35214N9494DReder Monte D · Miles City, MTBuilt 1958 · S/N 18-6746N9494GKelly William W · Springfield, ORBuilt 1977 · S/N 15279527N9494JRuiz Serge · Montgomery, TXS/N 28-3613N9494WDavisson Michael A · Edgewood, NMBuilt 1969 · S/N 28-11234N94959Lane Community College · Eugene, ORBuilt 1983 · S/N 15285823N9495DEichholz Kenneth D · Cordova, TNBuilt 1985 · S/N 172RG1187N9495HNelson Flying Service LLC · Lansford, NDBuilt 1975 · S/N 17266180N9495NNagel Richard A · Mequon, WIBuilt 1969 · S/N 28R-35216N9495VSoccer Goals LLC · Christoval, TXBuilt 1970 · S/N 700067N94963Twin Cities Air Service LLC · Gray, MES/N 15285825N9496DCavu Clearing LLC · Center Harbor, NHBuilt 1958 · S/N 18-6748N9496VEvans Richard I · Elko, NVS/N 700050N9496WJones Terry · Bells, TNBuilt 1969 · S/N 28-11238N9497JShushnar Gary J · Irvine, CABuilt 1966 · S/N 28-3737N9498JBrantley Hugh L · Hazlehurst, GAS/N 28-3738N9498KDirksen Caleb A · Garner, IABuilt 1976 · S/N 28R-7635245N9498LRaber Jonathan L · Baltimore, MDBuilt 1972 · S/N AA5-0238N9498NKoehler Scott A · Brighton, ILBuilt 1969 · S/N 28R-35219N9498VMoonshiner Aviation LLC · Austin, TXBuilt 1970 · S/N 700068N94992Mac Air Corp · Benton, KSBuilt 2013 · S/N 18282359N9499BWyatt Bradley S · Bishop, CABuilt 2012 · S/N 90631N9499LRobinson Jason C · Fort Worth, TXBuilt 1971 · S/N AA1A-0299N9499NFlight Niner Niner LLC · Charleston, SCBuilt 1969 · S/N 28R-35220N9499VBerliner Donald D · Medford, NJBuilt 1970 · S/N 700048N9499ZDark Sky Enterprises LLC · Flagstaff, AZBuilt 1998 · S/N 18280292N949BMGoebel Michael M · Conroe, TXBuilt 2012 · S/N 3142N949BVStout Billy V · Hooker, OKBuilt 2019 · S/N 372-79N949CDDupont Samuel F C · Mount Solon, VABuilt 1978 · S/N 17270883N949CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 18283128N949FSDraper Floyd L · El Paso, TXBuilt 1951 · S/N 18-949
Back to AD 81-18-04 R2