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.

N8357MPrinceton Soaring Assoc · Princeton, NJBuilt 1976 · S/N 18264594N8358JMorrow John E · Clarendon, TXBuilt 1967 · S/N 15066258N8358LOc Flight Lessons LLC · Costa Mesa, CABuilt 1968 · S/N 17256558N8358SStewart Bryan P · Carson City, NVBuilt 1965 · S/N 18256458N8358TTbs Aviation LLC · Wilmington, DEBuilt 1961 · S/N 17557058N8358UN8358u LLC · Knoxville, IABuilt 1964 · S/N 17252258N8359AWoosley Kenneth D · Rumsey, KYBuilt 1952 · S/N 25211N8359JManchester Eric S · Milton, VTBuilt 1967 · S/N 15066259N8359LBay Lux Ventures LLC · Tampa, FLS/N 17256559N8359TCornejo Bernard J · Elko, NVS/N 17557059N8359UMusgrove Stacy J · Cunningham, TXS/N 17252259N835MDMacconnell John · Deland, FLBuilt 1963 · S/N 18254759N835TAHuber Gary · Bradenton, FLBuilt 1976 · S/N 18265019N8360MOld Goat Aviation LLC · Naples, FLBuilt 1969 · S/N A1500060N8360QU S Department Of The Interior · Boise, IDBuilt 1978 · S/N 18503666N8360UHead Joseph · Fairbanks, AKS/N 15077927N8360XJk Sparks Inc · Lutz, FLBuilt 1961 · S/N 17248860N8361ABenton Paul N · Manhattan, KSBuilt 1952 · S/N 25213N8361BBrim Robert H · Bellingham, WABuilt 1957 · S/N 36161N8361JCoughlin Kevin P · Ridge, NYBuilt 1967 · S/N 15066261N8361LMolid Robert J · Dubuque, IABuilt 1968 · S/N 17256561N8361UBoss Gary W · Bronston, KYS/N 17252261N8361ZVining Eric · Lowell, ARS/N 205-0361N8362BDelp Ryan K · Southbury, CTS/N 36162N8362UJohnson Scott T · Delta, UTS/N 17252262N8362XMarlow Haley C · Carrollton, MSS/N 17248862N8362ZCampbell Tyler A · Billings, MTBuilt 1963 · S/N 205-0362N8363MWeatherford Ranches Support Services LLC · Arlington, ORBuilt 1976 · S/N 18264596N8363SHellie Andrew Bryant · College Place, WAS/N 18256463N8363URagsdale Gregory · Peoria, AZS/N 17252263N8363XKrause Alex E · Oklahoma City, OKS/N 17248863N8364BDigiacomo Ernest R · Hampton Bays, NYBuilt 1957 · S/N 36164N8364MComchoc Paul R · Bellevue, WABuilt 1969 · S/N A15000064N8364TPrice Michael A · Carson City, NVBuilt 1961 · S/N 17557064N8364UElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1964 · S/N 17252264N8365AHauptman George J · Halfway, ORBuilt 1952 · S/N 25217N8365BHallada David M · Lakeview, MIBuilt 1957 · S/N 36165N8365GMendez Carlos L · Somerset, NJBuilt 1965 · S/N 15062465N8365LHarbour Aviation LLC · Weatherford, TXBuilt 1968 · S/N 17256565N8365UHunt Ellwood M · Texarkana, TXBuilt 1964 · S/N 17252265N8366ACyr Gregory A · Augusta, MES/N 25218N8366GRovers Adrian J · Chazy, NYBuilt 1965 · S/N 15062466N8366JRobertson R Topp · Decatur, TXBuilt 1967 · S/N 15066266N8366LCurwin Randy S · Villa Rica, GABuilt 1968 · S/N 17256566N8366MMccauley Aviation Inc · Springfield, TNBuilt 1969 · S/N A15000066N8366QBesse Richard L · Wasilla, AKFirst renewal noticeBuilt 1976 · S/N U20603227N8366TPoint Garrett Robert · Wilmington, NCBuilt 1961 · S/N 17557066N8366UHob Aero Inc · Freeland, MIBuilt 1964 · S/N 17252266N8366XAjm Aviation Ventures LLC · Seal Beach, CABuilt 1961 · S/N 17248866N8367AAnderson Arthur L · Fitzgerald, GABuilt 1952 · S/N 25219
Back to AD 87-20-03 R2