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.

N9295TViking Custom Builders Inc · Anchorage, AKBuilt 1960 · S/N 50795N9296BColby Robert D · Bigfork, MTBuilt 1958 · S/N 55096N9296CDinstel Delbert F · Park City, MTBuilt 1955 · S/N 31395N9296GGreen Daniel C · Cedar Hill, TNBuilt 1971 · S/N 18260836N9296HSmith Richard A · Burnsville, MNBuilt 1975 · S/N 17266076N9296XJasuma Farms · Maxwell, CABuilt 1961 · S/N 18253696N9297TSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 50797N9297UNorthwest Wings LLC · Hillsboro, ORBuilt 1976 · S/N 15078247N9297XJohnson Durwood D · Beaumont, TXBuilt 1962 · S/N 18253697N9298AHenderson Larry V · Highland Village, TXBuilt 1949 · S/N 19059N9298GA&A Aviation LLC · Mountain Brk, ALS/N 18260838N9298ZFrederick Ag LLC · Humboldt, KSS/N 17701215N92995Yoanna Flight School Inc · Fort Myers, FLBuilt 1981 · S/N 15285372N929AEColman Steve · Alamosa, COBuilt 1959 · S/N 50457N929BMSuntops Aircraft Holding LLC · Lakeland, FLBuilt 1975 · S/N 17265826N929FRacoon Aviation LLC · San Antonio, TXBuilt 1953 · S/N 30188N929LSFlying Tigers Flight School Ltd · Houston, TXBuilt 1972 · S/N 17260660N929PMRegistered aircraftBuilt 1979 · S/N 18266844N929RHJohnson Merlin K Trustee · Mentone, CABuilt 1964 · S/N 206-0061N92ATBroquet Bruce L · Anchorage, AKBuilt 1981 · S/N 18053169N92BMNugent James S · Diamondville, WYS/N P21000557N92CRodriguez Michael C · Drums, PAS/N P3370128N92CCCanadian Co Sheriffs Office · El Reno, OKBuilt 1965 · S/N 17253144N92CKKingsborough James D · Carlisle, PABuilt 1978 · S/N P21000160N92CMN92cm LLC · Genola, UTS/N 18260420N92CPSlattery Richard E · Fountain Valley, CABuilt 1953 · S/N 30019N92DCAdams Bob L · Eagle River, AKBuilt 1975 · S/N 18502828N92DSBooty Bill · Idaho Falls, IDBuilt 1975 · S/N 21060847N92DWBurnette Jeffrey T · Big Lake, AKBuilt 1958 · S/N 55046N92FRGliem Robert E Jr · Eddystone, PABuilt 1979 · S/N 17273140N92GDStefenelli Aviation N-Tr Inc Trustee · AtterseeFirst renewal noticeBuilt 1979 · S/N P3370343N92MMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 17266052N92MSCil N92ms LLC · Mcallen, TXS/N P21000689N92NAOneill Laurie A · Pinckney, MIS/N 207-00093N92RHCrabtree Nathan J · Boise City, OKBuilt 1967 · S/N P206-0431N92RZSale Reported · Gold Canyon, AZSale reportedBuilt 1979 · S/N R18201313N92SCMorrison Neil E · Port Townsend, WABuilt 1967 · S/N R172-0211N92WMGerhardt David C · Denver, COBuilt 1979 · S/N 18503859N93002Lcc North LLC · Freehold, NJBuilt 1981 · S/N 15285374N9300BBenson Ryan Denson · New Carlisle, OHS/N 55100N9300NChristensen Hans · Enterprise, UTBuilt 1981 · S/N 18504328N9300XEdwards Karen Marie · Mcminnville, ORS/N 18253700N93010Davis Russell C · Odessa, TXBuilt 1976 · S/N 18503158N93018Joy Austin J Jr · Anchorage, AKBuilt 1976 · S/N 18503161N9301BGimli Son LLC · Fort Lauderdale, FLBuilt 1980 · S/N 172RG0786N9301ERyan Aircraft Holding LLC · Orlando, FLBuilt 1979 · S/N 17272216N9301XShaunkoe LLC · Merrill, ORBuilt 1961 · S/N 18253701N93020Red Leasing LLC · Juneau, AKS/N 20700385N93022Red Leasing LLC · Juneau, AKBuilt 1979 · S/N U20605463N93023Ward Air Inc · Juneau, AKBuilt 1976 · S/N U20603526
Back to AD 87-20-03 R2