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.

N789AMGal Aviation LLC · Winchester, MABuilt 2005 · S/N 1492N789BDTroy Farms Lp · Delano, CABuilt 1973 · S/N 310Q0922N789BJCulman William Donald Trustee · Scotts Valley, CABuilt 2010 · S/N 0053N789CDCf Steel LLC · Midland, NCBuilt 2009 · S/N 3567N789DLTj Air Holdings Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1732N789FMRadio Flyer LLC · Fox Point, WIBuilt 2000 · S/N EA-652N789JArr Planes LLC · Chattanooga, TNBuilt 1984 · S/N E-2145N789MD340a1021 Inc Trustee · Wilmington, DEBuilt 1980 · S/N 340A1021N789PPBloom Zachary Aaron · Lago Vista, TXFirst renewal noticeBuilt 2002 · S/N 3RX110N789PTValiair Limited Company · Casper, WYBuilt 1985 · S/N 414A1209N789PWTango Whisky LLC · Thomaston, GAFirst renewal noticeBuilt 2007 · S/N 2341N789RGBonanza N789rg LLC · Oro Valley, AZBuilt 1973 · S/N D-9483N789SLRoye Bart Laine · Slaton, TXBuilt 1975 · S/N TJ-12N789SPReed David Allen Trustee · Pinedale, WYBuilt 2003 · S/N 0742N789TRTbird Wings LLC · Evansville, WYBuilt 2014 · S/N 0954N789TX22t-2471 LLC · Austin, TXBuilt 2021 · S/N 2471N789VBFsq Aviation LLC · Dover, DEBuilt 2004 · S/N 0806N789VRN789vr LLC · Camden, DEBuilt 2023 · S/N 9337N789VSGaruda Aviation LLC · Genoa, NVBuilt 2020 · S/N 2132N789WBDale Scott A · Baltimore, MDBuilt 2001 · S/N 40029N78AEFirst To The Alternate II LLC · Atlantic Beach, FLBuilt 2014 · S/N 0831N78BBRadwanski D · Westmont, ILBuilt 1977 · S/N 310R1246N78BCMastin William · Fort Worth, TXBuilt 1989 · S/N EA-499N78CDPolyresources · Naperville, ILBuilt 2003 · S/N 0456N78DGUsac N78dg LLC · Wall Township, NJBuilt 1981 · S/N 414A-0641N78DSCane Express LLC · Vero Beach, FLBuilt 2018 · S/N 1777N78EEEagle Property Group LLC · Virginia Beach, VABuilt 2002 · S/N 0325N78EMMcclure Holding LLC · Alvaton, KYBuilt 2014 · S/N 4105N78GLB & L Grumman Tiger LLC · Pennsburg, PABuilt 2007 · S/N 2333N78HGJh Aviation LLC · Tyler, TXBuilt 2025 · S/N 10585N78KC5634 Aviation LLC · Flowery Branch, GABuilt 1978 · S/N 414A-0045N78KLNea Industrial LLC · Paragould, ARBuilt 1990 · S/N TH-1578N78KWVolz James R · Laredo, TXBuilt 1974 · S/N U20602647N78KZAz Sr22t LLC · Encino, CABuilt 2025 · S/N 10709N78LBBernston Lowell · Kulm, NDBuilt 2022 · S/N 8799N78MGCirrus Design Corp · Knoxville, TNBuilt 2020 · S/N 4907N78MKNelleh LLC · Liberal, KSBuilt 1978 · S/N 21062587N78MMCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11560N78MWSymple Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603205N78NGRam Aero Development Inc · Waco, TXS/N 414A0617N78PZMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2024 · S/N 9916N78RDPrecision Wingman LLC · Kingston, OKBuilt 2008 · S/N 3043N78RSSkorpiks Inc · Tyndall, SDBuilt 1980 · S/N D-10360N78SBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 340-0151N78SZAdhika Aviation Corp Trustee · Wilmington, DEBuilt 2016 · S/N 4301N78TFPritchett Thomas E · Post Falls, IDBuilt 1999 · S/N 30-0037N78UMDenver Air Support Inc · Englewood, COS/N TJ-84N78VFandler Fred E · Denton, TXBuilt 1996 · S/N 29N78VCBb58 LLC · Greenville, MSBuilt 1995 · S/N TH-1743N78VKSonier Michele M · Granbury, TXBuilt 2009 · S/N 293
Back to AD 2012-10-13