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.

N8693YPeregrine Aviation LLC · Winfield, ILBuilt 1969 · S/N 30-1839N86948Guglietta Jon R · Harwinton, CTBuilt 1974 · S/N 147-74N8694DJunek John M · Leonardtown, MDS/N 18-6303N8694NCitadelle Holdings LLC · Palmetto Bay, FLBuilt 1971 · S/N 32-7200009N86950Dale Jane L · Willow, AKS/N 39-74N86953Madden Russell · Graford, TXBuilt 1974 · S/N 152-74N86954Breaking Wind LLC · Alabaster, ALBuilt 1974 · S/N 148-74N86957Swan Creek Flying Club · Ayr, NDBuilt 1974 · S/N 692-74N86959Collum Aviation LLC · Milton, FLBuilt 1974 · S/N 1029-74N8695PDurflinger Aviation LLC · Otterbein, INFirst renewal noticeBuilt 1965 · S/N 24-4143N8695WBurr Walker · Redmond, UTBuilt 1964 · S/N 28-10268N8695YPurkinje Ltd LLC · Wilmington, DEBuilt 1969 · S/N 30-1841N86968Crafted Enterprises LLC · Montrose, COS/N 40-74N86969Sperry Sails Inc · Marion, MABuilt 1974 · S/N 695-74N8696VMoynahan Thomas F · Newnan, GABuilt 1975 · S/N 515-75N86974Qualitair LLC Trustee · MichelstadtBuilt 1974 · S/N 145-74N86977Ajs Aviation Inc · Spring Hill, FLBuilt 1974 · S/N 458-74N8697EMaze Bryan · Tulare, CABuilt 1976 · S/N 28-7615148N8697LFried Stephen · Kingston, MABuilt 1969 · S/N 25-5124N8697VFisher Kurt Adrian Trustee · San Luis Obispo, CABuilt 1975 · S/N 833-75N86983Hanson Curtis J · Peyton, COBuilt 1974 · S/N 1031-74N86985Thomas Lucas G · Beebe, ARBuilt 1974 · S/N 44-74N86986Nelson Michael R · Philip, SDBuilt 1974 · S/N 45-74N86989Webb Terry M · Montreal, MOBuilt 1974 · S/N 46-74N8698CRichard Waldren LLC · Newberg, ORBuilt 1953 · S/N 22-1348N8699Blake Rodney · Trophy Club, TXBuilt 1973 · S/N 358-73N8699DBohannon James A III · Waller, TXBuilt 1958 · S/N 18-6277N8699PKroll Corey · Gilbert, SCBuilt 1964 · S/N 24-4097N8699RQuinn Michael P · Matthews, NCBuilt 1966 · S/N P767N869ATCxk1 LLC · Wilmington, DEBuilt 2026 · S/N 4496627N869BCInter American University Of Puerto Rico · Bayamon, PRBuilt 2026 · S/N 28020269N869CPExecutive Flight Institute LLC · Murrieta, CABuilt 1999 · S/N 17280641N869EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12679N869FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10346N869GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881468N869KF3 Aero LLC · New Lenox, ILFirst renewal noticeS/N 292-HN869NEJohn Cox LLC · De Witt, NEBuilt 1977 · S/N 15280149N869RRCooper Billy P · Columbia, MSBuilt 1979 · S/N 15283698N869RVThwaits John Drew · Ashland, MABuilt 2005 · S/N 90869N869TASheeptick LLC · Conrad, MTBuilt 2022 · S/N 2881545N869TTDimond Joan M · Birch Run, MIBuilt 1969 · S/N 157N869VLVieques Air Link Inc · Vieques, PRBuilt 1983 · S/N 1048N869WCSchofield Wayne D · Polson, MTBuilt 1957 · S/N 22-5521N86ABAir Sailing Inc · Reno, NVBuilt 1965 · S/N 25-3409N86AJMullins Mark C · Riverside, CABuilt 1972 · S/N 32-7200036N86AKBuss Bryce D · Homer, AKBuilt 2000 · S/N BC1-1N86AT86at LLC · Elizabethtown, PABuilt 1976 · S/N 61P-0364-114N86AVPlane Fun Inc Tr Trustee · Snellville, GAS/N 523N86AYN86ay LLC · Burke, VABuilt 1977 · S/N 32R-7780478N86BEEmery Odus D Jr · Weslaco, TXBuilt 2007 · S/N 3042
Back to AD 81-18-04 R2