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.

N83415Murray Donald L · Two Harbors, MNBuilt 1946 · S/N 7AC-2083N83420Leonardi William J · Jamesport, NYBuilt 1946 · S/N 7AC-2087N83425Graber Donald L · East Thetford, VTBuilt 1946 · S/N 7AC-2092N83426Smokovitz Joseph M · Tecumseh, MIS/N 7AC-2093N83427Registration Pending · Milton, TNRegistration pendingBuilt 1946 · S/N 7AC-2094N83429Gultch Dale R · Brookfield, WIBuilt 1946 · S/N 7AC-2096N8342VPrecision Aerial Ag LLC · Seneca, KSS/N 232N83430Harter Michael R · Greenfield, INBuilt 1946 · S/N 7AC-2097N83431Fredrickson Richard · Granite Falls, MNBuilt 1946 · S/N 7AC-2098N83436Milligan Reid D · Catawba, NCBuilt 1946 · S/N 7AC-2103N83439Mckinney Steve · Hamersville, OHBuilt 1946 · S/N 7AC-2106N83440Wright Eric K · Wills Point, TXBuilt 1946 · S/N 7AC-2107N83445Diewold Jeff E · Burlington, IABuilt 1946 · S/N 7AC-2112N83448Baker Thomas N · Grove, OKBuilt 1946 · S/N 7AC-2115N83450Fish John F · Fayetteville, GABuilt 1946 · S/N 7AC-2117N83457Havener Hunter W · Chittenango, NYBuilt 1946 · S/N 7AC-2127N83460Davis Ralph · Canon, GABuilt 1946 · S/N 7AC2129N83465Frost Beverly J · Greenfield, INBuilt 1946 · S/N 7AC-2134N83468Skyhawk Aero LLC · Montevideo, MNS/N 7AC-2137N83469Morgan Jeffrey S · Utica, INFirst renewal noticeBuilt 1946 · S/N 7AC-2138N8346VLovley Linda C · Jordan, MNBuilt 1966 · S/N 127N83474Canyon West LLC · Amarillo, TXS/N 7AC-2143N83478Barker Edward J · Claremore, OKBuilt 1946 · S/N 7AC-2149N83479Connor Timothy J · Kirtland, OHBuilt 1946 · S/N 7AC-2150N83483Moore Michael E · Renton, WABuilt 1946 · S/N 7AC-2154N83487Wilkins John K · Montgomery City, MOBuilt 1946 · S/N 7AC-2158N83488Borzoya Aero Group Inc · Slatington, PABuilt 1946 · S/N 7AC-2159N83489Flavell John P · East Bridgewater, MABuilt 1946 · S/N 7AC-2160N83495Heidbreder Mark A · Liberty, ILBuilt 1946 · S/N 7AC-2166N83496Rich Aviation Services LLC · Fort Worth, TXBuilt 1946 · S/N 7AC-2167N83499Vetrone Troy D · Wisconsin Rapids, WIS/N 7AC-2170N83500Snodgrass Richard T · Simpsonville, KYBuilt 1946 · S/N 7AC-2171N83502Robinson Samuel C · Brighton, TNBuilt 1946 · S/N 7AC-2173N83504Oak Ridge Flyers Inc · Oak Ridge, TNBuilt 1946 · S/N 7AC-2175N83507Wrasse Mark R · Rosholt, WIBuilt 1946 · S/N 7AC-2178N8350VMertz Rachel A · New Ulm, MNFirst renewal noticeBuilt 1966 · S/N 85N83515Chirtea John · Milton, DEBuilt 1946 · S/N 7AC-2186N83518Cosentino William D · Lees Summit, MOBuilt 1946 · S/N 7AC-2189N83520Songer Dylan · Veedersburg, INS/N 7AC-2193N83521Lequire Wayne A · Maryville, TNBuilt 1946 · S/N 7AC-2194N83526Mccord Mark Harlan · Valleyford, WABuilt 1946 · S/N 7AC-2199N83533Brewer Brandon B · Jonesboro, ARS/N 7AC-2209N83538Lee Justin W · Maud, TXS/N 7AC-2214N8353VN8353v LLC · Monroe, LAS/N 294N83542Vinyard Herbert O Jr · Hammond, LABuilt 1946 · S/N 7AC-2218N83544Williams Theodore · Marietta, OHBuilt 1946 · S/N 7AC-2220N83548Johnston Stephen P · Hawley, MNBuilt 1946 · S/N 7AC-2226N83555Middletown LLC · Chandler, AZBuilt 1946 · S/N 7AC-2230N83557Pressley Brandon S · York, SCBuilt 1946 · S/N 7AC-2234N83561Hutzler Matthew T · Chetek, WIBuilt 1946 · S/N 7AC-2237
Back to AD 2000-25-02 R1