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.

N769LSFlystar LLC · Tampa, FLBuilt 2006 · S/N 40.663N770RSPlesant Maurice P · El Paso, TXBuilt 2002 · S/N 40.240N777YHCombined Air Ventures LLC · Avon Park, FLS/N 40.451N777ZV777 Aviation LLC · Bedford, MABuilt 2004 · S/N 40.364N777ZWSky Safety Inc · San Antonio, TXBuilt 2004 · S/N 40.366N778DSGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2006 · S/N 40.678N779USUtah Valley University · Orem, UTBuilt 2007 · S/N 40.779N786AMCenter For Healthcare Education Inc · Riverside, CAS/N 40.726N787DMWingsleasing LLC · Wichita, KSBuilt 2008 · S/N 40.993N787ECSky Safety Inc · San Antonio, TXBuilt 2005 · S/N 40.529N787PVPatterson Douglas · Oakland, CABuilt 2007 · S/N 40.695N789DAKlimach Waldemar · Kingman, AZBuilt 2007 · S/N 40.789N789VVReeder Paul A · Weston, MABuilt 2005 · S/N 40.532N78USUtah State University · Logan, UTBuilt 2020 · S/N 40.1219N791PSTake Flight Aviation LLC · Montgomery, NYBuilt 2007 · S/N 40.791N793USUtah Valley University · Orem, UTS/N 40.793N797AMBarren Aviation LLC · Glasgow, KYBuilt 2006 · S/N 40.717N797RSGinier Bruce L · Fresno, CABuilt 2009 · S/N 40.1029N798DSWindemere Group LLC · Redwood City, CABuilt 2007 · S/N 40.798N799DSValiair Limited Co Trustee · Casper, WYBuilt 2007 · S/N 40.799N79USUtah State University · Logan, UTBuilt 2020 · S/N 40.1220N7KPSky Safety Inc · San Antonio, TXBuilt 2005 · S/N 40.530N802ERValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 40.306N803ERBenson Catrina D · Palmdale, CABuilt 2003 · S/N 40.307N804ERDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2003 · S/N 40.311N806ERDiamond Aircraft Sales Of Kentucy LLC · Henderson, KYBuilt 2003 · S/N 40.317N808ERDurcan David · Kingston, NYBuilt 2003 · S/N 40.319N808ETJust Plane People LLC · Irvine, CABuilt 2007 · S/N 40.808N809AMWelbourn Farms Inc · Union City, OHBuilt 2007 · S/N 40.809N811ETGroup Five 24 LLC · Corvallis, ORBuilt 2007 · S/N 40.874N815DSFlt Academy · Woods Cross, UTBuilt 2007 · S/N 40.815N81DSMarathon Leasing Inc · Elyria, OHBuilt 2004 · S/N 40.406N820AMWolsey Gilman T · Scottsdale, AZBuilt 2007 · S/N 40.880N820DSTino Equipment LLC · Salisbury, NCBuilt 2007 · S/N 40.893N821LGKaufman Matthew Todd · Bonny Doon, CABuilt 2007 · S/N 40.816N821TColquhoun Steven · North Augusta, SCBuilt 2012 · S/N 40.1154N823YTSolo Skies Aviation LLC · Missoula, MTBuilt 2005 · S/N 40.555N824USLightyear Aviation LLC · Chicago, ILBuilt 2007 · S/N 40.824N825USTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2007 · S/N 40.825N829DSSuperfortress LLC · Hampstead, NCBuilt 2007 · S/N 40.849N830BSShortt Aircraft Leasing LLC · Wilmington, DEBuilt 2004 · S/N 40.395N831BAIntered North LLC · Eagle, IDBuilt 2007 · S/N 40.876N831JLUtah State University · Logan, UTBuilt 2008 · S/N 40.939N833DSIndiana State University · Terre Haute, INBuilt 2011 · S/N 40.1110N834DSWimmer Abran A · South Salt Lake, UTBuilt 2001 · S/N 40034N834KCEcho Papa Aviation LLC · Knoxville, TNBuilt 2007 · S/N 40.834N835DSFederal Service Corp · Bay Minette, ALBuilt 2001 · S/N 40035N836DSLima Hotel Aviation LLC · Mooresville, NCBuilt 2005 · S/N 40.500N837DSLyons Brent · Saint Cloud, FLBuilt 2004 · S/N 40.437N840ABDiamond Group Holdings LLC · Greenville, NCBuilt 2005 · S/N 40.478
Back to AD 2007-11-21