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.

N9347UAirgo Inc · Centralia, ILBuilt 1976 · S/N 15078296N93488Rawareo LLC · Warsaw, MOBuilt 1982 · S/N 15285501N9348AShelomis Dennis B · Shelton, CTBuilt 1949 · S/N 7427N9348HDeshazer Bill G · Gladewater, TXBuilt 1975 · S/N 17266106N9348XWhittemore Kenneth P Jr · Fredericksburg, VABuilt 1962 · S/N 18253748N9349MDouble R Air LLC · Miami, FLBuilt 1980 · S/N 20700682N9349RMccelvey James L · Dilley, TXBuilt 1978 · S/N R18200694N9349XDicarlo Jason M · Covington, LABuilt 1962 · S/N 18253749N934GRGrossman Robert W · Andover, MABuilt 1977 · S/N 17269688N934TCVandentoorn Randy J · Caledonia, MIFirst renewal noticeBuilt 1976 · S/N 18503026N934TRAris Leasing Inc · Sunnyvale, CABuilt 1977 · S/N 17269190N9350AGalloway Thomas E S · Oklahoma City, OKBuilt 1949 · S/N 7429N9350BHoman Ralph C · Weiser, IDBuilt 1958 · S/N 55150N9350CCloud Dancer Inc · Berlin, MDBuilt 1955 · S/N 31748N9351DJennings David M · Huffman, TXBuilt 1982 · S/N 172RG1130N9351HBrown Daniel Thomas · Layton, UTS/N 17266109N9351UHolt James D · Greensboro, NCBuilt 1976 · S/N 15078300N9351XSasser Konnie B · Granbury, TXBuilt 1985 · S/N 18268499N93526Delta State University · Cleveland, MSBuilt 1982 · S/N 15285507N93529Richmor Aviation Inc · Hudson, NYBuilt 1982 · S/N 15285510N9352CSage Blue LLC · Yakima, WABuilt 1955 · S/N 31750N9352XLinhart Charles W · Dayton, WYBuilt 1962 · S/N 18253752N9353ARoelofs David M · Prescott, AZBuilt 1949 · S/N 7432N9353DRegistration Pending · Simi Valley, CARegistration pending, canceledBuilt 1982 · S/N 172RG1131N9353ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268402N9353GMisyukevich Konstantyn · Clarkston, MIBuilt 1971 · S/N 18260893N9353RStephanian Erick Trustee · Naples, FLFirst renewal noticeBuilt 1978 · S/N R18200695N9353YKovax Aviation LLC · Youngstown, OHBuilt 1981 · S/N 21064482N9354BC2 Aero LLC · Dallas, TXBuilt 1958 · S/N 55154N9354CSmith Richard M · Stanwood, WABuilt 1955 · S/N 31752N93550Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1982 · S/N 15285513N9355CGrobbelaar Warren · Naples, FLBuilt 1955 · S/N 31753N9355NGardner Tyler J · Lowell, MEBuilt 1981 · S/N 18504337N9355RSkyline Aviation LLC · Lewistown, MTBuilt 1975 · S/N 18802254TN9355XTaylor John A · Lexington, MABuilt 1985 · S/N 18268501N9356BWard Clayton D · Mcville, NDBuilt 1958 · S/N 55156N9356HQuad Cities Aero LLC · Bettendorf, IABuilt 1975 · S/N 17266113N9356RQuality By Design Inc · Leesburg, FLBuilt 1978 · S/N R18200696N9356XGibson Kenneth W · Washougal, WAS/N 18253756N9356YParsons Bruce W Trustee · Costa Mesa, CABuilt 1981 · S/N 21064483N9357GPpp Investments LLC · Lexington, MSBuilt 1971 · S/N 18260897N9357TBonafide Investments LLC · Dover, DEBuilt 1960 · S/N 50857N9357UBaldwin James S · Sylvania, OHBuilt 1976 · S/N 15078306N93585Sipher William M · Baker, FLBuilt 1982 · S/N 15285521N9358ELechmanski Philip J · Shelter Island, NYBuilt 1979 · S/N 17272236N9358GBig Sky Plane Holdings LLC · Kalispell, MTBuilt 1971 · S/N 18260898N9358LUnited States Air Force · Eglin Afb, FLBuilt 1986 · S/N 17276546N9358NHarvey Kandace A · Snohomish, WABuilt 1981 · S/N 18504339N9358USaddedine Nouredine · Frisco, TXBuilt 1976 · S/N 15078307N93590G & M Aircraft Inc · Wheat Ridge, COS/N 15285524
Back to AD 87-20-03 R2