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.

N331CMCard Donald J · Dallas, TXBuilt 1999 · S/N 1N331CPCivil Air Patrol · Montgomery, ALBuilt 2019 · S/N 172S12342N331DHEaves Donald Ray · Byhalia, MSFirst renewal noticeBuilt 2000 · S/N 21754N331DJMugford David Allen · Annapolis, MDBuilt 2007 · S/N 40331N331DWHaehnel Patrick J · Elbert, COBuilt 2001 · S/N 001N331ESJackson Paul D · Chesapeake, VAFirst renewal noticeBuilt 2001 · S/N 1067N331FBurton Charles E · Jackson, CABuilt 2001 · S/N 5703N331GPDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 44-7995277N331GTPope Kent M · Hayden, IDBuilt 1984 · S/N 331N331GWFieldcrest Air LLC · Latrobe, PABuilt 2021 · S/N 18283147N331GZN331gz LLC · Fort Myers, FLBuilt 1980 · S/N WA-116N331HTTope Loren C · Cody, WYBuilt 1989 · S/N HT-1N331JArndt Brent · Kodiak, AKBuilt 2023 · S/N 1331N331JBBostik Josef J · Green Cove Springs, FLBuilt 2002 · S/N 25108N331JHStack Trevor J · Keller, TXBuilt 2005 · S/N 40142N331JKKenzy 2020 LLC · Aurora, ORBuilt 2021 · S/N 172S12751N331MDMedmission Supplies LLC · Escondido, CABuilt 2018 · S/N 90991N331MEHarrison Matthew T · Naponee, NEBuilt 2000 · S/N 172S8464N331MKStardust Aviation LLC · Farmingdale, NYBuilt 2001 · S/N 2843477N331MSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 18282021N331NTCrowley E Ned · Londonderry, NHS/N N.C.1N331PEnglish Barton C · Liberty Corner, NJBuilt 2007 · S/N 40143N331PAHale Enterprises Inc · Carbondale, ILBuilt 2002 · S/N 2843514N331PHAppel Raymond Lee · Incline Village, NVBuilt 1977 · S/N 28-7710045N331RDHiggins Roland · Solon Springs, WIBuilt 2005 · S/N 25720N331RPRaritan Valley Flying School · Princeton, NJS/N 172S9863N331SYTorii Aviation LLC · Naperville, ILBuilt 1980 · S/N 7N331TShimkus Stanley M · N Huntingdon, PABuilt 1953 · S/N 18-2445N331VNYokosawa Kenneth Eino · Grand Blanc, MIBuilt 1982 · S/N 21N331VRRoof Jerry G · Centennial, COBuilt 1991 · S/N 509N331WTillman Nickolas R · Piggott, ARBuilt 1972 · S/N 287225543N331WBAb Aviation LLC · Ashland, OHBuilt 1969 · S/N 28-5401N3320MFena Daniel J · Side Lake, MNBuilt 1947 · S/N 12-2177N3320ZHolton Mark · Lebanon, MOBuilt 1960 · S/N 22-7255N33212Burlingame Lloyd · Fort Atkinson, WIBuilt 1976 · S/N 177RG0920N3321BLee Donald R · Talkeetna, AKS/N 22-2136N3321LN3321l LLC · Dacula, GAS/N 3321N3321TWilks Donald Leon · Flat Rock, ALBuilt 1967 · S/N 17700621N33220Advanced Analytical Inc · Newbury Park, CABuilt 1976 · S/N 177RG0925N3322AJohnson Ezra M · Rhinelander, WIS/N 22-1598N3322GLone Star Flight Museum · Houston, TXBuilt 1970 · S/N 39-10N3322KHamilton Roger A Trustee · Pisgah Forest, NCBuilt 1975 · S/N AA5B-0046N3322WWilson Devin · Star, IDBuilt 1965 · S/N 32-156N33230Alaska Air Service LLC · Brookings, ORBuilt 1976 · S/N 177RG0930N3323BCenterville Air Techs LLC · Centerville, IABuilt 1954 · S/N 22-2138N3323MTalbot Larry · Bradenton, FLBuilt 1977 · S/N 28-7890296N3323TDeese James K Jr · Charlotte, NCS/N 17700623N33248Wilson Harvey Lee · Gadsden, ALBuilt 1976 · S/N 177RG0932N3324MBush Pilot Inc · Soldotna, AKBuilt 1947 · S/N 12-2183N3324WThompson Mark D · West Chicago, ILBuilt 1965 · S/N 32-158
Back to AD 81-18-04 R2