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.

N9543WStryker Kevin · Ben Wheeler, TXBuilt 1967 · S/N 28-22974N95444Kent State University · Stow, OHBuilt 1984 · S/N 15285897N95445Kent State University · Stow, OHBuilt 1984 · S/N 15285898N95447Swartzendruber Rebecca A · Bay Port, MIBuilt 1969 · S/N 28-25959N9544CJones Michael Jay · Schaumburg, ILBuilt 1966 · S/N 28-3614N9544DPhilpott Stuart L · Taylorsville, KYBuilt 1958 · S/N 22-6461N9544HSouthern Aero LLC · Homestead, FLBuilt 1975 · S/N 17266217N9544LFortnight Aviation LLC · Philadelphia, PAFirst renewal noticeBuilt 1974 · S/N AA5-0543N9544QPhoto Services Unlimited · Augusta, MEBuilt 1998 · S/N 18280291N9544SJourney Holdings LLC · Reform, ALBuilt 1998 · S/N 18280149N9544WStrawn Randy A · Atlanta, TXBuilt 1967 · S/N 28-22975N95450Piper Aire LLC · Shell Knob, MOBuilt 1969 · S/N 28-25963N95452Blatti Charles A Jr · Elwood, ILBuilt 1969 · S/N 28-25965N95454Butler Byron D · Acworth, GABuilt 1969 · S/N 28-25968N95455Juszkiewicz Jack · El Paso, TXBuilt 1969 · S/N 28-25969N95457Miss May Aviation Inc · Brookfield, MABuilt 1969 · S/N 28-25967N95459Folsom James · Lawrenceburg, KYBuilt 1969 · S/N 28-25970N9545BSunrise Aero Inc · Ocala, FLBuilt 1981 · S/N 172RG0870N9545DFaught Jeffrey R · Bismarck, NDBuilt 1958 · S/N 22-6462N9545FEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1998 · S/N 17280380N9545LMoore Walter Robert · Bradentone, FLBuilt 1974 · S/N AA5-0655N9545MStull Ronald Wayne Jr · Ward, ARBuilt 1966 · S/N 670122N9545WBouthillier Mark W · Tonawanda, NYBuilt 1967 · S/N 28-22976N95461Bradford Murvin L · Hensley, ARS/N 28-25971N95463Licata Paul Z · Mexico, MOBuilt 1969 · S/N 28-25704N95469Kent State University · Stow, OHBuilt 1984 · S/N 15285899N9546DTripacer Leasing LLC · Lauderhill, FLBuilt 1958 · S/N 22-6463N9546HMiller Dale L · Bozeman, MTBuilt 1975 · S/N 17266219N9546MHood Michael T · Parrottsville, TNS/N 670123N9546PVacaville Aero Services Inc · Williams, CABuilt 1974 · S/N 25-7405646N9546UFletchair Inc · Comfort, TXBuilt 1977 · S/N AA1C0042N9546WSale Reported · Van Nuys, CASale reportedBuilt 1967 · S/N 28-22978N95471Herrington Herbert A · Gallatin, TNBuilt 1969 · S/N 28-25452N95473Bohling Anthony W · Auburn, NEBuilt 1969 · S/N 28-25981N95474Kent State University · Stow, OHBuilt 1984 · S/N 15285901N95475Kent State University · Stow, OHBuilt 1984 · S/N 15285902N95476Bollinger Aaron · Norfolk, VABuilt 1969 · S/N 28-25985N95477Wills Thomas J · Plainfield, ILBuilt 1969 · S/N 28-25986N95479Wilson Scott E · Fostoria, OHBuilt 1969 · S/N 28-25988N9547DStoltz Michael A · Portland, ORS/N 22-6464N9547HRegistered aircraftBuilt 2007 · S/N 1654N9547JFranz Stanley · Yakima, WABuilt 1966 · S/N 28-3676N9547KAviles Hector J · Rancho Cucamonga, CAS/N 28-7615211N9547LCivil Air Patrol · Maxwell Afb, ALBuilt 1986 · S/N 17276575N9547MDenig Daniel D · Albuquerque, NMBuilt 1966 · S/N 670124N9547TJk Gray Family LLC · Concord, NCBuilt 1978 · S/N 38-78A0128N9547WWatch Ya Head Aviation I LLC · Zionsville, INBuilt 1998 · S/N 17280508N95481North Texas Aeronautics LLC · Fort Worth, TXBuilt 1969 · S/N 28-25989N9548JMulder Timothy D · Shafter, CABuilt 1966 · S/N 28-3677N9548MPetersen Todd Anthony · Simi Valley, CABuilt 1966 · S/N 670125
Back to AD 81-18-04 R2