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.

N3312EDexter Fred H · Live Oak, FLBuilt 1947 · S/N 7AC-6756N3316EBeach Bound Baron LLC · Modena, NYBuilt 1947 · S/N 7AC-6761N3321EGudgel Daniel R · Merced, CABuilt 1947 · S/N 7AC-6770N3322EBudd Sharon · Rushville, NEBuilt 1947 · S/N 7AC-6771N3325EUnderland Brian G · Atwater, MNS/N 7AC-6784N3335EVawter William R Jr · Fort Worth, TXBuilt 1947 · S/N 7AC-6785N3336ENoga Gwain J · Youngstown, OHS/N 7AC-6786N333HTTiernan Barton M · Anchorage, AKBuilt 1979 · S/N 33380N333JSWarbird Adventures Inc · Ocoee, FLBuilt 1977 · S/N 612-77N333MRRegistration Pending · Palm Coast, FLRegistration pendingBuilt 1946 · S/N 11AC-115N333WBGammill David R · Tyronza, ARBuilt 1947 · S/N 7AC-3461N333YZeller Ty F · Trego, WIBuilt 1969 · S/N 7GCBC-194N3340ERichardson Michael T · Inver Grove, MNS/N 7AC-6790N3342ESpears Patricia C · Longmont, COBuilt 1947 · S/N 7AC-6792N3347ECunningham Frank D · Okeechobee, FLBuilt 1947 · S/N 11AC-1679N3348DDuke Robert D · Darrouzett, TXFirst renewal noticeBuilt 1946 · S/N 7AC-3348N3349EBrown Tim J · Madison, SDBuilt 1947 · S/N 11AC-1681N334SVTmstar Services LLC · Lewes, DEBuilt 1965 · S/N 7ECA-89N3351EWomack Jeff M · Jackson, LABuilt 1947 · S/N 11AC-1683N3354EBarnes James C · Gregory, MIBuilt 1947 · S/N 11AC-1686N3358EBlanton David L · Valley Center, KSBuilt 1947 · S/N 11AC-1691N335DSWhitaker Martin · Portland, MEBuilt 2008 · S/N 10702008N3361ELeasure Michael · Battle Ground, INBuilt 1947 · S/N 11AC-1693N3366ECrosslin Rick · Elizabethtown, KYBuilt 1950 · S/N 11AC-1698N3367EGeisler Mark · Dallas, TXBuilt 1947 · S/N 11AC-1703N336WTRomney Chad · Rigby, IDBuilt 2023 · S/N 1210-2023N3370EBas Part Sales LLC · Greeley, COBuilt 1947 · S/N 7AC-6778N3372ETracy Johnny L · Troy, MOBuilt 1947 · S/N 7AC-6798N3374ESlone Donald L · Holden, MOS/N 7AC-6800N337CBErickson Arnold F · Devils Tower, WYS/N 1337-80N3380EFrench Lynn J · Broken Bow, NEBuilt 1947 · S/N 11AC-1706N3382EFarrelly Joseph T · Rocklin, CABuilt 1947 · S/N 11AC-1708N3383EElwood Eddie · Parma, MIBuilt 1947 · S/N 11AC-1709N3384EVaughn Trennis L · Reese, MIS/N 11AC-1710N3390EReid Dale L · Eau Claire, WIBuilt 1947 · S/N 7AC-6808N3390RNuckles Charles A Jr · Suffolk, VABuilt 1946 · S/N 7AC-1700N33BP33bp LLC · Sand Springs, OKBuilt 1992 · S/N 691-92N33BYSellmeyer Flying Service · Knobel, ARBuilt 2005 · S/N 990-2005N33DVKostreva Adam · Riverton, WYBuilt 1970 · S/N 234-70N33GRHeadrick John Eric · Eolia, MOS/N 259-76N33JTTuchscherer James D · Waterloo, IABuilt 1946 · S/N 6291N33LTKelly Tony R · Aberdeen, MSBuilt 1997 · S/N 799-97N33PRude David L · Raleigh, NCBuilt 1946 · S/N 7AC-2801N3402ECwian Nickolas W · Easley, SCBuilt 1947 · S/N 7AC-6817N3409EHerrema Scott · White Cloud, MIBuilt 1947 · S/N 7AC-6822N340ACMajor Travis S · Phoenix, AZBuilt 2003 · S/N 1340-2003N3415EMerkle Larry · Clarence Center, NYBuilt 1947 · S/N 7AC-6823N3418ELauer Raymond C · Amissville, VABuilt 1947 · S/N 7AC-6826N3420EStarfire Aviation LLC · Conyers, GABuilt 1947 · S/N 11AC-1737N3424EDowdy John H · Union, WVBuilt 1947 · S/N 7AC-6829
Back to AD 2000-25-02 R1