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.

N331BRegistered aircraftBuilt 1956 · S/N D-4829N331BEBabich Leslie Paige · Lutz, FLBuilt 1981 · S/N M-2300N331CSBauer Matthias · Ann Arbor, MIS/N D-7126N331EBEberly Mark H · Carmel, INBuilt 1976 · S/N CE-651N331GZN331gz LLC · Fort Myers, FLBuilt 1980 · S/N WA-116N331HKCharter Scott R · Manistique, MIBuilt 1960 · S/N D-6313N331RHWhite Wing Aviation LLC · Shreveport, LABuilt 1977 · S/N CE-691N331SASunlight Aviation LLC · Anchorage, AKS/N E-3301N3320CTalmage Timothy A · Azle, TXS/N D-3986N3321CAviation Management II LLC · Des Moines, IAS/N E-1261N3322CLt Aviation LLC · Louisa, KYBuilt 1955 · S/N D-4194N3324CGloeckler Alexander · Pearl City, ILBuilt 1954 · S/N D-3990N3325CPolhemus Christopher A · Carmichaels, PABuilt 1954 · S/N D-3991N3326CDefiant Aeronautics LLC · Marion, TXBuilt 1954 · S/N D-3992N3327CObenauf L John · Manvel, TXBuilt 1955 · S/N D-4187N332CBFlying Pigs Aviation LLC · Los Altos, CABuilt 2000 · S/N E-3306N332HPDolan Charles A · Augusta, GABuilt 1990 · S/N CE1508N332ZBrown Kenneth L · Conroe, TXBuilt 1960 · S/N D-6504N3332BAirkrapf LLC · Clearwater, FLBuilt 1997 · S/N E-3140N3333AReese Ronald R · Lakewood Ranch, FLBuilt 1977 · S/N E970N3334CBijelic Luke E · Mahwah, NJBuilt 1954 · S/N D-4000N3336CLucarelli Christopher Alan · Moncks Corner, SCBuilt 1955 · S/N D-4002N333BQQualitair LLC Trustee · MichelstadtBuilt 1960 · S/N DH-250N333EIngram Robert S · Bertram, TXBuilt 1943 · S/N 4878N333FHHatton Leslie J · Edgewood, TXBuilt 1976 · S/N TC1934N333JGCuthbert Victor W · Dowagiac, MIBuilt 1964 · S/N TD-580N333JMKahl Fredric P · Monmouth, MEBuilt 1972 · S/N M-1404N333JPSpeece Ryan J · Vero Beach, FLBuilt 1967 · S/N D-8539N333KLindsey Paul R · Quinlan, TXBuilt 1955 · S/N D-4215N333KPGyarfas Nicholas · Lafayette, LABuilt 1948 · S/N D-1909N333LJJarrell Christopher · Lincolnton, NCBuilt 1969 · S/N D-8969N333MCGriffin Shawn P · Locust Grove, GABuilt 1964 · S/N TC-660N333NTKoerner Norman H · Roanoke, TXBuilt 1962 · S/N TD-515N333REM I Aviation Inc · Juda, WIBuilt 1980 · S/N E-1737N333RFQualitair Lc Trustee · MichelstadtBuilt 1976 · S/N TJ-92N333RJAddco Aviation Services Inc · Newcastle, OKBuilt 1978 · S/N D10188N333SRRocky Mountain High Aviation LLC · Boulder, COBuilt 1977 · S/N TJ-114N333TFBluebird Airways Inc · East Palatka, FLBuilt 1975 · S/N CE-553N333THUchiyamada Brian N · San Gabriel, CABuilt 1977 · S/N CE-692N333TRBreaking Wind LLC · Alabaster, ALBuilt 1979 · S/N CE-860N333TTChristel Roderick C · Lompoc, CABuilt 1956 · S/N D-4778N333VPDennee Enterprises Group LLC · New Bern, NCBuilt 1984 · S/N E-2161N333WDanarich LLC · Rancho Mirage, CABuilt 1979 · S/N TE-1172N333XJpg Aviation LLC · Wilmington, DEBuilt 1966 · S/N TE-266N334Jeffrey Mark · Clayton, MIBuilt 1967 · S/N D-8467N3340CBeck Roger M Trustee · Goode, VABuilt 1955 · S/N D-4006N3341LSky Chem LLC · Downingtown, PABuilt 1976 · S/N MC-462N3342CKrynik Mitchell G · Granbury, TXBuilt 1955 · S/N D-4008N3343CHecker Mark · Niceville, FLBuilt 1955 · S/N D-4009N3343LFreid Paul E · Southport, NCBuilt 1976 · S/N MC-466
Back to AD 99-05-13 R1 WD