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.

N2591GRivero Mark A · Henderson, NVBuilt 1979 · S/N 38-79A0563N2591HRaile Randall J · Benkelman, NEBuilt 1979 · S/N 18-8009003N2591MFlyer One LLC · Palm Harbor, FLBuilt 1946 · S/N 12-950N2591VLivewire Holdings LLC · Salinas, CABuilt 1974 · S/N 177RG0627N25922Byrd-Pettit Caroline A · Smithfield, NCS/N 15280859N25929Trevisan Hugo S · Polk City, FLBuilt 1981 · S/N 38-81A0105N2592FDunlap Burton D · Mooresville, NCS/N 111N2592LLondke Kevin S · Lexington Park, MDBuilt 1979 · S/N 38-79A0774N2592PRogers Lee B · Anchorage, AKBuilt 1955 · S/N 18-4336N2592SSchaller Lee · New Athens, ILS/N 18-7909166N25932California In Nice Inc · San Jose, CABuilt 1977 · S/N 15280864N2593RWeatherly Lloyd W · Wittmann, AZS/N 28-5654N2593WUehlin Bradley S · Danbury, NEBuilt 1965 · S/N 3282N2593ZGuillen Gregorio J · Phillipsburg, NJS/N 27-8154007N25948Indiana State University · Terre Haute, INBuilt 1977 · S/N 15280875N2594GRuddle Kaleb T · Lawrenceburg, TNBuilt 1967 · S/N 448N2594MBertke Matthew B · Anchorage, AKS/N 12-1037N2594NDivinity Enterprises LLC · Wilmington, DEBuilt 1979 · S/N 38-79A0933N2594WMcclure Richard A · Victoria, TXBuilt 1965 · S/N 945N25950Gist Phillip C · Fort Worth, TXBuilt 1977 · S/N 15280877N25959South Texas Air Force LLC · Mission, TXS/N 38-81A0087N2595WReid Lois M · Dallas, TXBuilt 1965 · S/N 946N2596ARoach Wesley R · Marietta, GABuilt 1952 · S/N 22-875N2596BWynn Ralph H · Tulsa, OKBuilt 1978 · S/N 38-79A0143N2596EMeigs Jonathan H · Corning, NYBuilt 1978 · S/N 38-78A0483N2596JMarkshausen Zeke R · Santa Paula, CABuilt 1979 · S/N 18-7909121N2596PCarlson Eric S · Kodiak, AKBuilt 1978 · S/N 879N2596WClark Richard · Towanda, PABuilt 1965 · S/N 3283N25976Skylogix Aircraft LLC · La Verne, CAS/N 15280890N25979Andrews University · Berrien Springs, MIS/N 15280892N2597FDonovan Gerald A · Los Lunas, NMBuilt 1965 · S/N 2N2597ZSchroeder Herbert D · Plano, TXBuilt 1977 · S/N 1001-77N2598GRybacki Peter L · Great Barrington, MABuilt 1967 · S/N 423N2598PLeonard David J · Bettles Field, AKBuilt 1955 · S/N 18-4346N2598RRiff Raff Air LLC · Isle La Motte, VTBuilt 1969 · S/N 28-5655N2598WSunset Aviation LLC · New Iberia, LABuilt 1965 · S/N 949N25995Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280903N25998Carlin Delbert J · Blanchard, OKS/N 15280905N2599RNeo Aero LLC · Youngstown, OHBuilt 1969 · S/N 28-5656N2599WBinger Thomas C · Stillwater, MNBuilt 1965 · S/N 950N2599ZAirborne Images Inc · Encino, CABuilt 1977 · S/N 319-77N259ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496080N259BDRainier Flight Service LLC · Renton, WABuilt 2025 · S/N 172S13356N259CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881004N259CFMander John E · Kingston, TNBuilt 2003 · S/N BB2059N259CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282349N259DWSmith Jason · Calliham, TXBuilt 2003 · S/N 3492N259EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13335N259FCState Of Alabama · Montgomery, ALBuilt 2024 · S/N 18283276N259GFPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1997 · S/N 17280259
Back to AD 81-18-04 R2