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.

N251WYNorton Robert · Coeur D Alene, IDBuilt 2015 · S/N 3251N251YAnderson Michael A · Bowie, MDBuilt 2021 · S/N M-II-2510N25200Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13385N25204Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13387N25205Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13390N25208Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13393N2520ARaptor Flight LLC · Fort Worth, TXS/N 38-78A0730N2520BRegistration Pending · Cheshire, CTRegistration pendingBuilt 1978 · S/N 38-79A0105N25210Mathison John M · Vancouver, WABuilt 1977 · S/N 76N25212Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13396N25213Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13399N25216Mcfarlane Claude L III · Fitchburg, WIBuilt 1977 · S/N 15280534N25218Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13402N25219Octopus Flying Club Inc · Riverdale, MDS/N 970N2521NOpen Heavens Aerospace LLC · Fort Gratiot, MIS/N 901N2521RSok Gregory J · Wallingford, CTBuilt 1969 · S/N 28-5641N2521SSieberts Soren K · Anchorage, AKBuilt 1979 · S/N 18-7909152N2521UN2521u LLC · Danbury, CTBuilt 1979 · S/N 28-8016029N2522Garella Craig W · Edwardsville, ILBuilt 2020 · S/N 42006N25220Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13405N25221Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280538N25225Howard Jeff S · Anderson, SCBuilt 1977 · S/N 15280541N25228Laguna Verde Leasing Inc · Wilmington, DES/N 15280543N2522APierce Stephan L · Graham, TXBuilt 1953 · S/N 22-830N2522BRossman Brian · Valparaiso, INS/N 863N2522CKlamecki Alan P · Phoenix, AZBuilt 1978 · S/N 38-79A0216N2522PPfisters Helicopters Inc · Pasco, WABuilt 2014 · S/N 2352N25233Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280545N2523AChadwick Harold T · Ottsville, PABuilt 1952 · S/N 22-829N2523BJenny Joe S · Fresno, CABuilt 1978 · S/N 38-79A0107N2523PHarris Jason C A · Unalakleet, AKS/N 22-2885N2523UPro Renovations Savannah Ltd Co · Savannah, GABuilt 1979 · S/N 28-8016030N2523ZBchr Aviation LLC · Boerne, TXBuilt 1977 · S/N 337-77N2524FWilkins Shelley A · Claremore, OKBuilt 1966 · S/N 72N2524MDd Leasing LLC · Aberdeen, IDBuilt 1946 · S/N 12-910N2524UAir Warriors LLC · Opelika, ALBuilt 1979 · S/N 28-8016031N2524WAerowave Aviation LLC · Noblesville, INBuilt 1973 · S/N MC-196N2524ZEgan Brian M · Saint Charles, ILBuilt 1977 · S/N 338-77N2525Davis Bill M · Kent, WABuilt 1976 · S/N 28-7790180N25252Scott Wilson A · Norman, OKBuilt 1980 · S/N 38-80A0005N25255Flm Aviation LLC · Vernal, UTBuilt 1977 · S/N 15280556N25259Miller Eric J · Mendocino, CAS/N 982N2525BOn Course LLC · Saint Charles, MOBuilt 1978 · S/N 38-79A0108N2525FGarbani Jacob R · Caldwell, IDBuilt 1966 · S/N 419N2525SJbird Aviation LLC · Elizabeth City, NCBuilt 2025 · S/N 1225-2025N2525YWilde Stephen · Elverta, CABuilt 1985 · S/N 28-8516075N25269Yankaskas Kurt D · Ijamsville, MDBuilt 1977 · S/N 15280563N2526MTulin Donald J · Anchorage, AKS/N 12-1017N2526SPlane Nutz LLC · Sugar City, IDBuilt 1979 · S/N R18201347N2526WCulling Thomas E · Venice, FLBuilt 2000 · S/N 25419
Back to AD 81-18-04 R2