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.

N5461Lb Flying Aces LLC · Wilmington, DEBuilt 1991 · S/N E-2621N5464VLivingood Richard A · Tucson, AZS/N 21060955N5467APiedmont Air Services LLC · Helena, MTBuilt 1979 · S/N 21063454N5469XTechaero 210 LLC · Healdsburg, CABuilt 1980 · S/N P21000507N546CDScalini Fernando A · Huntington Beach, CABuilt 2005 · S/N 1627N546DMMorgan Aviation LLC · Dover, DEBuilt 2024 · S/N 10323N546ESBurgess James R · Cave Creek, AZBuilt 2014 · S/N MEW001ESN546KMAero Montana LLC · Greensboro, GABuilt 2008 · S/N 3262N546PAJnh Properties Aviation LLC · Morganton, NCBuilt 2024 · S/N 10094N547CHoch Jeffrey · Seattle, WABuilt 2003 · S/N 0484N547DTMcb Family Aviation LLC · Boca Raton, FLBuilt 2024 · S/N 10368N547EMWolcott John · Peoria, AZBuilt 1979 · S/N P21000271N547SMTrinity Aviation LLC · Rome, GAS/N 1828N547TJTj Flying Adventures LLC · Port Orange, FLBuilt 2017 · S/N 1497N5482CSantiago Robert S · Torrance, CABuilt 1979 · S/N 21063764N5484JCaba Joseph · Covington, LAS/N 310R0282N548CPF Partnoy Inc · San Diego, CABuilt 2008 · S/N 3329N548EBRomeo Charlie Aircraft Partners LLC · North Little Rock, ARS/N 0291N548GAHyannis Air Service Inc · Hyannis, MABuilt 1982 · S/N 402C0653N548RESabair LLC · Clinton, PABuilt 2025 · S/N 10969N5490AN5490a LLC · Rutherfordton, NCBuilt 1979 · S/N 21063467N5495VPhillips Ruffin P Jr · Lexington, NCBuilt 1975 · S/N 21060964N549CDValiair Limited Co Trustee · Casper, WYBuilt 2004 · S/N 1088N549SRPlane Fun Flying Club · Vancouver, WABuilt 2006 · S/N 2177N54AKGreat Planes Reproductive Centers Pa · Circle Pines, MNBuilt 1981 · S/N 21064473N54CCScythe & Spade Co · Grand View, IDBuilt 1979 · S/N P21000360N54DFSkywave Associates LLC · Spirit Lake, IABuilt 1972 · S/N 340-0172N54DTBell Air LLC · Valdosta, GABuilt 2023 · S/N 9248N54FMAetherion LLC · Miami, FLBuilt 2024 · S/N 10039N54JNDlz Aviation LLC · Ostrander, OHBuilt 1991 · S/N E-2684N54JQRegistered aircraftN-number assigned (import), not yet registeredS/N 414A0086N54KMFredriksson Conny · Prospect, KYS/N L2K-170N54KSParia Aviation LLC · Saratoga, CABuilt 2025 · S/N 10403N54KYGael Aviation Inc · West Harrison, NYBuilt 2015 · S/N 4207N54LGSynergy Wellness Group Inc · Bakersfield, CABuilt 2007 · S/N 2685N54LWDogtown Aviation LLC · Teton Village, WYBuilt 2007 · S/N 2407N54LXRegistered aircraftBuilt 2004 · S/N LIV 071N54PFSilverado Land Management LLC · Sparks, NVS/N E-2941N54PSAustin Bill DBA · Sparta, TNBuilt 1980 · S/N P21000492N54SXIfr Capital Leasing LLC · Miami, FLBuilt 2012 · S/N 0419N54TBTango Bravo LLC · Ann Arbor, MIBuilt 2002 · S/N LIV-229FBN54VL4791 Capital Holdings LLC · Austin, TXS/N 4791N54WFMajmudar Krupal · Flemington, NJBuilt 2017 · S/N 4506N54WMNemensky Jack · Southborough, MABuilt 1976 · S/N CE-657N54YZPalmquist Gustuf · Memphis, TNBuilt 2012 · S/N ES-171N550ACCrawford Alan R · Buchanan Dam, TXBuilt 2008 · S/N L2K-315N550AFAtm One Inc · Tulsa, OKBuilt 1979 · S/N EA-6N550AWWerback Andrew R · Sebastopol, CABuilt 2010 · S/N L2K-112N550BMarchetti 211 LLC · Helena, MTBuilt 2023 · S/N 212N550BNAllen Anne · Huntsville, TXBuilt 1977 · S/N 18265609
Back to AD 2012-10-13