OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N138RCBardin G W · Granville, NYBuilt 1976 · S/N 177RG0994N138RJBayou Flight Training LLC · Niceville, FLBuilt 1988 · S/N 821N138RSPerry Louis D · Joseph, ORBuilt 1998 · S/N WA1714N138SCSelzer Robert Scott · Anchorage, AKS/N 7-0209N138SFUnderwood Mark A · Kennewick, WAS/N 28-20998N138TPTwo Pauls LLC · Forked River, NJBuilt 1968 · S/N 28-25301N138UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11487N138VAMysky LLC · Saint Louis, MOBuilt 2023 · S/N 28020112N138WSGardner Luther Winford III · Dallas, TXS/N 2038N13902Campbell Travis G · Starr, SCBuilt 1974 · S/N 17263035N13905Positive Rate LLC · Rutherford, NJBuilt 1974 · S/N 17263036N1390RYancy Timothy J · Chino Hills, CABuilt 1975 · S/N AA5-0790N1390TAccessible Aviation Inc · Tupelo, MSBuilt 1972 · S/N 34-7250274N13910Coryell James M · Valdez, AKBuilt 1974 · S/N 18-7409055N13911Northern Aeroworks LLC · Eagle River, AKBuilt 1971 · S/N 18-8972N1391CSale Reported · Beech Creek, PASale reportedBuilt 1953 · S/N 22-1143N1391RMccarthy Daniel J · San Diego, CAS/N AA5-0791N1391UArctic Winds Inc · King Salmon, AKS/N 17267062N1391WKotinek Douglas A · Rapid City, SDBuilt 1983 · S/N 124N13923Timoszyk James S · Wayne, MIBuilt 1974 · S/N 17263039N13925Lindsay John S · Freeport, PABuilt 1971 · S/N 18-8973N13927Zerck Joseph W · Anchorage, AKBuilt 1972 · S/N 18-8977N1392AHerrig Daniel C · King Salmon, AKBuilt 1951 · S/N 18-1228N1392WSale Reported · Lakeland, FLSale reportedBuilt 1964 · S/N 2670N13931Mahoney Edmund Mont · Anchorage, AKBuilt 1972 · S/N 18-8978N13937Rafter J Aviation LLC · Moab, UTS/N 18-8979N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477N1393CHayden Daniel · North Pole, AKS/N 20-980N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983N1393PSeymour Lori L · Woodstock, GAS/N 23-445N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064N1393VWayne Brett M · Saint George, UTS/N HAY 0001N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045N13943Tell Christopher A · Colville, WAS/N 17263046N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048N1394JFendi Aviation LLC · Petal, MSS/N 394N1394RRoss Bill · Meridian, MSBuilt 1952 · S/N 18-1983N1394WLuniewicz Morgan · Walnutport, PAFirst renewal noticeS/N 2672N1394YOjendyk Mark R · Newcastle, WABuilt 1953 · S/N 18-3357N13951Black Timber Aviation LLC · Rifle, COBuilt 1972 · S/N 18-8981N1395EHendricks Paul · Yellville, ARBuilt 1978 · S/N 17270984N1395FMoquin Christopher · Chicago, ILS/N 578 38 8392N1395JWard Brian S · Long Beach, CABuilt 1975 · S/N 395N1395RKing Rodney R · Lucedale, MSBuilt 1975 · S/N AA5-0795N1395TLegacy Aerospace Industries LLC · Miami, FLS/N 28R-7235277N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066N1395WRienstra Andrew P · South Lyon, MIBuilt 1964 · S/N 2673
Back to AD 81-18-04 R2