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.

N762LCLeon County Sheriffs Office · Tallahassee, FLBuilt 1995 · S/N 4363N762SHBlue Air Training Corp · Las Vegas, NVBuilt 1992 · S/N 006N76431Four Creeks Aviation Inc · Visalia, CABuilt 1958 · S/N 992N7650MAnw Investment Group LLC · Denham Springs, LABuilt 1971 · S/N 624N76544Churchill Scott · Jordan, MNBuilt 2001 · S/N 5273N765BWHva Inc · Summersville, WVBuilt 1980 · S/N 200661DN765KVWinco Inc · Aurora, ORBuilt 1984 · S/N 0082EN769KBWhiskey River Aviation LLC · Medford, ORBuilt 1993 · S/N LN056N76TLJ L Smith Enterprises LLC · Jackson, KYBuilt 1999 · S/N 4523N770FKInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N 2144N770HPDodson International Parts Inc · Rantoul, KSBuilt 2007 · S/N 4624N771KESchilling Michael K · Kenai, AKBuilt 2004 · S/N 51002CN772DWCcf Ventures Inc · Bangor, MEBuilt 1976 · S/N 007N774CBCbhelos LLC · Chesapeake, VABuilt 1983 · S/N 0016EN775BDAviation Advantage Inc · Tabor City, NCBuilt 1977 · S/N 970197DN775DWCosta James J · Prineville, ORBuilt 1976 · S/N 028N77766Usda Aphis Wildlife Services · Cedar City, UTBuilt 2001 · S/N 5279N779DWRegistered aircraftBuilt 1975 · S/N 016N77DCOmega 377 Pennsylvania LLC · Shavertown, PABuilt 1985 · S/N E-2289N77YVSara Helicopters Inc · Wilmington, DEBuilt 1972 · S/N 520381SN782MHRotor Blade LLC · Pawleys Island, SCBuilt 1980 · S/N 600739DN784FNascar Aviation LLC · Silverado, CABuilt 1978 · S/N 2508N785CBHarr Jeremy E · Kingsport, TNBuilt 1989 · S/N 4051N7860SMagnum Aviation LLC · Goff, KSS/N 6627N78906King County Sheriffs Office · Seattle, WABuilt 2001 · S/N 5277N78AMBell206 LLC · Anchorage, AKBuilt 1989 · S/N 4060N78BRMontana Air Tankers LLC · Three Forks, MTBuilt 1988 · S/N 4001N78MEElliott Enterprises Group LLC · Wilmington, DEBuilt 1981 · S/N 3442N78NLH&G Farms Inc · Corcoran, CABuilt 1974 · S/N 1561N79987Usda Aphis Ws · Cedar City, UTBuilt 2001 · S/N 5278N79FSMarchetti LLC · Conner, MTBuilt 1979 · S/N 066AN7MTCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1991 · S/N 12002CN7UMSabe Aviation Inc · Santa Monica, CABuilt 1975 · S/N 850767SN800JBHelicopter Applicators LLC · Pembroke, NHBuilt 1979 · S/N 2832N800PHTomlinson Aviation Inc · Ormond Beach, FLBuilt 1988 · S/N S-800N801JBNewwest LLC · Pembroke, NHBuilt 1979 · S/N 2697N801SBBank Of Utah Trustee · Salt Lake City, UTS/N 0209EN803JBGuardian Aero LLC · Flora, ILBuilt 1991 · S/N 4172N804LASouthern Helicopter Inc · O Brien, FLBuilt 1971 · S/N 680N80558Oh58 Airborne LLC · Saint Petersburg, FLBuilt 1970 · S/N 70-15207N805MDIntegrity Aircaft Title Holdings LLC · Portland, ORBuilt 1986 · S/N 0168EN806LACoastal Helicopters Inc · Panama City, FLBuilt 1973 · S/N 1008N808BHNorton Basin Services · Nome, AKBuilt 1988 · S/N 0317EN808JHTreeline Helicopters Inc · Bristol, TNBuilt 2008 · S/N 0577EN808QPalmer Carroll W · Harper, ORBuilt 1980 · S/N 3029N809WAWindward Aviation Inc · Puunene, HIBuilt 1979 · S/N 490493DN811WAWindward Aviation Inc · Puunene, HIBuilt 1979 · S/N 590517DN813RRIndian River County Sheriffs Office · Vero Beach, FLBuilt 2002 · S/N 5284N81519Bell Textron Inc · Fort Worth, TXBuilt 1998 · S/N 4498N8159JForming Agrotors Inc · Louisville, MSBuilt 1970 · S/N 512
Back to AD 2005-10-13