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.

N771SRN771sr Inc Trustee · Wilmington, DEBuilt 2007 · S/N 2771N772CManitoba Pacific LLC · Laguna Niguel, CABuilt 2002 · S/N 0401N772CCWagner William · Oro Valley, AZBuilt 2005 · S/N 1539N772CDHarllee Cattle Company LLC · Bradenton, FLBuilt 2005 · S/N 1403N772DBAtb Aviation LLC · Wilmington, DEBuilt 2000 · S/N E-3314N772DDN36be LLC · Wilmington, DEBuilt 1993 · S/N E-2775N772DGDg Aviation LLC · Las Vegas, NVBuilt 2025 · S/N 10777N772LCTwo Bad Dogs LLC · Denver, COBuilt 2024 · S/N 10234N772MCayle Jonathan · Rochester, MIBuilt 1979 · S/N EA-14N772MDMary Rabbit LLC · Saratoga, CABuilt 1997 · S/N EA-605N772PCThompson John Christopher · Dallas, TXBuilt 2005 · S/N 29-0402N772RGFresh Wind Gts LLC · Knoxville, TNBuilt 2024 · S/N 10037N772TTBrightwater Enterprises LLC · Lakeway, TXBuilt 2004 · S/N 42058N7734MHeinrich Bruce · East Burke, VTBuilt 2005 · S/N 29-0397N77350Bottom Line Technologies Inc · Columbia, MDBuilt 2003 · S/N 42013N7736KValiair Lc Trustee · Casper, WYBuilt 1979 · S/N P21000420N773ABCirrus Aviators LLC · Leesburg, VABuilt 2022 · S/N 5146N773BBMinnesota Made Hockey Inc · Edina, MNBuilt 2007 · S/N 2425N773CDMississippi Pepin Flyers LLC · Hager City, WIBuilt 2005 · S/N 1362N773CMZee Lee Air LLC · Fort Lauderdale, FLBuilt 2017 · S/N 1560N773CVRengel & Co Architects Inc · Tustin, CABuilt 2018 · S/N 4644N773DCFlying Rose LLC · Sparks, NVBuilt 2006 · S/N 1989N773DVDuet Ventures LLC · Isle Of Palms, SCBuilt 2020 · S/N 4947N773GMBluff Aviation LLC · Lewes, DEBuilt 2019 · S/N 1864N773GPBb Co LLC · Parker, COBuilt 2015 · S/N 0971N773MGSei Bryan J Trustee · Albuquerque, NMBuilt 2019 · S/N 1940N773SRTiger Eye 2004 LLC · Montauk, NYBuilt 2007 · S/N 2773N773TA309 Holdings LLC · Wilmington, NCBuilt 2026 · S/N 11473N774CDValiair Limited Co Trustee · Casper, WYBuilt 2003 · S/N 0786N774CSWyo Ventures LLC · Buffalo, WYBuilt 1976 · S/N 21061359N774DCBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 340A0206N774EBBruce Erik · Yreka, CABuilt 2022 · S/N 8926N774MWOptus Air LLC · Wilmington, DEBuilt 2021 · S/N 2288N774PLTop Gun G Force LLC · Eatonville, WABuilt 2015 · S/N 1051N774RDDemuth Roger C Trustee · Valley View, TXBuilt 1974 · S/N 21060229N774SFOktex Air LLC · Ardmore, OKBuilt 2019 · S/N 1998N774SRLevesque Jay F · Rochester, NHBuilt 2007 · S/N 2747N774TRMb Air Inc · Fort Myers, FLBuilt 2021 · S/N 5046N7750QJohnson Gregory L · Orange, CABuilt 1973 · S/N 340-0200N77554U S Department Of The Interior · Boise, IDBuilt 1976 · S/N U20603408N7758BMiller Jeffrey A Trustee · Tucson, AZBuilt 1982 · S/N TJ-394N775ABLand Air & Sea LLC · Charlotte, NCBuilt 2024 · S/N 10326N775AR826tw LLC · Haverford, PABuilt 2026 · S/N 11444N775CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 0228N775EWThree Three Foxtrot Inc · Cedar Falls, IABuilt 2003 · S/N 0526N775JWCunningham William R · Broken Arrow, OKBuilt 1968 · S/N CJ-2N775RCAirswiss Inc · Wilmington, DEBuilt 1980 · S/N 402C0311N775ZHundal Medical Corp · Malibu, CABuilt 1980 · S/N TJ283N7763BWyndymere Harbor LLC · Port Saint Lucie, FLBuilt 2016 · S/N 4425N7763YBen Shuzen LLC · White Plains, NYBuilt 2023 · S/N 9252
Back to AD 2012-10-13