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.

N261HHoward Clifford E · Auburn, WABuilt 1968 · S/N R.E.C.2N261JBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12575N261KTFrisch Adam · Los Angeles, CAS/N 61P-0437-163N261MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881311N261MMCockroft Scott · Kersey, COBuilt 2000 · S/N 30015CN261RMOlandese Donald J · Newalla, OKBuilt 2011 · S/N 91507N261SCIndia Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13439N261VFBickley Clarence R · Jefferson, GABuilt 1989 · S/N 576RN261WYFoss Jared K · Greenbush, MNBuilt 2016 · S/N 3261N261XEvans Dennis · Naples, FLBuilt 2000 · S/N 60239N26200Ulmer Clarence G · Aladdin, WYBuilt 1940 · S/N 7501N26206Breakey Phillip · Pickerington, OHBuilt 1977 · S/N AA5A0471N2620CWhalen Shenandoah · Amelia, OHBuilt 1987 · S/N 0725N2620MBooth Chance · Wasilla, AKBuilt 1946 · S/N 12-1091N2621AFox Jeff R · Soldotna, AKBuilt 1952 · S/N 18-2168N2621KBasmajian Zachary Robert · Peoria, AZBuilt 1954 · S/N 54-2629N2621MWestern Oklahoma Aviation LLC · Clinton, OKBuilt 1977 · S/N 28-7816297N2621QBrown Russell C · Howey, FLBuilt 1977 · S/N 28-7725202N2621ZWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1998 · S/N 17280559N26225Kilday Klayton D DBA · Dexter, ORBuilt 1989 · S/N 1138N2622HBurgess John H · Tower, MNS/N 001N2622MN2622m LLC · Rehoboth Beach, DEBuilt 1982 · S/N 0735MN2622TStenvers Aaron · Valley, NEBuilt 1991 · S/N 1823N2622WMohamed Eman Z · Lubbock, TXBuilt 1966 · S/N 3295N26234Compositec Inc · Manitowoc, WIS/N AA5A0458N26236Mcdonnel Jack Edward Jr · Woodsboro, TXBuilt 1977 · S/N AA5A0475N26237Registration Pending · Spokane, WARegistration pendingBuilt 1977 · S/N AA5A0476N26239Rice Grantland S · Boston, MABuilt 1977 · S/N AA5A0477N2623BWalton Indy R · Soldotna, AKS/N 5160N2623PJd Aero LLC · Chester, SDBuilt 1955 · S/N 22-2959N26240Gilmer Thomas · Deridder, LABuilt 1977 · S/N AA5A0478N26244Clear Blue Aviation LLC · Melbourne, FLBuilt 1977 · S/N AA5A0480N26247Royer Virgil P · Salem, ORBuilt 1977 · S/N AA5A0482N2624AWsiaki Kenneth J · Northridge, CABuilt 1953 · S/N 22-1091N2624NBoston Helicopters Inc · North Andover, MAS/N 0739N2624PRobinson Eric C · Palmer, AKS/N 22-2960N2624WWilkins James K · Owens Cross Roads, ALBuilt 1966 · S/N 966N26253Tompkins Robert G · Panacea, FLBuilt 1979 · S/N AA5A-0819N26255Wren Donald F · West Chester, OHBuilt 1977 · S/N AA5A0485N2625AGundersen James I · Townsend, MTBuilt 1952 · S/N 18-2170N2625CL&W Leasing LLC · Murfreesboro, TNBuilt 1998 · S/N 17280436N2625SSierra Aviation LLC · Plaza, NDBuilt 1979 · S/N R18201350N2625WPatton William D · Sheridan, WYBuilt 1966 · S/N 967N26264Edb Air Inc · Wilsonville, ORBuilt 1998 · S/N 18280265N26265Rogers B L · Martinsburg, WVBuilt 1940 · S/N 7552N2626BRodgers Patti · Apple Valley, CABuilt 2004 · S/N 90429N2626PLeguia Augusto A · Kathleen, GABuilt 1955 · S/N 22-2963N2626SDelta Aero LLC · Sarasota, FLBuilt 2026 · S/N 1226-2026N26273Gasiorowski Mark A · Buford, GABuilt 1977 · S/N AA5A0500N26275Bresser Jason R R · Soldotna, AKS/N 7559
Back to AD 81-18-04 R2