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.

N433YHRegistration Pending · Stuart, FLRegistration pendingS/N 310Q0998N4343PEnvironmental Enterprises Inc · Cincinnati, OHBuilt 1984 · S/N 34-8433034N4348YFlamingo Express LLC · Jacksonville, FLBuilt 1984 · S/N 34-8433040N434PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496064N43519Paris Air Inc · Vero Beach, FLS/N 34-7450192N4354PApache Twin Rental LLC · Harrisonville, MOBuilt 1960 · S/N 23-1854N4355PCrew Sourcing Inc · Wilmington, DES/N 23-1855N43577Novaair LLC · Lake Sherwood, CABuilt 1974 · S/N 34-7450194N4357PWatkins Lowry Jr · Louisville, KYBuilt 1959 · S/N 23-1857N4358PQualitair LLC Trustee · MichelstadtBuilt 1959 · S/N 23-1858N4358XSga Alaska Leasing LLC · Anchorage, AKBuilt 1975 · S/N 34-7670027N435PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496070N4360MOwen Kevin R Trustee · Camdenton, MOBuilt 1984 · S/N 34-8433058N43613Piper Aircraft Inc · Vero Beach, FLBuilt 1984 · S/N 34-8433068N4364C4 Aces Air LLC · Brandon, MSS/N 34-8433075N43690Fly Twin Commanche LLC · Peoria, AZBuilt 1974 · S/N 34-7450198N4369XSand Duane A · Bismarck, NDBuilt 1975 · S/N 34-7670030N436ATWheels Up LLC · Aloca, TNBuilt 1978 · S/N TH-953N436PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496079N436SCAb Prop Plane I LLC · Metairie, LABuilt 2014 · S/N 4496362N4373PMartin Vernon W · Peoria Heights, ILBuilt 1960 · S/N 23-1874N4373WDreamline Aviation LLC · Saint Petersburg, FLBuilt 1974 · S/N TC-1696N4374PDodson International Parts Inc · Rantoul, KSBuilt 1960 · S/N 23-1880N4375WTouch N Go Aeroworks LLC · Greenville, SCS/N TH-489N4377GD&P Enterprises Inc · Fresno, CABuilt 1985 · S/N TJ-479N437ALBier Ervin D · Locust Grove, GABuilt 1981 · S/N 348133156N437CBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 31-7952225N437SCAb Prop Plane I LLC · Metairie, LABuilt 2014 · S/N 4496363N4380WAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1974 · S/N TH-448N4381PChase 13 LLC · Wilmington, DES/N 23-1889N43838Rodelsperger Robert · Charleston, SCS/N 27-4334N4383PBeard Michael L · Marble Hill, MOS/N 23-1893N4387FValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 34-7670336N4387PAurora 17 Holdings LLC · Aurora, ORBuilt 1960 · S/N 23-1898N438APWhiskey 340 LLC · Tucson, AZBuilt 1977 · S/N 340A0438N438CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 4496404N438EL1 Stop Sod & Landscaping Inc · Orlando, FLBuilt 1977 · S/N 421C0274N438PABird Acquisition LLC · Phoenix, AZS/N 4496083N4394PJohnson Christopher R · Tulsa, OKBuilt 1960 · S/N 23-1906N4394WSisson James M · Orlando, FLBuilt 1974 · S/N TH-460N4395PHesse Paul W · Oxford, NCBuilt 1960 · S/N 23-1904N4396XAeromedx Corp · Wilmington, DEBuilt 1975 · S/N 34-7670038N4399PSchrunk Lloyd E · Canby, MNBuilt 1960 · S/N 23-1911N439PTKnot Mach LLC · Mchenry, ILBuilt 1974 · S/N 34-7450179N43ATOld Virginia Properties LLC · Cedar Bluff, VABuilt 1965 · S/N TC-881N43BLockard Seth J · Lebanon, TNBuilt 1963 · S/N 30-226N43BMDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 421C1224N43CCWpb Pilot Service LLC · West Palm Beach, FLBuilt 1965 · S/N 27-2820N43CW42f LLC · Key West, FLBuilt 1990 · S/N 20800175N43DAAero Management Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 340A0112
Back to AD 2004-25-16 R1