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.

N415PJPalm Springs Air Museum · Palm Springs, CAS/N 0002N415PW415air LLC · Tiburon, CAS/N 4965N415TLEilts Jason · Jefferson, GABuilt 2006 · S/N 2041N415WBCanon Robert G · Waller, TXBuilt 2015 · S/N 4296N416CDLewis Jim C · Tigard, ORBuilt 2006 · S/N 1820N416CERedwing Aviation LLC · Largo, FLBuilt 2019 · S/N 4782N416GWidhalm Chelsea · Yakima, WABuilt 2002 · S/N 0310N416PCKjt Aviation LLC · Beaumont, TXBuilt 2016 · S/N 4329N416RJCirrus Design Corp · Duluth, MNS/N 11806N416SCribbie Ronald J Trustee · Hernando, FLBuilt 2001 · S/N 0020N416TDC C Aviation Group LLC · Wilmington, DEBuilt 2009 · S/N 3398N416WBSoaring Eagle Air LLC · Salt Lake City, UTBuilt 2007 · S/N 2540N417JRBinary Ninjutsu LLC · Myrtle Beach, SCS/N 0222N417JTQuick Kenneth Wayne · Cordova, TNBuilt 2005 · S/N 1325N417KHWillens Mark D · Livermore, CABuilt 2010 · S/N 3657N417LCFowm LLC · West Memphis, ARBuilt 2016 · S/N 4367N417MMN417mm LLC · Kirkwood, MOBuilt 2007 · S/N 2332N417PWFleur De Lis Krewe LLC · Orlando, FLBuilt 2006 · S/N 1929N417TABrickler Alexander J · Tallahassee, FLBuilt 2002 · S/N 0241N417WDWheels Down LLC · Oklahoma City, OKBuilt 2014 · S/N 4162N418BCFlying Beep LLC · Athens, GABuilt 2016 · S/N 4372N418JCWalker Richard A · Omaha, NEBuilt 2004 · S/N 1132N418MLLloyd Morty C · Apison, TNBuilt 2006 · S/N 1781N418RMWind Sock Aviation LLC · Lancaster, KYBuilt 2005 · S/N 1719N419CDRsk Aviation LLC · Midland, MIBuilt 2005 · S/N 1377N419STMyers Steven L · Goodyear, AZBuilt 2005 · S/N 1656N41CASale Reported · Trapper C Reek, AKSale reportedBuilt 2017 · S/N 4559N41DWOne Delta Whiskey LLC · Westport, CTBuilt 2024 · S/N 9802N41JGRegistration Pending · Farmingdale, NYRegistration pendingBuilt 2026 · S/N 11510N41KBColne Valley Aviation Inc Trustee · Wilmington, DEBuilt 2022 · S/N 8813N41MMason Charles · Austin, TXBuilt 2025 · S/N 10719N41PJBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 3708N41SAIntegrated Design And Supply Inc · Crystal Lake, ILBuilt 2005 · S/N 1507N41SMHarper & Co Builders Inc · Douglas, GABuilt 2015 · S/N 4214N41VVTurner Andrew · Orange Beach, ALBuilt 2004 · S/N 1231N41WVKmfg3 Aero LLC · Barrington, NHBuilt 2014 · S/N 4100N41XPIra Ellis LLC · Jackson, TNBuilt 2002 · S/N 0206N420BLN420bl LLC · Carmel, INBuilt 2004 · S/N 1234N420GWSchell Scott A · Lisbon, NDBuilt 2004 · S/N 1077N420SEVadola James J Jr · Hillsborough, NJBuilt 2006 · S/N 2293N420SSZardoz Aviation Inc · Spring, TXBuilt 2022 · S/N 8750N421CShadow Cat Aviation LLC · Fitchburg, WIBuilt 2002 · S/N 0434N421CDTarsky Project LLC · Panama City Beach, FLBuilt 2006 · S/N 1791N422AKAlpha Kilo One LLC · Humble, TXBuilt 2014 · S/N 4099N422BSN422bs LLC · Bluffton, SCBuilt 2016 · S/N 4362N422DRQualitair LLC · MichelstadtBuilt 2007 · S/N 2705N422GH422gh Aviation LLC · Tampa, FLBuilt 2008 · S/N 3177N422GKKierspe Leasing LLC · Aiken, SCBuilt 2025 · S/N 10996N422JMVertical Consulting LLC · Boise, IDBuilt 2010 · S/N 3656N422LDMld Services LLC · Atlantic Beach, FLBuilt 2006 · S/N 2154
Back to AD 2007-24-13