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.

N55935Teprovich Thomas J III · Peachtree City, GABuilt 1973 · S/N 28R-7335313N55938Turner Cole M · Round Rock, TXBuilt 1973 · S/N 287325536N5593HLandreth Homer W · Peoria, AZBuilt 1951 · S/N 20-655N5593PDingus Donald E Jr · Brownfield, TXBuilt 1959 · S/N 24660N5593QBrazdys Luke V · Kingman, AZBuilt 1965 · S/N 2987N5593ZEastern Stearman Inc Trustee · Leesburg, VABuilt 1962 · S/N 22-9404N55940Zadrick Wayne J · Bristol, CTBuilt 1973 · S/N 28-7325537N55942Ray Lynn M · Cloquet, MNBuilt 1973 · S/N 28-7325538N55948N235ml LLC · Marshalltown, IABuilt 1973 · S/N 28R-7335316N5594PBombo Aviation LLC · Gold Beach, ORBuilt 1959 · S/N 24-661N5594YWdw Aviation Leasing Inc · Knoxville, TNBuilt 1964 · S/N 1140329N55954Registration Pending · Jacksonville, FLRegistration pendingBuilt 1973 · S/N 28-7325539N55955Pierce Riley Deirdre · Chicago, ILBuilt 1973 · S/N 28-7325542N55958Rl Magneto LLC · Sacramento, CABuilt 1973 · S/N 28R-7335317N5595EV & E Sunset LLC · St George, UTBuilt 1978 · S/N 17271897N5595FByrne Matthew A · West Allis, WIBuilt 1968 · S/N 28-24883N5595HHornby James C · Kaukauna, WIBuilt 1951 · S/N 20-659N5595PCassell Joseph · Singer, LABuilt 1959 · S/N 24-662N5595QLivezey Patrick · Lithia, FLBuilt 1965 · S/N 2988N55960Gallagher Sean · Cave Creek, AZBuilt 1973 · S/N 28R-7335318N55965Greene County Flying Club · Waynesburg, PABuilt 1973 · S/N 28-7305510N55967Hisman Gary L · Skagway, AKS/N 28-7305511N55968Tindle David W · Fennville, MIFirst renewal noticeS/N JC-1N5596JJenny LLC · Hudsonville, MIBuilt 1968 · S/N 32-1037N5596UPine Aviation Inc · Sheridan, WYBuilt 1969 · S/N 28-26326N5596ZLamb Steve E · Big Bear City, CABuilt 1962 · S/N 22-9407N5597Quinn Michael P · Matthews, NCS/N BF-P478N55970Soaring Eagle Aviation LLC · Carmi, ILBuilt 1973 · S/N 34-7350266N55973Crase Nicole Trustee · Mansfield, OHBuilt 1973 · S/N 28-7325543N55975Pena Leonardo · The Colony, TXBuilt 1973 · S/N 28-7325545N55977Walker Benjamin M · Weatherford, TXBuilt 1973 · S/N 28-7305512N55979Acumen Aerotech LLC · Rogers, TXBuilt 1973 · S/N 28R-7335321N5597FDeardorff Karl R · San Luis Obispo, CABuilt 1968 · S/N 28-24853N5597HNicholson Robert Lyle · North Ogden, UTS/N 20-661N5597UFejor Inc · San Juan, PRBuilt 1969 · S/N 28-26327N5597WLathrop Christopher A · Palmyra, WIBuilt 1962 · S/N 28-733N55986Turner Jeffrey K · Gastonia, NCBuilt 1973 · S/N 28R-7335322N55988Murawski Rene · Clarkston, MIBuilt 1973 · S/N 28-7325549N5598FKeran Gary R · New Holstein, WIBuilt 1976 · S/N 28-7725064N5598JMakfly LLC · Chardon, OHBuilt 1968 · S/N 32-1065N5598UHilton Colby W · Amarillo, TXBuilt 1969 · S/N 28-26328N5598WBall Dontel J · Tacoma, WAS/N 28-734N5598ZEkstrom David L · Bemidji, MNBuilt 1962 · S/N 22-9409N55990Registered aircraftN-number assigned, not yet registeredS/N 28R-7335323N55996Mcfarlane Randall C · Loudonville, NYBuilt 1973 · S/N 28R-7335325N5599BMccain David O · Ashville, ALBuilt 1980 · S/N 0828N5599KDayton Walter S · Napa, CAS/N R18200922N5599QFerraro Christopher · Croydon, PABuilt 1965 · S/N 2990N5599WPhoenix Aviation LLC · Claremore, OKBuilt 1962 · S/N 28-736N559BDBiggs Aviation LLC · Decatur, INBuilt 2004 · S/N 1470
Back to AD 81-18-04 R2