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.

N54105Gopub Aviation Inc Trustee · Wilmington, DEBuilt 2004 · S/N 1139N54175Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1337N5419WKenosha Aviation LLC · Jacksonville, FLS/N 0857N541CDAcheson Wiliam B · Waconia, MNBuilt 2005 · S/N 1491N541DFSr20 Holdings LLC · Coral Springs, FLBuilt 2025 · S/N 10869N541JDBlue Sky Flyers LLC · Hoover, ALBuilt 2002 · S/N 0315N541SRSierom LLC · Charlotte, NCS/N 2109N541WPStorzer Daniel Norman · Neenah, WIS/N 1931N542AMSolid Rock Stone Inc · Shady Point, OKBuilt 2007 · S/N 2666N542CDStorch David · Goodyear, AZBuilt 2004 · S/N 1186N542PFKittyhog Air LLC · Margate, FLBuilt 2008 · S/N 3144N542PGMountain Airplane LLC · Alpine, WYBuilt 2008 · S/N 3002N542SFNoble Aviators LLC · Myrtle Beach, SCBuilt 2017 · S/N 4439N542SRAlliance Solutions Group Inc · Yorktown, VABuilt 2006 · S/N 2213N543FCGraytail Vision LLC · Dallas, TXBuilt 2025 · S/N 10794N543GWBrown Gregory L · Argyle, TXBuilt 2014 · S/N 4102N543LKKilolima3 LLC · Washington, DCBuilt 2021 · S/N 5058N543MWWood Martin J · Ramona, CABuilt 2019 · S/N 4767N543SKGreene Scott P · El Paso, TXBuilt 2004 · S/N 1213N544CDAeroplanes LLC · Cary, NCBuilt 2005 · S/N 1544N545CBRegistered aircraftBuilt 2006 · S/N 2134N545CDValiair Lc Trustee · Casper, WYBuilt 2005 · S/N 1508N545CP545 Charlie Papa LLC · Colorado Springs, COBuilt 2005 · S/N 1462N545PMPerseverance Enterprises LLC · Sitka, AKBuilt 2010 · S/N 3703N545WTBuilding Restoration Corp · Roseville, MNBuilt 2009 · S/N 3422N546CDScalini Fernando A · Huntington Beach, CABuilt 2005 · S/N 1627N546KMAero Montana LLC · Greensboro, GABuilt 2008 · S/N 3262N547CHoch Jeffrey · Seattle, WABuilt 2003 · S/N 0484N547DTMcb Family Aviation LLC · Boca Raton, FLBuilt 2024 · S/N 10368N547SMTrinity Aviation LLC · Rome, GAS/N 1828N548CPF Partnoy Inc · San Diego, CABuilt 2008 · S/N 3329N548EBRomeo Charlie Aircraft Partners LLC · North Little Rock, ARS/N 0291N548RESabair LLC · Clinton, PABuilt 2025 · S/N 10969N549CDValiair Limited Co Trustee · Casper, WYBuilt 2004 · S/N 1088N549SRPlane Fun Flying Club · Vancouver, WABuilt 2006 · S/N 2177N54KYGael Aviation Inc · West Harrison, NYBuilt 2015 · S/N 4207N54LGSynergy Wellness Group Inc · Bakersfield, CABuilt 2007 · S/N 2685N54LWDogtown Aviation LLC · Teton Village, WYBuilt 2007 · S/N 2407N54VL4791 Capital Holdings LLC · Austin, TXS/N 4791N54WFMajmudar Krupal · Flemington, NJBuilt 2017 · S/N 4506N550CDCoen Scott D · Kingsport, TNBuilt 2004 · S/N 1124N550RGBr Ventures LLC · Port Orange, FLBuilt 2005 · S/N 1635N551ATCorellian Spacecraft LLC · Leesburg, VABuilt 2021 · S/N 5149N551BPPalmer John Michael · Saint Louis, MOBuilt 2007 · S/N 2876N551CDBwr Group LLC · Hobbs, NMBuilt 2005 · S/N 1550N551SGAviation Module LLC · Los Angeles, CABuilt 2017 · S/N 4562N551SRN551sr Aviation LLC · Roswell, GABuilt 2006 · S/N 2126N552CDDirect Internet Inc · Harsens Islands, MIS/N 0922N552FSSciortino Frank M · Oswego, NYBuilt 2023 · S/N 9552N552SRGenung Tobin J · Ocala, FLBuilt 2007 · S/N 2278
Back to AD 2007-24-13