OpenAirDocs.org
AD 2004-25-16 R1

Registered aircraft · 10,537

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:2004-25-16-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:2004-25-16-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.

N8941GHawks Eye View LLC · Roanoke, VAS/N 340A0327N8941ZUplands Aviation Management LLC · Mineral Point, WIBuilt 1962 · S/N 310G-0041N8944YTallman Michael Daniel · Latrobe, PABuilt 1971 · S/N 39-105N8945YPipers Are Still Better LLC · Carson City, NVS/N 39106N8947YStroh Chuck · Yukon, OKBuilt 1971 · S/N 39-108N8948YKilpatrick Kerry · Somerset, NJBuilt 1971 · S/N 39-109N894JGMeasured Approach LLC · Wooster, OHBuilt 1972 · S/N 340-0098N894NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496609N8955C4k Endeavors LLC · Wadsworth, OHBuilt 1976 · S/N 34-7670158N8955YCarter Howard A III · Stafford, VABuilt 1971 · S/N 39-115N8955ZSimmons Louis Crispin · Williamsburg, VABuilt 1999 · S/N TH-1897N8956YDark Side Aeronautical Inc · Wilmington, DEBuilt 1971 · S/N 39-116N8956ZN8956z LLC · Brighton, COBuilt 1962 · S/N 310G-0056N895ACTejas Cavu LLC · Wilmington, DEBuilt 1978 · S/N 340A0558N895NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 4496503N8960MSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1963 · S/N TC-559N8962YChoate Cass Joseph · Toone, TNS/N 39-122N8962ZMorris Russell L · Fort Myers, FLBuilt 1962 · S/N 310G-0062N8963YNess Rent A Car Inc · Fargo, NDS/N 39-123N8965YLucid Thought Consulting LLC · Terre Haute, INS/N 39-127N8965ZMathison John M · Del Norte, COBuilt 1962 · S/N 310G0065N8967YQualitair LLC Trustee · MichelstadtBuilt 1971 · S/N 39-130N8969MTriple Heaven Aircraft Leasing Inc · Anchorage, AKBuilt 1964 · S/N TC-561N8969YTrident Aero Services LLC · Park City, UTBuilt 1971 · S/N 39-132N896NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496610N8970MAviator Air Flight School LLC · Grand Prairie, TXBuilt 1964 · S/N TC-594N8971YLaubscher John E · Cazenovia, NYBuilt 1972 · S/N 39-134N8973YAire Ryder LLC · Roseville, MNS/N 39-139N8976YAfricano Aircraft Management LLC DBA · Chicago, ILS/N 39-142N8976ZProsperity Properties Ltd · Southlake, TXBuilt 1962 · S/N 310G0076N8979ZKimbrel Mark D · Rochester, WABuilt 1962 · S/N 310G0079N897ATCxk1 LLC · Wilmington, DEBuilt 2026 · S/N 4496628N897NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496604N8980YTomu Fly LLC · Vero Beach, FLS/N 39-146N8981YGrey Enterprises Holdings LLC · Kalispell, MTBuilt 1972 · S/N 39-138N8982YCovington James P · Poplar Grove, ILBuilt 1972 · S/N 39-147N8982ZEverett Dwight H · Pauma Valley, CABuilt 1962 · S/N 310G0082N8986YN8986y LLC · Orlando, FLBuilt 1972 · S/N 39-151N8986ZPremier Capital Enterprises LLC · Hurricane, UTS/N 310G0086N8987ZRobinson Mark V · Vacaville, CABuilt 1962 · S/N 310G0087N898ATCxk1 LLC · Wilmington, DEBuilt 2026 · S/N 4496630N898EPMarcy Michael S · Farmington, NMBuilt 1973 · S/N 421B0429N898LMMlm Aviation LLC · Mars Hill, NCBuilt 1977 · S/N 340A0254N898TCRomar LLC · Myrtle Beach, SCBuilt 1966 · S/N 310K0084N8991GAll Trimmed Out LLC · Pierre, SDBuilt 1977 · S/N 340A0329N8991MHilgy'S Aviation LLC · Tomahawk, WIBuilt 1965 · S/N TC-937N8993ZBrutus Adrien J · Grove City, OHS/N 310G0093N8995ZRidgway Rick J · Carlisle, INBuilt 1962 · S/N 310G0095N899AVGilbert Charles L · Belleair, FLBuilt 1980 · S/N ME-353N899NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 4496638
Back to AD 2004-25-16 R1