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.

N93196Registration Pending · Lafayette, LARegistration pendingBuilt 1981 · S/N 15285439N9319AMyers Alan J · Danville, ILBuilt 1949 · S/N 7398N9319HHoffman Stanley L Jr · Bethel, AKBuilt 1975 · S/N 17266084N9319UJohnson Douglas G · Mason City, IABuilt 1976 · S/N 15078269N9319XShepherd Joseph R · Fayetteville, GAS/N 18253719N931EMClackamas County Sheriffs Office · Oregon City, ORBuilt 1975 · S/N 18263643N931MSColeman Aviation LLC · Livingston, TNBuilt 1968 · S/N 17257349N931URRegistration Pending · Ivins, UTRegistration pendingS/N 56048N93202Nature State LLC · Portland, ORBuilt 1977 · S/N 18503198N9320CRiley Coda L · Beaumont, TXBuilt 1955 · S/N 31718N9320DDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 172RG1119N9320GChiles Farms LLC · Hooper, COBuilt 1971 · S/N 18260860N9320HPlane Tail LLC · Bethany, CTBuilt 1975 · S/N 17266085N9320RHaskell Flyers LLC · Sublette, KSBuilt 1978 · S/N R18200689N9320XBlue Skies Air LLC · Portland, ORBuilt 1985 · S/N 18268488N93214Sundance Air Services Inc · Alameda, CABuilt 1981 · S/N 15285444N93216East Moriches Aerial Advertising Ltd · Ridge, NYBuilt 1966 · S/N R172-0110N9321BGippner Gerald W · Olathe, KSBuilt 1958 · S/N 55121N9321EMertinez Matos Daniel Enrique · Fajardo, PRS/N 17272225N9321GFontana Michael A · Kirkwood, MOS/N 18260861N9321XSakonnet Aircharter · Bradenton, FLBuilt 1985 · S/N 18268489N93229Back Country Club LLC · Crawford, TXBuilt 1976 · S/N 18503200N9322ALeamon Douglas H Trustee · Stockwell, INBuilt 1949 · S/N 7401N9322CWaters David J · Phelps, NYBuilt 1959 · S/N 46402N9322GHutchinson Darrold Trustee · Hingham, MTBuilt 1971 · S/N 18260862N9322XCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 18268490N93239Minuteman Aviation Inc · Missoula, MTBuilt 1981 · S/N 15285447N9323BCarter Lance F · Bangor, CABuilt 1958 · S/N 55123N9323ESchock Richard F II · Peoria, ILBuilt 1979 · S/N 17272226N9323XBertelsen Sven Erik · Gulfport, FLBuilt 1961 · S/N 18253723N9324ABoswell Kurt R · Renton, WAS/N 7636N9324CWillig Zachary · Angola, INBuilt 1955 · S/N 31722N93251Flaherty Edward T · Scotia, NYBuilt 1981 · S/N 15285448N9325ABarron Aviation LLC · Perry, MOS/N 7404N93260Webb Michael · Magnolia, TXBuilt 1974 · S/N 21060322N93262Land Office LLC · Burlington, COBuilt 1974 · S/N 21060324N93263Xin Han Aviation LLC · Atwater, CABuilt 1981 · S/N 15285451N93264Wolfe Michael S · Norco, CABuilt 1981 · S/N 15285452N93267Cachorro Cattle Co · Granbury, TXBuilt 1976 · S/N 18503204N9326DAll Seasons Aviation LLC · Laredo, TXBuilt 1982 · S/N 172RG1122N9326EWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 17272228N93271Pauma Holdings LLC · Colorado Springs, COBuilt 1981 · S/N 15285454N93272Grossman Marc · Lake Oswego, ORBuilt 1976 · S/N 18503206N93274Wltf LLC · Caldwell, IDBuilt 1974 · S/N 21060335N93276Fitzgerald Robert Paul · Eagle River, AKBuilt 1977 · S/N 18503208N9327ERhoades Christine · Laguna Beach, CABuilt 1984 · S/N 18268396N9327XHull Ray · Waynoka, OKS/N 18253727N93281Bishop Mike · Rifle, COBuilt 1981 · S/N 15285456N93285Corrie Brent · Vero Beach, FLBuilt 1974 · S/N 21060341N9328BDethlefs Darrell C · Mechanicsburg, PAS/N 55128
Back to AD 87-20-03 R2