OpenAirDocs.org
AD 2000-25-02 R1

Registered aircraft · 7,563

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:2000-25-02-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-25-02-R1')
  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.

N86219Quast Felix E · Winsted, MNBuilt 1946 · S/N 11AC-23N86221Page Tony G · Hammon, OKBuilt 1946 · S/N 11AC-25N86223Stevenson George G · Scio, ORS/N 11AC-27N86224See J William · Topeka, ILRevoked, canceledBuilt 1946 · S/N 11AC28N8622VHoneycutt Aviation Inc · Olivehurst, CABuilt 1975 · S/N 172-75N86232Wasnik Richard J · Munnsville, NYBuilt 1946 · S/N 11AC-36N8624VMccoard Paul · Provo, UTBuilt 1975 · S/N 810-75N86250Henry Joseph R · Elizabeth, WVBuilt 1946 · S/N 11AC-54N86252Reek David A · Emmett, IDBuilt 1946 · S/N 11AC58N8625VLemaire Jonathan D · Taunton, MABuilt 1975 · S/N 191-75N86266Anding Catherine C · Bryan, TXFirst renewal noticeS/N 11AC-71N8626VAlaska Star Flying Club LLC · Wasilla, AKBuilt 1975 · S/N 312-75N86270Curley Paul T · Wilmington, NCBuilt 1946 · S/N 11AC-75N86271Bouten Glenn A · Kasilof, AKBuilt 1946 · S/N 11AC-76N86272Turf Birds LLC · Zelienople, PABuilt 1946 · S/N 11AC-77N86273Harder Alan N · Terre Haute, INS/N 11AC-78N86278Veley Larry D · Chickasha, OKBuilt 1946 · S/N 11AC-83N8627VDunleavy John R · Mandeville, LABuilt 1975 · S/N 811-75N86286Stewart Emerson C · Waynesville, OHS/N 11AC-92N86287Hryniewicki Walter E · Jim Falls, WIBuilt 1946 · S/N 11AC-93N8628VKemp Charles D · Fredericksburg, TXBuilt 1975 · S/N 1086-75N86295Houser Teddy W · Lincolnton, NCS/N 11AC-101N86296Brewer Michael A · Fort Wayne, INBuilt 1946 · S/N 11AC-102N8629VHorvath Stephen L · Lake City, MIS/N 1087-75N862ACMadelaire LLC · Bow, NHBuilt 2000 · S/N 862-2000N86301Morozowsky John S · Zanesville, OHBuilt 1946 · S/N 11AC-107N86304Stanton Dennis W · Loogootee, INBuilt 1946 · S/N 11AC110N86307Mcatee Mark D · Casper, WYBuilt 1946 · S/N 11AC-113N86310Raymond R Brock · Crescent, IABuilt 1946 · S/N 11AC-114N86313Starfire Aviation LLC · Conyers, GABuilt 1946 · S/N 11AC-119N86314Mull Floyd D · Granbury, TXBuilt 1946 · S/N 11AC-120N86317Vogel Zachary S · Miamisburg, OHBuilt 1946 · S/N 11AC124N86318Rhoades David M · Wichita, KSBuilt 1946 · S/N 11AC-123N86319Zuleger John E · Minneapolis, MNBuilt 1946 · S/N 11AC-125N8631VBeving Charles J · Garden City, SDBuilt 1975 · S/N 822-75N86321Brooks Alan G · Kernersville, NCBuilt 1946 · S/N 11AC-127N86323Woody Leslie H · Alexandria, MNBuilt 1946 · S/N 11AC-129N86326Foley Kyle T · Longmont, COBuilt 1946 · S/N 11AC-132N86328Werner Duane Charles · Meadowlands, MNBuilt 1946 · S/N 11AC-133N8632VLindgren Steven D · Holyoke, COBuilt 1975 · S/N 813-75N86331Hart John C · Sheridan, ORBuilt 1946 · S/N 11AC137N86333Bogner Ranch Inc · Oelrichs, SDBuilt 1946 · S/N 11AC-139N86335Mehrer Kelly L · Apex, NCS/N 11AC-141N86337Agaliotis Paul E · San Martin, CAS/N 11AC-144N86339Adam Emma K · East Canaan, CTBuilt 1946 · S/N 11AC-147N8633VDe Rouchey Louis E · Yreka, CABuilt 1975 · S/N 506-75N86342Harding Robert L · Nine Mile Falls, WABuilt 1946 · S/N 11AC-150N86343Knight Aaron P · Marion, INS/N 11AC-151N86348Marvin Benjamin C · Wasilla, AKBuilt 1946 · S/N 11AC-157N8634VKoykka Kevin P · North Wildwood, NJBuilt 1975 · S/N 814-75
Back to AD 2000-25-02 R1