AD 2002-20-05

Registered aircraft · 2,705

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

N108SCCounty Of Sonoma · Santa Rosa, CAS/N 54728N108WWeyerhaeuser Nr Co · Eugene, ORBuilt 1993 · S/N 52034N109AGO'Brien Helicopters Inc · Lehigh Acres, FLBuilt 1989 · S/N 7602N109AHEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11078N109ALEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 11113N109BMRegistration Pending · North Salt Lake, UTRegistration pendingS/N 11157N109BTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 22055N109CGEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 11109N109CYO'Brien Derrick P · Middletown, DES/N 7351N109DDLitton Global LLC · Wilmington, DEBuilt 2000 · S/N 11069N109DXSunwest Construction Enterprises Inc · Tarpon Springs, FLS/N 3489N109FBCity Of Phoenix · Phoenix, AZS/N 11629N109GLA Air Club LLC · Tampa, FLBuilt 1990 · S/N 7623N109HNPrestige Air LLC · Aliso Viejo, CABuilt 2000 · S/N 11087N109LRCenterline Holdings Inc · Camden, DES/N 7416N109MHGateway Air Center Inc · Merced, CABuilt 1998 · S/N 11026N109MMAirborne Leasing Inc · Sylmar, CABuilt 1985 · S/N 7279N109NLIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1988 · S/N 7415N109PPhoenix Helicopters LLC · Dover, DES/N 11035N109PBBennedsen Rosa Fadia Gabriel · Aventura, FLBuilt 1985 · S/N 7344N109RASunny Sky LLC · Stacyville, IABuilt 1979 · S/N 2741N109SFHeli Assets LLC · Mesa, AZBuilt 1989 · S/N 7436N109SJCarmona Cristobal Pelaez · Laredo, TXS/N 11170N109TGTwin Rotors Flying Circus LLC · Port Orange, FLBuilt 2006 · S/N 11680N109USU S Helicopters Inc · Marshville, NCBuilt 1977 · S/N 2164N109WGDodson International Parts Inc · Rantoul, KSS/N 7316N109WHTre Aviation Corp · Wilmington, DEBuilt 1997 · S/N 7174N109WJL S Service Corp · Wilmington, DEBuilt 1982 · S/N 7218N109XPNational Test Pilot School · Mojave, CABuilt 1981 · S/N 7178N109ZTValiair Lc Trustee · Casper, WYBuilt 1991 · S/N 7639N10AJEl Aero Services LLC · Elko, NVBuilt 1980 · S/N 3169N10BLLeon Helicopter One LLC · Miami, FLBuilt 2009 · S/N 22105N10CCSmith Kord S · Salmon, IDBuilt 1964 · S/N 206-0166N10KXWhirly Leasing Inc · Richvale, CABuilt 1975 · S/N 1628N10LESlws LLC · Missoula, MTBuilt 2003 · S/N 53556N10MSKas Enterprises LLC · Lewes, DEBuilt 1980 · S/N 3208N10SPState Of Kentucky · Frankfort, KYBuilt 1983 · S/N 51064N10TVHelicopters Inc · Cahokia, ILBuilt 1990 · S/N 51399N10XVHelicopters Inc · Wilmington, DEBuilt 2004 · S/N 52293N110DJLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56371N110LTLt Aviation LLC · Louisa, KYBuilt 1981 · S/N 45676N110WGMeshoppen Air LLC · Tunkhannock, PABuilt 1978 · S/N 2367N111BVOceanside Vertical Express LLC · Canaan, NYS/N 3264N111GHGuardian Helicopters Inc · Fillmore, CABuilt 2001 · S/N 53494N111HFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1968 · S/N 208N111PMTri Rotor Spray And Chemical · Ulysses, KSBuilt 1975 · S/N 1770N111SPState Of Michigan · Lansing, MIBuilt 1990 · S/N 51325N112EPMarks Aviation Group LLC · Lafayette, LAS/N 51612N112LPRanger Aviation Leasing LLC · Wilmington, DES/N 3403N113AEAir Evac Ems Inc · O Fallon, MOS/N 45371
Back to AD 2002-20-05