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.

N1849PDaedalus LLC · Bozeman, MTBuilt 1982 · S/N CE-974N1849SOnedown LLC · Kalispell, MTBuilt 1981 · S/N CE-973N1849WCarrow LLC · Meredith, NHBuilt 1973 · S/N E-428N184AJFour Alpha Juliet LLC · Minster, OHBuilt 2004 · S/N E-3578N184BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-68N184DMRegistered aircraftBuilt 1998 · S/N E-3199N184EHTen Hi Flyers Inc · Denver, COBuilt 1989 · S/N CE-1355N184ERIxi LLC · West Bloomfield, MIBuilt 1979 · S/N ME-267N184HPGries John R · Haslet, TXBuilt 1979 · S/N TC-2248N184MBBaker Aviation Consulting LLC · Summerland Key, FLBuilt 1976 · S/N TE-1075N184QSchmuker David Joseph · Grand Rapids, MIBuilt 1959 · S/N D-5954N1850DLeupp John R · Taylors, SCFirst renewal noticeBuilt 1952 · S/N D-3116N1850FMarcus Air LLC · Plano, TXBuilt 1981 · S/N TE-1195N1850JWailea Aircraft LLC · Kamuela, HIBuilt 1981 · S/N EA-268N1850NSnohomish Flying Service Inc · Snohomish, WABuilt 1981 · S/N ME-429N18516Maine Instrument Flight · Augusta, MEBuilt 1981 · S/N M-2344N1852DEbers Harold Dewayne · Hennessey, OKBuilt 1952 · S/N D-3114N1852SReg Aeronatics LLC · Bradenton, FLBuilt 1981 · S/N E-1923N1853BAltius Aviation LLC · Syracuse, NYBuilt 1981 · S/N TC-2420N1853WKozdron Henry · Harbor Beach, MIBuilt 1973 · S/N D-9477N1854KNelson Law Firm Pc · Billings, MTBuilt 1981 · S/N E-1927N1854WRona-B LLC · Scottsdale, AZBuilt 1981 · S/N EA-269N18555Wiltz Paul E · Opelousas, LABuilt 1937 · S/N 157N1855D55 Delta LLC · Jacksonville, FLBuilt 1952 · S/N D-3130N1855S1855 Sierra LLC · Brighton, MIBuilt 1981 · S/N CE-980N18560Strafuss Ben · Collierville, TNFirst renewal noticeBuilt 1937 · S/N 162N18561Ladd Daniel T · Loudon, NHBuilt 1938 · S/N 210N1856DByrd Aviation LLC · Marshfield, MOS/N D-3112N1856FCraig Marc · Mountain City, TXBuilt 1981 · S/N E-1931N1856LR J Fuselier & Associates LLC · Eunice, LABuilt 1976 · S/N D-9889N1856ZBromley Wayne B · Colwich, KSBuilt 1981 · S/N CE-977N18570Howell Nicholas A · Englewood, COBuilt 1938 · S/N 228N18575Greenblatt Michael A · Midland, GABuilt 1937 · S/N 179N18577Jacobson Curtis · Prineville, ORBuilt 1937 · S/N 195N1858LAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N CE-646N1858PBaron N1858p LLC · Fresno, CABuilt 1981 · S/N TJ-372N1859CHadley Aviation LLC · Kent, CTBuilt 1981 · S/N CE-986N1859P1859p LLC · Fulton, MOBuilt 1982 · S/N E-1995N1859WDellarosa Brian David · Indianapolis, INBuilt 1973 · S/N D-9503N185HP185hp LLC · Sioux Falls, SDBuilt 1982 · S/N E-1996N185THsr Creative LLC · Indian Trail, NCS/N D-9672N1860AAry Co Ac & Heat LLC · Decatur, TXBuilt 1981 · S/N E-1933N1860DRay Charlie B · Prosser, WABuilt 1951 · S/N D-3125N1860WWhittaker Gary · Southport, NCBuilt 1973 · S/N D-9500N1861FKent Group Inc · Hazelhurst, WIBuilt 1981 · S/N E-1940N1861LBaker James W · Goodland, KSBuilt 1976 · S/N TC-1964N1861MLightspeed Enterprises LLC · Virginia Beach, VABuilt 1981 · S/N E-1936N1865LLiberty Partners Inc · Okmulgee, OKS/N TK-14N1866DFarris Russell L · Fort Mill, SCBuilt 1952 · S/N D-3136N1868WJohnson Brian D · Glidden, IABuilt 1973 · S/N E-436
Back to AD 99-05-13 R1 WD