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.

N999ERBalentine Joe B · Alvarado, TXBuilt 1967 · S/N D-8304N999FSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1988 · S/N CE-1282N999FBDelia Salvatore · Rocky Point, NYBuilt 1979 · S/N E-1495N999FMWhite Christopher M · Broken Bow, OKS/N D-6160N999GTJet Air Inc · Iowa City, IABuilt 1964 · S/N D-7686N999KAHarlan John M · Cedar Park, TXBuilt 1967 · S/N D-8644N999KTSmith John C B · West Palm Beach, FLS/N TJ-483N999NWBoss Gary W · Bronston, KYBuilt 1969 · S/N M-1243N999PGRegistered aircraftBuilt 1995 · S/N E-2955N999PZBs Starbellies LLC · Austin, TXBuilt 1979 · S/N E-1483N999RBSchmidt Frances M · Lafayette, INBuilt 1967 · S/N TC-1052N999SCRounds Donald C DBA · Waller, TXS/N G-306N999SGHuskey Eugene Donald Jr · Leesburg, TXBuilt 1981 · S/N E-1963N999SWEis Equipment LLC · Eau Claire, WIBuilt 1979 · S/N P-505N999TEtling Kurt K · Edgewood, TXS/N D7210N999WMTriple Nine Wm LLC · Yukon, OKBuilt 1978 · S/N P-472N999YBucciarelli Tazio E · San Diego, CABuilt 1955 · S/N G-811N99AWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1973 · S/N CE-420N99BDOcm Aviation LLC · Garner, NCBuilt 1977 · S/N E-1147N99BGTfs Air LLC · Loveland, COBuilt 1962 · S/N TC-396N99BRAircorps Aviation LLC · Bemidji, MNBuilt 1980 · S/N E-1688N99CCSchmalz Philip Griffin Ranlett · Mountain Brk, ALBuilt 1961 · S/N D-6790N99CEAviation Peter Corp Of New York · New York, NYBuilt 1954 · S/N D-3987N99DGBrooks Conoly O III · San Angelo, TXBuilt 1978 · S/N CE-823N99DPCmt Properties LLC · Laurel, MSBuilt 1966 · S/N TE-158N99DVSopwith Ltd · Las Vegas, NVS/N B-9N99JCHerold Edward E · Santa Cruz, CABuilt 1975 · S/N TC-1801N99JZUnadventurous LLC · Amarillo, TXBuilt 1984 · S/N TJ-474N99L99 Lima LLC · San Antonio, TXBuilt 1957 · S/N G-122N99LGWashington Enterprises LLC · Little Rock, ARBuilt 1987 · S/N CE 1157N99MFly Buy LLC · Kalispell, MTBuilt 1972 · S/N CE-414N99MKHigh Mountain Healthcare LLC · Blairsville, GABuilt 1977 · S/N CE-742N99MQPlacide Aircraft LLC · Canton, MIBuilt 1968 · S/N TE-527N99NPColonial Export Inc · Pompton Plains, NJBuilt 1976 · S/N E-809N99NTEdwards Mark A · Sedalia, MOBuilt 1965 · S/N D-8019N99PAMckelvey Jeffrey R · Dadeville, ALBuilt 1978 · S/N TJ-179N99PRBeale Leonard C · Fort Worth, TXBuilt 1968 · S/N TD-709N99RLThompson Nigel J · Ann Arbor, MIBuilt 1970 · S/N D-9108N99SBBonanza Service Ltd Co · Bethany, OKBuilt 1971 · S/N E-281N99SDCali Aviation LLC · Sacramento, CABuilt 1961 · S/N D-6672N99VBC&S Aviation Partners LLC · Thibodaux, LABuilt 1980 · S/N EA-154N99VMDaniel M Skotte Do Pc · Sunriver, ORBuilt 1980 · S/N EA-140N99WMDay William L · Seguin, TXBuilt 1958 · S/N D-5654N99ZXCecil Geoffrey · Punta Gorda, FLBuilt 1973 · S/N D-9530N9ABFirst Alarm Aviation LLC · Fosters, ALBuilt 1978 · S/N D-10175N9BMMahanor Joseph P · Spring City, PABuilt 1955 · S/N BG-117N9BNBrookfield Bonanza Corp · Menomonee Falls, WIBuilt 1982 · S/N E-2046N9BSWorld Aircraft Sales Inc · Gulfport, MSBuilt 1968 · S/N TG-73N9DNMaxs Airplane LLC · Plano, TXBuilt 1973 · S/N D-9550N9DVNorwood Ronald Steven · Raleigh, NCBuilt 1981 · S/N EA-193
Back to AD 99-05-13 R1 WD