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.

N328JWL & R Cirrus Inc · Portage, PABuilt 2002 · S/N 0225N328MBN328mb LLC · Old Bridge, NJBuilt 2004 · S/N 0867N328RHEchemendia Joel · Kissimmee, FLBuilt 2004 · S/N 1008N328SRStarr Robert J · Burlington, VTBuilt 2007 · S/N 2516N329RDCirrus Design Corp · Duluth, MNS/N 11779N329RMNova Aviators LLC · Great Falls, VABuilt 2011 · S/N 3776N329SFChampion Air LLC · Louisville, KYBuilt 2008 · S/N 3230N329SRHorn Russell · Woodbridge, CABuilt 2006 · S/N 2073N329WMMorning Star Aviation Services LLC · Charleston, SCS/N 3868N32AJFreedom Plane LLC · Freedom, NHBuilt 2012 · S/N 3852N32AZChristian Brothers Aviation LLC · Dalton, GABuilt 2013 · S/N 4028N32EPCaravelle Aviation LLC · Farmingdale, NYBuilt 2025 · S/N 10801N32GRAngella Tony · Fort Lauderdale, FLBuilt 2001 · S/N 0046N32JGBlackbird Florida LLC · Deerfield Beach, FLBuilt 2023 · S/N 9477N32MFHistick Logistics LLC · Camden, DEBuilt 2017 · S/N 4437N32WBFly Away LLC · Aguanga, CABuilt 2008 · S/N 3291N330CDDec Enterprises LLC · Naples, FLBuilt 2005 · S/N 1319N330DPAdvanced Commercial Group LLC · Helena, MTBuilt 2005 · S/N 1417N330HCTf Op LLC · Houston, TXBuilt 2023 · S/N 9223N331APSugar Creek Partners LLC · Rogers, ARBuilt 2021 · S/N 5109N331EDDaniel Dunagan Inc · Rome, GABuilt 2017 · S/N 4544N331SMApex Aviation LLC · Farmingdale, NYBuilt 2018 · S/N 4630N331TFCapital Holdings 244 LLC · Dover, DEBuilt 2024 · S/N 10133N331WGRegistration Pending · York, PARegistration pendingBuilt 2026 · S/N 11509N332CDDuggar Aviation LLC · Springdale, ARBuilt 2004 · S/N 0873N332DAHanford Equipment LLC · Eagle, IDS/N 3453N332GTArminair LLC · Dover, DEBuilt 2008 · S/N 3332N332LMLumbra Ronnie E · Rye, NYBuilt 2005 · S/N 1332N332MMRan Health Services Inc · Modesto, CABuilt 2025 · S/N 10749N332TTAlta Vista Enterprises LLC · Sheridan, WYBuilt 2009 · S/N 3525N333ARLe Bon Air Inc Trustee · Wilmington, DEBuilt 2004 · S/N 0844N333KQQuarles Transportation LLC · Bolivar, MOBuilt 2023 · S/N 9597N333LLNutex Concepts Of North Carolina Corp · Lenoir, NCBuilt 2017 · S/N 4447N333NYAvery Anne Leasing LLC · Rocky Point, NYBuilt 2016 · S/N 4373N333PXTime Investment Corp · Greenville, NCBuilt 2011 · S/N 3791N333QKPcg Aviation LLC · Charleston, SCBuilt 2025 · S/N 11014N333WSMuller Gabriel J · Leesburg, VABuilt 2004 · S/N 0906N334DATwo Knuckleheads & An Airplane LLC · Georgetown, TXBuilt 2009 · S/N 3396N335ASeals Richard S · Key Colony Beach, FLBuilt 2006 · S/N 2288N335CPMcbride John F Jr · Billerica, MABuilt 2008 · S/N 3250N335PGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1504N336BWright Brothers Aero Inc · Vandalia, OHBuilt 2006 · S/N 2049N336HTRegistered aircraftBuilt 2019 · S/N 4801N337GVVenturino Lee Angelo Trustee · Kure Beach, NCBuilt 2013 · S/N 3928N337RBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 0869N338CPQualitair LLC Trustee · MichelstadtBuilt 2008 · S/N 3253N338TXBussin' Air LLC · San Antonio, TXBuilt 2023 · S/N 9383N339CDMcwethy22 LLC · Woodstock, GABuilt 2004 · S/N 1107N339DTGuzauff LLC · Katy, TXBuilt 2015 · S/N 4224N339WMFlying Frenchies LLC · Naples, FLBuilt 2024 · S/N 9850
Back to AD 2007-24-13