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.

N5949TJoy Jeffrey · Pendergrass, GABuilt 1964 · S/N 15060649N5949VElkhorn Creek Aviation 3 LLC · Georgetown, KYBuilt 1954 · S/N 20920N594CF4cf Partnership · Fall River Mills, CABuilt 1966 · S/N 18256922N594PFBatten Franklin H · Randleman, NCBuilt 1974 · S/N 15076042N5950AVincent Anthony Jordan · Graham, KYBuilt 1956 · S/N 28550N5950GSmylie Michael Dean · Douglas, WYBuilt 1974 · S/N 18263310N5951ELlano Alfonso · Tucson, AZS/N 17271974N5951GWallace Grant R · Altoona, IABuilt 1969 · S/N 15071451N5951RSouth Seattle Community College · Seattle, WABuilt 1965 · S/N 17253620N5952ARoberts Richard R · Seaman, OHBuilt 1956 · S/N 28552N5952FRedmon David M · Biloxi, MSBuilt 1967 · S/N 21058952N5952GBradford III Properties LLC · Huntersville, NCBuilt 1969 · S/N 15071452N5952JB&R Aircraft LLC · Wadsworth, OHBuilt 1970 · S/N A1500252N5952TWaters Brandon J · Bushnell, ILS/N 15060652N5953BElevate Air Inc · Titusville, FLBuilt 1956 · S/N 33953N5953FKnickerbocker Thomas C · Houston, TXS/N 21058953N5953GKibart Allan L · Eufaula, OKBuilt 1969 · S/N 15071453N5953THangar Ak LLC · Sterling, AKBuilt 1964 · S/N 15060653N5954ROtr Enterprises LLC · Broussard, LAS/N 17253623N5954TAeropro Aviation LLC · Brighton, MIBuilt 1964 · S/N 15060654N5954VBown Leah R · Belgrade, NEBuilt 1954 · S/N 26405N5955BHess Garrett · Fullerton, CABuilt 1956 · S/N 33955N5955EClover Park Technical College · Tacoma, WABuilt 1978 · S/N 17271975N5955GHoughton Lawrence A · Rsm, CABuilt 1969 · S/N 15071455N5956ATimes Of Refreshing World Outreach Ministry Inc · Baton Rouge, LABuilt 1956 · S/N 28556N5956EWalsh James · Hayden, IDS/N 17271976N5956JBrogren Nicholas R · Minneapolis, MNS/N A1500256N5956THout David D · Columbus, OHS/N 15060656N5956XCox David F · Tucson, AZS/N 21058956N5957ASwenson Kent A · Kindred, NDBuilt 1956 · S/N 28557N5957BMiss Mayson LLC · Midland, TXBuilt 1956 · S/N 33957N5958AAndreoli Robert J · Alamogordo, NMBuilt 1956 · S/N 28558N5958JHaymond Robert · San Antonio, TXBuilt 1969 · S/N A1500026N5959TSchramm John · Walbridge, OHBuilt 1964 · S/N 15060659N595DLieberg Craig · Clear Lake, MNS/N 20747N595KHarvey Air LLC · Doylestown, PABuilt 1972 · S/N 17260401N595LTN595lt LLC · Edwards, COS/N P21000008N595TSArner Michael D · Tolland, CTBuilt 1967 · S/N 17256027N5960ASouthern Aviation Solutions LLC · Sumter, SCS/N 28560N5960JWoodward Michael J · Council Bluffs, IABuilt 1971 · S/N A1500260N5960RFrame Russell C · Harrison, IDBuilt 1965 · S/N 17253629N5960TDonat Brandon L · Glendale, AZBuilt 1964 · S/N 15060660N5961AMobley Mark A · Wasilla, AKS/N 28561N5961BC&B Aerial Transport Inc · Wilmington, DES/N 33961N5961GSkypark Inc · Wadsworth, OHBuilt 1969 · S/N 15071461N5961RPieper James E · Corpus Christi, TXBuilt 1965 · S/N 17253630N5961THusky Transportation LLC · San Antonio, TXBuilt 1964 · S/N 15060661N5962AKadlec Paul · Vail, AZBuilt 1956 · S/N 28562N5962GVaught Andrew W · Long Beach, CABuilt 1969 · S/N 15071462N5962RN5962r LLC · Auxvasse, MOBuilt 1965 · S/N 17253631
Back to AD 87-20-03 R2