AD 2012-17-05

Registered aircraft · 1,197

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

N381CWN650rj LLC · Marshall, MNBuilt 1986 · S/N 650-0111N383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 322N383MVN383mv LLC · Amarillo, TXBuilt 1999 · S/N 258403N383TKThk Holdings LLC · Cincinnati, OHBuilt 2004 · S/N 258700N384ABArkoma Air LLC · Rockwall, TXBuilt 1997 · S/N 258339N384PBOvation Jet Parts LLC · Smyrna, DEBuilt 1980 · S/N 384N385RCTms Global Investments Inc · Naples, FLBuilt 1984 · S/N 117N387TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 018N388WA2029 Aircraft Trust 2 LLC Trustee · Davie, FLFirst renewal noticeS/N 27N389AWAir Gato Enterprises Inc · Clearwater, FLBuilt 1977 · S/N 157N389SRIgnite Enterprises LLC · Cerritos, CABuilt 2002 · S/N 258575N38MGBay Venture Management LLC · Atlanta, GABuilt 1989 · S/N 009N38PSAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 206N38TVLs Mobile LLC · Weatherford, TXBuilt 1988 · S/N 37N391BVcs Encore LLC · Austin, TXBuilt 1996 · S/N 258321N393SCN169px LLC · Delaware, OHBuilt 1989 · S/N 650N395HEBillron LLC · Houston, TXBuilt 1992 · S/N 228N39FNGh Equipment LLC · Dover, DEBuilt 1974 · S/N 006N39GXPitch N Power Aviation Inc · Jupiter, FLBuilt 1982 · S/N 232205N400CZDodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 547N400GPIcmc Idaho LLC · Salinas, CAS/N 423N400GSGreen Savoree Transportation LLC · Carmel, INBuilt 2001 · S/N 134N401JWWatts John I · Murchison, TXBuilt 1975 · S/N 46N402HMAer Sales Lp · Carrollton, TXBuilt 2006 · S/N 258782N404BYMalagamar LLC · Fort Myers, FLBuilt 1988 · S/N 650-0152N404FZBogey Bird II Inc · Jeffersonville, INBuilt 1985 · S/N 473N406CUSs Leasing II LLC · Eau Claire, WIBuilt 1992 · S/N 650-7010N406TMAlcyone Trust Corp Trustee · Wichita, KSBuilt 2002 · S/N 258578N40AGNew Chat Air LLC · Chattanooga, TNBuilt 2008 · S/N HB-15N40BGAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 2041N40GPBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 45-2061N411CDRegistered aircraftBuilt 1994 · S/N 138N411SCRegistered aircraftBuilt 2004 · S/N 258653N412DAVida Trade And Management Group LLC · Charlotte, NCS/N 258061N412JADodson International Parts Inc · Rantoul, KSBuilt 2001 · S/N 258516N412SWThunderforce Investments LLC · Washington, DCBuilt 2002 · S/N 238N413HSAerotrust Services Corp Trustee · Wilmington, DES/N NA0413N413MHFastair Inc · Columbia Station, OHBuilt 1987 · S/N 650-0148N414PEAerotrust Services Corp Trustee · Wilmington, DES/N 258090N417TMCpj2 LLC · Garden City, NYBuilt 2004 · S/N 258657N422CSBusiness Jet Managers Inc · Canton, MIBuilt 1988 · S/N 258110N423SGSworks Aviation LLC · Chicago, ILS/N 258472N424JRGravitas Aviation LLC · Dallas, TXBuilt 1984 · S/N 405N424TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 169N426MJArbuckle II LLC · Missoula, MTBuilt 2006 · S/N 258759N428DRMaverick Air II LLC · Deer Park, WABuilt 2005 · S/N 154N429FCLopez Fabio · Denver, NCBuilt 1983 · S/N 091N42GEWatts John · Murchison, TXBuilt 1974 · S/N 20N42JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 258509N431CKKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N 431
Back to AD 2012-17-05