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.

N7670SShortridge Randall R · Mesa, AZBuilt 1976 · S/N 218-76N7671SKlos Aero LLC · Plevna, MTS/N 254-76N7672SLouisville Soaring Club Inc · Lexington, KYBuilt 1976 · S/N 222-76N7674SMurtagh Johhny T · Lexington, MSBuilt 1976 · S/N 932-76N7675SKemp Gilbert A · Waterville, NYBuilt 1976 · S/N 1170-76N7677EPatterson Judy K DBA · Rutherfordton, NCBuilt 1958 · S/N 7FC-274N7678ETerry Michael R Trustee · Bullhead City, AZBuilt 1946 · S/N 7AC-3393N7679EColorado Express LLC · New Port Richey, FLBuilt 1958 · S/N 7FC-276N767ACWooldridge Kent L · Albany, ORBuilt 2000 · S/N 410-2000N767PAviation Investments Inc · Virginia Beach, VAS/N 262-73N767RAmerican Champion Aircraft Corp · Rochester, WIS/N 648-2027N767SECoyote Aviation LLC · Carefree, AZBuilt 2004 · S/N 1374-2004N7680EC & C Farms Partnership · Epps, LAS/N 7FC-277N7680SHallsten Stephen B · Fairbanks, AKBuilt 1976 · S/N 221-76N7681SCawley Jeffrey W · Buckley, WABuilt 1976 · S/N 907-76N7683SSzabolscky Stephen L · Remington, VABuilt 1976 · S/N 257-76N7684SStrehle Scott · Lewiston, IDS/N 934-76N7685EDougherty Jeff D · Connell, WAFirst renewal noticeS/N 7EC-664N7685SHull Kevin G · Sadler, TXBuilt 1976 · S/N 58276N7686EChristie Ian A H · Limon, COS/N 7FC-282N7687SLynn Robert W · Independence, WVBuilt 1976 · S/N 936-76N7688SJohnson Brian G · Goodridge, MNBuilt 1976 · S/N 937-76N768ACBowe Joseph E · Ocklawaha, FLBuilt 1999 · S/N 1268-99N768CStieren George L · Kerrville, TXBuilt 2010 · S/N 532-2010N768TPjd Holdings LLC · Grand Blanc, MIBuilt 2025 · S/N 1488-2025N7690SCollum Aviation LLC · Milton, FLBuilt 1976 · S/N 224-76N7692EBrickwood-Figgins David B · Tulsa, OKBuilt 1958 · S/N 7FC-287N7693EBrignac Flying Service LLC · Columbus, MSS/N 7FC-288N7694EWilliams Lisa Goulet · Summerland Key, FLS/N 7FC-289N7694SBaker Bruce A · Chandler, AZBuilt 1976 · S/N 260-76N7695EReynolds William H Jr · Norfolk, VAS/N 7FC290N7695SState Of Alaska · Fairbanks, AKBuilt 1976 · S/N 225-76N7696EReedy James · Fairfield, IDS/N 7FC-291N7697SKenley Fredrick Charles · Palmer, AKBuilt 1976 · S/N 226-76N76BCYackley Ranches · Onida, SDBuilt 2020 · S/N 606-2020N76BEBrown Darrell W · Covington, GABuilt 1969 · S/N 168N76DESchiff Brian · Keller, TXS/N 513-2007N76KFRegistration Pending · Grenada, MSRegistration pendingBuilt 1974 · S/N 153-74N76MLDunn Courtland E Jr · West Grove, PABuilt 1974 · S/N 446-74N76PPGround Effect Aviation LLC · Ogden, UTBuilt 2007 · S/N 494-2007N76SMCasey Mike P · Whitefish, MTS/N 393-72N76YDBeasley Charles A · Spencer, VABuilt 1975 · S/N 199-75N7704SHolte Bruce C · Thief River Falls, MNBuilt 1976 · S/N 1172-76N770ACSearching For Grass LLC · Stroudsburg, PAS/N 380-96N771ACMorrison William Fraser · Bonners Ferry, IDS/N 379-96N771CTCrump John · Gillette, WYBuilt 2006 · S/N 1407-2006N771LLBravo November LLC · Wilsonville, ORBuilt 2008 · S/N 1065-2008N771MRSmith Nathan · Palmer, AKBuilt 1967 · S/N 87N772ACMiller Kevin W · Epps, LAS/N 1228-96N772EMelvin Daniel · Larkspur, CABuilt 2000 · S/N 849-99
Back to AD 2000-25-02 R1