AD 2004-10-06

Registered aircraft · 139

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-10-06')
    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-10-06')
  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.

N422BNAntares Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 20735N429MCAtlas Air Inc · Purchase, NYBuilt 1990 · S/N 24833N438BNAntares Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 21045N438GTAtlas Air Inc · White Plains, NYBuilt 2002 · S/N 30766N439GTAtlas Air Inc · White Plains, NYBuilt 2002 · S/N 30767N440KHAircraft 28889 LLC · Lake Mary, FLBuilt 1998 · S/N 28889N442KHAircraft 28888 LLC · Lake Mary, FLBuilt 1998 · S/N 28888N444HECsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1987 · S/N 23800N464MCAtlas Air Inc · Purchase, NYBuilt 1992 · S/N 26341N465MCAtlas Air Inc · Purchase, NYBuilt 1990 · S/N 24784N465TWSierra American Corp · Wilmington, DES/N 23465N467TWSierra American Corp · Wilmington, DES/N 23466N471EVGugu Ltd · Bellevue, WAS/N 20651N471MCAtlas Air Inc · White Plains, NYBuilt 1997 · S/N 26557N472EVFletcher Aviation Services LLC · Bismarck, NDBuilt 1971 · S/N 20320N480MCAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 28812N481MCAtlas Air Inc · Purchase, NYS/N 32339N482MCAtlas Air Inc · Purchase, NYBuilt 2001 · S/N 32340N489MCAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 26553N502DADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 21304N537CAAc Spe 10 LLC · Orlando, FLBuilt 2004 · S/N 33749N554WTAerownership North American Services Inc Trustee · Dover, DES/N 28554N569CAAc Spe 11 LLC · Orlando, FLS/N 30763N580UPC C & E I LLC · Louisville, KYS/N 25632N615PA2d Aviation Corp · Frisco, TXBuilt 1976 · S/N 21266N615SCSvp LLC · Missoula, MTS/N 26100N617USLogistic Air Inc · Reno, NVBuilt 1975 · S/N 21121N618USLogistic Air Inc · Reno, NVBuilt 1975 · S/N 21122N640CSCsds Asset Management LLC · Marana, AZS/N 26078N652EEAerotrust Services Corp Trustee · Wilmington, DEBuilt 1992 · S/N 26526N661USDelta Air Lines Inc · Atlanta, GABuilt 1989 · S/N 23719N702CAAc Spe 5 LLC · Orlando, FLBuilt 1994 · S/N 27217N703CKKalitta Air LLC · Ypsilanti, MIBuilt 1990 · S/N 24226N708AAWorld Aviation Services LLC · Medley, FLBuilt 1981 · S/N 22465N708SSierra Pacific Airlines Inc · Tucson, AZBuilt 1995 · S/N 27424N709SSierra Pacific Airlines Inc · Tucson, AZBuilt 1997 · S/N 28722N720CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1977 · S/N 21298N724CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1971 · S/N 20383N726USUSA Jet Airlines Inc · Belleville, MIBuilt 1981 · S/N 22469N727HLAviation Sales And Charter LLC · Dover, DES/N 22642N727NKAntares Aviation LLC · Boca Raton, FLBuilt 1979 · S/N 21945N727USUSA Jet Airlines Inc · Belleville, MIBuilt 1981 · S/N 22470N727YKFayaka Airways LLC · San Francisco, CANon-citizen corporation, flight hours not reportedS/N 21442N729CAAc Spe 6 LLC · Orlando, FLBuilt 1991 · S/N 25068N729CKConair USA Co · Dover, DEBuilt 1982 · S/N 22982N732CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1989 · S/N 24271N733CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1992 · S/N 25849N734CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1993 · S/N 25858N7352CCsds Asset Management LLC · Rllng Hls Est, CAS/N 26340N7353CCsds Asset Management LLC · Rllng Hls Est, CAS/N 27634
Back to AD 2004-10-06