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.

N6000LDoherty Douglas E · Nome, AKBuilt 1955 · S/N 31877N6000RKreisler Curt A · Plantation, FLBuilt 1965 · S/N 17253669N60016Meassick Steven F · Mount Horeb, WIBuilt 1968 · S/N 15070005N60018Moreno & Nelson Construction Corp · Walla Walla, WABuilt 1973 · S/N U20602002N6001GN6001g LLC · Wheeling, ILBuilt 1969 · S/N 15071501N6001JBullard Daniel C · Dallas, TXBuilt 1971 · S/N A1500301N60024Esker William D · White Mtn Lk, AZBuilt 1968 · S/N 15070011N60026Lareaux Jon R · Calumet, MIBuilt 1968 · S/N 15070013N60028Mesner Steven M · Tomah, WIBuilt 1968 · S/N 15070015N6002BWard William O · Pocatello, IDBuilt 1956 · S/N 34002N6002JSeibert John E · Anchorage, AKBuilt 1975 · S/N 18263607N6002RZelner Gregory M · Merritt Island, FLBuilt 1965 · S/N 17253671N6003260032 LLC · Jackson, MIBuilt 1968 · S/N 15070019N6003BHenley Alan · Hoover, ALS/N 34003N60040Registration Pending · Cottage Grove, MNRegistration pendingBuilt 1968 · S/N 15070026N6004GLiberty University Aviation Dept · Lynchburg, VABuilt 1969 · S/N 15071504N6004RSeaplanes R Fun Inc · Wilmington, DEBuilt 1965 · S/N 17253673N6004TIrwin Donald L · Emporia, KSBuilt 1964 · S/N 15060704N60050Elsen Paul D · Winnebago, ILBuilt 1968 · S/N 15070035N60052Onofre- Trejo Ray · Chicago, ILBuilt 1968 · S/N 15070037N60056Jones Edward · Mechanicsburg, PABuilt 1968 · S/N 15070041N6005AClark Lewis R Trustee · Lansing, MIBuilt 1956 · S/N 28605N6005BConnected Air LLC · Danvers, MABuilt 1956 · S/N 34005N6005GCrockett Guy S · Louisville, KYBuilt 1969 · S/N 15071505N60065Brewer Michael M · Naperville, ILS/N 15070048N60067Kinsella Joseph R · Jackson, WYBuilt 1968 · S/N 15070050N60069Moody Gary M · Osage, IABuilt 1968 · S/N 15070052N6006BRockfield Investments LLC · Hurricane, UTBuilt 1957 · S/N 34006N6006CUtah State University · Logan, UTS/N R18200347N6006NFraser Shane · San Marcos, TXBuilt 1978 · S/N 21062875N6006RPpb Aviation Management Inc · Wading River, NYBuilt 1965 · S/N 17253675N60072Torres Guillen Jesus F · Gridley, CABuilt 1968 · S/N 15070054N60074Barba John C · Missoula, MTBuilt 1968 · S/N 15070055N60075Zaier Alan S · Saint Paul, MNBuilt 1968 · S/N 15070056N6007BSkydive Deland Inc · Deland, FLBuilt 1956 · S/N 34007N6007CAdler Jeffrey S Trustee · Westminster, COBuilt 1978 · S/N R18200348N6007JAldrich Richard G · La Habor, CABuilt 1971 · S/N A1500307N6007RMaster Jacob M · Waddy, KYBuilt 1965 · S/N 17253676N60082Trinity Trust LLC · Fort Smith, ARBuilt 1968 · S/N 15070060N60087Butcher David W · Radford, VABuilt 1968 · S/N 15070061N6008ABreton Paula Jean · Carrollton, GAS/N 28608N6008BKarella Howard · Fairbanks, AKBuilt 1956 · S/N 34008N6008GBernadt Aviation Inc · Steinauer, NEBuilt 1969 · S/N 15071508N6008TYoungman Lawrence J · Penn Yan, NYBuilt 1964 · S/N 15060708N6009RCape Aerial Tours DBA · Chatham, MABuilt 1965 · S/N 17253678N6009TGies Paul E · Wauwatosa, WIS/N 15060709N600BFarley Bobby Joe · Lawton, OKBuilt 1960 · S/N 18253034N600CGAnderson Cody J · Orono, MEBuilt 1978 · S/N 18052998N600EERieman Sylvia · Newbury Park, CAS/N 18256336N600HBCoastal Aerops LLC · Montrose, ALBuilt 1978 · S/N 18266490
Back to AD 87-20-03 R2