AD 2000-08-07

Registered aircraft · 369

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:2000-08-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-08-07')
  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.

N800SEDodson International Parts Inc · Rantoul, KSS/N NA0425N800SVAircraft Fidelity Corp Trustee · Dover, DES/N NA0470N800THHoover Aviation LLC · Nashville, TNBuilt 2004 · S/N 258678N800TLN800tl LLC · Wilmington, DEBuilt 1998 · S/N 258394N800UKJ W Construction Co Inc · Wise, VABuilt 2002 · S/N 258577N800UWUniform Whiskey Holdings LLC · Opa Locka, FLBuilt 1998 · S/N 258395N800VRCkv Express LLC · Minneapolis, MNBuilt 1984 · S/N 258016N800WAKmwflight LLC · Wilmington, DEBuilt 1988 · S/N NA0414N800WFVarsity Aviation LLC · Martinsburg, PABuilt 2005 · S/N 258728N800WHGsmh LLC · Daniel Island, SCS/N 258080N800WWPnw Transport LLC · Tucson, AZBuilt 2004 · S/N 258661N800XMFlyteme Aviation LLC · Fort Pierce, FLBuilt 1999 · S/N 258414N800XRSparks Aviation Ownership LLC · Santa Rosa Beach, FLBuilt 1995 · S/N 258283N801LMGlobal Aircraft Solutions LLC Trustee · San Antonio, TXBuilt 1988 · S/N NA0409N801PJGovoa LLC · Miami Beach, FLBuilt 1990 · S/N NA0456N801RMBlue Skies Hawker LLC · Canton, MIBuilt 1984 · S/N 258011N802CFLitton Global LLC · Wilmington, DEBuilt 1999 · S/N 258425N802WJXoom Enterprises LLC · Sunny Isles Beach, FLBuilt 1984 · S/N 258008N803RKAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 258003N804BHMahaska Bottling Co · Oskaloosa, IABuilt 2002 · S/N 258596N804JMStarr Aviation Solutions LLC · New York, NYBuilt 2000 · S/N 258467N804MC824 Holdco LLC · Salt Lake City, UTBuilt 2004 · S/N 258684N804TBN804tb III LLC · Stuart, FLBuilt 1999 · S/N 258438N806GJPb Air LLC · Higley, AZBuilt 2002 · S/N 258602N806MNJm Soar LLC · Paradise Valley, AZBuilt 2003 · S/N 258605N806TCAviation Resource Group Inc · Fort Lauderdale, FLS/N 258364N807AVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 258597N808MCLrt Aero Partners LLC · Sheridan, WYBuilt 2003 · S/N 258614N80PKN80080pk LLC · Stuart, FLBuilt 1999 · S/N 258442N810AFJt Acquisitions LLC · Nashville, TNBuilt 2002 · S/N 258589N812LLH800 Vi LLC · Stuart, FLBuilt 2003 · S/N 258620N812SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 258683N816KYBcp Fa Ap LLC · Providence, RIBuilt 2004 · S/N 258680N816LXEa Enterprises LLC · Bismarck, NDBuilt 1998 · S/N 258363N817SDSea Aviation Holdings LLC · Wilmington, DEBuilt 2005 · S/N 258709N818LXN818lx LLC · Wilmington, DEBuilt 2001 · S/N 258534N821LBTvpx Ars Inc Trustee · Concord, MAS/N 258650N821MPLucas Aviation LLC · Fremont, MIBuilt 1985 · S/N 258043N822RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 258643N823AMAirmed International LLC · Birmingham, ALBuilt 2004 · S/N 258687N825QTKjm Air LLC · Aurora, ILBuilt 2000 · S/N 258497N826GCMqe LLC · Missoula, MTBuilt 1994 · S/N 258263N82RSFly Mda Aviation LLC · Opa Locka, FLBuilt 1997 · S/N 258336N831LXM&N Equipment LLC · Englewood, COBuilt 2000 · S/N 258510N838BBE D Santos & Associates LLC · Wilmington, DES/N 258301N847TX4 Ms Holding LLC · Spring, TXBuilt 2007 · S/N 258847N848NAsf Aviation LLC · Cortlandt Manor, NYBuilt 1998 · S/N 258371N84JGTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 2000 · S/N 258507N84UPN84up LLC · Wilmington, DEBuilt 2000 · S/N 258484N850DPN850dp LLC · Wilmington, DEBuilt 2000 · S/N 258468
Back to AD 2000-08-07