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.

N4021JSharapan Ilya · Brooklyn, NYBuilt 1966 · S/N 15065321N4021VBeishline Daniel · Bath, MES/N 18340N4022YKelley Kitty K · Albion, IDBuilt 1961 · S/N 185-0222N4023JHector Flyers LLC · Hector, MNBuilt 1966 · S/N 15065323N4024AEling Stefan · Savannah, GAS/N 7821N4024YJr Aviation LLC · Temple, TXS/N 1850224N4025FBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1958 · S/N 36925N4025URichardson Richard A · Fort Worth, TXBuilt 1965 · S/N 15061425N4026VLandry Timothy G · Lodi, CABuilt 1948 · S/N 18345N4026YOlsen Scott M · Forest Lake, MNBuilt 1961 · S/N 185-0226N4027JMcburney James H Jr · Horseshoe Bay, TXBuilt 1967 · S/N 15065327N4027UTsukii Toshikazu · Tucson, AZBuilt 1965 · S/N 15061427N4028DDriebergen John A · Meridian, IDS/N 34728N4028JWarn James D Jr · Overland Park, KSBuilt 1966 · S/N 15065328N4028UCesperalle Aviation LLC · Grassy Butte, NDS/N 15061428N4029FMcelhaney Jung R · Phelan, CABuilt 1958 · S/N 36929N4029UPathfinder Aero Services LLC · Sheridan, WYS/N 15061429N402FUSarment David · Ann Arbor, MIBuilt 1973 · S/N 18261534N402MPBravan Aviation Inc · Fort Lauderdale, FLS/N U20606896N4030DPaulson Glenn D · Oro Valley, AZBuilt 1957 · S/N 34730N4031DSurette Phillip · Vail, COBuilt 1957 · S/N 34731N4031YPemberton Addison J · Spokane, WABuilt 1961 · S/N 1850231N4032DPentecost Benjamin · Puyallup, WABuilt 1957 · S/N 34732N4032FDmnm LLC · Albuquerque, NMBuilt 1958 · S/N 36932N4032ULiberty University Inc · Lynchburg, VABuilt 1965 · S/N 15061432N4032VHart Travis R · Ontario, ORBuilt 1948 · S/N 18351N4033DJacquin Aviation Inc · Markham, ILBuilt 1957 · S/N 34733N4033VJepsen James Scott · Kirkwood, MOBuilt 1948 · S/N 18380N4034JStange Robert C · Toledo, OHBuilt 1966 · S/N 15065334N4035DWylie Joshua H · Landgrove, VTBuilt 1957 · S/N 34735N4035FGinn Ray Jr · Beeville, TXBuilt 1958 · S/N 36935N4035JBloomquist Steven R · Granbury, TXS/N 15065335N4035VBeckner Russell R · Rutland, MAS/N 18382N4036DWilson Kevin B P · La Mesa, CABuilt 1957 · S/N 34736N4037FSicaras Paul G · Longmont, COBuilt 1958 · S/N 36937N4037UDelgado Brandon · Moreno Valley, CABuilt 1965 · S/N 15061437N4037YVfr Ltd · Wilmington, DES/N 1850237N4038DSkydive Snohomish Inc · Snohomish, WAS/N 34738N4038FKcantarano LLC · Mukilteo, WABuilt 1958 · S/N 36938N4038VStirling Nathan L · Alton, MEBuilt 1975 · S/N 15076682N4039DKruger Daniel G · Stateline, NVBuilt 1957 · S/N 34739N4039FBlue Ice Aviation Inc · Wasilla, AKS/N 36939N4039UHendrickson Flying Service Inc · Rochelle, ILBuilt 1965 · S/N 15061439N4039VHowe Shawn E · Lewistown, PABuilt 1948 · S/N 18358N403ABItalio River Adventures LLC · Yakutat, AKBuilt 1966 · S/N 18257439N403BSRogness Joshua D · Wasilla, AKS/N 18503527N403GMBalisky Micah · Fort Shaw, MTBuilt 1972 · S/N 18260967N403PKN403pk LLC · Ada, MIBuilt 1977 · S/N 18265475N403SWheeler James · Shreveport, LABuilt 1980 · S/N P21000403N4041UCumberland Soaring Group Inc · Wiley Ford, WVBuilt 1965 · S/N 15061441
Back to AD 87-20-03 R2