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.

N49GCFinnegan Kevin · Indialantic, FLBuilt 1968 · S/N TE-585N49HRBon-36 Ltd · Shavano Park, TXBuilt 1993 · S/N E-2790N49JGCavanaugh James Martin Jr · Ann Arbor, MIBuilt 1990 · S/N CE-1505N49JLPalmetto Aviation Solutions LLC · Woodruff, SCBuilt 1975 · S/N E-746N49LFHerrera Gilbert Jr Trustee · Arcadia, CABuilt 1979 · S/N E-1510N49MDHayes Jack D · Kingman, AZBuilt 1966 · S/N TE-57N49PGVasiloff Mark · Barberton, OHBuilt 1967 · S/N D-8452N49PMFlying Ace 75 LLC · Wilmington, DEBuilt 1970 · S/N TC-1376N49PSZulu Time LLC · Norfork, ARBuilt 1978 · S/N E-1227N49SBGarcia Edward · Ooltewah, TNBuilt 1991 · S/N E-2661N49TRVincent T Remcho Phd LLC · Corvallis, ORBuilt 1974 · S/N D-9628N49WPWilkinson Graham · Camano Island, WAS/N D-2725N49YTTotten Floyd M · Wamego, KSS/N D-5186N4BWPike County Aviation Inc · Waverly, OHBuilt 1972 · S/N TC-1446N4DHGlenn L Martin Maryland Aviation Museum · Baltimore, MDFirst renewal noticeBuilt 1946 · S/N A-260N4EQUsi Leasing LLC · Garden City, KSBuilt 1984 · S/N E-2205N4ERJet Mentors USA LLC · Littleton, COBuilt 1961 · S/N D-6869N4EVSchlueter Gerald C · Lincoln, CABuilt 1952 · S/N D-3302N4FHWall Jacob · Grapevine, TXBuilt 1976 · S/N D-9973N4GAAircraft Owners And Pilots Association · Frederick, MDBuilt 1989 · S/N E-2466N4HFBat Plane LLC · Memphis, TNS/N E-2421N4HHAndrews Terry · Camp Verde, AZS/N D-8422N4HXGoettl Tiffany A · Clarkdale, AZBuilt 1943 · S/N 6672N4JXCosta James J · Tulare, CABuilt 1974 · S/N D-9642N4KTEthriedge Jeffrey A · Elizabethtown, PAS/N CE1115N4LCCorbett Perry Howard III · Ferriday, LABuilt 1991 · S/N E-2617N4LVInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N MC-86N4MCCoberly Adrian R · Manhattan, KSBuilt 1984 · S/N TJ-461N4PKJohnson David W · Mulvane, KSBuilt 1969 · S/N TC-1216N4RANyerges James · Midland, TXBuilt 1969 · S/N LB-4N4RBFlying Country Club Inc · Coal Valley, ILBuilt 1973 · S/N CE-469N4TB367 Estrella LLC · Ponte Vedra Beach, FLBuilt 1955 · S/N CH-308N4TC14tz LLC · Geneva, FLBuilt 1966 · S/N MA-9N4UFOtoole Joshua G · Letts, IABuilt 1976 · S/N TC-1978N4WLOstrich James T · Redding, CAS/N G-127N4WNBlair Aircraft No 2 LLC · Herriman, UTS/N D-5689N4WRShoemaker David J · Menlo Park, CABuilt 1967 · S/N D-8497N4XPPazdziora Ronald G · St Charles, ILBuilt 1982 · S/N D-10401N5000QNowalzyk Daniel C · Downers Grove, ILBuilt 1957 · S/N D-5000N5001XVirginia Brian · Maple Grove, MNBuilt 2002 · S/N E-3481N5002BPeacock Jeffery D · Cleburne, TXS/N D4271N5007BGunnarsson Jon · Concrete, WABuilt 1955 · S/N D-4267N5008Holmes John K · Spring, TXBuilt 1959 · S/N D-5865N5008BHolley Air LLC · Fayetteville, ARBuilt 1955 · S/N D-4268N5008CMckenna Kent T · Torrance, CAFirst renewal noticeBuilt 1950 · S/N D-2270N5009BAcosta Mario L · Eagle Nest, NMBuilt 1955 · S/N D-4269N500BMHawkwell Aviation LLC · Stillwater, OKBuilt 1982 · S/N TJ-418N500BQCoolbreeze LLC · Ripon, CAS/N EA-336N500CALegha Jaskirat · Holly Ridge, NCBuilt 1963 · S/N TC-494N500CMM & M Aviation LLC · Portsmouth, NHBuilt 1979 · S/N E1505
Back to AD 99-05-13 R1 WD