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.

N9026AMoyer Michael · Duarte, CABuilt 1949 · S/N 18781N9026GTekoa Skylane Club · Chattaroy, WAS/N 18260566N9026MGlenn Stephen B · Texarkana, TXBuilt 1977 · S/N 21062051N9027ABrowning Charles R · Fond Du Lac, WIBuilt 1949 · S/N 18782N9027GCessna Flyers LLC · Spartanburg, SCBuilt 1971 · S/N 18260567N9027HAdriatic Holdings LLC · Cheyenne, WYS/N 17265908N9027TSwanson Roy D · Douglas, AZBuilt 1960 · S/N 52927N9027XDelauder Patrick J · Terra Alta, WVBuilt 1961 · S/N 18253427N9028CEvans Johnny D I · Wasilla, AKBuilt 1954 · S/N 31076N9028MMumford Charles E Trustee · Big Lake, AKBuilt 1970 · S/N 18052128N9028TFultz William L · Buckhannon, WVS/N 52928N9028XGold Coast Skydivers Louisiana Adventures LLC · Slidell, LABuilt 1961 · S/N 18253428N9029DKemp Ted · Pleasant Shade, TNS/N 17254099N9029MSturgeon Ronald A · Anchorage, AKBuilt 1970 · S/N 18052129N9029WKnutson Wayne R · Thompson, NDS/N 17248036N9029XWichmann David · Park City, UTBuilt 1961 · S/N 18253429N902AZSantiago Felipe · Miami, FLBuilt 1981 · S/N 17275091N902FAVero Technical Support Inc · Pensacola, FLBuilt 1980 · S/N 17273785N902HMacvey Troy R · Milan, INBuilt 1971 · S/N 17259252N902KSSmart Aviation Solutions Inc · Lakeland, FLBuilt 1974 · S/N 15076244N902NSRegistration Pending · Pottstown, PARegistration pendingBuilt 1981 · S/N 17275415N9030ALimbach Cynthia S · Verona, ILBuilt 1949 · S/N 18785N9030RWilliams Transportation LLC · St Paul, MNBuilt 1967 · S/N 185-1244N9030TClark Joseph J · Fairbanks, AKBuilt 1960 · S/N 52930N9031AKiesling Michael J · Omro, WIBuilt 1949 · S/N 18786N9031UBlue Sky Aero Club Inc · Escondido, CABuilt 1977 · S/N 18265445N9032AProag Services Inc · Mahnomen, MNBuilt 1949 · S/N 18787N9032CGoodman Kim J · Burnsville, NCBuilt 1978 · S/N R18200377N9032MWillke Theodore Lawrence II · Tacoma, WAS/N 21062052N9032XWalters Douglas R · Sunbury, OHBuilt 1961 · S/N 18253432N9033AEverson David · Redding, CABuilt 1949 · S/N 18788N9033CPrice Tom Jr · Baker City, ORBuilt 1954 · S/N 31081N9033GHillside Air Service LLC · Roanoke, INS/N 18260573N9033MBasinger Robert C · Freedom, PABuilt 1976 · S/N 18264652N9034CGrizzly Air Service Inc · Paris, TXBuilt 1954 · S/N 31082N9034GDanielle K Heckman · Crystal River, FLBuilt 1971 · S/N 18260574N9034XCunningham Patrick J · Council Bluffs, IABuilt 1961 · S/N 18253434N9035GRd Smith LLC · Rexburg, IDBuilt 1971 · S/N 18260575N9036MChalk 2 Inc · Apple Valley, CABuilt 1977 · S/N 21062053N9036RBaltz David M · Superior, COBuilt 1978 · S/N R18200658N9036XNiemeyer Henry · Eagle River, AKS/N 18253436N9037MLevin Austin T Trustee · Prairie Du Sac, WIBuilt 1970 · S/N 18052137N9037XFornasier Manuel Jr · Westcliffe, COBuilt 1961 · S/N 18253437N9038CMackay Scott · Spokane Valley, WABuilt 1954 · S/N 31086N9038HPeterson Todd B · Cameron Park, CABuilt 1975 · S/N 17265912N9039CDouble O Seven Limited Co · Carefree, AZBuilt 1978 · S/N R18200378N9039TMetal Bird LLC · West Jordan, UTBuilt 1960 · S/N 52939N9039XAhrens Videll A · Tintah, MNBuilt 1961 · S/N 18253439N903AZN903az LLC · Miami, FLBuilt 1984 · S/N 17276198N903KKHanger Nine Point Five LLC · Aztec, NMBuilt 1970 · S/N 33701263
Back to AD 87-20-03 R2