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.

N9978HBrumette Aviation LLC · Vidalia, GABuilt 1982 · S/N 18268158N9978NFulwiler Air LLC · Green Bay, WIBuilt 1975 · S/N 18052633N9978XLyons Jeffery E · Carrollton, GABuilt 1961 · S/N 185-0178N9979Dubois County Airport Authority · Huntingburg, INBuilt 1967 · S/N R1720024N9979B79bravo Leasing LLC · Lincoln, DEBuilt 1957 · S/N 34379N9979CVan Lehn Sethany A · Frederick, MDBuilt 1978 · S/N R18200495N9979EFitzgerald Brett · Wellsville, UTBuilt 1975 · S/N 18264039N9979GSteinke Matthew R · Gibson, IABuilt 1971 · S/N 18800779N9979NAvtech Global LLC · Renton, WABuilt 1975 · S/N 18052634N9979TRoth Ellen C · Blakely Island, WABuilt 1960 · S/N 18253079N9979XGeorge Anthony L · Billings, MTBuilt 1961 · S/N 185-0179N997AKLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N 20700019N997CHHolly Ridge Planting · Indianola, MSBuilt 1986 · S/N T21064997N997JBBrannan Brendon Kyle · Gardnerville, NVBuilt 1982 · S/N 18268276N997PCHunter Marty Paul · Christine, TXFirst renewal noticeS/N 18267241N997RRegistered aircraftBuilt 1974 · S/N 21060386N997SEAero Equities LLC · Ventura, CABuilt 1978 · S/N 17271571N997TXPeso Consulting LLC · Lexington, TXS/N 182-54369N9980AYork Robert L · Capitan, NMBuilt 1950 · S/N 19340N9980BBudenbender Philip W · Weatherford, TXBuilt 1957 · S/N 34380N9980ERapid Flyers LLC · Zionsville, INBuilt 1975 · S/N 18264040N9980GSchwend Brian · Forsyth, MTBuilt 1971 · S/N 18800780N9981NGagnon Matthew I · Fairbanks, AKS/N U20603745N9981VWeeks Richard F Jr · Portsmouth, NHFirst renewal noticeBuilt 1974 · S/N 17264599N99826Cp Aviation · Santa Paula, CABuilt 1985 · S/N 17276514N9982TAero Club Albatross · Blairstown, NJBuilt 1960 · S/N 18253082N9982YChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1982 · S/N 21064659N99832Watch Ya Head Aviation 1 LLC · Zionsville, INBuilt 1985 · S/N 17276515N9983BMartyn Michael L · Ridgecrest, CABuilt 1957 · S/N 34383N9983HVisual Group LLC · Ringgold, GABuilt 1982 · S/N 18268161N9983MTate Clint · Boise, IDBuilt 1978 · S/N U20604632N9983RHellmann Andrew P · Newark Valley, NYBuilt 1986 · S/N U20607011N9983TPara-Plane Aviation Inc · Thomasboro, ILBuilt 1960 · S/N 18253083N9983VHeyman William L · Santa Fe, NMBuilt 1974 · S/N 17264601N9984AWarwick Company LLC · Jupiter, FLBuilt 1950 · S/N 19556N9984CTucker Harry B · Lexington, NCBuilt 1978 · S/N R18200496N9984EVelasco Timoteo W · South Jordan, UTBuilt 1975 · S/N 18264044N9984TOhman Mikael A · Watonga, OKS/N 18253084N9984VValley Drug Of Malta Inc · Malta, MTBuilt 1974 · S/N 17264602N9985BJacks Charles D · Morse, LABuilt 1982 · S/N 172RG1107N9985NJakab Stephen F · Wasilla, AKBuilt 1975 · S/N 18052640N9986AHerbert Wallace R · Marble Falls, TXBuilt 1950 · S/N 19346N9986HKirkman Todd A · Chetek, WIS/N 18268163N9986MLogan Timothy R · Valley City, NDS/N U20604635N9986TSkylane Ventures LLC · Keizer, ORBuilt 1960 · S/N 18253086N99870Christiansen Aviation LLC · Wilmington, DES/N 17276519N99871Civil Air Patrol · Maxwell Afb, ALS/N 17276520N99872Rps Holdings N99872 LLC · Magnolia, TXS/N 17276521N9987ALewis Benjamin · Delano, MNBuilt 1950 · S/N 19557N9987HRoger Roger Aviation LLC · Delaware, OHBuilt 1982 · S/N 18268164
Back to AD 87-20-03 R2