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.

N9802EPouya Hamid · San Jose, CABuilt 1975 · S/N 18263916N9802HPatterson Aubrey III · Saltillo, MSBuilt 1981 · S/N 18268034N9802TSandford Graves M · Moberly, MOS/N 47602N9802XMeise Fred W · Moses Lake, WABuilt 1961 · S/N 1850002N9802ZBig Horn Aviation Group · Fort Worth, TXBuilt 1982 · S/N U206-06667N9803CWhite Traci M · Manasquan, NJBuilt 1971 · S/N 17259703N9803HCoburn Alan B · Plantation, FLBuilt 1981 · S/N 18268035N9803VKoinzan Enterprises Inc · Elgin, NEBuilt 1966 · S/N 188-0053N9803XPatrick Samuel Garrett · Durango, COBuilt 1961 · S/N 1850003N9803ZBig Horn Aviation Group · Fort Worth, TXBuilt 1982 · S/N U20606668N9804JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1975 · S/N A1500613N9804TRussell Michael K · Sprakers, NYBuilt 1960 · S/N 47604N9805AMay Richard U · Soquel, CABuilt 1950 · S/N 7484N9805GSell Edwin D · Woodbury, PABuilt 1971 · S/N 17259705N9805TNorman Ronald E · Lopez Island, WABuilt 1960 · S/N 47605N9806EMccullough John D · Maize, KSBuilt 1985 · S/N 18268448N9806GDonohue Denis J · Montvale, NJBuilt 1971 · S/N 17259706N9806XWelliver Charles Kimmel Jr · Staunton, VABuilt 1961 · S/N 185-0006N9807GPoshak Jay M · Ely, MNS/N 17259707N9807HMid Eastern Specialties Ltd · Wilmington, DEBuilt 1981 · S/N 18268037N9807VLazy T Aviation LLC · Ashland, NEBuilt 1966 · S/N 188-0057N9808HThiel Av LLC · Lewistown, MTBuilt 1981 · S/N 18268038N9808JPtosis LLC · Fair Oaks, CABuilt 1980 · S/N 17273919N9808TGilmer Randy G · Nickelsville, VABuilt 1960 · S/N 47608N9808XKeller Matthew Charles · Wasilla, AKBuilt 1961 · S/N 185-0008N9809GMcclendon Jon L · Kilgore, TXBuilt 1971 · S/N 17259709N9809HHumphries Steve J · Raleigh, NCBuilt 1981 · S/N 18268039N9809JRies Roger W · Franklin, INS/N A1500618N980HPTopher Enterprises LLC · Bucyrus, KSBuilt 1978 · S/N R18200205N980JKKoskan John M · Wood, SDBuilt 1980 · S/N R18201591N980LKmq Data Acquisitions LLC · Chugiak, AKBuilt 1973 · S/N 18262273N980NOneill Aviation LLC · Lake Wales, FLS/N A1520814N980SCSky Horse LLC · Santa Cruz, CABuilt 1982 · S/N 21064774N980TAFierling Lennard W · Colton, ORBuilt 1961 · S/N 17248800N9810ACarroll Judy Diane · Naples, FLBuilt 1950 · S/N 7489N9810GAir America Flight Center LLC · Daytona Beach, FLBuilt 1971 · S/N 17259710N9810HLoos Gregory S · Boscobel, WIBuilt 1981 · S/N 18268040N9810JBradley Eric Leon · Anthony, NMBuilt 1976 · S/N A1500619N9810TWall Jeffrey L · Goffstown, NHBuilt 1960 · S/N 47610N9811HArnaud Eldon · Fort Lauderdale, FLBuilt 1960 · S/N 21057667N9811JJones Mark D · Corsicana, TXBuilt 1975 · S/N A1500620N9811VSteffek Mark E · Alturas, CABuilt 1974 · S/N 17264511N9811ZBlack Hawk Brothers LLC · Lakeland, FLBuilt 1982 · S/N U20606674N98120Blue River Aviation LLC · Palmer, AKBuilt 1984 · S/N 17276260N98125Western Reserve Flight Center Inc · Mc Donald, OHBuilt 1984 · S/N 17276261N9812BPavco Inc · Gig Harbor, WABuilt 1982 · S/N 172RG1046N9812GWhitfield Robert O Jr · Hurdle Mills, NCBuilt 1974 · S/N 18801607N9812JMelbourne Flight Training LLC · Melbourne, FLBuilt 1980 · S/N 17273920N9812TBucks Flight Academy LLC · Cashion, OKS/N 47612N9812XSmith James M · Fitchburg, WIBuilt 1961 · S/N 1850012
Back to AD 87-20-03 R2