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.

N7917SNelson Cliff A · Joplin, MTBuilt 1976 · S/N 943-76N7918SKnox James P · Park Rapids, MNBuilt 1976 · S/N 955-76N791KBLucky Dog Aviation LLC · Victoria, TXBuilt 2006 · S/N 1035-2007N792THbhis LLC · Gnadenhutten, OHS/N 1024 74N793BPlumhoff Uwe E · La Center, WAS/N 7EC-647N793LLetourneau University · Longview, TXBuilt 2014 · S/N 1409-2014N795ACZorba Chad · Grapevine, TXBuilt 1999 · S/N 833-99N795JPLange Daniel C II · Oakland, CABuilt 1995 · S/N 746-95N795LLetourneau University · Longview, TXBuilt 2023 · S/N 1413-2023N796TMBlack John E · Cocoa Beach, FLBuilt 1996 · S/N 779-96N797ACWoods Gregory W · Englewood, FLFirst renewal noticeBuilt 1997 · S/N 797-97N797LLetourneau University · Longview, TXBuilt 2014 · S/N 1410-2014N797PFBerggren Philip C · Gunnison, COBuilt 2022 · S/N 1484-2022N798LLetourneau University · Longview, TXBuilt 2005 · S/N 1393-2005N798MATobago4 LLC · Lawrenceville, GABuilt 2006 · S/N 1416-2006N799KMonarch Aviation LLC · Dillon, MTBuilt 2002 · S/N 470-2002N799LKelley Stephen D · North Easton, MABuilt 2005 · S/N 503-2005N799MA406 Mountain Air LLC · Bigfork, MTBuilt 2006 · S/N 1413-2006N799RGRegistration Pending · Dayton, OHRegistration pendingBuilt 1946 · S/N 7AC-3834N79ACTen G LLC · Waddell, AZS/N 708-93N79KRRedick Albert L II · Reno, NVBuilt 1946 · S/N 7AC-4515N79QBBaer Marcus R · Aubrey, TXBuilt 1965 · S/N 48N79RARegistered aircraftBuilt 2001 · S/N 1312-2001N7DFSkyshoe III LLC · Beverly, MABuilt 2007 · S/N 1055-2007N7DTPeet Edward V · Lady Lake, FLS/N 577-76N7ECWolford Sales & Leasing LLC · Abingdon, ILBuilt 2007 · S/N 1018-2007N7JBB F Service Inc · Bloomington, INBuilt 1994 · S/N 727-94N7XPInternational Air Services Inc Trustee · Carson City, NVBuilt 2001 · S/N 1309-2001N7XVPagenkopf Joseph C · Juneau, AKBuilt 1974 · S/N 132-75N800PTContner Gary E · Huntsville, OHBuilt 1946 · S/N 7AC-5427N8023MWhite Paul M · Elizaville, NYS/N 11BC-132N8038WMctaggart Briar C · Adelanto, CAS/N 179N80461Bremer Wilfred P · Madison, WIS/N 7EC743N804JSButler Jack L · Bennington, OKBuilt 2004 · S/N 491-2004N804SMVogt Gregory A · Broken Arrow, OKBuilt 1975 · S/N 158-75N8057HTrevor Bruce B Jr · Green Bay, WIS/N 181N805ACSouthern Sky LLC · Henderson, NVBuilt 2005 · S/N 1001-2005N805BCCrosswind Landing Inc · Mccall, IDBuilt 2016 · S/N 575-2016N805STDga Avition LLC · Sacramento, CABuilt 1976 · S/N 275-76N805TTTim Twisselman Enterprises Inc · San Luis Obispo, CABuilt 2022 · S/N 628-2023N8060XChance Malcolm · Folsom, CAS/N 7DC-132N806CInternational Divers Co Inc · Corpus Christi, TXBuilt 2010 · S/N 1100-2010N808BWWeber William A · Brodhead, WIBuilt 1962 · S/N 7GCB-147N80BDJtr Aviation LLC · Canton, TXBuilt 1980 · S/N 613-80N80SDLake Area Technical College · Watertown, SDBuilt 2005 · S/N 1397-2007N80TARegistration Pending · Lancaster, CARegistration pendingS/N 632-80N8111NRhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1946 · S/N 7AC-3712N813AXColley Douglas W · Spokane, WAS/N 11AC-842N813KMSantopietro Paul · Dunnellon, FLBuilt 2001 · S/N 1321-2001N81401Sipes Jacob L · Sunbury, OHBuilt 1945 · S/N 7AC-19
Back to AD 2000-25-02 R1