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.

N292MWGroth Greg · Cookeville, TNBuilt 1994 · S/N E-2862N2930BMcdougall Angus D · Gillette, WYBuilt 1953 · S/N D-3571N2931BMake It So LLC · Knoxville, TNBuilt 1953 · S/N D-3572N293SMKemp Aviation LLC · Hiram, GABuilt 1982 · S/N EA-329N2941VDowns Roland · Oro Valley, AZBuilt 1947 · S/N D-329R12N2942BThomas Ronald G · Dallas, TXBuilt 1953 · S/N D-3583N2944BVantreese Kenneth C · Tulsa, OKBuilt 1953 · S/N D-3585N2949BKlassen Lloyd G · Enid, OKBuilt 1953 · S/N D-3590N294AMAeh Flying Inc · Cincinnati, OHBuilt 1985 · S/N E-2262N294DTrant David B · Kingsville, TXBuilt 1977 · S/N P-451N2950BReichert Thomas W · Dickinson, NDBuilt 1956 · S/N D-3591N2952BReardon Michael · East Falmouth, MABuilt 1953 · S/N D-3593N2954BO'Conell David DBA · Butte, MTBuilt 1953 · S/N D-3595N295BSInternational Air Services Inc Trustee · Carson City, NVBuilt 1939 · S/N 39-139N295DEFly Direct LLC · La Porte, INBuilt 1956 · S/N DH-88N295RJRegistered aircraftBuilt 1983 · S/N EA-381N2960FNaber Tania B · Niceville, FLBuilt 1953 · S/N D-3601N2962BBridges Janiece · Forsyth, MOS/N D-3603N2969BBlaszak Benjamin D · Troy, MIBuilt 1953 · S/N D-3610N2969CCollins Gordon Lee · Knoxville, TNS/N G-155N296BJc Aircraft Leasing LLC · Wasilla, AKBuilt 1964 · S/N TC-600N296HLMcclanahan Edward A · Apo, AEBuilt 1980 · S/N M-2275N2970BRymer Joseph M · Riverview, FLBuilt 1953 · S/N D-3611N2971BParker Michael T Trustee · Denton, TXBuilt 1953 · S/N D-3612N2972BTowle Karl E · Denton, TXBuilt 1954 · S/N D-3935N2973BLightle Theodore L · Cocoa, FLBuilt 1953 · S/N D-3613N2975BHayes Jack D · Kingman, AZBuilt 1953 · S/N D-3615N2976BParker Michael T Trustee · Denton, TXBuilt 1956 · S/N D-4786N2977BFilippelli Kenneth J · Edmond, OKBuilt 1955 · S/N D-4152N2978BDelarosa Kelly · Port Orange, FLBuilt 1953 · S/N D-3618N297DMFocht Ronald D · Fort Myers, FLBuilt 1980 · S/N TC-2351N2980AWest David R · Newalla, OKBuilt 1978 · S/N D-10154N2981BStowells Outlaw Services LLC · Rigby, IDS/N D-3621N2983BFisher Bryce Anthony · Cleveland, TNS/N D-3623N2986BBrittian Scott A · Wichita, KSBuilt 1953 · S/N D-3496N2989Reavely Richard T · Madison, CTBuilt 1969 · S/N M-1274N298BCFlight School Of Gwinnett · Lawrenceville, GABuilt 1978 · S/N ME-59N2993BHillegeist Tracy · Beverly, KSBuilt 1953 · S/N D-3631N29950Nichols William K · Bainbridge, GABuilt 1974 · S/N TC-1760N29959Nail Ronald Wesley · Edmond, OKBuilt 1986 · S/N E-2340N2995BLeggat Douglas J · Manhattan, KSBuilt 1953 · S/N D-3633N2996BSale Reported · Alton, ILSale reportedBuilt 1953 · S/N D-3634N2997BFigueroa Christopher · West Covina, CABuilt 1953 · S/N D-3635N2998MM T Aviation LLC · Grove, OKBuilt 1986 · S/N CE-1097N2999BNordhagen Melvin L · Spokane, WABuilt 1954 · S/N D-3748N2999GShehl Michael H · Danbury, CTBuilt 1986 · S/N E-2348N2999MLopez Eve · Santa Monica, CABuilt 1985 · S/N CE-1074N2999NGarcia Michael R · Marshall, VABuilt 1986 · S/N CE-1081N299BDTupelo Air LLC · Altheimer, ARS/N E-3474N299BGHarrison Rv Inc · Jefferson, IABuilt 1989 · S/N CE-1366
Back to AD 99-05-13 R1 WD