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.

N4293TDiehl Ryan J · Columbus, OHS/N 7AC5466N4295EKaushagen Luther G · Thief River Falls, MNBuilt 1947 · S/N 7BCM-420N4297EMccallum James W · Ambrose, GABuilt 1948 · S/N 11CC-169N4299EViggiano Louis Jr · San Antonio, TXBuilt 1948 · S/N 7DC-113N429ACRegistration Pending · Morris, ILRegistration pendingBuilt 1999 · S/N 429-99N4300CBerke Steven M · Black Hawk, SDBuilt 1955 · S/N 7EC-300N4303CWhite David W · South Fulton, TNBuilt 1955 · S/N 7EC-303N4305EKlos Jeff · Plevna, MTBuilt 1947 · S/N 7BCM-369N4306CHarsh David L · Daniels, WVBuilt 1955 · S/N 7EC306N4308CBrooks Clifton B · Harrah, OKBuilt 1955 · S/N 7EC-308N4310CTadic Michael · Skagway, AKBuilt 1955 · S/N 7EC-310N4310EDittlinger Bret W · Anchorage, AKBuilt 1948 · S/N 11CC-176N4311CPage Aerial Service Inc · Rochelle, ILBuilt 1955 · S/N 7EC-311N4311EHeavirland Robert A · North Branch, MNBuilt 1948 · S/N 11CC-177N4313CJohnson Charles M · Malta, MTBuilt 1955 · S/N 7EC-314N4316CNorman Shawn T · Rothsay, MNBuilt 1955 · S/N 7EC-317N4316ELandry Roger W · Alstead, NHBuilt 1948 · S/N 7DC-26N4317CSasinowski Joseph Vance · Anchorage, AKBuilt 1955 · S/N 7EC-318N4318CEakins Clifford P · Bloomfield, IABuilt 1955 · S/N 7EC-323N431MARegent Trust Corporation Trustee · Wichita, KSBuilt 2022 · S/N 1200-2022N431SAArgotsinger Michael · Wichita, KSBuilt 2004 · S/N 952-2004N4321CWeiss Elliott · Fresno, TXS/N 7EC-326N4322CSparrowhawk Aviation LLC · Moraine, OHS/N 7EC-327N4324CCornfield Cruisers LLC · Urbandale, IABuilt 1955 · S/N 7EC-333N4328CWelch Thomas R · Modesto, CABuilt 1955 · S/N 7EC-337N4328EDangelo Dennis L · Xenia, OHBuilt 1948 · S/N 7AC-7181N432TEEmmons Thomas M · Millington, MIS/N 85N4333EWatters Robert K · Dwight, ILBuilt 1948 · S/N 11CC-186N4333KWeisbeck Kenneth J · Scottsdale, AZS/N 115-2N4334CEyring Joshua S · Diamond, OHBuilt 1955 · S/N 7EC-347N4336CRegistration Pending · Billings, MTRegistration pendingS/N 7EC-352N4337CSpence Stephen L · N Richland Hills, TXS/N 7EC-353N4338EMay John F · Sandusky, OHS/N 11CC-191N4339CMurray Erwin L Jr DBA · Emporium, PABuilt 1955 · S/N 7EC-355N433DLBlue Sky Transport LLC · Deland, FLBuilt 2007 · S/N 1013-2007N433HKuhn Darrell G · Irma, WIBuilt 1956 · S/N 7BCM-159N433TJKennedy John A · Marietta, GABuilt 1992 · S/N 661-92N4340CAndersen Andy · Sutton, AKBuilt 1955 · S/N 7EC-356N4341CHofer Perry L · Doland, SDBuilt 1955 · S/N 7EC-357N4341EJeffryes Richard B · Creswell, ORBuilt 1948 · S/N 7DC-2N4343CHarwood Mark D · Cossayuna, NYBuilt 1955 · S/N 7EC-361N4346CHill H Charles II · South Hero, VTBuilt 1955 · S/N 7EC-365N4348CRankin Kevin J · Maryville, MOBuilt 1955 · S/N 7EC-367N4348EBarts Flying Service Inc · Storm Lake, IABuilt 1948 · S/N 7DC-9N4349CCollins Jeffrey L · Camilla, GAS/N 7EC-368N4349ECook David A · Castleton, NYBuilt 1948 · S/N 7DC-10N434DTTiffany David J · Lyme, CTBuilt 2008 · S/N 509-2008N4351CKinkle Douglas C Trustee · Colusa, CABuilt 1955 · S/N 7EC-370N4351EDetroit Lakes Aviation Inc · Detroit Lakes, MNS/N 7DC-12N4352CThor David L · Thompson Falls, MTBuilt 1955 · S/N 7EC-371
Back to AD 2000-25-02 R1