OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N24152Miller Michael S · Wills Point, TXS/N 178N24153Mt Vernon Airport Authority · Mount Vernon, ILBuilt 1981 · S/N 17275094N24155American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275290N2415PGlahn Guy R · Surprise, AZBuilt 1955 · S/N 18-4290N2416AKoenig Caleb A · Huntsville, TXBuilt 1952 · S/N 22-782N2416BSouth Texas Air Force LLC · Mission, TXS/N 38-79A0052N2417ASitta Donald C · Farmington, NMBuilt 1952 · S/N 22-781N2417EWolthuis Ivan H · Sweet Home, ORS/N 17271274N2417GDel-Sky LLC · Dilliner, PABuilt 1979 · S/N 38-79A0523N2417KDarley Vernon O · Peachtree City, GABuilt 2024 · S/N HC 0186N2417MRens Troy D · Marshfield, WIBuilt 1977 · S/N 32R-7880064N2417PMehling Craig · Hardin, MTS/N 18-4293N2418ANation Linda S · Sanford, FLBuilt 1952 · S/N 22-784N2418KSterba Edward J · Ocala, FLBuilt 1979 · S/N 38-79A0622N2418MBallow Richard C · Valdez, AKBuilt 1947 · S/N 12-1652N2418RMann Steven · High Springs, FLBuilt 1969 · S/N 28-5617N2418VHart William Kirby · Springville, CABuilt 1960 · S/N 27-81N2419ABoehlke Kevin P · New Baltimore, NYBuilt 1952 · S/N 22-786N2419PRegistration Pending · Lavale, MDRegistration pendingBuilt 1955 · S/N 22-3091N2419RLynch Gerald A · Santa Barbara, CABuilt 2000 · S/N 18280927N2419TN2419t Inc · Okeechobee, FLBuilt 1978 · S/N 38-78A0799N241ACTwob LLC · Eden Prairie, MNBuilt 1999 · S/N 1373-98N241AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281182N241ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496039N241AWStewart Lawrence D · Council Bluffs, IABuilt 2004 · S/N 5614N241BHughes Dustin G · Texarkana, TXBuilt 2016 · S/N 571702N241BDHanus David S · Mound, MNS/N 60477N241CFPalermo Michael S · Carter Lake, IABuilt 1957 · S/N 23-1160N241DKSale Reported · Wilmington, DESale reportedBuilt 2022 · S/N 367N241DWGaither William W Jr · Shallotte, NCS/N 634RGN241EPiedmont Aviation Leasing LLC · Monticello, GABuilt 1971 · S/N 17259889N241EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2024 · S/N 172S13238N241GSmith Albert K · Pentwater, MIBuilt 1978 · S/N 14394N241GWWheeler Gregory R · Spicewood, TXS/N 2248N241HBEngelmann Christopher · Mayer, MNBuilt 2019 · S/N 1241N241HCButcher Robert E · Friendswood, TXBuilt 2005 · S/N 81966N241HRHickey Timothy J · Montrose, IABuilt 2016 · S/N 808RN241JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020011N241JESmedshammer Paul J · Petaluma, CABuilt 2001 · S/N 23868N241JJN241jj LLC · Louisville, KYBuilt 2025 · S/N 18283313N241JPNate Nelsen LLC · Enterprise, ALBuilt 1963 · S/N 30-241N241KCChase Kenneth W · Anvik, AKS/N 22-4138N241KDReiter Kenneth L · Plano, TXBuilt 1998 · S/N 162N241KSCrane Kermit J · Topeka, KSBuilt 1973 · S/N 17262602N241LWDrouin William · Brookline, NHBuilt 1970 · S/N 700088N241MAKim Sung Su Trustee · Upland, CABuilt 2010 · S/N 3110N241ME#430b LLC · Bruce Township, MIBuilt 2000 · S/N 18280761N241MJMj Aero LLC · Mims, FLBuilt 1987 · S/N 1055N241NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1999 · S/N 2842051N241PArnston Ranch Inc · Circle, MTBuilt 1992 · S/N 1214
Back to AD 81-18-04 R2