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.

N860CGLeading Edge Flight Academy LLC · Bend, ORBuilt 1976 · S/N TC-1957N860FWFlorida Fish And Wildlife Conservation Commission · Lakeland, FLBuilt 2023 · S/N 20800699N860KSKansas State University · Salina, KSBuilt 2024 · S/N 4496572N860RCCornell Christopher M · Corpus Christi, TXS/N 421B0035N86106Rodriguez Bernardino N · Hialeah, FLBuilt 1969 · S/N 337-1083N8611YCragg Gordon E · Georgetown, TXBuilt 1968 · S/N 30-1751N8614YD&D Maintenance LLC · Etna Green, INBuilt 1968 · S/N 30-1754N8615YUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1968 · S/N 30-1755N86178Lpm Sky Masters LLC · Green Cove Springs, FLS/N 337-1104N8618YGroup Aire II · Manitowoc, WIBuilt 1968 · S/N 30-1758N8619YNuse Aviation LLC · Hollidaysburg, PABuilt 1968 · S/N 30-1759N861HCN861hc LLC · Elk City, OKBuilt 1977 · S/N 421C0438N861KSKansas State University · Salina, KSBuilt 2024 · S/N 4496573N861PAParis Air Inc · Vero Beach, FLBuilt 1973 · S/N 347450063N8621YParks Ashton · Pepperell, MABuilt 1968 · S/N 30-1762N86220Gardner Daniel J · Alvord, TXBuilt 1969 · S/N 337-1115N8622YClosson Luke E Jr · Valdosta, GABuilt 1968 · S/N 30-1763N8624YRegistered aircraftBuilt 1968 · S/N 30-1765N86256Steven M Gilreath · Anderson, SCBuilt 1969 · S/N 337-1131N8625QCorona Robert Jr Dr · Bay Shore, NYFirst renewal noticeS/N TC-779N8626YThomas William R · Rochester, MNBuilt 1968 · S/N 30-1767N86285Caradine Jimmie P · Commerce, TXS/N 337-1142N8629YFarris Mark E · Richmond, KYBuilt 1968 · S/N 30-1770N862ARLe Pichon II LLC · San Juan, PRBuilt 1982 · S/N 31-8212019N862KSKansas State University · Salina, KSBuilt 2024 · S/N 4496586N86303Van Dootingh Jeffrey A · Middle Bass, OHBuilt 1969 · S/N 337-1147N863062fly-Safety LLC Trustee · Azle, TXBuilt 1969 · S/N 337-1148N8632KEano Air 340 LLC · Highland, UTBuilt 1981 · S/N 340A1243N8632YDream Flyers LLC · Cherry Hill, NJBuilt 1968 · S/N 30-1773N8635YLysiuk Lance · Andover, CTS/N 30-1776N8636KM & J General Contractors Inc · Elgin, ILBuilt 1978 · S/N 340A0562N8637KCommonwealth Capital Corp · Wilmington, DEBuilt 1978 · S/N 340A0604N8637QLindell Michael S · East Wenatchee, WABuilt 1964 · S/N TC-781N86383Euro Aviation Inc · KematenBuilt 1969 · S/N 337-1169N8638QJeffery Finis B · Washington, DCBuilt 1964 · S/N TC-784N86395Maley Adam W · Shinnston, WVBuilt 1969 · S/N 337-1171N863ATCxk1 LLC · Wilmington, DEBuilt 2025 · S/N 4496621N863CPNet Quest Management Services LLC · Winter Haven, FLBuilt 1968 · S/N 421-0117N863TWilliams Roger F · Hayward, CABuilt 1964 · S/N TC-739N86417Joseph John P II · Willis, TXBuilt 1969 · S/N 337-1181N8641MCaldwell Glenn A · Garnett, KSBuilt 1963 · S/N TC-529N8647KJughead Aircraft LLC · Salina, KSBuilt 1978 · S/N 340A0605N8647MWestern Skymasters LLC · Salt Lake City, UTBuilt 1972 · S/N 33701447N86487Flohr Linn C · Allons, TNBuilt 1969 · S/N 33701207N8648YChuss Edward · Metamora, MIBuilt 1969 · S/N 30-1791N864ATCxk1 LLC · Wilmington, DEBuilt 2025 · S/N 4496622N864CMForss Jamey L · Ferndale, WABuilt 1979 · S/N 340A0683N864SPiekarski John S · Kuna, IDBuilt 1969 · S/N TC-1208N86508Kalweit Reginald A · Page, AZBuilt 1969 · S/N 33701213N86513Northern Air & Ag Inc · Pollock, SDBuilt 1969 · S/N 33701216
Back to AD 2004-25-16 R1