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.

N46VCAltitude & Anchor LLC · Kalispell, MTS/N 3206N46VTPh Aviation Inc · Lewes, DEBuilt 2015 · S/N 40138N46WStansell Clayton H · Los Lunas, NMBuilt 1965 · S/N 1N46WFFoy William N · Murfreesboro, TNS/N 32-971N46WMMallia Karen W · Schenectady, NYBuilt 1997 · S/N 31N46WPPowers Phillip M · Cumberland Gap, TNS/N 60376N46YHDouglas Hiram P · Godley, TXBuilt 2025 · S/N 21026N46YMAircraft Partner Holdings Inc Trustee · BerlinBuilt 1992 · S/N 10026N4700SGiddyup Flyers LLC · Danville, CABuilt 1979 · S/N R18201388N4701LTrainor Jonathan P · Bridgewater, NJS/N 28-4014N4701SBailey Mark E · Owingsville, KYBuilt 1979 · S/N R18201389N47023Morey John Jack · Port Orange, FLBuilt 1977 · S/N 28-7890049N47028My Way Aviation LLC · Weston, FLS/N 15283159N47029Geronimo Aviation LLC · Scottsdale, AZBuilt 1979 · S/N 15283160N4702FSouthern Aces LLC · Geneva, FLBuilt 1979 · S/N 17273074N4702HAbove All Others Consulting Inc · West Palm Beach, FLBuilt 1979 · S/N 24-0812N4702PWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284801N4703AStromberg Gary J · Medicine Lake, MTS/N 18-4918N4703LMaust Luke A · Accident, MDBuilt 1967 · S/N 28-4017N4703ZStarling Ronald A · Prescott, AZBuilt 1961 · S/N 22-8245N4704HWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 15283966N4704PCarlson Brent · Medford, ORBuilt 1960 · S/N 27-232N4704ZRegistration Pending · Canyon Country, CARegistration pendingBuilt 1961 · S/N 22-8246N47053Semagin Arkadi · Burlingame, CABuilt 1979 · S/N 15283163N4705DN4705d LLC · Oklahoma City, OKS/N 17272335N4705HWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 15283967N4705LHorton Kelly · Hollis, OKBuilt 1967 · S/N 28-4019N4705PHam Edward E · Boring, ORBuilt 1960 · S/N 27-233N4705QWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 152-85053N4705WPelch Jeffrey W · Dallas, TXBuilt 1978 · S/N 13276N4706DKelly William W · Springfield, ORBuilt 1979 · S/N 17272336N4706LKings Heir Inc · Kent, WABuilt 1967 · S/N 28-4026N4706SGreat Lakes Aviation LLC · Burtchville, MIBuilt 1979 · S/N R18201392N4706ZAirsmith Aviation LLC · Oshkosh, WIS/N 22-8248N4707ASherman Aviation Inc · Redmond, ORBuilt 1956 · S/N 18-4924N4707CSmith James A · Lyle, WABuilt 1955 · S/N 22-3291N4707JBeck Joseph P II · Pollock, LABuilt 1966 · S/N MA-147N4707LJet & Rotor Aviation LLC · Sacramento, CABuilt 1980 · S/N 15284222N4707SBas Part Sales LLC · Greeley, COBuilt 1979 · S/N R18201393N4707TVan Ausdall John C · Spring Branch, TXBuilt 1981 · S/N R18201739N4707YWengair LLC · Powell, WYBuilt 1967 · S/N 25-4439N4707ZBradsher Larry Flint · Rougemont, NCBuilt 1961 · S/N 22-8250N4708AFranz Stanley · Yakima, WABuilt 1956 · S/N 18-4926N4708LAlexander Nicholas R · Oak Hill, OHBuilt 1967 · S/N 28-4027N47093Skipper Consulting LLC · Athens, ALBuilt 1942 · S/N 2N4709LJohannsen Michael R · Allen, TXBuilt 1967 · S/N 28-4028N4709RG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0013N4709SMolinar Antonio L · El Paso, TXBuilt 1979 · S/N R18201395N470AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843742N470AKAkima Logistics Services LLC · Usaf Academy, COBuilt 2018 · S/N CC18-0089
Back to AD 81-18-04 R2