OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N6041NLj Camp LLC · Longview, TXS/N 18504297N6041RStanley Herb · Morgan City, LABuilt 1965 · S/N 17253710N60425Sale Reported · Lexington, KYSale reportedBuilt 1969 · S/N 15070297N60429Mccall Freddie · Brewton, ALS/N 15070299N6042AWoods Richard C · Raeford, NCS/N 28642N6042BWilson Janis O · Friendswood, TXBuilt 1957 · S/N 34042N6042JGeer Chad C · Murrieta, CABuilt 1972 · S/N A1500342N6042RMetz Jonathan M · Corpus Christi, TXBuilt 1965 · S/N 17253711N60439Walker Timothy M · Brockport, NYS/N 15070307N6043AGriffin Tiffany J · Collinsville, OKBuilt 1956 · S/N 28643N6043RDelage Enterprises · Dent, MNBuilt 1965 · S/N 17253712N60441Hawkins Richard · Tybee Island, GAS/N 15070308N60443Diesing Daniel D · Monroe, MIBuilt 1969 · S/N 15070310N60447Marquette County Flying Club · Marquette, MIBuilt 1969 · S/N 15070314N60449Carlson Matthew S · Westminster, COBuilt 1969 · S/N 15070316N6044NB407 LLC · Seattle, WABuilt 1981 · S/N 18504298N6044RLee Brett · Austin, TXBuilt 1965 · S/N 17253713N6045AFleischman Matthew A · Moab, UTBuilt 1956 · S/N 28645N6045GWalls Sales LLC · Poplar Bluff, MOBuilt 1969 · S/N 15071545N6045JCavender Michael J · Tucson, AZBuilt 1975 · S/N 18263617N6045TSaladino Michael J · Metairie, LABuilt 1964 · S/N 15060745N60463Angeltown LLC · Covina, CABuilt 1969 · S/N 15070326N6046ADickerson Danny W · York, SCBuilt 1956 · S/N 28646N6046KAl-Rubaiie Haider A · Fort Worth, TXBuilt 1975 · S/N 15077494N6046NPappas Joshua · Wilmette, ILBuilt 1981 · S/N 18504300N6046TDimaio Joseph V · Leesville, LABuilt 1964 · S/N 15060746N60470Lowry John R · Mexico, MOBuilt 1969 · S/N 15070333N60474Koeck Max IV · Metairie, LAS/N 15070337N60475Blair Shawn C · Mandeville, LABuilt 1969 · S/N 15070338N60477Edwards Blake A · Greensburg, KYS/N 15070340N6047AJames Theodore B · Marine St Crx, MNS/N 28647N6047BOliver Ross C Trustee · Eagle River, AKBuilt 1957 · S/N 34047N6047RSwanson Brad J · Yakutat, AKBuilt 1965 · S/N 17253716N60484Erb Charles A · Holden, MEBuilt 1969 · S/N 15070344N60487Mac Mor Ltd · East Troy, WIBuilt 1969 · S/N 15070347N6048GWitthuhn Johnie B · Callaway, NEBuilt 1973 · S/N 18801172TN6048JAll Elements Aviation LLC · Newnan, GABuilt 1972 · S/N A1500348N6048NAero-Mach Labs Inc · Wichita, KSBuilt 1978 · S/N 21062916N60492Saint John Harold James · Arvada, COBuilt 1969 · S/N 15070350N60494Heilmann Charli E · Martinsburg, WVBuilt 1969 · S/N 15070352N60499Marion Military Institute · Marion, ALBuilt 1969 · S/N 15070355N6049AMetcalf Nate J · Hooker, OKBuilt 1956 · S/N 28649N6049JKyne James M Jr · Vacaville, CABuilt 1972 · S/N A1500349N6049RSmith Timothy John · Parkville, MDBuilt 1965 · S/N 17253718N604MSHawaiian Airlift Company Llp · Kihei, HIFirst renewal noticeBuilt 1957 · S/N 33985N604RDSaint Aviation Ministry LLC · Ozark, MOBuilt 1974 · S/N 18052417N60502Janak Jeffrey J · Corpus Christi, TXBuilt 1969 · S/N 15070356N60505Mcbride Kristi L · Lexington, OKBuilt 1969 · S/N 15070359N60509Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1969 · S/N 15070361N6050GNihan Gregory K · Hanson, MABuilt 1969 · S/N 15071550
Back to AD 87-20-03 R2