OpenAirDocs.org
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.

N353JABasler Turbo Conversions LLC · Oshkosh, WIS/N 258729N355FAE D Santos & & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N 258156N356EJAlliance Aviation Group LLC · Wilmington, DEBuilt 1999 · S/N 258452N356MANazareth Bay Holdings LLC · Palm Beach Gardens, FLBuilt 1998 · S/N 258373N361CAN361ca LLC · Wilmington, DEBuilt 2005 · S/N 258734N361LABest Friends Air LLC · Kerrville, TXBuilt 2001 · S/N 258562N369UBAlliance Air Parts Acquisitions Corp · Oklahoma City, OKS/N 258232N375PFConch Air LLC · Green Bay, WIBuilt 2001 · S/N 258558N375RC2022 Olivia Av LLC · Austin, TXBuilt 2001 · S/N 258565N383MVN383mv LLC · Amarillo, TXBuilt 1999 · S/N 258403N383TKThk Holdings LLC · Cincinnati, OHBuilt 2004 · S/N 258700N384ABArkoma Air LLC · Rockwall, TXBuilt 1997 · S/N 258339N389SRIgnite Enterprises LLC · Cerritos, CABuilt 2002 · S/N 258575N391BVcs Encore LLC · Austin, TXBuilt 1996 · S/N 258321N406TMAlcyone Trust Corp Trustee · Wichita, KSBuilt 2002 · S/N 258578N411SCRegistered aircraftBuilt 2004 · S/N 258653N412DAVida Trade And Management Group LLC · Charlotte, NCS/N 258061N412JADodson International Parts Inc · Rantoul, KSBuilt 2001 · S/N 258516N413HSAerotrust Services Corp Trustee · Wilmington, DES/N NA0413N414PEAerotrust Services Corp Trustee · Wilmington, DES/N 258090N417TMCpj2 LLC · Garden City, NYBuilt 2004 · S/N 258657N418CASkybus Inc · North Miami Beach, FLBuilt 1992 · S/N 258218N422CSBusiness Jet Managers Inc · Canton, MIBuilt 1988 · S/N 258110N423SGSworks Aviation LLC · Chicago, ILS/N 258472N42JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 258509N432SMWorldwide Option LLC · Lewes, DEBuilt 1996 · S/N 258293N4343FFrenkel Tardis Development Corp LLC · Dallas, TXBuilt 2003 · S/N 258641N43JRGlobal Avionics LLC · Downey, CAS/N 258173N43MMAircraft Holding Solutions LLC · Newark, DEBuilt 2001 · S/N 258543N43TPAircraft Holding Solutions LLC Trustee · Newark, DES/N 258628N440WPBbft Aero Holdings LLC · Columbus, OHBuilt 2001 · S/N 258524N442MSWd Aviation Group Inc · Atlanta, GAS/N NA0460N444JFBod Aviation LLC · Los Angeles, CABuilt 1999 · S/N 258431N44MBTria Entertainment LLC · Wisconsin Dells, WIBuilt 2002 · S/N 258573N44UNHawker 258359 LLC · Dover, DEBuilt 1998 · S/N 258359N457JAviation Leasing Group Inc · Wilmington, DEBuilt 1987 · S/N 258085N45GDPacific Rim Management LLC · Middletown, DEBuilt 1989 · S/N 258142N45KNHawker800xp LLC · Dorado, PRBuilt 2003 · S/N 258635N469RJDodson International Parts Inc · Rantoul, KSBuilt 1986 · S/N 258067N474CFCarrousel Aviation LLC · Monroe, WIBuilt 2004 · S/N 258662N475HMFalcon Double D 163 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258451N475RSRomeo Sierra LLC · Morgantown, WVBuilt 2004 · S/N 258674N47HAHoosier Jets LLC · Sellersburg, INBuilt 1995 · S/N 258280N47HWCelebration Tv America Inc · Houston, TXS/N 258023N488AMByte Me Transportation Inc · Fort Pierce, FLBuilt 2003 · S/N 258648N489BMEd Santos & Associates LLC Trustee · Wilmington, DEBuilt 1994 · S/N 258271N492DYLerma Aviation LLC · Dallas, TXBuilt 2001 · S/N 258546N499PANe Charters LLC · South Jordan, UTBuilt 2005 · S/N 258739N500XPHawker 800xp LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258455N509DMTeam Aero LLC · Shawnee, KSS/N 258056
Back to AD 2000-08-07