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.

N9822RHawkins Albert W · Santa Maria, CABuilt 1960 · S/N D-6353N9823RLettunich John William Jr · Wild Horse, COS/N D-6343N9826RJacques Jeffrey P · Spokane, WABuilt 1960 · S/N D-6332N9828RHarbin Billy C · Floydada, TXBuilt 1960 · S/N D-6352N9830RPollock Craig D · Walnut Creek, CABuilt 1960 · S/N D-6349N9831RFreilich Richard E · Sugar Land, TXBuilt 1960 · S/N D-6340N98339Carlson Jeremy · Yucaipa, CABuilt 1968 · S/N MA297N9833RL&M Aircraft Inc · Rome, GABuilt 1960 · S/N D-6357N9834RBailey Eugene P · Dickinson, TXBuilt 1960 · S/N D-6363N9835RAviation Hangar LLC · Wentzville, MOBuilt 1960 · S/N D-6359N9836PTurbo Property LLC · Clovis, CABuilt 1998 · S/N E-3169N9836SForest Kevin · Langdon, NDBuilt 1998 · S/N E-3210N9837RWinn Larry V · Tucson, AZBuilt 1960 · S/N D-6369N983DBBunke Jim Bradley · Denver, COBuilt 2000 · S/N EA-657N983GTOne Echo Romeo Inc · Sandy Springs, GABuilt 1988 · S/N CE-1295N9842REdelman Freddie L · Manlius, NYBuilt 1960 · S/N D-6374N9843RRegistered aircraftBuilt 1960 · S/N D-6361N9844RAlsworth John H · Anchorage, AKBuilt 1960 · S/N D-6376N9846RSmith Louis · Dundee, NYBuilt 1960 · S/N D-6379N9847RWininger Floyd W · Duncan, OKBuilt 1960 · S/N D-6380N9848RStark James E · Mansfield, TXBuilt 1960 · S/N D-6381N9849RSmith Tyler · Vancouver, WABuilt 1960 · S/N D-6382N984QSpring Lake Aviators LLC · Quincy, ILS/N TC-197N9850RLeffingwell Thomas W Jr · Wilton Manors, FLBuilt 1960 · S/N D-6401N9852REverready Aviation LLC · Dickson, TNBuilt 1960 · S/N D-6400N9853RDwight Hawkins H · Allen, TXBuilt 1960 · S/N D-6404N9856RMcgrath Stephen · Hawley, PABuilt 1960 · S/N D-6398N9859RM20 Flying Club LLC · Kansas City, MOBuilt 1960 · S/N D-6406N985QMcdonald Mark R · Laguna Beach, CAFirst renewal noticeBuilt 1961 · S/N D-6847N985SJohnston Thomas · Wasilla, AKBuilt 1959 · S/N BA-476N985SWPietsch Warren A · Minot, NDBuilt 1943 · S/N 4870N9861RRichards Tyler B · Henderson, TXBuilt 1960 · S/N D-6408N9862RIsr Aviation LLC · Wilmington, DES/N D-6409N9865RBeyers Gary L · Temple, TXBuilt 1960 · S/N D-6414N9867RMoyer Thomas L · Fayetteville, GABuilt 1960 · S/N D-6446N9868RClark William T · Spartanburg, SCBuilt 1960 · S/N D-6421N986JVHelfrich Vincent · Lawrence, MAS/N TC-1861N986YDv Aviation Inc · Brainerd, MNBuilt 1985 · S/N E-2233N9870RHoward Flying Service Inc · Clarksdale, MSBuilt 1960 · S/N D-6424N9873HMoyle Lee E · Heyburn, IDBuilt 1943 · S/N 4839N9874RDouglas Donald G · Park Rapids, MNBuilt 1960 · S/N D-6428N9875RPalmer Neal J · West Monroe, LABuilt 1960 · S/N D-6429N9876RValla Jospeh P · Santa Clarita, CABuilt 1960 · S/N D-6431N9876TJr Aviation LLC · Benton, KSBuilt 1975 · S/N E-795N9879RSamuels Marty · Russellville, ARBuilt 1960 · S/N D-6459N987KCAsberry Gregg J · Sidney, ARBuilt 1990 · S/N E-2556N987TReady Aim Flyer LLC · New Castle, DES/N TD-405N987TTEllison Thomas Andrew · Parker, TXBuilt 1993 · S/N E-2776N9881RNowak Christopher G · Douglassville, PABuilt 1960 · S/N D-6439N9882RN9882r LLC · Punta Gorda, FLBuilt 1960 · S/N D-6448
Back to AD 99-05-13 R1 WD