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.

N2871WBuess Wayne R · Shirley, NYBuilt 1974 · S/N TH-462N287KMO'Connor Thomas F · Plano, TXBuilt 1980 · S/N TJ-330N288PBlue 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-1535N28WVOrth Duane C · San Antonio, TXBuilt 1978 · S/N TJ124N2901LStraight & Level Aviation LLC · Bradenton, FLBuilt 1980 · S/N TH-1172N299KAir Transport LLC · Troy, MTBuilt 1979 · S/N TJ-185N29CCSafford Aviation Service Inc · Coolidge, AZBuilt 1977 · S/N TJ-117N29CPClifford 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-1966N29RRKhg Aviation Holdings LLC · Columbus, OHBuilt 1982 · S/N TJ-414N2VVAir Mods And Repair Inc · Robbinsville, NJBuilt 1976 · S/N TK-37N2YCTaglavore Franklin · Irving, TXBuilt 1974 · S/N TH-487N3007WLima Mike Inc · Ham Lake, MNBuilt 1973 · S/N TH-365N300KKrakeel James A · Mount Pleasant, SCBuilt 1977 · S/N TE-1103N300THPacific Flight Academy LLC · Honolulu, HIBuilt 1972 · S/N TH-266N3014WRunyan Joseph D · Bushnell, ILBuilt 1973 · S/N TE-933N301CTVatm 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-1870N305TCjn Enterprises LLC · Elbert, COBuilt 1973 · S/N TE-952N305WP3192 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-1521N3085WFly Rudolf Corp · Wilmington, DEBuilt 1973 · S/N TE-954N30LLSoftware Innovations LLC · Wahoo, NEBuilt 1982 · S/N TJ-391N30PHStoneman Thomas K · Friendswood, TXS/N TJ-5N30RMDaniel Warren · Naples, FLBuilt 1971 · S/N TE-828N30TBAlbert Lea Airport Inc · Albert Lea, MNBuilt 1970 · S/N TH-74N30WGMather Christopher D · Hayward, CABuilt 1974 · S/N TE-997N3101WGeorge Jon A · Durango, COS/N TE-953N3109WIII Per LLC · Lewes, DEBuilt 1973 · S/N TE-955N310ECState Of Tennessee · Nashville, TNBuilt 1988 · S/N TH-1534N3118HAtlantic Aviation Group Inc · Miami, FLBuilt 1994 · S/N TH-1718N311CHWings Of Eaglz LLC · Lamoni, IAS/N TK-149N3121WAlpha Dog Aviation LLC · Marco Island, FLBuilt 1973 · S/N TH-410N3122RMarrow Henry G · Southern Pines, NCBuilt 1994 · S/N TH-1722N3124WBaron 24w LLC · Outing, MNBuilt 1973 · S/N TH-411N312CWLb Wings LLC · Midland, MIBuilt 1981 · S/N TH-1204N316DFThacker Orbie A · Wellington, ALBuilt 1997 · S/N TH-1817
Back to AD 2002-11-07