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.

N8211WPeterson Dustin K · Alliance, NEBuilt 1965 · S/N 28-2344N8211YMccoy Darren T · Caledonia, MIBuilt 1966 · S/N 30-1338N82122Takeoff2entertainment LLC · Lake Havasu City, AZBuilt 1982 · S/N 28-8290140N8212GDavis Richard M · Southport, NCBuilt 1971 · S/N 177RG0112N8212HAdermannick · Palmer, AKS/N 32-8006046N8212WRayviation LLC · Carrollton, MIBuilt 1965 · S/N 28-2345N82131Bradley Michael R · Denver, NCBuilt 1980 · S/N 32-8006053N8213CFaucon LLC · Tucson, AZBuilt 1975 · S/N 28-7525160N8213JWcd LLC · Palatka, FLBuilt 1981 · S/N 2258N8213TMortenson Jay E · Venice, CABuilt 1960 · S/N 17556913N8213YBoomer Joshua G · Floyds Knobs, INBuilt 1966 · S/N 30-1340N8213ZOne Three Zulu Inc · Marble Falls, TXBuilt 1980 · S/N 32-8006052N82145Kcn Aero Club Inc · Overland Park, KSBuilt 1980 · S/N 32-8006029N82149Sanders Flight Training Center Inc · Jasper, ALBuilt 1976 · S/N 17267692N8214BDaas Company Inc · El Centro, CABuilt 1980 · S/N 32-8006058N8214CRegistered aircraftBuilt 1954 · S/N 18-3655N8214GKolman Michael D · Overland Park, KSBuilt 1971 · S/N 177RG0114N8214NKuenzi Scott A · Madison, WIBuilt 1969 · S/N 28-25418N8214YRegistration Pending · Harrisburg, SDRegistration pendingBuilt 1980 · S/N 28-8090362N82155Maroney Thomas L · Wasilla, AKBuilt 1975 · S/N 18-7809135N8215GGersten Iron · Spring Valley, CABuilt 1971 · S/N 177RG0115N8215NRyder Paul M · Charlotte, NCBuilt 1969 · S/N 28-25419N8215PAme LLC · Kalispell, MTBuilt 1963 · S/N 24-3468N8215YGlassburn Teresa L · Winthrop, WAS/N 30-1343N82162Conner Larry W · Los Lunas, NMBuilt 1982 · S/N 32R-8313015N82165Piper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 18-7809136N82166Minuteman Aviation Inc · Missoula, MTBuilt 1978 · S/N 18-7809137N82168Earth Center Adventures Inc · Haines, AKBuilt 1979 · S/N 18-7909061N82169Patterson Colin G · Ballston Spa, NYBuilt 1979 · S/N 18-7909063N8216CYoung Mikaela R · Fairbanks, AKS/N 18-4444N8216GFarrar Edwin L · Mansfield, OHBuilt 1971 · S/N 177RG0116N8216NShelton William B · Wildwood, MOBuilt 1969 · S/N 28-25420N8216PBobbitt Aviation LLC · Edenton, NCBuilt 1960 · S/N 24-2219N8216SNulton Enterprises LLC · Johnstown, PABuilt 1980 · S/N 28-8016328N8216TRegistered aircraftBuilt 1982 · S/N 32-8206037N8216WBritair Inc · Austin, TXBuilt 1965 · S/N 28-2349N8216YMedia Stew LLC · Carson City, NVS/N 30-1344N82172Wadekamper Leo V · Helena, MTBuilt 1979 · S/N 18-7909064N8217NG U M P S Flying Club Inc · Warner Robins, GABuilt 1969 · S/N 28-25421N8217PDanilchuk Phillip A · Auburn, GAS/N 24-3470N8217QParis Air Inc · Vero Beach, FLBuilt 1980 · S/N 28-8016334N8217SValles Robert Jr · Spicewood, TXBuilt 1980 · S/N 28-8016335N8217YMaledy John Trustee · Salem, MOBuilt 1966 · S/N 30-1345N8217ZPerry Richard F · Lexington, MABuilt 1982 · S/N 32R-8213051N8218Kornegay Patrick C · San Benito, TXBuilt 1982 · S/N 18-8209005N82188Kubecka Daniel P · Edna, TXBuilt 1979 · S/N 18-7909068N8218CStargazer Aviation LLC · Clearwater, FLBuilt 1975 · S/N 28-7615081N8218NLee David · Palm Springs, CAS/N 28-25548N8218ZWingsleasing LLC · Wichita, KSBuilt 1980 · S/N 28-8090320N82190Salav LLC · Salisbury, NCBuilt 2018 · S/N 140344
Back to AD 81-18-04 R2