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.

N60ETChankhunthod Anawat · Saratoga, CAS/N TK-57N60FVMp3 Aviation LLC · Nocona, TXBuilt 1975 · S/N P-333N60FXAmeriflight Management Services Inc · Orlando, FLBuilt 1968 · S/N LC-312N60KTTalhelm Timothy A · Flushing, MIBuilt 1948 · S/N D-1912N60LPLowpass Aviation Services LLC · Germantown, TNBuilt 1977 · S/N E-1061N60MLStephens Gary James · Austin, TXBuilt 1976 · S/N D-9955N60NECub Crafters Resale LLC · Yakima, WABuilt 1978 · S/N E-1209N60NKKirchhoefer John D · Orlando, FLBuilt 1969 · S/N LC-328N60NZBlackley Donald W · Cornelius, NCBuilt 1975 · S/N P-339N60RMMartin Bennie D · Garden Ridge, TXBuilt 1977 · S/N D-10048N60SHBas Part Sales LLC · Greeley, COBuilt 1980 · S/N TJ-267N60TZMeadows Christopher · Vestavia Hills, ALS/N CE-729N6100VDickson Bernard G · Chiloquin, ORBuilt 1965 · S/N D-7774N61018Grimes Richard Reid · Hoover, ALBuilt 1982 · S/N MC-776N6105CPaschall Flights LLC · Hailey, IDBuilt 1981 · S/N CE-979N6106VMendoza Cesar · Anthony, NMBuilt 1965 · S/N D-7796N6107NMaclean Rex G · Covington, WABuilt 1969 · S/N M-1192N6108EMid America Sprayers Inc · Ulysses, KSBuilt 1981 · S/N E-1939N6108STorres Jose C · Santa Clarita, CABuilt 1982 · S/N E-1946N6108VMcpherson Richard R Jr · Butler, PABuilt 1965 · S/N D-7776N610EAHarvard Corp · Hartford, CTBuilt 1969 · S/N TE-719N610KGN610kg LLC · Tampa, FLBuilt 1957 · S/N D-5412N610QMarashi Farhad · Kingwood, TXBuilt 1959 · S/N D-5821N610WMWilber Christian B · Waukesha, WIS/N WA-64N6110XVitale Matthew W · Lithia Springs, GAS/N M-2347N6111MBeech Club LLC · Lacrosse, INBuilt 1965 · S/N D-8033N6112VSlifkin Richard · Forest Hills, NYBuilt 1965 · S/N D-7778N6113ADelianides Aris Philip · Virginia Beach, VABuilt 1981 · S/N E-1941N6113DMurfin Drilling Co Inc · Afton, OKS/N E-3513N6113NKrabill Ronald D · Halsey, ORBuilt 1969 · S/N M-1199N6114NSabourin David R · Draper, UTBuilt 1969 · S/N M-1200N6114VMarc Inc · Bolton, MSBuilt 1965 · S/N D-7780N6115VLloyd Timothy S · Yorba Linda, CABuilt 1965 · S/N D-7781N6116VDoyle George H III · Anthony, NMBuilt 1965 · S/N D-7782N6119UQureshi Arif · Dansville, NYBuilt 1981 · S/N E-1948N611DRK & A Solutions LLC · Summerfield, NCS/N DH-274N611MWolf Thomas James Trustee · Simi Valley, CABuilt 1960 · S/N D-6310N611QLucky Star Farms LLC · Stuart, FLS/N D-5248N611RSWickman William S · Mckinleyville, CABuilt 1976 · S/N E-982N611WFly Whiskey LLC · Fitzgerald, GABuilt 1968 · S/N TE-509N6120VDraw Holdings LLC · Meridian, TXBuilt 1965 · S/N D-7783N6123NPfisters Flying Wahine · Waialua, HIBuilt 1969 · S/N MB-409N6123VWings Over La Aviation LLC · Van Nuys, CABuilt 1965 · S/N TD-613N6123XBuffalo Aviators LLC · Denver, COBuilt 1981 · S/N D-10385N6124NPacific Coast Air Museum · Santa Rosa, CABuilt 1968 · S/N MB-410N6125JBo LLC · Birmingham, ALBuilt 1982 · S/N E-1949N61278Aerospace Trust Management LLC Trustee · Wilmington, DES/N 4859N612HClear Sound Hearing LLC · Sedalia, MOBuilt 1972 · S/N TE-860N612PZLovrencevic Mark · Hanford, CABuilt 1983 · S/N E-2108N612QWeisenseel Charles William · Bandon, ORBuilt 1957 · S/N D-5375
Back to AD 99-05-13 R1 WD