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.

N9838EErickson Lambert A · Littlefork, MNBuilt 1949 · S/N 7EC-1N9839YHayton James B · Sedro Woolley, WABuilt 1961 · S/N 7FC-451N9840YBrown Michael D · Columbia, TNBuilt 1961 · S/N 7FC-436N9851YElliott Carlton P Jr · Rustburg, VABuilt 1960 · S/N 7FC-412N9852YMingo Daniel J Trustee · Wasilla, AKBuilt 1960 · S/N 413N9855YBothe Larry S · Seymour, INBuilt 1961 · S/N 7FC-406N9857BSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1958 · S/N 7FC-183N9858YMclaughlin Paul E · Mansfield, OHS/N 437N9859BMcfag LLC · Delaware, OHBuilt 1958 · S/N 7FC-185N985ACRainey Aerial Ag Service Inc · Obion, TNBuilt 2004 · S/N 463-2004N985BCNorthwest Back Country Aircraft LLC · Caldwell, IDBuilt 2025 · S/N 645-2025N9862BSunny Flying LLC · Kindred, NDS/N 7FC-191N9862YTreml Edward I · Kewaunee, WIS/N 7FC-425N9865YCloose Brian D · Carlton, MNBuilt 1960 · S/N 7GCB-63N9866YMummey Gary E · Stockport, OHBuilt 1960 · S/N 64N9867YPeterson Eric S · North Logan, UTS/N 65N9868BRobbins Patrick D · Yakutat, AKS/N 7EC-656N9869YThompson Curtis W · Battleview, NDBuilt 1961 · S/N 7FC-421N9870BAspenglow LLC · Talkeetna, AKBuilt 1958 · S/N 7FC-193N9872BSchuler Joyce L · Dutton, MTFirst renewal noticeS/N 7EC-658N9872YSpee James C · Redlands, CABuilt 1962 · S/N 764N9876BGreenough Dale · Lusk, WYBuilt 1958 · S/N 7FC-198N9878BRittberger Beef Inc · Hermosa, SDBuilt 1958 · S/N 7EC-659N9878YWaterman David N · Amery, WIS/N 7KC-3N9879BStrine Russell A · Reading, PABuilt 1958 · S/N 199N987ANf County Flying Club Inc · Chateaugay, NYBuilt 2003 · S/N 921-2003N9880YMerrick Shane · Redgranite, WIBuilt 1961 · S/N 7GCB-73N9881Conaway Byron Richard · Savannah, TNS/N 7CCM-79N9883BDeal Brady Edward · Anchorage, AKBuilt 1958 · S/N 7FC-203N9884BRegistration Pending · Jackson, OHRegistration pending, pending cancellationBuilt 1958 · S/N 7FC-204N9884YRoberts Colton C · Bluebell, UTS/N 7GCB-119N9885BHill Nelson · Laurel, MSBuilt 1958 · S/N 7FC-205N9885YCentral Air Parts Inc · Staunton, ILS/N 145N9890BSchoettmer Thomas C · Greensburg, INBuilt 1958 · S/N 7FC-210N9892YWraith Daniel T · Wasilla, AKBuilt 1961 · S/N 7GCB-77N9894BAscension Flyers Inc · Stillwater, MNBuilt 1958 · S/N 7FC-214N9896YFrisby James A · Palmer, AKS/N 7GCB-95N9897BMccrorie LLC · Helena, MTBuilt 1958 · S/N 7FC-217N9897YCline Braxton L · Wasilla, AKBuilt 1962 · S/N 7GCB-117N9899BSonic Inspection Corp · Edmond, OKS/N 7FC-219N9899YOld Style Aircraft LLC · Ellsinore, MOBuilt 1962 · S/N 7GCB-139N989CDDoyle Charles P · Webster, MNBuilt 2008 · S/N 1075-2008N989WBCp Aviation Inc · Santa Paula, CABuilt 2012 · S/N 1120-2012N98ABooe Kent W · Clay City, INBuilt 1973 · S/N 64-73N98JPWetstein James M · Anchorage, AKBuilt 1960 · S/N 7JC16N9900YGary E Gylten · Northwood, NDBuilt 1961 · S/N 7FC-440N9902YJeepers LLC · New York, NYBuilt 1961 · S/N 8N9906YMac · Wichita, KSBuilt 1961 · S/N 7GCB-74N9907YIngle Stephen D · Bainbridge, OHBuilt 1961 · S/N 94N9908YNickerson William L · Libby, MTBuilt 1962 · S/N 122
Back to AD 2000-25-02 R1