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.

N9728RHornbeck Jordan D · Oklahoma City, OKBuilt 1959 · S/N D-6145N9728YLarson Kenneth J · Lake Havasu City, AZBuilt 1963 · S/N D-7127N9729LStephen Christina J · Shreveport, LAS/N M-1356N972ETowe Lannie K · Madison, ALBuilt 1969 · S/N TC-1277N972GCInternational Air Services Inc Trustee · Carson City, NVBuilt 1962 · S/N TC-540N972QN972q LLC · Sheridan, WYBuilt 1961 · S/N D-6851N9730LSundowner N9730l LLC · Calhoun, GABuilt 1971 · S/N M-1357N9730QWheat Land Aviation LLC · Andover, KSBuilt 1971 · S/N MC-82N9731LMaine Instrument Flight · Augusta, MEBuilt 1971 · S/N M-1358N9732RPfau Michael G · Princeton, MNBuilt 1959 · S/N D-6211N9733YSs & C Aviation LLC · North Fort Myers, FLBuilt 1963 · S/N TC-419N9734RAces Hangar LLC · Bentonville, ARBuilt 1959 · S/N D-6213N9735YWhalen Mark P · Millington, MDBuilt 1963 · S/N D-7131N9736QGregory Charlie E · Blairsville, GABuilt 1971 · S/N MC-88N9736RGet Happy Adventures LLC · Leawood, KSBuilt 1959 · S/N D-6203N9736YAshura-Smith Mary F · Steamboat Springs, COBuilt 1963 · S/N D-7132N9737LSzish Michael · Mountain Top, PABuilt 1972 · S/N MB-524N9737QSierra Tn Aviation LLC · Vonore, TNBuilt 1971 · S/N MC-89N9738RNathan Price · Crawfordsville, INBuilt 1959 · S/N D-6217N9739RKinkade John T · Gallatin, TNBuilt 1959 · S/N D-6218N973LBLcnic LLC · Wilmington, DEBuilt 1968 · S/N TE-557N973PCTennessee Beach Boyz LLC · Soddy Daisy, TNBuilt 1992 · S/N E-2698N973SThompson Peter L · Portales, NMBuilt 2001 · S/N EA-688N9740RTonge Gregory Charles · Wenatchee, WABuilt 1959 · S/N D-6219N9741RDoble Michael P · Waukesha, WIBuilt 1959 · S/N D-6220N9742QMese Jacob L · Savannah, GABuilt 1971 · S/N M-1313N9743LSundowner Rental Options LLC · Lawrenceville, GABuilt 1971 · S/N M-1371N9744QLong Richard · Sebastopol, CABuilt 1970 · S/N M-1314N9744YDouble P Creative LLC · Pleasanton, TXBuilt 1963 · S/N D-7141N9745RBykerk John C · Springfield, ORS/N D-6226N9746QJones Rea V · Maple, NCBuilt 1971 · S/N MC-93N9747RAmundson James Robert · South Lake Tahoe, CAS/N D-6228N9747YRichardson LLC · Henderson, NVBuilt 1963 · S/N D-7136N9748QSchwanke Timothy Michael · Enid, OKBuilt 1971 · S/N MB-522N9748RVinson Lonnie Eugene Jr · Oceanside, CABuilt 1959 · S/N D-6229N9749QKyle Edwards LLC · Seneca, SCBuilt 1971 · S/N M-1363N9749YMckenney Brett K · Billings, MTBuilt 1963 · S/N TC-429N974CCPlane Fun Inc Tr Trustee · Snellville, GABuilt 1964 · S/N D-7498N974CPSale Reported · Wilmington, DESale reportedBuilt 1975 · S/N TE-1050N974QBailey Jerry D · Sulpher, OKBuilt 1961 · S/N D-6849N975J&H Aircraft Leasing LLC · Berrien Springs, MIBuilt 1977 · S/N TC-2056N9750CJv Aviation LLC · Johnston, RIBuilt 1973 · S/N D-9469N9750RMiletta Anthony · Beloit, OHS/N D-6232N9752LHickox Richard E · Las Cruces, NMBuilt 1971 · S/N MC-102N9752RChristensen Craig H · Webster, MNBuilt 1959 · S/N D-6240N9753RMasterson James Patrick · Aptos, CAS/N D-6241N9754RStrojny Andrew P Jr · Strongsville, OHBuilt 1959 · S/N D-6248N9755LClendenen William M · Spencer, TNBuilt 1975 · S/N MC-104N9755RSalisbury Ronald · Newport Beach, CABuilt 1959 · S/N D-6250N9756REstes Aviation LLC · Vicksburg, MSBuilt 1959 · S/N D-6251
Back to AD 99-05-13 R1 WD