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.

N956WBEd Payne Motors Inc · Weslaco, TXBuilt 1981 · S/N 21064532N9570BStriplin Bradley H · Pittsboro, NCS/N 32867N9570XGroves Chandler H DBA · Farmington, CAS/N 21057870N9571BFarrell Mark A · Omaha, NEBuilt 1957 · S/N 32868N9571HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266236N9571VTempleton John E · Loami, ILBuilt 1974 · S/N 17264373N9571XBarnett David Kirk · Brock, TXS/N 21057871N95720Stilley John · Flagstaff, AZBuilt 1978 · S/N 18266608N95721Copeland Danny K · Roseville, CABuilt 1978 · S/N 18266609N95722Frick Gregory A · Portland, ORBuilt 1985 · S/N 15285962N9572GJones Robert D Jr · Chugiak, AKBuilt 1972 · S/N U20601772N9572HGeneral Aviation LLC · Henderson, NVBuilt 1975 · S/N 17266237N9572LJav Air Services LLC · Anchorage, AKBuilt 1986 · S/N 17276582N9572VHill Timothy E · Hooks, TXBuilt 1974 · S/N 17264374N9572XSparks James D · Glennallen, AKBuilt 1962 · S/N 21057872N95737Kent State University · Stow, OHBuilt 1985 · S/N 15285964N9573BDocarmo Aviation LLC · Dallas, TXBuilt 1981 · S/N 172RG0890N9573TLearn To Fly LLC · Portal, GABuilt 1959 · S/N 57373N9573VReynolds Darryl G · Wills Point, TXBuilt 1974 · S/N 17264375N9573XLenyk Michael · Venice, FLBuilt 1986 · S/N 18268558N9573ZBangert Richard E III · Seattle, WABuilt 1981 · S/N U20606549N95740Nicholes Steven A Trustee · Portland, ORBuilt 1978 · S/N 18266615N95747Eichelberger John Andrew · Winchester, MABuilt 1978 · S/N 18266617N9574BHinds Community College · Bolton, MSBuilt 1981 · S/N 172RG0891N9574GKreiner Kurt · Rch Palos Vrd, CABuilt 1972 · S/N U20601774N9574HJb III LLC · Stuart, FLBuilt 1975 · S/N 17266238N9574TMcclellan Fred L · Flint, MIBuilt 1960 · S/N 57374N9574XFlying Nova LLC · Anchorage, AKS/N 21057874N9575AConway Sheila R · Seattle, WABuilt 1949 · S/N 19136N9575GGolden Eagle Outfitters · Delta Junction, AKFirst renewal noticeBuilt 1972 · S/N U20601775N9575HBoca Aircraft Partners Inc · Coral Springs, FLBuilt 1981 · S/N 18267965N9575VFurnari Alfio · Hutchinson Island, FLBuilt 1974 · S/N 17264377N95764Marc Inc · Bolton, MSBuilt 1978 · S/N 18266622N95766Ongstad William · Harvey, NDBuilt 1978 · S/N 18266623N9576GWerth Lance C · Johnson Lake, NEBuilt 1974 · S/N 18801542N9576TDe Vincenzo Chiara · Chicago, ILBuilt 1960 · S/N 57376N9577BRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1981 · S/N 172RG0894N9577VMdr Flying Inc Trustee · Wilmington, DEBuilt 1974 · S/N 17264379N9577XColumbia Asset Trust Corp Trustee · Wichita, KSS/N 18268560N9577YShort Notice Inc · Pensacola, FLBuilt 1981 · S/N 21064552N95785Elton Donald Robert · Kissimmee, FLS/N 18266630N95787Wisconsin Aviation - Four Lakes Inc · Madison, WIBuilt 1985 · S/N 15285967N95789Katmai LLC · Mount Pleasant, TXBuilt 1978 · S/N 18266632N9578BHalseth Harald E · El Paso, TXBuilt 1981 · S/N 172RG0895N9578XTvat LLC · Sun City, AZS/N 21057878N95797Kent State University · Stow, OHBuilt 1985 · S/N 15285968N9579ABolan Steve A · Concrete, WABuilt 1949 · S/N 19140N9579EAdventist World Aviation · Wilson, NCBuilt 1984 · S/N 18268428N9579XHayden Luke S · Yardley, PABuilt 1986 · S/N 18268561N957CFBergdoll Barry L · Juneau, AKS/N 31623
Back to AD 87-20-03 R2