OpenAirDocs.org
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.

N35749Pashley John F · Johnstown, NYBuilt 1968 · S/N 17256951N3574CAtd Pilot Training LLC · Kansas City, MOBuilt 1979 · S/N 28-8016200N3574JI.F.C. Inc · Wayne, NEBuilt 1979 · S/N 28-8090196N3574RGarner Financial Management Inc · Franklin, TNBuilt 1979 · S/N 32-7940287N3574ZWestwood Dave · Red Lodge, MTBuilt 1960 · S/N 18-7360N35751Bas Part Sales LLC · Greeley, COBuilt 1968 · S/N 17256953N35752Radcliffe Ronald W · Juneau, AKS/N 17256954N35753Gipson Aviation LLC · Beach City, TXS/N 17256955N35755Varin Joseph J · Smithfield, RIBuilt 1979 · S/N 28-8090200N3575AScoval Aviation LLC · Murray, KYBuilt 1979 · S/N 32R-8013034N3575KN83993 LLC · Cherry Hill, NJS/N 32R-8013037N3575LSwann Robert A · Hereford, AZS/N 15062375N3575NPierson Oran · Tucson, AZBuilt 1967 · S/N 680102N3575UJ P Aviation LLC · Kingfisher, OKBuilt 1979 · S/N 28-8090198N3575XSmith Foster Fritz · Bishopville, SCBuilt 1979 · S/N 28-8090199N3575ZRieke Rhett W · Bigfork, MTS/N 18-7364N35760Johnson Harry D Jr · Unalakleet, AKS/N 17256957N35762Aerial Sign North Inc · Lakewood, NJBuilt 1941 · S/N 5-753N35763Woodson Marcus S · Waxahachie, TXBuilt 1968 · S/N 17256958N3576ASolosky Robert L · North Barrington, ILBuilt 1953 · S/N 22-1850N3576HJohnson Grant J · Doylestown, PABuilt 1979 · S/N 28-8090205N3576JStephens Lloyd G · Saratoga, CABuilt 1979 · S/N 28-8090206N3576MFly Legacy Planes LLC · Philadelphia, PABuilt 1978 · S/N 28-7890315N3576RDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1979 · S/N 28-8090207N3576WEllison David L · Stockbridge, GABuilt 1966 · S/N 32-469N35770Ccb Flyers LLC · Waco, TXBuilt 1968 · S/N 17256959N35779Syrang Aero Club Inc · Cato, NYFirst renewal noticeBuilt 1968 · S/N 17256961N3577PKeegan Stephen E III · Nome, AKS/N 18-4531N3577QSousa Joao P · Prince Frederick, MDBuilt 1973 · S/N 17261678N35788Glennon Christopher M · Villa Park, ILBuilt 1968 · S/N 17256962N35789Barrett Robin C · Holwaloa, HIBuilt 1979 · S/N 28-8016230N3578KWienhold Kevin · Cuyahoga Falls, OHBuilt 1967 · S/N 28-23636N3578PTirrell Danielle J · Fairbanks, AKBuilt 1955 · S/N 18-4532N3578ZNance Gary L · Fairbanks, AKBuilt 1960 · S/N 18-7368N35790Integrity Aviation Inc · Worthington, MNBuilt 1968 · S/N 17256963N35795N35795 LLC · Fredericksburg, TXBuilt 1968 · S/N 17256965N35798Big Sky Aviation LLC · Massillon, OHBuilt 1968 · S/N 17256967N35799Huebner Otto · Bolingbrook, ILS/N 17256968N3579APerry John E · Kenai, AKBuilt 1953 · S/N 22-1854N3579BEssman Kenneth R · Burlington, WIBuilt 1950 · S/N 18-368N3579NPorter Gary · Oregonia, OHBuilt 1967 · S/N 680104N3579WGuzman Anthony J · Hacienda Heights, CABuilt 1966 · S/N 32-472N3579ZMartin Michael J · Anchorage, AKS/N 18-7369N357AHAtlantic Aviation International Inc · Lewes, DEBuilt 1987 · S/N 0711N357ASAero Leasing Inc · Medford, ORBuilt 2004 · S/N 10477N357AUWeakley Robert Kayce · Pleasant View, TNS/N 72320N357BCChristopher Brian A · Panama City Beach, FLBuilt 1998 · S/N 18280242N357BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2025 · S/N 2881912N357BKStone Michael · Palatka, FLBuilt 2003 · S/N 2353N357BUGilbert Jeffrey T · Tucson, AZBuilt 2023 · S/N 0357
Back to AD 81-18-04 R2