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.

N48TDFoster Aviation LLC · Missoula, MTBuilt 1997 · S/N 123297N491MABelle Casa Sport LLC · Tarpon Springs, FLBuilt 2004 · S/N 957-2004N4952SPrecision Delta Corp · Ruleville, MSBuilt 2010 · S/N 1458-2010N4952VMartin Ryan L · Moses Lake, WAS/N 47-822N4955VSindlinger Lyle J · Puyallup, WABuilt 1947 · S/N 47-841N495ACRegistration Pending · Honolulu, HIRegistration pendingBuilt 1999 · S/N 1265-99N495DBWolfson Jason · Duxbury, MABuilt 1995 · S/N 372-95N495GEastern Stearman Inc Trustee · Leesburg, VABuilt 2014 · S/N 1470-2014N495JCCampillo Jorge A · Miami, FLBuilt 1977 · S/N 357-77N496ECHatfield James D · Hagerman, IDBuilt 2004 · S/N 1356-2003N497ACSwest Properties LLC · Carson City, NVBuilt 2005 · S/N 497-2005N4995Stein David E · Modesto, CABuilt 1971 · S/N 10-71N499DPFarrington John R · Cedar Park, TXBuilt 2010 · S/N 2001-2010N49DTClark Coy A · Raeford, NCBuilt 1957 · S/N 7FC-117N49EELessley Aviation LLC · Carrollton, MSBuilt 1998 · S/N 1239-98N49NHNehemiah Aviation LLC · Leavenworth, KSBuilt 1975 · S/N 1106-75N49TPAnzalone Gary A · Hackettstown, NJBuilt 2002 · S/N 1333-2002N4DG4dg LLC · Tacoma, WABuilt 2021 · S/N 611-2021N4FRW J Rothwell Ranch Co · Hyannis, NEBuilt 1973 · S/N 384-73N4JJJoseph John P · Hewitt, NJBuilt 2001 · S/N 1308-2000N4PDSteck Paul D · Pelham, NHBuilt 1974 · S/N 689-74N4UNXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 1324-79N500BCGwinn Donald R · Mccall, IDBuilt 2013 · S/N 557-2013N501BAFalcon Air LLC · Orlando, FLS/N 326-72N501BSBlue Skies Enterprises Of Texas · Richmond, TXBuilt 2005 · S/N 1005-2005N501DWParmar Bluffs LLC · Parker, SDBuilt 1996 · S/N 939-76N501ELJourneys Aviation Inc · Boulder, COBuilt 2009 · S/N 1404-2009N50240Carr James T · Scotts, MIBuilt 1978 · S/N 436-78N50246Taubman Jason · Greenland, NHBuilt 1978 · S/N 1052-78N50247Haywood Charles E Jr · Valrico, FLS/N 437-78N50259Coker Steve L III · Tyler, TXBuilt 1978 · S/N 441-78N5025CSamalon William S Trustee · Juneau, AKBuilt 1978 · S/N 1053-78N5025DCal-Aerofab Flight Academy Inc · Chino, CABuilt 1978 · S/N 366-78N5025EStokes Field LLC · Mount Vernon, MOBuilt 1978 · S/N 438-78N5025FAllen Scott L · Ogallala, NEBuilt 1978 · S/N 1054-78N5025MRezich Nicholas R · Green Bay, WIBuilt 1978 · S/N 1274-78N5025NMalott Corwin · Spokane, WAS/N 439-78N5025PFoley Jeffrey W · Scappoose, ORBuilt 1978 · S/N 440-78N5025QAppel Joshua D · Redfield, SDS/N 1056-78N5025UDuke Michael R · Mc Gregor, TXBuilt 1978 · S/N 1275-78N50264Hooper Kenneth R · Hermitage, TNBuilt 1979 · S/N 1328-79N5026BLaurie Craig M · Anchorage, AKBuilt 1978 · S/N 442-78N5026ETurner Greg W · Delta Junction, AKBuilt 1978 · S/N 1057-78N5026FRegistration Pending · Greenville, NCRegistration pendingBuilt 1978 · S/N 1276-78N5026GJohnson Steven L · Salol, MNBuilt 1978 · S/N 1058-78N5026KGriswold David M · Port Townsend, WABuilt 1978 · S/N 1278-78N5026NWright Bruce M · Rosharon, TXBuilt 1979 · S/N 570-79N5026SSchwenker Jerry D · Maquoketa, IAFirst renewal noticeBuilt 1979 · S/N 1326-79N5026TGroom Lawrence W · Saint George, UTS/N 1327-79N50271Sawyer Johnson Inc · Osceola, WIBuilt 1979 · S/N 572-79
Back to AD 2000-25-02 R1