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.

N355MJHaldeman Richard C · Frisco, TXBuilt 2010 · S/N 3550N355MWCotton Aviation Enterprises Inc · Lakeway, TXBuilt 2007 · S/N 2554N355NEMeyers Air Service LLC · Superior, NEBuilt 2012 · S/N 3902N355TBravo Busters LLC · Kalispell, MTBuilt 2008 · S/N 3311N355TGHigh & Fast LLC · Batesville, ARBuilt 2006 · S/N 2158N355WTSerious Business LLC · Gregory, SDBuilt 2015 · S/N 4167N356LEFly Pharmd LLC · Valdosta, GABuilt 2007 · S/N 2652N356RKMec2 Aviation LLC · Catonsville, MDBuilt 2012 · S/N 3857N356TTMercator Aviation LLC · Orlando, FLBuilt 2020 · S/N 4971N357ERoss Modglin · Sandy Valley, NVS/N 0650N357GKGk Aviation LLC · Orlando, FLBuilt 2024 · S/N 10140N358CDOptimal Aircraft Management Mi LLC · Sanford, MIBuilt 2004 · S/N 0967N358TPCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11648N359CDKomet Israel · Midland, MIBuilt 2004 · S/N 1184N359CMCm Flyers LLC · Wayland, IABuilt 2016 · S/N 4434N359SMod Eleven LLC · Los Alamos, NMBuilt 2001 · S/N 0072N35ECKoda Bear Properties LLC · Wilmington, DEBuilt 2004 · S/N 0883N35FDCirrus Design Corp · Duluth, MNS/N 11835N35GMSt Cloud Flying Club LLC · Saint Cloud, MNBuilt 2003 · S/N 0478N35XPFletcher Lance · Germantown, OHBuilt 2011 · S/N 3716N360CWassup Homes LLC · Wilmington, DEBuilt 2007 · S/N 2562N360CD360cd LLC · Eagle, IDBuilt 2009 · S/N 3516N360LVJb Acquisitions LLC · Gonzales, LABuilt 2008 · S/N 3272N360WLLaughlin Linda · Bluff Dale, TXBuilt 2002 · S/N 0216N361JBCarroll Farm Management Company · Carthage, ILBuilt 2005 · S/N 1253N361KMMclain Kevin A · Stoddard, WIBuilt 2015 · S/N 4212N361TA466m LLC · Evansville, INBuilt 2008 · S/N 3325N362CDBmg Adventures LLC · Decatur, TXBuilt 2005 · S/N 1392N362CPLare Robert W Jr · Shreveport, LABuilt 2008 · S/N 3048N362MDJj Hughes Logistics LLC · Canyon, TXBuilt 2014 · S/N 4126N362SRAviation Guys LLC · Charleston, WVBuilt 2006 · S/N 1999N363CTAlpha Mike Aviation LLC · Lakeville, MNBuilt 2015 · S/N 4232N363KKFisher David J · La Conner, WABuilt 2009 · S/N 3379N363PMFlying Luvbug LLC · Grafton, WIS/N 4368N363SCOcm Aviation LLC · Buckeye, AZBuilt 2004 · S/N 1209N363SRJolly Raymond V · Hillsborough, NJBuilt 2006 · S/N 2226N365AFFna Aviation LLC · Wakefield, MABuilt 2022 · S/N 8910N365JPFlycirrus LLC · Clermont, FLBuilt 2008 · S/N 3010N365KAWorker Bees LLC · Kaukauna, WIS/N 3381N365MBAmg Aviation LLC · Marlton, NJBuilt 2016 · S/N 4349N365PMValiair Lc Trustee · Casper, WYBuilt 2008 · S/N 3081N365TGSuperior Transportation LLC · Belcamp, MDBuilt 2022 · S/N 8618N365WDIsaiah4031 LLC · Santa Rosa Beach, FLBuilt 2014 · S/N 4042N366CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1369N366CPSnsg Properties LLC · Virginia Beach, VABuilt 2008 · S/N 3049N366DMSwaggart Paul Blake · Touchet, WABuilt 2005 · S/N 1625N366LDHorizon Aviation LLC · Johnson City, TNBuilt 2019 · S/N 4792N367BMWilliams Richard · Atlanta, GABuilt 2005 · S/N 1647N367CPKafil Jason · Covina, CABuilt 2008 · S/N 3050N367HMCoastal Streets LLC · Marblehead, MABuilt 2015 · S/N 4210
Back to AD 2007-24-13