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.

N371PMElias Miguel A · Kenner, LAS/N 4371N371SLOrnelas Sergio L · Santa Teresa, NMBuilt 2017 · S/N 1652N371STSierra Aviation LLC · Fort Lauderdale, FLBuilt 2026 · S/N 11145N37236Nay Richard B · Gunnison, UTBuilt 1981 · S/N EA202N37268H & S Aircraft LLC · Lewes, DEBuilt 1977 · S/N 310R0983N37285Java Air LLC · Visalia, CABuilt 1979 · S/N 340A0953N372CCLemieux Kenneth G · Oneida, TNBuilt 1974 · S/N 310Q1071N372FCHeartland Aviation Inc · Alliance, NEBuilt 1971 · S/N 310Q0215N372LFShoemaker William · Manns Choice, PABuilt 2004 · S/N 1074N372WTCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11575N37302Elrod Jason A · Seattle, WABuilt 1977 · S/N 340A0334N37306Frescomar USA LLC · Miami, FLS/N 340A0336N37315Atlantic Coast Contractors Inc · Denver, NCBuilt 1977 · S/N 340A0341N3731GMaxwell Truck & Equipment LLC · State College, PABuilt 1977 · S/N 310R0906N37343Bearings & Belts LLC · Carlsbad, NMBuilt 1977 · S/N 340A0358N37356Congregation Rosh Hagivah Inc · Waterbury, CTBuilt 1977 · S/N 340A0364N37360Tkn Holdings LLC · Pima, AZBuilt 1978 · S/N 340A0402N3737Qualitair LLC · MichelstadtBuilt 1985 · S/N 468508060N37376Huntley Storage Units LLC · Billings, MTBuilt 1977 · S/N 340A0374N373ARPaul Brightwell Dirtworks Inc · Springer, OKBuilt 1979 · S/N P21000308N373BBSchackel Shacks LLC · Durango, COBuilt 2007 · S/N 2508N373CDKnight Douglas G · Bend, ORBuilt 2005 · S/N 1468N373DHigh Flight Baron LLC · Holland, MIBuilt 1980 · S/N TJ-299N373DSRegistered aircraftBuilt 2007 · S/N 2310N373ERStx Aviation LLC · Fresno, CABuilt 2006 · S/N 1923N373MCKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2008 · S/N 2996N373PJRock Creek Corp · Henderson, NVBuilt 1978 · S/N 21062887N373RWCjcat LLC · Sugar Land, TXBuilt 2019 · S/N 1975N373SRSummer Dog LLC · Greenwich, CTBuilt 2007 · S/N 2743N373STLassen Peter C · Ventura, CAS/N EA-308N37402Viking Construction Inc · Hayden Lake, IDBuilt 1980 · S/N EA-165N3745PRiviera Aircraft Inc · Lewes, DEBuilt 1978 · S/N P21000052N3747CS I Air Inc · Dover, DEBuilt 1975 · S/N 414-0818N3747TAir Force One LLC · Coral Springs, FLBuilt 2005 · S/N 1328N374CDN374cd LLC · Goffstown, NHBuilt 2004 · S/N 1174N374RLDeep Blue Spring LLC · Doral, FLBuilt 2022 · S/N 9026N374TTTyphoon Holdings LLC · Valdosta, GABuilt 2021 · S/N 2438N374WHLr Freedom Air LLC · Tallahassee, FLBuilt 2025 · S/N 10746N3752CMiller Robert G · Clear Lake, IAS/N 414-0819N3758CDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 414-0839N375AJGolden Calf Company LLC · Bloomer, WIBuilt 2010 · S/N 0041N375BMBlotsky Jim · Fargo, NDBuilt 2024 · S/N 10092N375CDAtlantic Marine Construction Co Inc · Virginia Beach, VABuilt 2005 · S/N 1461N375CWN375cw LLC · Fort Smith, ARFirst renewal noticeBuilt 2017 · S/N 1487N375DBEight Aviation LLC · Greenwood Village, COS/N 2331N375JWPanthers Aviation LLC · Pikeville, KYBuilt 1995 · S/N E-2918N375MF5k Management LLC · Burnet, TXBuilt 2015 · S/N 1187N375MJJerez Mario · Coral Gables, FLBuilt 2023 · S/N 9605N375MTVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 3298N375NDInsuring That Pigs Can Fly LLC · Tyrone, GABuilt 2013 · S/N 3953
Back to AD 2012-10-13