AD 2000-09-06

Registered aircraft · 1,273

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-09-06')
    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-09-06')
  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.

N1048QTaf Aerial Services LLC · Corpus Christi, TXBuilt 1997 · S/N 21034CN1048TTrotter Thomas J · Bremerton, WABuilt 1997 · S/N 23037CN1048XLogan Colton Dean · Pagosa Springs, COS/N 25043CN1049ZMandan Enterprises LLC · Chester, CTS/N 21004CN1050RWatrous Scott A · Warrenton, VABuilt 1998 · S/N 21044CN1051SWhitfield David Michael · Cleveland, GABuilt 1998 · S/N 21039CN1051TOwens Randall C · Houston, TXBuilt 1998 · S/N 14092CN1051WAir Services International Leasing LLC · Fort Lauderdale, FLS/N 21035CN1051ZDranttel Timothy John · Fuquay Varina, NCBuilt 1998 · S/N 25021CN1052TSale Reported · Crystal, MNSale reportedBuilt 1998 · S/N 20054CN1052UHuizinga Reinder C · Marietta, GAS/N 28007CN1053THenderson State University · Arkadelphia, ARBuilt 1998 · S/N 21054CN1054TInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N 26004CN10550Edwards Robert · Daphne, ALBuilt 1998 · S/N 21060CN10555Mccrea Daniel B · Waldport, ORS/N 23055CN1055CPerry Scott R · Klamath Falls, ORS/N 20051CN1055JEmbry William Mark · Gifford, WABuilt 1995 · S/N 20039CN1055TWeiss Martin T · Aquinnah, MABuilt 1998 · S/N 21058CN1055XDcfly LLC. · Bessemer City, NCBuilt 1996 · S/N 14075CN1055ZLikovich Robert B Jr · Wake Forest, NCBuilt 1998 · S/N 21050CN1058TRock Island Aviation Inc · Wilmington, DEBuilt 2010 · S/N 23107CN107AKLazzaro Chris C · Solvang, CABuilt 1988 · S/N 4055CN108FBPlane Fun Inc Tr Trustee · Snellville, GABuilt 1993 · S/N 10119CN108HGKillam Galen Mark · Wautoma, WIBuilt 1994 · S/N 19015CN10SYBellany Mark A · Freeville, NYS/N 7487CN1101TThompson Thomas Brian · San Francisco, CABuilt 2023 · S/N 14139CN110HSHenderson State University · Arkadelphia, ARBuilt 1998 · S/N 17008CN11101Perin Jeffrey S · Wasilla, AKBuilt 1986 · S/N 7478CN111KDWedekemper Steven E · Brighton, MIS/N 10049CN112CPBradley Aviation LLC · Columbus, INBuilt 2001 · S/N 18062CN112LCJacobsen Jeffrey M · Salinas, CABuilt 2001 · S/N 28014CN114HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 21092CN114MKGood Thomas Ryan · Grapevine, TXS/N 10022-CN114WMMaule Flight LLC · Nashville, INBuilt 2001 · S/N 25058CN116GRegistration Pending · Sheridan, WYRegistration pendingBuilt 1995 · S/N 23019CN118GSparks Brian E · Monmouth, ORBuilt 1996 · S/N 23025CN11UGBrandemuehl Joseph J · Boscobel, WIBuilt 1987 · S/N 10047CN11ZARanch Aero LLC · Sterling City, TXBuilt 1985 · S/N 10005CN11ZVWebb Group Flp · Jackson, MSBuilt 2012 · S/N 22031CN12008Dvoracek Dana J · Charlevoix, MIBuilt 1963 · S/N 18N12009Jordan Ronald W · Stoutsville, OHS/N 19N12011Marsh John Edward · Washington, DCS/N 21N12014Thompson Robert J · Kaktovik, AKS/N 24N12015Thurmond Paul J · Huntley, MTBuilt 1963 · S/N 25N12016Swain Michael J · Jacksonville, FLBuilt 1963 · S/N 26N12017Nuckles Charles Austin Jr · Suffolk, VABuilt 1963 · S/N 27N12018Theriot Harris J Jr · Thibodaux, LABuilt 1963 · S/N 28N12026Bernhardt Michael J · North Branch, MNBuilt 1963 · S/N 38N12027Rugland Roger E · Anoka, MNBuilt 1963 · S/N 36N12029Dippold Lois M · Perry, MIBuilt 1963 · S/N 39
Back to AD 2000-09-06