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.

N229RMMjt Real Estate Holdings LLC · Orlando, FLBuilt 2002 · S/N 0416N229SG229sc LLC · Fayetteville, GABuilt 2006 · S/N 1956N22ADMorganav Inc · Chapel Hill, NCBuilt 2018 · S/N 4641N22AYRegistration Pending · Lebanon, PARegistration pendingBuilt 2004 · S/N 1176N22CE0 To 100 Aviation LLC · Palmetto Bay, FLBuilt 2020 · S/N 4918N22CYHughes Jason David · Hickory, NCBuilt 2008 · S/N 3085N22DBSalisbury Mark J · Green Cove Springs, FLBuilt 2002 · S/N 0205N22DMM1 Aviation LLC · Trenton, NJFirst renewal noticeBuilt 2007 · S/N 2886N22EGEsm Aviation LLC · Pomona, NYBuilt 2006 · S/N 2234N22FARosen Barry W · West Hollywood, CABuilt 2003 · S/N 0782N22GXKiser Raymond Paul · Sebring, FLBuilt 2004 · S/N 0980N22KHTrue Aviation LLC · Charlottesville, VABuilt 2002 · S/N 0198N22VCVictorcharlie LLC · Weston, MABuilt 2005 · S/N 1341N22VGGreenway Group LLC · Suwanee, GAS/N 0459N22WEWings Over Saluda Institute LLC · Wilmington, DEBuilt 2022 · S/N 9023N22WXCisneros Corina · Belmont, NHBuilt 2002 · S/N 0281N22XDNokes James · Woodbury, TNBuilt 2003 · S/N 0531N22XJSmile Air LLC · Vidalia, GABuilt 2012 · S/N 3835N22ZFEastern Stearman Inc Trustee · Leesburg, VABuilt 2006 · S/N 1902N22ZMAbkw Air Sunshine LLC · Wilmington, DEBuilt 2007 · S/N 2684N230CARinehart Investment Group LLC · Forest Lake, MNBuilt 2011 · S/N 3821N230EValiair Ltd Co Trustee · Casper, WYS/N 9522N230SRNational Auto Solutions LLC · Gallatin, TNBuilt 2007 · S/N 2361N230WJCenter Ice Scouting LLC · Crestwood, KYBuilt 2007 · S/N 2539N231LLTen-Xray LLC · Woodside, NYBuilt 2002 · S/N 0199N231WMA Davtian M D Medical Services Inc DBA · Glendale, CAS/N 0900N232CDNew Paul · Jackson, TNBuilt 2002 · S/N 0187N232FJConstruct Air LLC · Osage Beach, MOBuilt 2002 · S/N 0338N232MMBuilder Tony Hirst LLC · Kittrell, NCBuilt 2006 · S/N 2302N232SRRegistration Pending · Vandalia, OHRegistration pendingBuilt 2006 · S/N 1990N233LSSelznick Larry Trustee · Stevenson Ranch, CABuilt 2004 · S/N 0885N233MMHigh Way LLC · Wilmington, DEBuilt 2017 · S/N 4445N233NCEnergyview LLC · Tioga, NDBuilt 2012 · S/N 3905N233SBC2c LLC · Hamilton, MTBuilt 2002 · S/N 0242N233SROharra Robert J · Buckley, WAS/N 2185N233WZInduction Aviation LLC · Lewes, DEBuilt 2006 · S/N 1752N234AKKihneman David J · Spring, TXBuilt 2007 · S/N 2878N234BJJmc Commercial Contractors LLC · Porter, TXBuilt 2007 · S/N 2541N234CWWright Caleb · Douglas, GABuilt 2015 · S/N 4261N234CZBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 2548N234DPConnect 4 Ventures LLC · Woodberry Forest, VABuilt 2024 · S/N 10214N234ETAir Fergie LLC · Camden, DEBuilt 2026 · S/N 11257N234HKExplore Aviation LLC · Santa Barbara, CABuilt 2006 · S/N 1746N234JFaliero Bryan K · Greenville, SCBuilt 2025 · S/N 10754N234LBCirrus Design Corp · Duluth, MNS/N 11828N234PDAccurite Machine & Manufacturing Inc · Louisville, KYBuilt 2004 · S/N 1167N234PGSpeer Aircraft LLC · Evansville, INBuilt 2004 · S/N 0935N234XLCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11503N235SKInde Aviation LLC · Chesterfield, VABuilt 2023 · S/N 9372N236DCGilbert Gerald · Falls Church, VABuilt 2012 · S/N 3836
Back to AD 2007-24-13