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.

N344DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843832N344ESLake Superior Helicopters LLC · Duluth, MNBuilt 2015 · S/N 2402N344GStobbe Marlin · Ethridge, TNBuilt 2003 · S/N 10099N344JEAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13472N344LCDuyk Charles W · Saint Petersburg, FLBuilt 2018 · S/N 2564N344MARomeo Romeo LLC · Lewes, DEBuilt 2003 · S/N 40.344N344MCEuroaviation Inc · KematenBuilt 1973 · S/N 34-7450008N344RBContinental Aerospace Technologies Inc · Mobile, ALBuilt 2011 · S/N 172S11133N344RDSchab-Davis Margaret A · Spangle, WABuilt 2003 · S/N 02-PA18ABN344RLRed R44 LLC · Wilmington, DEBuilt 2019 · S/N 2598N344SAShier Aviation DBA · San Diego, CABuilt 2017 · S/N 30012N344SPSun City Aviation LLC · Davie, FLBuilt 1999 · S/N 172S8267N344WBeck Tom E · Homer, AKBuilt 1946 · S/N 12-775N344YUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 30056N34500Miller Judy Carole · No Palm Beach, FLBuilt 1972 · S/N 17701843N34502Cardinal Primo LLC · Mesa, AZBuilt 1977 · S/N 177RG1296N34506Tibbs Gary R · Marietta, GABuilt 1972 · S/N 17701846N3450AScootair LLC · Alburgh, VTBuilt 1953 · S/N 22-1719N3450WRst Aviation LLC · Vero Beach, FLBuilt 1965 · S/N 32-317N3450XCarey Patrick M · Citrus Heights, CABuilt 1966 · S/N 1136N3451Hardt Daniel M · Eugene, ORBuilt 1978 · S/N 173N34511Mazure Glenn J · Bad Axe, MIBuilt 1972 · S/N 17701849N3451334513 LLC · Stanton, TNBuilt 1972 · S/N 17701851N34519Mccarthy James E · Yucca Valley, CABuilt 1972 · S/N 17701855N3451KMorehead Matt F · Chico, CABuilt 1967 · S/N 28-23559N3451MWilliamson Gary T · Ashmore, ILBuilt 1947 · S/N 12-2342N3451QCcr Holdings LLC · Rushford, MNBuilt 1977 · S/N 28-7725228N3451TMichael W Maciol Md · Pelham, NYBuilt 1968 · S/N 17700751N3451ZHarris Michael E · Greenville, SCS/N 22-7370N34521Mitchell Robert A · Centennial, COBuilt 1972 · S/N 17701856N34524Registered aircraftBuilt 1972 · S/N 17701857N34528Mcmahon John · Sequim, WABuilt 1972 · S/N 17701859N3452AMolek Jon · Warren, OHS/N 22-1725N3452KRegistered aircraftBuilt 1967 · S/N 28-23561N3452TKordus Robert A · Union Grove, WIS/N 17700752N3452ZChief LLC · Du Quoin, ILBuilt 1960 · S/N 22-7371N3453MSmith Matthew M · Anchorage, AKBuilt 1947 · S/N 12-2340N3453QEdwards Latas L Jr · St Petersburg, FLFirst renewal noticeS/N 28-7716156N3453TAircraft Evolution LLC · Miami, FLBuilt 1968 · S/N 17700753N3453WBrown Craig · Vernal, UTBuilt 1966 · S/N 32-321N34543Riggs Jeffrey W · Claremore, OKBuilt 1973 · S/N 17701865N3454ABasler Leon E · Sainte Genevieve, MOBuilt 1953 · S/N 22-1723N3454CHenderson Eric R · Santa Rosa, CABuilt 1954 · S/N 26497N3454TTears Gary S · Edmond, OKBuilt 1968 · S/N 17700754N3454WRoos Paul A · Lake City, FLBuilt 1966 · S/N 32-322N3454XGarcia Eduardo G · Houston, TXBuilt 1966 · S/N 1138N34552Mlinarich Rob · Pottsboro, TXBuilt 1973 · S/N 17701868N34554Maryland Industrial Trucks Inc · Linthicum, MDS/N 17701870N34555Cardinal Aviation LLC · Everett, WABuilt 1973 · S/N 17701871N34556Thornsbury Nicholas J · Virginia Beach, VABuilt 1973 · S/N 17701872
Back to AD 81-18-04 R2