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.

N4517DPlane Fun Inc Tr Trustee · Snellville, GAS/N D-4650N4519DHammons Gordon D · Wilson, WIBuilt 1956 · S/N D-4681N4519SBlanck Greg J · Redwood City, CABuilt 1975 · S/N E-719N451BVan Velden Chris W · Yucaipa, CABuilt 1948 · S/N D-1776N451MJRoost Leasing LLC · Sturgis, MIBuilt 1985 · S/N E-2246N451STrevathan Max Tyler · Dyersburg, TNBuilt 1977 · S/N E1200N4522DGuy Timothy S · Ennis, MTS/N D-4668N4522SSpecialty Surgery Centers Of America Inc · Brentwood, TNBuilt 1975 · S/N TC-1889N4523SLucky92 & Associates LLC · Reno, NVBuilt 1976 · S/N TE-1062N4524SKnox James P · Park Rapids, MNBuilt 1975 · S/N E-727N4525DButler Philip E · Wichita, KSBuilt 1956 · S/N D-4692N4527MF33 Air LLC · Selinsgrove, PABuilt 1978 · S/N CE-768N4528DHopper Phillip L · Phoenix, AZBuilt 1956 · S/N D-4697N4528SMoore William W · Merritt Island, FLBuilt 1975 · S/N D-9799N4529MMetzler Aaron · Otis, COBuilt 1978 · S/N D-10115N4529SRegistration Pending · Frisco, TXRegistration pendingBuilt 1975 · S/N CE-600N452CWashington Derrick A · Louisville, KYBuilt 1999 · S/N E-3256N452SCBond Jeffrey B · Lebanon, MOBuilt 1975 · S/N D-9771N4532DShort Carl M II · Arrington, TNBuilt 1956 · S/N D-4685N4532SElite Aviation Partners LLC · Blacklick, OHBuilt 1975 · S/N CE-598N4533SBolanos Nilson J · Fairview, NJBuilt 1975 · S/N CE-612N4534MFowler Bruce Jr · Cedar Park, TXBuilt 1956 · S/N 58-11088 (FM88)N4534SMarmon Robert A · Merion Station, PABuilt 1975 · S/N E-743N4535SWintson James R · Cornelius, NCBuilt 1976 · S/N P-384N4537DBlech Connor N · Chowchilla, CABuilt 1956 · S/N D-4751N4537MBullet Construction LLC · Roswell, NMBuilt 1979 · S/N TC-2234N453SAHts LLC · Hudsonville, MIBuilt 2002 · S/N E-3453N4540Mathis Mark L · Fremont, CABuilt 1971 · S/N E-299N4540DBailey Jerry D · Ardmore, OKBuilt 1956 · S/N D-4716N4540STdc Aviation LLC · Wilmington, DES/N TC-1891N4541DGastaris Nichlas · Shelby Township, MIBuilt 1956 · S/N D-4722N4541MPerez Johnathan Daniel · Placerville, CABuilt 1978 · S/N E-1232N4542DMathis Mark L · Fremont, CAS/N D-4680N4543DFerguson William Keith · Ocala, FLBuilt 1956 · S/N D-4684N4546SMid Iowa Equipment · Newton, IABuilt 1975 · S/N TC-1895N4547DAviation Garage LLC · Farmington, MIS/N D-4677N4547SLorentz Aviation LLC · Canadian, TXBuilt 1976 · S/N TJ-81N454ATye Eric R · Napa, CABuilt 1963 · S/N TC-533N454BMajeste Air LLC · Loveland, COS/N P-302N454JDickey Michael W · Fredericksburg, TXBuilt 1979 · S/N E-1571N454RBDan Cox LLC · Troutdale, ORBuilt 1966 · S/N D-8242N4551DSannon Michael R · Fairview, MTBuilt 1956 · S/N D-4704N4551SAak Enterprises LLC · Fayetteville, ARFirst renewal noticeBuilt 1976 · S/N CE-645N4556MPerry Richard H · Crossville, TNBuilt 1978 · S/N E-1234N4559MSky High Ventures LLC · Bartlett, TNS/N E-1235N455BTMarshall Tristen · Spokane Valley, WABuilt 1964 · S/N TC741N455DSanders Tyler B · Yuma, AZBuilt 1989 · S/N CE-1408N455DCAviation Safety Training International LLC · Butte, MTBuilt 1968 · S/N CJ-13N455FPRobert Corio Inc · Johnston, RIS/N TE-549N455HCBas Part Sales LLC · Greeley, COS/N TC-586
Back to AD 99-05-13 R1 WD