OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N3053NAnywhere Atp LLC · Mount Juliet, TNBuilt 1979 · S/N 28-7990288N3053ZSonntag Franklin T · Stevensville, MDBuilt 1959 · S/N 22-7007N30540Steinmetz Peter N · Tempe, AZBuilt 1968 · S/N 17701312N30542Yatman Mark Eugene · San Anselmo, CABuilt 1968 · S/N 17701314N30543Schultheis John U · Wasilla, AKBuilt 1994 · S/N 20017CN30544Flying Twenty Inc · San Jose, CAS/N 17701316N30546Brady Dennis J Jr · Chesterfield, MOBuilt 1968 · S/N 17701318N30547Wright Thomas L · Clyde, OHBuilt 1968 · S/N 17701319N3054EPrinceton Flying Club Inc · Wilmington, DEBuilt 1978 · S/N 17271421N3054LNationwide Aviation LLC · Hudson Oaks, TXBuilt 1979 · S/N 28-7916250N3054MRegistration Pending · Reseda, CARegistration pendingS/N 28-7890292N3054QAlessi Brian C · Blossvale, NYBuilt 2003 · S/N 5702N3054TVidal Aviation LLC · Gaithersburg, MDBuilt 1979 · S/N 28-7990325N3054ZSandall Brian E · Lake Stevens, WABuilt 1959 · S/N 22-7008N30553Jfe LLC · Flossmoor, ILBuilt 1968 · S/N 17701322N30556Amundson Clyde E · Poplar Grove, ILBuilt 1968 · S/N 17701324N30557Wilson Thomas L · Sheboygan, WIBuilt 1968 · S/N 17701325N3055BSale Reported · Gainesville, FLSale reportedS/N 28-7990137N3055CCrecente Joseph W · Indn Hbr Bch, FLBuilt 2007 · S/N 28025CN3055EFisher Joseph · Canadian, TXS/N 1579N3055NAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 2007 · S/N 4168N3055PZebroski Andrew John · Seattle, WABuilt 1957 · S/N 23-967N3055RAll Sky Aviation LLC · Farmington, UTBuilt 1979 · S/N 32-7940053N3055SWcm Ventures LLC · Hondo, TXBuilt 2007 · S/N 1745N30561Eisele William L · Laporte, INBuilt 1978 · S/N 28-7990096N30565Flowings LLC · Orlando, FLBuilt 1968 · S/N 17701331N30567Sale Reported · West Liberty, KYSale reportedBuilt 1968 · S/N 17701332N3056ARegistered aircraftBuilt 1953 · S/N 25700N3056MGrald Jonathan A · New Hampton, NYS/N 12-1744N3056SMagic Shuttle Bus Air Tours LLC · Traverse City, MIBuilt 1979 · S/N 28R-7918058N3056ZPopson LLC · Peachtree City, GABuilt 1979 · S/N 28-7990412N30570Gallacher Mark A · Salem, UTBuilt 1968 · S/N 17701333N30571Spencer Burton D · Mchenry, ILS/N 17701334N30573Dentdel Inc · Wilmington, DEBuilt 1994 · S/N 1615N30574Carter Peter M · Elkhorn, WIBuilt 1969 · S/N 17701337N30578Rhodes Michael · Jacksonville, FLBuilt 1969 · S/N 17701339N30579Dry Creek Services LLC · Lodi, OHBuilt 1974 · S/N 17264145N3057FN3057f LLC · Branson, MOBuilt 1978 · S/N 28-7990226N3057MAg Aero Inc · Lenzburg, ILBuilt 1977 · S/N 28-7890293N3057PMcneil Michael D · Caro, MIS/N 23-969N30584New Horizons Aviation LLC · East Helena, MTBuilt 1969 · S/N 17701344N3058MMcguire Patrick · Greenleaf, WIS/N 12-1585N3058TN3058t LLC · Cheyenne, WYBuilt 1979 · S/N 28R-7918062N3058VN5237l LLC · Oswego, NYS/N 1617N3058ZLove Glen L · Poplar Grove, ILBuilt 1959 · S/N 22-7013N30592Kussmaul Richard · Clinton, MIBuilt 1994 · S/N 11093CN30597Brewer Aviation LLC · Winslow, ARBuilt 1969 · S/N 17701350N30599Wilson Phillip W Jr · Kailua, HIBuilt 1969 · S/N 17701351N3059BBay De Noc Flying Club Inc · Escanaba, MIBuilt 1978 · S/N 28-7990138N3059FAtwell Charles A · Eldred, NYBuilt 1969 · S/N 28-25760
Back to AD 81-18-04 R2