OpenAirDocs.org
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.

N170DLRlw 767 LLC · Lighthouse Point, FLBuilt 2006 · S/N 2017N170EJZirkel Acquisition Corp LLC · Colchester, VTBuilt 2010 · S/N 3604N170SGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2014 · S/N 4122N170SRSj Airways LLC · Wilmington, DEBuilt 2007 · S/N 2456N17113J&L Aviation LLC · Lakewood Ranch, FLBuilt 2012 · S/N 3851N171HTChico Gregory John · Dayton, NVBuilt 2005 · S/N 1613N171MAChute First LLC · Covina, CABuilt 2005 · S/N 1398N171SRRegistered aircraftS/N 2422N171TDFh Consulting LLC · Christiana, TNBuilt 2020 · S/N 4973N171TSWindow Universe LLC · Beaverton, ORBuilt 2008 · S/N 2900N171VTShly Aviation LLC · Carnegie, PABuilt 2002 · S/N 0142N1724XN2200b LLC · Cicero, NYBuilt 2014 · S/N 4090N173CBAircraft Associates LLC · Valparaiso, INBuilt 2006 · S/N 1877N173KHD & B Management LLC · Clayton, GABuilt 2004 · S/N 1191N173SRRomeo Pappa LLC · Midlothian, TXBuilt 2006 · S/N 1925N174DLHubbard James E · Bessemer, MIBuilt 2007 · S/N 2437N174YMSch Aviation Inc Trustee · Sporle Kings LynnBuilt 2010 · S/N 3644N175DSSkyfall Aviation LLC · Maryville, TNBuilt 2024 · S/N 10257N175DYFirst Tracks Aviation LLC · Lewes, DEBuilt 2010 · S/N 3608N175MHCharlie Michaels LLC · Helena, MTBuilt 2023 · S/N 9467N175USAtlas Property Management LLC · Broken Arrow, OKS/N 0570N176CFMbg Capital Holdings LLC · West Des Moines, IAS/N 3757N176PSJr Barragan Inc · Chowchilla, CABuilt 2006 · S/N 2249N1776MBidfish Ventures LLC · Harrisonburg, VABuilt 2005 · S/N 1394N177PTJohn Walter Finley · Mcconnelsville, OHBuilt 2007 · S/N 2861N1783JReady Air Inc · Bellevue, WABuilt 2008 · S/N 3293N17JGSkyward Holdings Inc · Miami Beach, FLBuilt 2019 · S/N 4771N17KEYanity Nicholas A · Woodinville, WABuilt 2005 · S/N 1358N17SNWindspeed LLC · Amarillo, TXBuilt 2001 · S/N 0115N17UKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 0200N180BZFlying Red Birds LLC · Framingham, MABuilt 2003 · S/N 0714N181JWSkyhaven Aviation LLC · Steamboat Springs, COBuilt 2009 · S/N 3591N181MCTf1 LLC · Pittsford, NYBuilt 2018 · S/N 4720N181WTMeadows Robert K · Macon, GABuilt 2003 · S/N 0638N183BMAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 2014 · S/N 4080N183CDRegistered aircraftBuilt 2004 · S/N 0921N183VGriffiths Aero LLC · Centerville, OHBuilt 2008 · S/N 3125N184KTDsm Asset Management LLC · Fort Worth, TXBuilt 2003 · S/N 0477N184PKChucks Transport LLC · Kalispell, MTBuilt 2007 · S/N 2802N1856TCohan Peter E · Trinidad, CABuilt 2015 · S/N 4279N1862BLow Key Aero LLC · Laingsburg, MIBuilt 2011 · S/N 3753N186CKPuckett David Bryan · Ellensburg, WABuilt 2009 · S/N 3441N187AJAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2016 · S/N 4356N187SRSpirit Property Development LLC · Addison, TXBuilt 2006 · S/N 1950N1880E L I Land Design LLC · Montgomery, TXBuilt 2001 · S/N 0110N188CTPlane Fun Inc Tr Trustee · Snellville, GAS/N 2983N188GMckee Kent M Trustee · Varna, ILS/N 3102N188MAAviation Leasing LLC · Erie, COBuilt 2008 · S/N 3096N18916Valiair Lc Trustee · Casper, WYBuilt 2006 · S/N 2075N189FGAerotech Coatings LLC · Arlington, WABuilt 2016 · S/N 4378
Back to AD 2007-24-13