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.

N5843WSkyunityventures LLC · Richmond Hill, NYBuilt 1965 · S/N 28-2247N5843ZIkenberg H L · Butler, PABuilt 1963 · S/N 22-9697N5844HMccoy David L · Bear Creek, WIS/N 16-463N5844LHennell Elizabeth · Orrville, OHBuilt 1972 · S/N AA5-0044N5844WSmith William H · Weimar, TXBuilt 1965 · S/N 28-2237N5844ZJohnk Willi C II · Donalds, SCBuilt 1963 · S/N 22-9698N5845LKunkel Dennis J Co Trustee · Clearwater, MNBuilt 1972 · S/N AA5-0045N5845PGriffel Brandon T · Frederick, MDBuilt 1959 · S/N 24-926N5845ZGeldermann Bert E · Friday Harbor, WABuilt 1996 · S/N 230RN5846FDunning Steve L · Hopkinsville, KYBuilt 1976 · S/N 28-7790138N5846HTop Flight Detail LLC · Middlebury, INS/N 16-465N5846QGardner Perry F · East Canaan, CTBuilt 1965 · S/N 3132N5847PMyers Michael A · Indianapolis, INBuilt 1959 · S/N 24-928N5847UFly Vermont LLC · Swanton, VTBuilt 1969 · S/N 28-26678N5847WReed Charles W · Elizabeth City, NCBuilt 1965 · S/N 28-2286N5847XFowler Leo W · Port Alsworth, AKBuilt 1941 · S/N 7896N5848AKnight Farms Inc · Pasco, WAS/N 001JRAN5848HWhite Terry W · Saint Joseph, MIBuilt 1949 · S/N 16-467N5848LN5848l LLC · San Francisco, CABuilt 1972 · S/N AA5-0248N5848QValenti Edgar M · Gig Harbor, WABuilt 1965 · S/N 3133N5848WLedbetter Mark W · Garfield, ARBuilt 1965 · S/N 28-2292N58490Kushner Herbert A · Bridgewater, NJBuilt 1997 · S/N 1094N5849FGng LLC · Arlington, INBuilt 1976 · S/N 28-7790139N5849PJinnis Flight Enterprises LLC · Montgomery, TXBuilt 1959 · S/N 24-930N5849WHomic Michael J · Edmond, OKBuilt 1965 · S/N 28-2293N584BRRathburn Robert L · Edgewood, TXBuilt 2013 · S/N 82948N584CALance Toland Ltd · Griffin, GABuilt 1993 · S/N 14584N584CMBurns Timothy R · Eighty Four, PABuilt 1978 · S/N 24-0544N584FBenesch Benjamin · Sparks, NVBuilt 2000 · S/N 5084N584FLQuantum Aviation Services LLC · Lakewood Ranch, FLBuilt 1971 · S/N 28-7125439N584JHSoaring Eagle Aviation LLC · Missoula, MTBuilt 2001 · S/N 84N584KButterfield Rory A · Milan, NMBuilt 1975 · S/N 584N584LLawver William A · Panama City, FLBuilt 1972 · S/N AA5-0084N584LKTipton William M · Burlington, NCBuilt 1999 · S/N 103MN584LMTiede Russell James · Miami, AZBuilt 2003 · S/N 70171N584RVFelix Leonard D Jr · Salome, AZS/N 587N584SShobe Andrew S A · Clarksville, MDBuilt 1977 · S/N 28R7737112N584SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881403N584SFDsr Cherokee 180 LLC · Dallas, TXBuilt 1968 · S/N 17256834N584SPTexas State Technical College At Waco · Waco, TXBuilt 2000 · S/N 172S8511N584UConverse Donald A · Los Alamitos, CABuilt 1986 · S/N 862N584YKBachman David A · Griggsville, ILBuilt 1973 · S/N AA1B-0286N5850LXeus Inc · Nottingham, PABuilt 1972 · S/N AA5-0050N5850PInto The Forest Equipment LLC · Placerville, CABuilt 1959 · S/N 24-932N5850QMcmoran Donald W · Mount Vernon, WAS/N 3134N5850UMarfair LLC · Freeport, TXBuilt 1970 · S/N 28-26681N5850WCaside Aviation LLC · Brooklyn, NYBuilt 1965 · S/N 28-2296N5850ZMiller Helen J · Springfield, OHBuilt 1963 · S/N 22-9705N5851DRubbert Lorin E · Reynolds, NDBuilt 1956 · S/N 22-4530N5851LOretsky Philip H · South Haven, MIBuilt 1972 · S/N AA5-0051
Back to AD 81-18-04 R2