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.

N2300JRadosevich Michael K · Albuquerque, NMBuilt 1963 · S/N M-246N2300LAv8n Idaho LLC · Greenleaf, IDBuilt 1962 · S/N M-112N2301LMuskrat Flying Club LLC · Orlando, FLBuilt 1963 · S/N M-122N2301ZRegistration Pending · Maumee, OHRegistration pendingBuilt 1962 · S/N M-4N2302CDuck & Goose Aviation Inc · St Simons Island, GABuilt 1997 · S/N E-3102N2302ZJohnson Melvin L · Toney, ALBuilt 1962 · S/N M-5N2303QVan Hoosen Ronald L · Goldsby, OKBuilt 1963 · S/N M-369N2303VFindlay Fly Boys LLC · Findlay, OHBuilt 1998 · S/N E-3168N2303ZBeech Aero Club · Ashburn, VABuilt 1962 · S/N M-6N2304LJohnson Diversified LLC · East Lansing, MIBuilt 1963 · S/N M-125N2304QAviation Business Corp · Saint Louis, MOBuilt 1963 · S/N M-356N2305WRobison Charles R · Big Spring, TXBuilt 1965 · S/N M-907N2306QVanderwielen Joseph M · Neenah, WIBuilt 1963 · S/N M-358N2306WFreeman Darrell · Tacoma, WABuilt 1965 · S/N M-908N2307CStuffmann Eric S · Orinda, CABuilt 1997 · S/N E-3107N2307JMidwest Kilo Delta LLC · Clara City, MNBuilt 1997 · S/N EA-607N2307LZamel Andre · Sunrise, FLBuilt 1962 · S/N M-128N2307QWinters Jeffrey · Olathe, KSBuilt 1963 · S/N M-367N2307WMitchell Kenneth M · Saint Jacob, ILS/N M-909N2308JMcgary Blaine J · Pasco, WABuilt 1963 · S/N M-259N2308WLach John J · Austin, TXBuilt 1965 · S/N M-910N2309QBorja Nicholas F · Freeburg, ILBuilt 1963 · S/N M-373N230BBBishay Motors & Leasing Inc · Norwood, MAS/N P-460N230DAHot Seat Aviation · Blacksburg, VAS/N TC-387N230DDStrobe 33 LLC · Houston, TXBuilt 1978 · S/N CE-835N230EASea Hawk Airways LLC · Largo, FLS/N E-3530N230QKuper Carl J II · Dalhart, TXBuilt 1966 · S/N TE-278N2310JRegistration Pending · Aberdeen, SDRegistration pendingBuilt 1963 · S/N M-261N2310QPeterson Kevin · Roseville, CABuilt 1963 · S/N M-374N2311QHagy Thomas Lee · Abingdon, VABuilt 1963 · S/N M-375N2311VB & L Henry LLC · Chipley, FLBuilt 1997 · S/N E-3111N2312LSumerau Robert L IV · Lexington, SCBuilt 1963 · S/N M-138N2312QMiller Kevin · Dover, DES/N M-376N2312ZDfr LLC · Giltner, NEBuilt 1962 · S/N M-35N2314JAce Aviation Seminars LLC · Armuchee, GABuilt 1963 · S/N M-377N2314LSale Reported · Brunswick, OHSale reported, canceledBuilt 1963 · S/N M-140N2314WHansen Robert J · Bainbridge, INBuilt 1965 · S/N M-915N2316LCarrigan Sean P · Slidell, LABuilt 1963 · S/N M-142N2317LAdamiak Jeffrey · Mount Laurel, NJBuilt 1963 · S/N M-143N2317SSokoloff James T · Cambridge, MAS/N E-3117N2317VMay-Collier Aviation LLC · Atlanta, GABuilt 1998 · S/N E-3164N2318ATarpley Gary H · Seaford, VABuilt 1997 · S/N E-3118N2318ZCrosson Ronda L · Corinth, MEBuilt 1962 · S/N M-45N2319WWinstead Walley K · Leavenworth, KSBuilt 1965 · S/N MB-1N231BBlue River Holdings LLC · Hugo, OKBuilt 1956 · S/N D-4651N231RLumair LLC · Northville, MIFirst renewal noticeBuilt 1980 · S/N CE-917N231SVinegaroon Aviation LLC · Franklin, TNBuilt 1966 · S/N D-8058N231WEJones Jason Bart · Frankfort, ILBuilt 1980 · S/N TJ-263N231ZHolland Douglas A · Wichita Falls, TXBuilt 1962 · S/N TC-370N2320AStructural Integrity Systems LLC · Wichita, KSBuilt 1977 · S/N TC-2113
Back to AD 99-05-13 R1 WD