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.

N4925KAlberts Nelson · Weatherford, TXBuilt 1979 · S/N P21000371N4927N774pt Inc Trustee · Wilmington, DEBuilt 2007 · S/N 2598N492CPCirrus Velocity Group LLC · San Antonio, TXBuilt 2008 · S/N 3309N492DMDunaway Brian Scott · Perry, GABuilt 2008 · S/N 3282N492DPToepfer Arthur David · Boerne, TXBuilt 2022 · S/N 8765N492DZN492dz LLC · Highland, UTBuilt 2021 · S/N 2337N492MMJustarep Group LLC · Deerfield Beach, FLBuilt 2025 · S/N 10671N4930VCirrusly LLC · Bonney Lake, WABuilt 2004 · S/N 0960N4937JSwirsding David J · Chalfont, PABuilt 1977 · S/N 310R0952N4939YDavidson Dan F · Ozona, TXBuilt 1980 · S/N 21064050N493CDCocozzoli Kevin A · Crestview, FLBuilt 2005 · S/N 1603N493MSHingley Daniel · Boise, IDBuilt 2007 · S/N 2450N493TRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2014 · S/N 0776N4940KGoves Abram M · Parker, COBuilt 1979 · S/N P21000376N4945MMidland College · Midland, TXBuilt 1978 · S/N TJ-145N4946KOrion Technology Group LLC · San Diego, CABuilt 1979 · S/N P21000378N4948AKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1410N4949ASw Air LLC · Denver, COS/N 310R1505N4949SSchwenk Holdings LLC · Fort Myers, FLBuilt 2011 · S/N 3796N494SRSolaero LLC · Toledo, OHBuilt 2006 · S/N 2263N494TSDeep Creek Lake Ventures LLC · Oakland, MDBuilt 1983 · S/N T30300201N495495htsi LLC · Wilmington, DEBuilt 1980 · S/N 414A0487N4950UAerotech Mapping Inc · Las Vegas, NVBuilt 1979 · S/N U20605174N4951YH & B Aeronautics LLC · Miamisburg, OHBuilt 1980 · S/N 21064057N4957ZGuinasso Kimberly Marsh · Reno, NVS/N U20606059N4959CDoll House Properties Inc · Chesapeake, VABuilt 1979 · S/N 21063689N495BCR&B Adventures LLC · Benton, KSBuilt 2021 · S/N 2239N495CCM2 Aero LLC · Powell, OHBuilt 2006 · S/N 2011N495CDJl Aviation LLC · Crestwood, KYBuilt 2005 · S/N 1605N495CPIris Fliers Inc · Fernandina Beach, FLBuilt 1995 · S/N 29-0058N495PDAbaco Aviation LLC · Bismarck, NDBuilt 2023 · S/N 9044N495RDCapital Holdings 226 LLC · Naples, FLBuilt 2003 · S/N 42032N495RMNorth Fork Wings LLC · Bakersfield, CABuilt 2017 · S/N 1557N495SCOptimum Aviation LLC · Sterling, VABuilt 2025 · S/N 10484N495SLAlair Scott C · Pleasanton, CAS/N L2K-167N4960JPonderosa Airtankers LLC · Safford, AZBuilt 1981 · S/N T18803791TN4960KShuck Drilling Co · Edgar, NES/N P21000383N4967KBrown Lawson M II DBA · San Diego, CABuilt 1979 · S/N P21000386N496ALDelta Lima LLC · Nashville, TNBuilt 2018 · S/N 1836N496CDCirrus Skies LLC · Clayton, MOBuilt 2005 · S/N 1612N496CJPurview LLC · Brownsburg, INBuilt 2025 · S/N 10918N496CPSportmed Outreach Air LLC · Gulf Breeze, FLBuilt 2008 · S/N 3314N496DEHegedus Bruce Alan · Anchorage, AKBuilt 1996 · S/N 29-0082N496GRRegistered aircraftBuilt 2019 · S/N 4779N496LLLucky 28 Holdings LLC · Destin, FLBuilt 2023 · S/N 9055N4971Osborne Scott M · Fort Myers, FLBuilt 2015 · S/N 4174N4978UKempf Rodney G · Eugene, ORBuilt 1979 · S/N U20605180N497BCBarnes William · Hagerstown, MDBuilt 2010 · S/N 411157N497CPGulfstream Turbine LLC · Naples, FLBuilt 2008 · S/N 3315N497EBFl Scapes Inc · Panama City Beach, FLBuilt 1999 · S/N E-3296
Back to AD 2012-10-13