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.

N9997PSullivan Michael · Cazenovia, NYBuilt 1969 · S/N 18260018N9997TFrazer Scott Cameron · Durango, COBuilt 1960 · S/N 18253097N9997VBecker Philip J · Ocean Isle Beach, NCBuilt 1974 · S/N 17264614N99981Sky High Leasing Services LLC · Lakeland, FLBuilt 1985 · S/N 17276533N9998AWhite Fox LLC · Springdale, ARBuilt 1950 · S/N 19433N9998HBas Part Sales LLC · Greeley, COBuilt 1982 · S/N 18268172N9998JBecker Flying Service Inc · Hartington, NES/N T18803927TN9998NFoulk William H · Shelburne, VTBuilt 1976 · S/N 18052653N9998TTilley Melvin D · Sperry, OKBuilt 1960 · S/N 18253098N9998VCox Danny A · Panama City Beach, FLS/N R1722361N9998XSells James O · Peachtree City, GABuilt 1961 · S/N 185-0198N99991Genovese Mark A · Baltimore, MDBuilt 1985 · S/N 17276534N9999BMccole Kevin · Brookline, NHBuilt 1957 · S/N 34399N9999TN9999t LLC · Boulder, COS/N 18253099N9999XBogart Sean A · Anchorage, AKBuilt 1961 · S/N 185-0199N999AFThree Four Juliet LLC · Orange, CABuilt 1975 · S/N 17265806N999AGClark Chase H · Ozona, TXS/N 18052029N999ARD R Tripp Enterprises LLC · Omaha, NES/N 17268006N999AVSouza Engineering Contracting Inc · San Luis Obispo, CABuilt 1979 · S/N P21000257N999BMDewitt Stephen R · Port Aransas, TXS/N R18200072N999CFPerkins Nathan Zackery · Bonanza, ORBuilt 1960 · S/N 52450N999CGEdling Leon K · Colorado Springs, COBuilt 1973 · S/N 177RG0357N999DGFoghorn Airfleet LLC · Columbus, INBuilt 1973 · S/N 18261688N999DKSkt Seaplanes LLC · Huntsville, ALBuilt 1953 · S/N 30359N999HRPage Edward C · Thornhurst, PABuilt 1975 · S/N 17702359N999JJAlpine Holdings LLC · Kalispell, MTBuilt 1976 · S/N 18264642N999JTCdm Dirt LLC · Snowflake, AZBuilt 1976 · S/N 15079002N999KBBurgess James H · Cora, WYBuilt 1969 · S/N 18259741N999KMMaule Aviation LLC · Las Vegas, NVBuilt 1979 · S/N P21000387N999KWTeodoro Scott · Fox Island, WABuilt 1981 · S/N 18267899N999LWTroposcatter Inc · Wilmington, DEBuilt 1978 · S/N R1722985N999MHDetiger Elizabeth · East Stour DorsetBuilt 1948 · S/N 7168N999PAGoodwin William S · Sequim, WABuilt 1969 · S/N 17701392N999PCFlying T LLC · Albuquerque, NMBuilt 1972 · S/N 21059694N999QAQuebec Alpha LLC · Milwaukie, ORBuilt 1973 · S/N 17262047N999RDSale Reported · Colorado Springs, COSale reportedBuilt 1966 · S/N 15064280N999TKPearson John L · Stevensville, MTBuilt 1963 · S/N 18254831N999UCLinville Rex D Trustee · Sarasota, FLBuilt 1973 · S/N 18261957N999WBEastern Kentucky University · Richmond, KYBuilt 1979 · S/N 17273254N999ZPGassen Paul E · Fallbrook, CABuilt 1981 · S/N R18201771N99ABrown Ashley A · Fort Worth, TXS/N 18052789N99BHBarker Aviation LLC · Ardmore, OKS/N 17260112N99DDLussier John A · Greene, RIBuilt 1959 · S/N 50419N99DSToutant Roland J · Woodstock, CTBuilt 1972 · S/N 210-59608N99EAndrews University · Berrien Springs, MIBuilt 1967 · S/N 15066141N99EBAir Wings Enterprise LLC · Roca, NEBuilt 1963 · S/N 17250150N99FC4th Street Group LLC · Signal Mountain, TNS/N 18268381N99FEN99fe Aircraft Services LLC · Lubbock, TXS/N 18260751N99GBBright Edgar H · Collegeville, PABuilt 1973 · S/N 21060115N99GFDemon Diversified LLC · Wilmington, DEBuilt 1979 · S/N 18267418
Back to AD 87-20-03 R2