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.

N7062XPatriot Aviation Inc · Greenville, DES/N S-793N7079KDah Aircraft LLC · Georgetown, SCBuilt 1981 · S/N 610988DN707HJIndustrial Helicopters LLC · Lafayette, LABuilt 1980 · S/N 3173N707MDEfw Inc · Fort Worth, TXBuilt 1984 · S/N 5306N707MKSch Aviation Inc Trustee · NorfolkBuilt 2007 · S/N 4633N707SJCtrg Aviation Holdings LLC · Lakeway, TXBuilt 1981 · S/N 3561N709ACJbd Enterprises Inc · Englewood, COBuilt 1982 · S/N 5114N710ACJbd Enterprises Inc · Englewood, COBuilt 1982 · S/N 5234N711HLMann Laurence F · San Jose, CABuilt 1987 · S/N 7398N711KVAa Leasing Lp · Kilauea, HIBuilt 1977 · S/N 1070212DN711ZWMalmrose Heli Services Inc · North Salt Lake, UTBuilt 1979 · S/N 2691N712CACatalyst Aviation LLC · Hammonton, NJBuilt 1987 · S/N 5362N713BCTimcoaviation LLC · Purvis, MSBuilt 1982 · S/N 3671N716CBCbhelos LLC · Chesapeake, VABuilt 1980 · S/N 500701DN716KVAa Leasing Lp · Lihue, HIBuilt 1990 · S/N 0407EN716VLAirwayplanner.Com LLC · Sands Point, NYBuilt 1992 · S/N 4203N7173FFour Creeks Aviation Inc · Visalia, CAS/N 2011N7173SCraig Helicopters Inc · Craig, COBuilt 1965 · S/N 2351N719CBCbhelos LLC · Chesapeake, VABuilt 1972 · S/N 890N719KVAa Leasing Lp · Kilauea, HIBuilt 1979 · S/N 890579DN721KHBruce Mike · Evadale, TXFirst renewal noticeBuilt 1984 · S/N E-2214N721RPRatcliff Dustin · Saltville, VABuilt 1981 · S/N 310918DN722LMNorthwest Helicopters LLC · Olympia, WABuilt 1994 · S/N 52111N7230TFernandez Rosario Yailin · Imperial, CABuilt 2005 · S/N 72-21128N7242NMaverick Jet Leasing Inc · Wilmington, DEBuilt 1986 · S/N 7355N724HKHawkeye Helicopter LLC · Lyndon, KSBuilt 2000 · S/N 0553EN7250EAg Air Inc · Oakdale, CABuilt 1974 · S/N 1529N725MAviation Advantage Inc · Tabor City, NCBuilt 1980 · S/N 500726DN727BBDle Corp · Lewes, DES/N 735N727JSTrickett Michael W · Washington, DCBuilt 2002 · S/N 5048N727JVCalifornia Helicopter Operations LLC · Santa Rosa, CABuilt 1973 · S/N 230451SN72VVBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N P21000339N734HHHlh Leasing LLC · Wilmington, DEBuilt 1980 · S/N 200677DN735CBChesapeake Bay Helicopters Inc · Chesapeake, VABuilt 1980 · S/N 1100858DN73AJGreenway Avia Inc · Wilmington, DES/N 922N73AMMetroplex Flight Services LLC · Fort Worth, TXS/N 3473N743MHDah Aircraft LLC · Georgetown, SCBuilt 1981 · S/N 811034DN744TVU S Helicopters Inc · Marshville, NCBuilt 1985 · S/N 3863N745HAPrivate LLC · Kalispell, MTRegistration ineffective or invalidS/N 7413N74678Southmark Aviation Inc · Hattiesburg, MSBuilt 2001 · S/N 5274N747DMHunter Construction Group Inc · Mooresville, NCBuilt 1981 · S/N 3510N748CBCbhelos LLC · Chesapeake, VABuilt 1988 · S/N 0303EN74AJAerial Control Inc · Brentwood, CABuilt 1979 · S/N 2751N74FKSt Louis Airmotive LLC · Wilmington, DEBuilt 1979 · S/N 6004N7508PReece Michael · Marathon, FLBuilt 2006 · S/N 4611N753BFAis Construction Equipment · Grand Rapids, MIBuilt 2006 · S/N 5090N75454Realstaff Rocket LLC · Salem, ORS/N 5280N75CWChem Air LLC · Shreveport, LABuilt 1975 · S/N 1762N75YLinville Manor LLC · Reidsville, NCBuilt 1994 · S/N 4304N760AMAir Services Inc · Minneapolis, KSBuilt 1976 · S/N 1060863S
Back to AD 2005-10-13