OpenAirDocs.org
AD 2000-25-02 R1

Registered aircraft · 7,560

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.

N147TPPatty Wagstaff Aviation Safety LLC · Saint Augustine, FLBuilt 2008 · S/N 10602008N147TQIron Thermal LLC · Hogansville, GABuilt 2003 · S/N 920-2003N1480EHughes Todd R · Rocky Ford, COBuilt 1946 · S/N 7AC-5043N1483ELee Scott D · Mcloud, OKBuilt 1946 · S/N 7AC-5046N1485ERunway 37 Inc · Hanson, MABuilt 1946 · S/N 7AC-5048N1486EBuergel Sandra T · East Aurora, NYBuilt 1946 · S/N 7AC-5049N1488EFasolilli Alexander A · Herkimer, NYBuilt 1952 · S/N 7AC-5051N148ACMach 1 Aircraft LLC · Malibu, CABuilt 1993 · S/N 717-93N148AKMurphy Patrick · Englewood, COBuilt 2014 · S/N 1140-2014N148BCWalker Dean M · Fort Collins, COBuilt 2008 · S/N 507-2008N148PCSuperd LLC · Everett, WABuilt 2005 · S/N 996-2005N1496EBucher William D · Troy, OHBuilt 1946 · S/N 7AC-5059N1499EJohnson Ronald W · Cayce, SCBuilt 1946 · S/N 7AC-5062N149ACOsceola Aerosport LLC · Osceola, WIBuilt 2001 · S/N 1032-2011N149BCKurtz Garold · Mound City, MOBuilt 2004 · S/N 4532004N149SAVan Bergen Matthew D · Arlington Heights, ILBuilt 2008 · S/N 10672008N149SGWaterwings Seaplanes LLC · Hoover, ALBuilt 2006 · S/N 1021-2006N14EJPrecision Air LLC · Trent, SDBuilt 1993 · S/N 709-93N14HWAmenta George S · Fishkill, NYBuilt 1946 · S/N 7AC-3120N14JRAerial Reconnaissance Inc · Trent Woods, NCS/N 479-73N14KDBobcat Ag LLC · Wooster, ARBuilt 2020 · S/N 604-2020N14KFParker Jerry · Houston, TXS/N 656-91N14SASidney Aviation LLC · Sidney, NEBuilt 2014 · S/N 1146-2014N14WFSamberg Scott S · Gillette, WYBuilt 1976 · S/N 233-76N14XDAero Leasing Inc · Wilmington, DEBuilt 2014 · S/N 1152-2014N1503EVan Tine Brad R · Billings, MTBuilt 1946 · S/N 7AC-5066N1506ERathbone Karin R · Anchorage, AKBuilt 1946 · S/N 7AC-5069N1508ECouch Richard A · Iowa City, IABuilt 1946 · S/N 7AC-5071N1511EPatton D Pettijohn · Wasilla, AKBuilt 1946 · S/N 7AC-5074N1516XNorthern James E · Oakdale, CABuilt 1973 · S/N 379-73N1518EFolk Michael C · Martinsburg, WVS/N 7AC-5081N151BHRajnarayan Dev Gorur · Mountain View, CABuilt 2008 · S/N 1061-2008N151JSPerkins E G Jr · Greenwood, MSBuilt 1994 · S/N 738-94N151PCWear Thomas M · Bridgewater, NJBuilt 2001 · S/N 884-2001N151SAKennedy Jon P · Gillette, WYBuilt 2008 · S/N 1448-2008N151VJonathan Wise & Associates Inc · Edmond, OKBuilt 1979 · S/N 550-79N1520EPethel Gregory L · Concord, NCBuilt 1946 · S/N 7AC-5083N1522FMatray Blake E · Fairbanks, AKS/N 7AC-1071N1523ERustin Phillip L · Reynolds, GABuilt 1946 · S/N 7AC-5086N1524EBlain Robert L · West Richland, WABuilt 1946 · S/N 7AC-5087N1526ECastorina John S · Anthem, AZBuilt 1946 · S/N 7AC-5089N1528EBeasley Silas W · Spokane, WABuilt 1946 · S/N 7AC-5091N1537EHammerdog LLC · Lafayette, COBuilt 1946 · S/N 7AC-5100N1538EBartelma Farms Inc · Runnells, IABuilt 1946 · S/N 7AC-5101N153ACN153ac LLC · Eldon, MOBuilt 1993 · S/N 702-93N153GReese Paul D · Elkview, WVBuilt 2007 · S/N 1039-2007N153RAWeiner Marc H · Hoboken, NJBuilt 2001 · S/N 1311-2001N1540EMacveigh Craig A · New Carlisle, OHS/N 7AC5103N1546EStory John · Harrah, OKBuilt 1946 · S/N 7AC-5109N154RAFulwiler Air LLC · Green Bay, WIBuilt 2005 · S/N 1391-2005
Back to AD 2000-25-02 R1