OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N4317RSam Aviation LLC · Long Beach, CAS/N 17263070N4318LPhillips Matthew L · Las Cruces, NMBuilt 1966 · S/N 17254387N4318NBybee James W · West Jordan, UTBuilt 1948 · S/N 7092N4318RBeaulieu Steven · Georgetown, DEBuilt 1974 · S/N 17263071N4318UCragg Gordon · Georgetown, TXBuilt 1964 · S/N 15060318N4319BClay Charles E · Alhambra, CABuilt 1955 · S/N 26663N4319RWoodland William B · Anchorage, AKFirst renewal noticeBuilt 1976 · S/N 18502931N4319VBarron Jon M · Perry, MOBuilt 1948 · S/N 7226N431ARegistered aircraftBuilt 1976 · S/N 17265942N431DKrause Derris O · Cumberland, MDS/N 15066583N431MLFarr Francis A · Bozeman, MTBuilt 1975 · S/N 18263538N4321QW H Flying Club Inc · Kingston, MIS/N 17260221N4321UBurdett Michael R · Dawsonville, GABuilt 1964 · S/N 15060321N4321XGrady Auctions & Realty Inc · Newport, ARBuilt 1965 · S/N 21058623N4322LShastri Milind J · Seminole, FLBuilt 1966 · S/N 17254391N4322RKing Air Charter LLC · Zanesville, OHBuilt 1978 · S/N R18200590N4323LReed Darran K · Whitney, TXBuilt 1966 · S/N 17254392N4323NGrant Yeol D · Livermore, CABuilt 1948 · S/N 7086N4323QWausau Flying Service Inc · Wausau, WIBuilt 1971 · S/N 17260223N4323RMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263076N4323VRhodes John D · Tarzana, CAS/N 7316N4324LMesa Aviation LLC · Alpine, TXBuilt 1966 · S/N 17254393N4324NLeighton George E · Seattle, WABuilt 1948 · S/N 7085N4324RShadle James A Jr · Gig Harbor, WABuilt 1974 · S/N 17263077N4324UPerot Mark E · Homer, LABuilt 1964 · S/N 15060324N4325BWattum Joel W · Wasilla, AKBuilt 1955 · S/N 26669N4325LJ & F Aviation Adventure LLC · North Fort Myers, FLBuilt 1966 · S/N 17254394N4325QBeier Mark E · Sylvania, GABuilt 1971 · S/N 17260225N4325RGaruda Aviation Inc · Miami, FLBuilt 1974 · S/N 17263078N4326BRopp Doug · Albany, ORS/N 26670N4326QStar Fleet Aviation LLC · Bisbee, AZBuilt 1971 · S/N 17260226N4326ULampley Timothy · Nolensville, TNS/N 15060326N4327QFackler Aviation Services LLC · Clearwater, FLBuilt 1971 · S/N 17260227N4327UHodges Caleb F · Omaha, TXBuilt 1964 · S/N 15060327N4327VFultz Andrew J · Starkville, MSBuilt 1948 · S/N 7270N4328QBetzner John C · Medway, MABuilt 1971 · S/N 17260228N4328VLumcavok Aviation 1 Inc · Middletown, DEBuilt 1948 · S/N 7234N4329LHanson Randy J · North Branch, MNBuilt 1966 · S/N 17254398N4329NPulver Douglas A · Kenockee, MIBuilt 1947 · S/N 7080N4329QElfers Brian K · Colfax, WAFirst renewal noticeBuilt 1971 · S/N 17260229N4329UCarvalho Brandon A · Camarillo, CAS/N 15060329N432BAAnderson Jerry J · Vacaville, CABuilt 1956 · S/N 32279N432DTrollinger Lari D · Wanette, OKBuilt 1964 · S/N 15060762N432DBDepcinski Travis A · Fairbanks, AKBuilt 1956 · S/N 32410N432ELazy J Aeroplanes LLC · Beverly, WVBuilt 1969 · S/N 18259591N432RRFirst Plane LLC · Erie, PAS/N 18267066N432SUlman Morrison · San Carlos, CABuilt 1957 · S/N 32879N432TSModern Air Solutions LLC · Panama City Beach, FLBuilt 1981 · S/N 18267862N432ZADunbar Stephen E Trustee · Broken Arrow, OKS/N 15073805N4330NMays Kevin E · West Liberty, KYBuilt 1947 · S/N 7079
Back to AD 87-20-03 R2