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.

N1705ZJohnston Daryl T · Euless, TXBuilt 1973 · S/N 474-73N1706ECrabbe Michael B · Galloway, OHBuilt 1946 · S/N 7AC-5271N170MLLacey David G · Locust Grove, GABuilt 1974 · S/N 1074-75N1712ECrooks Sean P · Canton, MIS/N 7AC-5277N1713EMurray Donald L · Two Harbors, MNBuilt 1946 · S/N 7AC-5278N1714ELeonx Aaron R · Cambridge, WIBuilt 1946 · S/N 7AC-5279N1715EDelong Erika D · Forest Lake, MNS/N 7AC-5280N1719MJohnson David H · Jasper, GAS/N 7BCM-73N171CRLaniape LLC · Fort Walton Beach, FLBuilt 2007 · S/N 1053-2007N171HBKrawchuck Paul L · Live Oak, FLBuilt 1946 · S/N 7AC-2169N171TGarrett Wayne · Guntersville, ALBuilt 2025 · S/N 527-2025N1724EMorgan John T · Fort Payne, ALBuilt 1946 · S/N 7AC-5290N1726ESale Reported · Overland Park, KSSale reportedBuilt 1946 · S/N 7AC-5291N1729EFogg William R · Greensburg, INBuilt 1946 · S/N 7AC-5296N1731EWelton Doug L · Fairbanks, AKBuilt 1946 · S/N 7AC-5298N1739EWilson Bobby R · Kathleen, GABuilt 1946 · S/N 7AC-5306N173PWSunspot Meadow LLC · Cloudcroft, NMBuilt 2004 · S/N 1362-2004N173SDMountain Aerobatics LLC · Chesterfield, MOBuilt 2011 · S/N 1108-2011N1744EDietz Steven C · Poplar Grove, ILBuilt 1946 · S/N 7AC-6125N1749EPrice William B · Lamar, SCBuilt 1946 · S/N 7AC-5316N174RAWelke Gregory E · Chippewa Falls, WIBuilt 2005 · S/N 1390-2005N174RCCarsey Rick · Fowler, CAS/N 576-73N174SGMoore Stan · Amarillo, TXBuilt 2008 · S/N 1441-2007N174TBOwen Harold E Jr · Collierville, TNBuilt 2017 · S/N 1173-2017N1751ELowe Thomas E · Crystal Lake, ILBuilt 1946 · S/N 7AC-5318N1752EStoos Robert A · Lakeland, FLS/N 7AC-5319N1756ESlg Aviation LLC · Berlin, WIBuilt 1946 · S/N 7AC-5323N175RABrabec Frank F · Indio, CABuilt 2002 · S/N 1332-2002N175RLPerera Nandana L · Logan, OHBuilt 1995 · S/N 761-95N1762EKopecky Carle J · Warnerville, NYBuilt 1946 · S/N 7AC-5329N1763EKohn Michael E · Endicott, NYS/N 7AC-5330N1764EBlackwood Edward W Jr · Mt Holly, NCBuilt 1946 · S/N 7AC-5331N1766EKottemann Gregory C · Kentwood, LABuilt 1946 · S/N 7AC-5333N1770ESimmers Jonathan P · Mandan, NDS/N 7AC-5337N1771EBerntsen Bradley T Trustee · Apple Valley, MNBuilt 1946 · S/N 7AC-5338N1774EKendall Jeffrey A · Vero Beach, FLBuilt 1946 · S/N 7AC-5341N177ACIsaac Bron A · Soldotna, AKS/N 7AC-5275N1780EKalb Kenneth R · Dubois, INS/N 7AC-5347N1785EHamlett Reece W · Anchorage, AKBuilt 1946 · S/N 7AC-5352N1787EStevens Jerrold B · Salem, ORS/N 7AC-5354N1789EPinkston Billy Walker · Lambert, MSBuilt 1946 · S/N 7AC-5356N178BCAllen Lisa M · Melba, IDBuilt 2005 · S/N 474-2005N178DKSchenck James R Trustee · Mclean, VABuilt 2018 · S/N 1178-2018N178TTLockwood Kurt G · Fairbanks, AKBuilt 1978 · S/N 278-78N1790EMountain Flyers LLC · Milton Freewater, ORBuilt 1946 · S/N 7AC-5357N1792EHowe Patrick L · Higgins Lake, MIBuilt 1946 · S/N 7AC-5359N1797ESmokovitz Daniel J · Brighton, MIBuilt 1946 · S/N 7AC-5364N1798EStewarts Aircraft Service Inc · Waynesville, OHBuilt 1946 · S/N 7AC-5365N1799EAndresen Paul S · Chandler, AZBuilt 1946 · S/N 7AC-5366N179BCDenmark Ag · Winters, CAS/N 458-2004
Back to AD 2000-25-02 R1