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.

N40CZBeast Aero Consulting And Training LLC · Rosamond, CAS/N 0763N40DACirrus Design Corp · Duluth, MNBuilt 1965 · S/N 30-904N40DCWright Innovators LLC · Sebastian, FLBuilt 1988 · S/N 561N40DLStyer David B · Pendleton, ORBuilt 1971 · S/N 071N40DMChapman Randy J · Jackson, NHS/N 2102N40DRRoss David R · Wakeman, OHBuilt 1991 · S/N DR-01N40DZSt. Bernard Aerial LLC · Kalispell, MTBuilt 1947 · S/N 12-2675N40EBWegman Jacob L · Rochester, MNBuilt 1985 · S/N 984N40EHHibler Phillip E · Alameda, CABuilt 1995 · S/N 2067N40EMYour Moms Upset LLC · Saint Paul, MNS/N 696-92N40ERFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17269569N40ESP.C. Air LLC · Lockport, NYBuilt 2008 · S/N 71432N40EZMaui Aero LLC · Yelm, WAS/N 69N40FAWright Paul G Trustee · Scotts Valley, CABuilt 1972 · S/N AA5-0114N40GECuckler Dale E · Tulsa, OKBuilt 1998 · S/N 1545N40GRPetao LLC · Trinity, FLBuilt 2003 · S/N 21980N40HDDrollinger David H · Kennewick, WABuilt 1987 · S/N 040N40HFVogel Essex Nathaniel B · Berkeley, CAS/N 15072309N40HUMoore Charles B · Miles City, MTBuilt 1996 · S/N 1315N40HYHendrickson Dale W · Denton, TXBuilt 2002 · S/N 2205N40JTav8rs LLC · Tea, SDS/N 001N40JAJersey Aero Club Inc · Lakewood, NJBuilt 1985 · S/N 28-8616036N40JGSimms Charles Jr · Lexington, KYBuilt 1968 · S/N 28R-30953N40JKMann Nathan · Poulsbo, WABuilt 2022 · S/N 11480N40JMAll Breeds Combined LLC · Kalispell, MTS/N 540-2011N40JSAir Flight Enterprises Inc · South Daytona, FLS/N 24-3269N40JVWhiting Andrew W · Mentor, OHBuilt 1977 · S/N 80N40KEValiair Lc Trustee · Casper, WYBuilt 2018 · S/N 70311N40KHMccormick Robert E · Selah, WABuilt 1979 · S/N 13082N40KKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N KK-1N40KLConstantine Lucas L · Inglewood, CAS/N 40.316N40KMFlight Tech LLC · Prosser, WABuilt 2000 · S/N 23063CN40KPZoie Air LLC · Fort Lauderdale, FLBuilt 2003 · S/N 30030CN40LLWalker Christopher J · Mason City, NEBuilt 2021 · S/N 3358N40LYAsh Gary W · Houston, TXBuilt 1978 · S/N 17270900N40MBAndersen Thomas · Yoder, COS/N 708N40MGFly Arkansas LLC · Harrison, ARBuilt 1959 · S/N TD-293N40MRWennberg Timothy J · Mariposa, CABuilt 1979 · S/N 001N40MUOracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264170N40NCJones Edward B · Valdese, NCBuilt 1980 · S/N 32-8006014N40NZGround Effect LLC · Atascadero, CABuilt 1974 · S/N 32-7440171N40PJMitchell Everett · Glendive, MTS/N 3066N40PXHealey David A · Hammondsport, NYBuilt 2003 · S/N 14110CN40PZHaagenson Trevor · Portland, ORBuilt 2006 · S/N 155N40RBKmg Aviation Holdings LLC · Hartville, OHBuilt 1976 · S/N 177RG1071N40RFGamma Flight LLC · Reno, NVBuilt 2007 · S/N 172S10473N40RGDovy Aviation LLC · Houston, TXBuilt 1974 · S/N 17263241N40RSSaul Gregory D Jr · Glenrock, WYBuilt 1960 · S/N 24-2031N40SASemper Fi Aviation LLC · Brooksville, FLS/N 32-111N40SFSterling Flight Training LLC · Jacksonville, FLBuilt 2020 · S/N 2881377
Back to AD 81-18-04 R2