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.

N367KRYance International LLC · Mobile, ALBuilt 2006 · S/N 2162N367PTHalcomb Robby · Burleson, TXBuilt 2012 · S/N 3854N367TMTm Ventures LLC · Missoula, MTBuilt 2009 · S/N 3590N368CDSavfar Aviation Inc · Wilmington, DEBuilt 2004 · S/N 1071N368DMNosrati David · Beverly Hills, CABuilt 2007 · S/N 2433N368FDOakes Farms Food & Distribution Services LLC · Naples, FLBuilt 2019 · S/N 4858N369CHLiberty Leasing Ix LLC · Melbourne, FLBuilt 2007 · S/N 2665N369JDVitale Baxter 2 Llp · Baxter, MNBuilt 2010 · S/N 3686N369PCPine Holdings LLC · Broken Bow, OKBuilt 2020 · S/N 4916N369SESkyfusion II LLC · Atlanta, GABuilt 2004 · S/N 0846N369SFFlying Pig Express II LLC · Bucyrus, OHBuilt 2008 · S/N 3087N369ZDZelta Air LLC · Newark, DEBuilt 2025 · S/N 10702N36BXCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10599N36GWSky Whiddon Inc · Fort Lauderdale, FLBuilt 2023 · S/N 9551N36MRCook Canyon (Gp) LLC · Dallas, TXBuilt 2018 · S/N 4631N370GAir Land Ventures LLC · Highland Park, ILBuilt 2003 · S/N 0783N370JGGuideair LLC · Eden Prairie, MNBuilt 2004 · S/N 1123N371CDEicholz Robert Trustee · Palm Springs, CABuilt 2005 · S/N 1434N371ECNext1sr LLC · Dayton, OHBuilt 2025 · S/N 10487N371PMElias Miguel A · Kenner, LAS/N 4371N372LFShoemaker William · Manns Choice, PABuilt 2004 · S/N 1074N373BBSchackel Shacks LLC · Durango, COBuilt 2007 · S/N 2508N373CDKnight Douglas G · Bend, ORBuilt 2005 · S/N 1468N373DSRegistered aircraftBuilt 2007 · S/N 2310N373ERStx Aviation LLC · Fresno, CABuilt 2006 · S/N 1923N373MCKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2008 · S/N 2996N373PSEngineered Propulsion Systems Inc · New Richmond, WIBuilt 2002 · S/N 0173N373SRSummer Dog LLC · Greenwich, CTBuilt 2007 · S/N 2743N3747TAir Force One LLC · Coral Springs, FLBuilt 2005 · S/N 1328N374CDN374cd LLC · Goffstown, NHBuilt 2004 · S/N 1174N374RLDeep Blue Spring LLC · Doral, FLBuilt 2022 · S/N 9026N374WHLr Freedom Air LLC · Tallahassee, FLBuilt 2025 · S/N 10746N375BMBlotsky Jim · Fargo, NDBuilt 2024 · S/N 10092N375CDAtlantic Marine Construction Co Inc · Virginia Beach, VABuilt 2005 · S/N 1461N375DBEight Aviation LLC · Greenwood Village, COS/N 2331N375MTVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 3298N375NDInsuring That Pigs Can Fly LLC · Tyrone, GABuilt 2013 · S/N 3953N375RRRegistered aircraftBuilt 2020 · S/N 4961N375THRbm Records And Promotion LLC · Clinton, OHBuilt 2024 · S/N 10060N375TT4two9 Aviation LLC · Princeton, FLBuilt 2017 · S/N 4550N376BCKunz Paul C · Midway, UTBuilt 2006 · S/N 2186N376CDWestern Chancellor LLC · Fort Worth, TXBuilt 2005 · S/N 1425N377ALKairis Perry A · High Point, NCBuilt 2018 · S/N 4622N377BCMelcor Aviation LLC · Hopkinton, MABuilt 2022 · S/N 8996N377CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1022N377JJThree L Aviation LLC · Victor, NYBuilt 2007 · S/N 2646N377MRMaquinarias Repuestos Inc · Miami, FLBuilt 2002 · S/N 0268N377TXFauber Dan · Granbury, TXBuilt 2020 · S/N 4950N378CTamavo Inc · Baltic, SDBuilt 2008 · S/N 3235N378GLReel Trip LLC · Knightdale, NCBuilt 2009 · S/N 3433
Back to AD 2007-24-13