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.

N4683ERegistration Pending · Delanson, NYRegistration pendingBuilt 1950 · S/N 7EC-31N4686ESieh Colton David · Kotzebue, AKS/N 7EC-34N4687EMaslen Holbrook · Caldwell, IDS/N 7CCM-217N4689EKelly Michael A · Anchorage, AKBuilt 1950 · S/N 7EC35N468DRBrantley James · Estero, FLBuilt 2016 · S/N 579-2016N4696ETorgersons LLC · Ethridge, MTBuilt 1950 · S/N 7EC-43N4697EIverson James P · Soldotna, AKBuilt 1950 · S/N 7EC-44N4698ECook Bruce F · Circleville, OHBuilt 1950 · S/N 7EC-45N469JAmerican Champion Aircraft Corp · Rochester, WIBuilt 2013 · S/N 1122-2012N469KLM9 Flight LLC · Delhi, LABuilt 1966 · S/N 61N46ACMccleary Timothy A · Navarre, OHBuilt 1946 · S/N 7AC-3382N46WRHelminger Nathan · Wellington, KSS/N 11AC1108N4701EMacveigh Craig A · New Carlisle, OHS/N 7EC-50N4702EMiller Henry C · Mckinney, TXS/N 7EC-51N4703ERittberger Dustin A · Fairburn, SDBuilt 1950 · S/N 7CCM-219N4705EBurgess Dwight G · Florence, ALBuilt 1950 · S/N 7EC-54N4708EEngesath David H · Duluth, MNBuilt 1950 · S/N 7EC-55N4709EMiller Aircraft Services Inc · Crookston, MNBuilt 1950 · S/N 7EC-52N4711XKirby John D · San Diego, CABuilt 1947 · S/N 7AC-7038N4712EWaggoner David F · Aurora, ORS/N 7EC-56N4714ECampbell Brett L · Kirksville, MOBuilt 1950 · S/N 7EC-58N4715EWings Of The North Inc · Eden Prairie, MNBuilt 1950 · S/N 7EC-59N4717EMalsberger Tim J · Blakely, GABuilt 1950 · S/N 7EC-62N4719EMcmillan Rickey F · Mission Hills, CARegistration revokedBuilt 1950 · S/N 7EC-63N471ACWard Allen M · Andalusia, ALBuilt 1998 · S/N 410-98N4721EQuast George Walter · Hutchinson, MNBuilt 1950 · S/N 7EC-65N4722EHarris Denton · Preston, IDS/N 7EC66N4723EAddington James T · Denton, TXBuilt 1950 · S/N 7CCM-224N4724EFarringer Steven R · Columbia City, INBuilt 1950 · S/N 7EC-67N4725EAgaliotis Paul E · San Martin, CABuilt 1950 · S/N 7EC-68N4727EKw Group LLC · Philipsburg, MTS/N 7EC-70N4728EJohnson Gregory T · Stanley, NDBuilt 1951 · S/N 7EC86N472ACSwift Air LLC · Lebanon, TNS/N 411-98N4733EBecker Mark · Bismarck, NDS/N 7CCM-226N4738EDetert Bradley · Valparaiso, INBuilt 1950 · S/N 7EC-83N4741EDemars Dale Anthony · Remer, MNBuilt 1951 · S/N 7CCM-225N4741YBest Joseph J · Coldwater, MIS/N 7AC-5637N4745EScott Erik G · Anchorage, AKS/N 7EC-92N4747EMacveigh Craig A · New Carlisle, OHS/N 7EC94N4748ETaylor Aero LLC · Lewes, DEBuilt 1951 · S/N 7EC-95N474ACOverland Leasing Inc · La Porte, TXBuilt 2000 · S/N 854-99N474HBGreene William T · Dresser, WIBuilt 2017 · S/N 590-2018N474HHVanhouten Philip · Wallkill, NYS/N 7AC-3419N474JSAmerican Champion Aircraft Corp · Rochester, WIS/N 1494-2026N474WBPhillips Kenneth R · Brackettville, TXBuilt 1974 · S/N 21-74N475ACWigginton John D · Saco, MEBuilt 2000 · S/N 1300-2000N476FMShumaker James B · Salinas, CABuilt 1978 · S/N 355-78N476MAAdamko Victor W · Riley, MIBuilt 2007 · S/N 1056-2007N4775PRegistered aircraftBuilt 1975 · S/N 20675N4781TContinental Title Trust LLC Trustee · Wichita, KSS/N 170-75
Back to AD 2000-25-02 R1