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.

N731XSchorsch Kerry · New England, NDBuilt 1957 · S/N 51N733MWWebb Matthew · Denton, TXBuilt 1967 · S/N 7GCBC-15N736JBBrownell Kenneth C · Leverett, MABuilt 1995 · S/N 1209-95N736LRegelbrugge Marc · El Dorado, CABuilt 2011 · S/N 1031-2011N737ADDe Zafra Aaron · Mill Valley, CABuilt 2004 · S/N 941-2003N73JGMeyer Gordon W · Huber Heights, OHBuilt 1973 · S/N 122-74N73PAJones Brandon B · Saint Francisville, LABuilt 1973 · S/N 79-73N73PCMedearis Jeff W · Plevna, MTS/N 7ECA-48N73TDWeber Michael Scott · Gonzales, LABuilt 1973 · S/N 278-73N73XDN73xd LLC · Houston, TXBuilt 2014 · S/N 1136-2014N7400BHartmann Jeffrey N · Chico, CABuilt 1956 · S/N 7EC-430N7401BSherman David B · Readfield, MEBuilt 1956 · S/N 7EC-431N7402BRoberts Christopher J · Andover, KSBuilt 1956 · S/N 7EC-432N7405BDennis Rick L · Poughkeepsie, NYBuilt 1956 · S/N 7EC-437N7406BKraft Tyrone H · Timber Lake, SDS/N 7EC-438N7407FFp Aircraft Holdings LLC · Alvord, TXBuilt 1999 · S/N 416-98N7411BWilcox Stacy S · Parker, COBuilt 1956 · S/N 7EC-443N7412BGonzales Donald M · Columbia Station, OHBuilt 1956 · S/N 7EC-444N7417BNelsonmiguel E · Lake Stevens, WAS/N 7EC-451N7420BFreeman James L · Decatur, GABuilt 1956 · S/N 7EC-454N7421BBrowns Valley Aviation LLC · Utica, KYBuilt 1956 · S/N 7EC-455N7423BSiglin Shaw D · Wellsboro, PABuilt 1956 · S/N 7EC-461N7425BGreen William D · Fairbanks, AKBuilt 1956 · S/N 7EC-463N7426BOdlozil Henry W Sr · Ennis, TXBuilt 1956 · S/N 7EC-464N7427BBouton Glenn A · Kasilof, AKBuilt 1956 · S/N 7EC-465N7428BGrasshopper L-16 LLC · Greeley, COS/N 7EC-466N7430BBugbee Frank S Jr · Schwenksville, PABuilt 1956 · S/N 7EC-468N7432BSmith David C · Malott, WABuilt 1956 · S/N 7EC-470N7432PWeber William A · Brodhead, WIS/N 25N7433BRegistration Pending · Beebe, ARRegistration pendingBuilt 1956 · S/N 7EC-471N7436BLooper Kyle · Las Vegas, NVBuilt 1956 · S/N 7EC-474N7438BLampe Jared Joseph · Turner, MIS/N 7EC477N7439BWoyte John F · Eagle River, AKS/N 7EC-478N743ACOlsson Charles E · West Point, VABuilt 1995 · S/N 753-95N743JBLiley Brian A · Fall Branch, TNBuilt 2000 · S/N 417-2000N743JFPanasuk Austin R · Sidney, MTS/N 419-74N7440BGoethel Eric D · Hampton, NHBuilt 1956 · S/N 7EC-485N7447BCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1956 · S/N 7EC-496N744ABBeverung Robert D · Manitowish Waters, WIBuilt 2025 · S/N 1491-2026N744JAWiebe Albert · Seminole, TXBuilt 1968 · S/N 615N744SGGimblin Robert Steven Trustee · Yuba City, CABuilt 2017 · S/N 582-2017N7451BBone Mitchell T · Calhoun, GABuilt 1956 · S/N 7EC-500N7452BOesper Peter F · Taos, NMBuilt 1956 · S/N 7EC501N7455BRichards Troy L · Saint Jo, TXBuilt 1956 · S/N 7EC-504N7456GGregory Larry C Trustee · Farmington, MOS/N 129N7459BSchulert Philip J · Lebanon, TNFirst renewal noticeBuilt 1956 · S/N 7EC-508N745LSWeaver Chris D · Hallam, NEBuilt 1974 · S/N 291-74N745MSSchamel Michael A · Salem, INS/N 126-74N7462BKrumbine David A · Lebanon, PABuilt 1956 · S/N 7EC-520N746ACCaldwell Robert I · Danville, KYBuilt 1946 · S/N 7AC 6008
Back to AD 2000-25-02 R1