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.

N87GVChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280355N87GZGonzalez Jorge L · Pensacola, FLBuilt 2011 · S/N 21689N87HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 1998 · S/N 172S8022N87HPConnolly Andrew Leadley · Seabrook, TXBuilt 2003 · S/N NF0004N87HUGladius LLC · Nantucket, MABuilt 2017 · S/N 3287N87HYDuke Ray J · Texico, NMBuilt 2000 · S/N 25050CN87JAN87ja Lk Aircraft Holdings LLC · Wheeling, ILBuilt 1998 · S/N 172S8012N87KCAviation 3 D Loggers LLC · Sheridan, WYBuilt 1997 · S/N 006N87KDKissick Kathy L · Kansas City, MOBuilt 2011 · S/N 3124N87KGCherokee From Sebring LLC · North Brunswick, NJBuilt 1969 · S/N 28R-35043N87KMLibbey Eric D · Solvang, CAS/N 71148N87LAAdams Kirk · Sanger, CABuilt 1989 · S/N 87N87LJRegistration Pending · Chicago, ILRegistration pendingBuilt 1988 · S/N SN-487RN87MSellers Mark · Philadelphia, PABuilt 1955 · S/N 22-2951N87MBTraining Planes LLC · Tampa, FLBuilt 1972 · S/N 34-7250070N87MCNorthern Blue Skies Inc · Shawano, WIBuilt 1980 · S/N 28-8090104N87MRReisdorfer Mark J · La Follette, TNBuilt 1994 · S/N 23010CN87MXHalbritter Shawn M · Caldwell, IDBuilt 1989 · S/N 1371N87NMChildress Gregory F · Dallas, TXBuilt 1957 · S/N 22-5082N87PCraig Stephen J Trustee · Lawrence, KSBuilt 1963 · S/N 1015N87PDRyan Patrick W · Poway, CABuilt 1999 · S/N 21875N87PMMona LLC · Kalispell, MTBuilt 1983 · S/N 24-1386N87PRTango Flight LLC · Thibodaux, LABuilt 2020 · S/N 91593N87RCTime To Fly Meseum · Burleson, TXBuilt 1994 · S/N 526-HN87RPWhitehead Glenn K · Friendswood, TXS/N 24-1603N87RVRoberts-Lethaby Jeremy P · Isanti, MNS/N 619N87SDHubbert Stephen A · Newcastle, OKBuilt 1977 · S/N 1N87SVMontgomery Vaughn L · Washington, UTBuilt 2020 · S/N 25070N87TKKee Franklin T · Camden, TNBuilt 2023 · S/N DMO409N87VKBurgstaller Martine S · DeurneBuilt 1960 · S/N 22-8879N87WAltitude Aviation LLC · Lenoir, NCBuilt 1999 · S/N 2843296N87WAMann Ronald L · Pound Ridge, NYS/N 754-95N87WBWild Bitch LLC · Oklahoma City, OKS/N SN-483RN87WHPerry Larry B · Montross, VABuilt 1987 · S/N 1672N87WJKrueger Kenneth L · Newberg, ORS/N 553N87WRJohnston Donald C · Davis, CABuilt 1967 · S/N 520N87XPSutherland Brian · Nolensville, TNBuilt 2019 · S/N 087N88002Heiderscheidt Aerial LLC · Sleepy Eye, MNBuilt 1980 · S/N DW-1-0005-80N8800JRobinson Jacob · Lewistown, MTS/N 28-2745N8800WEagle LLC · Sleepy Eye, MNBuilt 1980 · S/N DW-1-0004-80N8800YAlexander City Aviation Corp · Alexander City, ALBuilt 1969 · S/N 30-1956N8801CBlue Chip Aviation LLC · Falling Waters, WVS/N 22-1414N8801EBlades Paul A · Newman, CABuilt 1980 · S/N DW-1-0007-80N8801MStein Bruce A · Punta Gorda, FLBuilt 1964 · S/N TD-569N8801WAfrican Research Foundation Inc · New York, NYRevoked, canceledBuilt 1964 · S/N 28-10213N8801XPiercy Ronald S · Moses Lake, WABuilt 1980 · S/N DW-1-0010-80N8802Osterberg Douglas · Neenah, WIBuilt 1973 · S/N 492-73N88024Madsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-0021-81N8802FMc Lane Jonathan T · Morrisville, NCRevoked, canceledBuilt 1962 · S/N 0133N8802JShivers James C II · Columbus, OHBuilt 1965 · S/N 28-2750
Back to AD 81-18-04 R2