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.

N2375LEdgren Alan J · Punta Gorda, FLBuilt 1963 · S/N M-223N2375QTaxes Suck LLC · Orlando, FLBuilt 1963 · S/N M-449N2375ZMorrissett Jay Dean · Bumpass, VABuilt 1962 · S/N M-99N2376JWinstead Jonathan M · Griffin, GABuilt 1963 · S/N M-339N2376LRbg Aviation LLC · Middleburg, FLBuilt 1963 · S/N M-212N2376QEisenmann James R · Fort Worth, TXBuilt 1963 · S/N M-450N2377LBarnes Matthew · Cost, TXS/N M-217N2378ZMugleston Tim H · Waldport, ORBuilt 1962 · S/N M-102N237DCHinkle Airspray Inc · Cavalier, NDBuilt 1978 · S/N TJ-133N237SColey Douglas E · Mchenry, ILBuilt 1965 · S/N D-7841N237TDBodily Lorin D · Brigham City, UTS/N TD237N23822Platt James Wesley · Bushnell, FLBuilt 1977 · S/N E-1089N23824American Lighthouse Transportation Inc · Dry Ridge, KYBuilt 1977 · S/N M-1999N2382LRadloff Nicholas R · Fort Atkinson, IABuilt 1963 · S/N M-222N23830Klosterman Jack L · Cincinnati, OHBuilt 1978 · S/N M-2002N2383AAero Traveler Ltd · Warminster, PABuilt 1969 · S/N D-9034N2383WMcclure Miles · Vancouver, WAS/N MB-18N2384JEdwards Isaac J · Glen Ellyn, ILBuilt 1963 · S/N M-342N2384QTailwind Ventures LLC · Three Rivers, MIS/N M-464N23851Giordano Kim O · Foxboro, MABuilt 1978 · S/N M-2006N23859Fu Jinlin · Olympia, WABuilt 1976 · S/N MB-811N2386ZHoffman Kurt T · Savannah, GABuilt 1962 · S/N M-109N2388ZKoehler Brian L · Washington, IAS/N M-94N2389WCherney Cody L · Belleville, KSBuilt 1966 · S/N MB-24N238DSRegistration Pending · Plainwell, MIRegistration pendingBuilt 1987 · S/N CE-1146N238SAJmm Capital LLC · Fort Worth, TXBuilt 2000 · S/N E-3321N238YWright Jeffrey C · Canby, ORBuilt 1939 · S/N 272N2390LTsiouklas Anthony P · Dunedin, FLBuilt 1963 · S/N M-235N2390QLatia Douglas C · Lafayette, INS/N M-471N2390WNgk Aviation LLC · West Point, NEBuilt 1966 · S/N MB-28N2390ZTicen Jeffrey L · Chalmers, INBuilt 1962 · S/N M-113N2391WShanahan Jolene D · Upper Lake, CAS/N MB-29N2392LLindell Tom R · Cashmere, WAFirst renewal noticeBuilt 1963 · S/N M-237N2392ZVancleave Nate M · Yazoo City, MSBuilt 1962 · S/N M-115N2393JHunter John C · Saint George, UTS/N M-360N2393LPolitte Brian · Festus, MOS/N M-238N2394ZBlue Max Aero Club Ltd · Onalaska, WIBuilt 1962 · S/N M-117N2395WRegistration Pending · Leavittsburg, OHRegistration pendingS/N MB-26N23963Flanegan Charles E Jr · Jonesboro, GABuilt 1977 · S/N MB-827N23966Misbe Darrell James · Pierz, MNBuilt 1977 · S/N M-1996N2396QPhantom Works Flying Club Inc · Saint Peters, MOBuilt 1963 · S/N M-475N2396ZSouthard Toby J · Beaver Dam, KYS/N M-119N23976Brazdys Luke V · Kingman, AZBuilt 1977 · S/N M-1900N23979Grounds Cameron · Sachse, TXBuilt 1977 · S/N M-1908N2397EMaine Instrument Flight · Augusta, MEBuilt 1977 · S/N M-1949N2397LOliver Michael · Palmer, AKS/N M-242N2397WMigliorini William E · Granville, ILBuilt 1966 · S/N MB-27N23982Maine Instrument Flight · Augusta, MES/N MB-831N23986Mcintyre Joel · Greensboro, NCBuilt 1977 · S/N M-1910N2398QLee Kitchell · Shelburne Falls, MABuilt 1963 · S/N M-477
Back to AD 99-05-13 R1 WD