AD 2012-10-13

Registered aircraft · 13,306

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-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:2012-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.

N4743XAerotech Mapping Inc · Las Vegas, NVBuilt 1980 · S/N U20605530N4744K4744k LLC · Mesa, AZBuilt 1979 · S/N P21000275N4746U4746u LLC · Sherman Oaks, CABuilt 1979 · S/N U20605079N4747CAlfred Joseph T · Pagosa Springs, COBuilt 1979 · S/N 21063611N4747KFloyd Don B · Snohomish, WAFirst renewal noticeBuilt 1979 · S/N P21000278N474CDNiagara Airways LLC · Orchard Park, NYBuilt 2005 · S/N 1573N474K5net4 LLC · Plano, TXBuilt 2026 · S/N 11152N474PDFlying Carpet Service LLC · Wilmington, DEBuilt 2020 · S/N 4936N474RLMassey Air Inc · Lucedale, MSBuilt 2011 · S/N 3820N474WYSky 4 Holdings II LLC · Kaysville, UTBuilt 2026 · S/N 11364N4752KAraiza Fernando A · Tucson, AZBuilt 1979 · S/N P21000283N4753UTurchan Robert H · Scottsdale, AZBuilt 1983 · S/N 21064811N4754AIndigo Air LLC · Gulf Breeze, FLBuilt 1980 · S/N 340A1024N47557M & M Aircraft LLC · Cresson, TXBuilt 1977 · S/N 34-7770414N4755KPhilmar LLC · Oshkosh, WIBuilt 1979 · S/N P21000286N4756CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 21063613N4757KGirard Gregory M · Tucson, AZBuilt 1979 · S/N P21000288N47589Radke John A · Cedar Falls, IABuilt 1977 · S/N 28R-7703404N4758KRuvo Scott J · Augusta, NJBuilt 1979 · S/N P21000289N475CDBird 33 LLC · Cody, WYBuilt 2005 · S/N 1574N475HLEmployment Universe Inc · Truckee, CABuilt 2015 · S/N 1092N475JGwaltney Air Inc · Alexander City, ALBuilt 1994 · S/N E-2883N475JMSmm Aviation LLC · Destin, FLBuilt 2001 · S/N E-3368N475RBN475rb LLC · Lexington, KYBuilt 1997 · S/N 29-0121N4761AAmarel Robert E Jr · Yuba City, CABuilt 1983 · S/N P21000821N4761KLyman Leslie F · Walnut Grove, CABuilt 1979 · S/N P21000292N4763GGamma Transport Solutions Inc · Carrollton, TXFirst renewal noticeBuilt 1977 · S/N 414-0938N47645Arizona Type Ratings LLC · Sedona, AZBuilt 1980 · S/N 340A0992N4765GAircraft Charter And Leasing LLC · El Cerrito, CABuilt 1977 · S/N 414-0940N4768KJohnson Durwood · Beaumont, TXS/N P21000299N4768PBoone Patrick J · San Antonio, TXBuilt 1978 · S/N P21000101N4769KSpirit 210 LLC · Missoula, MTBuilt 1979 · S/N P21000300N476EWWny Air Inc · Dover, DEBuilt 1996 · S/N TH-1797N476SRMjd Advisory Services LLC · Atlanta, GABuilt 2007 · S/N 2746N476TKAviation Partners LLC · Mcallen, TXBuilt 2010 · S/N 3667N476WGTrow Michael P · Seattle, WABuilt 2002 · S/N 0389N476YTower Aviation LLC · Kalispell, MTBuilt 2007 · S/N 2624N4770KPaulk Charles Jr · Naples, FLBuilt 1979 · S/N P21000301N4771KAshby Kenny · Mead, COBuilt 1979 · S/N P21000302N4772ADodson International Parts Inc · Rantoul, KSS/N 414A0095N4773CDickert Daniel · Cross City, FLBuilt 1979 · S/N 21063621N4773KReason Farms · Yuba City, CABuilt 1979 · S/N P21000304N4773PCoeur De Air LLC · Mcminnville, ORBuilt 1978 · S/N P21000102N4774KWingfield John J · Parker, TXBuilt 1979 · S/N P21000305N4775KBas Part Sales LLC · Greeley, COBuilt 1979 · S/N P21000306N4776UHabberstad John L · Rathdrum, IDBuilt 1979 · S/N U20605096N4777UAdair Aviation LLC · Broken Arrow, OKBuilt 1983 · S/N 21064814N477MAThompson Layne A · Pollok, TXBuilt 1981 · S/N 21064291N477MLVolmary John M · Madison Lake, MNBuilt 2011 · S/N 0246N477RSSundbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0477
Back to AD 2012-10-13