OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N49055Lima Aviation LLC · Lake Havasu City, AZBuilt 1977 · S/N 15281126N4905CAnacapa Capital LLC · Fresno, CABuilt 1979 · S/N 21063664N4905RFlight Level Zero LLC · Othello, WABuilt 1975 · S/N 18802423TN4905UPerformance Ag Indiana · Frankfort, INS/N 21058605N49060Skylogix Aircraft LLC · La Habra, CABuilt 1979 · S/N 15283410N4906DHutchison Robert T · Big Lake, AKBuilt 1958 · S/N 51006N4906NKmq Data Acquisitions LLC · Chugiak, AKBuilt 1979 · S/N 18267450N4906SSweeney Peter Allan · Irvine, CABuilt 1979 · S/N R18201446N49070Ilmberger Stephen Joseph · San Leandro, CABuilt 1977 · S/N 15281133N49075Mccullough Nancy D · Abilene, TXBuilt 1979 · S/N 15283412N49078Radar Aviation LLC · Mebane, NCS/N 15281137N49079Alexander Joseph · Hamilton, INBuilt 1977 · S/N 15281138N4907RMills Spraying Service Inc · Pahokee, FLBuilt 1975 · S/N 18802425TN4908GShaffer Aviation LLC · Tupelo, MSS/N 17273455N4908Q1lowflyer Inc · Harrisonville, MOBuilt 1976 · S/N 18802643TN49090Victory Aviation LLC · Winchester, VABuilt 1979 · S/N 15283415N49094Fleck Richard N Trustee · Camarillo, CABuilt 1979 · S/N 15283416N4909ANastro Kristopher Jason · Fallon, NVS/N 32306N4909GRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1979 · S/N 17273456N4909UGarner Howard E · Bonifay, FLBuilt 1965 · S/N 21058609N4909YFremont Airways LLC · Riverton, WYBuilt 1980 · S/N 21064039N490AFEiffert Matthew T · Ukiah, CABuilt 1970 · S/N 17701493N490DBPatkotak Crawford · Barrow, AKS/N U20604472N491Acadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1978 · S/N 18503597N49104Jprg Aviation Inc DBA · Orlando, FLS/N 15281151N4910AEverett Laurence B · Berkley, CABuilt 1956 · S/N 32307N4910BCooper Ronald C · Fowlerville, MIBuilt 1979 · S/N 15283702N4910DN4910d LLC · Delavan, WIBuilt 1979 · S/N 17272394N4910SMarden John E · Oakland, MEBuilt 1980 · S/N R18201449N4910UN4910u LLC · Cushing, OKBuilt 1965 · S/N 21058610N4911ASatra Jerry J · Sidney, MTBuilt 1956 · S/N 32308N4911CGianni David C · Fairbanks, AKBuilt 1975 · S/N 18502653N4911ESchumacher Gregory Luther · Anchorage, AKBuilt 1979 · S/N 18503904N4911JDarter Lloyd R · Mountain Grove, MOBuilt 1981 · S/N T18803778TN49120Aviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 15283425N49123Ascend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 15281152N49125Morey Airplane Co Inc · Middleton, WIBuilt 1979 · S/N 15283426N49126Flight Expo Inc · Princeton, MNS/N 15283427N49127Schaefer B C · Fairfield, TXS/N 15281154N4912EAdams Bruce M · Santa Fe, NMBuilt 1982 · S/N 18268284N4912GHardee Christopher D · Smyrna, TNBuilt 1979 · S/N 17273459N4912SStevens Joel N · Monticello, ARBuilt 1980 · S/N R18201451N49138Osborn Scott R · Rch Palos Vrd, CABuilt 1979 · S/N 15283430N4913AOlson David J · Eugene, ORBuilt 1956 · S/N 32310N4913DRosies Procurement LLC · Midlothian, TXBuilt 1979 · S/N 17272395N4913GLeading Edge Flight Academy LLC · Bend, ORBuilt 1979 · S/N 17273460N4913JPassmore Stephen B DBA · Lacrosse, WABuilt 1981 · S/N T18803780TN4913UGarvey F Patrick · Churubusco, INBuilt 1965 · S/N 21058613N49142Zion Summit Holdings LLC · Wesley Chapel, FLBuilt 1977 · S/N 15281161N49144Westfall Benjamin C · Coeur D Alene, IDBuilt 1977 · S/N 15281163
Back to AD 87-20-03 R2