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.

N5181EMustang Sally Aviation LLC · Camden, SCBuilt 2002 · S/N 172S9058N5181HRegistered aircraftBuilt 1975 · S/N 17265363N5181PFritz Joseph L · Eufaula, OKBuilt 1958 · S/N 24-202N5181REdelen Daniel R · Clayton, NCBuilt 1974 · S/N 17263398N5181SHicks Douglas A · Cumming, GABuilt 1970 · S/N 28-7105035N5181TSchmetter Kenneth E · Needville, TXBuilt 1967 · S/N 508N5181WSzymanski Janet M · Alanson, MIBuilt 1961 · S/N 28-216N5181XKummer Nicolas · Wenatchee, WABuilt 1969 · S/N 191N51826Van Dyke James C · Pleasant Grove, CABuilt 1980 · S/N 01VDN51827B D Aviation LLC · Sauget, ILBuilt 2002 · S/N 17281108N5182ERegistered aircraftBuilt 1978 · S/N 17271756N5182LGarden City Aviation LLC · Augusta, GABuilt 1967 · S/N 28-4469N5182PThede Dondi I · Marshall, WIBuilt 1958 · S/N 24-203N5182RHalf Wagon Innovations LLC · Cresson, TXBuilt 2000 · S/N 18280707N5182SFoster Tyler R · Levelland, TXS/N 28-7105036N5183HLlewellyn John M · Grangeville, IDBuilt 1949 · S/N 14-501N5183LWolstenholme Robert F · Line Lexington, PABuilt 1984 · S/N 0001N5183MGc Aviation Services 1 LLC · Miamisburg, OHBuilt 1978 · S/N ME-13N5183PAig Aeronautics LLC · Guaynabo, PRBuilt 1981 · S/N 15284890N5183RThompson Aerial Service Inc · Wyndmere, NDBuilt 1974 · S/N 17263400N5183SWestland Aviation LLC · Lake Havasu City, AZBuilt 1970 · S/N 28-7105037N5183TMinier Tryg · Corralitos, CABuilt 1967 · S/N 16N5183XStory James W · Byhalia, MSBuilt 1969 · S/N 170N51840Sky Bubble LLC · Santa Ana, CABuilt 1980 · S/N 17274359N5184EStringfellow Timothy C · Maryville, TNBuilt 1978 · S/N 17271758N5184GSicking Ryan · Gainesville, TXBuilt 2002 · S/N 18281104N5184HReynolds Michael A · Fairbanks, AKBuilt 1949 · S/N 14-502N5184JRiverside Flight Academy LLC · Riverside, CAS/N 17273721N5184LOtt Timothy M · Ida, MIBuilt 1967 · S/N 28-4472N5184PBarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281105N5184S1st Cooling Inc · Rockwall, TXBuilt 1970 · S/N 28-7105038N5184XComstock Derrick B · Salol, MNBuilt 1969 · S/N 173N5184ZCox Ronnie · Whitesburg, GABuilt 1961 · S/N 22-8851N5185DMartinez Richard Christian · Stockbridge, MIS/N 17272441N5185QRegistered aircraftBuilt 1989 · S/N 300N5185TRomano Serge · Beaverton, ORBuilt 1967 · S/N 15N5185UMoyer Aviation Inc · Tobyhanna, PABuilt 2002 · S/N 172S9059N5185YPiedmont Flight Inc · Winston Salem, NCBuilt 2002 · S/N 172S9060N5185ZTroy Michael J · Albion, NYS/N 22-8852N51863Green Wendell L · Argyle, TXBuilt 1980 · S/N 46N51865Savage Michael B · Lincoln, CABuilt 1981 · S/N 17274362N5186HPope Brian B · Coalgate, OKBuilt 1975 · S/N 17265365N5186LKlippel Charlie L · Huntington Beach, CABuilt 1980 · S/N 15284276N5186WQuick Janice L · Wrightwood, CABuilt 1961 · S/N 28-221N5186XRochelle Stephen L · Raymond, MSBuilt 1969 · S/N 198N5186YHowe Jamie W · Boynton Beach, FLS/N 690030N5186ZBearer Ronald C · Wimauma, FLBuilt 1961 · S/N 22-8853N51871Az2026 LLC · Miami, FLBuilt 1980 · S/N 17274366N51875Wings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 17274369N5187AHada Benjamin · Andrews, TXBuilt 2002 · S/N 18281111
Back to AD 81-18-04 R2