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.

N407UTMed Trans Corp · Denton, TXBuilt 1996 · S/N 53036N4088YDumont Associates · Morris Plains, NJBuilt 1990 · S/N 4088N40DVNordstrom Eric Trustee · Anchorage, AKBuilt 1982 · S/N U20606493N40MCScotts Helicopter Service · Le Sueur, MNBuilt 1970 · S/N 563N410SCAlfheim II LLC · Menomonee Falls, WIBuilt 1998 · S/N 5026N411DDHbh Aircraft LLC · Stratford, CTBuilt 1979 · S/N 2837N411JHHeidrick Joe · Woodland, CAS/N 0193EN411TDRotor Head Helicopters LLC · Torrance, CABuilt 1991 · S/N 4165N411WJNorthwest 60 LLC · Kalispell, MTBuilt 2014 · S/N 0620EN4155KPereira Alfred R Jr · Valley Springs, CAS/N 1053N415WCWilson Construction Co · Canby, ORBuilt 1981 · S/N 0005EN41AJEnglish Air Service LLC · Georgetown, TXBuilt 1978 · S/N 480299DN41EWMemphis Police Department · Memphis, TNBuilt 1989 · S/N 4044N41PHTobler Hans P · Anchorage, AKBuilt 1974 · S/N 1544N41WEEastward Aviation Inc · Eagle Lake, TXS/N 3850N420KTRegistered aircraftBuilt 2008 · S/N 0582EN420LECox Robert D · Girdwood, AKBuilt 2006 · S/N 5101N420WPQualitair LLC Trustee · MichelstadtBuilt 2002 · S/N 29004CN421KY250 Logistics LLC · Mount Pleasant, TXBuilt 2009 · S/N 0594EN421SPKentucky State Police · Frankfort, KYBuilt 2008 · S/N 0714FFN4237MTrideca Vertical Solutions LLC · Dallas, TXBuilt 1989 · S/N 4055N425WCWilson Construction Co Inc · Canby, ORS/N 0268EN4265JRatcliff Dustin · Saltville, VABuilt 1979 · S/N 790542DN4292DUrocopters Inc · Lancaster, CAS/N 0364EN42FFBeef Aviation LLC · Bradenton, FLBuilt 1984 · S/N 0141EN42LHFly Hangar 13 LLC · Mico, TXBuilt 1981 · S/N EA-163N42MCD & L Aeronautics LLC · Wilmington, DEBuilt 1995 · S/N 4348N430AGMcmahon Helicopter Services Inc · Canton, MIBuilt 1998 · S/N 49045N430JRAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1991 · S/N 7640N430NYMcmahon Helicopter Services Inc · Canton, MIBuilt 2000 · S/N 49068N430STHigh Performance Helicopters Corp · Crestline, CABuilt 2000 · S/N 49071N430VPAerotrust Services Corp Trustee · Wilmington, DES/N 49005N43142Scotts Helicopter Services Inc · Le Sueur, MNBuilt 1977 · S/N 1577N431CAChem-Air LLC · Shreveport, LABuilt 1978 · S/N 2517N431HFHeliflite Shares LLC · Newark, NJBuilt 1999 · S/N 49051N4328Air Gov II LLC · Rome, NYBuilt 1994 · S/N 4328N432RDAirdine LLC · San Francisco, CABuilt 2002 · S/N 5039N432TVSky Choppers LLC · Seneca, KSBuilt 1981 · S/N 3286N434STSchweizer Rsg LLC · Fort Worth, TXS/N 0010N43HHJohnson Flying Service LLC · Exira, IABuilt 1975 · S/N 1585N43MAMinuteman Aviation Inc · Missoula, MTBuilt 1991 · S/N 4156N4445HBell Textron Inc · Fort Worth, TXBuilt 1998 · S/N 4493N444JBAir First LLC · Pembroke, NHBuilt 1971 · S/N 71-20362N444TVScotts Helicopter Service Inc · Le Sueur, MNBuilt 1981 · S/N 3501N445Wisk Aero LLC · Mountain View, CABuilt 1993 · S/N 4285N4452Bravo Aviation LLC · Chicago, ILBuilt 1973 · S/N 1086N445SAvitek Inc · Plymouth, MIS/N 230445SN448EAEdgefield Aviation LLC · Sandy, ORBuilt 1974 · S/N 1495N449SS & L Farm And Ranch LLC · Georgetown, TXBuilt 1998 · S/N 4495N44SZEnstrom Helicopter Corp · Menominee, MIBuilt 2009 · S/N 5131
Back to AD 2005-10-13