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.

N2129WDuknic Derek · Magnolia, TXBuilt 1973 · S/N M-1500N212DEWerre Joel F · Dunn Center, NDS/N EA-626N212GBailey Orin A · Homedale, IDBuilt 1955 · S/N CH-331N212GMAce Flight Center Inc · St Thomas, VIS/N TD-529N212GWTim D Wilson Investigations Inc · Hempstead, TXS/N TE-494N212MHM L H Properties Inc · Rogers, ARBuilt 1998 · S/N E3209N212RJBishop Mike · Rifle, COBuilt 1964 · S/N D-7467N212STWalsh Scott · Stuart, FLBuilt 1978 · S/N MC-566N212TDDevane David B Trustee · East Falmouth, MABuilt 1982 · S/N E-1944N212VGuilfoyle Robert J · Fairhope, ALBuilt 1976 · S/N D-9851N2130LTds Property Holdings LLC · Gilmer, TXBuilt 1976 · S/N TK-25N2130WUnusual Attitudes Flying Club Inc · Mount Vernon, MOBuilt 1974 · S/N M-1505N2131DWiley David A · Arlington, TXBuilt 1957 · S/N D-3476N2131WRussek Rick · Cave Creek, AZBuilt 1974 · S/N M-1506N2132LCsrh Ventures LLC · Lubbock, TXBuilt 1976 · S/N D-9923N2133WBeck Robert M · Bakersfield, CABuilt 1974 · S/N CE-502N2134LHeyen John M · Springfield, ILBuilt 1976 · S/N E-890N2134WJustison David L · Hillsboro, ILBuilt 1974 · S/N M-1508N2135WLeary Kevin · Midland, TXBuilt 1974 · S/N D-9648N2136DLeake Richard · Fresno, CABuilt 1953 · S/N D-3481N2136WMills Robert D · Newport, MIBuilt 1974 · S/N E-568N2137LPcb Air 2 LLC · West Palm Beach, FLBuilt 1976 · S/N CE-662N2138DMigliaccio Jason · Palm Bay, FLBuilt 1953 · S/N D-3483N2138LBrooks John S · Camarillo, CAS/N E-893N21398Peterson Peter M · Silverado, CABuilt 1977 · S/N D-10077N2139DJenkins James G · Stoneville, NCBuilt 1953 · S/N D-3484N2139WRegistration Pending · Lake Worth, FLRegistration pendingBuilt 1974 · S/N M-1509N213CNCullem Daniel F · Soquel, CABuilt 1980 · S/N TC-2298N213DBall Frederick C · Harbor Springs, MIBuilt 1955 · S/N CH-192N213DRCon-Ag Rentals Inc · Blairsville, GAFirst renewal noticeBuilt 1999 · S/N E-3247N213EOliver Craig J · Orion, MIBuilt 1965 · S/N TE-40N213MEMcgough Craig N · Ferris, TXBuilt 1958 · S/N D-5686N213PBKofman Peter M · Mountain Grove, MOBuilt 1959 · S/N D-5791N213QHardcopf Robert W · Apple Valley, MNBuilt 1965 · S/N D-7929N213ZWhite Gregory D · Enterprise, ALBuilt 1964 · S/N TC-672N2140WAbbott Bruce E · Seal Beach, CABuilt 1974 · S/N M-1513N2141LErwin James Erskine III · Newnan, GABuilt 1976 · S/N E-896N2141WMeyer Carl F Jr · Eagan, MNBuilt 1974 · S/N M-1514N2142DGlenn Kyle K · Ellendale, NDS/N D-3546N2144LPrivate Paws LLC · Colorado Springs, COBuilt 1976 · S/N E-895N2146DDerrer Anthony Robert · Livermore, CABuilt 1953 · S/N D-3491N2147WMeyer Ronnie G · Sidney, NEBuilt 1974 · S/N M-1520N2148LL&M Cleared2land LLC · Coral Gables, FLBuilt 1976 · S/N E-897N2149LRocky Hill Airshows Inc · San Jose, CABuilt 1976 · S/N E-898N214CKBreland Michael · Olympia, WABuilt 1976 · S/N P399N214DMGrueninger Mark J · Benton, ILBuilt 1962 · S/N TC-285N214DRMarsh David · Flower Mound, TXBuilt 1969 · S/N D-8997N214MCCampbell Christian · Senoia, GAS/N D-6772N214QHassenger Management Strategies Inc · San Antonio, TXBuilt 1965 · S/N D-7932N214RCWhitcomb David · Morrisville, VTS/N D-7453
Back to AD 99-05-13 R1 WD