AD 2002-11-07

Registered aircraft · 1,512

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-11-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:2002-11-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.

N23PCHenderson Aviation Inc · Abingdon, VAS/N TH-2071N23PVLake Dana · Boxford, MAFirst renewal noticeBuilt 1987 · S/N TH-1513N240HCBlodgett James R · Walnut Creek, CABuilt 1979 · S/N TJ-221N24165Yukon Helicopters Inc · Bethel, AKBuilt 1978 · S/N TK-78N24182Robert Yost Enterprises Inc DBA · Saint Francis, KSBuilt 1978 · S/N TJ-136N241WSSun Moon Star LLC · Springfield, MOBuilt 1999 · S/N TH-1922N242RCN242rc LLC · Miami, FLBuilt 1972 · S/N TH-248N2458RKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2004 · S/N TH-2089N249CRA&W Air LLC · Aiken, SCBuilt 1979 · S/N TJ-249N24KHMoffett Jules M DBA · Elmore, ALBuilt 1974 · S/N TE-996N24RCJeanes Guy R · Lampe, MOBuilt 1974 · S/N TE-994N250DCHightower George Jr · Thomaston, GABuilt 1979 · S/N TK-91N250MMMone Forwarding Lc · Laredo, TXBuilt 1980 · S/N TJ-261N252DPDream Flite LLC · Sarasota, FLBuilt 1973 · S/N TE-932N25612Mad Scientist Aviation LLC · Wilmington, DES/N TE-897N25627Sutter Jacob O · Roland, ARBuilt 1973 · S/N TH-295N25647Segura Richard J III · Henderson, TXBuilt 1973 · S/N TH-301N25734Gardner Aviation LLC · Hot Springs, ARBuilt 1973 · S/N TH-390N25745Bird Dog Aviation LLC · Kalispell, MTS/N TE-949N258BBGhanimian 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-1539N25RMSky Travel LLC · Clayton, MOS/N TJ-459N25RXOlde Same Place LLC · Thiensville, WIBuilt 1971 · S/N TE-832N260ARDeep South Flying Services LLC · Albany, GABuilt 1983 · S/N TJ436N264SBCkw Aviation LLC · Dalhart, TXS/N TE-1125N266EASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N TH-2031N269KTJfa Aviation Group LLC · Pompano Beach, FLBuilt 1980 · S/N TJ-324N269RAFuller Aire Inc · Wilmington, DEBuilt 1978 · S/N TH-998N26HAEpsilon Equity Partners LLC · Houston, TXS/N TJ-486N26JJCrescenzo David G · Hammonton, NJBuilt 1975 · S/N TE-1058N26WLTrio Leasing LLC · Highland, MIBuilt 1974 · S/N TH-406N271PBClark Mayer Aviation LLC · Cross Roads, TXBuilt 1997 · S/N TH-1840N2720ABaron N2720a LLC · Faulkton, SDBuilt 1978 · S/N TK-69N275VFly 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-2082N283DFrohbieter Alan · Superior, COBuilt 1979 · S/N TK-112N283MAAtaraxia 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-349N2858WHought Lowell T · Olathe, KSBuilt 1973 · S/N TE-927N285HABlacqjacq Aviation Co · Wilmington, DEBuilt 1975 · S/N TH623
Back to AD 2002-11-07