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.

N422LMJafari Dadbeh · Edmond, OKBuilt 2001 · S/N 0118N422LTSr Flyers LLC · Baltimore, MDBuilt 2003 · S/N 0730N422PCSalty Pines LLC · Haverford, PABuilt 2024 · S/N 10318N422RJTopflight Aviation Inc · Brentwood, TNBuilt 2013 · S/N 3942N422SNFalcon Flight LLC · Las Vegas, NVS/N 3508N422SRReno Flight Club LLC · Reno, NVBuilt 2006 · S/N 1976N422TBMark 2 Aviation LLC · Sand Springs, OKBuilt 2006 · S/N 1888N423BDConcorde Transportation LLC · Freehold, NJBuilt 2020 · S/N 4893N423CDGrzebik Ellerine P · Petaluma, CAS/N 1109N423CPAltus Aviation LLC · Pike Road, ALBuilt 2013 · S/N 3944N423SRHaloroc Muppets II LLC · Nashville, TNBuilt 2007 · S/N 2459N424ATInspiring Strength Inc · Redding, CABuilt 2011 · S/N 3817N424AXPolyloom Corporation Of America Inc · Florence, ALBuilt 2016 · S/N 4308N424BBYoung Robert N · Stratham, NHBuilt 2015 · S/N 4195N424BDBadass Aviation LLC · Fernandina, FLBuilt 2005 · S/N 1723N424CKCca Aviation LLC · Great Bend, KSS/N 3495N424EGS&R Flying LLC · Franklin, TNBuilt 2004 · S/N 0887N424PBDavis John W · Sugar Land, TXBuilt 2015 · S/N 4277N424RSRomeo Sierra LLC · Acworth, GABuilt 2025 · S/N 10604N424SRMartin Gary D · Plano, TXBuilt 2007 · S/N 2464N424SWPrestige Worldwide Sr22 LLC · Caldwell, IDBuilt 2009 · S/N 3380N424XBespinx LLC · Austin, TXBuilt 2014 · S/N 4153N425BVBvi Air LLC · Grand Forks, NDBuilt 2014 · S/N 4158N425CDDtn Aviation LLC · Winona, MNBuilt 2004 · S/N 0892N425CGSchmiesing Brothers Aviation Ltd · Minster, OHBuilt 2007 · S/N 2814N425JAWhiskey Tango Fox LLC · Portland, ORBuilt 2007 · S/N 2452N425MHN425mh LLC · Geismar, LABuilt 2017 · S/N 4517N425MSMcdonald Shane · Belmont, MSBuilt 2005 · S/N 1256N425MTRkg Enterprises · Hibbing, MNBuilt 2015 · S/N 4201N426BGZulu Golf LLC · Henderson, NVBuilt 2026 · S/N 11277N426BLRice Developments LLC · Walker, LABuilt 2022 · S/N 8653N426DJNehoc Leasing LLC · Marietta, GABuilt 2019 · S/N 4867N426GWNottingham Holdings LLC · Bluffton, SCBuilt 2017 · S/N 4520N426SRSchoeneman Michael D · Central Point, ORBuilt 2006 · S/N 2205N426SSCirrus Design Corp · Duluth, MNS/N 11739N426WVAbhrdh Enterprises LLC · Bunker Hill, WVBuilt 2025 · S/N 10548N427ATMockingbird LLC · Bloomington, INBuilt 2004 · S/N 0954N427KGWhite James J IV · Conroe, TXBuilt 2008 · S/N 3068N427SRTrosclair Air LLC · Gonzales, LABuilt 2007 · S/N 2432N428AMT G Mendell Corp · New York, NYBuilt 2020 · S/N 4896N428ANPatriot Flyers LLC · Lake Havasu City, AZBuilt 2006 · S/N 2092N428APPaper Plane Aviation LLC · Sharpsburg, GABuilt 2026 · S/N 11406N428SRLautman Karl F Trustee · Los Angeles, CABuilt 2006 · S/N 2258N428TLight Korbin T · Midland, TXBuilt 2001 · S/N 0049N428TMBlue Jay Omni Bearing LLC · Fargo, NDS/N 0167N428ZZDeans List Aviation LLC · Nashville, TNBuilt 2020 · S/N 4987N429CDQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1064N429SRN205bp LLC · Sheridan, WYBuilt 2007 · S/N 2686N42BELasalle Management Company LLC · Ruston, LAS/N 3903N42PYArtemis Aviation LLC · Houston, TXBuilt 2022 · S/N 8941
Back to AD 2007-24-13