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.

N5268Evans Eric A · Saint Peter, MNBuilt 1955 · S/N G-825N52686Heartland Aviation LLC · Ada, OKS/N 4882N526BPutnam Michael C · Topeka, KSBuilt 1948 · S/N D-1541N526PHangar Four LLC · Blue Ridge, GAS/N E-603N526PMMccandless Malinda Sue · Sussex NbFirst renewal noticeBuilt 1973 · S/N TC-1507N5270CLohr David C · Wrightwood, CABuilt 1950 · S/N D-2664N5271CSale Reported · Davis, CASale reported, pending cancellationBuilt 1951 · S/N D-2665N5272CDiehl Ross E · Chino, CABuilt 1951 · S/N D-2666N5278CMoore Louis · Rutland, VTBuilt 1951 · S/N D-2672N527MLMoss Herman D · Centreville, VABuilt 1966 · S/N TE-217N527QSilver Linings Air And Farm LLC · Chamblee, GABuilt 1968 · S/N LC-284N527RABonanza Parts Inc · Davis, CAS/N D-4213N527RSLookout Mountain LLC · Mill Valley, CABuilt 1999 · S/N E3222N527TFlying H Enterprises LLC · Smithville, MOBuilt 1964 · S/N TC-576N527TCLeonardo Paul A III · Merced, CABuilt 1991 · S/N EA-527N5282COrr Kent C · Kearney, NES/N D-2676N5283MPskd Limited LLC · Upland, CABuilt 1978 · S/N ME-25N5285CElkins Quentin D · Andersonville, TNBuilt 1951 · S/N D-2679N5286MSwift Aviation LLC · Silverdale, WABuilt 1978 · S/N MC-570N5289MHardy Caitlin M · Woodinville, WABuilt 1978 · S/N M-2021N528EWNc Aviator LLC · Fuquay Varina, NCBuilt 1989 · S/N CE-1375N528LCSaunders Michael · Argyle, TXBuilt 1963 · S/N TC-509N528PLebanon Air Taxi LLC · Hanover, NHBuilt 2004 · S/N E-3565N528TTaylor Edith E · Como, NCBuilt 1964 · S/N TD-573N5294Brown Kevin Lee · Broseley, MOBuilt 1971 · S/N MC-94N52962Worlds Greatest Aircraft Collection Inc · Polk City, FLBuilt 1944 · S/N 6880N5298CCheshire Derek L · Mercer Island, WABuilt 1951 · S/N D-2682N529BBCarnahan Charles Christopher · Wentzville, MOBuilt 1955 · S/N D-4250N529CCC747 LLC · Wilmington, DEBuilt 1969 · S/N TC-1230N529DDSchwertfeger Dean · Woodruff, WIBuilt 1970 · S/N D-9151N529JAAnton Aaron · Poplar Grove, ILBuilt 1965 · S/N TD-617N529PHoffman Andrew · Martinsville, INBuilt 1961 · S/N D-6686N529RBBusby Ralph H III Trustee · Newport, ORBuilt 1960 · S/N TD-417N529SARaptorsair LLC · Mchenry, ILBuilt 2001 · S/N E-3429N52AAWebster Patrick Edward · Elk Grove, CABuilt 1975 · S/N MB-760N52AUUllman Aaron L · Barksdale Afb, LABuilt 1967 · S/N D-8484N52CEUlmer Ken W · Houston, TXS/N E-3495N52DNAir Apparent Aviation LLC · Plant City, FLBuilt 1952 · S/N A-846N52HCOak Bay Aviation LLC · Bellvue, WABuilt 1980 · S/N TJ-274N52JMJetstar Aviation Group LLC · Norlina, NCBuilt 1980 · S/N TC-2309N52KTMontgomery Transit LLC · Fulton, MSS/N E-3391N52LGGroom Lincoln · Wadmalaw Island, SCBuilt 1991 · S/N CE-1627N52LVAltair Aircraft LLC · Gainesville, FLBuilt 1971 · S/N MC-22N52MBRoark Dale L · Cheyenne, OKS/N TE-395N52RARennenkampf Erik J · Columbia, MDBuilt 1974 · S/N M-1626N52SBRedwood Oil Co Inc · Rohnert Park, CABuilt 1978 · S/N E-1274N52SCTaylor Aaron Lee · Salado, TXBuilt 1965 · S/N TC-951N52TADowell Thomas · New Smyrna Beach, FLBuilt 1963 · S/N TC-442N52TZTurley Dale R · Poway, CABuilt 1988 · S/N CE1297N52VBHarral Vaughn R · Prescott Valley, AZBuilt 1964 · S/N TC-560
Back to AD 99-05-13 R1 WD