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.

N4042FTweedle Dee LLC · John Day, ORBuilt 1958 · S/N 36942N4042VFreedom Aviation · Salina, KSBuilt 1948 · S/N 18361N4043FFinley Trevor S · Caddo Mills, TXS/N 36943N4043JDevine Steven A · Roseville, CAS/N 15065343N4043UHawthorne Christopher J · Lafayette, LABuilt 1965 · S/N 15061443N4043VThompson Frank · Weiser, IDBuilt 1948 · S/N 18362N4044JLiberty University Inc · Lynchburg, VABuilt 1966 · S/N 15065344N4044VStrnad William J · Taylors Falls, MNBuilt 1948 · S/N 18369N4045DTlm Properties LLC · Gladewater, TXBuilt 1957 · S/N 34745N4045FRobinson Jeffrey A · Gaines, MIBuilt 1956 · S/N 36945N4045UKnutson Tristian A · Spokane, WABuilt 1965 · S/N 15061445N4046FVyatkin Denis · Sacramento, CAS/N 36946N4046UFox James E · Queen Creek, AZS/N 15061446N4046VHowell Alvin M · Needville, TXS/N 18373N4047DEiff John E · Deland, FLFirst renewal noticeBuilt 1957 · S/N 34747N4047FRegistration Pending · Sherwood, WIRegistration pendingBuilt 1958 · S/N 36947N4047UDurfey Kyle A · Tucson, AZBuilt 1965 · S/N 15061447N4048MJoel Massey Real Estate LLC · Flowery Branch, GABuilt 1981 · S/N 182-67993N4048UOshtemo Flyers LLC · Kalamazoo, MIBuilt 1965 · S/N 15061448N4048VThomas Kevin C · Spokane, WABuilt 1948 · S/N 18377N4049DUnwrapped LLC · Dover, DEBuilt 1957 · S/N 34749N4049FSouthwell Arthur M · Arcadia, FLBuilt 1958 · S/N 36949N4049JWashington Aero Club Inc · South Park, PAS/N 15065349N4049UCatero Inc · Chickasha, OKBuilt 1965 · S/N 15061449N4049VJustin William R · Sauk Rapids, MNBuilt 1975 · S/N 15076685N404BNCienski Todd A · Duncanville, TXBuilt 1965 · S/N 21058705N404RGJoyner James M · Eagle River, AKS/N 18502702N404SMForm 50 Aviation LLC · Newark, DEBuilt 1966 · S/N 18257374N404SSInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 0702N404SWWood Roger W · Sale Creek, TNBuilt 1968 · S/N 17256702N404XXInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N R18201624N4050DKesling Aviation LLC · Orange Beach, ALBuilt 1957 · S/N 34750N4050FTitensor Shanelle Bn · Tetonia, IDS/N 36950N4050VDussetschleger Lynn Albert · Luling, TXBuilt 1948 · S/N 18381N4051AVintage Sky LLC · Trussville, ALBuilt 1949 · S/N 7318N4051DOlson Scott L · Girdwood, AKS/N 34751N4051FTamargo Victor · Fort Worth, TXBuilt 1958 · S/N 36951N4053DGardner Dale R · North Logan, UTBuilt 1957 · S/N 34753N4053USegura Jose · Chicago, ILBuilt 1965 · S/N 15061453N4054DBass Edward J · Richland, WABuilt 1958 · S/N 34754N4054FSterbonic Peter D · Wickenburg, AZS/N 36954N4054VHunsberger Colin T · Palmer, AKBuilt 1948 · S/N 18386N4055DLoup Technologies Inc · Longmont, COBuilt 1957 · S/N 34755N4055FFerguson Richard Trustee · Canyon Lake, TXBuilt 1958 · S/N 36955N4055JStrobel Oliver K · Fishers, INBuilt 1966 · S/N 15065355N4055UHanson Parry B · Eagle Creek, ORS/N 15061455N4055VWayman Tim · Santa Rosa, CAS/N 18387N4056FMullen Mark M · Livermore, CABuilt 1958 · S/N 36956N4056UFranklin Timothy · Brentwood, TNBuilt 1965 · S/N 15061456N4057JTurner Jeremy A · Rancho Murieta, CABuilt 1966 · S/N 15065357
Back to AD 87-20-03 R2