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.

N83295Steffey Charles S · Raleigh, NCBuilt 1946 · S/N 7AC-1962N8329VBuck Timothy A · Howland, MES/N 119N83300Dennis John Mark L · Paola, KSS/N 7AC-1967N83303Rackley Steven P · Livermore, CABuilt 1946 · S/N 7AC-1970N83304Lorenz Brian J Trustee · Ballwin, MOBuilt 1946 · S/N 7AC-1971N83308Clinton Richard C · Fair Oaks, CABuilt 1946 · S/N 7AC-1975N83309Del Martin Lp · Spring, TXS/N 7AC-1976N8330VJensen Carla J · Pingree, IDBuilt 1966 · S/N 43N83311Ballard Alexander Jr · Conneaut Lake, PAS/N 7AC-2034N83314Hampton Michael D · Marshfield, MOBuilt 1946 · S/N 7AC-1979N83317Hughes Michael C · Wasilla, AKS/N 7AC-1982N83318Miller Richard E · Philip, SDBuilt 1946 · S/N 7AC-1985N8331VAirplane Binnis LLC · Janesville, WIBuilt 1966 · S/N 477N83320Lynn Lonnie A · Jesup, GABuilt 1946 · S/N 7AC-1987N83321Lovern Steven B · Newton, NCBuilt 1946 · S/N 7AC-1988N83322Mister Jonathan · Roaring Spring, PABuilt 1946 · S/N 7AC-1989N83323Kijowski Thomas C · Freeport, PABuilt 1946 · S/N 7AC-1990N83327Olear Inc · Evansville, INBuilt 1946 · S/N 7AC-1994N83333Chipman Jeff M · Rising Sun, INBuilt 1946 · S/N 7AC-2000N83336Pease Gordon W · Hampden, MEFirst renewal noticeBuilt 1946 · S/N 7AC-2003N83340Brekhus Susan Marie Wissler · Tenino, WABuilt 1946 · S/N 7AC-2007N83341Herridge Douglas E · Tacoma, WABuilt 1946 · S/N 7AC-2008N83342Cummins Michael V · Modesto, CAS/N 7AC-2009N83348Miller Sean C · New Carlisle, OHBuilt 1946 · S/N 7AC-2015N8334VRegistration Pending · Milton, FLRegistration pendingBuilt 1966 · S/N 482N83352Deckard Audie T · Independence, ORBuilt 1946 · S/N 7AC-2019N83355Krueger Steven A · Merrill, WIBuilt 1946 · S/N 7AC-2022N83357Mcginn Robert W · Marion, NCBuilt 1946 · S/N 7AC-2024N8335VLisoski Derek L · Clark Fork, IDBuilt 1966 · S/N 474N83360Sankey Paul F · Colusa, CABuilt 1946 · S/N 7AC-2027N83361Maynard Mark L · Kendall, NYBuilt 1946 · S/N 7AC-2028N83363Van Bergen Mark S · Soquel, CABuilt 1946 · S/N 7AC-2030N83366Texas Warbirds LLC · Lewes, DEBuilt 1946 · S/N 7AC-2033N83369Bellamy John-Mark · Freeville, NYS/N 7AC-2036N8337VWydronek Joseph A · Tucson, AZBuilt 1966 · S/N 422N83385Nelson William J · Mahnomen, MNBuilt 1946 · S/N 7AC-2052N83387Goodwin Richard L · Northfield, MNBuilt 1946 · S/N 7AC-2054N83388Grubs Jon P · White Bear Lake, MNBuilt 1946 · S/N 7AC-2055N83389Snyder Michael Scott · Erie, COS/N 7AC-2056N8338VGustafson Cody A · Corvallis, ORBuilt 1966 · S/N 401N83391Abbe Thomas E · Wasilla, AKBuilt 1946 · S/N 7AC2058N83393Jasinski Jack J · Necedah, WIBuilt 1946 · S/N 7AC-2060N83399Latimer Francis E · Washingtonville, NYBuilt 1946 · S/N 7AC-2066N83401Macario Mark A · Weirsdale, FLBuilt 1946 · S/N 7AC-2068N83405Banner Bernard C Jr Trustee · Lawrenceburg, INS/N 7AC-2072N83406Epps Edward A · Texarkana, TXBuilt 1946 · S/N 7AC-2074N83407Travis Johnathan M · Griffin, GABuilt 1946 · S/N 7AC2075N83409David P St George · Ithaca, NYBuilt 1946 · S/N 7AC-2076N83410Peters William D Jr · Charleston, WVBuilt 1946 · S/N 7AC-2077N83414Higgins Bennett P · Brewer, MEBuilt 1946 · S/N 7AC-2082
Back to AD 2000-25-02 R1