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.

N9452MSoares De Matos Guilherme Cesar · Fort Lauderdale, FLBuilt 1970 · S/N 21059352N9452NAlaska Department Of Public Safety · Anchorage, AKBuilt 1981 · S/N 18504359N9452UCurtis Marilyn D · Woodland, CABuilt 1976 · S/N 15078400N94531Cire Aviation LLC · Lutz, FLBuilt 1978 · S/N 18266431N94532Oklahoma State University · Stillwater, OKFirst renewal noticeBuilt 1983 · S/N 15285707N94536Freese Marc A · Fulda, MNBuilt 1978 · S/N 18266434N94537Joyner Russell L · Aulander, NCBuilt 1978 · S/N 18266435N94538Curran James · Santa Ana, CABuilt 1978 · S/N 18266436N94539Woodward William R · Portland, ORBuilt 1978 · S/N 18266437N9453BCain James W · Big Rapids, MIBuilt 1958 · S/N 55253N9453CEarth Center Adventure Inc · Haines, AKBuilt 1955 · S/N 31851N9453THansen Jerry E · San Antonio, TXBuilt 1960 · S/N 57253N9453XFlying Machines LLC · Danville, CABuilt 1985 · S/N 18268530N94544Dawson Farms · Tappen, NDBuilt 1978 · S/N 18266439N94549Scott Nathan A · Lake Winnebago, MOBuilt 1978 · S/N 18266443N9454XRoland Aviation LLC · Saint Matthews, SCBuilt 1985 · S/N 18268531N94553Delta State University · Cleveland, MSBuilt 1983 · S/N 15285718N9455UUniform Aircraft Holdings LLC · Ransom, ILS/N 15078403N9455XRather Be Airborne LLC · Chaska, MNBuilt 1985 · S/N 18268532N94569Chester Charter Inc · Chester, CTBuilt 1983 · S/N 15285731N9456CCoaker Martin · Ada, MIBuilt 1955 · S/N 31854N9456DMajka Marc · San Carlos, CABuilt 1984 · S/N 172RG1171N9456XMoxie Holdings LLC · Midvale, UTBuilt 1985 · S/N 18268533N94570Richmor Aviation Inc · Hudson, NYBuilt 1983 · S/N 15285732N94573Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1983 · S/N 15285735N94577Ace Aircraft Leasing Inc · Nazareth, PABuilt 1983 · S/N 15285736N9457DN1705r Inc · Cobb, CAS/N 172RG1172N9457UClemens Jerry W · Parsons, KSBuilt 1976 · S/N 15078405N9457XRoss Karen F · Marion, TXBuilt 1961 · S/N 21057757N94584Sale Reported · West Lafayette, INSale reportedBuilt 1983 · S/N 15285738N94585Aviation Trade Inc · Castroville, TXBuilt 1983 · S/N 15285739N94587Kenny Douglas B · Auburn, NHBuilt 1978 · S/N 18266448N94588Burt Lisa C · Justin, TXS/N 18266449N94589Haverlock Aircraft LLC · Willoughby, OHBuilt 1983 · S/N 15285740N9458TWasp Air LLC · Hamilton, MTBuilt 1960 · S/N 57258N9458XAnderson William B · Rogers, ARBuilt 1961 · S/N 21057758N94592Oklahoma State University · Stillwater, OKBuilt 1978 · S/N 18266452N94596Koulbou Moussa A · Chandler, AZBuilt 1978 · S/N 18266455N94598Klein Thomas Alan · North Pole, AKBuilt 1978 · S/N 18266457N94599Ams Aviation LLC · South Bend, INBuilt 1978 · S/N 18266458N9459BMiller Jason · Clifton, NJS/N 55259N9459MCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1978 · S/N U20604547N945ASA2g International LLC · San Juan Capo, CABuilt 1978 · S/N 33701844N945FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1980 · S/N R18201484N945KMSkypros East Kansas City · Grain Valley, MOBuilt 1977 · S/N 15280816N945RCR&C Aviation Partners LLC · Tucson, AZBuilt 1978 · S/N P21000084N945SMFive Rivers Flight Training LLC · Livermore, CABuilt 1981 · S/N 17274742N945TC R Transport Inc · Wilmington, DES/N 17265082N94608Hansen David A · Milton Freewater, ORBuilt 1978 · S/N 18266459N94609Heavy Metal Air LLC · Farmingdale, NYBuilt 1983 · S/N 15285742
Back to AD 87-20-03 R2