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.

N8308LClassic Wings · Westlake Village, CAS/N 28-8316017N8308MGfl Aircraft Leasing Corp · Glens Falls, NYBuilt 1980 · S/N 32-8106020N8308RClassic Flyers Club Inc · Hastings, NEBuilt 1966 · S/N 28-22177N8308WSchlenker Richard A · Meeteetse, WYBuilt 1965 · S/N 28-2478N8309ASchmidtys Air LLC · Stuart, FLBuilt 1980 · S/N 32-8106026N8309EPlanewright Inc · Newberg, ORBuilt 1983 · S/N 28-8390013N8309KClaridge Michael A · Houston, TXBuilt 1982 · S/N 28-8390015N8309RPipal Cory J · Dublin, TXBuilt 1966 · S/N 28-22179N8309VSunde Bradley J · Fergus Falls, MNBuilt 1966 · S/N 95N8309YHolman Michael J · Anchorage, AKBuilt 1967 · S/N 30-1448N830ADb-Gbr LLC · Sarasota, FLBuilt 1962 · S/N M-36N830AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2000 · S/N 0838N830BMurphys Auto Gyro Sales LLC · Dade City, FLBuilt 2015 · S/N SC006N830BSShortt Aircraft Leasing LLC · Wilmington, DEBuilt 2004 · S/N 40.395N830BVRegistration Pending · Manhattan, MTRegistration pendingBuilt 1979 · S/N 28-7911289N830CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281300N830JVeracity Aviation LLC · Seguin, TXBuilt 2007 · S/N 4236N830KXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2011 · S/N 172S11106N830LMKq Aviation LLC · Old Town, FLBuilt 1988 · S/N 11048CN830MOliver Firm Lc · Dexter, MOBuilt 1989 · S/N 4622045N830MAFlying Technologies LLC · Wilmington, DEBuilt 2001 · S/N 172S8954N830MDMcelwee Glenda A · Lake City, FLS/N 22-6590N830MUMarshall University · Huntington, WVBuilt 2021 · S/N 4496532N830PColeman Nathan R · Zephyrhills, FLBuilt 1964 · S/N 28-20554N830PCSprowl Brian M · Millville, NJS/N 28R-7335055N830RCMartin Douglas J · Lutz, FLBuilt 1964 · S/N 28-20558N830TCRegistered aircraftBuilt 1980 · S/N 32R-8113016N830TNPrianti Paul J · Rockaway, NYBuilt 1972 · S/N 17260881N830UPixton Christopher T · Oregon City, ORBuilt 1957 · S/N TD-12N830ZCartwright John P · Watkinsville, GAS/N 1101N8310HPettit Brian K · Wshngtn Ct Hs, OHBuilt 1982 · S/N 32-8306009N8310WBennett Anthony W · Bradenton, FLBuilt 1965 · S/N 28-2482N8310YRegistration Pending · Kansas City, MORegistration pendingBuilt 1981 · S/N 32R-8113025N83113N83113 LLC · Liberty, NCBuilt 1981 · S/N 28-8116110N8311FGregoire Brandon James Ernst · Orlando, FLBuilt 1969 · S/N M1280N8311LSimpson Robert B · South Pasadena, CABuilt 1980 · S/N 28-8116104N8311PDuckett Kristofer · Fairfield, CAS/N 24-3561N8311WAlford Charles Mikael · Meadow Valley, CABuilt 1965 · S/N 28-2483N8311YAj Air LLC · Cape Girardeau, MOBuilt 1967 · S/N 30-1450N83126Ttl Aviation LLC · Lexington, KYBuilt 1980 · S/N 28-8111035N8312AToro Aero LLC · Calabasas, CABuilt 1982 · S/N 32R-8313002N8312HAlameda Aero Club · Alameda, CABuilt 1982 · S/N 28-8316020N8312PPerson Timothy Ivan · Lake Stevens, WABuilt 1980 · S/N 28-8190123N8312TRobinson Helicopter Co · Torrance, CABuilt 1994 · S/N 2452N8312VPester Mark C · Crookston, MNBuilt 1966 · S/N 458N8312WGillen James A · Cornville, AZBuilt 1965 · S/N 28-2484N83130Registered aircraftBuilt 1994 · S/N 2426N8313ACarter Donald R Jr · Nebo, NCBuilt 1980 · S/N 28-8111041N8313EShevah Avi · New Milford, CTS/N 2463MN8313TBehnfeldt Barry W · Napoleon, OHBuilt 1980 · S/N 32R-8113026
Back to AD 81-18-04 R2