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.

N8323YRochester Flying Club Inc · Rochester, NYBuilt 1980 · S/N 28-8111045N8323ZChapman Farms Inc · Vernon, COBuilt 1980 · S/N 28-8111046N8324Veal Tim S · Egegik, AKBuilt 1953 · S/N 18-2377N8324EGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1979 · S/N 17272189N8324PCirrus Air LLC · Eden, NCBuilt 1963 · S/N 24-3575N8324TTango LLC · Chesterfield, MOS/N 32-8106036N8324USyren David N · Anchorage, AKBuilt 1995 · S/N 2570MN8324WSwofford Sherman A · Inman, SCBuilt 1965 · S/N 28-2501N8324YStein Anthony J · Locust Grove, GABuilt 1967 · S/N 30-1465N8325EAnzaldi Carl J · Cherry Valley, CABuilt 1959 · S/N 1503N8325LLeading Edge Flight Services Inc · Hampshire, ILBuilt 1980 · S/N 28-8116131N8325RSy Aviation LLC · Judsonia, ARS/N 28-22197N8325TColumbia Jet Center Inc · Columbia, MOBuilt 1980 · S/N 28-8116134N8325UCross Dustin · Tonto Basin, AZBuilt 1964 · S/N 17252225N8325VPct Hawk Inc · Wilmington, DEBuilt 1980 · S/N 28-8190143N8325WAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 28-2502N83268Wright Kim B · Bozeman, MTS/N 18-7609057N8326CNewman Carl D · Phoenix, AZBuilt 1980 · S/N 28-8190152N8326ENorton Eric D · Nauvoo, ILBuilt 1960 · S/N 1582N8326WBarnwell Sam M · Traverse City, MIBuilt 1965 · S/N 28-2504N8326YEastern Stearman Inc Trustee · Leesburg, VABuilt 1967 · S/N 30-1468N83271Nohrenberg Raymond C · Pingree, NDS/N 18-7609061N83272Bowker James D · Willow, AKBuilt 1976 · S/N 18-7609063N83275Perry Scott D · Hood River, ORBuilt 1976 · S/N 18-7609062N83278Hamlin Andrew J · Two Rivers, AKBuilt 1976 · S/N 18-7709047N8327LFill David · Hadley, MABuilt 1980 · S/N 28-8111049N8327RWelsh Rick F · Ewing, VABuilt 1966 · S/N 28-22199N8327WFuture Flying LLC · Manassas, VABuilt 1965 · S/N 28-2506N8327YKaeser Robert E · Lafayette, INBuilt 1967 · S/N 30-1469N83281Chandler Air Service Inc · Chandler, AZBuilt 1976 · S/N 18-7609064N83283Hayton James B · Sedro Woolley, WABuilt 1976 · S/N 18-7609065N83285Dyches Abigail · Eagle River, AKBuilt 1976 · S/N 18-7609067N8328CSky Craft LLC · Powell, OHBuilt 1975 · S/N 28-7690116N8328LArrowhead Helicopter Services LLC · Jourdanton, TXBuilt 1995 · S/N 0210N8328PSale Reported · Lewes, DESale reportedS/N 24-3581N8328UHale Larry D · Charlotte, NCBuilt 1995 · S/N 2567N8328WTolmachev Nikolay A · Anchorage, AKBuilt 1965 · S/N 28-2507N8328YSims Chris · Colleyville, TXBuilt 1967 · S/N 30-1470N8329649 Ranch Co LLC · Odonnell, TXBuilt 1976 · S/N 18-7609068N83299Brewer Danny E Jr · Nikiski, AKBuilt 1976 · S/N 18-7609070N8329VBuck Timothy A · Howland, MES/N 119N8329YHarbock Inc · Wilmington, DEBuilt 1967 · S/N 30-1471N832ABeck John Edward · Newton, IABuilt 1951 · S/N 22-133N832AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2003 · S/N 1324N832ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496312N832CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281301N832EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2021 · S/N 172S12669N832KXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2011 · S/N 172S11109N832MAState Of Wisconsin · Madison, WIBuilt 2001 · S/N 172S9004N832RMMcbride Christen L · Elgin, TXBuilt 1996 · S/N 42121
Back to AD 81-18-04 R2