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.

N224RTIronwood Aviation LLC · Boerne, TXBuilt 2008 · S/N 3268N224RWNomad Air LLC · North Bend, WABuilt 2005 · S/N 1595N224SJPrestige Aircraft LLC · Madison, WIBuilt 2003 · S/N 0705N224SRRaffo Christopher Stephen · Potomac, MDBuilt 2006 · S/N 2172N224STB & G Aviation Enterprises LLC · Lilburn, GABuilt 2004 · S/N 0882N224SYMrc1 LLC · Bernie, MOBuilt 2002 · S/N 0184N224TGPlaneview LLC · Fountain Hills, AZBuilt 2005 · S/N 1570N224UQue Estaran Haciendo LLC · North Miami, FLBuilt 2008 · S/N 3129N224WTSkizer Inc · Marina Del Rey, CABuilt 2006 · S/N 1947N224YBFly Robin Fly LLC · Marietta, GABuilt 2025 · S/N 11048N225CDCirrus Design Corp · Duluth, MNS/N 11631N225FSmall Inc · Senath, MOBuilt 2016 · S/N 4330N225FDHoldings Excellence LLC · Frostproof, FLBuilt 2023 · S/N 9167N225PETspy Services Inc · Wilmington, DES/N 4286N225RLReeves Kyle · Newport Beach, CAS/N 2981N225TLChute Happens LLC · Annandale, VABuilt 2017 · S/N 4478N225TNA C Leonard LLC · Missoula, MTBuilt 2008 · S/N 3108N225VTSls Travel LLC · Missoula, MTBuilt 2017 · S/N 4448N2268MMorgan Kinder LLC · Friendswood, TXBuilt 2003 · S/N 0642N226BBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2009 · S/N 3426N226BCBrown John D · Parkersburg, WVBuilt 2006 · S/N 1826N226BGMahoney Timothy P · Nantucket, MABuilt 2004 · S/N 0837N226CFWendler William F II · Bridgton, MEBuilt 2021 · S/N 4994N226CHDraper Michael John · Chenoa, ILBuilt 2004 · S/N 0875N226FDBlue Mountain Aviation LLC · Newark, DEBuilt 2023 · S/N 9105N226JHAmeritech Flight Services LLC · Hummelstown, PABuilt 2009 · S/N 3443N226KBBex Investments LLC · Oklahoma City, OKS/N 4746N226RHHarding Christopher · Houston, TXBuilt 2006 · S/N 2290N226SRDairyaire LLC · Brookfield, WIBuilt 2023 · S/N 9179N226TWBb Aviation LLC · Louisville, KYBuilt 2019 · S/N 4837N226TXGriffin Christopher W · Blowing Rock, NCBuilt 2009 · S/N 3390N226XYTar Aviation LLC · Akron, IABuilt 2003 · S/N 0486N2277CC4 Holdings Group LLC · Odessa, FLBuilt 2026 · S/N 11434N227BDBlack Dog Aviation LLC · Avon, MNBuilt 2008 · S/N 3134N227DZAd Holdings Group Inc · Wilmington, DEBuilt 2008 · S/N 3288N227FDSpettro Air LLC · Monroe, LABuilt 2023 · S/N 9113N227HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2009 · S/N 3438N227JHRgs Aviation LLC · Lexington, KYBuilt 2015 · S/N 4237N227KCSeven Kilo Charlie LLC · Lawrence, KSBuilt 2021 · S/N 5012N227MPGo Raleigh Aviation LLC · Cary, NCBuilt 2014 · S/N 4141N227PGDiederich Drone Service LLC · Fargo, NDBuilt 2010 · S/N 3675N227RTBarnard David W · La Follette, TNBuilt 2007 · S/N 2357N227SPIowa State Patrol · Des Moines, IABuilt 2021 · S/N 5050N227WBSlamo LLC · Bulverde, TXBuilt 2017 · S/N 4523N2288DTen Equipment LLC · Boston, MABuilt 2011 · S/N 3761N228CFAsterix Aviation Inc · New York, NYBuilt 2021 · S/N 5007N228FD228 Properties LLC · Tabernacle, NJBuilt 2023 · S/N 9115N228MMFly Enterprises LLC · Cumberland, WIBuilt 2005 · S/N 1335N229DTEyes In The Skies LLC · Oklahoma City, OKBuilt 2012 · S/N 3850N229FSmith Dennis L · Burbank, CABuilt 2006 · S/N 2299
Back to AD 2007-24-13