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.

N8594EMehlbauer Robert B · Owensboro, KYBuilt 1959 · S/N 7FC-367N8594VCosta James J · Tulare, CABuilt 1974 · S/N 799-75N8595VAnacortes Associates LLC · Anacortes, WABuilt 1974 · S/N 1076-75N8596Tooley Joe K · Quanah, TXS/N 11AC-381N85962Perez Daniel E · Parsons, KSS/N 11AC-380N85969Holcomb Murray B · Palestine, TXBuilt 1946 · S/N 11AC-392N85971Johnson Jerome L · Victorville, CABuilt 1946 · S/N 11AC-390N85974Nodorft Aviation LLC · Orlando, FLBuilt 1946 · S/N 11AC-388N85976Savage David E · American Falls, IDBuilt 1946 · S/N 11AC-398N8597EHightower Jerry C · Boyd, TXFirst renewal noticeS/N 7FC-368N8597VSitta Donald C · Farmington, NMBuilt 1975 · S/N 150-75N8598Davidson Gary A · Bunnell, FLBuilt 1946 · S/N 11AC-400N85981Fey Duane E · Fairfield, CABuilt 1946 · S/N 11AC-399N85986Miller Raymond S · Knightstown, INBuilt 1946 · S/N 11AC-401N85991Kleinwolterink David · Sibley, IABuilt 1946 · S/N 11AC-406N85997Mull Floyd D · Granbury, TXFirst renewal noticeBuilt 1946 · S/N 11AC-416N85999Denney Mark J · Battlefield, MOBuilt 1946 · S/N 11AC-417N8599EPengilly Sky LLC · Ellicottville, NYBuilt 1959 · S/N 7FC-365N8599VObx Airplanes LLC · Manteo, NCS/N 151-75N85CSeay Edward A · Signal Mountain, TNBuilt 1967 · S/N 29N85GPRay Hardee · Dupont, WABuilt 2010 · S/N 1096-2010N85MLEscott Aerial Spraying LLC · El Reno, OKBuilt 1965 · S/N 7ECA-277N86001Martino John F · Kingston, NYBuilt 1946 · S/N 11AC-420N86004Richardson Mark A · Shepherdsville, KYBuilt 1946 · S/N 11AC-423N86007Woodard Dale F · Deer River, MNBuilt 1946 · S/N 11AC-426N86008Kraus Russell E · Albemarle, NCBuilt 1946 · S/N 11AC-425N8601Lewis Richard F · Halifax, VABuilt 1973 · S/N 917-73N86012Sinclair Thomas J · Kennebunkport, MEBuilt 1946 · S/N 11AC-433N86013Correa Ruben D · Horn Lake, MSBuilt 1946 · S/N 11AC-441N86014Lipper Charles S Personal Representative · Stone Mountain, GAFirst renewal noticeBuilt 1946 · S/N 11AC-434N86016Wood John S · Boulder, COBuilt 1946 · S/N 11AC436N86019Airspeed Inc · Winter Park, FLBuilt 1946 · S/N 11AC-437N86021Riner Gary E · Clinton, TNBuilt 1946 · S/N 11AC-440N86024Roush Thomas M · Tallassee, TNBuilt 1946 · S/N 11AC-446N8602VSchumaker Daniel J · Glenville, MNBuilt 1974 · S/N 1078-75N86033Lingo Hartlage And Dale LLC · Kokomo, INBuilt 1946 · S/N 11AC-445N86036Leblanc John D · De Leon Springs, FLS/N 11AC-448N86037Studier Joe · Guyton, GAS/N 11AC-459N86043Kuehne Thomas M · Maryland Heights, MOBuilt 1946 · S/N 11AC-464N86044Registration Pending · Plant City, FLRegistration pendingS/N 11AC-465N86045Matthews Michael S · Reno, NVBuilt 1946 · S/N 11AC-468N86051O'Connor Michael D · Jackson, MIBuilt 1946 · S/N 11AC-471N86058Lewinski John T · Macomb, MIS/N 11AC-480N8605VGibney Ricky D · Fargo, NDBuilt 1974 · S/N 501-75N86060Trimmer Marvin E · Willow, AKBuilt 1946 · S/N 11AC-481N86067Long Michael J · Weyauwega, WIBuilt 1946 · S/N 11AC-490N86073Dirigo Aerospace Solutions LLC · Sumner, MES/N 11AC-496N86079Gault Donald D · Neosho, WIBuilt 1946 · S/N 11AC-502N86082Renwick Dennis E · Gilmer, TXBuilt 1946 · S/N 11AC-504N86085Zeuch Michael A · Pasadena, MDS/N 11AC-508
Back to AD 2000-25-02 R1