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.

N3701UBowley Steven Jon · Phoenix, AZS/N 18255101N3702JMaslovsky Serhiy A · Carbondale, ILBuilt 1966 · S/N 15065002N3702LBailey April O · Papillion, NEFirst renewal noticeS/N 17253871N3702SWhite Edward H · Waco, KYS/N 17250902N3702UCc Flyers LLC · Corpus Christi, TXS/N 18255102N3703JSilver And Associates LLC · Ojai, CAS/N 15065003N3703SDavis William F · Oak City, NCBuilt 1963 · S/N 17250903N3703YWilemon Ronald J · Tulsa, OKBuilt 1963 · S/N 21058203N3704FBrzezinski Samuel M · Boyceville, WIS/N 17255199N3704LN3704l LLC · Jacksonville, FLBuilt 1965 · S/N 17253873N3705LRed Five Aviation LLC · Wilmington, DEBuilt 1965 · S/N 17253874N3705SGra Flying Club LLC · Bay City, MIBuilt 1963 · S/N 17250905N3705YMunoz Concepcion · Tulsa, OKBuilt 1963 · S/N 21058205N3706UBrownfield Ken F · Boonville, MOS/N 18255106N3706YAlexander Steve Craig · Shreveport, LABuilt 1963 · S/N 21058206N3707DWilliams Charles S · Pearland, TXS/N 34407N3707LPropwash Aviation LLC · Midland, MIBuilt 1965 · S/N 17253876N3707RHartsfield Amy G · Pace, FLBuilt 1966 · S/N 17255507N3708JBormann Wayne T · Valley Center, KSBuilt 1966 · S/N 15065008N3708RNeufeld Henry F · Brownfield, TXBuilt 1966 · S/N 17255508N3708SPalmer Christopher · Soddy Daisy, TNS/N 17250908N3708UCollins George H · Murfreesboro, TNBuilt 1963 · S/N 18255108N3709DAbidance Inc · Winthrop, WABuilt 1957 · S/N 34409N3709FWeaver Jerry T Jr Trustee · Anchorage, AKBuilt 1966 · S/N 17255204N3709JBoughter William C · Port Townsend, WAS/N 15065009N3709RBaillie Stephen H · Flint, MIBuilt 1966 · S/N 17255509N3709UMoser Scott M · Pisgah Forest, NCS/N 18255109N370JCSouth Oaks Inc · Hollywood, FLBuilt 1977 · S/N U206-04024N370LATurning Point @ Sonrise Inc · Hartsville, TNBuilt 1964 · S/N 17251995N370RAmerican Aircraft Management LLC · Irving, TXBuilt 1980 · S/N U20605501N370SNesbit Stephen W · Hemphill, TXBuilt 1968 · S/N 17700692N370XPMckerney Charles A · Anchorage, AKBuilt 1976 · S/N 17267622N3710DHiller Paul D · Grafton, OHBuilt 1957 · S/N 34410N3710FDavis Charles Arthur Wesley · Petersburg, AKS/N 17255205N3710LRegistered aircraftS/N 17253879N3710UFollette Aviation LLC · Scottsdale, AZBuilt 1963 · S/N 18255110N3711FMission Aviation Training Academy · Arlington, WABuilt 1966 · S/N 17255206N3711SWittco Aero LLC · Vancouver, WAS/N 15062988N3712LNoble Todd D · Hudson, INBuilt 1965 · S/N 17253881N3712UVarian Dennis D · West Lafayette, OHBuilt 1963 · S/N 18255112N3712VImperium Solutions LLC · Cheyenne, WYBuilt 1977 · S/N R1722261N3712YRpx Technologies Inc · Stillwater, OKBuilt 1963 · S/N 21058212N3713DHedgecock David H · Elkhorn, WIFirst renewal noticeBuilt 1957 · S/N 34413N3713FDavis Jeffery S · Oregon City, ORBuilt 1966 · S/N 17255208N3713RTroglio Joseph A · Peoria, ILBuilt 1966 · S/N 17255513N3713UDaggy Curt L III · Red Bluff, CABuilt 1963 · S/N 18255113N3714DZombo Brian T · Youngsville, NYBuilt 1957 · S/N 34414N3714FSwearengen Sally · Tunica, MSBuilt 1966 · S/N 17255209N3714LArizona Aircraft Leasing LLC · Mesa, AZBuilt 1965 · S/N 17253883N3714USchaffer John Paul · Prior Lake, MNBuilt 1963 · S/N 18255114
Back to AD 87-20-03 R2