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.

N6412DPort Aero Club Inc · Gold River, CABuilt 1979 · S/N 17272792N6412EJoseph Jeric A · Lincoln, MTBuilt 1959 · S/N 46512N6412FRick Aviation Inc · Newport News, VABuilt 1979 · S/N 17273220N6412MNighthawk N8231g LLC · Pompano Beach, FLS/N 15284715N64134Torres Felix · Dallas, TXBuilt 1975 · S/N 17265039N64135Flying Mermaid LLC · Aiea, HIBuilt 1975 · S/N 17265040N6413BMccroan William R · Blountstown, FLBuilt 1956 · S/N 29613N6413ESchad Tom J · Gainesville, TXBuilt 1959 · S/N 46513N6413FRouse Jeffrey S · Cumming, GABuilt 1966 · S/N 15063013N6413PAlta Air LLC · Boise, IDBuilt 1978 · S/N P21000176N6413TCaraway James T · Milwaukee, WIS/N R18202015N6413XMeyer Charles H · Stratford, CABuilt 1960 · S/N 18050913N64140C64140 LLC · Bloomington, INBuilt 1975 · S/N 17265043N64147Summit Aviation Inc · Kingston, NYBuilt 1975 · S/N 17265047N6414BFamuliner Dennis M · Carrollton, MOS/N 29614N6414ETobin Cory J · Cheney, WAS/N 46514N6414FMessing Jeffrey B · Ruth, MIBuilt 1966 · S/N 15063014N6414GBurks Aviation Inc · Hattiesburg, MSBuilt 1970 · S/N 15071914N6414KLindberg Joseph J · Chugiak, AKBuilt 1975 · S/N 15077690N64153Davies Thomas V · Chula Vista, CABuilt 1977 · S/N 18052874N64154Jw Skyhawk LLC · Austin, TXBuilt 1975 · S/N 17265049N64155Lowcountry Flight LLC · Johns Island, SCBuilt 1975 · S/N 17265050N64157Christensen Jeffrey S · Wisconsin Rapids, WIBuilt 1975 · S/N 17265052N64159Flying 14 LLC · Spokane, WABuilt 1975 · S/N 17265053N6415APekkala John W · Palmer, AKS/N 33215N6415FDewitte Jon James · Bishop, GABuilt 1975 · S/N 18264192N6415RAlpine Aviation Of Fayetteville Inc · Prairie Grove, ARBuilt 1979 · S/N 172RG0179N6415SJohnson Edward A · Columbia, SCS/N 15067215N6415VPeter Prince Aviation Center LLC · Milton, FLS/N 172RG0677N6415XPogany Steve C · Chugiak, AKBuilt 1960 · S/N 18050915N64160Glide Slope LLC · East Hampton, NYBuilt 1975 · S/N 17265054N64161Aom Aircraft LLC · Orlando, FLBuilt 1975 · S/N 17265055N64162Mccormick Philip D · Mount Pleasant, IABuilt 1975 · S/N 17265056N64163Good Airplanes LLC · Oshkosh, WIBuilt 1975 · S/N 17265057N64165Weaver Lynwood J Jr · Raleigh, NCBuilt 1975 · S/N 17265059N64167Registered aircraftS/N 18052875N6416AJanak Jeffrey · Corpus Christi, TXBuilt 1956 · S/N 33216N6416GRolin Brian · Mc David, FLBuilt 1970 · S/N 15071916N6416KShreveport Aviation Services LLC · Shreveport, LAS/N 15077692N6416SCerny Mark V · Canyon City, ORBuilt 1967 · S/N 15067216N6416WGallien Anthony · Livermore, CABuilt 1981 · S/N P21000773N64173Training Planes LLC · Tampa, FLBuilt 1975 · S/N 17265065N64174Sen Air Inc · Mckeesport, PABuilt 1975 · S/N 17265066N6417ALevasseur Peter W · Plymouth, MEBuilt 1956 · S/N 33217N6417ESharpley David Jr · Pittsboro, INBuilt 1959 · S/N 46517N6417FAdkins Ian B · Dahlonega, GABuilt 1966 · S/N 15063017N6417JChapman Michael K · North Salt Lake, UTS/N 17273871N6417KVaro-Real Investments Inc · Visalia, CAS/N R1722044N6417NTaylor Michael Norman · Chino Hills, CABuilt 1978 · S/N 21062993N64180Spanaflight LLC · Puyallup, WABuilt 1975 · S/N 17265069
Back to AD 87-20-03 R2