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.

N584HPN305yv LLC · Doral, FLBuilt 1983 · S/N TH-1365N584JTGoff James T · Sunriver, ORBuilt 1980 · S/N TH-1127N584MBCenterline Holdings Inc · Camden, DES/N TK-151N584METwo Spinny Things LLC · Overland Park, KSBuilt 1974 · S/N TH-427N584MJC5 Aviation LLC · Harrison, ARBuilt 1987 · S/N TH-1512N584MWRela Matthew V · Monroe, NJBuilt 1991 · S/N TH-1615N584RCrooked Creek Enterprises LLC · Nacogdoches, TXBuilt 1985 · S/N TH-1464N584SMRegistered aircraftBuilt 1973 · S/N TH-412N584TBSundancer Enterprises LLC · Norman, OKBuilt 1997 · S/N TH-1810N584WKing Air Ny LLC · Schenectady, NYBuilt 1993 · S/N TH-1699N5850MJones Michael J · Cypress, TXBuilt 1969 · S/N 310P0150N5853XAnderson Douglas S · Gansevoort, NYBuilt 1961 · S/N 310-0153N5854MJantzen Equipment LLC · Madrid, NEFirst renewal noticeBuilt 1969 · S/N 310P0154N5854SKarl Herrmann Inc · Afton, WYBuilt 1965 · S/N TC-846N5855TAkland Konrad R · Missoula, MTBuilt 1979 · S/N TC-2261N5856YGalett Steven J · Canton, CTS/N 27-2942N5857KN5857k LLC · Carlsbad, NMS/N TC-806N5857MVenturi Corp · Staunton, ILBuilt 1969 · S/N 310P0157N5858PMatherne David M · Houma, LAS/N TJ446N5859MJasper County Properties LLC · Jasper, TXBuilt 1972 · S/N 340-0057N585BN585b LLC · Snohomish, WAS/N 27-4819N585CKKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N TH-1299N585NYPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954012N585RJMr Aeronautics LLC · Clarksville, TNBuilt 1985 · S/N TH-1479N5862MPortland Holdings LLC · Vista, CABuilt 1969 · S/N 310P0162N5867JFlight Guys Baron LLC · Coral Springs, FLBuilt 1965 · S/N TC-922N5868CShimomura & Co Cpas Pc · New York, NYBuilt 1980 · S/N 340A0977N5868SHolloway John · Blackburn, MOS/N TC-860N586CKKalitta Charters LLC · Ypsilanti, MIS/N TH-1084N586JRHuerta Holdings Inc · Santa Ana, CABuilt 1969 · S/N 310P0165N5870MMcdonald Brian L · Van Alstyne, TXBuilt 1972 · S/N 3400058N5871Sparrow Group LLC · Belton, TXS/N 20800135N5872MDixon Jack · Casa Grande, AZBuilt 1969 · S/N 310P0172N5874CVola Acosta LLC · Lake Forest, CAS/N 421C0882N5877MBrook Ash Inc · Waxahachie, TXS/N 310P0177N5878MKodiak Helo LLC · Kodiak, AKBuilt 1972 · S/N 340-0059N587ANCalifornia In Nice Inc DBA · San Jose, CAS/N TH1530N587CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N TH-1189N587MWHammonds Mark · N Richlnd Hls, TXBuilt 1974 · S/N 421B0587N5882TDe Smet Vicki M · La Verne, CAS/N 421B0424N5884JBge Enterprises LLC · Harrison, ARBuilt 1965 · S/N TC-926N5885MButler Richard A · Portland, TXBuilt 1969 · S/N 310P0185N5886SNiles Paul B · Hicksville, NYBuilt 1965 · S/N TC-858N5887YAlmost There Air LLC · Daytona Beach, FLBuilt 1965 · S/N 27-3040N5888LDavenport Aviation LLC · Rock Hill, SCS/N P-89N5888SPorterfield James William · Grove City, OHBuilt 1965 · S/N TC-861N588ANCalifornia In Nice Inc DBA · San Jose, CAS/N TH-1843N588CKKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N TH-965N588DMColeman Russell Ll · Saint Charles, ILBuilt 1973 · S/N 310Q0624N588MCPowell Jonathan M · Chattanooga, TNBuilt 1999 · S/N 3449111
Back to AD 2004-25-16 R1