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.

N6752XIyer Vijay · Mammoth Lakes, CABuilt 1980 · S/N TJ-276N6752YPrewitt Grady Lee · Roanoke, VABuilt 1980 · S/N MC-728N6752ZVector USA LLC · Olive Branch, MSBuilt 1981 · S/N ME-340N6753HJsy Aviation LLC · Port Angeles, WABuilt 1983 · S/N EA-395N6753LHaas Edward Leland · Conroe, TXBuilt 1980 · S/N MC-740N67542Haag Neil E · Elgin, SCBuilt 1980 · S/N WA-101N67543Mayer-Llamas Danna M · Santa Cruz, NMBuilt 1944 · S/N 6908N6754WBell Christopher K · Reynoldsburg, OHBuilt 1980 · S/N WA-99N67550Parker R · Oklahoma City, OKBuilt 1944 · S/N 6717N67551Takeoff Holdings LLC · Anchorage, AKBuilt 1983 · S/N E-2119N67555Krl LLC · Longview, TXBuilt 1944 · S/N 6876N6755QAeromed 36 LLC · Cedar Rapids, IABuilt 1984 · S/N E-2162N6756BNortheast State Community College · Blountville, TNBuilt 1980 · S/N M-2276N6756DSarsfield Aviation LLC · Dacula, GABuilt 1980 · S/N TE-1181N67574International Air Services Inc Trustee · Carson City, NVS/N TE-1194N6757DMcdonald Land & Cattle LLC · Muleshoe, TXBuilt 1980 · S/N E-1698N6757XCall One Inc · Clarinda, IABuilt 1980 · S/N WA-118N67586Carwashos LLC · Colorado Springs, COBuilt 1983 · S/N EA-397N6758XAc Green LLC · Athens, OHBuilt 1980 · S/N TK-134N6759CJds Aero LLC · Decatur, TXS/N E-1686N6759GTrademark Services LLC · Vineyard Haven, MABuilt 1980 · S/N E-1682N6759JConrick Charles J IV · Fort Myers, FLBuilt 1984 · S/N CE-1040N675BWFreedman Stephen Eric · Falls Church, VABuilt 1978 · S/N D-10134N675VCroft Lloyd B · Galveston, TXBuilt 1960 · S/N D-6575N67607Bertrand William DBA · Milford, MIBuilt 1980 · S/N E-1750N6764KElemental Energy LLC · Portland, ORBuilt 1983 · S/N E-2102N67677Webb Thomas Allen · Riverside, CABuilt 1944 · S/N 6724N676BHTicknor Rodney J · Bridewater, IABuilt 1983 · S/N E-2121N676TFry Aviation LLC · Piqua, OHBuilt 1963 · S/N D-7248N676TGRick Aviation Inc · Newport News, VABuilt 1964 · S/N TC-676N67716Stimson Frederick C · Harrison, TNBuilt 1944 · S/N 6733N67734York Stanley A · Leetonia, OHS/N 3093N67735Brown James A · Bath, MEBuilt 1944 · S/N 6935N67736Lane Archie G Trustee · Cypress, CABuilt 1943 · S/N 4848N67738Hayden Aviation LLC · Rhome, TXS/N 6914N67769York Stanley A · Leetonia, OHBuilt 1937 · S/N 146N6778NMountain Skylane LLC · Loveland, COBuilt 1983 · S/N E-2127N6778ZSkorina Air LLC · Walla Walla, WABuilt 1959 · S/N D-6033N67799Piper Arrow LLC · Yarmouth, MEBuilt 1984 · S/N EA-433N677BEGoodrich Matthew E · Bainbridge Island, WAS/N E-1090N677CMWiemer Walter T · Cornwall, NYS/N TC-1206N677ZMottram Jacob A · Orange, CABuilt 1965 · S/N TE-14N6780QVaulters Aviation LLC · Coburg, ORBuilt 1984 · S/N E-2128N6784SSbhd LLC · Santa Rosa Beach, FLS/N E-3089N6788CDewn Aviation LLC · Noble, OKFirst renewal noticeBuilt 1983 · S/N E-2090N6789YMcdonough Patrick J · Defiance, OHBuilt 1986 · S/N EA-453N678AJAj Air LLC · Brookfield, WIBuilt 1975 · S/N P363N678DCentral Virginia Aviation Inc · North Dinwiddie, VAS/N D-2951N678EMAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1978 · S/N E-1285N678FChapel On The Bayou Ministries LLC · Raceland, LABuilt 1969 · S/N TE-687
Back to AD 99-05-13 R1 WD