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.

N496CJPurview LLC · Brownsburg, INBuilt 2025 · S/N 10918N496CPSportmed Outreach Air LLC · Gulf Breeze, FLBuilt 2008 · S/N 3314N496GRRegistered aircraftBuilt 2019 · S/N 4779N4971Osborne Scott M · Fort Myers, FLBuilt 2015 · S/N 4174N497CPGulfstream Turbine LLC · Naples, FLBuilt 2008 · S/N 3315N497TZLightspeed Aviation LLC · Lutz, FLBuilt 2022 · S/N 8773N498BCOutside In Aviation LLC · Fort Madison, IABuilt 2015 · S/N 4268N498CDCrew Zen Aviation LLC · Fort Smith, ARBuilt 2005 · S/N 1549N498DDCambridge Industries LLC · Rehoboth, MABuilt 2020 · S/N 4910N498GNChb Aw LLC · Amarillo, TXBuilt 2007 · S/N 2587N498SRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2006 · S/N 2081N498TTMiddletown Composites Inc · Berea, KYBuilt 2015 · S/N 4239N499RJNd-Pace Logistics LLC · Sneads Ferry, NCBuilt 2009 · S/N 3588N499VAIdeker Inc · Saint Joseph, MOBuilt 2006 · S/N 1921N49CEIttf LLC · Fort Lauderdale, FLBuilt 2017 · S/N 4504N49DACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11555N49EDOak Country Air LLC · Laguna Beach, CABuilt 2016 · S/N 4388N49PXN49px Group LLC · West Jordan, UTBuilt 2009 · S/N 3570N49WFTech Air Systems LLC · Apollo Beach, FLBuilt 2007 · S/N 2610N4GHDouble Bridges Aviation LLC · Luxora, ARBuilt 2013 · S/N 3941N4KWFly Aero LLC · Missoula, MTBuilt 2016 · S/N 4352N4ZYValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 1502N5000CFly Right LLC · Burlington, WIBuilt 2004 · S/N 0803N5009UOrca Flight LLC · Keaau, HIBuilt 2004 · S/N 0847N500CPEcho Acquisitions LLC · Dover, DEBuilt 2007 · S/N 2636N500HBN500hb LLC · Branchville, NJBuilt 2006 · S/N 1745N500RCWright Mason · Henderson, NVBuilt 2005 · S/N 1680N501CGCirrus Flyers LLC · Gilbert, AZBuilt 2016 · S/N 4358N501NANasa Langley Research Center · Hampton, VABuilt 2001 · S/N 0012N501PTJe Air 2 Corp · Wilmington, DEBuilt 2014 · S/N 4076N501PXMo Flying LLC · Fredericktown, OHBuilt 2016 · S/N 4313N5023FCharlie Tango Enterprises LLC · Newport Beach, CABuilt 2004 · S/N 0842N502BZBirchfield Randy R · Wakeman, OHBuilt 2005 · S/N 1485N502CDQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1149N502SRRegistered aircraftBuilt 2007 · S/N 2460N5030SPolaris Fire Protection Inc · Fernandina Beach, FLBuilt 2004 · S/N 0827N503BNAllegrezza Fred · Line Lexington, PABuilt 2005 · S/N 1276N503CDLagade Marco C · Lake Mary, FLBuilt 2004 · S/N 0909N503SMTyler Lauren M · Ticonderoga, NYBuilt 2022 · S/N 8791N503WKAnimal Aviation LLC · Nashville, TNBuilt 2020 · S/N 4980N504CSBeach Cruiser Express LLC · Hummelstown, PABuilt 2014 · S/N 4131N504FPBaumgarten Jeffrey A · New Orleans, LABuilt 2004 · S/N 1192N504LMLucky H Farms Inc · Mesa, WABuilt 2008 · S/N 2912N504PGHlm Partners LLC · Grosse Pt Shr, MIBuilt 2008 · S/N 3014N5050GHats Off Aviation LLC · Newnan, GABuilt 2004 · S/N 0833N5050MMarijune Aviation LLC · Lakeland, FLBuilt 2016 · S/N 4326N505ARDoss Justin · Beaumont, TXBuilt 2007 · S/N 2798N505CDValiair Limited Company Owner Trustee · Casper, WYBuilt 2002 · S/N 0323N505MAMonmouth Aviation LLC · Sea Girt, NJBuilt 2026 · S/N 11201N505PGNorthern Minnesota Group LLC · Baxter, MNS/N 3016
Back to AD 2007-24-13