OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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.

N82WAVomela Paul Trustee · Wasilla, AKBuilt 1978 · S/N 18266327N82XTPerreault Mark L · Van Buren, MEBuilt 1979 · S/N 18266945N82YMiller Charles G · Anchorage, AKBuilt 1958 · S/N 51039N8300AChapa Jana K · Corpus Christi, TXBuilt 1952 · S/N 25152N8300BMonger Kenneth R · Bella Vista, ARBuilt 1957 · S/N 36100N8300MWiener Ronald K Trustee · Tucson, AZBuilt 1976 · S/N 18264583N8300QSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N U20603161N8300UFrisby Richard V · Fredericksburg, VABuilt 1964 · S/N 17252200N8301AFrazer Wendy J · Meridian, IDBuilt 1952 · S/N 25153N8301UN8301u LLC · White Springs, FLBuilt 1964 · S/N 17252201N8301XLindeman Rusty · D Hanis, TXBuilt 1961 · S/N 17248801N8302GLittle Air Dream LLC · Mooresville, NCBuilt 1965 · S/N 15062402N8302XManley Stephen Edward · Carrabelle, FLBuilt 1961 · S/N 17248802N8302ZAbbott Barry · Tempe, AZBuilt 1963 · S/N 205-0302N8303AMiller A Barry · Lincoln, ILBuilt 1952 · S/N 25155N8303BBack Jason M · Poolville, TXBuilt 1957 · S/N 36103N8303JFodero Jesse G · West Seneca, NYBuilt 1967 · S/N 15066203N8303SSamia Robert B · The Plains, VABuilt 1965 · S/N 18256403N8303TBingham John V · King George, VABuilt 1961 · S/N 17557003N8304AWehner John P · Malone, WIS/N 25156N8304BWarzecha Kathy A · Sauk Rapids, MNBuilt 1957 · S/N 36104N8304MUecker Richard H · Dania Beach, FLBuilt 1976 · S/N 18264585N8304XAeschliman Arlie W · Tribune, KSBuilt 1961 · S/N 17248804N8304ZBin Parts Inc · Fargo, NDS/N 205-0304N8305BHansen Mark A · Savannah, GABuilt 1957 · S/N 36105N8305MGossage Terrence L · Port Angeles, WABuilt 1969 · S/N A1500005N8305SHatley Ralph A · Eagle Creek, ORBuilt 1965 · S/N 18256405N8305TBradford Alfred G · San Antonio, TXS/N 17557005N8305USkyhawk Leasing LLC · Port Huron, MIBuilt 1964 · S/N 17252205N8305ZAlpha Cloud LLC · Lake Wylie, SCBuilt 1963 · S/N 205-0305N8306BCoopsair LLC · Saint Petersburg, FLS/N 36106N8306GLees Michael S · Port Allen, LABuilt 1965 · S/N 15062406N8306MJohnson Airspray Inc · Argyle, MNBuilt 1976 · S/N 18264586N8306SConte Michael R · Collinsville, OKS/N 18256406N8306TBowers Roy L · Valley Springs, CABuilt 1961 · S/N 17557006N8307ASweetnam G Leslie · Woodstock, CTBuilt 1952 · S/N 25159N8307BRogers Eric M · Cascade, IDBuilt 1957 · S/N 36107N8307GRegistered aircraftS/N 15062407N8307SKohlitz Jeffery P · Harrison Township, MIBuilt 1965 · S/N 18256407N8307TMark Lang Construction LLC · Blooming Prairie, MNBuilt 1961 · S/N 17557007N8308APrice Jerry A · Joiner, ARBuilt 1952 · S/N 25160N8308BBerg Timothy J · Neenah, WIS/N 36108N8308GThompson Stephen A · Murphy, NCBuilt 1965 · S/N 15062408N8308SThun John C · Concrete, WABuilt 1965 · S/N 18256408N8308TRegistration Pending · San Tan Valley, AZRegistration pendingBuilt 1961 · S/N 17557008N8309GWoods Allen D · Old Hickory, TNBuilt 1965 · S/N 15062409N8309MCarlisle C A P Flying Club Inc · Carlisle, PABuilt 1976 · S/N 18264587N8309TMudd Robert John · Moriarty, NMBuilt 1961 · S/N 17557009N8309ZCypress Church Farms LLC · Greenwood, SCBuilt 1963 · S/N 2050309N830BABarr Air Patrol LLC · Mesquite, TXBuilt 1984 · S/N 18268390
Back to AD 87-20-03 R2