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.

N906VState Of Alabama · Montgomery, ALBuilt 1974 · S/N TE-983N9070SFontana Brent S · Rogers, ARBuilt 1978 · S/N CE-793N9072SSaddleback Enterprises LLC · Newport Beach, CABuilt 1978 · S/N E-1307N9074QDulin Michael N · Edmond, OKBuilt 1970 · S/N E-235N9075QBenson Edward A · San Antonio, TXBuilt 1970 · S/N D-9202N9076Q76q LLC · Ventura, CABuilt 1970 · S/N E-236N908Heinze Gregory L · Little Rock, ARBuilt 1945 · S/N A-36N9081QReplogle Randall B · Gulfport, MSBuilt 1970 · S/N D-9203N9083SRobinson Charley C · Guthrie, OKBuilt 1978 · S/N TJ-152N9084QEanes Thomas M · Fort Worth, TXBuilt 1970 · S/N E-237N9086SKats Ventures LLC · Byron, MNBuilt 1978 · S/N CE-790N908ATWegener Airlines Inc · Ridgeland, MSBuilt 1991 · S/N E2639N908DBB36 LLC · Winter Park, FLBuilt 2002 · S/N EA-694N908PScott Kevin · Santa Fe, NMBuilt 2000 · S/N EA-664N908VSeven M Enterprises LLC · Kalispell, MTBuilt 1974 · S/N D9645N9093QInvesta Aviation LLC · Yoakum, TXBuilt 1971 · S/N E-296N9094SZompa Edward A Md Phd · Galveston, TXBuilt 1978 · S/N D-10152N9095QApt Jerome III · Pittsburgh, PABuilt 1970 · S/N D-9221N9096SRes-Air LLC · Clarksville, TNBuilt 1978 · S/N D-10153N9098RDelta T Properties LLC · Rainbow City, ALS/N G-839N9099SRegistration Pending · Davis, CARegistration pendingBuilt 1976 · S/N E-814N909ATGo Consultants LLC · Wilmington, DES/N E-2647N909GPRegistered aircraftBuilt 1957 · S/N BA-236N909HSilva John R · Salmon, IDBuilt 1956 · S/N D-4658N909MDEmber Brett D · Cottondale, ALBuilt 1970 · S/N D-9210N909TBCrawford Greg · Humnoke, ARBuilt 1971 · S/N TC-1387N909VAAthol Aggregate LLC · Athol, IDS/N D-5505N909VBBedalou Aviation LLC · Joplin, MOBuilt 1997 · S/N E-3133N90HFNovak Todd · Lumberton, NJBuilt 1990 · S/N CE-1495N90JLCrook Robert W · Lowgap, NCBuilt 1955 · S/N D-4295N90KRKoch Leasing LLC · Campbellsville, KYBuilt 1965 · S/N D-7892N90KWKleid Kenneth E · Spring Branch, TXBuilt 1981 · S/N MC-744N90TMJ&W Aviation LLC · Taylor, NEBuilt 1976 · S/N D-9839N90TTTwin Beech Partners LLC · Virginia Beach, VABuilt 1957 · S/N BA-335N9102QLarosa Christopher · Tampa, FLBuilt 1970 · S/N D-9227N9102SHeartland Properties III Inc · Danville, ILS/N D-9972N9104YQ&A Holdings LLC · Elkridge, MDBuilt 1976 · S/N P-382N9105SDominguez Cesar Trustee · Yuma, AZBuilt 1976 · S/N CE-630N9107QRitter Disposables Inc · Marion, ARBuilt 1971 · S/N E-241N9107TVaughan Lee E Jr · Philip, SDBuilt 1968 · S/N MB-377N9109SThomas Timber Inc · Harrells, NCBuilt 1976 · S/N E-816N910TN910t LLC · Newark, OHBuilt 1970 · S/N TC-1361N911Legacy Leasing Group Inc · Wilmington, DEBuilt 1946 · S/N B-12N9110QZen Air LLC · Kalispell, MTS/N D-9219N9111QDreifort David A · Brentwood, CABuilt 1970 · S/N CE-330N9112QSkyward Mn LLC · Hutchinson, MNBuilt 1971 · S/N D-9223N9113SBonanza Flyers Of Kansas LLC · Stilwell, KSBuilt 1976 · S/N D-9857N9114TFlying Frog Aviation LLC · Palm City, FLBuilt 1969 · S/N MB-401N9115HMontmorency John Trustee · Napa, CAS/N 1014N9116TSkinner Jay D · The Woodlands, TXBuilt 1968 · S/N MA-331
Back to AD 99-05-13 R1 WD