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.

N653JRRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1979 · S/N 340A0726N653KS653 Kilo Sierra LLC · Palm Springs, CABuilt 2008 · S/N 3233N6542CLeonard Summers · Pleasanton, CABuilt 1980 · S/N 21063913N6542UMcdade John P · Fraser, COBuilt 1985 · S/N 21064957N6544YSchwarzenberg Johannes · Helena, MTBuilt 1981 · S/N 21064429N6546NMitchell Matthew J · Penn Yan, NYBuilt 1978 · S/N 21063102N6547CJrp Management LLC · Williams, AZBuilt 1980 · S/N 21063915N654BHKdzrgon LLC · Moneta, VABuilt 2026 · S/N 11374N654BKCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11542N654CDCharlie Delta Aviation LLC · Sheridan, WYBuilt 2005 · S/N 1733N654DEDill Brice R · Glendale, AZBuilt 1978 · S/N 310R1428N654DMJohnson Douglas W · Jacksonville, FLBuilt 1997 · S/N 213N654JRCapital Holdings 233 LLC · Fullerton, CABuilt 2010 · S/N 3611N654KBDonatti Fernando E · Katy, TXBuilt 2014 · S/N 4139N654LCCirrus Bay Partners LLC · Naples, FLBuilt 2017 · S/N 4486N654MCD Andrea Victor Brian · White Rock, NMBuilt 2009 · S/N 3375N654MECayman Holdings Inc · Wilmington, DEBuilt 2023 · S/N 9607N654MFPenair LLC · Monroe, LABuilt 2022 · S/N 8739N654PGrimm Air LLC · Tucson, AZBuilt 2005 · S/N LIV-046N654PPPp Transportation Leasing LLC · Newburgh, NYBuilt 2020 · S/N 2050N654RSR Aviation LLC · Leawood, KSS/N 0471N654YBVandenberg Herbert · Ruston, LABuilt 2016 · S/N LIV-609N6553V44hw LLC · Shreveport, LABuilt 1967 · S/N D-8625N6553YCenturion Aero LLC · Coos Bay, ORBuilt 1981 · S/N 21064434N6557BFangio Mark · Mckinney, TXBuilt 1978 · S/N 21062786N655CBJlala LLC · Auburn, ALBuilt 2015 · S/N 1151N655CDCrh Services Inc · Shreveport, LABuilt 2004 · S/N 0916N6561CTrtc Aviation LLC · Byron Center, MIBuilt 1977 · S/N 414A0014N6562YKp Builders Inc · Pittsburgh, PABuilt 1981 · S/N 21064440N6567YMoeller Gerhard Walter · Goshen, OHBuilt 1981 · S/N 21064442N6568XBarnes Inc · Lewiston, IDBuilt 1980 · S/N U20605950N656CDAec Ally Equipment Company Inc · Murray, UTBuilt 2004 · S/N 1006N656MCMcintosh Justin W · Joshua, TXBuilt 1978 · S/N 21063111N656REPlane And Simple Inc · Sunrise Beach, MOBuilt 2015 · S/N 4222N656SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 3273N656TWAnderson Leif Knut · Sidney, MTBuilt 2005 · S/N 1331N6572YMoss G B · Bakersfield, CABuilt 1981 · S/N 21064444N6573EZxtair LLC · Janesville, MNS/N 1942SVN6578CPapoose Air II LLC · Wilmington, DEBuilt 1978 · S/N 414A0020N657CBBerichi Aviation Aircraft LLC · Fort Lauderdale, FLBuilt 2023 · S/N 9069N657MWWaddell Mark E · New York, NYBuilt 2023 · S/N 9138N6580XSouthwest Aerial Survey LLC · Carlsbad, CABuilt 1983 · S/N EA-341N6582Phoenix Aviation LLC · Bonaire, GABuilt 1976 · S/N 340A0125N6582PGrand High Way LLC · Gallatin, TNBuilt 1978 · S/N P21000191N6582XMclean Bruce R · Napa, CABuilt 1980 · S/N U20605958N6584NHartmann Wayne E · Hill City, SDBuilt 1978 · S/N 21063112N6585XNorthbay Consulting LLC · Bellevue, WABuilt 1983 · S/N EA-340N6586WMair LLC · Lenexa, KSBuilt 1982 · S/N P21000800N65873Carpenter Steve · Batesville, ARBuilt 1983 · S/N EA-342N6588XPc Rental LLC · Ely, MNBuilt 1980 · S/N U20605962
Back to AD 2012-10-13