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.

N72PVBowman Theodore R · Santa Ynez, CABuilt 1988 · S/N E-2452N72PWAndrews Aviation LLC · Coralville, IABuilt 2024 · S/N 10088N72SCLsa Aircraft Holdings LLC · Houston, TXBuilt 1984 · S/N TJ-477N72TFLeuthner Roger B · Albuquerque, NMBuilt 1999 · S/N 29-0195N72VTNot Enuf LLC · Jackson, WYBuilt 1979 · S/N 340A0654N7301PPan Steve · San Francisco, CABuilt 2024 · S/N 10336N7303NJordan James D · Paradise, TXBuilt 1979 · S/N 21063218N7305URyan Air Inc · Anchorage, AKBuilt 1977 · S/N 20700392N730AFB Fam LLC · Texico, NMBuilt 1976 · S/N 414-0853N730BGBc Aviation LLC · Valdosta, GABuilt 2026 · S/N 11331N730BLHolden Simon · Napa, CABuilt 2021 · S/N 2421N730CN730c LLC · Merrimack, NHS/N 0410N730CDCirrus Associates LLC · Colorado Springs, COS/N 0053N730CNMaxim Aviation LLC · Scottsdale, AZBuilt 2025 · S/N 10584N730LTLt Wings LLC · Paris, TXBuilt 2022 · S/N 8988N730TRZero Tango Romeo LLC · Grand Junction, COBuilt 2024 · S/N 9871N730WDWjd Services LLC · Saint Augustine, FLBuilt 2018 · S/N 1761N730WWInternational Air Services Inc Trustee · Carson City, NVBuilt 2026 · S/N 11190N7311KChunga Air LLC · Orange Park, FLBuilt 2014 · S/N 4125N73123Lake Clark Air Inc · Port Alsworth, AKBuilt 1979 · S/N 20700561N731APEastway Properties LLC · Moxee, WABuilt 2009 · S/N 3566N731ATMark L Carman · Aiken, SCBuilt 2005 · S/N 1728N731BJArmis Strategies LLC · Hartwell, GABuilt 1979 · S/N P21000437N731CBAnesthesia Aviation LLC · Leesburg, VAS/N P21000545N731CDOwen Brian F · Tulsa, OKBuilt 2001 · S/N 0129N731CYSan Diego Air Service · San Diego, CABuilt 1979 · S/N P21000442N731DSYou And Me LLC · Sedalia, MOBuilt 1979 · S/N P21000446N731EAExperience Aviation Inc · Opa Locka, FLBuilt 2005 · S/N 41518N731EMAuer William W · Saint Petersburg, FLBuilt 1988 · S/N E-2446N731FAFly Najd Inc Trustee · Wilmington, DEBuilt 2024 · S/N 10247N731FEJones Marilyn W · Collinsville, CTBuilt 1979 · S/N P21000450N731FKQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N P21000452N731FTMillican Clifford A · Burleson, TXBuilt 1979 · S/N P21000454N731GCLavalley Asset Management Inc · Potsdam, NYBuilt 1979 · S/N P21000457N731GVSolomon Mark Trustee · Wilmington, DEBuilt 1999 · S/N EA-631N731HRBrennan Timothy · San Francisco, CABuilt 1980 · S/N P21000464N731HTAeolus Aviation LLC · Franklin, TNBuilt 1980 · S/N P21000465N731HWOne Hotel Whskey LLC · Hugoton, KSBuilt 1980 · S/N P21000468N731JAMccallister Aviation Rentals & Sales LLC · Qulin, MOBuilt 1998 · S/N TH-1884N731JGGate Air LLC · Ketchum, IDBuilt 1980 · S/N P21000474N731JHGcl Juliet Hotel LLC · Winter Springs, FLBuilt 2021 · S/N 5027N731JXKai Herbert DBA · Rillito, AZFirst renewal noticeS/N P21000479N731KLMullen James P Jr · Rogers, ARS/N P21000483N731LNEastern Washington Ambulatory Anesthesia Svcs Pllc · Walla Walla, WABuilt 1980 · S/N P21000488N731LTDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N P21000436N731LUDiversified Air LLC · Kalispell, MTBuilt 1980 · S/N P21000490N731MQClassic Management Corp · Marion, INBuilt 1980 · S/N P21000496N731NCSmith Bryan · Wenatchee, WABuilt 1980 · S/N P21000502N731NRWife Approved LLC · Torrance, CABuilt 1980 · S/N P21000509N731NUNgu Services LLC · Sheridan, WYBuilt 1980 · S/N P21000512
Back to AD 2012-10-13