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.

N9987NUnited States Department Of Interior · Boise, IDBuilt 1982 · S/N 18504379N9987VKaplan Steven M · North Monmouth, MES/N 172-64605N99881Civil Air Patrol · Maxwell Afb, ALS/N 17276523N99885Az2025 LLC · Miami, FLS/N 17276524N9988NBackcountry Air LLC · Wilmington, DES/N 18052643N9988VLenoir Aviation Club Inc · Lenoir, NCFirst renewal noticeBuilt 1974 · S/N 17264606N9988XBenavides Antonio · Anchorage, AKBuilt 1961 · S/N 1850188N9989AHatcher Bradley M · Jackson, GABuilt 1950 · S/N 19424N9989ET Craft Aero Club Inc · Nampa, IDBuilt 1975 · S/N 18264049N9989TGreat Basin Aviation LLC · Eagle River, AKBuilt 1961 · S/N 18253089N9989VPace Dusty · Pendleton, ORBuilt 1974 · S/N 17264607N998MSteamboat Springs Flying Club Inc · Steamboat Springs, COBuilt 1977 · S/N R1722333N998RASchubert Brothers Aviation Inc · Canandaigua, NYBuilt 1973 · S/N 17261672N998SEUtter Albert · Fort Myers, FLBuilt 1988 · S/N 17274025N9990BAurora-Flight LLC · Commerce Township, MIBuilt 1982 · S/N 172RG1109N9990EN9990e LLC · Alva, FLBuilt 1975 · S/N 18264050N9990VCompass Aviation Inc · Shelby, NCBuilt 1974 · S/N 17264608N99917Anderson Cody Jon · Orono, MEBuilt 1986 · S/N 17276527N9991ASaunders James E · La Vista, NEBuilt 1950 · S/N 19426N9991BTaft Leasing LLC · Bloomfield, NMBuilt 1982 · S/N 172RG1110N9991EWings Flight Enterprises Inc · Danville, KYS/N 17272308N9991GSale Reported · Staten Island, NYSale reported, canceledBuilt 1979 · S/N 17273639N9991NTin Cup Aviation LLC · Frostproof, FLBuilt 1975 · S/N 18052646N9991TChupp Family Trust LLC · Kalispell, MTS/N 18253091N9991VSafeway Flying Club Inc · Denmark, WIBuilt 1975 · S/N 17264609N9991YArwlb Aviation LLC · Spokane, WABuilt 1982 · S/N 210-64661N9992BAirco International LLC · Arlington, WABuilt 1957 · S/N 34392N9992EWoods Charles D · Huffman, TXBuilt 1975 · S/N 18264052N9992GDaneker Adin · Kalispell, MTBuilt 1974 · S/N 18263451N9992NHanson Lavon T · Saint Ignatius, MTS/N U20603749N9992VShipe Jacqueline M · Louisville, TNBuilt 1974 · S/N 17264610N9992ZAdvanced Placement Aviation LLC · Eagle River, AKBuilt 1984 · S/N U20606800N9993BTurinsky Anthony · Anchorage, AKS/N 34393N9993ECruise Flight Academy Inc · Dalton, GABuilt 1979 · S/N 17272309N9993THusbands Jason · Belen, NMBuilt 1960 · S/N 18253093N99948Florida State College At Jacksonville · Jacksonville, FLS/N 172-76483N9994EBeard Michael W · Eveleth, MNBuilt 1975 · S/N 18264054N9994HCasey James D · Burlington, MABuilt 1982 · S/N 18268169N9994NBoynton Scott · Campbell Hall, NYS/N 18052649N9994VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264612N9995BAlbatross Air Inc · Mccall, IDS/N 34395N9995EWilliams Dean W · Punta Gorda, FLBuilt 1975 · S/N 18264055N9995NIrvine Hollis E Jr · Greenwich, NJBuilt 1975 · S/N 18052650N9996EMeier Sally A · Lac Du Flambeau, WIBuilt 1975 · S/N 18264056N9996HStrong Jennifer E Trustee · Lakeport, CABuilt 1982 · S/N 18268171N9996JDiamond X LLC · Elko, NVBuilt 1982 · S/N T18803925TN9996MYr-Aircraft Leasing LLC · Bethel, AKBuilt 1984 · S/N 20700779N9996NMorrison Otto M · Harrisburg, ARFirst renewal noticeS/N 18052651N9997EAir Data Solutions LLC · Natchitoches, LABuilt 1975 · S/N 18264057N9997FUsda Forest Service Fepp · Columbia, SCBuilt 1967 · S/N R1720247
Back to AD 87-20-03 R2