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.

N739GVQuarter To Two Flying Club Inc · Williamsport, PAS/N 17270540N739GXMusic City Air LLC · Rogersville, ALBuilt 1978 · S/N 17270542N739GYRadecki Francis R · Carmichael, CABuilt 1978 · S/N 17270543N739HCGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1978 · S/N 17270547N739HDRoseland Dan E · Sonoma, CABuilt 1978 · S/N 17270548N739HETakai Hiroyasu · San Jose, CABuilt 1978 · S/N 17270549N739HHAbove And Beyond Aviation LLC · Austin, TXBuilt 1978 · S/N 17270552N739HKSouthwest Aeronautics Mathematics & Science Acad · Albuquerque, NMBuilt 1978 · S/N 17270554N739HPHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1978 · S/N 17270558N739HSOrange County Flight Center Inc · Santa Ana, CABuilt 1978 · S/N 17270561N739HX739hx LLC · Jackson, MIBuilt 1978 · S/N 17270566N739HZZrelak Patrick H · Apple Valley, CABuilt 1978 · S/N 17270568N739JBS O W Aviation LLC · Crystal River, FLBuilt 1978 · S/N 17270570N739JCMoontown Airport Inc · Brownsboro, ALBuilt 1978 · S/N 17270571N739JDBergstrom Aircraft Inc · Pasco, WABuilt 1978 · S/N 17269999N739JEMountain South Aviation LLC · Telford, TNBuilt 1978 · S/N 17270573N739JFSagori Aviation LLC · Orlando, FLBuilt 1978 · S/N 17270574N739JGLfw Investments LLC · Hillsborough, NCBuilt 1979 · S/N R18200999N739JHEfinger John · Cresson, TXBuilt 1979 · S/N R18201000N739JROklahoma State University · Stillwater, OKBuilt 1978 · S/N 17270584N739JUGregg Flying Service Inc · Durango, COBuilt 1978 · S/N 17270587N739JWJuliet Whiskey LLC · Wilmington, DEBuilt 1978 · S/N 17270589N739KBBentley Michael P · Spofford, NHBuilt 1978 · S/N 17270594N739KFFive Two Investments LLC · Oconomowoc, WIS/N 17270598N739KKN739kk LLC · Phoenix, AZBuilt 1978 · S/N 17270602N739KRPayne David · Maryville, TNS/N 17270608N739KSPlane One LLC · Kokomo, INBuilt 1978 · S/N 17270609N739KYFlyright Aviation Inc · North Las Vegas, NVS/N 17270615N739LBBandy Robert W · Ridgecrest, CABuilt 1978 · S/N 17270618N739LCHall Kenneth C · Durham, NCBuilt 1978 · S/N 17270619N739LDDass Ronald L · Hutchinson, MNS/N 17270620N739LJHadley Susan S · Hamilton, GABuilt 1978 · S/N 17270625N739LKBrown Yorke J · Enfield, NHBuilt 1978 · S/N 17270626N739LSBenham Properties LLC · Sullivan, INBuilt 1978 · S/N 17270633N739LTBlue Sky Flight Training LLC · Hamilton, OHBuilt 1978 · S/N 17270634N739LUBergstrom Aircraft Inc · Pasco, WABuilt 1978 · S/N 17270635N739LVCentennial Aircraft LLC · Boulder, COBuilt 1978 · S/N 17270636N739LWFlycarolina LLC · Concord, NCS/N 17270637N739MCaurus Power Inc · Santa Rosa, CABuilt 1978 · S/N P21000063N739MBC P Aviation Inc · Santa Paula, CABuilt 1978 · S/N 17270641N739MFClover Park Technical College · Lakewood, WABuilt 1978 · S/N 17270645N739MHWhite Jeffrey M · Carlsbad, CABuilt 1978 · S/N 17270647N739MJPlane Nuts Aviation LLC · Livingston, LABuilt 1978 · S/N 17270648N739MKSale Reported · Peachtree City, GASale reported, canceledBuilt 1978 · S/N 17270649N739MMWet Sky LLC · Fort Myers, FLBuilt 1978 · S/N 17270651N739MREagle Simulator LLC · Lake Oswego, ORBuilt 1978 · S/N 17270654N739MSCosta Flying Service Inc · Painted Post, NYS/N 17270655N739MYSky Safety Inc · San Antonio, TXBuilt 1978 · S/N 17270661N739NCFairmont State University · Fairmont, WVBuilt 1978 · S/N 17270665N739NGTuskegee Airmen National Historical Museum Inc · Detroit, MIBuilt 1978 · S/N 17270669
Back to AD 87-20-03 R2