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.

N2977WRhinehart Christopher · Deerwood, MNS/N 1207-80N29788Lund Kevin J · Williamson, GABuilt 1980 · S/N 396-80N2979BLearn 2 Fly LLC · Seminole, ALS/N 1214-80N2979CEnchanted Aircraft LLC · Santa Fe, NMBuilt 1980 · S/N 639-80N2979ERogers James R · Morriston, FLBuilt 1946 · S/N 7AC-6565N2979PRussman Nicholas S · Farmersville, TXBuilt 1980 · S/N 1351-80N297ACCavanaugh Flying Service Inc · Minden, NES/N 771-96N297JBCheney Livestock Corp · Casper, WYS/N 1279-99N2980DLimbach Ronald B · Verona, ILBuilt 1980 · S/N 642-80N2981MPavey Rocky A · Fairbanks, AKBuilt 1980 · S/N 360-80N2982EGauthier Peter J · Woodburn, ORBuilt 1946 · S/N 7AC-6568N2984ZStitch Aero LLC · Sunnyvale, CABuilt 1978 · S/N 381-78N2985EWelna John M · Saginaw, MNS/N 7AC-6476N2987GMuehlbauer Jeff J · Nenana, AKBuilt 1967 · S/N 578N2988EJones Mike G · Slaton, TXBuilt 1946 · S/N 7AC-6574N298ACEagle Prairie Flyers LLC · Eau Claire, WIFirst renewal noticeBuilt 1999 · S/N 1259-99N298JBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 350-78N298MASouthern Air Service Inc · Carbondale, ILBuilt 2004 · S/N 961-2004N29900Parsons Dennard C · Mount Dora, FLBuilt 1980 · S/N 1348-80N2990DHall Tyson · Leadville, COBuilt 1980 · S/N 1201-80N2991DWatkins William C · Guy, ARS/N 627-80N2991EPlayter Bud W · Greenville, MIBuilt 1946 · S/N 7AC-6578N2992ESallade William L · Coudersport, PABuilt 1946 · S/N 7AC-6579N2992GYonge Charles Richard · Ocala, FLBuilt 1967 · S/N 68N2993GKilgore Samuel E Jr · Southaven, MSBuilt 1967 · S/N 54N2995GVincent Frederick D · Searsport, MEBuilt 1967 · S/N 38N2996GAngle Matthew G · Teton Village, WYS/N 558N2996ZKerr Ian A · Redwood City, CAS/N 1247-78N2998EWenk Jennifer M · Beaufort, NCBuilt 1946 · S/N 7AC-6585N2998GMiner Jay G · Seattle, WAS/N 589N2999ZGodensun Aero LLC · Sutherlin, ORS/N 382-78N299BCClark John Thomas Jr · North Salt Lake, UTBuilt 2018 · S/N 591-2018N299LCFlight Contract Services Inc · Las Vegas, NVBuilt 1974 · S/N 165-75N299SAEnterprise General Aviation Network Inc · Dell Rapids, SDFirst renewal noticeBuilt 2005 · S/N 1003-2005N299SLSatermo Lee J · New Town, NDBuilt 1947 · S/N 7CCM214N29BHShearer Glendon E · Wall, SDBuilt 1958 · S/N 215N29CBHouston Robert · Murray, KYBuilt 1974 · S/N 156-74N29FFBriggs Aviation LLC · Virginia Beach, VABuilt 2008 · S/N 1022-2008N29GLHometime Rv LLC · San Antonio, TXBuilt 2008 · S/N 517-2008N29KRNeill Derek R · Shawnee, OKS/N 274N29SGMusser Richard J · Lithia, FLBuilt 2009 · S/N 1084-2009N2AGCentral Air Parts Inc · Staunton, ILBuilt 1972 · S/N 366-72N2BNJensen Paul E · Exeter, NEBuilt 1973 · S/N 445-73N2EZScott Flying Service Inc · Bono, ARBuilt 1979 · S/N 1296-79N2JGWetsu Enterprises Inc · Colorado Springs, COBuilt 1978 · S/N 403-78N2KTCambridge Valley Flying Club Inc · Shusann, NYBuilt 1946 · S/N 7AC-2012N2PMDixon Morris M · Poynette, WIBuilt 1946 · S/N 7AC-2461N2SGKcsi Aerial Patrol · Bakersfield, CABuilt 2000 · S/N 432-99N2VTRegistration Pending · Fort Pierce, FLRegistration pendingBuilt 2005 · S/N 1394-2005N2ZZDel Carlo Gary · Tracy, CABuilt 1965 · S/N 98
Back to AD 2000-25-02 R1