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.

N44KCSpitfire Ix Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 2003 · S/N 0516N44WFWildy David · Manila, ARBuilt 2003 · S/N 0533N44WWHauser Michael L · Glendale, AZBuilt 2006 · S/N 1946N44WXA O Retail Consulting Inc · Oconomowoc, WIBuilt 2005 · S/N 1258N450CDAlcyone Trust Corp Trustee · Wichita, KSBuilt 2005 · S/N 1478N450SUMore Right Rudder LLC · Edmond, OKBuilt 2012 · S/N 3901N450TXM And M Aviation Leasing LLC · Wilmington, DEBuilt 2004 · S/N 1063N451MVOne Mike Victor Aviation LLC · Belmont, CABuilt 2016 · S/N 4365N451SRSkywalk LLC · Olive Branch, MSBuilt 2007 · S/N 2325N451TJSr22 Aviators LLC · Crete, ILBuilt 2004 · S/N 0866N452CDTimber Ridge Aviation LLC · Wilmington, DEBuilt 2010 · S/N 3652N452JGQualitair LLC Trustee · MichelstadtS/N 1415N452MDHeartsill Lucas G · San Angelo, TXBuilt 2016 · S/N 4426N452TXEfficient Transportation Services LLC · Harpers Ferry, WVBuilt 2015 · S/N 4233N452VABegio Aviation LLC · Arlington, VABuilt 2019 · S/N 4776N454CPWestern Chancellor LLC · Fort Worth, TXBuilt 2008 · S/N 3303N454RKFiore Christopher · Forked River, NJS/N 2084N454SDDelcampo Holdings LLC · Atlanta, GABuilt 2008 · S/N 3114N454SRFaisal Tameesh · Sterling Heights, MIBuilt 2007 · S/N 2428N4555Glass Bagging Ent Inc · Duncansville, PABuilt 2008 · S/N 3312N455BDArchco II LLC · Bloomfield, NEBuilt 2004 · S/N 1029N455CDSanta Barbara Biplane Tours LLC · Santa Barbara, CABuilt 2004 · S/N 0907N455MVGrand Sierra Investments LLC · Kingfisher, OKBuilt 2016 · S/N 4307N455PCPch Inc · Roseville, CABuilt 2006 · S/N 1961N455SPSrb Aviation LLC · Pewaukee, WIBuilt 2007 · S/N 2406N455SRScottie Dog Air LLC · Wilmington, DEBuilt 2006 · S/N 2229N455TCTompkins Landing Lc · Wayne, NEBuilt 2007 · S/N 2491N456ACHotel Quebec I LLC · Mount Pleasant, SCBuilt 2015 · S/N 4249N456DCCatalpa Holdings LLC · Las Vegas, NVBuilt 2005 · S/N 1525N456GGCoward Lawrence Jayson · Paris, TXBuilt 2004 · S/N 0896N456KMKilo Mike Aviation LLC · Chandler, AZBuilt 2006 · S/N 1977N456LEAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2006 · S/N 1868N456LL2fly-Safety LLC Trustee · Azle, TXBuilt 2008 · S/N 3009N456MGJones Daniel S Trustee · Hendersonville, NCBuilt 2008 · S/N 3330N456RTMassive Solutions LLC Trustee · Denton, TXBuilt 2002 · S/N 0314N457CAFox William B · Malvern, PAS/N 3160N457CBPreferred Aviation Technologies LLC · Mooresville, NCBuilt 2008 · S/N 3058N457FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10457N458BBLeonard Aviation LLC · Ponte Vedra Beach, FLBuilt 2018 · S/N 4716N458CAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 0388N458CPEagle Aviation LLC · Hawarden, IABuilt 2008 · S/N 3255N458RHHamil Robert D · Houston, TXBuilt 2005 · S/N 1688N458TTTurner George T · Alpharetta, GABuilt 2004 · S/N 0801N458TWFirst Aviation Co · Prospect Heights, ILBuilt 2003 · S/N 0697N459CDUrsine Teleportation LLC · Redmond, WABuilt 2005 · S/N 1535N45BVGrinberg Dmitry · Austin, TXBuilt 2004 · S/N 1007N45CXRobin Aviation LLC · Plymouth, MIBuilt 2021 · S/N 5145N45DMRaolji Mahendra · Florida City, FLBuilt 2018 · S/N 4634N45GLOptimal Aircraft Management Nc LLC · Sanford, MIBuilt 2006 · S/N 1870N45JNSpotts Marcus P · Nora Springs, IABuilt 2003 · S/N 0489
Back to AD 2007-24-13