OpenAirDocs.org
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.

N65439Pnl Aero LLC · Raleigh, NCBuilt 1981 · S/N 15285287N6543DBatte Randall E · Forest, MSBuilt 1979 · S/N 17272855N6543FJackson Road Flyers · Wayne, MIS/N 15063143N6543VChupito Sabrocito LLC · Paso Robles, CABuilt 1980 · S/N 172RG0766N65440G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 15281554N65449Hoeft Cliff A · Pilot Rock, ORBuilt 1978 · S/N 15281557N6544ESando Jan R · St Louis Park, MNS/N 56044N6544KWaldron Ronald J · Strongsville, OHBuilt 1980 · S/N 17274209N6544XAnderson Joseph · Tillamook, ORBuilt 1960 · S/N 57544N6544YSchwarzenberg Johannes · Helena, MTBuilt 1981 · S/N 21064429N6545AWunrow Steven M · River Falls, WIS/N 32442N6545DCosta Flying Service Inc · Painted Post, NYBuilt 1979 · S/N 17272856N6545GBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1971 · S/N 15072045N6545HAmerican Patrols Inc · Midland, TXBuilt 1975 · S/N 17265483N6545XTail Chaser LLC · Wilmington, DEBuilt 1960 · S/N 57545N65468Burger John J · Ocala, FLBuilt 1978 · S/N 15281569N6546AHayden Susan R · North Pole, AKBuilt 1956 · S/N 32443N6546EMenard Keith L · Bellevue, TXS/N 56046N6546NMitchell Matthew J · Penn Yan, NYBuilt 1978 · S/N 21063102N65470Jt Aero LLC · Wilmington, DEBuilt 1978 · S/N 15281570N65477Nistler Joseph C · Helena, MTS/N 18050637N6547CJrp Management LLC · Williams, AZBuilt 1980 · S/N 21063915N6547GLarson Jerry L Jr · Shelby, MTBuilt 1970 · S/N 15072047N6547MLeder John · Marble, NCS/N 18263748N6547NHart Anthony · Promise City, IABuilt 1978 · S/N 21063103N6547SMiller Bradley J · Joliet, MTS/N 15067347N65483American Aviation Inc · Brooksville, FLS/N 15281580N65489Flight Solutions LLC · Columbia, MOBuilt 1982 · S/N 17275762N6548ANebesky William E · Anchorage, AKBuilt 1956 · S/N 32445N6548ESewell William G Jr · Bremen, GABuilt 1978 · S/N 17272036N6548GRoeder Paul A · Waukon, IABuilt 1970 · S/N 15072048N6548SDersch Jonathan D · Mullica Hill, NJBuilt 1967 · S/N 15067348N6548VMaxwell Frank R · Fairbanks, AKBuilt 1980 · S/N 172RG0771N6548XGardner Maureice E · Garden City, KSS/N 57548N65495Circle W Flying Club Inc · Creighton, PABuilt 1978 · S/N 15281587N65498Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281588N6549DBbjs Investments LLC · Waukesha, WIBuilt 1979 · S/N 17272858N6549ENewton Donald H · Lewistown, MTBuilt 1959 · S/N 56049N6549GAviaschin LLC · Frisco, TXBuilt 1970 · S/N 15072049N6549KBurchinal Sam · Brookston, TXS/N 17251306N6549MWhitinger Ryan · Flowery Branch, GABuilt 1975 · S/N 18263749N654ALMoore Howard · Camden, TNBuilt 1977 · S/N 17269033N654ASDwyer Sean · Edmonds, WABuilt 1975 · S/N 18263788N65506Skelton James P Jr · Lithia Springs, GABuilt 1978 · S/N 15281593N6550XButterfield Rory A · Milan, NMBuilt 1960 · S/N 57550N65516J-Airco LLC · Nashville, TNBuilt 1982 · S/N 17275769N65518Tk Equipment LLC · Brownsburg, INBuilt 1982 · S/N 17275771N6551AGlynn Kathy G · Queenstown, MDBuilt 1956 · S/N 32448N6551EMoore Henry J · Deer Park, WABuilt 1959 · S/N 56051N6551HBas Part Sales LLC · Greeley, COBuilt 1981 · S/N 18267893
Back to AD 87-20-03 R2