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.

N48WLAtkinson Matthew D · Theodore, ALBuilt 1978 · S/N AA5B0892N48WYTyphoon Products Inc · Umatilla, FLBuilt 2021 · S/N 3362N49004Oakland Flyers LLC · Oakland, CAS/N 15281094N49005Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15281095N4900CRider Bradley H · Juneau, AKBuilt 2013 · S/N AI-18062N4900HNew Horizon Aviation Inc · Warwick, RIBuilt 1980 · S/N 15284009N4900JUniversal Technical Institute Inc · Avondale, AZBuilt 1968 · S/N 28R-30617N4900LJonghan Park · Stanton, CABuilt 1980 · S/N 15284241N4900URegistration Pending · Rockville, MDRegistration pendingBuilt 2005 · S/N 2842240N4900ZPeden Max S · Eagleville, TNBuilt 1961 · S/N 22-8483N4901MSchaller Lee · New Athens, ILBuilt 1947 · S/N 11-422N4901ZUnger Michael D · Bellingham, WAS/N 22-8486N49024B2fh Ltd · Allentown, NJBuilt 1977 · S/N 15281106N49025Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 15281107N4902FFlying Vikings Inc · Hayward, CABuilt 1979 · S/N 17273099N4902LObrien William M · Aptos, CABuilt 1967 · S/N 28-4269N4902SBbsa Flight LLC · Tucson, AZBuilt 1979 · S/N R18201442N49039Welcome Aviation LLC · Hayward, CABuilt 1977 · S/N 15281115N4903LPlane Crazy Aviation LLC · Hollywood, SCBuilt 1967 · S/N 28-4270N49043Edwards Pacific Aviation Corp · Dover, DEBuilt 1977 · S/N 15281117N4904GC & W Aviation LLC · Trumbull, CTBuilt 1979 · S/N 17273451N4904JLunken Air Group LLC · Cincinnati, OHS/N 28R-30622N4904LSchmick David D · Sturgis, MIBuilt 1967 · S/N 28-4271N4904PCivil Air Support LLC · Phoenix, AZBuilt 1961 · S/N 27-495N4904SO Neil Mark F · Suffolk, VABuilt 1979 · S/N R18201444N49055Lima Aviation LLC · Lake Havasu City, AZBuilt 1977 · S/N 15281126N4905JMoore Albert III · Las Vegas, NVBuilt 1968 · S/N 28R-30623N49060Skylogix Aircraft LLC · La Habra, CABuilt 1979 · S/N 15283410N4906JSeal Air LLC · San Juan Capo, CABuilt 1968 · S/N 28R-30624N4906LRitter Steven L · Harlingen, TXBuilt 1967 · S/N 28-4274N4906SSweeney Peter Allan · Irvine, CABuilt 1979 · S/N R18201446N4906TSmith Bruce · Leonardtown, MDBuilt 1972 · S/N 28R-7235158N49070Ilmberger Stephen Joseph · San Leandro, CABuilt 1977 · S/N 15281133N49075Mccullough Nancy D · Abilene, TXBuilt 1979 · S/N 15283412N49079Alexander Joseph · Hamilton, INBuilt 1977 · S/N 15281138N4907JHarmon Neil A · North Chelmsford, MABuilt 1968 · S/N 28R-30625N4907LSmooth Landin Inc · Melville, NYBuilt 1967 · S/N 28-4222N4907PTabor Conor C · Littleton, COBuilt 1961 · S/N 27-498N4907TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250184N4907ZChristie Ian A H · Limon, COS/N 22-8492N4908JHolm R Stan · College Place, WABuilt 1968 · S/N 28R-30626N4908PJohnson Dalton S · Sterling, AKBuilt 1962 · S/N 18-7789N49090Victory Aviation LLC · Winchester, VABuilt 1979 · S/N 15283415N49094Fleck Richard N Trustee · Camarillo, CABuilt 1979 · S/N 15283416N4909GRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1979 · S/N 17273456N4909SRice Philip V · Sublette, KSBuilt 1970 · S/N 28R-35681N4909ZVersatile Aviation LLC · Waterford, MIBuilt 1961 · S/N 22-8494N490AFEiffert Matthew T · Ukiah, CABuilt 1970 · S/N 17701493N490BYancey Patrick D · Spirit Lake, IDS/N 1994N490CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282205
Back to AD 81-18-04 R2