AD 2005-10-13

Registered aircraft · 1,224

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:2005-10-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-10-13')
  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.

N450AGInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 1090202MN450XPlane Enjoyment LLC · Dover, MABuilt 1990 · S/N 12001CN451HAIron Horse Aviation LLC · Marshalltown, IABuilt 1979 · S/N 490484DN451LEEnstrom Helicopter Corp · Menominee, MIBuilt 2026 · S/N 5262N451NEEnstrom Helicopter Corp · Menominee, MIBuilt 2026 · S/N 5263N451REEnstrom Helicopter Corp · Menominee, MIBuilt 2026 · S/N 5265N452MCCitrus County Mosquito Control District · Lecanto, FLBuilt 1995 · S/N 4377N454JHJack Harter Helicopters Inc · Lihue, HIBuilt 1991 · S/N 0454EN454MSCb Couch Inc · Walcott, ARBuilt 1975 · S/N 1627N4569U S Army · Ft Rucker, ALBuilt 2006 · S/N 5306N456KJTaod Aviation LLC · Elkhart, INBuilt 2016 · S/N 5238N458HWHeliwild Investments LLC · Austin, TXBuilt 1979 · S/N 390483DN458PBBarbaro Paul G · Argyle, TXBuilt 1985 · S/N 0123EN463RARanger Aviation Leasing LLC · Wilmington, DEBuilt 1997 · S/N 4463N467PHPhi Health LLC · Tempe, AZBuilt 1997 · S/N 53142N46CLHelicopters Inc · Wilmington, DEBuilt 1999 · S/N 4518N46DKWrong Bros Ranch LLC · Lake Havasu City, AZBuilt 1996 · S/N 5014N46EEUnited States Department Of Agriculture · Cedar City, UTBuilt 1990 · S/N 0406EN472MRight Brother Aviation LLC · Chaffee, NYBuilt 1994 · S/N 4327N473EOchoco Wood Products LLC · Prineville, ORBuilt 1991 · S/N 0473EN475ALScotts Helicopter Service Inc · Le Sueur, MNBuilt 1968 · S/N 6675N478NWTmds Air Inc · Gig Harbor, WABuilt 1973 · S/N 530478SN479DBAmerican Honor Foundation Inc · Ocala, FLS/N 5062N47HHJkt LLC · Douglas, WYS/N 2667N4806Tennessee Helicopter Sales & Service Inc · Bolivar, TNS/N 5092N480ABBardo Wade · Erin, NYBuilt 1996 · S/N 5013N480AJRamos Aviation Services LLC · Arvada, COS/N 5104N480CJCentrix Air Inc · Central Point, ORBuilt 2008 · S/N 5123N480DDButler William J II · Juntura, ORBuilt 1996 · S/N 5017N480EMidtex Aviation LLC · Midlothian, TXBuilt 1993 · S/N 5001N480EHSloflight LLC · Ogden, UTBuilt 2002 · S/N 5046N480ENEnstrom Helicopter Corp · Menominee, MIBuilt 2025 · S/N 5259N480FHFalcon Helicopters Inc · Logan, NMS/N 5009N480GBInternational Air Services Inc Trustee · Carson City, NVBuilt 2008 · S/N 5128N480HCHangar Seven LLC · Penn Yan, NYBuilt 2007 · S/N 5112N480JBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 5108N480JSRichard Smith Farms Inc · Rexburg, IDBuilt 2008 · S/N 5125N480LIrrg LLC · Kane, PABuilt 2008 · S/N 5124N480MDJ&H Aicraft Leasing LLC · Berrien Springs, MIBuilt 2007 · S/N 5115N480MHBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 5129N480MLCline Air Services LLC · Ellensburg, WABuilt 1998 · S/N 5032N480MMAviation LLC · Madison, WIBuilt 2001 · S/N 5040N480MTCline Air Services LLC · Ellensburg, WABuilt 1994 · S/N 5003N480PQPlaquemines Parish Sheriff'S Office · Belle Chasse, LABuilt 2008 · S/N 5117N480RSEuroaviation Inc Trustee · KematenBuilt 1999 · S/N 5038N480THTroubleshooter Network Inc · Denver, COBuilt 2005 · S/N 5077N480TRAdlr Heli Inc Owner Trustee · Wilmington, DEBuilt 2005 · S/N 5076N480TTSanta Lucia Holding · Forked River, NJBuilt 1997 · S/N 5019N480VPropwash LLC · Mesquite, NVBuilt 2003 · S/N 5057N480VAFliege Jetzt LLC · Loveland, OHBuilt 2016 · S/N 5237
Back to AD 2005-10-13