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.

N9186SHigh Flyin LLC · Canton, MSBuilt 1976 · S/N M-1805N9187SCarr Gary · Crestwood, ILBuilt 1976 · S/N MB-790N9188SVanommeren Matthew · Uniondale, NYBuilt 1976 · S/N M-1803N918CSDubberly David · St Simons Is, GABuilt 1961 · S/N D-6881N918QHardey John L · Spring, TXBuilt 1961 · S/N D-6812N918SNorton Wesley R · Medford, ORBuilt 1960 · S/N DH-302N9192QMonroe Aviation Inc · Verona, PABuilt 1971 · S/N E-259N9193SMiller Brian P · Middletown, INBuilt 1975 · S/N MC-365N9195SBailey Thomas P · Cannelton, INBuilt 1975 · S/N MC-368N9196SSkyward Leasing Inc · Dallas, GABuilt 1975 · S/N MC-370N9197SEisenhaur Timothy · Wells, MEBuilt 1975 · S/N M-1684N9198STolton Grant D · Republic, WABuilt 1975 · S/N M-1712N9199QCramer Todd L · Fort Mohave, AZBuilt 1971 · S/N CE-334N919BGFreebird Aviation LLC · Monahans, TXBuilt 1984 · S/N EA-428N919CAvventura Del Volo LLC · Nashville, TNBuilt 2004 · S/N E-3563N919DPTrumbull Thomas A Trustee · Leland, MIBuilt 1987 · S/N E-2373N919JBWiz Air LLC · Wilmington, DEBuilt 1980 · S/N E-1702N919MSStraits Mark · Sugarcreek, OHS/N E-3504N919PJDel Rosso Peter · Los Angeles, CABuilt 1981 · S/N TK-140N919TPWarren Jason J · Silverdale, WABuilt 1977 · S/N D-10068N919YFlow Pro Products Inc · Romeoville, ILS/N TC-408N91DCarterdawg Real Estate And Aircraft Holdings LLC · Fort Worth, TXBuilt 1967 · S/N TE-496N91DDLonghorn Leasing LLC · Anchorage, AKS/N EA-511N91EWToussaint David F · Lakeville, MNS/N WA-30N91HZaher Amir · Oakland, TNBuilt 1938 · S/N 219N91JPJackson Gerald M · Lake City, MIBuilt 1975 · S/N D-9810N91KMj Aviation Inc · Custer, SDBuilt 1975 · S/N D-9764N91VPBravo Sierra Holdings LLC · Downers Grove, ILBuilt 1969 · S/N D-9035N91YRRegistered aircraftBuilt 1991 · S/N CE-1634N9200QHenning Lowell W · Haslet, TXBuilt 1971 · S/N CE-335N9202SEstafan Fadi · Tracy, CABuilt 1975 · S/N M-1736N9203QDavis & Automotive Services Inc · Carlinville, ILBuilt 1971 · S/N E-261N9204SHoward Alexander James · Coulterville, ILS/N MC-374N9206SJohnson W Norman · Stayton, ORS/N MC-375N9207SMr Woodchuck LLC · Naples, FLBuilt 1975 · S/N MC-376N9208SFrush Charles A · Burlington, NJBuilt 1975 · S/N M-1688N920CBOgden Newspapers Inc · Wheeling, WVBuilt 1981 · S/N TJ-380N920JKeppen Charles Joseph · Wentworth, SDS/N D-4671N920LGSmart Motion Advisory Group LLC · Frisco, TXBuilt 1994 · S/N E-2901N9210SBazemore Dennis A · Ingleside, TXBuilt 1975 · S/N MC-384N9212QViking Pilot LLC · Carmel, CABuilt 1971 · S/N E-268N9214SC&L Aviation LLC · New London, WIBuilt 1975 · S/N M-1737N9215SGarner James L DBA · Pelham, ALBuilt 1973 · S/N M1711N9216QOsage Aviation LLC · Yates Center, KSBuilt 1971 · S/N D-9268N9217QMiyamoto Edward · Rio Vista, CABuilt 1971 · S/N CE-340N9219QMedia Exp LLC · Portland, ORBuilt 1971 · S/N D-9265N921AWJjmb Customs LLC · Port Saint Lucie, FLS/N P-292N921KKTat Networks And Aviation LLC · Bend, ORBuilt 1974 · S/N TE-980N921MJKing Robert Kyle · Wichita Falls, TXS/N CE-1458N921MKCognito Design Inc · Punta Gorda, FLS/N D-9321
Back to AD 99-05-13 R1 WD