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.

N81403Early Patricia A · Palmyra, PAFirst renewal noticeBuilt 1945 · S/N 7AC-21N81409Williams Jeremy · Searsport, MEBuilt 1946 · S/N 11AC-1002N81411Sale Reported · Warner Robins, GASale reportedBuilt 1945 · S/N 7AC-28N81412Taylor William E Trustee · Waynesville, MOBuilt 1945 · S/N 7AC-5N81414Monroe David M · Cary, ILBuilt 1945 · S/N 7AC-32N81415Zeman Donald G · Hinckley, MNBuilt 1945 · S/N 7AC-31N81420Dahle Timothy D · Waseca, MNBuilt 1945 · S/N 7AC-35N81421Banker James · Geneseo, NYRegistration revokedBuilt 1945 · S/N 7AC-40N81422Wadsworth Naomi W · Mount Morris, NYBuilt 1945 · S/N 7AC-43N81425Pegasus Copters LLC · Makawao, HIBuilt 1945 · S/N 7AC-42N81426Perry Flying Svc · Bastrop, LARegistration revokedBuilt 1945 · S/N 7AC45N81428Morris Dennie R · North Fort Myers, FLBuilt 1945 · S/N 7AC-46N81429Smith Warren C · Halliday, NDBuilt 1945 · S/N 7AC-47N81431Galer Charles J · Irvington, ALBuilt 1945 · S/N 7AC-49N81443Mizer James D · Hailey, IDFirst renewal noticeS/N 7AC-61N81445Coleman Marc C · Muldrow, OKBuilt 1945 · S/N 7AC-63N81447Saratoga Soaring Association · Ballston Lake, NYS/N 7AC-65N81451Vaughn Jared A · Fairfield, ILBuilt 1945 · S/N 7AC-70N81455Holcombe Richard H Trustee · Florence, ORBuilt 1945 · S/N 7AC-73N81456Gocha John H III · Greenfield Center, NYBuilt 1945 · S/N 7AC-77N81457Providence Aerospace LLC · Choctaw, OKBuilt 1945 · S/N 7AC-75N81466Kirkwood Eric J · Waterford, MIS/N 7AC-85N81468Feydo Richard D · Andover, OHBuilt 1945 · S/N 7AC-69N81472Hopkin Judith R · Perkasie, PABuilt 1945 · S/N 7AC-90N81475Helicorp LLC · Chesterfield, MOBuilt 1945 · S/N 7AC-93N81482Copaair Maintenance Services Inc · Indiantown, FLBuilt 1945 · S/N 7AC100N81484Graham Steven W · Caldwell, IDS/N 7AC-102N81485Tripp Virginia C · Vanceboro, NCBuilt 1945 · S/N 7AC-103N81488Registered aircraftBuilt 1945 · S/N 7AC-107N81494Lkn Champ LLC · Sherrills Ford, NCBuilt 1945 · S/N 7AC-104N81495Merrick Christopher D · Grass Valley, CABuilt 1945 · S/N 7AC-114N814ACAlpine Aviation Inc · Grass Valley, CABuilt 1998 · S/N 814-98N814NG7ac Aviation LLC · Fort Worth, TXBuilt 1947 · S/N 7BCM-28N81501Szabolscky Stephen L · Remington, VABuilt 1945 · S/N 7AC-118N81505Cavallaro Jack C · Jordan, NYBuilt 1945 · S/N 7AC-123N81507Kiroy Bradley R · Plattsburgh, NYBuilt 1945 · S/N 7AC-125N81508Engler Aviation LLC · Bad Axe, MIBuilt 1945 · S/N 7AC-126N81510Vihlen Steven C · Locust Grove, GABuilt 1945 · S/N 7AC-131N81511Hinson John F · Jefferson Hills, PABuilt 1945 · S/N 7AC-132N81513Macveigh Craig A · New Carlisle, OHBuilt 1945 · S/N 7AC-135N81520Stormer Isaac E · Curtis, WABuilt 1945 · S/N 7AC-146N81534Kjesbo Dean C · Norcross, MNBuilt 1945 · S/N 7AC-153N81539Braun Kevin J · Aberdeen, SDBuilt 1945 · S/N 7AC-155N81542Cottonwood Flying Club · Rockford, ILBuilt 1945 · S/N 7AC-161N81545Harper David E · Stillwater, MNBuilt 1945 · S/N 7AC-164N81551Gustafson Dale H · Kingwood, TXBuilt 1945 · S/N 7AC-170N81554Kalat Norman W III · Pinedale, AZS/N 7AC-173N81555Lightfoot Dale · Stillwater, OKBuilt 1945 · S/N 7AC-174N81565Pearman Jake J · Alamogordo, NMS/N 7AC-184N81566Whitmarsh Stephen C · Marysville, CABuilt 1945 · S/N 7AC-185
Back to AD 2000-25-02 R1