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.

N704GEPester Jerome · Hingham, MTBuilt 1976 · S/N 15078593N704GFDresti Mauro · Pomona, CABuilt 1976 · S/N 15078594N704GGGorin Gustavo A · Statesboro, GABuilt 1976 · S/N 15078595N704GKMcmullen Julie A · Skwentna, AKBuilt 1976 · S/N 15078598N704GRMellor James F · Spanish Fork, UTFirst renewal noticeBuilt 1976 · S/N 15078604N704GXHunt Greg · Rolling Prairie, INBuilt 1976 · S/N 15078610N704HBOtero Alberto A · Fort Pierce, FLBuilt 1976 · S/N 15078614N704HCBrown William C · Columbia, CABuilt 1976 · S/N 15078615N704HDCleary John P · Worcester, MABuilt 1976 · S/N 15078616N704HEFour Sisters Aviation LLC · Fayetteville, GABuilt 1976 · S/N 15078617N704HFNo Name Aviation LLC · Wilmington, DES/N 15078618N704HGAvery Ricky E · Redfield, SDBuilt 1976 · S/N 15078619N704HKChilstrom John S · Austin, TXBuilt 1976 · S/N 15078622N704HRLitcof Brian P · Moultonborough, NHBuilt 1976 · S/N 15078628N704HYStatter Daniel E · Chicago, ILBuilt 1976 · S/N 15078635N704JCAskenasy George R · Cleburne, TXBuilt 1976 · S/N 15078639N704JFHammer Joseph W Jr · Shannon, ILBuilt 1976 · S/N 15078642N704JHPhelps Clay DBA · Santa Paula, CABuilt 1976 · S/N 15078644N704JKWardle Lynn A · Rogue River, ORBuilt 1976 · S/N 15078646N704JLSprecher Susan E · Locust Grove, GABuilt 1976 · S/N 15078647N704JQRusso Robert J · Hope Valley, RIS/N 15078651N704JRAirgo Inc · Centralia, ILBuilt 1976 · S/N 15078652N704JSCassels William · Phoenix, AZBuilt 1976 · S/N 15078653N704JVVan Zyl Larry D Trustee · Sherwood Forest, CABuilt 1976 · S/N 15078656N704JXSchwettmann Dennis E · Nampa, IDBuilt 1976 · S/N 15078658N704KAMartin Noah I · Brookeville, MDBuilt 1976 · S/N 15078661N704KDSmith Kenneth E Jr · Collinsville, OKBuilt 1976 · S/N 15078664N704KHCampbell Bruce A · Henderson, NVBuilt 1976 · S/N 15078668N704KPMassari John C · Wantage, NJBuilt 1976 · S/N 15078674N704KQJones Gary L · Athens, GABuilt 1976 · S/N 15078675N704KREagle Aeroplane LLC · Delano, TNBuilt 1976 · S/N 15078676N704KSFlying Ace LLC · Lakeville, MNS/N 15078677N704KUHoelscher Mark A · Richmond, INS/N 15078679N704KVArellano Eric · Harlingen, TXBuilt 1976 · S/N 15078680N704KXBain Joshua L · Watauga, TXBuilt 1976 · S/N 15078682N704LASoutheastern Oklahoma State University · Durant, OKBuilt 1976 · S/N 15078685N704LCEdwards Pacific Aviation Corp · Dover, DEBuilt 1976 · S/N 15078687N704LFSable Douglas B · Petersburg, VABuilt 1976 · S/N 15078690N704LGMunger Christopher M · Watertown, MABuilt 1976 · S/N 15078691N704LJLepp Jason E · Butterfield, MNBuilt 1976 · S/N 15078693N704LKGreen Daryl Keith · Grove City, OHBuilt 1976 · S/N 15078694N704LPRother Michael V · Granbury, TXBuilt 1976 · S/N 15078698N704LRTcm Flying Club Inc · Mobile, ALBuilt 1976 · S/N 15078700N704LVBrock George W · Union, MOBuilt 1976 · S/N 15078704N704MGStephens Brian A · Bruceville, INS/N 15078715N704MHOrmond Aircaft Leasing & Management Inc · Ormond Beach, FLBuilt 1976 · S/N 15078716N704MKPerez Sigfredo A · Fort Buchanan, PRS/N 15078718N704MQGriffin Shawn · Locust Grove, GAS/N 15078723N704MTAirways Aviation Services LLC · Miami, FLBuilt 1976 · S/N 15078726N704MUJones K L III · Jasper, ALBuilt 1976 · S/N 15078727
Back to AD 87-20-03 R2