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.

N91451Pettus Const Inc · Dallas, GABuilt 1973 · S/N 18262004N9145AWomack Wilbur A Jr · Jackson, LABuilt 1949 · S/N 18906N9145CReitz Andrew P · Pembroke Pines, FLS/N R18200419N9145GYost James J · Placentia, CABuilt 1971 · S/N 18260685N9145USharp Wayne H · Mena, ARBuilt 1976 · S/N 15078096N91464Breard Armand C · Monroe, LABuilt 1969 · S/N 18052091N9146AHusser Marilyn G · Independence, ORS/N 18907N9146GShea Bernie J · Polson, MTBuilt 1971 · S/N 18260686N9146MJc Aircraft Leasing LLC · Wasilla, AKBuilt 1970 · S/N U20601546N9146XMangun Charles L · Middleton, IDBuilt 1961 · S/N 18253546N91470Sky Sailing Inc · Warner Springs, CABuilt 1969 · S/N 18052094N91475Johnson Robert L · Douglas, AKBuilt 1969 · S/N 18052097N91476Petersen Greg · Chelan, WABuilt 1969 · S/N 18052098N9147BReed Zane · Mountain Home, IDBuilt 1958 · S/N 36747N9147CCope Eric E · Angels Camp, CABuilt 1954 · S/N 31246N9147GSnyder Barry L · Morrison, COBuilt 1971 · S/N 18260687N91484Scovel Simeon Edwin · Ontario, CABuilt 1973 · S/N 18262006N91489Dan River Aero Club Inc · Jonesville, NCBuilt 1973 · S/N 18262008N9148MBlackhole Inc · Round Rock, TXBuilt 1976 · S/N 18264702N9149BFoust Kal E · Lenox, MIBuilt 1958 · S/N 36749N9149CBryan Robert G · New Lenox, ILBuilt 1978 · S/N R18200422N9149MBoynton Scott E · Campbell Hall, NYBuilt 1970 · S/N U20601549N914AVNorcal Skydiving LLC · Cloverdale, CABuilt 1964 · S/N 18255445N914AZN969az LLC · Miami, FLBuilt 1985 · S/N 17276379N914CBChan Blair H · Arlington, TXBuilt 1977 · S/N R1722705N914EYDreimiller Raymond J Jr · Bloomfield, NYBuilt 1976 · S/N 15079131N914FCSinibaldi Glenn · Highland Park, NJBuilt 1969 · S/N 18052086N914HSHis Wings Air Service Inc · Hyder, AKS/N 185-0429N914JDAis Wings LLC · Grand Rapids, MIBuilt 1972 · S/N 17261296N914MDCrum Brian B · Warrensburg, MOS/N 51014N914RRMartinez Jeff L · Lewistown, MTS/N 17264508N914STAir Ex LLC · Chelan, WABuilt 1980 · S/N 18504010N914ZSkylens LLC · Hammond, LABuilt 1974 · S/N 17264444N91507Eagle Aviation LLC · Spearfish, SDBuilt 1973 · S/N 17261499N91508Stewart Bryan P · Carson City, NVBuilt 1969 · S/N 18259798N91509Watts Timothy R · Hermiston, ORS/N 18259799N9150BHarral Blake · Prescott Valley, AZFirst renewal noticeBuilt 1958 · S/N 36750N9150CAkers Joel W · Anchorage, AKBuilt 1954 · S/N 31249N9150HN9150h LLC · Charleston, SCBuilt 1975 · S/N 17265975N9150MSkyler Aviation Inc · San Diego, CABuilt 1970 · S/N U20601550N91510Registration Pending · Eagle River, AKRegistration pendingS/N 18259800N91513Attactix Aviation LLC · Tucson, AZBuilt 1969 · S/N 18259801N91515Bulkley Gregory A · Spokane, WABuilt 1969 · S/N 18259802N9151HFirst Flight Corp · San Diego, CABuilt 1975 · S/N 17265976N9151MMcatee Kevin Patrick Trustee · Ventura, CABuilt 1976 · S/N 18264703N9151UAdvanced Aviation LLC · New Century, KSBuilt 1976 · S/N 15078102N91529Dutchess Community College · Poughkeepsie, NYBuilt 1969 · S/N 18259808N91538Graves Dale E · Waukesha, WIBuilt 1969 · S/N 18259810N9153BMires James · Newnan, GABuilt 1958 · S/N 36753N9153CPax Enterprises Inc · Allen, TXBuilt 1978 · S/N R18200425
Back to AD 87-20-03 R2