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.

N85337Port Townsend Aero Museum · Port Townsend, WAS/N 7AC-4076N85338Minor J Mark · Rockledge, FLBuilt 1946 · S/N 7AC-4077N85339Aviators Of Texas LLC · Georgetown, TXS/N 7AC-4078N85343Greene Antony B · North Fort Myers, FLBuilt 1946 · S/N 7AC-4083N85344Krog Donald C · Somerville, NJBuilt 1946 · S/N 7AC-4084N85348Passeno Mark A · Cheboygan, MIS/N 7AC-4088N85349Paine Oliverb III · Fulton, NYBuilt 1946 · S/N 7AC-4089N8534ETyler Ronald A Jr · Valrico, FLBuilt 1959 · S/N 7FC-340N85353Linstad Daniel E · Canby, ORBuilt 1946 · S/N 7AC-4093N85362Demmers Jesse T · Jordan, MNBuilt 1946 · S/N 7AC-4102N85364Roberts Raymond W · Smithfield, RIBuilt 1946 · S/N 7AC-4104N85366Lemieux Kenneth G · Oneida, TNBuilt 1946 · S/N 7AC-4106N85367Stewart Richard S Jr · North Liberty, INBuilt 1946 · S/N 7AC-4107N8536EKaminski Daniel · Monee, ILBuilt 1959 · S/N 7FC-342N8537Kopaska Linda · Guthrie Center, IABuilt 1973 · S/N 452-73N85371Williams Darrell W · Fayetteville, ARBuilt 1946 · S/N 7AC-4111N85375Ropp Dorothy E · Poplar Grove, ILBuilt 1946 · S/N 7AC-4115N85378Benger Jeffrey S · Bozeman, MTBuilt 1946 · S/N 7AC-4118N8537EHoech Neal L · Sandpoint, IDBuilt 1959 · S/N 7FC-343N85380Holmgren Michael G · Kulm, NDBuilt 1946 · S/N 7AC-4120N85381Kieffer Michael · Honey Creek, IABuilt 1946 · S/N 7AC-4121N85383Faulkner Ronnie L · Mount Ida, ARBuilt 1946 · S/N 7AC-4123N85384Stenger Douglas E · Banks, ORFirst renewal noticeBuilt 1946 · S/N 7AC-4124N85387Temple Peter L · Harrisville, NHS/N 7AC-4127N8538EAgaliotis Paul E · San Martin, CABuilt 1959 · S/N 7FC-344N85393Crooks Sean P · Canton, MIS/N 7AC-4133N85394Cunningham Blake F · Rockville, INBuilt 1946 · S/N 7AC-4134N85396Patton Steven R · Wayne, OHBuilt 1946 · S/N 7AC-4136N85397Kyle E Rich Inc · Sumner, IABuilt 1946 · S/N 7AC-4137N85398Gann Gerald N · Conway, MOBuilt 1946 · S/N 7AC4138N8539EWombles Michael · Greenwood, INBuilt 1959 · S/N 7FC-345N85400Champ85400 LLC · West Jordan, UTBuilt 1946 · S/N 7AC-4140N85401Bartee Chaddick M · Lubbock, TXBuilt 1946 · S/N 7AC-4141N85403Fossa Joseph · Essex, MABuilt 1946 · S/N 7AC-4143N85406Crum John P · Waterloo, ILS/N 7AC-4146N85411Debaun Gary · Terre Haute, INBuilt 1946 · S/N 7AC-4151N85413Becker William A · Burlington, WIBuilt 1946 · S/N 7AC-4153N85420Registered aircraftBuilt 1946 · S/N 7AC-4160N85421Tillery Bernard Ray · Perris, CABuilt 1946 · S/N 7AC4161N85424Dirks Daniel P · Seguin, TXBuilt 1946 · S/N 7AC-4164N85425Micro Aerodynamics Inc · Anacortes, WAS/N 7AC4165N8542ESchillo Paul J · Wrenshall, MNBuilt 1959 · S/N 7EC-697N85430Weitemier Jeffrey D · Browerville, MNBuilt 1946 · S/N 7AC-4170N85433Sturgell James A · Blanchard, OKBuilt 1946 · S/N 7AC-4173N85434Letourneau Robert J · Plympton, MABuilt 1946 · S/N 7AC-4174N85439Kupka John J · Fremont, OHBuilt 1946 · S/N 7AC-4179N85440Catt Kevin R · Salinas, CABuilt 1946 · S/N 7AC-4180N85442Hayton James B · Sedro Woolley, WABuilt 1946 · S/N 7AC-4182N85448Poklar Norman A · Mount Orab, OHBuilt 1946 · S/N 7AC-4188N85450Barnes Rodney E · Oconomowoc, WIBuilt 1946 · S/N 7AC-4190
Back to AD 2000-25-02 R1