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.

N337EXTrepanier Dennis A · Agua Dulce, CAS/N 33701737N337FRomain Dennis · Payson, AZBuilt 1973 · S/N 33701547N337FMBrous James T Trustee · New York, NYBuilt 1997 · S/N 3449028N337FTMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3370384N337GDPorrima Photonix Inc · Las Cruces, NMBuilt 1979 · S/N 33701921N337GGInterventional Cardiovascular Group Of San Juan In · Laredo, TXS/N 33701429N337GRLor Aviation LLC · Atlanta, GABuilt 1969 · S/N 33701210N337GSJc Holding LLC · Wilmington, DEBuilt 1973 · S/N 33701520N337JFBeaty Andrew R Jr · Wichita Falls, TXFirst renewal noticeBuilt 1966 · S/N 3370391N337JLDavis Mike D · Huntersville, NCS/N 337-0708N337JRInternational Air Services Inc Trustee · Carson City, NVS/N 33701474N337JSI V S K LLC · Wilmington, DES/N 337-1136N337LASturgeon Kenneth V · Winter Garden, FLBuilt 1965 · S/N 337-0134N337LFA To B Flying Inc · Litchfield, ILFirst renewal noticeBuilt 1969 · S/N 337-1057N337LPSkymaster Stc LLC · Mena, ARBuilt 1977 · S/N 33701750N337MMAugugliaro Robert J · Albuquerque, NMBuilt 1967 · S/N 337-0608N337NEAviation Specialty Services LLC · Beaufort, NCBuilt 1969 · S/N 337-0997N337PHayes James J · San Diego, CAS/N 33701535N337RCN337rc Corp Trustee · Wilmington, DEBuilt 1968 · S/N 337-1014N337RDDamschroder Rex A · Fremont, OHBuilt 1968 · S/N 337-0847N337RJWilson Scott · Sheridan, WYBuilt 1975 · S/N 34-7570267N337RTTorres Ramon A · Mulberry, FLBuilt 1965 · S/N 337-0089N337SMFlippin Birds Aircraft LLC · Miami, FLS/N 3370495N337SSState Of Wisconsin/Doa · Madison, WIBuilt 1976 · S/N 33701716N337TKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1972 · S/N 33701462N337TLInternational Air Services Inc Trustee · Carson City, NVS/N 33701418N337TSWalz Steve · Kiowa, KSBuilt 1966 · S/N 337-0300N337VRed Devil Skymasters LLC · Helena, MTBuilt 1971 · S/N 33701369N337VGBvj Skymaster Inc · Appleton, MNS/N 337-0435N337WAGyron Eagle Ltd · Pasadena, CABuilt 1975 · S/N 33701651N337WGGrady Charles Martin · La Verne, CABuilt 1965 · S/N 337-0091N337WTSunset Aviation LLC · Wilmington, DEBuilt 1967 · S/N 337-0661N337WZAir Data Solutions LLC · Natchitoches, LABuilt 1971 · S/N 33701397N337XXPfister David E · Harlan, INS/N 337-0726N337YBrokaw Burton · Tucson, AZBuilt 1966 · S/N 337-0449N33809Iaba LLC · Norfolk, VABuilt 1975 · S/N 34-7570165N33832Shafer James H · Port Orchard, WABuilt 1975 · S/N 34-7570168N33833Buchholz David M · Scottsdale, AZBuilt 1975 · S/N 34-7570169N3388PMorrison Maria · Port Townsend, WABuilt 1958 · S/N 23-1351N3389PLapeyrouse Charles L · Raceland, LABuilt 1958 · S/N 23-1352N338SSSieli Paul III · Griffin, GAS/N 27-224N338TKGranite Boarding LLC · Loomis, CAS/N TH-1991N338TLMargolis Michael · Ruskin, FLBuilt 1973 · S/N 33701563N3398QRiebe Grover C Jr · Gwinner, NDBuilt 1969 · S/N 421A0108N339CTPatel Niral G · Atlanta, GABuilt 1974 · S/N 27-7405350N33ADSouthern Turf Services LLC · West Palm Beach, FLBuilt 1973 · S/N 414-0412N33HLKnudsen Russell G · East Troy, WIBuilt 1973 · S/N 340-0315N33JFKimsey Thomas Wayne · Warner Robins, GABuilt 1965 · S/N 30-820N33JRMil2atp Inc · Pikeville, NCBuilt 1975 · S/N 34-7570113N33LFJbo Airventures LLC · Saint Petersburg, FLBuilt 1974 · S/N 340-0352
Back to AD 2004-25-16 R1