OpenAirDocs.org
AD 2007-11-21

Registered aircraft · 702

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-11-21')
    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-11-21')
  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.

N904AZWingsleasing LLC · Wichita, KSBuilt 2008 · S/N 40.920N905AMSkyline Aviation Inc · San Angelo, TXBuilt 2006 · S/N 40.705N905CAVolair Aviation LLC · Waxhaw, NCBuilt 2007 · S/N 40.795N905PARamsey Scott A · Houston, TXBuilt 2008 · S/N 40.905N906PATeton Avjet LLC · Driggs, IDBuilt 2008 · S/N 40.906N908AZWingsleasing LLC · Wichita, KSS/N 40.388N908DSSantihoy LLC · Yonkers, NYBuilt 2008 · S/N 40.975N909AZN909az LLC · Miami, FLBuilt 2003 · S/N 40.318N910BBCoughlin Daniel F · Frederiksted, VIBuilt 2008 · S/N 40.910N911KTStar-Aveo Inc Trustee · Wilmington, DEBuilt 2007 · S/N 40.787N914USWingsleasing LLC · Wichita, KSBuilt 2008 · S/N 40.904N917USRed Hill Aviation LLC · North Garden, VABuilt 2008 · S/N 40.917N91GCSilver Bear Transport LLC · Santa Ana, CABuilt 2011 · S/N 40.1128N91LCBowersox Kenneth D · Houston, TXBuilt 2005 · S/N 40.FC002N923DSExecu-Air LLC · Apopka, FLS/N 40.979N924DSSanta Barbara Aviators LLC · Santa Barbara, CABuilt 2002 · S/N 40.224N925DSStarlight Technology Transfer Inc · Leesburg, VABuilt 2002 · S/N 40.225N925RHVan Belle Christopher J · San Diego, CABuilt 2002 · S/N 40.212N925YHPlane Fun Inc Tr Trustee · Snellville, GABuilt 2008 · S/N 40.925N933DSDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2003 · S/N 40.327N935AZN935az LLC · Miami, FLBuilt 2003 · S/N 40.320N937DSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 40.992N945PCErdman Aviation LLC · Mather, CABuilt 2008 · S/N 40.945N945TLShirley Mae LLC · Franklin, MIBuilt 2004 · S/N 40.413N946DSErickson Merton H · Port Orange, FLBuilt 2008 · S/N 40.984N946USSweet Aviation LLC · Fort Wayne, INBuilt 2008 · S/N 40.946N947USOperation No Person Left Behind Outdoors Inc · Libertytown, MDBuilt 2008 · S/N 40.947N949KCParamus Flying Club Inc · Fairfield, NJBuilt 2008 · S/N 40.949N950MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2023 · S/N 40.1241N951MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2023 · S/N 40.1242N953MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2022 · S/N 40.1234N954MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2022 · S/N 40.1235N955DSTalluto Mark A · Temecula, CABuilt 2008 · S/N 40.950N955MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2022 · S/N 40.1236N956JBJ Robb Consulting LLC · Scottsdale, AZBuilt 2004 · S/N 40.390N956MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2022 · S/N 40.1237N957MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2023 · S/N 40.1239N958MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2023 · S/N 40.1240N966DSN966ds Inc Trustee · Wilmington, DEBuilt 2008 · S/N 40.1002N969GLHooker Troy E · Hines, ORBuilt 2010 · S/N 40.1069N96DSAldea Da40 LLC · Summerville, SCBuilt 2010 · S/N 40.1096N970DSAirsaf LLC · Falls Church, VABuilt 2008 · S/N 40.928N97111Plane & Simple LLC · Aurora, OHBuilt 2012 · S/N 40.1166N971DSGville Flyers I LLC · Gainesville, FLS/N 40.671N971RDMouton Chad A · Houston, TXBuilt 2005 · S/N 40.508N975DSJpm Aviation LLC · Irvine, CABuilt 2009 · S/N 40.1065N97CFMidwest Avtech Inc · Peru, ILBuilt 2003 · S/N 40.334N980DSOzark Nuts & Trading Co · Dublin, NCBuilt 2010 · S/N 40.1080N984ESBmc Aviators LLC · Erie, COBuilt 2007 · S/N 40.827N989MAButler Holdings · Franklin, TNS/N 40.389
Back to AD 2007-11-21