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.

N85596Leek Roger W · Salem, ORBuilt 1946 · S/N 7AC-4339N85598Stewart Jr Emerson C · Waynesville, OHBuilt 1946 · S/N 7AC-4341N8559EFlynn Mark K · Quinton, VABuilt 1959 · S/N 7HC-8N8559VHolub Mark A · Dallas, TXBuilt 1974 · S/N 307-75N85604Schmitz Cael D · Lebanon, MOBuilt 1946 · S/N 7AC-4347N85606Backyard Aero LLC · Rockville, INBuilt 1946 · S/N 7AC-4349N85607Berge Paul J · Indianola, IABuilt 1946 · S/N 7AC-4350N85609Neader Steven W · Colusa, CABuilt 1946 · S/N 7AC-4352N85611Sellmeyer Charles A · Lakeland, FLBuilt 1971 · S/N 7AC-4355N85613Stick N Rudder Enterprises LLC · Miami, FLBuilt 1946 · S/N 7AC-4357N85615Rasmussen Peter · Orient, OHBuilt 1946 · S/N 7AC-4359N85617Swiney Timothy L · Tower Hill, ILBuilt 1946 · S/N 7AC-4361N85633Hardy John R · Wasilla, AKBuilt 1946 · S/N 7AC-4377N85634Wynia Steven P · Melba, IDBuilt 1946 · S/N 7AC-4378N85636Corradi John M · Rixeyville, VABuilt 1946 · S/N 7AC-4380N85639Duvall Paul M · Scottsburg, INBuilt 1946 · S/N 7AC-4383N85641Hammer Ronald R · Polo, ILBuilt 1946 · S/N 7AC-4385N85647Perkins Robert A · New Richmond, WIS/N 7AC-4391N8564VWarfield Gerald Alan · Saltillo, MSS/N 1049-74N85652Steenstry Larry E · Delavan, WIBuilt 1946 · S/N 7AC-4396N85656Jasinski Jack J · Necedah, WIBuilt 1946 · S/N 7AC-4401N85661Hutton Georgia Lee Trustee · Norman, OKBuilt 1946 · S/N 7AC-4406N85663Stewarts Aircraft Service Inc · Waynesville, OHBuilt 1946 · S/N 7AC-4408N85664Emslie Donis A · West Lafayette, OHS/N 7AC-4409N85668Seckerson Dale W · Jamestown, NDBuilt 1946 · S/N 7AC-4413N8566EGermond Kyle P · Indianapolis, INBuilt 1959 · S/N 7FC-354N8566VBrown Mill Ranch LLC · Lamar, COBuilt 1974 · S/N 140-75N85671Gentz Barbara J · Strykersville, NYS/N 7AC-4416N85673Sherrow Kent · Viburnum, MOBuilt 1946 · S/N 7AC-4418N85675Beranek John W · Prairieburg, IABuilt 1946 · S/N 7AC-4420N85676Bardwell Warren E · Gonvick, MNBuilt 1946 · S/N 7AC-4421N8567VDavey Bernard V · Eagle Lake, MNBuilt 1974 · S/N 1071-75N85682Teck Roger M · Mayfield, NYBuilt 1946 · S/N 7AC-4427N85688Whitbeck Larry J · Lincoln, ILBuilt 1946 · S/N 7AC-4434N8568ECochran Brandon · Covington, GABuilt 1959 · S/N 7FC-356N85691Johnson Christopher N · West Richland, WABuilt 1946 · S/N 7AC-4437N85692Duncan Christopher L · Austin, TXBuilt 1946 · S/N 7AC-4438N85695Griffith Dan W · Indianapolis, INBuilt 1946 · S/N 7AC-4441N85697Registration Pending · Hudson, INRegistration pendingBuilt 1946 · S/N 7AC-4443N8569VMachen Paul Stewart · Tallulah, LABuilt 1974 · S/N 795-75N856DMWendell Todd E · Axtell, NEBuilt 2002 · S/N 1124N856KWMurphy Michael J · Mendota Heights, MNS/N 188N85703Weaver Carl · Halstead, KSBuilt 1946 · S/N 7AC-4449N85705J Bird Air Service LLC · Cheyenne, WYBuilt 1946 · S/N 7AC-4451N85708Oltmans Michael J · Cotter, ARBuilt 1946 · S/N 7AC-4454N8570VJ K Air Inc · Chaffee, NYFirst renewal noticeBuilt 1974 · S/N 308-75N85713Sky High LLC · Fort Defiance, VABuilt 1946 · S/N 7AC-4460N85715Kiser Aviation LLC · Grottoes, VABuilt 1946 · S/N 7AC-4462N8571ESchwab Craig · Fort Walton Beach, FLBuilt 1959 · S/N 7FC-359N8571VFlywyo LLC · Kalispell, MTBuilt 1974 · S/N 1072-75
Back to AD 2000-25-02 R1