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.

N294CAPhiladelphia Aviators LLC · Blue Bell, PABuilt 2014 · S/N 4031N294MCNorthcoast Airsports Ltd · Hudson, OHBuilt 2007 · S/N 2431N295AKGlick Farms Inc · Minot, NDBuilt 2003 · S/N 0719N295DLGottschalk Justin R · El Dorado Hills, CABuilt 2007 · S/N 2335N295EC295ec LLC · Eau Claire, WIBuilt 2002 · S/N 0197N295SDErf Flight Services LLC · Corpus Christi, TXS/N 4295N296MPMaskair LLC · Mount Pleasant, SCBuilt 2015 · S/N 4252N296RSFloridian Aerospace LLC · Ormond Beach, FLBuilt 2024 · S/N 10283N296SRBayland Air LLC · Severna Park, MDBuilt 2006 · S/N 2040N29820Wtc Aviation LLC · Shreveport, LABuilt 2018 · S/N 4617N298CSCirrus Sr22 Somex Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1408N299JWRas Aviation LLC · Elyria, OHBuilt 2004 · S/N 1034N299MPHessjet LLC · Mc Donald, TNBuilt 2005 · S/N 1396N299MRPlane Viewing LLC · Colbert, WABuilt 2003 · S/N 0753N299PMFailte Aire LLC · S Abingtn Twp, PAS/N 0306N29BP29 Bp LLC · Goshen, NYBuilt 2018 · S/N 4699N29KGCalvin M Holdings LLC · Dania, FLBuilt 2014 · S/N 4148N29UAN29ny LLC · Eatontown, NJBuilt 2005 · S/N 1282N29WHSr-22 Partners LLC · Danville, CABuilt 2004 · S/N 0974N29YACirrus Sr22 1353 Inc Trustee · Wilmington, DES/N 1353N2BG2fly LLC · Seattle, WABuilt 2009 · S/N 3458N2FTContemporary Aviation LLC · Excelsior, MNBuilt 2024 · S/N 10307N2MAFlorida Air Leasing LLC · Gainesville, FLBuilt 2004 · S/N 1177N2ZHClt Thompson Holdings LLC · Charlotte, NCBuilt 2001 · S/N 0056N3000DHungy Air LLC · Bettendorf, IABuilt 2001 · S/N 0083N301FBlue Sky November LLC · Mamaroneck, NYBuilt 2026 · S/N 11303N301FCTango Charlie Aviation LLC · Thomasville, GABuilt 2023 · S/N 9076N301GKBrown Water Associates LLC · Monticello, FLBuilt 2020 · S/N 4951N301JPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2240N301MDMoritz Davis Aviation LLC · Edina, MNBuilt 2009 · S/N 3484N301RVK6 Construction Inc · Clovis, CABuilt 2004 · S/N 1172N302BYAviation Homes LLC · Terrell, TXBuilt 2004 · S/N 0985N302CDChadmatt Explorations LLC · Pensacola, FLBuilt 2004 · S/N 1076N302CPJbl Aviation Group Inc · Houston, TXBuilt 2008 · S/N 3226N302SRRebel Aviation LLC · Ramsey, MNBuilt 2006 · S/N 2175N302TDFl370 LLC · Northbrook, ILBuilt 2006 · S/N 1780N303BPMohan Anand · Vienna, VABuilt 2005 · S/N 1698N303SRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 2420N304WHLone Beech Enterprises LLC · Peachtree City, GABuilt 2003 · S/N 0717N305APDoc Joey Inc · Wilmington, DES/N 0500N305CDModern Industrial Services Inc · Beaumont, TXBuilt 2006 · S/N 1966N306CDDesantis Michael J · Port Orange, FLBuilt 2005 · S/N 1355N306CPFe Xy LLC · Leesburg, VABuilt 2008 · S/N 3055N306DCEngeman Charles E · Charlotte, NCBuilt 2002 · S/N 0366N306KCBest Flight LLC · Carlsbad, CAS/N 0253N306RSCorsair Aviation Holdings LLC · Orange Park, FLBuilt 2019 · S/N 4743N306SRElevate Air Service LLC · Montrose, COBuilt 2007 · S/N 2469N306STKruljiac Jonathan Wade · Kenmore, WABuilt 2006 · S/N 2247N307AHadaway Phillip Allen · Hooks, TXBuilt 2006 · S/N 1913N307CDBarton Michael · Creve Coeur, MOBuilt 2004 · S/N 1092
Back to AD 2007-24-13