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.

N42TJShark Vision LLC · Palm Harbor, FLBuilt 2017 · S/N 4507N42ZNHuntsville Flyers LLC · Owens Cross Roads, ALBuilt 2001 · S/N 0042N430LPDiamond D Aviation LLC · Northford, CTBuilt 2017 · S/N 4454N431CDMother Of Perpetual Succor LLC · Villa Hills, KYBuilt 2005 · S/N 1501N432CBAlltrade Aviation LLC · Fort Branch, INBuilt 2004 · S/N 1175N432CDVlahos Aviation LLC · Destin, FLBuilt 2004 · S/N 0941N433ALBowline Aviation LLC · Jupiter, FLBuilt 2026 · S/N 11357N433CFRotormate LLC · Royse City, TXS/N 0710N433CPPaul Family Properties - Texas LLC · Wasco, CABuilt 2008 · S/N 3070N433TMChristensen Michael S · Mesa, AZBuilt 2002 · S/N 0144N433WSAlpha Ingredients Inc · Belle Mead, NJS/N 0254N434CDFlycarolina LLC · Concord, NCBuilt 2005 · S/N 1514N434KBConnecting Aviators LLC · Katy, TXBuilt 2026 · S/N 11300N434MMMlc Aviation LLC · Inver Grove, MNBuilt 2007 · S/N 2643N434SRMiller Richard Francis · Waxhaw, NCBuilt 2007 · S/N 2557N434TBFlightworks LLC · Crozet, VAS/N 0290N435CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 0836N435CPNext Century Aviation LLC · Boca Raton, FLBuilt 2008 · S/N 3264N435SRM2 Aviation LLC · Concord Township, OHBuilt 2006 · S/N 2022N436CDSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N 1522N436CPAeronauncents LLC · El Paso, TXBuilt 2008 · S/N 3266N437CWestacott Simon · Fenwick Island, DEBuilt 2002 · S/N 0375N438CDSquibb Daniel · Xenia, OHBuilt 2005 · S/N 1404N438PCJaml Aviation LLC · Happy Valley, ORBuilt 2010 · S/N 3625N438SR10sm Clr LLC · Oklahoma City, OKBuilt 2007 · S/N 2567N439NKSt Louis Aircraft Partners LLC · Saint Louis, MOBuilt 2004 · S/N 0919N43LDIrongate Aviation LLC · Raymond, NHBuilt 2021 · S/N 5093N43TMMkt Development LLC · Venedocia, OHBuilt 2012 · S/N 3838N440CDN440cd LLC · Williamsburg, VABuilt 2005 · S/N 1515N441GWEugetech LLC · Bettendorf, IABuilt 2004 · S/N 1060N442TTQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1012N443CPBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3296N444AHPhalanx Pc LLC · Austin, TXBuilt 2006 · S/N 2137N444CVCloud Punchers LLC · Cary, NCBuilt 2017 · S/N 4527N444JHCirrusly Fast J2911 LLC · Duson, LABuilt 2016 · S/N 4376N444MFChampagne Cruises Ltd · St Thomas, VIBuilt 2002 · S/N 0174N444NPJc Aviation LLC · Raleigh, NCBuilt 2026 · S/N 11204N444UJAmbush Aviation LLC · Anabel, MOBuilt 2005 · S/N 1348N444VRBarber Casey John · Visalia, CABuilt 2003 · S/N 0788N445CDMockingbird Wings LLC · Wilmington, DEBuilt 2007 · S/N 2504N446BDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2366N446CPOn Eagles Wings Aviation LLC · Ponte Vedra Beach, FLBuilt 2008 · S/N 3297N446MTValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10708N448AMHetpath Aero LLC · Bismarck, NDBuilt 2015 · S/N 4205N448LMKinzler William · Tierra Verde, FLBuilt 2007 · S/N 2893N448SRAquatic Resources Management LLC · Lexington, KYS/N 1048N448TTScher Steven A · Sonoma, CABuilt 2008 · S/N 3073N449SRCline Aviation LLC · Travelers Rest, SCBuilt 2006 · S/N 1980N449WMWissman Enterprises LLC · Lincoln, NEBuilt 2012 · S/N 3869N44JHCirrusly Faster J2911 LLC · Duson, LABuilt 2008 · S/N 3192
Back to AD 2007-24-13