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.

N33CFObx Boil Aviation LLC · Kitty Hawk, NCBuilt 2022 · S/N 8525N33HCSmith Christopher J · Longwood, FLBuilt 2004 · S/N 0815N33JGCavu 1989 LLC · New Hope, PABuilt 2021 · S/N 5075N33MWSackett Gary G · Millcreek, UTBuilt 2007 · S/N 2435N33PFNeed For Speed Aviation LLC · Charleston, SCBuilt 2007 · S/N 2572N33TVTgbde LLC · Fort Pierce, FLBuilt 2007 · S/N 2400N33WSJak2 Properties LLC · Ocala, FLBuilt 2017 · S/N 4563N340CDArgent Holding (USA) Ltd · Corona, CAS/N 1354N341EYEdy Aviation LLC · Framingham, MABuilt 2017 · S/N 4571N3427BBoyle Corey J · Robbinsville, NJBuilt 2025 · S/N 10868N3427DPowers Ryan · Boston, MABuilt 2021 · S/N 5099N342ACC & L Aviation LLC · Swainsboro, GABuilt 2008 · S/N 3051N342CDBlanchard Aviation LLC · Waynesboro, GABuilt 2024 · S/N 9812N342GFKites Rising LLC · Naples, FLFirst renewal noticeBuilt 2016 · S/N 4342N342SRRh Air LLC · Slinger, WIBuilt 2007 · S/N 2342N342TTLewis Charles Ryan · Napa, CABuilt 2004 · S/N 1236N343BPShelton Joseph H · Fort Worth, TXBuilt 2007 · S/N 2340N343CDMastin Air LLC · Dover, DEFirst renewal noticeBuilt 2005 · S/N 1343N343STJagc LLC · Freeport, FLBuilt 2015 · S/N 4264N3442TBoyle Ventures LLC · Rogers, ARBuilt 2010 · S/N 3710N344ARpm Aviation LLC · San Antonio, TXBuilt 2007 · S/N 2888N344CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 0156N344SKDriver Aviation LLC · Bloomfield Hills, MIBuilt 2007 · S/N 2657N345DAGrigg Apiaries Inc · Hot Springs, MTBuilt 2005 · S/N 1674N345ETKeene Warren · Post Falls, IDBuilt 2003 · S/N 0492N345JREastern Stearman Inc Trustee · Leesburg, VABuilt 2003 · S/N 0594N345TSUncle Bob Consulting LLC · Antioch, ILBuilt 2005 · S/N 1569N345WZEntroair LLC · Hilliard, OHBuilt 2021 · S/N 5028N347CDCulkin Daniel J Trustee · Edmond, OKBuilt 2005 · S/N 1360N347CPNwr Aviation LLC · Scottsdale, AZBuilt 2008 · S/N 3044N347EPEauclaire Aircrafts LLC · Weston, MAS/N 10688N347SRVenture North Aviation LLC · Cloquet, MNBuilt 2007 · S/N 2575N348CD348 Charlie Delta LLC · Ames, IABuilt 2007 · S/N 2389N348SBVector Victor Aviation LLC · Geneva, ILBuilt 2019 · S/N 4824N348TSTuchman Holdings LLC · Englewood, NJBuilt 2011 · S/N 3800N34CDCannon David A · Magnolia, TXBuilt 2002 · S/N 0148N34TGTri W Inc · Shepherd, MTBuilt 2002 · S/N 0386N34WGWings Of Grace Inc · Vonore, TNBuilt 2004 · S/N 0824N351SREagle I LLC · Kalispell, MTBuilt 2009 · S/N 3571N352KPN258wt LLC · Boca Raton, FLBuilt 2019 · S/N 4845N352MMWindmill Aviation LLC · Sleepy Hollow, NYBuilt 2021 · S/N 5096N352MRN352mr LLC · Weldona, COBuilt 2006 · S/N 1782N352RCN352rc Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0186N352SRGulf Atlantic Airways Inc · Gainesville, FLBuilt 2006 · S/N 2030N353CDSt Croix Leasing LLC · Fredonia, WIBuilt 2004 · S/N 1210N353KSReichard Leasing LLC · Harrisburg, PABuilt 2024 · S/N 10212N353PGDecarlo Rick P · Minden, NVBuilt 2004 · S/N 1115N354EMSrm Aviation Solutions LLC · Richland, WABuilt 2007 · S/N 2634N354FCBlue Sky November LLC · Mamaroneck, NYBuilt 2020 · S/N 4875N355GKAircraft Holding And Leasing LLC · Sarasota, FLBuilt 2019 · S/N 4799
Back to AD 2007-24-13