OpenAirDocs.org
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.

N9128EEngelman Jonathan Phillip · Prather, CABuilt 1946 · S/N 11AC-761N9128LSmith Stuart T · Murrieta, CAS/N 199-71N9128RExtraspecial LLC · Wilmington, DEBuilt 1958 · S/N 7FC-230N9129LOsi Flyers Inc · Oak Ridge, TNBuilt 1970 · S/N 265-71N9129SAugust Aero LLC · Kalispell, MTS/N 7GCB-36N912CPHoppe Gregory M · Big Lake, AKS/N 165N912MAEmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2004 · S/N 9482004N9130EDufriend James M III · Newton, KSBuilt 1946 · S/N 11AC-763N9130LJohnsen David E · Oklahoma City, OKBuilt 1970 · S/N 805-71N9131EBryant Mark L · Montrose, GABuilt 1946 · S/N 11AC-764N9131LAeronautical Technical Service Inc · Collierville, TNS/N 806-71N9133LThompson Clark J · Rosharon, TXBuilt 1971 · S/N 36-72N9134LSipes Greg A · North Pole, AKS/N 310-71N9135EWelborn Jason D · Sand Springs, OKBuilt 1946 · S/N 11AC-768N9135LStudie Billy D · Wasilla, AKS/N 3-71N9136LWelch Thomas R · Rimrock, AZBuilt 1971 · S/N 4-71N9139LHurley William J III · Abingdon, ILBuilt 1971 · S/N 8-71N913JKKing Michelle L · Atlanta, GABuilt 1974 · S/N 1018-74N9140LPretorius Ellen T · Smithville, OHBuilt 1971 · S/N 807-71N9141LAmerican Airpower Heritage Flying Museum · Dallas, TXS/N 808-71N9142LBrown Michael E Jr · Timmonsville, SCBuilt 1971 · S/N 11-71N9146ESmith Joseph · Sebring, FLBuilt 1946 · S/N 11AC-778N9146LMalone Aaron E · Wasilla, AKS/N 812-71N9147ELucchesi Jeffrey M · Ballwin, MOBuilt 1946 · S/N 11AC-781N9147LNewton Justin T · Knox City, MOBuilt 1971 · S/N 13-71N9150ELinstad Daniel E · Canby, ORS/N 11AC-784N9150LKing Jessie M · Spring Valley, MNBuilt 1971 · S/N 12-71N9150UBehrends Steven R · Livingston, TXS/N 7AC4922N9151LCerrato Michael J · Dublin, OHBuilt 1971 · S/N 306-71N9152LBaker Glen M · El Reno, OKBuilt 1971 · S/N 810-71N9153EDoll John M · Austin, TXBuilt 1946 · S/N 11AC-787N9154EFarwell Allen C · Cottage Grove, WIS/N 11AC-786N9154LKost Steven F · Fort Pierre, SDFirst renewal noticeS/N 22-71N9155ECarey Richard L Trustee · Hagerstown, INBuilt 1946 · S/N 11AC-789N9155LBelisle Barry A · Lancaster, TXBuilt 1971 · S/N 16-71N9156EClayton Steve · San Antonio, TXS/N 11AC-790N9156LLerner Michael M · Tehachapi, CABuilt 1971 · S/N 17-71N915LFLingo Joshua B · Oak Grove, LABuilt 1998 · S/N 390-98N915RSHayward Houston C · Lansdale, PABuilt 1999 · S/N 1260-99N9161LBredlow Farming Co Inc · England, ARBuilt 1971 · S/N 23-71N9162EDs Batchelor Holding LLC · Clark, SDS/N 11AC-797N9162LBranum Seth L · Jonesboro, ARBuilt 1971 · S/N 24-72N9163LLewallen William J · Eloy, AZBuilt 1971 · S/N 25-71N9164EDenman Thomas G · Mims, FLBuilt 1946 · S/N 11AC798N9164LHodges Robert J · Savannah, GABuilt 1971 · S/N 26-71N9165LJajade Farms Inc · Birmingham, MOBuilt 1971 · S/N 27-71N9166LSutton Aircraft Salvage LLC · Palmer, AKBuilt 1972 · S/N 319-72N9167EKulton Jon T · Somonauk, ILBuilt 1946 · S/N 11AC-800N9167LBravo 3 Aviation LLC · York, NES/N 793-72N9169LSimons Grant C · White Owl, SDBuilt 1971 · S/N 320-72
Back to AD 2000-25-02 R1