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.

N7387BMclenaghan Alvin N · Phoenix, AZS/N D-3850N7388BJohnson Carl · Chico, CAS/N D-3871N7388RPeitz Russell W · Sebring, FLBuilt 1974 · S/N E565N7389BL And P Air LLC · Lees Summit, MOS/N D-3883N738BPockrus Pat B · Mineral Wells, TXBuilt 1948 · S/N D-1744N738WBNord Aviation Inc · Pembina, NDBuilt 1960 · S/N DH-286N7390BWitthuhn Johnie B · Callaway, NEBuilt 1954 · S/N D-3852N7391REdm Corporation · Nevada, MOBuilt 1974 · S/N D-9651N7392RJohnson Franklin H · Tyler, TXBuilt 1974 · S/N E-579N7394BShepherd Flight Collective LLC · Rockwall, TXBuilt 1954 · S/N D-3851N7395BMaag Dallas N · Nampa, IDBuilt 1954 · S/N D-3856N7396BHulsey Ryan · Cleveland, GABuilt 1954 · S/N D-3872N7396RBaja Aviation LLC · Northbrook, ILBuilt 1974 · S/N E-580N7397RWest Michael P · Colusa, CABuilt 1974 · S/N D-9654N7398BDixson James S II · Gonzales, TXS/N D-3855N7399BMahoning Co Career & Tech Center · Canfield, OHBuilt 1954 · S/N D-3859N739DSchaak William N · Billings, MTBuilt 1951 · S/N D-3009N739JGrace Mollie B · Batesville, ARBuilt 1978 · S/N M-2091N739MPArnold Nelson Aviation Inc · Saint Paul, MNBuilt 1965 · S/N D-7817N73AAStorey Malcolm E · Houston, TXBuilt 1961 · S/N D-6656N73DEHill Christopher Michael · Linden, TXBuilt 1976 · S/N D-9909N73FPDunn Frederick C Jr · Fayetteville, GABuilt 1968 · S/N CJ-5N73HW73 Hotel Whiskey Llp · West Fargo, NDBuilt 1979 · S/N TJ-223N73JWKiang Justin · Simi Valley, CABuilt 1974 · S/N TE-982N73KMThomas Jackson S · Baton Rouge, LABuilt 1965 · S/N TC-935N73MDReed Henry J · Jacksonville, NCS/N MB-226N73MKKauffman Nicole A · Lincoln Park, NJBuilt 1966 · S/N TE-153N73MVPlantation Air LLC · Spartanburg, SCS/N E-3583N73RHBradley A Eli Dental Corp · Encinitas, CABuilt 1973 · S/N D-9487N73SMBrown Michael · Gardnerville, NVS/N E-2961N73VBVb Aviation LLC · Mount Pleasant, SCBuilt 1973 · S/N D-9534N74010Nogle Charles H · Champaign, ILS/N G-103N7419WBaker Terry · Mesa, AZBuilt 1977 · S/N M-1973N741ESSmith Edward B · Slidell, LABuilt 1981 · S/N E-1915N741JBBrendel James G · Scottsdale, AZBuilt 1968 · S/N D-8701N741LFValley Aviation Inc · Lake Lillian, MNBuilt 1979 · S/N E-1529N741RVInternational Fun Place Hangar 32 LLC · Laughlin, NVBuilt 1987 · S/N CE-1198N7420DMajeste Air LLC · Loveland, COBuilt 1970 · S/N P-134N742DKaurich Steven · O Brien, FLBuilt 1953 · S/N D-3412N742NEPotkulski Daniel M · Locust Grove, GABuilt 1978 · S/N TK82N743BSauls Emily A · La Vernia, TXBuilt 1948 · S/N D-1749N743TIsr Aviation LLC · Lewes, DEBuilt 1976 · S/N E-802N7444Tytex LLC · Dallas, TXS/N E1520N7444SBlkbrdz LLC · Grand Ledge, MIS/N D-8803N744BGraves Bryan G Sr · Madisonville, TNBuilt 1948 · S/N D-1750N744PZHemmingway Gray Inc · Los Gatos, CABuilt 1981 · S/N TJ-382N744TIverson Walter P · Nancy, KYBuilt 1977 · S/N TE-1096N744UJApproach Aviation LLC · Marion, OHBuilt 1968 · S/N TE-568N745DWjs Business Development Consulting LLC · Gainesville, GABuilt 1951 · S/N D-3015N745TStoneman Thomas K · Friendswood, TXBuilt 1973 · S/N TE-900
Back to AD 99-05-13 R1 WD