OpenAirDocs.org
AD 87-21-02 R1

Registered aircraft · 3,961

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-21-02-R1')
    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-21-02-R1')
  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.

N87293Dinaland Aviation · Vernal, UTS/N 310R0505N87316Wilson David L · Huntington, NYBuilt 1975 · S/N 310R0512N87332Odell Ronald W · Peachtree City, GABuilt 1976 · S/N 310R0516N87341N87341 LLC · Milford, MIBuilt 1975 · S/N 310R0520N87356Kovacs Endre · Plant City, FLBuilt 1975 · S/N 310R0527N87357Qualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 310R0528N87358Braswell Eugene E III · Louisburg, NCBuilt 1975 · S/N 310R0529N87363Janeair LLC · Acworth, GABuilt 1975 · S/N 310R0530N87386Golden Eagle Flyers Inc · Cheyenne, WYS/N 421C0168N87389Missouri River Holdings LLC · Fairview, MTS/N 310R0541N87393310 Amigos LLC · Stuart, FLS/N 310R0542N87397Smith Aviation LLC · Springer, OKBuilt 1975 · S/N 310R0545N87403Twin Oaks Aviation LLC · Oshkosh, WIBuilt 1975 · S/N 310R0547N87412Rmb Leasing Inc · Dover, DEBuilt 1975 · S/N 310R0552N87429Leite Glen · King George, VABuilt 1975 · S/N 310R0557N87443Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N 310R0562N87454Burton Donald O · Mooresville, NCBuilt 1975 · S/N 310R0568N87461Cya Aviation LLC · Gainesville, FLBuilt 1975 · S/N 310R0573N87464Wells Legacy Consultants LLC · Hickory Creek, TXBuilt 1975 · S/N 310R0576N87481Petersen Donald W · Bullhead City, AZBuilt 1976 · S/N 310R0587N87490Starkey Tommy · Pocatello, IDS/N 310R0591N87536Krull Jesse L · Bismarck, NDBuilt 1981 · S/N 340A1254N87541Chadbourne Daniel I Jr · Anchorage, AKS/N 421C0007N87561Forest Aire LLC · Flagstaff, AZBuilt 1975 · S/N 421C0017N877JBOg Flights LLC · Dover, DEBuilt 1980 · S/N 421C0877N877SCGv Air Inc · Medford, ORS/N 310R0940N8789BBearcat Aviation LLC · Joplin, MOBuilt 1980 · S/N 414A0605N878DMFly North 421 LLC · Helena, MTBuilt 1977 · S/N 421C-0413N878SPC-140 Co LLC · Milton, FLBuilt 1974 · S/N 421B0634N8792KTornado Venture Once LLC · San Antonio, TXBuilt 1980 · S/N 340A0985N87CGPro Aire Cargo & Consulting Co Inc · Oshkosh, WIBuilt 1975 · S/N 402B0883N87GKAlpha Zulu Aviation LLC · Spring, TXS/N 421C0131N87MKWind River Aviation LLC · Lawton, OKBuilt 1974 · S/N 421B0808N87PPAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N 421C0206N87RJNorris Aviation LLC · Mansfield, TXBuilt 1976 · S/N 310R0676N8801GAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1980 · S/N 340A0986N880AMj Aviation LLC · Denham Springs, LABuilt 1973 · S/N 414-0397N880JSDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 421C-0489N881PJJohnson Patrick Allen · Olive Branch, MSBuilt 1973 · S/N 310Q0754N881RMMadden Robert B · Eagleville, PABuilt 1966 · S/N 310K0114N881TJBarron Eddie T · Amarillo, TXBuilt 1972 · S/N 414-0259N8825GRichardson Dean A · St Thomas, VIFirst renewal noticeBuilt 1981 · S/N 404-0628N882BCTechnology Aviation Services LLC · Covington, GABuilt 1973 · S/N 414-0470N882GLProctor Brian S · Leesburg, TXBuilt 1963 · S/N 320B0026N884LPBecton Aviation LLC · Lubbock, TXS/N 421C0102N8851KJac Leasing LLC · Fort Myers, FLBuilt 1979 · S/N 414A0239N88521Godfrey Pharis · Missouri City, TXBuilt 1981 · S/N 340A1260N88537Gink2 LLC · Elkhorn, NEBuilt 1978 · S/N 421C0514N8853K8853k LLC · New Bedford, MABuilt 1979 · S/N 414A0240N88549Seed Richard J IV · Holmes Beach, FLBuilt 1981 · S/N 340A1261
Back to AD 87-21-02 R1