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.

N4177QAdamson Paul · Sparks, NVBuilt 1968 · S/N 310N-0077N4178SGlad Aviation LLC · Gilford, NHBuilt 1975 · S/N TH-652N417BTBridger Air Tanker 2 LLC · Belgrade, MTBuilt 1986 · S/N 1082N417EC417ec LLC · Sheridan, WYBuilt 1972 · S/N 310Q0539N417EPEpic Aviation Inc · New Smyrna, FLFirst renewal noticeBuilt 2017 · S/N 4496403N417GTLs Aerospace Inc · Big Spring, TXBuilt 1974 · S/N 27-7405467N4181QMontgomery Steven D · Cleveland, OKBuilt 1968 · S/N 310N-0081N4181TKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320D0081N4183QSpurlock Daniel C · Harrogate, TNBuilt 1968 · S/N 310N-0083N41849Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 3449179N4184QBluesky Airline LLC · La Crescenta, CAS/N 310N-0084N4186TRegistered aircraftBuilt 1966 · S/N 320D0086N4188PAero Club Valkaria LLC · Malabar, FLS/N 23-1676N4188SMajor Air LLC · Charleston, SCBuilt 1975 · S/N TH-620N4189PAdams Carlos · Hawi, HIS/N 23-1677N418BMOrion Aircraft Holding LLC · Rocky Mount, VABuilt 1982 · S/N 421C1227N418BTBridger Air Tanker 3 LLC · Belgrade, MTBuilt 1985 · S/N 1083N418DPPiotrowski Enzo · Miami, FLBuilt 1976 · S/N 34-7670239N418GFlight 762 LLC · New Orleans, LABuilt 1966 · S/N 310K0067N418RWPower Aero Inc · Scituate, RIBuilt 1978 · S/N TH-917N418TRAir Sunrise LLC · Mountain View, CABuilt 1982 · S/N 340A1525N4191PBerry Michael C · Stanfield, AZBuilt 1959 · S/N 23-1679N4191SNiblett Brian E · Mount Pleasant, TXBuilt 1975 · S/N TC-1867N41960Tiffin Aviation Services Inc · Nogales, AZBuilt 1974 · S/N 34-7450165N4196PHarmon Aviation LLC · Exeter, NHBuilt 1959 · S/N 23-1684N4196QLand Air Enterprises · Boynton Beach, FLS/N 310N-0096N4197CAll In Aviation LLC · Townville, SCS/N 414-0513N4198BAero Flight Flying Club · Minneapolis, MNBuilt 1959 · S/N 23-1687N419BTBridger Air Tanker 4 LLC · Belgrade, MTBuilt 1986 · S/N 1089N419HCZangs William J · Poplar Grove, ILBuilt 1978 · S/N 34-7870376N41BGRaising Lazarus LLC · Farmington, NMS/N 340A0305N41BPSturdevant Harold L Jr · Kalispell, MTS/N 30-644N41CFJet Movers LLC · Vandalia, ILS/N TJ-47N41CUEncinal Aviation LLC · Springfield, MOS/N 421C0318N41DMMission Air LLC · Oklahoma City, OKBuilt 1959 · S/N 23-1566N41ECTreeline Helicopters Inc · Bristol, TNS/N TH-471N41EGSal Aviation Inc · Wilmington, DEBuilt 1978 · S/N TK-75N41LCBowen William A III · California, MDBuilt 1972 · S/N 310Q0502N41LJPic Aviation Group LLC · Cornelia, GABuilt 1982 · S/N 421C1252N41LM92 Aviation LLC · Whiteville, NCS/N TH-967N41MMRiester Robbin W · Navarre, FLS/N 310H0017N41NRSholy Fred · Granada Hills, CAS/N 340A0488N41PBCrestview Residential Properties LLC · Laurinburg, NCBuilt 1974 · S/N 421B-0845N41PLTj Air Holdings Inc Trustee · Wilmington, DES/N 30-1293N41RTVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1964 · S/N TC-666N41SPN41sp LLC · New Port Richey, FLFirst renewal noticeBuilt 1975 · S/N 421B0937N41TGBusch John · Chapin, SCBuilt 1973 · S/N TC-1581N41TNBvbd Aviation LLC · Charlotte, NCBuilt 1980 · S/N 31-8012034N41TTAlvis Michael Ernie · Sparta, TNBuilt 1972 · S/N 414-0263N41WFJack Ryan Aviation · Woodcliff Lake, NJBuilt 1976 · S/N 421C0205
Back to AD 2004-25-16 R1