OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,718

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.

N116SLXcel Aviation LLC · Eagle, IDBuilt 2003 · S/N 18281242N116TRobinett Barton L · Frankston, TXBuilt 1952 · S/N 18-2230N116TBMcmullan Francis G · Weirsdale, FLS/N 362N116TSIrish Cindy L · Buckeye, AZBuilt 2003 · S/N 60399N116URobinson Michael E · Anthony, NMS/N 1557866N116UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1223N116VGBruns Phillip T · Shiro, TXBuilt 1998 · S/N 18280346N116VKAirborne LLC · Wilmington, DEBuilt 2018 · S/N 2547N116WBDunch David J Trustee · Poland, OHBuilt 1998 · S/N 18280170N116ZXVranjes Peter · Johnstown, COBuilt 1997 · S/N 18280042N11702Tailwheeling It LLC · Algoma, WIBuilt 1972 · S/N 317-72N11704Jackman William L · Newman Lake, WAS/N 857-72N11706Hershberger Brian K · Wrightwood, CABuilt 1972 · S/N 319-72N11707Catfish Express Inc · Inverness, MSBuilt 1972 · S/N 15-72N11709Hutchins Reid C · Hanover, NHBuilt 1972 · S/N 859-72N1170AAbbott Barry R · Sterling, AKBuilt 1951 · S/N 18-768N1170JHoward Thomas D · Bunnlevel, NCBuilt 1974 · S/N 170N1170LSweet Aviation LLC · Dover, DES/N 332N1170MBryson William H III · Cook, MNBuilt 1969 · S/N 17258670N1170YMacmullen Kenneth P · Quakertown, PAS/N 15059570N1171CUnser Joshua D · Anchorage, AKBuilt 1953 · S/N 20-963N1171JNational Test Pilot School · Mojave, CABuilt 2007 · S/N 18281985N1171LN1171l LLC · Newport News, VABuilt 1982 · S/N 24-1330N11720Mcfarlane Kevin E · Dubuque, IABuilt 1972 · S/N 860-72N11721Yague-Martinez Eloy · Rochester, NYBuilt 1972 · S/N 320-72N11723Rader Mark Todd · Deland, FLBuilt 1975 · S/N 17702361N1172MTodd Kevin E · Bismarck, NDBuilt 1969 · S/N 17258672N1172PSteed William B · Winnsboro, SCS/N 23-175N11730Sendelbach John W · Cochrane, WIBuilt 1975 · S/N 17702362N1173CHolland Todd D · Mendota, ILBuilt 1977 · S/N 17702679N1173JCohelios LLC · Oviedo, FLBuilt 1974 · S/N 135N1173MFlathead Lake Aviation LLC · Polson, MTBuilt 1969 · S/N 17258673N1173XWnc Aviation LLC · Arden, NCBuilt 2006 · S/N 172S10379N1173YSorg Daniel T · Columbus, INS/N 001N1174CGeorgia Forestry Commission · Macon, GABuilt 2007 · S/N 18281905N1174EInman James Dylan · Parsons, TNS/N 1228-78N1174JOlson Michael J · Viroqua, WIBuilt 1974 · S/N 174N1174MWhitted Danny E · Candler, NCBuilt 1969 · S/N 17258674N1174PHardin John M · Terrell, TXBuilt 1955 · S/N 23-188N11756Creswell Philip M · Camden, ALBuilt 1975 · S/N 17702365N1175ABurmeister Aaron R · Nenana, AKBuilt 1951 · S/N 18-777N1175ENannini Gary S · Lincoln City, ORBuilt 1977 · S/N 314-77N11760Davis Richard M · League City, TXBuilt 1934 · S/N A-689N1176EIrving Holdings LLC · Greensboro, NCBuilt 1977 · S/N 988-77N1176RBas Part Sales LLC · Greeley, COBuilt 2005 · S/N 18281688N1176TP C O Leasing Inc · Dobbin, TXBuilt 2005 · S/N 18281587N1176UPlane Leasing LLC · Wilmington, DEBuilt 1976 · S/N 17266877N11771Boss Gary W · Bronston, KYBuilt 1975 · S/N 17702366N1177AN1177a LLC · Lewes, DEBuilt 1977 · S/N 32R-7780430N1177BTakacs John Paul III · Colorado Springs, COBuilt 1991 · S/N 651-91
Back to AD 81-18-04 R2