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.

N729JHDickman Robert J · Richmond, INBuilt 1978 · S/N 17271839N729SCCole Michael J · Ginnison, COBuilt 1978 · S/N R18200750N729WDMonroe Greg · Linden, TNBuilt 1960 · S/N 47583N72BLSkrow Works Inc · West Monroe, LAS/N 17257795N72CCasa Acquisitions LLC · Winter Haven, FLBuilt 1948 · S/N 7219N72CABrooks Duane T · Mt Shasta, CABuilt 1972 · S/N P3370027N72CCCaterfull Inc · Miami Beach, FLBuilt 1975 · S/N 17266347N72CPGrant Henry R H · Ocracoke, NCBuilt 1973 · S/N 15075051N72CXCorsair Engine Technologies · Colorado Springs, COBuilt 1969 · S/N 17258725N72ERMaierhoffer Henry F Jr · Sylvania, GABuilt 1977 · S/N 17269501N72FDEngesath David H · Duluth, MNBuilt 1974 · S/N 17263913N72GJSkydive Greene County Inc · Xenia, OHS/N 51723N72HSRowser Brad C · Duchesne, UTBuilt 1959 · S/N 52223N72JGN72jg LLC · Belgrade, MTBuilt 1976 · S/N 18264870N72JNTroy I Mounts Md Inc · San Juis Obispo, CABuilt 1974 · S/N 17263882N72NXNexair Avionics LLC · Plymouth, MABuilt 1976 · S/N 17267923N72PFKuck Russell W · Aguila, AZBuilt 1965 · S/N 17253530N72RRoam Airlines LLC · Eugene, ORBuilt 1952 · S/N 20904N72RXTayloreel Plastics South Corp · Gainesville, GAS/N 18261397N72SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17272017N72STSierra Tango Air LLC · Senoia, GAS/N 17269433N72TNTornado Alley Turbo Inc · Ada, OKBuilt 1976 · S/N R1722028N72TRRcrhb LLC · Wells, TXBuilt 1972 · S/N 18261325N72VCProfessional Motorcoach Leasing & Sales LLC · Tamassee, SCBuilt 1981 · S/N 18267977N72VHThomason Terry C · Hot Springs, ARBuilt 1972 · S/N 18261033N72VVBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N P21000339N72WEWest Elk Air LLC · Gunnison, COBuilt 1979 · S/N 18503854N72XPFlink Frank B Jr · Shawnee Mission, KSFirst renewal noticeBuilt 1977 · S/N R1722396N73001Spooter Air LLC · Obion, TNBuilt 1976 · S/N 17267232N7300QClark Perry W · Pine River, MNBuilt 1971 · S/N 18260940N7300SHerring Alan T · Laredo, TXBuilt 1981 · S/N R18201702N73010Rico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17267235N73015Alameda Flying Club Inc · Richmond, CABuilt 1976 · S/N 17267238N7301GFreeport Flyers Inc · Freeport, ILBuilt 1970 · S/N 17259001N7301MLeaders Bob O · Clear Lake, MNBuilt 1958 · S/N 55601N7301QMorgan John C · Seattle, WABuilt 1971 · S/N 18260941N7301SJohn Air LLC · Aurora, UTBuilt 1976 · S/N 18265094N7301THolte Martin W · Burnsville, MNBuilt 1959 · S/N 46901N7301WFry Mark · Danville, PABuilt 1977 · S/N R18200051N73020Ajf Enterprises LLC · Des Moines, IABuilt 1976 · S/N 17267239N73028Halley Craig H · Lanai City, HIBuilt 1976 · S/N 17267241N7302ASkywagon Aero LLC · Wilmington, DEBuilt 1956 · S/N 29402N7302GSmith Neil W · Rincon, GABuilt 1970 · S/N 17259002N7302MKoenig Donald J · Las Animas, COBuilt 1958 · S/N 55602N7302NClark Frank C · Pinckney, MIBuilt 1974 · S/N 18263088N7302QDuckworth Bill J · Epps, LAS/N 18260942N7302TSchaff James F · Prescott, AZBuilt 1959 · S/N 46902N7302WSanders Robert E · Whitewater, MOBuilt 1977 · S/N R18200052N7302XGlover Thomas · Marana, AZBuilt 1961 · S/N 15059402N73036Johnson Deborah K · Fairbanks, AKBuilt 1979 · S/N 20700555
Back to AD 87-20-03 R2