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.

N6635FJenkins Keith · Corralitos, CABuilt 1966 · S/N 15063235N6635SCoughanowr David D · Chatham, MABuilt 1967 · S/N 15067435N6635XNewsom Larry E Jr · Hernando, MSS/N 21057635N6636FChesterton Thomas W Jr · Watertown, MABuilt 1966 · S/N 15063236N6636XAllen Leigh E · Bedford, WYBuilt 1961 · S/N 21057636N66376Backhaus John W · Hampton, NHBuilt 1974 · S/N 15076000N66379Curry Zachary A · Loveland, COBuilt 1974 · S/N 15076003N6637ASmedley Hank W · Lake Havasu City, AZBuilt 1956 · S/N 28737N6637TRomo Aubrey J · Del Norte, COS/N 15059037N66380Logan Thomas H · Canfield, OHBuilt 1974 · S/N 15076004N66383Tuskegee Airmen National Historical Museum · Detroit, MIS/N 15076007N66384Anderson Rick L · Valley City, NDBuilt 1974 · S/N 15076008N66386Registration Pending · Portage, MERegistration pendingBuilt 1974 · S/N 15076010N66387Bredvold Daniel M · Mendota Heights, MNS/N 15076011N6638AKeystone Cessna LLC · Melrose, FLBuilt 1956 · S/N 28738N6638MAdams Flying Service Inc · Rayville, LABuilt 1975 · S/N 18263787N6638NIsr Aviation LLC · Wilmington, DEBuilt 1978 · S/N 21063129N6638TSmolios Charles M · Nashville, TNBuilt 1960 · S/N 15059038N6638XSipple Paul K · Moorpark, CAS/N 21057638N66393Dash Roger A · Niles, MIBuilt 1974 · S/N 15076017N66394Y&S Aviation LLC · Oceanside, CAS/N 15076018N66395Murray Kevin D · Moneta, VABuilt 1974 · S/N 15076019N66397Petersen Bradley L · Bellingham, WABuilt 1974 · S/N 15076021N66399Acord Aviation Co L L C · Chandler, OKBuilt 1983 · S/N 17275988N6639APeach Christopher G · Waterville, MNBuilt 1956 · S/N 28739N6639SMoen Richard C · West Dundee, ILS/N 15067439N6639XLee Michael A · Arlington, WABuilt 1960 · S/N 21057639N663GGNt Miller LLC · Winchester, KYBuilt 1975 · S/N 33701634N663RTRaiders Tigers Flying Club Inc DBA · Houston, TXBuilt 1975 · S/N 17265988N66402King Dwayne W · Sutton, AKBuilt 1974 · S/N 15076025N6640ABunger Glenn H · Kirkland, ILBuilt 1956 · S/N 28740N6640ELarkin Marion J · Salome, AZBuilt 1959 · S/N 56140N6640FFlying High LLC · Gore, VABuilt 1966 · S/N 15063240N6640GKruckeberg Leroy A · Sanford, NCS/N 15072140N6640HSolis Aviation LLC · Carroll, OHBuilt 1975 · S/N 17265520N66412Farris Chad M · Bronte, TXBuilt 1975 · S/N 15076032N6641FKatzenberger Devin T · Little Falls, MNBuilt 1966 · S/N 15063241N6641GWalborn Carl L · Sun City, AZBuilt 1970 · S/N 15072141N66420Ware Charles W Jr · Atmore, ALBuilt 1974 · S/N 15076035N66422Zaleski-Johnson Laura · Mays Landing, NJBuilt 1974 · S/N 15076036N66425Biornstad John A · Big Lake, AKBuilt 1974 · S/N 15076039N6642ATundra Aviation Inc · Casselton, NDS/N 28742N6642FSomerset Flying Club · Basking Ridge, NJBuilt 1966 · S/N 15063242N6642GBurgmeier Peter W · North Vernon, INBuilt 1970 · S/N 15072142N6642SSellers Douglas D · Webster, NYBuilt 1967 · S/N 15067442N66431Neron II LLC · New Smyrna Beach, FLS/N 17275989N66437Fluno John I · San Anselmo, CAS/N 15076049N66439Mancini James N · Baltimore, MDBuilt 1974 · S/N 15076051N6643AMoore Michael J · Monroe, UTBuilt 1956 · S/N 28743N6643FAyresouth Aviation Inc · Lithia Springs, GABuilt 1966 · S/N 15063243
Back to AD 87-20-03 R2