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.

N82MVDelacerda Lucas Lane · Baton Rouge, LABuilt 2015 · S/N 4297N82MZN82mz LLC · Carlsbad, CABuilt 2024 · S/N 9921N82PHHarold Hart & Associates Inc · Tampa, FLBuilt 2005 · S/N 42082N82SAOrange Skies LLC · Falls Church, VABuilt 2004 · S/N 0902N82SNImmaculate Aviation LLC · Green Lane, PABuilt 2014 · S/N 0859N82TAJanes Paul A · Ontario, ORBuilt 1968 · S/N 402-0156N82TEAir Urology LLC · Wadmalaw Island, SCBuilt 2006 · S/N 1817N82TRExecutive Autopilots DBA · Sacramento, CABuilt 1972 · S/N 414-0273N82VTSwan Lake Farms LLC · Greensboro, GABuilt 2014 · S/N 0956N82VV82vv LLC · Portland, ORBuilt 2013 · S/N 0551N83000Gehrer Aviation LLC · Wichita, KSBuilt 1993 · S/N E-2829N8300ZWillowridge Farm · Winchester, KYBuilt 1993 · S/N EA-551N830BJElm III Operating Company LLC · Edmond, OKBuilt 1979 · S/N 340A0738N830CAValiair Lc Trustee · Casper, WYBuilt 2026 · S/N 11119N830CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 0158N830DSFry Craig · Carmel, INBuilt 2006 · S/N 2113N830TDWhite And Blue LLC · Auburn, CABuilt 1987 · S/N E-2397N830TPValhalla Partners LLC · Atlanta, GABuilt 1984 · S/N 46-8408015N830TTThuen Douglas · Andover, NJBuilt 1972 · S/N 3400186N831AMSky Candy LLC · Scottsdale, AZBuilt 2005 · S/N 1578N831AZ847cx LLC · St George, UTBuilt 2001 · S/N 0003N831BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 414A0340N831CCEntrantek LLC · Vancouver, WABuilt 2007 · S/N 2360N831CDNathan Smith Ministries · Belmont, NCBuilt 2005 · S/N 1580N831DE2000m LLC · Pooler, GABuilt 2020 · S/N 2205N831DWLivewire Ventures LLC · La Jolla, CABuilt 2016 · S/N 1233N831EDDiaz Edgar · Elmore, ALBuilt 2008 · S/N 3188N831GETs&L Aircraft LLC · Alexandria, MNS/N TJ-293N831JBEleven Western Builders Inc · Escondido, CABuilt 1980 · S/N TJ-279N831JCLaw Office Of Jerome A Clay · Stockton, CABuilt 2003 · S/N 0546N831JDMartinez Alexander J · Cumberland, MEBuilt 2006 · S/N 42506N831JWInternational Air Services Inc Trustee · Carson City, NVBuilt 2022 · S/N 8637N831MMAmelia Aviation LLC · Fernandina Beach, FLBuilt 2013 · S/N 0493N831RRFresh Farms Inc · King City, CABuilt 1986 · S/N 21064994N831SGDelahoussaye Investments LLC · Leander, TXBuilt 2003 · S/N 0647N831TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1995 · S/N 29-0031N831TAN831ta Inc · Port Orange, FLBuilt 2008 · S/N 3150N831TDJdm Aviation LLC · Yorba Linda, CABuilt 2006 · S/N 2087N831TRJaybird Aviation II LLC · Lake Charles, LABuilt 2025 · S/N 10973N831TXAtx Air Ventures LLC · Kalispell, MTBuilt 2022 · S/N 2476N831WCEpic Vibes Consulting Group Lp · Princeton, NJS/N 414-0467N831WTN831wt LLC · Centennial, COBuilt 2023 · S/N 9292N831YHorizon Aviation LLC · Tipp City, OHBuilt 2023 · S/N 9345N831ZHFlight Level 250 LLC · Carmel, CABuilt 2026 · S/N 11371N832LMScherado Kenneth · Las Vegas, NVBuilt 2004 · S/N 0832N832PSPase Aviation LLC · Houston, TXBuilt 2025 · S/N 10981N8338HBayviewer LLC · Sarasota, FLS/N EA-399N8338ZNistler Ben · Bozeman, MTBuilt 1963 · S/N 205-0338N833CFPilotbear Corp · Sherman, CTBuilt 2006 · S/N 2148N833JDReading Air LLC · St Charles, ILBuilt 2021 · S/N 2463
Back to AD 2012-10-13