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.

N1617ECarter Tonja B · Monroeville, ALBuilt 1946 · S/N 7AC-5182N1617GDuch Jose M · Miami, FLBuilt 1968 · S/N 621N1618EParker Lee R · Alsea, ORBuilt 1946 · S/N 7AC-5184N1618GBlue Moon Flying Club LLC · Westminster, MDBuilt 1968 · S/N 622N161SAAviation Consultants Inc DBA · San Luis Obispo, CABuilt 2002 · S/N 901-2002N161SEOquinn Timothy M · Tehachapi, CABuilt 2006 · S/N 1027-2006N161SG3bs Aviation LLC · Wilmington, DEBuilt 2005 · S/N 1000-2005N161WFMaier Diane K · Underwood, WABuilt 2017 · S/N 1472-2016N1620EBowery Michael P · Quinton, VAS/N 11AC1460N1620GDrexler Charles T · Albuquerque, NMBuilt 1968 · S/N 123N1624EStadel Jim D · Yuba City, CABuilt 1946 · S/N 7AC-5189N1624GBarnett William M · Wasilla, AKBuilt 1968 · S/N 623N1625GPippert Jim · Dysart, IABuilt 1968 · S/N 127N1628GBistline Quentin J · Pahrump, NVS/N 626N162ACWatson Tommy R · Thibodaux, LABuilt 1997 · S/N 1235-97N162BCRegistration Pending · Tampa, FLRegistration pendingBuilt 2004 · S/N 465-2004N1631GSwiger Cale W · Hendersonville, TNBuilt 1968 · S/N 127N1632GValentine Robert D · Winfield, KSBuilt 1968 · S/N 627N1633GCarbiener Ross · Kewanee, ILBuilt 1968 · S/N 628N1634GBruce Robert W · Frontenac, MNBuilt 1968 · S/N 629N1636EMcilonie Robert L · Pingree, NDS/N 7AC5201N1637GLejeune Robert S · Basile, LABuilt 1968 · S/N 113N1639GGhostwriter Airshows LLC · Hustonville, KYBuilt 1968 · S/N 115N163BCClear Skies Aviation Inc · Hayward, CABuilt 2004 · S/N 1370-2004N1640GTownsend Gary V · Sunderland, VTS/N 116N1642EMeade Raymond L · Chester, VABuilt 1946 · S/N 7AC-5207N1642GLetourneau University · Longview, TXBuilt 1969 · S/N 169N1645GNashua Aerial Advertising LLC · Nashua, NHBuilt 1968 · S/N 63N1646ESwager Joel P · Ione, CAS/N 7AC-5211N1646GUndem John D · Grand Rapids, MNBuilt 1968 · S/N 100N1647EConder James C · Hemet, CAS/N 7AC-5212N1648ECollins Keith D · Clanton, ALBuilt 1946 · S/N 7AC-5213N1649GBentley Kyle S · Keene, NHBuilt 1968 · S/N 120N164PCSkye Equipment LLC · Asheboro, NCS/N 1015-2007N1650GWright Jeffrey Crandel · Opelika, ALBuilt 1968 · S/N 128N1652EHemphill Holdings LLC · Hemphill, TXBuilt 1946 · S/N 7AC-5217N1652GRunway 5 LLC · Wurtsboro, NYBuilt 1968 · S/N 122N1654GGelvin Stanley M · Central, AKBuilt 1968 · S/N 123N1659EBrown Frank A · Seal Beach, CABuilt 1946 · S/N 7AC-5225N1659GMills Kurt E · Oak View, CABuilt 1968 · S/N 632N165ACBrian & Karen Snodgrass Farms LLC · Seminole, TXS/N 471-2005N165BCMckinney William C · Whitefish, MTBuilt 2019 · S/N 600-2019N165RAEl Rancho Escondido Inc · Brownsville, TXBuilt 2004 · S/N 1367-2004N1660EVia Johnnie W · Atascadero, CABuilt 1946 · S/N 7AC-5226N1660GHintzman Bonnie L · New York Mills, MNBuilt 1968 · S/N 633N1661EWalts Byars · Annandale, MNBuilt 1946 · S/N 7AC-5227N1661GLockbaum James G · Oconomowoc, WIBuilt 1968 · S/N 636N1662ECalifornia Antique Aircraft Museum DBA · San Martin, CABuilt 1946 · S/N 7AC-5228N1663EGrave Eugene G · Spencer, INBuilt 1946 · S/N 7AC-5229N1664EJatho Jimmy W · Augusta, GABuilt 1944 · S/N 7AC-5230
Back to AD 2000-25-02 R1