AD 2000-22-03

Registered aircraft · 425

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-22-03')
    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-22-03')
  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.

N317CQPrivate Fliers LLC · Wheaton, ILBuilt 2001 · S/N 258532N31ZZE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N NA0437N320EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258523N321MSTaughannock Aviation Corp · Ithaca, NYBuilt 2001 · S/N 258515N323AAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N 258155N32KBS S K Hawker Group LLC · New Haven, CTBuilt 2000 · S/N 258461N32PJRegistered aircraftN-number assigned (import), not yet registeredS/N NA0455N333PCSemanik Investment Corp · Jacksonville, FLBuilt 2004 · S/N 258669N333RLJetstream Air LLC · Colfax, NCBuilt 1992 · S/N 259027N337WRAer Sales Lp · Carrollton, TXBuilt 1995 · S/N 258273N338SWN338sw LLC · Midland, TXBuilt 1992 · S/N 258229N339AVKmwflight LLC · Wilmington, DEBuilt 1994 · S/N 258255N33BCSworks Aviation LLC · Chicago, ILBuilt 1996 · S/N 258292N33RCBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 258466N343SCMtj Aviation LLC · Mooresville, NCBuilt 1998 · S/N 258365N348AJE E & K C LLC · New Orleans, LABuilt 1997 · S/N 258334N353JABasler 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 258321N39QJAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 1993 · S/N 259039N406TMAlcyone 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 258431
Back to AD 2000-22-03