AD 2007-24-13

Registered aircraft · 4,026

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:2007-24-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:2007-24-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.

N222LDHrt Aviation LLC · Charleston, SCBuilt 2006 · S/N 1838N222SRC & C Air LLC · Cumming, GAS/N 0858N222XJBismarck Aircraft Owners Llp · Mandan, NDBuilt 2016 · S/N 4325N222YYMerlin Aviation LLC · Fairfield, CTBuilt 2005 · S/N 1458N223BMCirrus 801ca LLC · Port Angeles, WABuilt 2015 · S/N 4285N223ERKern Delta Co LLC · Fresno, CABuilt 2007 · S/N 2658N223FDRegistered aircraftBuilt 2023 · S/N 9162N223GBMain Line Aviation LLC · Haverford, PABuilt 2022 · S/N 8638N223GKGk Aviation LLC · Orlando, FLBuilt 2022 · S/N 8764N223HHMach Speed Properties LLC · Spiro, OKBuilt 2006 · S/N 2212N223MKKaul Mahendra · Bainbridge Island, WABuilt 2004 · S/N 1003N223MRConderet LLC · New York, NYFirst renewal noticeBuilt 2006 · S/N 1760N223RWRegistered aircraftBuilt 2010 · S/N 3442N223TFMeadowlark Air LLC · Johnston, IABuilt 2011 · S/N 3814N223TNGeneral Aviation Modifications Inc · Ada, OKBuilt 2007 · S/N 2698N223TSJvgh LLC · Eastpoint, FLBuilt 2019 · S/N 4788N223TXBaron Logistics LLC · Metairie, LABuilt 2007 · S/N 2494N2242WKikhtenko Dmytro · Horse Shoe, NCBuilt 2025 · S/N 10831N2246HHanover Flying Club LLC · Mechanicsville, VABuilt 2014 · S/N 4127N2247RSkaggs Erik Jerome · Tupelo, MSBuilt 2017 · S/N 4534N224ARAvtac Solutions LLC · Oneida, TNBuilt 2001 · S/N 0137N224AVAirplanesusa LLC · Schaumburg, ILS/N 2324N224BGSlo Cal Aviation LLC · Arroyo Grande, CABuilt 2017 · S/N 4469N224BTCacchiotti Lawrence F · Yakima, WABuilt 2002 · S/N 0370N224CESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2016 · S/N 4396N224CFTitan Land Company LLC · Medford, ORS/N 2926N224CZTeal Skies LLC · Wilmington, DEBuilt 2011 · S/N 3771N224DAAiralley LLC · Kingsport, TNBuilt 2008 · S/N 2988N224DDDe Maio Dorian Albert · Las Vegas, NVBuilt 2007 · S/N 2625N224DGFahrer Scott M · Sunrise Beach, MOBuilt 2002 · S/N 0275N224EBVasquez Aviation LLC · Lake Placid, FLBuilt 2005 · S/N 1287N224EJGlenn Air LLC · Ponte Vedra Beach, FLBuilt 2023 · S/N 9476N224FRVictor 93 LLC · Hummelstown, PABuilt 2008 · S/N 2953N224GRHaufe Nicole C · Madeira Beach, FLBuilt 2003 · S/N 0626N224HFHallock Scott A Sr · Oneida, TNS/N 0255N224JC109 Ventures & Agency Services Inc · Glenburn, MEBuilt 2004 · S/N 0914N224JF224jf LLC · Waterford, MIBuilt 2006 · S/N 2031N224JGGuillory Mark T · Pineville, LABuilt 2004 · S/N 1013N224KRJds Holdings LLC · Oneida, TNBuilt 2002 · S/N 0179N224LRCamp95 Enterprises LLC · Wheeling, WVBuilt 2002 · S/N 0155N224LZMazzia Aviation Partners LLC · Alpine, WYBuilt 2007 · S/N 2767N224MVAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 1922N224NHLola Leasing LLC · Sugar Land, TXBuilt 2009 · S/N 3569N224NXNexair Avionics LLC · Plymouth, MABuilt 2002 · S/N 0170N224PBDeaux James · Collierville, TNBuilt 2006 · S/N 1754N224PCCarlson Craig B Trustee · Los Altos, CABuilt 2018 · S/N 4655N224PFKurrle Ryan J · Austin, TXBuilt 2006 · S/N 1917N224PJLeng Jason W · Chehalis, WABuilt 2006 · S/N 2281N224RCSky West Aviation Inc Trustee · Albuquerque, NMS/N 2919N224RJDuke Mfg Of Florida LLC · Saint Louis, MOBuilt 2013 · S/N 4027
Back to AD 2007-24-13