AD 2000-18-53

Registered aircraft · 45,248

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-18-53')
    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-18-53')
  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.

N102FVGruba Sheila M · Saint Joseph, MNBuilt 1998 · S/N 17280552N102GWJones Jamie M · Grants Pass, ORS/N GW 102N102KCJohnson Jerry D · Bryan, TXBuilt 1982 · S/N 760N102LCMy Technology Services LLC · Miami, FLBuilt 1967 · S/N 28-22860N102LPWashington State Patrol · Olympia, WABuilt 2002 · S/N 18281121N102LSVan Dyke Kevin J · Palm Beach Gardens, FLBuilt 1991 · S/N 2844N102LWWulff Allan · Reston, VABuilt 1955 · S/N 18-4383N102LYIves Samuel E · Amarillo, TXBuilt 2003 · S/N 90130N102MOk Av8r LLC · Iowa Park, TXBuilt 2002 · S/N 175N102MASquaw Creek Aviation LLC · Dover, DES/N 18280100N102MREquipment Services Corp · Wahpeton, NDS/N 30020CN102PRRico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17266462N102RRMoyer Aviation Ll C · Katy, TXS/N 1477-5N102TCMason Brian L · Eagle River, AKS/N 18-7909038N102VWVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1957 · S/N 18-5806N1030ZLenhart Thomas E · Barnesville, GABuilt 1997 · S/N 23041CN1032SThurber Matthew Calbraith · Vancouver, WABuilt 1980 · S/N 144-HN1033CHuson Lee E · Port Townsend, WABuilt 1997 · S/N 25012CN1033PProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 23-35N1033XHorizon Enterprises LLC · Kalispel, MTBuilt 1975 · S/N 28-7515376N1035EJobe Ronald G · Sedalia, MOFirst renewal noticeBuilt 1977 · S/N 983-77N1035XSocal Blue Side Up LLC · Anaheim, CABuilt 1975 · S/N 28R-7535222N1036JPremier Jets Inc · Hillsboro, ORS/N 36N1036NKovaleski Thomas J · Chugiak, AKBuilt 1997 · S/N 23035CN1036QKelley Michael · Bellingham, MABuilt 1977 · S/N 28-7716079N1037JTate Andrew E · Chapel Hill, NCBuilt 1973 · S/N 37N1038EFueston Vernon A · Montague, CABuilt 1977 · S/N 971-77N1038FPetrick Dan A · Punta Gorda, FLBuilt 1969 · S/N 28-25552N1038JLandgraf Robert J · Sussex, WIBuilt 1973 · S/N 118N1039JN1039j LLC · Casa Grande, AZBuilt 1973 · S/N 101N1039MManly James H · Reno, NVBuilt 1998 · S/N 513N1039PN1039p LLC · Suwanee, GABuilt 2005 · S/N 18281566N1039UIowa Lakes Community College · Estherville, IABuilt 1971 · S/N 34-7250024N1039XSilvered Wings LLC · Howell, MIBuilt 1975 · S/N 28-7525265N103ARHd Outdoor Advs LLC · Coalgate, OKBuilt 2005 · S/N 18281663N103ASHill Bryan Thomas · Page, AZBuilt 1979 · S/N R18200923N103BWWilson Billy C · Fort Worth, TXBuilt 2002 · S/N 21511N103DBZelasko Edward P · Oxford, WIS/N A-86N103DGD&R Aviation LLC · Lowell, MIBuilt 1999 · S/N 6MN103DJChicoine Chris · Williston, VTS/N 50N103FVChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280553N103HSHenderson State University · Arkadelphia, ARBuilt 1998 · S/N 17007CN103JKWise Charlie S · Norfolk, VABuilt 1974 · S/N 28-7415271N103JSVon Helmolt William · Inglewood, CAS/N 1822N103KCLang Elmer N · Hemphill, TXBuilt 1979 · S/N 28-7911238N103KFCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1999 · S/N 172S8143N103LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280298N103MBJohnson Kenneth W · Pueblo West, COBuilt 2005 · S/N 25248N103MDCarson Business Systems Inc · Carson City, NVS/N 30N103MPJoyce George E · Franklinville, NCS/N LF-50
Back to AD 2000-18-53