AD 2000-22-18

Registered aircraft · 914

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

N25647Segura Richard J III · Henderson, TXBuilt 1973 · S/N TH-301N25734Gardner Aviation LLC · Hot Springs, ARBuilt 1973 · S/N TH-390N258BBGhanimian Zaven · Encino, CABuilt 1977 · S/N TH-892N258DTwin Engine Express LLC · Lewes, DEBuilt 1995 · S/N TH-1740N258MTK5 Aviation LLC · Lewes, DES/N TH-244N258NCFidelis Flight Group Inc · Elm Springs, ARBuilt 1978 · S/N TH899N258RPInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N TH-1737N258TNKrause Jason · Glendale, AZBuilt 1988 · S/N TH-1539N266EASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N TH-2031N269RAFuller Aire Inc · Wilmington, DEBuilt 1978 · S/N TH-998N26WLTrio Leasing LLC · Highland, MIBuilt 1974 · S/N TH-406N271PBClark Mayer Aviation LLC · Cross Roads, TXBuilt 1997 · S/N TH-1840N275VFly Collier LLC · Naples, FLBuilt 1973 · S/N TH-376N278MReid Stephen M · Gardner, KSBuilt 1980 · S/N TH-1105N27DQOhio University · Albany, OHBuilt 1972 · S/N TH-228N27MTFlying Dog Aviation LLC · Swanton, OHBuilt 1980 · S/N TH1120N27PKOgary Aviation LLC · North Little Rock, ARBuilt 1993 · S/N TH-1687N281ARKing Scott · Knoxville, TNBuilt 1978 · S/N TH-991N282EAGalaxy Lift II LLC · Blountville, TNS/N TH-2082N283MAAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1975 · S/N TH-669N2844DMichigan Aeronautics Commission · Lansing, MIBuilt 1994 · S/N TH-1726N2852WButcher Charles · Germantown, TNBuilt 1973 · S/N TH-349N285HABlacqjacq Aviation Co · Wilmington, DEBuilt 1975 · S/N TH623N2871WBuess Wayne R · Shirley, NYBuilt 1974 · S/N TH-462N288PBlue Water Aviation Inc · Jupiter, FLBuilt 1980 · S/N TH-1113N288TATurbine Time LLC · Mercer Island, WABuilt 1999 · S/N TH-1926N28MGHudson Equipment LLC · Camden, DEBuilt 1988 · S/N TH-1535N2901LStraight & Level Aviation LLC · Bradenton, FLBuilt 1980 · S/N TH-1172N29CPClifford Robert J · Dania Beach, FLFirst renewal noticeBuilt 1970 · S/N TH-33N29CSKntj Properties 1 LLC · Wildwood, MOBuilt 1989 · S/N TH-1558N29DAJones David W · Carlisle, PABuilt 1975 · S/N TH-645N29MFChas N Clark Associates Ltd · Laurel, MSBuilt 2000 · S/N TH-1966N2YCTaglavore Franklin · Irving, TXBuilt 1974 · S/N TH-487N3007WLima Mike Inc · Ham Lake, MNBuilt 1973 · S/N TH-365N300THPacific Flight Academy LLC · Honolulu, HIBuilt 1972 · S/N TH-266N301CTVatm Sky Investments LLC · Thomson, GABuilt 1980 · S/N TH-1166N301PRussell Bill W · Victoria, TXBuilt 1978 · S/N TH-890N3033BPalms Edward M · Greenwood Village, COBuilt 1998 · S/N TH-1869N3044W625 Mike Tango LLC · Dickinson, TXBuilt 1973 · S/N TH-344N3049DAnchor Equipment Leasing LLC · Covington, KYBuilt 1998 · S/N TH-1873N3058ROn Top Aviation LLC · Salinas, CABuilt 1998 · S/N TH-1870N305WP3192 Golf Inc · Wauchula, FLBuilt 1984 · S/N TH-1426N3066BAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1987 · S/N TH-1514N3066DN3066d LLC · Pompano Beach, FLBuilt 1998 · S/N TH-1866N3075PWjs Inc · Greeneville, TNBuilt 1999 · S/N TH1887N30771Dodson International Parts Inc · Rantoul, KSBuilt 1987 · S/N TH-1518N3077ZBravo Air LLC · Troy, MIBuilt 1987 · S/N TH-1516N30787Jetsons Holdings LLC · Birmingham, ALBuilt 1987 · S/N TH-1521N30TBAlbert Lea Airport Inc · Albert Lea, MNBuilt 1970 · S/N TH-74N310ECState Of Tennessee · Nashville, TNBuilt 1988 · S/N TH-1534
Back to AD 2000-22-18