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.

N7241AGibbs Geoffrey M · Holland, TXS/N 29341N7241MLabarre Ben A · Hayward, WIBuilt 1958 · S/N 55541N7241SWatrous David S Trustee · Gainesville, VABuilt 1976 · S/N 18265085N7241TSelleck Philip A · Falls Church, VABuilt 1959 · S/N 46841N72421N83882 Inc · Huntington, NYBuilt 1968 · S/N 17257407N7242ES S Farms Of Freeborn County Inc · Albert Lea, MNBuilt 1959 · S/N 52242N7242GIrizarry Heriberto J · Homestead, FLBuilt 1970 · S/N 17258942N7242TDenton David · Siloam Springs, ARBuilt 1959 · S/N 46842N7242XWatson Kenneth B · Sanford, TXBuilt 1961 · S/N 15059342N72432Kaono Jerry C · Carson, CABuilt 1973 · S/N 33701581N7243GKrumbine David A · Lebanon, PABuilt 1970 · S/N 17258943N7243SEggers Matthew O · Keller, TXBuilt 1973 · S/N 15075277N72444Valiair Lc LLC Trustee · Casper, WYS/N 33701586N72446Minerals 66 LLC · Molt, MTBuilt 1973 · S/N 33701587N7244ETomsheck Matthew E · Seville, OHS/N 52244N7244QBuckley Gregory L · Melba, IDS/N 17260544N7244TFlood John M · Bozeman, MTBuilt 1959 · S/N 46844N7245AStoup Kyle W · Foss, OKBuilt 1956 · S/N 29345N7245EWheeler Chad L Personal Representative · Arco, IDS/N 52245N7245SHansen Abree G · Reno, NVBuilt 1967 · S/N 15067945N7245TWestfall James H · Bend, ORBuilt 1959 · S/N 46845N7245XBelliveau Brian J · Easthampton, MABuilt 1961 · S/N 15059345N7246GHale Warren P · Martinsburg, MOBuilt 1970 · S/N 17258946N7246QHaines Anne K · Ligonier, PABuilt 1972 · S/N 17260546N7246SDenton Christopher G · Youngsville, NCS/N 15067946N7246TKruger Bruce W · Gustavus, AKS/N 46846N7246XMuinos Jose M · York, PABuilt 1961 · S/N 15059346N72474Dick Ronald J · Fort Wayne, INBuilt 1974 · S/N 33701597N7247EStrong Brian S · Southport, NCBuilt 1959 · S/N 52247N7247MChristopher James R · College Park, GABuilt 1958 · S/N 55547N7247NMartin Christian E · Amagansett, NYBuilt 1976 · S/N U20603582N7247SEpperly Scott E · Creswell, ORS/N 15067947N7247TNelson Harold G · Pendleton, ORBuilt 1959 · S/N 46847N7247XGritter Robert C · Hudson, FLBuilt 1961 · S/N 15059347N7248AMoore Greg J · Bakersfield, CAS/N 29348N7248ESchutt Patrick M · Kingsville, MOBuilt 1959 · S/N 52248N7248QEricson Steven L · Dorris, CABuilt 1972 · S/N 17260548N7248TStormont Dylan · Xenia, OHS/N 46848N7249GTate Donald E · Jonesburg, MOBuilt 1970 · S/N 17258949N7249MNewell Norman I Jr · Palm City, FLBuilt 1958 · S/N 55549N7249QTrailgate Tailgate Systems Inc · Belle Vernon, PABuilt 1972 · S/N 17260549N7249SBell Global Security Group LLC · Lewes, DEBuilt 1976 · S/N 18265086N7249XZubeck Robert E · Emery, SDS/N 15059349N724CTWarner David A · Carbondale, ILBuilt 1963 · S/N 17251105N724DBRegistered aircraftBuilt 1977 · S/N 18266198N724KRClean Patterns LLC · Mesa, AZBuilt 1976 · S/N R1722050N724LCDixon Jody S · Chancellor, ALBuilt 1966 · S/N 17254599N724MCSutton Aircraft Salvage LLC · Palmer, AKBuilt 1970 · S/N 15072198N724RJRehkopf Ronald O · Texarkana, TXBuilt 1981 · S/N 18267979N724RTBrown Robert · Wayne, OKS/N 56160
Back to AD 87-20-03 R2