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.

N2370UWatts Keith R · Chapel Hill, TNBuilt 1963 · S/N 17249970N2371CMathers John R · Denton, TXBuilt 1953 · S/N 30671N2371ETmc Shooting Range Specialist Inc · Valencia, CAS/N 17271254N2371RBudell Stacey M · Caldwell, IDBuilt 1964 · S/N 18255471N2371XCouch Sue A · Dewy Rose, GABuilt 1965 · S/N 18256271N2372CMartin Land Improvement Inc · Elk Rapids, MIBuilt 1978 · S/N R18200164N2372DTucker Matthew T · Dillingham, AKS/N 20524N2372GJohnson David B · Santa Barbara, CABuilt 1958 · S/N 51672N2372USky View Aviation LLC · Lenoir, NCBuilt 1962 · S/N 17249972N2372XRegistered aircraftBuilt 1965 · S/N 18256272N2373CDs Flight Services LLC · Battle Ground, WABuilt 1978 · S/N R18200165N2373FRlo Aviation LLC · Double Springs, ALBuilt 1965 · S/N 21058573N2373UBeeline Aviation LLC · Austin, TXBuilt 1962 · S/N 17249973N2374CJackson Jeffrey D · Elk City, OKBuilt 1978 · S/N R18200166N2374GAirco International LLC · Everett, WAS/N 51674N2374UEstes Kenneth · Benton, KSBuilt 1962 · S/N 17249974N2374XMorrison Aircraft · Harrisburg, ARS/N 18256274N2375CEverwind Aviation LLC · Kalispell, MTBuilt 1978 · S/N R18200167N2375DGauntt Chep · Goodyear, AZBuilt 1952 · S/N 20527N2375SLundin Lawrence D · Midvale, IDBuilt 1976 · S/N 21061257N2375XBaldwin Todd K · Prescott Valley, AZBuilt 1965 · S/N 18256275N2376GN2376g LLC · Helena, MTBuilt 1958 · S/N 51676N2376UHowell Rebecca Elizabeth · Elgin, TXBuilt 1962 · S/N 17249976N23777Erb Ralph J · Mebane, NCS/N R1720096N2377EBeck Roger M Trustee · Goode, VABuilt 1978 · S/N 17271256N2377FBuoni Frank · Bakersfield, CABuilt 1965 · S/N 21058577N2377GLutz Matthew S · Lewistown, MTBuilt 1958 · S/N 51677N2377XBieker Tor M · Hood River, ORBuilt 1965 · S/N 18256277N23788Bellendir Timothy J · Fort Morgan, COBuilt 1967 · S/N R172E-0092N2378CHovda H O · Progreso, TXBuilt 1953 · S/N 30678N2378GStramel Matthew J · Elko, NVBuilt 1958 · S/N 51678N2379CWest Country Aviation Inc Trustee · Wilmington, DEBuilt 1978 · S/N R18200170N2379DMoore Orville G · Hays, KSBuilt 1952 · S/N 20531N2379RLanzetta Kenneth · Oakland Park, FLBuilt 1979 · S/N 18266988N2379UAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1962 · S/N 17249979N2379XK Fortner LLC · San Marcos, TXS/N 18256279N2379YThelwell Llansley · Frisco, TXBuilt 1967 · S/N 17700179N237CTSkymax LLC · Stanford, KYBuilt 1968 · S/N 18258819N237DTBurque Sean Michael · New Braunfels, TXBuilt 1962 · S/N 17249862N2380DKovalchik Janet N Trustee · Kernersville, NCBuilt 1952 · S/N 20532N2380RReep Nicolas K · Yakima, WABuilt 1964 · S/N 18255480N2380XGaller Mary D Trustee · Elysian, MNBuilt 1965 · S/N 18256280N2381CLee Kevin M · Rexburg, IDBuilt 1954 · S/N 30681N2381DShryock Jennifer M · King Salmon, AKS/N 20533N2381FOops LLC · Cheyenne, WYBuilt 1965 · S/N 21058581N2381GKittelman Thomas L · Gilbert, AZS/N 51681N2381XCooper Scott J · Fellows, CABuilt 1965 · S/N 18256281N2382GGish Joseph B · Lewiston, IDFirst renewal noticeBuilt 1958 · S/N 51682N2382SMielczarek Joe I · Santa Paula, CABuilt 1967 · S/N 337-0682N2382UMrnm LLC · Albia, IABuilt 1963 · S/N 17249982
Back to AD 87-20-03 R2