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.

N7490FDodson International Parts Inc · Rantoul, KSS/N 570596N7490PRobinson John W · Ten Mile, TNBuilt 1961 · S/N 24-2683N7490WCome Fly With Me LLC · Columbiana, ALBuilt 1963 · S/N 28-1401N74911Aerial Messages Leasing Co · Longwood, FLS/N 18-7509092N74912Sky Sailing Inc · Warner Springs, CABuilt 1975 · S/N 18-7509094N74913Street Raymond E Jr Trustee · Fort Worth, TXBuilt 1975 · S/N 18-7509095N74914Tachoir Steven E · Marienville, PABuilt 1968 · S/N 67-15442N74919Braden John H · Watseka, ILBuilt 1975 · S/N 18-7509096N7491GAccess Air Service Inc · Mercedita, PRBuilt 1970 · S/N 17259191N7491KGidzinski Daniel P · Campbellsburg, KYBuilt 1950 · S/N 20-404N7491WWillard Michael W · Boonville, NCS/N 28-1402N74922Sale Reported · Anchorage, AKSale reportedBuilt 1975 · S/N 18-7509097N74924Rs Specialties LLC · Anchorage, AKBuilt 1975 · S/N 18-7509098N74929Shadbolt George Q · Merriman, NES/N 18-7509101N7492FHouston Police Dept · Houston, TXBuilt 2008 · S/N S1920N7492JClassic Air Aviation LLC · Mesa, AZBuilt 1968 · S/N 28R-30852N7492PCache Rentals 401k P.S.P. · Greeley, COS/N 24-2686N7492WN7492w LLC · Spicewood, TXBuilt 1963 · S/N 28-1405N74935Mcevoy Richard D Trustee · Anchorage, AKBuilt 1975 · S/N 18-7509100N7493FHouston Police Dept · Houston, TXBuilt 2008 · S/N S1921N7493GHaugo Robert P · Scobey, MTBuilt 1970 · S/N 17259193N7493JRegistered aircraftBuilt 1968 · S/N 28R-30854N7493PBassar Michael · Eagle, MIBuilt 1961 · S/N 24-2687N7493RWalcher James W · Wilmington, ILBuilt 1966 · S/N 28-22047N7493WNonn Lidia G · Appleton, WIBuilt 1965 · S/N 28-2900N74945Wright Sherry L · Buhl, IDBuilt 1975 · S/N 18-7509102N7494KWeaver Marvin Thomas · Kalispell, MTBuilt 1950 · S/N 20-409N7494PM And P Aviation Inc · Albia, IABuilt 1961 · S/N 24-2689N7494WLandreth Homer W · Peoria, AZBuilt 1963 · S/N 28-1407N7494YRay James O III · Mc Rae, GABuilt 1964 · S/N 30-555N74954Willis Andrew B · Wasilla, AKBuilt 1975 · S/N 18-7509103N7495JDreamair LLC · Fargo, NDBuilt 1968 · S/N 28R-30856N7495PSale Reported · Fort Lauderdale, FLSale reported, pending cancellationBuilt 1961 · S/N 24-2690N74960Smith Wallace B · Fairbanks, AKBuilt 1975 · S/N 18-7509105N74964Air Dakota Flite Inc · Hettinger, NDBuilt 1975 · S/N 18-7509104N74967Owens Sara R · Casper, WYS/N 18-7509107N74968Niesen Isaac W · Nikiski, AKBuilt 1976 · S/N 18-7709045N7496DLeggett Brandon · Eola, TXBuilt 1957 · S/N 18-5837N7496PS & S Air Inc · Wilmington, DEBuilt 1961 · S/N 24-2691N74979Johnson Warren E · Kenai, AKBuilt 1975 · S/N 18-7509109N7497PLift Aircraft LLC · Carmel, INBuilt 1961 · S/N 24-2692N7497TLeffler Greg L · Zion Crossroads, VABuilt 1959 · S/N 47097N7498JSawyer Steven A Md · Hampton, GABuilt 1968 · S/N 28R-30860N7498PKarnegis Frank J · Senoia, GABuilt 1961 · S/N 24-2693N74990Berry Stanley W · Reddick, FLBuilt 1975 · S/N 18-7509111N74996Seward Air Taxi LLC · Seward, AKBuilt 1975 · S/N 18-7509112N74998White Jacob E · Delta Junction, AKBuilt 1975 · S/N 18-7509106N7499KBarnes Darin L · Wasilla, AKS/N 20-413N7499PTri-C Farms · Tompkinsville, KYBuilt 1961 · S/N 24-2696N7499RCart Caleb L · Eunice, LAS/N 28-22054
Back to AD 81-18-04 R2