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.

N36434Phillips Aaron W · Fort Scott, KSBuilt 1973 · S/N 275-73N36438Dorman Richard E · Mesa, WABuilt 1973 · S/N 577-73N3644EClifton Joshua M · Marion, INBuilt 1947 · S/N 11AC-1834N3645EBenham Aviation LLC · Enid, OKBuilt 1947 · S/N 7AC-6965N3650EMerrick Joshua B · Wasilla, AKBuilt 1947 · S/N 7AC-6969N3651EBrown Rodney D · Foxworth, MSBuilt 1947 · S/N 7AC-6970N3657EBook Paul A · Richvale, CABuilt 1947 · S/N 7AC-6968N36593Kentucky Stick And Rudder Academy LLC · Springfield, KYBuilt 1973 · S/N 112-73N36594Hayward Casey W · Anchorage, AKBuilt 1973 · S/N 578-73N3659EAnding Paige E · Bryan, TXS/N 7AC-6975N3660EBarbee Michael A · Delaware, OHBuilt 1947 · S/N 11BC-68N36626Farrier John M · Tillamook, ORBuilt 1973 · S/N 411-74N36628Quale David R · Cottage Grove, WIBuilt 1973 · S/N 113-73N3664EKrenzke Stephen E · Fairbanks, AKS/N 11AC-1841N3668EAnderson Richard A · Sycamore, ILBuilt 1947 · S/N 11AC-1844N3675EHaley Robert Jay · Livermore, CABuilt 1947 · S/N 7AC-6985N36768Miller Thomas O · Ingalls, KSBuilt 1973 · S/N 277-73N36773Scootair LLC · Alburgh, VTS/N 395-73N36774Mader David B · Biddle, MTBuilt 1973 · S/N 594-73N3677EBaker Terry L · New Lexington, OHS/N 11AC-1846N3679EEagal Lloyd S · Butler, PABuilt 1947 · S/N 7AC-6988N367DSPetersen Gary Trustee · Walton, NEBuilt 1946 · S/N 7AC-1331N3685EManor Jay G · Broomfield, COBuilt 1947 · S/N 11AC-1848N3686ECarlisle Elizabeth L · Mohnton, PABuilt 1947 · S/N 7AC-6993N3688EEaa Chapter 540 Lancaster County · Smoketown, PABuilt 1947 · S/N 11AC-1849N3689ERegistration Pending · Mechanicsville, VARegistration pendingBuilt 1947 · S/N 7AC-6995N3690ELowe David M · Sacramento, KYBuilt 1947 · S/N 7AC-6996N3692ELangston Charles N · Elberta, ALBuilt 1947 · S/N 7AC-6997N3696EHadfield Brian S · Middleville, MIBuilt 1947 · S/N 7AC-7000N3698EVossman John · New Waverly, TXBuilt 1947 · S/N 7AC-7002N369DMHoll Brian E · Chugiak, AKBuilt 1975 · S/N 830-75N36RSSalerno Michael · Pueblo, COBuilt 1999 · S/N 1280-99N36WMMccleskey Matthew E · Anderson, TXS/N 7AC1837N3700EZero Zero Echo LLC · Lonoke, ARS/N 11AC-1853N3702COlson John D · Eau Claire, WIS/N 7BCM-356N3703CKimball Jeffrey G · Vaughn, WAS/N 7BCM-259N3703EThompson Barrett R · Smyrna, TNBuilt 1947 · S/N 11AC-1855N3706EEvans Robert F · Lafayette, INBuilt 1951 · S/N 11AC-1856N3708EHoffpauir Stanley C · Waller, TXBuilt 1947 · S/N 7AC-7009N3709EPippenger James W · Churubusco, INBuilt 1947 · S/N 11AC-1857N370ACNuza Philip A · Sidney, MEBuilt 2000 · S/N 433-99N3714EStoos Robert A · Lakeland, FLS/N 7AC7013N3716EMagneto Flyers LLC · Alexandria, OHBuilt 1947 · S/N 7AC-7001N3718EBasso Michele · Millbrook, ALBuilt 1947 · S/N 11AC-1860N371ACBloom Thomas C · Henderson, NVBuilt 2002 · S/N 435-2002N371DMCity Of Bakersfield California · Bakersfield, CABuilt 2000 · S/N 416-2000N371MWRegistration Pending · Coldwater, MIRegistration pendingS/N 7AC-364N3720EMaynard Jerry M · Dudley, NCBuilt 1947 · S/N 11AC-1862N3722ELinton James · Boise, IDBuilt 1947 · S/N 7AC-7016N3729EAerocraft Holding Company LLC · Waxhaw, NCBuilt 1947 · S/N 11AC-S15
Back to AD 2000-25-02 R1