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.

N432SCChalfin Steven · San Antonio, TXBuilt 2001 · S/N 40049N433DSRnp Capital Holdings LLC · Corpus Christi, TXBuilt 2001 · S/N 40033N437MAHartman David Stephen · Mills River, NCBuilt 2004 · S/N 40.401N439CALima Delta Co Trustee · New Castle, DEBuilt 2008 · S/N 40.907N43LMHorton Scott · Yorba Linda, CABuilt 2009 · S/N 40.1047N43SEAir Zamunda LLC · Rutherford, NJBuilt 2003 · S/N 40.313N440JPBernstein Robert L Trustee · La Jolla, CABuilt 2002 · S/N 40.233N441RAPacific Coast University LLC · Ojai, CABuilt 2008 · S/N 40.916N442ZCowan Holdings Management LLC · Gaylord, MIBuilt 2011 · S/N 40.1124N446DBJhc Airplane LLC · Palo Alto, CAS/N 40.273N446DCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 40.446N446DSFun Air LLC · Houston, TXBuilt 2002 · S/N 40.246N446SBIll Fly Away LLC · Goshen, INBuilt 2005 · S/N 40.488N447DSAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N 40.417N448USUtah State University · Logan, UTBuilt 2006 · S/N 40.708N449JLAir Jockey LLC · Orange, VABuilt 2007 · S/N 40.778N451DSUtah State University · Logan, UTBuilt 2012 · S/N 40.1136N451GLMaple Mountain Aircraft Leasing LLC · Payson, UTBuilt 2012 · S/N 40.1151N453DS453ds Aircraft Leasing LLC · Spanish Fork, UTBuilt 2011 · S/N 40.1123N456ASGutman Daniel W · North Andover, MABuilt 2004 · S/N 40.456N457HRSummit Aviation Inc · Belgrade, MTBuilt 2006 · S/N 40.700N457TLSkywest Leasing Inc · St George, UTBuilt 2005 · S/N 40.572N458DSRao Dinesh · Ocala, FLS/N 40.1144N461DSHussey Neil A · Alton, NHBuilt 2007 · S/N 40.761N462THIndiana State University · Terre Haute, INBuilt 2009 · S/N 40.1056N463THIndiana State University · Terre Haute, INBuilt 2009 · S/N 40.1058N464DSGreat Lakes Industrial Contracting Ltd · Maumee, OHBuilt 2012 · S/N 40.1167N464THIndiana State University · Terre Haute, INBuilt 2009 · S/N 40.1052N465DSMaxbay Aviation Corp · Chester, VABuilt 2012 · S/N 40.1165N465THIndiana State University · Terre Haute, INBuilt 2007 · S/N 40.879N466PSResidential Engineering Services LLC · Lees Summit, MOS/N 40.464N467DSFlown Coastal LLC · San Antonio, TXBuilt 2012 · S/N 40.1159N468MASky Safety Inc · San Antonio, TXBuilt 2005 · S/N 40.547N469JPAlmaz LLC · Pacific Palisades, CABuilt 2005 · S/N 40.469N470DSDowning Ridge Flying Club LLC · Coshocton, OHBuilt 2006 · S/N 40.670N472DSIndigo Skies LLC · Rome, GABuilt 2012 · S/N 40.1168N472PAHornsby Larry G DBA · Moody, ALBuilt 2005 · S/N 40.472N473DSAcanthis Aviation LLC · Franklin, MABuilt 2012 · S/N 40.1171N475PSInosculation 2 LLC · Summerville, SCBuilt 2005 · S/N 40.475N476DSDt Aviation LLC · Loveland, COBuilt 2012 · S/N 40.1160N476PSWingman Aviation LLC · King William, VABuilt 2005 · S/N 40.476N478DSChucktown Flight Training LLC DBA · Summerville, SCBuilt 2012 · S/N 40.1169N479DS7911 Airways LLC · Philadelphia, PABuilt 2013 · S/N 40.1189N480JPWells Vance · Battle Ground, WABuilt 2003 · S/N 40.280N481PARegistered aircraftS/N 40.1091N482MAHappy Landings LLC · Wake Forest, NCBuilt 2005 · S/N 40.552N489RSViage LLC · Boston, MABuilt 2004 · S/N 40.379N489YJoa Aviation LLC · Spokane, WABuilt 2007 · S/N 40.894N491TCWingsleasing LLC · Wichita, KSBuilt 2008 · S/N 40.914N492DSSkywest Leasing Inc · St George, UTBuilt 2005 · S/N 40.504
Back to AD 2007-11-21