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.

N407CDKelly George Sumner · Columbus, GABuilt 2004 · S/N 1005N407KPDelta Consulting & Real Estate LLC · Manila, ARBuilt 2018 · S/N 4687N407ST5x Sr22 LLC · Sandy Springs, GABuilt 2022 · S/N 8917N408CDKc Jet Sales LLC · Scottsdale, AZBuilt 2005 · S/N 1464N408KMRivers Aviation LLC · Houston, TXBuilt 2022 · S/N 8968N408PGJs Extra 300 LLC · Dallas, TXBuilt 2008 · S/N 2984N408RFFogel Services Inc · Ladson, SCBuilt 2024 · S/N 9895N408WGBlue Sky 408 LLC · Lakeland, TNBuilt 2009 · S/N 3565N409CDArmbruster LLC · Amherst, OHBuilt 2005 · S/N 1286N40GDSimply Living LLC · Fort Myers, FLBuilt 2003 · S/N 0473N40YMN40ym LLC · Mattituck, NYBuilt 2025 · S/N 10616N410MPGulf Horizon Ventures LLC · Tampa, FLBuilt 2021 · S/N 5005N410PPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2010 · S/N 3600N410SRBiondich Amy · Rubicon, WIBuilt 2006 · S/N 2138N410VVDaniels Mark A · Raleigh, NCS/N 3394N411APN411ap LLC · Independence, KSBuilt 2002 · S/N 0215N411BJclm Aviation LLC · Atlanta, GABuilt 2006 · S/N 1865N411DTSliwa Kevin Joseph · Fishers, INBuilt 2010 · S/N 3678N411EPRsbrm Aviation LLC · Lakewood, NJBuilt 2025 · S/N 10607N411EWC B Saunders Properties LLC · Alpharetta, GAS/N 0250N411GTTeam 646 LLC · Jupiter, FLBuilt 2005 · S/N 1714N411HZCedar Dix LLC · Lancaster, KYBuilt 2005 · S/N 1568N411MARouse William J · Palm Springs, CAS/N 3496N411PKC C Owen Tile Co Inc · Jonesboro, GABuilt 2008 · S/N 3368N411SAMasdon Aviation LLC · Guntersville, ALBuilt 2006 · S/N 1967N411SKRiverside Aviation LLC · Fernandina Beach, FLBuilt 2017 · S/N 4582N411SRC1n Cirrus G3 LLC · Rockford, ILBuilt 2007 · S/N 2518N411VTFletcher Holdings Of Nc LLC · Winston Salem, NCBuilt 2002 · S/N 0393N4122PCloud Eight LLC · Los Altos, CABuilt 2023 · S/N 9394N412CPSevern Aviation LLC · Richmond, VABuilt 2009 · S/N 3457N412DJStringfield Lisa P · Los Alamos, NMBuilt 2005 · S/N 1433N412JJSkybird Aviation LLC · Bowling Green, KYBuilt 2007 · S/N 2846N412PGVisual Approach LLC · Vienna, VABuilt 2026 · S/N 11276N412SRHealing Waters Counseling Center LLC · Cedar Bluff, VABuilt 2006 · S/N 2176N412TKBaerresen Drake A · Corona, CAS/N 0552N413AKAlhambra Aviation LLC · San Mateo, CABuilt 2016 · S/N 4429N413CNOa2 Aviation LLC · Gallatin, TNBuilt 2010 · S/N 3651N413CPDean Taylor LLC · Palm Coast, FLBuilt 2008 · S/N 3257N413PTag Aviation LLC · Larwill, INBuilt 2004 · S/N 1073N413RSStewart Rentals LLC · Tampa, FLBuilt 2026 · S/N 11460N413SRBroussard Knoll Law Firm LLC · Marksville, LABuilt 2006 · S/N 1936N413TLSnapper Kai LLC · Kerrville, TXBuilt 2016 · S/N 4338N4141TPremier Properties And Investments LLC · Tarkio, MOBuilt 2005 · S/N 1442N4141XSpuddy Properties LLC · Leclaire, IABuilt 2005 · S/N 1716N414CKN414ck LLC · Tacoma, WABuilt 2009 · S/N 3414N414CPCsu Aviation LLC · Plainfield, INBuilt 2008 · S/N 3209N414TXKwb LLC · Dover, DEBuilt 2004 · S/N 1165N415BBAventra Aviation LLC · Fuquay Varina, NCBuilt 2006 · S/N 2083N415GEN415ge LLC · Wilmington, DES/N 0693N415GFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 0067
Back to AD 2007-24-13