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.

N8947RUpton Chris M · Hettinger, NDBuilt 1960 · S/N 7GC163N8948RWhomble Leonard L · Wray, COBuilt 1960 · S/N 7GC-164N8949RMorten Jesse L · Larimore, NDBuilt 1960 · S/N 7GC-165N8951RGardner John B · Arlington, INBuilt 1960 · S/N 385N8952RBaker Charles L · Swartz Creek, MIFirst renewal noticeBuilt 1960 · S/N 7FC-386N8956Martini Philip D · Bethel Park, PABuilt 1973 · S/N 123-74N8958English John H · Pittsburg, TXBuilt 1973 · S/N 610-74N8965RAspenglow LLC · Talkeetna, AKBuilt 1960 · S/N 11N8967RWindsock Holdings LLC · Amarillo, TXBuilt 1960 · S/N 7JC-13N8969RRutland Aviation Service Inc · Tifton, GABuilt 1960 · S/N 7EC-728N8970RMerrell Susan E · Midland, MIBuilt 1960 · S/N 7EC-730N8973RDilliha Steve G · Russellville, KYBuilt 1960 · S/N 14N8977RCozine Mark R · Cherokee, IABuilt 1960 · S/N 7KC-1N8978RRoth Robin A · Wray, COBuilt 1960 · S/N 7GCB-11N8979RSeeley Lenard D · Osage, WYBuilt 1960 · S/N 13N8980RHolmes Aviation Inc · Cannon Falls, MNBuilt 1960 · S/N 7GCB-14N8981RBlock Raymond J · Palmer, AKS/N 7GCB-10N8982RBoo Steven R · Chisago City, MNBuilt 1960 · S/N 7GCB-15N8985RChapman William H · Dayton, OHBuilt 1959 · S/N 7FC-350N8986RYarbanton John Robert · Muskegon, MIBuilt 1960 · S/N 7GCB-16N8988RYoung Andrew J · Eagle River, AKBuilt 1960 · S/N 7EC-732N898TKatz Air Holdings LLC · Wilmington, DEBuilt 2024 · S/N 641-2024N8993RMiller Scott A · Piney Flats, TNBuilt 1960 · S/N 7GCB-22N89946Safran Brian J · Valley City, OHBuilt 1946 · S/N 7AC-3668N8994RT & H Aviation LLC · Rector, ARS/N 45N8999RDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1960 · S/N 7GCB-35N89GKCasa Jets Inc · Pittsford, NYS/N 1086-2009N89MMSic Sac Fliers LLC · Gainesville, FLS/N 1185-2020N89TWAlpine Aerobatics LLC · Chelsea, MABuilt 2005 · S/N 977-2005N89WSStevenson Wayne · Georgetown, MNBuilt 1993 · S/N 364-93N8CJBrothers Aviation LLC · Black Rock, ARBuilt 1946 · S/N 7AC-3745N8CKPresley Danny K · Homer, AKS/N 104N8DBBaker Drew A · Little Rock, ARBuilt 1966 · S/N 402N8DLKnowlton James W · Au Gres, MIBuilt 1976 · S/N 1169-76N8ETAshby Dennis A · Paris, TXBuilt 1980 · S/N 619-80N8PMChristmas Michael G · Long Beach, CABuilt 1975 · S/N 192-75N8QPBurwell Shawn J · Elkhorn, NES/N 7AC-5422N8RRCarey Patrick T · Hawthorne, CAS/N 450-73N8SFScarbrough Christopher R · Palestine, TXBuilt 1972 · S/N 59-73N8UKIvey Thomas S · Gladewater, TXS/N 134N8ZXKansas Farm And Ranch Inc · Seneca, KSBuilt 1995 · S/N 1210-95N9000BHanna Ryan D · Berthold, NDBuilt 1957 · S/N 7EC-623N9001EWiencek Karl · Huddleston, VABuilt 1946 · S/N 11AC-635N9002BWicklander Richard O · Spanaway, WABuilt 1957 · S/N 7FC-99N9004LThoman Mark C · Jacksonville, NCBuilt 1970 · S/N 240-70N9005BSchorsch Cary J · Franksville, WIBuilt 1957 · S/N 7EC-630N9005LColorado Twin Bonanza LLC · Broomfield, COBuilt 1970 · S/N 212-70N9006EMiller Bruce A · Plano, TXBuilt 1946 · S/N 11AC-637N90076Tilts Brandon J · Flagstaff, AZBuilt 1972 · S/N 414-72N9007EFolbre Frank S · Millsap, TXS/N 11AC-638
Back to AD 2000-25-02 R1