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.

N777PPCabana Robert D · Cocoa, FLS/N G-278N777SMJohnson Paul T · Red Oak, TXBuilt 1955 · S/N D-4400N777TLStemmer Steven N · Huntersville, NCBuilt 1966 · S/N D-8302N777UPerez Michael Joel D · San Diego, CABuilt 1970 · S/N D-9096N777USCurley James L · Oneida, TNBuilt 1966 · S/N TE-182N777VBArizona Thunderbolts LLC · Scottsdale, AZBuilt 1992 · S/N EA-539N777WCHome Run Rv LLC · Helena, MTBuilt 1952 · S/N D-3148N777WDMob Aviation USA LLC · Auburndale, FLBuilt 1960 · S/N D-6491N777XBWinds Aloft LLC · Brookshire, TXBuilt 1969 · S/N D-8948N777XJFields David B · Midland, TXS/N BA-726N777YAerotrack Inc · Hemet, CABuilt 1966 · S/N D-8296N777YFLandsgaard Equipment Leasing LLC · Wellington, COBuilt 1989 · S/N E-2495N777ZDiefenthal Douglas C · Roselle, ILBuilt 1964 · S/N D-7482N7781RVoler Exupery LLC · Lewes, DEBuilt 1968 · S/N TE-664N7786RWinfree Charles E · Edgewood, TXBuilt 1968 · S/N D-8884N7788HTeodoro Financial Group Inc · Mill Valley, CABuilt 1988 · S/N E-2436N7789RKing Automobiles Inc · Auburn, ALBuilt 1968 · S/N TE-661N778FYQualitair LLC Trustee · MichelstadtBuilt 1987 · S/N CE-1148N778JHCurran Michael · Gallatin, TNBuilt 1980 · S/N WA-156N778MWBaty Mark S · Napa, CABuilt 1975 · S/N M-1679N778RWSoutherly Winds LLC · Rogers, ARBuilt 1976 · S/N CE-652N7796NBas Part Sales LLC · Greeley, COBuilt 1968 · S/N TC-1192N7797RTurner Michael C · Suffolk, VABuilt 1968 · S/N D-8890N779DGlendaloch Partners Lp · El Reno, OKBuilt 1951 · S/N D-3048N779DBAirjohn LLC · Cheyenne, WYBuilt 1985 · S/N TJ-489N779MMMartin James D · Graford, TXBuilt 1963 · S/N TC-470N779NMCallahan Mfg Inc · Royal City, WABuilt 1967 · S/N TC-1053N779RBRbi Trading LLC · Morton Grove, ILBuilt 1966 · S/N D-8244N77ABEmap Aviation LLC · Tavernier, FLBuilt 1968 · S/N CJ-12N77ACEagle Aviation Consulting LLC · Wilmington, DEBuilt 1991 · S/N E-2675N77AWRose Timothy A · Hickory, MSBuilt 1961 · S/N TC-187N77BJHint Peter T · Centerport, NYBuilt 1974 · S/N D-9698N77CLDopfel Bruce E · Belle Plaine, KSBuilt 1967 · S/N TE-275N77CSRay Charles L · Hayti, MOBuilt 1977 · S/N CE-741N77CYN77cy LLC · Lambertville, MIBuilt 1974 · S/N D-9678N77DADuncan Aviation Inc · Lincoln, NEBuilt 1992 · S/N CE-1649N77DCOmega 377 Pennsylvania LLC · Shavertown, PABuilt 1985 · S/N E-2289N77EFAviation Business Corp · Saint Louis, MOS/N P-379N77FHCumbey Joseph S · Scroggins, TXBuilt 1977 · S/N D-10035N77FLMeyer Adnrew J · Clear Lake, IAS/N TD-545N77GFSkydancer LLC · Evergreen, COBuilt 1986 · S/N CE-1101N77GVBon Vol Ltd · Joliet, ILFirst renewal noticeBuilt 1964 · S/N D-7693N77HCHlh Properties LLC · Cohutta, GABuilt 1998 · S/N E-3189N77HTLac Aero LLC · Liberal, KSBuilt 1978 · S/N E-1324N77JBSilmi Amjad · Fremont, CABuilt 1968 · S/N TE-563N77JEEngelhardt John L · Netarts, ORBuilt 1977 · S/N E-1080N77KAHostetler Adam D · Dayton, VABuilt 1969 · S/N TE-720N77KGPickett Ronald K · Orange Park, FLBuilt 1974 · S/N CE-486N77LMElephants & Airplanes LLC · Wakeforest, NCBuilt 1969 · S/N D-8950N77LVAviacion Del Oeste Inc · Mayaguez, PRBuilt 1980 · S/N TJ-287
Back to AD 99-05-13 R1 WD