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.

N520TStanton Thomas M · Mcallen, TXBuilt 1966 · S/N TE-63N5214MS & M LLC · Nauvoo, ALBuilt 1978 · S/N M-2013N5216CGusset LLC · Omaha, NEBuilt 1950 · S/N D-2561N5216MChu Philip · Surprise, AZBuilt 1978 · S/N M-2010N5218CMikesell Tim · Decatur, ILBuilt 1950 · S/N D-2563N521CRuhan Brendon Thomas · Rehoboth, MABuilt 1987 · S/N CE-1119N521DPWin Holdings Inc · Englewood, COBuilt 1962 · S/N D-7005N521EAngels Ten LLC · Norfolk, VABuilt 1981 · S/N CE-963N521PWDoghouse Aviation LLC · Vienna, VABuilt 1988 · S/N E-2434N521VRMyers Jonathan A · Dieterich, ILBuilt 1965 · S/N D-7922N5220CD & A Aviation LLC · Melbourne, FLBuilt 1950 · S/N D-2565N5221TPalmer Charles S · Hernando, MSBuilt 1976 · S/N TC-1995N5226CShaner Toby D · Burlington, WABuilt 1950 · S/N D-2571N5226MTrader Robert D · Madison, INBuilt 1978 · S/N M-2014N522DHFlohr James E · Parker, COBuilt 1960 · S/N D-6493N5236MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-21N5239CDewitt Frederick E · Sycamore, ILS/N D-2630N523AMSigma Aviation LLC · Vancouver, WABuilt 1981 · S/N E-1723N523CHawk Unlimited LLC · Kalispell, MTBuilt 1998 · S/N E-3161N523DBN523db LLC · Santa Ana, CABuilt 1999 · S/N EA-643N523EFAircraft Partner Holdings Inc Trustee · BerlinBuilt 1979 · S/N P-523N523HCN523hc LLC · Pinecrest, FLBuilt 1972 · S/N P-200N523QNixon John H · Ormond Beach, FLBuilt 1967 · S/N D-8582N523SHNesher Wings LLC · Phoenix, AZBuilt 1998 · S/N EA-618N523TTennant Daniel R · Uniontown, OHBuilt 1963 · S/N D-7178N523TCSmith Ranch Bonanza LLC · San Francisco, CABuilt 1964 · S/N D-7613N523ZARegistration Pending · Perryton, TXRegistration pendingBuilt 1974 · S/N D-9596N5240CHardy Pete · Pearland, TXS/N D-2631N5246CMenzimer David · Snohomish, WAS/N D-2638N5246MFlorida Aviation Career Training Inc · Saint Augustine, FLBuilt 1978 · S/N MC-564N5247CFoushee Michael J · Columbus, INBuilt 1950 · S/N D-2639N524CNSchuele Hans-Peter · Wichita Falls, TXBuilt 1984 · S/N E-2144N524QBartel Christopher H DBA · Williamsburg, PABuilt 1967 · S/N TE-453N5250CHodges John J · Cleburne, TXBuilt 1950 · S/N D-2642N5255MFlesher William Robert Jr · Gainesville, GABuilt 1978 · S/N M-2019N5256CFortier Stanley · Chico, CABuilt 1950 · S/N D-2648N525BHWalker Craig · Pleasant View, TNBuilt 1982 · S/N D-10400N525CAWb Aviation LLC · Sugar Grove, ILBuilt 1981 · S/N E-1797N525FSWrb Aircraft Leasing LLC · Wilmington, DEBuilt 2002 · S/N E-3445N525FWWall Freddy V · Raleigh, NCBuilt 1962 · S/N D-7044N525GATechnical And Aviation Services LLC · Salisbury, NCBuilt 1979 · S/N P-525N525JRPj Flyer LLC · Avondale, AZBuilt 1980 · S/N CE-907N525KGCherokee Trail Aviation LLC · Tontitown, ARBuilt 1962 · S/N D-6965N525RRValiair Lc Trustee · Casper, WYBuilt 1997 · S/N E-3069N525SBAdams Sidney R · Belle Haven, VABuilt 1977 · S/N MC-472N525TChomchird Jon Attaporn · Centreville, VABuilt 1962 · S/N TC-360N525TDHigh Sky Bonanza Inc · Wilmington, DEBuilt 1978 · S/N E-1423N5260CTerlizzi Jacob Daniel · Vine Grove, KYBuilt 1950 · S/N D-2652N5263CMangu Ionel · Albuquerque, NMBuilt 1950 · S/N D-2655N5267COlson Derald G · Casa Grande, AZBuilt 1950 · S/N D-2660
Back to AD 99-05-13 R1 WD