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.

N412BPMission Hardward Ltd Co · Savannah, GABuilt 1983 · S/N T30300213N412BSN412bs LLC · Southport, CTBuilt 2016 · S/N 1258N412CAAirswiss Inc · Wilmington, DES/N 402C0005N412CGBlue Sky Naples LLC · Naples, FLBuilt 2015 · S/N 0992N412CKAir Blair LLC · Hubbard, OHBuilt 2019 · S/N 1900N412CPSevern Aviation LLC · Richmond, VABuilt 2009 · S/N 3457N412CRRegistered aircraftBuilt 2024 · S/N 9940N412DJStringfield Lisa P · Los Alamos, NMBuilt 2005 · S/N 1433N412JJSkybird Aviation LLC · Bowling Green, KYBuilt 2007 · S/N 2846N412MFCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11660N412MSLfg Aviation LLC · Crossville, TNBuilt 2021 · S/N 2292N412PABulletproof Asset Holdings LLC · Bradenton, FLBuilt 2023 · S/N 9078N412PGVisual Approach LLC · Vienna, VABuilt 2026 · S/N 11276N412SRHealing Waters Counseling Center LLC · Cedar Bluff, VABuilt 2006 · S/N 2176N412TKBaerresen Drake A · Corona, CAS/N 0552N412WDColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2025 · S/N 10948N412YZLegacy Air Group LLC · Palm City, FLBuilt 2023 · S/N 9089N4134SQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N TJ-18N4135TNehls Chevrolet Olds Cadillac · Marshall, TXBuilt 1965 · S/N 320D0035N4137CN4137c Inc · Redwood City, CABuilt 1979 · S/N 21063566N413ACJibber Aviation LLC · Westfield, MABuilt 2023 · S/N 9079N413AKAlhambra Aviation LLC · San Mateo, CABuilt 2016 · S/N 4429N413APAba Aviation LLC · Northbrook, ILBuilt 2018 · S/N 1685N413BMLee Aviation LLC · Sheridan, ARBuilt 1977 · S/N 414A0004N413CNOa2 Aviation LLC · Gallatin, TNBuilt 2010 · S/N 3651N413CPDean Taylor LLC · Palm Coast, FLBuilt 2008 · S/N 3257N413EM413em LLC · Columbia, ILBuilt 2005 · S/N 29-0388N413JDJwd Aviation LLC · Johns Creek, GABuilt 2022 · S/N 8806N413KJHuber Jeffrey C · Sidney, OHBuilt 1980 · S/N D-10307N413MP413 Aviation LLC · Washington, PABuilt 2020 · S/N 2203N413PTag Aviation LLC · Larwill, INBuilt 2004 · S/N 1073N413RSStewart Rentals LLC · Tampa, FLBuilt 2026 · S/N 11460N413SRBroussard Knoll Law Firm LLC · Marksville, LABuilt 2006 · S/N 1936N413TLSnapper Kai LLC · Kerrville, TXBuilt 2016 · S/N 4338N413WMCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10413N413WWWilkinson Jason S · Eastvale, CABuilt 1972 · S/N 340-0176N4140GCaribbean Development Partnership Ltd · Wilmington, DEBuilt 1977 · S/N 340A0311N4141TPremier Properties And Investments LLC · Tarkio, MOBuilt 2005 · S/N 1442N4141XSpuddy Properties LLC · Leclaire, IABuilt 2005 · S/N 1716N4146APinpoint Investment Capital Inc · Healdsburg, CABuilt 1999 · S/N EA-646N4148GKutrieb Wolfgang Michael · Chetek, WIBuilt 1977 · S/N 340A0318N414ACBirman Pablo · Suamico, WIBuilt 1975 · S/N 414-0820N414AFSano Aviation Corp · Lewes, DEBuilt 1971 · S/N 414-0167N414AKValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 414A0321N414AMToucan Aviation LLC · Lafayette, LABuilt 1982 · S/N 414A0850N414AQQualitair LLC Trustee · MichelstadtBuilt 1974 · S/N 414-0472N414ARFlight Med LLC · Cumming, GABuilt 1976 · S/N 4140902N414ASRobertson Julianne · Los Osos, CABuilt 1991 · S/N EA-523N414ATCreekmore Arnold · Somerset, KYBuilt 1978 · S/N 414A0209N414AVChoate Oilfield Services LLC · Hennessey, OKS/N 414A0294
Back to AD 2012-10-13