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.

N3378AThompson William A · Wenatchee, WAS/N 22-1635N3378CWaples Charles Andrew · Red Lodge, MTBuilt 1978 · S/N R18200277N3378EVisalia Flyers LLC · Visalia, CABuilt 1978 · S/N 17271524N3378WKimball Jason S · Riverview, FLS/N 32-232N3378XBurdis W J · Beaver Falls, PABuilt 1966 · S/N 1093N33793Schwartz Robert E · Middleburg, FLBuilt 1975 · S/N 28-7515363N33795Coco Phillip J · Middletown, CTBuilt 1975 · S/N 28R-7535194N33796235 Flying Circus Inc · Gillette, NJBuilt 1975 · S/N 28-7510063N3379AKurronen Eric D · Anchorage, AKBuilt 1953 · S/N 22-1634N337ABPlane And Simple Leasing LLC · Delano, MNBuilt 1960 · S/N 25-459N337AMBrine William H · Edgartown, MABuilt 2006 · S/N 2337N337BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881099N337BMSky Drivers LLC · La Fayette, GABuilt 1999 · S/N 18280629N337CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283116N337CWWebb Peter C · Rockport, MEBuilt 2010 · S/N 90811N337DBOlson Vienette · White Bear Lake, MNBuilt 2001 · S/N 18281027N337DCRichards Douglas A · Cookeville, TNBuilt 1978 · S/N F33700086N337DPCollins Paul C · Boise, IDBuilt 2012 · S/N 3144N337EPAtp Aircraft 4 LLC · Wilmington, DEBuilt 1978 · S/N 44-7995064N337FBMa Aviation Group LLC · Farmingdale, NYBuilt 2003 · S/N 2843550N337GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881424N337GFLewis John P · Alachua, FLBuilt 1969 · S/N 17258349N337HCustom Aircraft Inc · Palmer, AKBuilt 1999 · S/N 2999N337HRRahlf Steven · Muscatine, IAS/N 3N337JMJstol LLC · Monrovia, INBuilt 2022 · S/N CCK-1865-1107N337MEFlytcentrix LLC · Lewes, DES/N 172S8468N337MGTew-Mac LLC · Tewksbury, MABuilt 2025 · S/N 2810N337RARogers Kenneth R · Sandusky, OHBuilt 1978 · S/N 3099N337RVGeorge Gary D · Humble, TXBuilt 2010 · S/N 71040N337SBA1b LLC · Hinsdale, MTBuilt 2000 · S/N 2052N337TJeanes Douglas G · Frisco, TXBuilt 1953 · S/N 18-2451N337WMLee Mark A · Toppenish, WABuilt 2023 · S/N MAL-001N337XP3 Points LLC · Comstock Park, MIS/N 736N338Plane Fun Inc Tr Trustee · Snellville, GABuilt 1993 · S/N 2141N33802Drew Mark David · Phoenix, AZBuilt 1975 · S/N 28-7515364N33803Mclellan Simon W · Monroe, WABuilt 1975 · S/N 28-7505182N33804Klintrin Collectibles LLC · Downers Grove, ILBuilt 1975 · S/N 28R-7535195N33806Eagle 64 LLC · Stuart, FLBuilt 1975 · S/N 28-7515365N3380AStephan Pamela K · Anchorage, AKS/N 22-1637N3380KKabat Jules Max · Las Vegas, NVBuilt 1946 · S/N 1373N3380MSkaggs Jay D · Eagle River, AKBuilt 1947 · S/N 12-2227N3380XGretencord Howard F Trustee · Kansas City, MOBuilt 1966 · S/N 3381N3380ZSchwend Brian · Forsyth, MTBuilt 1960 · S/N 18-7261N33815Hyde Leasing LLC · Water Valley, MSBuilt 1975 · S/N 28R-7535199N33816Hettinger John E · Sterling, COBuilt 1975 · S/N 28R-7535200N3381MAdirondack Legacy Aircraft LLC · Saratoga Springs, NYBuilt 1947 · S/N 12-2230N3381XBagwell Trevor T · Valencia, CABuilt 1966 · S/N 3382N3382MGarber Linn A · Custer, SDBuilt 1947 · S/N 12-2229N3382WMoffatt Jeffrey Charles · Morgan Hill, CABuilt 1965 · S/N 32-237N33831D&K Sales Inc · Canton, GABuilt 1975 · S/N 32-7500032
Back to AD 81-18-04 R2