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.

N9600LDavis Jim F · Poteau, OKS/N AA1B-0100N9600MAstrup Aviation Enterprises LLC · Lincoln, CABuilt 1966 · S/N 670177N9600SHargrove Tom R · Coffeyville, KSBuilt 1966 · S/N 2N9600UUniversity Of Oklahoma · Norman, OKBuilt 1978 · S/N 28-7816505N9601DRiffle David T · Woodinville, WABuilt 1958 · S/N 22-6510N9601JGevers Robert L · Lafayette, INBuilt 1966 · S/N 28-3747N9601QSteel Aviation Inc · Walnut Cove, NCBuilt 1975 · S/N 17265686N9602BLaguna Verde Leasing Inc · Wilmington, DES/N 172RG0912N9602MCullen William P · Alexandria, VAS/N 670179N9602SKrepfl Martin J · Colorado Springs, COBuilt 1965 · S/N 50N96033Sullivan Leo W · O Fallon, ILBuilt 1990 · S/N 1127N9603DHeartland Aviation Inc · Alliance, NES/N 22-6512N9603FWylie Aviation LLC · Boise, IDBuilt 1989 · S/N 1121N9603QConnecticut Flyers Inc · Madison, CTBuilt 1975 · S/N 17265688N9603UAviation Business Corp · Saint Louis, MOBuilt 1977 · S/N AA1C0069N9603WMoore Alan Ray · Glenwood, ARBuilt 1967 · S/N 28-23055N96042Aeropaint LLC · Wylie, TXBuilt 1990 · S/N 1138N9604LBlue Grumman Plane LLC · New York, NYS/N AA1B-0104N9604QStevens Joel N · Monticello, ARBuilt 1990 · S/N 1120N9604SFmco Promotions Inc · North Little Rock, ARS/N 25N96052Copp James E · Adin, CAS/N 1150N9605CA O G Aircraft Services LLC · Aberdeen, NJBuilt 1978 · S/N 28-7816502N9605DDirty Side Down LLC · Downers Grove, ILBuilt 1958 · S/N 22-6514N9605LStroberger Anthony S · Chandler, AZBuilt 1973 · S/N AA1B-0105N9605MAsv Aviation LLC · Salem, ORBuilt 1966 · S/N 670182N9605QBragan Ryan J · Dunedin, FLBuilt 1975 · S/N 17265690N9605RStieglitz Jeffrey B · Firth, IDBuilt 1990 · S/N 1143N9605UCook Jacob D · Enid, OKBuilt 1977 · S/N AA1C0070N9605VBrookhart Brent Robert · Anaconda, MTBuilt 1990 · S/N 1144N9605ZBorror Kevin Bruce · Grants Pass, ORBuilt 1990 · S/N 1147N96060Silver Creek Ranch Inc · Austin, NVBuilt 1990 · S/N 1145N9606DNiemi Danny L · Osage, MNS/N 22-6516N9606SMix Timothy R · Hubbard, ORS/N 43N9606WMandolesi Daniel Martin · Hulmeville, PABuilt 1967 · S/N 28-23059N9607CLmc Aviation LLC · Goleta, CABuilt 1978 · S/N 28-7890429N9607DRomo Mark A · Dillingham, AKBuilt 1958 · S/N 22-6517N9607HTwin Oaks Airpark Inc · Hillsboro, ORFirst renewal noticeBuilt 1975 · S/N 17266260N9607RJohnston Bradley G · Ossining, NYBuilt 1959 · S/N TD-290N9607TPeterson Bradley E · Williston, NDBuilt 1990 · S/N 1134N9607WK-9 Handler LLC · Henderson, NVBuilt 1967 · S/N 28-23060N96088Griffith Kruz S · Bakersfield, CABuilt 1990 · S/N 1151N9608FDraper Floyd L · El Paso, TXBuilt 1970 · S/N 300012N9608HCag Aircraft Holdings LLC · Crystal River, FLBuilt 1975 · S/N 17266261N9608JGomm Bruce J · Colfax, NDS/N 28-3754N9608KPiper Arrow N9608k LLC · Ann Arbor, MIBuilt 1976 · S/N 28R-7635250N9608MWaryas Robert A · Long Island, VAFirst renewal noticeBuilt 1967 · S/N 670107N9608QLahmers Melvin E · Newcomerstown, OHBuilt 1976 · S/N 17265693N9608RB2 West Corporation · Winona, MNBuilt 1959 · S/N TD-291N9608UNorth Shore Aviation LLC · Honolulu, HIBuilt 1975 · S/N AA5-0808N9608WBright Skies Sales & Leasing LLC · Hendersonville, TNBuilt 1967 · S/N 28-23061
Back to AD 81-18-04 R2