OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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:87-20-03-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:87-20-03-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.

N2411CMacadams Christopher L · Bloomington, MNS/N 30714N2411DBinsky Lawrence A · Bexley, OHS/N 20563N2411JKenney Jason M · Grand Rapids, MIBuilt 1966 · S/N 15065511N2411LEfinger John M · Cresson, TXS/N 17255611N2411RLowery Jerry W · Cartersville, GABuilt 1964 · S/N 18255511N2411USiemens Jonathan Lee · Seminole, TXBuilt 1963 · S/N 17250011N2411YMullings Michael A · Orange, NJBuilt 1962 · S/N 17249711N2412CRigid Oilfield Services LLC · El Reno, OKS/N 30712N2412QTickemyer David K · Warrensburg, MOBuilt 1966 · S/N 18257612N2412UHill Brock E · Palouse, WABuilt 1963 · S/N 17250012N2413SQualitair LLC Trustee · MichelstadtBuilt 1967 · S/N 337-0713N2413UAmazon Aero Corp · Wilmington, DES/N 17250013N2413YRegistration Pending · Bangor, MERegistration pendingS/N 17249713N24143Angel Aviation Inc · Peoria, AZS/N 55436N2414DSmith Nathias N · Weiser, IDS/N 20566N2414URozell Wallace R · Argyle, TXBuilt 1963 · S/N 17250014N2414YHigh Flight LLC · Casey, ILBuilt 1962 · S/N 17249714N24153Mt Vernon Airport Authority · Mount Vernon, ILBuilt 1981 · S/N 17275094N24155American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275290N24159Power Alan T · Los Alamos, NMBuilt 1982 · S/N 18504346N2415FTrutschel Steven R · Waynesville, OHBuilt 1965 · S/N 18051615N2415L98x LLC · Caddo Mills, TXS/N 17255615N2415QPagel David R · Tioga, NDBuilt 1966 · S/N 18257615N2415RRegistered aircraftBuilt 1964 · S/N 18255515N2416CTa Ritchey LLC · Batavia, OHBuilt 1954 · S/N 30716N2416LBeck Roger M Trustee · Goode, VABuilt 1966 · S/N 17255616N2416QAltitude Addiction LLC · Harker Heights, TXS/N 18257616N2416USzabo Stephen A · Sacramento, CABuilt 1963 · S/N 17250016N2417CW & K Aviation LLC · Omro, WIS/N 30717N2417EWolthuis Ivan H · Sweet Home, ORS/N 17271274N2417LBox Aviation Inc · Montgomery, ALBuilt 1966 · S/N 17255617N2417QMcgough Julie Eileen · Red Oak, TXS/N 18257617N2417RJohary Aviation Inc · Apopka, FLS/N 18255517N2417SPiasecki Aircraft Corporation · Coatesville, PABuilt 1967 · S/N 337-0717N2417XGerding Thomas P · Philomath, ORBuilt 1965 · S/N 18256317N24187Heil Brad C · Homer, AKBuilt 1972 · S/N 18502031N2418CBlythe Anne T · Paso Robles, CABuilt 1954 · S/N 30718N2418DRogers Colin · Nevada City, CABuilt 1952 · S/N 20570N2418GSunset Cay Orc Partners LLC · Key Largo, FLS/N 51718N2418LF Sharp Aviation LLC · New Baltimore, MIBuilt 1966 · S/N 17255618N2418SThomas Michael Ray · Marshall, MOBuilt 1967 · S/N 337-0718N2418UGronning Chris D · Anchorage, AKBuilt 1963 · S/N 17250018N2418XPoessel Frank George Jr · East Bernard, TXBuilt 1965 · S/N 18256318N2419DHansen Michael C · Roseville, CABuilt 1952 · S/N 20571N2419FMartinez Rudy J · Wasilla, AKBuilt 1965 · S/N 18051619N2419GBig Sky Aviation LLC · Kapaau, HIBuilt 1958 · S/N 51719N2419JScheller Dwain A · Grand Rapids, MIBuilt 1966 · S/N 15065519N2419L2419l LLC · Jackson, MIBuilt 1966 · S/N 17255619N2419QScholl Steven G · Bluffton, SCBuilt 1966 · S/N 18257619N2419YBaker Adam W · Germantown, TNBuilt 1962 · S/N 17249719
Back to AD 87-20-03 R2