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.

N3840YBurrill Resources Inc · Medford, ORBuilt 1981 · S/N EA-201N3841TN3841t Lk Aircraft Holdings LLC · Wheeling, ILBuilt 1981 · S/N M-2307N3842UBezet Danny · Comfort, TXBuilt 1981 · S/N E-1824N3842YCole Scott A · Rockford, MIBuilt 1981 · S/N EA-204N3843BBrown Consulting Inc · Bessemer, ALBuilt 1955 · S/N D-4113N3843SSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N TK-139N3844GLandvalue Management LLC · Fresno, CABuilt 1981 · S/N E-1826N3845LDonq LLC · Hartford, CTBuilt 1981 · S/N TC-2378N38462Krystofiak Steven · Scottsdale, AZBuilt 1981 · S/N WA-244N3846UKrystofiak Steven · Scottsdale, AZS/N WA-242N3847BBrine William R · Pahrump, NVS/N D-4117N3847XCrowder Jonathan Slade · Columbus, INS/N D-10368N3848BBrown Ronald D · Auburn, WABuilt 1955 · S/N D4118N3848NNicholson Philip G · Wichita Falls, TXBuilt 1997 · S/N E3098N3848YBaron Lake LLC · Jefferson, LABuilt 1981 · S/N TJ-349N3849XBreland Quin H · Columbia, MSBuilt 1981 · S/N E-1829N38507Dwm Holdings Of Texas Inc · Hot Springs, ARBuilt 1981 · S/N E-1831N3851LFreedom Aviation Of Ne Florida LLC · Jacksonville, FLBuilt 1981 · S/N E-1832N3851ZPurcell Jmes Patrick III · Bayville, NJBuilt 1981 · S/N WA-241N3853BNoble Jeffrey C · Henderson, TXBuilt 1955 · S/N D-4148N3853JMitchell James R · Anthem, AZBuilt 1981 · S/N E-1837N3853LZ-Tech Research LLC · Greenville, TXBuilt 1981 · S/N E-1844N3854GDry Creek Aviation LLC · Belmont, CABuilt 1981 · S/N EA-213N38566Flight Time LLC · Snohomish, WABuilt 1981 · S/N MC-755N3856BGold Terry C · Folsom, CAS/N D-4122N38570Dm Asset Management LLC · Plain City, OHBuilt 1981 · S/N TC-2381N3857BChristensen Marshall J · Canton, SDBuilt 1955 · S/N D-4124N3857DGill Michael T · Little Rock, ARS/N WA-248N3858BDodson International Parts Inc · Rantoul, KSBuilt 1955 · S/N D-4125N385BRust Jeffrey J · San Antonio, TXBuilt 1960 · S/N D-6477N3860BFlight Club LLC · Middle River, MDS/N WA-273N3860VAts LLC · Memphis, TNBuilt 1981 · S/N TC-2382N3861BNorrix James · Elk River, MNBuilt 1955 · S/N D-4128N3862BTroxel Larry K · Palmdale, CABuilt 1955 · S/N D-4129N3862RToco Inc · Healdsburg, CABuilt 1981 · S/N EA-217N38644Harper Benjamin F III · Greensboro, ALS/N WA-275N3864CPearce Robert W · Santa Fe, NMBuilt 1981 · S/N E-1846N3864NScherffius Steven H · Louisville, KYBuilt 1981 · S/N M-2311N3864UInterrail Power Inc · Jacksonville, FLBuilt 1981 · S/N TJ-355N3864YDunshee Jon · Land O Lakes, FLBuilt 1981 · S/N MC-756N38650Sciorrotta Samuel C Jr · Gainesville, GABuilt 1981 · S/N E-1845N3867BColeman Aircraft LLC · Molalla, ORBuilt 1955 · S/N D-4173N3868JParker Fred E · Portola, CABuilt 1981 · S/N WA-258N3868KBeaver Mark · Valparaiso, INBuilt 1981 · S/N WA-259N3868URegistered aircraftBuilt 1981 · S/N D-10372N3868YTalewinds LLC · Litchfield Park, AZBuilt 1981 · S/N E-1852N3869BHackbart Gary H · Las Vegas, NVBuilt 1955 · S/N D-4102N3869SPeterson Kurtley D · Gunnison, UTBuilt 1981 · S/N EA-223N3869YMak Air Ventures LLC · Smithfield, NCBuilt 1981 · S/N TC-2388N386VHGrowthland Ag Realty Inc · Humboldt, IABuilt 1972 · S/N CE-386
Back to AD 99-05-13 R1 WD