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.

N6297FHitchcock Lonnie G · Sparta, TNS/N 337-0297N6297GMaclean Kenneth J · Northborough, MABuilt 1974 · S/N 18263311N6297HHackbart Gary H · Las Vegas, NVBuilt 1978 · S/N 20700472N6297RBejna Robert C · Addison, ILBuilt 1965 · S/N 15061597N6297TFrazier Joel A · Fennimore, WIBuilt 1964 · S/N 15060997N6297YL&L Aviation LLC · Baden, PAS/N 21064323N62983Studer Rodney J · Shelby, MIS/N 15063618N6298AExec Air Of Naples · Naples, FLBuilt 1956 · S/N 33098N6298EGreenes R&R LLC · Hobbs, NMBuilt 1983 · S/N 18268358N6298FKubik John A · Hardy, VAS/N 337-0298N6298MLapham John R · Palm Beach Gardens, FLBuilt 1980 · S/N 15284660N6299CCenturion Flight LLC · Auburn, WABuilt 1980 · S/N 21063858N6299DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272704N6299ECarpenter Daniel R · Jefferson City, MOBuilt 1959 · S/N 46399N6299FLynch Gregory R · Pahrump, NVBuilt 1966 · S/N 337-0299N6299KMarco Aviation Club Corp · Naples, FLBuilt 1975 · S/N 15077630N6299NAviation Trust Co LLC · Oklahoma City, OKS/N 18267823N6299PDanlars Aircraft Sales · Mccall, IDBuilt 1978 · S/N P21000165N6299RNorwood Dan L · Chippewa Falls, WIBuilt 1965 · S/N 15061599N6299SSena Gregori C · Buckeye, AZBuilt 1967 · S/N 15067099N6299TRegistered aircraftN-number assigned, not yet registeredS/N 15060999N629CMByrne Thomas J · Cascade, IDBuilt 1965 · S/N 18256340N629JWPenniman Reagan E · Georgetown, TXBuilt 1961 · S/N 15059205N629LBBachman Aviation LLC · Independence, IABuilt 1979 · S/N R1723063N629MMMcgraw Michael T · Gainesville, GABuilt 1973 · S/N 17262164N629WCCollins Jeffery Scott · Griffin, GABuilt 1963 · S/N 18254745N629WSPrecision Avionics Specialists · Griffin, GABuilt 1970 · S/N 21059363N62ACAllen Chorman & Son Inc · Milton, DEBuilt 1975 · S/N 18264345N62CGJain Ashish K · Hamilton, GABuilt 1973 · S/N 15075134N62ECSharp Aviation LLC · Pauls Valley, OKBuilt 1985 · S/N 18504428N62GKAugusta Flying Club Inc · Martinez, GABuilt 1978 · S/N 17271667N62JMVan Bergen Matthew D · Arlington Heights, ILS/N R18201834N62KKinyoun Robert C Jr · Bluff Point, NYBuilt 1962 · S/N 18051115N62KJStephani Timothy M · White Lake, WIBuilt 1957 · S/N 32933N62NAAdventure Aviation West LLC · Kalispell, MTS/N P3370269N62PBAlabama Fly Boys LLC · Cropwell, ALBuilt 1962 · S/N 17249273N62SGozashti Farid H · Abilene, TXBuilt 1973 · S/N P3370160N62SK55x LLC · Kalispell, MTS/N P21000096N62SMBell Charles S · Fort Payne, ALBuilt 1973 · S/N 17261862N62WPCarver Joseph · Bryson City, NCBuilt 1962 · S/N 17249440N63000Jet Boy LLC · Henderson, NVBuilt 1975 · S/N 15077036N63001Rbv Aviation And Cattle LLC · Kalispell, MTS/N 15077037N63002Nolt Shannon E · East Earl, PAS/N 15077038N63003Newell Rory H · Warner Springs, CAS/N 15077039N63006Registration Pending · Snohomish, WARegistration pendingBuilt 1975 · S/N 15077042N63008Wheaton Eric J · Gig Harbor, WAS/N 15077044N6300AByrne Theodore · Cannon Falls, MNBuilt 1956 · S/N 33100N6300KCash Richard W · Bossier City, LABuilt 1975 · S/N 15077631N6300PSchrempp Aviation LLC · Winnemucca, NVBuilt 1978 · S/N P21000166N6300QPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1981 · S/N 15285225
Back to AD 87-20-03 R2