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.

N317PZFairmont State University · Fairmont, WVBuilt 1980 · S/N 27-8054047N317RJN317rj Inc · Maitland, FLBuilt 1966 · S/N 30-1249N317SFLasher Patrick R · Magnolia, DES/N 31-7300912N3182LN303cj LLC #1 · Lexington, KYBuilt 1999 · S/N TH1882N3183L4 All In Inc · North Fort Myers, FLBuilt 1965 · S/N 310J0183N3184LKimbrell Heath · Quinlan, TXS/N 310J0184N3187PAir Over Ground LLC · Helena, MTS/N 23-1124N3187WG S Aviation Inc · Stilwell, KSBuilt 1974 · S/N TH-428N318CAKornegay Patrick · Harlingen, TXBuilt 2001 · S/N TH-2001N318PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 4496134N318PPK&A Consulting Of Montana Inc · Billings, MTBuilt 1974 · S/N 421B0843N318RHN72jp Inc · Annandale, VABuilt 1976 · S/N 27-7654184N318TWFlg Air Transport LLC · Miramar, FLS/N 421-0170N31913Southern Aircraft LLC · Valdosta, GABuilt 1978 · S/N 34-7870275N3192LPolk Kenneth W · Greenville, TXBuilt 1965 · S/N 310J0192N31932Air Cargo Solutions Inc · Two Rivers, AKBuilt 1973 · S/N 31-7405144N3194XAutry Mark T · Sumter, SCBuilt 1994 · S/N TH-1723N3195KEasygoair LLC · Sudbury, MABuilt 1999 · S/N TH-1895N3196WTs Aviation LLC · Sioux Falls, SDBuilt 1999 · S/N TH-1913N3197WMoskin Jeffrey M · Culver City, CAS/N TC-1658N3198WRobert And Donna Odegaard Family Lllp II · Kindred, NDBuilt 1974 · S/N TC-1647N31999Kealy Kevin · Las Vegas, NVBuilt 1978 · S/N 34-7870284N3199JSietsma Lawrence F · Indialantic, FLBuilt 1999 · S/N TH-1899N3199WCoastal Sky Partners LLC · Wilmington, DEBuilt 1974 · S/N TC-1648N319AUChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 4496585N319CAAcree James · Euless, TXS/N TK93N31AWRestoration Dental · Chesterfield, MOBuilt 1975 · S/N 414-0803N31CLg & Gs Holdings LLC · Middletown, DES/N 421C0096N31CRStory Aranzazu · Draper, UTS/N 31-8152011N31CULovaas Jean H Trustee · Crescent City, CABuilt 1977 · S/N 421C0341N31DEBarber Deans Elliott III · Selma, ALBuilt 1961 · S/N 27-504N31FACarlisle Robert · Pensacola, FLBuilt 1960 · S/N 27-215N31GKMartin Richard B · Corona Del Mar, CAS/N 310Q0664N31GSParsons John Joseph · Winter Park, FLS/N 348433021N31KCWashington State Community College · Spokane, WABuilt 1973 · S/N 421B0344N31KDChinook Fibre LLC · Wilmington, DEBuilt 1984 · S/N T30300310N31KSPaxton Jacob · Killeen, TXS/N 421B-0662N31KTSmith Kenneth L · Pomona, CABuilt 1970 · S/N 421B0011N31MMPence Air LLC · Edinburg, VAS/N 421C0819N31NWAlpha Whiskey 2 LLC · Brandon, MSBuilt 1981 · S/N 318152139N31PCFlight World Inc · San Juan, PRBuilt 1958 · S/N 23-1349N31PGPlacette Jim · Houston, TXBuilt 1977 · S/N 310Q0687N31PNRhs Consulting Ltd LLC · Reno, NVBuilt 1976 · S/N 31P-7630009N31PRAlpha Whiskey 1 LLC · Brandon, MSBuilt 1979 · S/N 317952049N31RCJoey Os LLC · Darlington, PAS/N 27-2818N31RDIsland Bound LLC · Dunedin, FLS/N 31-7852059N31RTPapuchin LLC · Highwood, ILBuilt 1970 · S/N 414-0158N31TEMiller David A · Albany, ORBuilt 1984 · S/N 31-8452012N31TUKalm Air Inc · Junction, TXBuilt 1973 · S/N 27-7305011N31TVCornea Kevin Troy · Palm City, FLBuilt 1979 · S/N 27-7954054
Back to AD 2004-25-16 R1