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.

N6734CClifford Eric S · Paris, TXS/N GM-141N6734UR E Bentz Inc · Monroe, LAS/N TK-117N67353Registered aircraftBuilt 1983 · S/N E-2105N6735PTarvin Darrel D · Huntsville, TXBuilt 1983 · S/N E-2104N6735ZGta Air Inc · Addison, TXBuilt 1979 · S/N E-1605N6736GKough Bryan · Scott City, KSBuilt 1980 · S/N E-1648N6736NSalter Aviation LLC · Bowdon, GABuilt 1980 · S/N E-1695N6736SA36 Aviation LLC · Boise, IDBuilt 1982 · S/N E-1987N6736TBrakke Thomas · Clear Lake, IABuilt 1981 · S/N EA-242N6736VSharkey Lowell G · Manitou, KYBuilt 1979 · S/N E-1569N6737DMarlin Air LLC · Dallas, TXBuilt 1980 · S/N E-1651N6737VRiverview Ranches · Chowchilla, CAS/N EA-63N6739CPearce William · Grants Pass, ORBuilt 1980 · S/N TJ-262N6739TJoca Holdings LLC · Kittrell, NCBuilt 1980 · S/N E-1652N6739UKahler Automation Corp · Fairmont, MNBuilt 1979 · S/N E-1591N6739WSweigard Daniel J · Euless, TXBuilt 1980 · S/N CE-899N673CVNewton Donald O Jr · Gretna, NEBuilt 1977 · S/N CE-738N673DHagglund Carl D · Pendleton, ORS/N D-2948N673TBalchunas Anthony B · Robinson, TXBuilt 1967 · S/N D-8470N67414Staley Clifford D · Delray Beach, FLBuilt 1980 · S/N E-1661N6741MCooper Aviation LLC · Georgetown, SCBuilt 1980 · S/N TK-122N6741WDempsey Justin · Hazlet, NJBuilt 1980 · S/N E-1660N6742LCrook Keigm L · Livingston, TXBuilt 1983 · S/N EA-385N6742PPrice Paul · Lancaster, VABuilt 1980 · S/N E-1709N6742SPowers Benjamin · Circleville, OHBuilt 1979 · S/N E-1635N6743CRocket Ems Inc · Santa Clara, CABuilt 1980 · S/N TJ-269N6745CTan Industries LLC · Wilmington, DEBuilt 1983 · S/N E-2109N6745TSeaman David S · Sunset Beach, NCFirst renewal noticeBuilt 1980 · S/N CE-902N6745YSeamech International Inc · Houston, TXBuilt 1984 · S/N EA-401N6746BMoran Ted B · Spokane, WABuilt 1980 · S/N D-10344N6746FQuality Motors Inc · Samson, ALBuilt 1983 · S/N CE-1024N6746TFlying Wolf LLC · Lomita, CABuilt 1980 · S/N E-1674N6746WEngine House.Com LLC · Corvallis, MTBuilt 1980 · S/N EA-73N6747JQualitair LLC Trustee · MichelstadtS/N E2130N6747VGap Mountain Development LLC · Jaffrey, NHBuilt 1980 · S/N TC-2316N6747YZ2b Aviation LLC · San Antonio, TXS/N E-1676N6747ZMclouth Fred E · Elkhorn, NEBuilt 1980 · S/N D-10346N6748CSan Andres Farms · Raymondville, TXBuilt 1980 · S/N EA-76N6748PSpears Derek · Los Angeles, CABuilt 1984 · S/N E-2131N6748VCannon Oil & Gas Well Services Inc · Rock Springs, WYBuilt 1980 · S/N TK-120N6748YGalvin Richard · Laytonsville, MDBuilt 1980 · S/N TC-2317N6749GLesh Air LLC · Denver, COBuilt 1980 · S/N E-1679N6749LGtf Aviation LLC · Fryeburg, MEBuilt 1980 · S/N E-1678N6749VUsg Assets Inc · Clarkesville, GABuilt 1980 · S/N E-1681N674BAtkins Mitchell · Jackson, MIBuilt 1948 · S/N D-1675N674CBMollica Richard A · Oxnard, CABuilt 1979 · S/N WA-8N674DSale Reported · Fountain, COSale reportedBuilt 1951 · S/N D-2946N674DMBravo Aviators LLC · Argyle, IABuilt 1974 · S/N CE-495N674TTumbling Mirth Mt LLC · Cody, WYBuilt 1969 · S/N D-9007N67526Fulton Louis · Boscobel, WIBuilt 1980 · S/N MC-730
Back to AD 99-05-13 R1 WD