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.

N461BCB&K Leasing Inc · Nantucket, MABuilt 1992 · S/N TH-1661N461CAMach II LLC · Carlsbad, CABuilt 2025 · S/N 10963N461CDRiver City Leasing LLC · Lakeville, MNBuilt 2004 · S/N 1189N461DKMark Andregg Dds Pc · Tulsa, OKBuilt 1985 · S/N 46-8508102N461EDp Aviation LLC · Nixa, MOBuilt 2007 · S/N 2717N461MGHangar 94 LLC · Niwot, COBuilt 2021 · S/N 2261N461SRRiechers Peter Trustee · Napa, CABuilt 2007 · S/N 2604N4620YCenturion Travel LLC · Fort Worth, TXBuilt 1980 · S/N 21063960N4623FHatfield William G · Nunica, MIBuilt 1966 · S/N P206-0223N4624KHoyt Matthew P · Newport Beach, CABuilt 1979 · S/N P21000243N4626KWyeth Patrick B Trustee · Chino Valley, AZBuilt 1979 · S/N P21000244N4627KIsbell Brian · Rosenberg, TXBuilt 1979 · S/N P21000245N4627QMassey Larry A · New Braunfels, TXBuilt 1971 · S/N 21059527N4629KAuburn Farms LLC · Auburn, KSBuilt 1979 · S/N P21000247N462CAKinslow Aviation LLC · Prague, OKBuilt 2021 · S/N 2462N462CDSouth Fork Group LLC · Belmont, NCBuilt 2005 · S/N 1546N462CPPonozzo Donald A · Plainwell, MIBuilt 2008 · S/N 3275N462DLDanmar Leasing LLC · Little Rock, ARBuilt 2025 · S/N 10961N462HSAmelia Ann Cruzing LLC · Sibley, LABuilt 2003 · S/N 0775N462PT4888 Aviation LLC · Peachtree Corners, GABuilt 2015 · S/N 4282N462TJJohnson River LLC · Durant, OKBuilt 2019 · S/N 1919N462WWPlane Metrics LLC · Fort Worth, TXBuilt 2001 · S/N LIV-462-SFBN4630NHyannis Air Service Inc · Hyannis, MABuilt 1978 · S/N 402C0001N4631CGraves Martin · Odessa, TXBuilt 1979 · S/N 21063582N4635GN535j LLC · Bismarck, NDBuilt 1977 · S/N 414-0906N4636KAdvanced Database Designs LLC · San Ramon, CABuilt 1979 · S/N P21000248N463CZCzabaranek Joseph A · Bellevue, WAS/N LIV-063N463DPDouble Play Aviation LLC · Crossville, TNBuilt 2024 · S/N 10152N463KJCc Equipment Holdings LLC · Zionsville, INBuilt 2022 · S/N 8605N4640GHonea Richard S · Canton, GABuilt 1976 · S/N 414-0908N4644UWineglass Holdings LLC · Fort Davis, TXBuilt 1983 · S/N 21064797N4648ATimms Chet D · Central City, IABuilt 1983 · S/N P21000812N464KBStillwater Aviation LLC · Belmont, CABuilt 2018 · S/N 1786N464MMeyer Brent · San Antonio, TXBuilt 2002 · S/N 0221N464PCJordan Thomas Harvey III · Jasper, GABuilt 2004 · S/N 1208N464WHInfinite Loop Aviation LLC · Granite Bay, CABuilt 2019 · S/N 1928N4653Q53 Quebec LLC · El Dorado, CABuilt 1972 · S/N 21059553N4654MJetway LLC · Dover, DEBuilt 2005 · S/N 29-0370N4656KValley Agriculture LLC · Galt, CABuilt 1979 · S/N P21000251N465CPN465cp Partners LLC · Sugar Land, TXBuilt 2008 · S/N 3279N465DLKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1979 · S/N 310R1622N465JRegistered aircraftBuilt 2011 · S/N 0157N465KJBvw Aviation LLC · Grand Rapids, MIBuilt 2025 · S/N 10663N465SAGilmore Air LLC · Boca Raton, FLBuilt 2002 · S/N E-3465N465TXLsa Aircraft Holdings LLC · Houston, TXBuilt 2020 · S/N 2073N465TYBear Flight LLC · Atlanta, GABuilt 2026 · S/N 11494N4660JStuder Al C · Shelby, MIBuilt 1980 · S/N T18803759TN4665CKrissman Ryan · Gallup, NMBuilt 1977 · S/N U20603841N4668NSre Holdings LLC · Dewitt, MIFirst renewal noticeBuilt 1978 · S/N 414A0061N466CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0428
Back to AD 2012-10-13