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.

N3089ZSnyder Stephen F · Paradise Valley, AZBuilt 1987 · S/N E-2402N308AWN308aw LLC · Omaha, NEBuilt 2014 · S/N 0851N308CACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11513N308CDM&R Transport LLC · Dover, DEBuilt 2004 · S/N 1026N308CFBaba Kenneth D · Sierra Vista, AZBuilt 1973 · S/N 310Q0804N308JJjc Air LLC · Normandy Beach, NJBuilt 2024 · S/N 10359N308JABair Sky LLC · Bridger, MTBuilt 2017 · S/N 1617N308LSpirit Aviation LLC · Dunedin, FLS/N 2065N308MSDakota Equipment Sales And Leasing LLC · Kearney, NEBuilt 2022 · S/N 8516N308SSAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2025 · S/N 10664N30942Polar Bear Aviation LLC · Batesville, MSBuilt 1973 · S/N 21059979N309CACloud Niner LLC · Levittown, NYBuilt 2026 · S/N 11198N309CDTriangle Aviation LLC · Cary, NCBuilt 2004 · S/N 1104N309CPCirrus 497pg LLC · Scottsdale, AZBuilt 2008 · S/N 3232N309JFRozo Matthew · Chatsworth, CABuilt 2002 · S/N 0266N309LSPure Pursuit LLC · Arnold, MDBuilt 2022 · S/N 8659N309PTNelems Manufacturing LLC · Beaufort, SCBuilt 2007 · S/N 2434N309SCCalcote Derrick · Arlington, TNBuilt 2006 · S/N 2207N309SRWise Aviation LLC · Atlanta, GABuilt 2007 · S/N 2309N30EEEnterprises Aviation Inc · Piedmont, SDBuilt 1979 · S/N 414A0443N30ETZaldivar Carlos · Miami, FLBuilt 1971 · S/N 310Q0266N30FBBmg Aviation Leasing LLC · Bloomington, INBuilt 1978 · S/N 414A0067N30LFSignalwave LLC · Doral, FLBuilt 1980 · S/N EA-122N30LNRaymon Rodherick L · Enterprise, ALBuilt 2002 · S/N 40046N30PHStoneman Thomas K · Friendswood, TXS/N TJ-5N30SSN30ss LLC · Dover, DEBuilt 1973 · S/N 414-0451N31075Camden Group Inc · Boston, MABuilt 1988 · S/N E-2415N3109CVicjen LLC · Bloomington, ILBuilt 1987 · S/N E-2400N310ADChang Stephen · Santa Barbara, CABuilt 1976 · S/N 310R0538N310AHGraydon Bilal R · Melbourne, FLBuilt 1979 · S/N 310R1660N310AMCwr Enterprises Inc · Henderson, NCBuilt 1979 · S/N 310R1672N310ARHales Gutter Guys LLC · Cottonwood, AZS/N 310R1387N310BARampey Alvin H Jr · Atlanta, GABuilt 1975 · S/N 310R0065N310BFGv Air Inc · Medford, ORBuilt 1978 · S/N 310R1390N310BLAlsager Joshua D · Kindred, NDS/N 310Q0069N310BUTar Heel Aviation Inc · Bonita Springs, FLBuilt 1986 · S/N 4608004N310CESwainston Ian · Las Vegas, NVBuilt 1974 · S/N 310Q1063N310CLSinclair Bradley W · Melbourne, FLBuilt 1981 · S/N 310R2138N310DHFavero Robert B · Weed, CABuilt 1974 · S/N 310Q1086N310ECState Of Tennessee · Nashville, TNBuilt 1988 · S/N TH-1534N310ELFly Ivy LLC · Brighton, MABuilt 2024 · S/N 9795N310EMTc Aviation LLC · Atlanta, GABuilt 1988 · S/N 46-08109N310EWAerial Imaging Inc · South Bend, INBuilt 1973 · S/N 310Q0935N310FJSimmonds Don M · Sandpoint, IDS/N 310Q0542N310FLD & T Outlaw Properties LLC · Dallas, TXBuilt 2009 · S/N 3534N310GCCook Kevin M · Missouri City, TXBuilt 1973 · S/N 310Q0838N310HBSmith William G · Huntsville, TXBuilt 1980 · S/N 310R1876N310HDWwdd Enterprises LLC · Port Orange, FLBuilt 1975 · S/N 310R0519N310HMInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 310R1282N310JFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2485
Back to AD 2012-10-13