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.

N6716SShelby Monroe Group LLC · Sioux City, IABuilt 1979 · S/N WA-71N6716TSchnack Marcus J · Crescent, IABuilt 1980 · S/N MC-716N6716VBay Richard G · Sparks, NVBuilt 1980 · S/N MC-717N6716ZNextgen Flight Academy Inc · Riverside, CABuilt 1980 · S/N ME-328N6717KFranco Enterprises LLC · Sioux City, IABuilt 1980 · S/N M-2266N6717VPierschbacher Clifton A · Marysville, WABuilt 1980 · S/N M-2265N6718RVernier Deborah J · Goshen, KYBuilt 1980 · S/N WA-76N6718TBhatia Anil · Round Rock, TXS/N M-2267N6718VHavelin Jeffrey I · Port Charlotte, FLBuilt 1980 · S/N M-2268N6718YN6718y Lk Aircraft Holdings LLC · Wheeling, ILBuilt 1980 · S/N M-2270N6718ZSchnatter Nathan William · Laurinburg, NCBuilt 1980 · S/N M-2271N6719BWakita Yuzo · San Jose, CABuilt 1981 · S/N MC-729N6719VDaniel Scott · Kingston, GABuilt 1980 · S/N WA-81N671BBe-A36 Inc Owner Trustee · Wilmington, DEBuilt 2001 · S/N E-3409N671SHEnochian Gary F · Santa Rosa, CABuilt 1966 · S/N D-8034N671TCBraunstein Robert S · Seattle, WABuilt 2001 · S/N EA-671N67201Sale Reported · Sunman, INSale reportedBuilt 1980 · S/N WA-111N6720H87ks LLC · Holyrood, KSBuilt 1980 · S/N MC-721N6720LDyer Shane E · San Francisco, CABuilt 1980 · S/N MC-724N6720TScandinavian Aviation Academy Inc · El Cajon, CABuilt 1980 · S/N ME-335N67217Pompano Hangars Inc · Lighthouse Point, FLBuilt 1980 · S/N WA-91N6721GDunbar Daniel D · Moneta, VABuilt 1980 · S/N MC-725N6721HMilos Tichy · Government Camp, ORBuilt 1980 · S/N MC-726N6721VNoll Brent M · Burbank, CABuilt 1980 · S/N WA-89N67224Vx Inc · Burbank, CABuilt 1983 · S/N EA-370N67230Boomerang Air LLC · Cedar Park, TXBuilt 1983 · S/N E-2093N6723CGolden Hour Aviation LLC · Charleston, SCBuilt 1982 · S/N M-2369N67249Derasmo Dominick · Manteo, NCBuilt 1983 · S/N CE-1022N6724TKaufman Melissa R · Franklin, TNBuilt 1984 · S/N E-2163N6724VFlying Bevo LLC · Newark, DEBuilt 1983 · S/N E-2095N67255Beau Air LLC · Edwards, COBuilt 1983 · S/N EA-374N6725CVick David L · Fort Jones, CABuilt 1983 · S/N EA-373N6725VAdvanced Thermal Systems Inc · West Memphis, ARBuilt 1983 · S/N E-2098N6726DDefini John · Mooresville, NCS/N E-2097N6727SKt Aero LLC · Charleston, WVBuilt 1983 · S/N E-2100N6727VUnited States Aviation Consultants LLC · Davie, FLS/N EA-378N6728FPeters Bruce L · Wichita, KSBuilt 1983 · S/N EA-379N6728RRegency Horizons Group LLC · Middletown, DEBuilt 1983 · S/N EA-380N6728VDriftwood Creek Flying Club LLC · Yankton, SDBuilt 1983 · S/N E-2103N6728YDashdale Aviation LLC · Fort Dodge, IABuilt 1980 · S/N D-10330N6728ZMccrorie LLC · Helena, MTBuilt 1980 · S/N EA-57N672BPlane Fun Inc Trustee · Snellville, GABuilt 1948 · S/N D-1673N672DWlad Joseph M Trustee · Alameda, CABuilt 1963 · S/N D-7204N6731RHaidlen Ford Inc · Oakdale, CABuilt 1980 · S/N D-10331N6731ZJerry Slough Aviation LLC · Bakersfield, CAFirst renewal noticeBuilt 1980 · S/N TJ-255N6732ZAir Pear LLC · Yakima, WAS/N E-1647N6733BWallace Scott D · Fairfield, CAS/N CE-919N6733MWilson Lawrence J · West Sacramento, CABuilt 1979 · S/N EA-37N6733YThormann Braulio Federico Cosme · Hollis Hills, NYBuilt 1980 · S/N CE-927N67343Gray Reece Allen · Buna, TXBuilt 1980 · S/N E-1649
Back to AD 99-05-13 R1 WD