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.

N9256BDillard Wendell Hoyt · Centerville, TXBuilt 1958 · S/N 55056N92570Becker Steven H · Prescott, AZBuilt 1973 · S/N 17261586N9257HTaf Aerial Services LLC · Beeville, TXBuilt 1981 · S/N 18267928N9257ULiberty Flyers Inc · Ramsey, MNBuilt 1976 · S/N 15078207N92584Buckner Walter · Columbia, TNBuilt 1970 · S/N 18260270N9258GHerb Meloche Ltd · West Allis, WIBuilt 1971 · S/N 18260798N92593Snider Scott E DBA · Turner, MTBuilt 1975 · S/N 18802067TN92595Bearfight Aviation LLC · Dover, DEBuilt 1973 · S/N 17261591N92597Morgan Ent LLC · Richland, IABuilt 1970 · S/N 18260276N9259CHauser Linda L · Ulysses, KSBuilt 1955 · S/N 31358N9259HBooke Phillip Austin · Anniston, ALS/N 17266053N9259UAdirondack Legacy Aircraft LLC · Saratoga Springs, NYBuilt 1976 · S/N 15078209N925ABJavelina Trax LLC · Saint Charles, MOBuilt 1978 · S/N 18266649N925CBDhani Errol · Locust Grove, GABuilt 1973 · S/N 17262826N925JKLonghorn Listings Inc · San Antonio, TXS/N U206-0969N925MML A M Capital Management LLC · Sheridan, WYBuilt 1982 · S/N 17275341N925PBRegistered aircraftBuilt 1979 · S/N R18201394N925RRHahn John K · Evansville, INBuilt 1969 · S/N 18260190N925WMHoward Charles M · Pittsburg, TXBuilt 1979 · S/N U20604997N92600Windh Steven R · Reedley, CABuilt 1970 · S/N 18260278N9260CWilson Benjamin W · Carrollton, TXBuilt 1955 · S/N 31359N9260GPeyton Julia H · Santa Barbara, CAFirst renewal noticeBuilt 1971 · S/N 18260800N9260RVroom David H · Oro Valley, AZBuilt 1978 · S/N R18200675N9260UFlying L Aircraft Inc · Fort Denaud, FLBuilt 1976 · S/N 15078210N9260XColvin Buster · Big Cabin, OKBuilt 1961 · S/N 18253660N92616Holby W Barrett Jr · Warren, RIBuilt 1970 · S/N 18260284N92617Stahl Raifen · Anchorage, AKBuilt 1973 · S/N 17261594N9261ACallahan Glenn P · Deridder, LABuilt 1949 · S/N 19022N9261GAllred Bobby A · Centre, ALBuilt 1973 · S/N 18801441N9261HSchrom Frederick A · Carlisle, PABuilt 1975 · S/N 17266054N9261UOconnor Sean P · Pompano Beach, FLBuilt 1976 · S/N 15078211N9262HAero Maintenance Inc · Vancouver, WAS/N 17266055N9262UNichols Curtis E · Gloucester, VABuilt 1976 · S/N 15078212N92638Van Raden Chris · Portland, ORBuilt 1970 · S/N 18260291N92639Pryor Aviation LLC · Hutchinson, KSS/N 18260292N9263GN9263g LLC · Marshall, MOS/N 18260803N9263HPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1975 · S/N 17266056N9263XMieloszyk Nicholas A · Elko, NVS/N 18253663N92644Atkins Doug · Murfreesboro, TNBuilt 1970 · S/N 18260293N92648Bender Phillip H · Bloomingdale, OHBuilt 1970 · S/N 18260295N9264RAir Dakota Flite Inc · Hettinger, NDBuilt 1975 · S/N 18802196TN9265CComerford John W · Pagosa Springs, COBuilt 1955 · S/N 31364N9265HCleveland Douglas P · Live Oak, FLBuilt 1975 · S/N 17266057N9265TFpg Agri Services LLC · Frost, TXBuilt 1960 · S/N 50765N9265UEtchell Bruce R · Healdsburg, CABuilt 1976 · S/N 15078215N9265XWestern Pilot Service Inc · Phoenix, AZBuilt 1961 · S/N 18253665N92665Rupke Curtis · Washington, NCBuilt 1970 · S/N 18260302N9266ADyrstad Mary S · Hampshire, ILBuilt 1949 · S/N 19027N9266GCole Mark A · Forest City, NCBuilt 1971 · S/N 18260806N9266UEgge Danny C · Pelican Rapids, MNBuilt 1976 · S/N 15078216
Back to AD 87-20-03 R2