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.

N2106LCht Corp · Lake Forest, CABuilt 1976 · S/N E-878N2106WGemma Aviation LLC · Duncan, SCBuilt 1973 · S/N M-1474N2107LN2107l LLC · Mishawaka, INBuilt 1976 · S/N E-879N2107WIguana Aviation LLC · Chicago, ILBuilt 1973 · S/N M-1437N2108DN2108d LLC · Sheridan, WYBuilt 1953 · S/N D-3453N210JLLopez Javier Jimenez · San Antonio, TXBuilt 1985 · S/N E-2208N210MKKhosravi Muhsin · Kansas City, KSS/N P-369N210QSkydog Air LLC · Lexington, SCBuilt 1957 · S/N BA-291N210RMace Steven B · Ocala, FLBuilt 1967 · S/N D-8463N210SKPray Aviation Inc · Augusta, KSBuilt 1960 · S/N TD-393N210WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N TC-1073N2110Firczak Scott William · Mt Ulla, NCBuilt 1959 · S/N D-5901N2110AWindshear Aviation LLC · Longmont, COBuilt 1977 · S/N TJ-129N2111DKing Kaleb R · Wasilla, AKS/N D-3456N2113LGilbert Ben · Omaha, NEBuilt 1976 · S/N D-9917N2113WMarschke Corey A · Stevens Point, WIBuilt 1973 · S/N M-1441N2114WHippensteel Michael J · Newville, PABuilt 1973 · S/N M1449N2116LHagg Theodoor · Johnson City, TNBuilt 1976 · S/N D-9916N2117DZudeck Austin · Toluca Lake, CABuilt 1953 · S/N D-3462N2117LCottage Grove LLC · Oklahoma City, OKS/N D-9918N2118WWegner John B · Preston, MDBuilt 1973 · S/N M-1491N211AA1776 Aviation LLC · Kalispell, MTBuilt 1976 · S/N TE-1078N211BStone Air LLC · Carrollton, GABuilt 1964 · S/N TC-714N211DRegistered aircraftBuilt 1966 · S/N TC-995N211DGSteel Crazy LLC · Page, AZFirst renewal noticeBuilt 1989 · S/N EA-489N211EBGarrard Mark E · Reno, NVBuilt 1968 · S/N TE-656N211EEV35a Speedsters LLC · Henderson, COBuilt 1968 · S/N D-8888N211FStoltzfus Calvin J · Great Falls, MTBuilt 1963 · S/N TC-514N211MVClark Aviation Inc · Greenville, SCBuilt 1999 · S/N E-3244N211MWGoad Jerry A · Oneida, TNBuilt 1973 · S/N TE-923N211QAIsland Time LLC · Rock Hill, SCBuilt 1953 · S/N D-3564N211VHull Robert Abbott · Payson, AZBuilt 1993 · S/N CE-1754N211YRegistered aircraftBuilt 1966 · S/N TE-169N2120DGray Charles E · Carbon, INBuilt 1953 · S/N D-3465N2120LN2120l LLC · Kansas City, MOBuilt 1976 · S/N TC-1985N2121DSale Reported · Ashland, OHSale reported, canceledBuilt 1953 · S/N D-3466N2121WSambell Warren D · Arlington, TXBuilt 1973 · S/N M1493N2122WRegistration Pending · Ubly, MIRegistration pending, pending cancellationS/N M-1495N2123DCraigmile David N · Monroe, CTBuilt 1953 · S/N D-3468N2123LPanther Air LLC · Alameda, CABuilt 1976 · S/N E-886N2123WSimmons Aeronautical LLC · Springfield, MOBuilt 1973 · S/N M-1496N2124LMax D Watkins Pc · Tulsa, OKS/N D-9920N2124WSerra Joseph I · Inverness, FLBuilt 1973 · S/N M-1497N2125WWittmer Daniel J · Tucson, AZBuilt 1973 · S/N M-1499N2126DValentino Franco · Hendersonville, TNBuilt 1953 · S/N D-3471N2126LLuurtsema Jon A · Alto, MIBuilt 1976 · S/N D-9913N2126WFormanek Carl F · Glen Flora, WIBuilt 1974 · S/N M-1502N2127UFox Robert H · Wyandotte, MIBuilt 1969 · S/N MB-447N2128DAlamo Adrian · Irvine, CABuilt 1953 · S/N D-3473N2128WDelgado David A · Fallbrook, CABuilt 1973 · S/N M-1504
Back to AD 99-05-13 R1 WD