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.

N7911RBelinski Jason J · Woodbridge, VAS/N TE-622N7912LMiller Cameron · Loomis, CAS/N MB-129N7913DOstwinkle Robert J · Mormon Lake, AZBuilt 1957 · S/N D-5161N7913RBeadle Steve E · El Paso, TXBuilt 1969 · S/N CJ-19N7914DLosee Dan · Lehi, UTBuilt 1957 · S/N D-5198N7914LHumble Aviation LLC · Russellville, ARS/N MB-131N7914RFrith Smith Michael J · Bishop, CABuilt 1969 · S/N D-8943N7915RWoods Todd Ryan · Perry, OKBuilt 1969 · S/N D-8941N7917KStratospheric Flyers Group Inc · Louisville, KYBuilt 1964 · S/N D-7416N7917RPh Air LLC · Turners Falls, MAFirst renewal noticeBuilt 1969 · S/N D-8940N7918DGolden Stephen J · Berkeley Springs, WVBuilt 1957 · S/N D-5146N7919DCarroll Aviation LLC · Kissimmee, FLBuilt 1957 · S/N D-5149N791AABonanza Paradise LLC · Queen Creek, AZBuilt 1979 · S/N E-1609N791JBFrylock LLC · Hurricane, UTBuilt 1961 · S/N TC-273N791Q791q LLC · Rock Springs, WYBuilt 1969 · S/N TE-724N791TAerotwin Maui LLC · Kahului, HIBuilt 1960 · S/N TD-392N791VWGreenawalt Bryan M · Durham, NCBuilt 1958 · S/N D-5570N7920LOstrom Richard A · Sterling Hts, MIBuilt 1966 · S/N MA-103N7920MWirt John P · Lake Havasu City, AZBuilt 1980 · S/N E-1714N7921DSmith Lee Holdings LLC · Oklahoma City, OKBuilt 1957 · S/N D-5167N7921KFrieders Bryan · Thompsons Station, TNBuilt 1964 · S/N D-7713N7921MMiller Dennis J · Bartlett, TNBuilt 1966 · S/N D-8251N7922KChand Jaison A · Astoria, ORBuilt 1964 · S/N D-7456N7922MDestination Aero LLC · Lubbock, TXBuilt 1966 · S/N D-8235N7923LTolliver Richard R · Amery, WIBuilt 1966 · S/N MB-137N7924DTimberline Aircraft LLC · Kalispell, MTBuilt 1957 · S/N D-5174N7925DBowers Christian R · Troy, ALBuilt 1957 · S/N D-5209N7925LAdams August G · Southport, NCS/N MA-112N7925MOatman Scott · Colorado Springs, COBuilt 1966 · S/N TE-183N7925RHoward Philip D · Glen Rose, TXBuilt 1969 · S/N D-8949N7926DRegistered aircraftBuilt 1957 · S/N D-5194N7926KOconnell Raymond · Brawley, CABuilt 1964 · S/N D-7421N7927RN7927r LLC · Columbia Falls, MTBuilt 1969 · S/N CJ-20N7928DNovak Warren D G · Lake Placid, FLBuilt 1957 · S/N D-5195N7928LCox Robert Etan · Flippin, ARBuilt 1966 · S/N MA-115N7928RMcveigh Ian · Mansfield, TXBuilt 1969 · S/N TC-1225N792DMDkl Inc · Ardmore, OKBuilt 1966 · S/N D-8354N792QMurphy Ronald O · Greensboro, NCFirst renewal noticeBuilt 1969 · S/N TE-754N7930DGronau Brian · Oxford, OHBuilt 1957 · S/N D-5197N7930LChavez Andrew · Pagosa Springs, COBuilt 1966 · S/N MA-117N7931LZundel Dana John · Watkins, COS/N MA-118N7932MPower James P · Box Elder, SDBuilt 1966 · S/N D-8241N7932RIowa Aircraft Inc · Burlington, IABuilt 1969 · S/N D-8954N7933KCross Marc W · Corpus Christi, TXBuilt 1964 · S/N D-7424N7933RBeech Runner LLC · Wilmington, DEBuilt 1969 · S/N D-8955N7934KNorth Perry Flight Center Inc · Fort Lauderdale, FLBuilt 1964 · S/N TC-648N7935HBaker Clark V · College Station, TXBuilt 1992 · S/N CE-1640N7935RWhitney Frederick C · Hampton, NJBuilt 1969 · S/N D-8960N7936ABb Air Guys LLC · Scott City, KSBuilt 1978 · S/N E-1421N7936DMartin Tully T · Idalou, TXBuilt 1957 · S/N D-5210
Back to AD 99-05-13 R1 WD