OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

N8272TWayne Clinton · Greenfield, INBuilt 1967 · S/N D-8473N8274DLim William Taek · Rancho Cucamonga, CABuilt 1957 · S/N D-5364N8275ASigillito Michael A · Vero Beach, FLBuilt 1993 · S/N E-2803N8277DValiair Lc Trustee · Casper, WYS/N E-2798N8278ZSaenger Lawrence · Mountain Home, IDBuilt 1964 · S/N TD554N8279DBullard Thomas Eugene · Midlothian, TXBuilt 1957 · S/N D-5392N827LWarfield Gerald A · Saltillo, MSBuilt 1960 · S/N D-6519N827RRatliff Aviation Inc · Sevierville, TNBuilt 1959 · S/N D-6082N827VMoore Plane Fun LLC · Toledo, OHS/N E907N827VU827vu LLC · Au Gres, MIS/N TC-2104N827WCustom Air Inc · Roe, ARBuilt 1968 · S/N D-8743N8282DHenry Craig A · East Troy, WIS/N D-5400N8283WSwampair LLC · Hillsboro, ORBuilt 1993 · S/N CE-1739N8284FRullman Laurie J Trustee · Reno, NVBuilt 1993 · S/N CE-1747N8285CBonanza Enterprise LLC · Tucson, AZBuilt 1993 · S/N E-2810N8285LGilbran Properties LLC · Oklahoma City, OKBuilt 1993 · S/N CE-1745N8285MCohen Aviation LLC · Rolla, MOBuilt 1993 · S/N E-2815N8286FDaedalus Advisory LLC · Seattle, WAS/N CE-1767N8287DWhite Steven · Oxnard, CABuilt 1957 · S/N D-5371N828DSOhlsson Kenneth S Trustee · Sedona, AZBuilt 1976 · S/N E-847N828JGGunderson Marvin · Greenwood Village, COBuilt 1955 · S/N D-4121N828KASvehla Gustav Jr · Flower Mound, TXBuilt 1990 · S/N CE-1512N828MJa Flight Services LLC · Sugar Grove, ILBuilt 1980 · S/N TC-2299N828PLGrosso Michael F · Charleston, SCS/N TD-549N828RDebs Raymond E · Boise, IDBuilt 1959 · S/N D-6071N828SBEa Aircraft Lease LLC · Dayton, MNS/N EA-111N828TFryar Arliss E · Pollock, LABuilt 1976 · S/N E-941N828VJames David O · Overland Park, KSBuilt 1976 · S/N E-883N828WTLaymon Air LLC · Redlands, CAS/N E-3581N82903Nms Air Services LLC · Chelmsford, MABuilt 1993 · S/N CE-1740N8290EWb Aviation LLC · Belmont, MIBuilt 1993 · S/N E-2805N8293DVeum Todd E · Sault Sainte Marie, MIBuilt 1957 · S/N D-5382N8293MMaffett Properties LLC · Dublin, GABuilt 1993 · S/N E-2794N8295DHorning Martin R · Lincoln, CAS/N D-5379N8295YBonanza Flyers LLC · Clovis, CAS/N E-2825N82964Big Bend Community College · Moses Lake, WABuilt 1993 · S/N CE-1761N82966Big Bend Community College · Moses Lake, WABuilt 1993 · S/N CE-1757N8296LRoth Vicki B · Bristow, OKBuilt 1993 · S/N E-2833N8296RPowell Franklin Travis · Lone Pine, CABuilt 1992 · S/N E-2763N8296UFritzinger Mark Thomas · Goldsboro, NCBuilt 1993 · S/N E-2828N8297ABonanza A36 LLC · Cedar Rapids, IABuilt 1992 · S/N E-2764N8297DDunlap Martin L · Hartville, OHS/N D-5383N8298HC & L Leasing LLC · Cody, WYBuilt 1993 · S/N CE-1741N8299DB K A Air LLC · Kennett, MOS/N E-2812N8299GHoughtaling Richard P · Harwich, MABuilt 1993 · S/N CE-1749N8299WKj 422 LLC · Augusta, GABuilt 1993 · S/N E-2809N8299ZCoachair Inc · Groveland, CABuilt 1993 · S/N EA-545N829GWin Win Aviation Inc · Wake Forest, NCBuilt 1967 · S/N TE-379N829RBGlover William Scott · Mount Pleasant, TXBuilt 1980 · S/N TC-2305N82BVetted Air LLC · Saint Petersburg, FLBuilt 1991 · S/N E-2663
Back to AD 99-05-13 R1 WD