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.

N5174TMarnoch Kenneth S Trustee · Canyon Country, CAS/N 163N5175TMcclain Timothy J · Tucson, AZBuilt 1966 · S/N 147N5176TScott Judson M · Wasilla, AKBuilt 1967 · S/N 153N5176XThiel Douglas E · Chowchilla, CAS/N 188N5177TJensen Larry F · Millington, MIBuilt 1967 · S/N 219N5177XAdams John L · Carmi, ILBuilt 1969 · S/N 683N5179THiggs Kathleen A · Garden Plain, KSBuilt 1967 · S/N 139N5179XKor Reese W · Piedmont, SDBuilt 1969 · S/N 189N5180XSouthern Sky Holdings LLC · Macon, GABuilt 1969 · S/N 190N5181TSchmetter Kenneth E · Needville, TXBuilt 1967 · S/N 508N5181XKummer Nicolas · Wenatchee, WABuilt 1969 · S/N 191N5183JPalmer Jonathan J · Tygh Valley, ORS/N 11AC-629N5183TMinier Tryg · Corralitos, CABuilt 1967 · S/N 16N5183XStory James W · Byhalia, MSBuilt 1969 · S/N 170N5184XComstock Derrick B · Salol, MNBuilt 1969 · S/N 173N5185TRomano Serge · Beaverton, ORBuilt 1967 · S/N 15N5186XRochelle Stephen L · Raymond, MSBuilt 1969 · S/N 198N5187JDagger Falls LLC · Boise, IDBuilt 1979 · S/N 313-79N5187TLopes Steve R · Lancaster, WIBuilt 1967 · S/N 14N5187XBerkeland Jacob J · Bricelyn, MNBuilt 1969 · S/N 685N5188XMullahy Patrick O · Burlington, IABuilt 1969 · S/N 686N5189TZerck Joseph W · Anchorage, AKBuilt 1967 · S/N 199N518ACGernand Charles · Hoopeston, ILBuilt 2000 · S/N 448-2000N518BCN815bc LLC · Post Falls, IDBuilt 2023 · S/N 632-2023N5190TMhe Aviation LLC · Las Vegas, NVBuilt 1967 · S/N 141N5190XGawf Mike · Springdale, ARBuilt 1969 · S/N 690N5191TLeonard Jon F · Glenn, CAS/N 300N5192XDavis Wayne W · Wakefield, RIBuilt 1969 · S/N 180N5195TRainbow Flying Service LLC · Moses Lake, WAS/N 344N5195XSears Wes L · Tacoma, WABuilt 1969 · S/N 195N5198XCornwell Thomas G Jr · Eatonville, WABuilt 1968 · S/N 128N5199TOwens Roger A · San Antonio, TXBuilt 1967 · S/N 211N5199XGallarate Raymond D · Sonoma, CABuilt 1969 · S/N 211N519ACC & J Air Inc · Middletown, DEBuilt 2000 · S/N 1295-2000N519FLeonard William E · Vancouver, WAS/N 1457-2010N519MARed Baron LLC · Middletown, DEBuilt 2004 · S/N 489-2004N519MKMcleod Martin · Carthage, NCBuilt 2010 · S/N 1099 2010N51CBPukach Greg V · Topeka, KSBuilt 1977 · S/N 297-77N51ERPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 484-2004N51GTBowen Austin T · Prairie Township, NDBuilt 1968 · S/N 103N5213XSutton Aircraft Salvage LLC · Palmer, AKBuilt 1969 · S/N 177N5214XHaltmann Sven · Fairbanks, AKBuilt 1969 · S/N 178N5215XTilghman Glen A · Houston, AKBuilt 1969 · S/N 179N5219XBlack Mark A · Lawsonville, NCBuilt 1969 · S/N 695N5220XCartwheel Aviation LLC · Boise, IDBuilt 1992 · S/N 694-92N5221XVandegrift Robert W · Waynesboro, VABuilt 1969 · S/N 200N52245Poursartip Nader · Hayward, CABuilt 1975 · S/N 164-75N5228XAirbatic LLC · Huntsville, ALBuilt 1969 · S/N 206N5229XG B Acro Inc · Grandville, MIBuilt 1969 · S/N 207N5231XHolloway David G · Auburn, CABuilt 1969 · S/N 209
Back to AD 2000-25-02 R1