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.

N1498LWheaton Blake L · Atlanta, GABuilt 1966 · S/N M-898N1499LHicks Philip R Jr · Knoxville, TNFirst renewal noticeBuilt 1966 · S/N M-899N149BDLewellyn Jim · Bloomsburg, PABuilt 1976 · S/N D-9924N149DSBuffaloe Thomas N · Mancos, COBuilt 1949 · S/N D-2152N149EDR&R Unlimited Inc · Alma, ARS/N D-1790N149GMetro Flyers Ltd · N Richland Hills, TXBuilt 1966 · S/N D-8100N149PAelick Joel D · Charlotte, NCBuilt 1979 · S/N M-2237N149RBest Erectors Inc · Wilmington, DEBuilt 1978 · S/N D-10161N149WLCarter Robert J Jr · Oak Ridge, TNS/N E3562N14ARRatliff Alvin · Northport, ALBuilt 1975 · S/N CE-561N14CMGallagher Michael S · Los Alamitos, CABuilt 1971 · S/N D-9298N14DADonaire Aviation LLC · Tampa, FLBuilt 1962 · S/N TD-505N14DFCook Charles M · Jay, FLBuilt 1957 · S/N D-5336N14FMDurbin Gregory M · Dallas, TXS/N D-7802N14JPDakota Aircraft Inc · Pierre, SDBuilt 1986 · S/N CJ-177N14LRGolly Laura · Deridder, LABuilt 1974 · S/N E-524N14MBJackson Craig D · Idaho Falls, IDBuilt 1977 · S/N E-1062N14MNOne Room LLC · Abilene, TXBuilt 1978 · S/N E-1344N14PGorman Aviation LLC · Bartlesville, OKBuilt 1985 · S/N TJ-492N14RFBerry Darrel · Camden, TNBuilt 1973 · S/N E-486N14VPAmerican Woodcraft LLC · Fort Denaud, FLBuilt 1981 · S/N P-576N14VUBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1962 · S/N DH-326N14WWWa Consulting LLC · Nashville, TNS/N E-3297N1500BElectrical Field Services Inc · Huffman, TXBuilt 1994 · S/N CE-1768N1500FGerhold Jeremy · Rosharon, TXS/N D-8552N1500LLandolt Gregg E · Moreno Valley, CABuilt 1968 · S/N TC-1120N1500SCianchette R Scott · Hermon, MEBuilt 1961 · S/N D-6897N1500VTessem Rolfe S · Great Barrington, MABuilt 1970 · S/N D-9160N1501STaylor Counsel LLC · Hoschton, GABuilt 1962 · S/N D-6898N1501ZDaytona Aircraft Services Inc · Daytona Beach, FLBuilt 1961 · S/N D-6824N1502SMakiva Sasha · Sonoma, CAS/N D-6899N1502ZSmith Chad M · Danville, CABuilt 1961 · S/N D-6823N1503ZMain Attraction LLC · Sioux Falls, SDBuilt 1961 · S/N D-6825N1505SBluboco LLC · Northville, MIBuilt 1962 · S/N D-7037N1507SArteta David A · Wake Forest, NCFirst renewal noticeBuilt 1962 · S/N D-6935N1509ZHeinrich John W · Chandler, AZBuilt 1961 · S/N TC-210N150DRVan Den Heuvel Michael E · Middleton, WIBuilt 1990 · S/N CE-1473N150UUKoshar Steven R · Coloma, MIBuilt 1961 · S/N D-6630N150WRWhiskey Romeo LLC · Timnath, COBuilt 1969 · S/N D-8911N1510SClark Lahn F · Pasco, WABuilt 1962 · S/N D-6940N1512SIrwin Dennis R · San Diego, CABuilt 1962 · S/N D-6941N1512WBryant John Mark · Knoxville, TNBuilt 1972 · S/N D-9332N1514BLilu LLC · Siloam Springs, ARBuilt 1988 · S/N CE-1276N1514ZDierold Robert S · Carrollton, TXBuilt 1961 · S/N D-6832N1515MSurecraft LLC · Dover, DEBuilt 1988 · S/N CE-1304N1515ZYanks Air Museum · Baldwin Park, CABuilt 1961 · S/N D-6831N1516MWrubel David · Atlanta, GABuilt 1988 · S/N E-2459N1516ZTulin Gary N · Sedona, AZS/N D-6836N15186N15186 LLC · Dyer, INBuilt 1988 · S/N E-2456N151FClark Robert G · Healdsburg, CABuilt 1964 · S/N TC-613
Back to AD 99-05-13 R1 WD