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.

N666BZCorrao Ludwig Jerome Trustee · Reno, NVBuilt 2019 · S/N 20800652N666KWRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1972 · S/N 27-7304928N666XGolden Eagle LLC · Estero, FLBuilt 1973 · S/N P-234N6670YJohnson Lerell L · Sunrise, FLS/N 27-3987N6671XDairy Air LLC · Mount Crawford, VABuilt 1979 · S/N TH-1077N6672CBayview Direct LLC · Dover, DEBuilt 1978 · S/N 414A0053N6675QLoyal Aviation LLC · Loyal, WIBuilt 1973 · S/N 421B0442N6675YField Inspection LLC · Brawley, CABuilt 1980 · S/N TJ-254N6677LAeropacific Consulting LLC · Reno, NVBuilt 1979 · S/N TJ-209N6678C678c LLC · Pensacola Beach, FLBuilt 1979 · S/N TJ-235N66805Opa Aviation LLC · Littleton, NCBuilt 1980 · S/N TH-1081N6680GHorst Commercial Ventures LLC · Sanger, TXBuilt 1979 · S/N TJ-236N6681LRotary Industries Inc · Miami, FLBuilt 1979 · S/N TH-1088N6682YMcdermott James R · Somerton, AZBuilt 1968 · S/N 27-4003N6683NLn Skies LLC · Streetman, TXBuilt 1979 · S/N TJ-239N6683YGate Post Aviation LLC · Woodbury, CTBuilt 1979 · S/N TK-111N6683ZMckinney John C · Heath, TXBuilt 1979 · S/N TC-2285N66845Madsen James · Markle, INBuilt 1979 · S/N TC-2287N66849Hawk Aircraft Sales And Leasing LLC · Sterling Heights, MIBuilt 1979 · S/N TH-1092N6684VFba Leasing LLC · Mountain Brk, ALS/N TH-1089N6686DN6686d LLC · Idaho Springs, COBuilt 1979 · S/N TH-1097N66878Cool Blue Air LLC · Wilmington, DEBuilt 1979 · S/N TH-1100N66882Mrd Aero LLC · Manheim, PAS/N TC-2291N668CWPrecision Air Inc · Anchorage, AKBuilt 1980 · S/N 31-8052176N66918Lbc1 LLC · Mount Olive, NCBuilt 1980 · S/N TH-1104N6697DAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1979 · S/N ME-264N6698HNational Test Pilot School · Mojave, CABuilt 1979 · S/N ME-273N669JMMerrell Bros Aviation LLC · Kokomo, INBuilt 1980 · S/N 340A0971N669PFBurkitt Harry G · Lebanon, TNBuilt 1980 · S/N TC-2297N66AEAndreassi LLC · Bluffton, SCBuilt 1974 · S/N 31-7405187N66AFSalmon Steven B · Liberty, MOBuilt 1980 · S/N TH1132N66ALXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 44-7995200N66ATDeer Elm Aviation LLC · Owens Cross Roads, ALBuilt 1975 · S/N 31-7552042N66BGAlaska Island Air Inc · Togiak, AKS/N 31-8252032N66CAM L Air Inc · Tulsa, OKBuilt 1974 · S/N TC-1703N66CLLiberty Eagle LLC · Helena, MTBuilt 1980 · S/N 421C1019N66CWSpannhake John H · Washington, CTBuilt 1973 · S/N 310Q0844N66DHKingsbury Raymond S · Farmington, MNS/N 320E0041N66EPSpillett James Kreg · Sandy, UTBuilt 1973 · S/N 421B0520N66JCCarney James D · Germantown, TNBuilt 1977 · S/N TC-2063N66JWNowell Borders Equipment G P Inc · Edinburg, TXBuilt 1972 · S/N 27-7304967N66NPOtero Naomi Rodriguez · Kissimmee, FLBuilt 1971 · S/N TC-1407N66RAGasu LLC · Henderson, NVBuilt 1981 · S/N 340A1231N66SRInbound LLC · Overland Park, KSBuilt 1968 · S/N TC-1093N66SSAyers Leland Clayton II · Carlsbad, CABuilt 1973 · S/N TC-1567N66STStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N 348133069N66TBTurner Brothers LLC · Middleboro, MABuilt 1983 · S/N 31-8452014N66TPAmerican Aviation Aircraft Leasing Inc · El Cajon, CABuilt 1979 · S/N ME-164N66TVDodson International Parts Inc · Rantoul, KSBuilt 1959 · S/N 23-1766N66TWRolfe Bangerter Aviation LLC · Murray, UTS/N 31T-8004030
Back to AD 2004-25-16 R1