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.

N87RRBahnair LLC · Oklahoma City, OKS/N TJ-34N87SPBorabora LLC · Tampa, FLBuilt 1968 · S/N D-8804N8800ABarnes Richard E · Malin, ORBuilt 1950 · S/N D-2222N8800MFlying Leatherheads LLC · Lakeland, FLBuilt 1964 · S/N D-7324N8801MStein Bruce A · Punta Gorda, FLBuilt 1964 · S/N TD-569N8803MFerwerda Beech LLC · Fremont, NHBuilt 1964 · S/N D-7328N8807MCatanese Marc V · Cumberland, RIBuilt 1964 · S/N D-7330N880CANspace LLC · Spicewood, TXBuilt 1973 · S/N TE-934N880TSSolano J Thomas · Ponte Vedra Beach, FLBuilt 1974 · S/N TC-1722N880TWEnvisage LLC · Virginia Beach, VABuilt 1969 · S/N TC-1240N8810ACovert Aero LLC · Warren, VTBuilt 1950 · S/N D-2232N8812MTri-County Ag Service Inc · Ipswich, SDBuilt 1964 · S/N D-7332N8813ALange Eric M · Prescott, AZBuilt 1950 · S/N D-2257N8813MMja Flight LLC · Justin, TXBuilt 1964 · S/N TD-571N8814Eer LLC · Camp Hill, PAS/N TC-1337N8815AMoore Steven L · Glasgow, KYBuilt 1950 · S/N D-2259N8815MGidusko James Patrick II · Hanover, PABuilt 1964 · S/N D-7334N8816XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N CE-489N8818RCrawford Brian L · Surprise, AZFirst renewal noticeS/N D-2397N8819ARegistered aircraftBuilt 1950 · S/N D-2235N881HMiller Leonard L · Houston, TXBuilt 1972 · S/N TE-883N881RParker Steven L · Many, LABuilt 1960 · S/N D-6290N881SRegistration Pending · Sulphur Rock, ARRegistration pendingBuilt 1973 · S/N CE-454N8822ASellers Ronald C · Knoxville, TNBuilt 1950 · S/N D-2367N8824MHalpern Joseph Robert · Apo, AEBuilt 1964 · S/N D-7344N8826AKirkpatrick Robert Allan · Placerville, CABuilt 1950 · S/N D-2371N8826MAeolus LLC · Portland, MEBuilt 1964 · S/N D-7373N8827MNewport Elite LLC · Newport Beach, CABuilt 1964 · S/N D-7347N882BPalmer Christopher J · Soddy Daisy, TNS/N D-6780N882CCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1989 · S/N CE1345N882CTCharlie Tango Aviation LLC · Rocklin, CABuilt 1990 · S/N E-2566N882RFoss James K · Anchorage, AKBuilt 1960 · S/N D-6291N882TGoing Bonanzas LLC · Scottsdale, AZBuilt 1965 · S/N D-7784N8830ACansler Seth A · Greenville, TXBuilt 1950 · S/N D-2484N8830MRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1964 · S/N D-7348N8831Flyingdriller LLC · Kalispell, MTBuilt 1976 · S/N P-404N88317Watkins Robert H Jr · Huntington Beach, CAS/N B-16N8831ALyons James P · Lake Suzy, FLBuilt 1950 · S/N D-2485N8831MMcmeekin Robert R Jr · Bethesda, MDBuilt 1964 · S/N TD-574N8833AChrzanowski Sigmund J Trustee · Hampshire, ILBuilt 1982 · S/N CE-976N8834MPilots Discretion LLC · Atlanta, GABuilt 1964 · S/N D-7352N8835MKnight Robert T · Baton Rouge, LABuilt 1964 · S/N D-7353N8837AFrisbie Anthony G · Dallas, TXBuilt 1950 · S/N D-2492N8837MNewpower Scott · Seeley Lake, MTBuilt 1964 · S/N D-7346N8839ALove Robert W · King George, VABuilt 1950 · S/N D-2494N883RRegistered aircraftBuilt 1960 · S/N D-6373N883TEasley Toby · Lucama, NCBuilt 1965 · S/N D-7770N8841MBanana Boys LLC · Seattle, WABuilt 1964 · S/N D-7365N8844MNewberry Travis · Niota, TNBuilt 1964 · S/N D-7357N8845MFodor Vincent A · Doylestown, OHBuilt 1964 · S/N TC-596
Back to AD 99-05-13 R1 WD