AD 2002-26-01

Registered aircraft · 29,517

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-26-01')
    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-26-01')
  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.

N103SJBarnick Air Holdings LLC · Santa Barbara, CABuilt 2000 · S/N 20608101N103SVSun Valley Aviation Inc · Harlingen, TXBuilt 1998 · S/N 17280534N103TXWilliams Bradley H Jr · Charleston, SCBuilt 2001 · S/N 18280984N103URankin Kenneth · Pinellas Park, FLBuilt 1986 · S/N 585N1040JHefferon John W · Locust Grove, GABuilt 1973 · S/N 40N1040UAmerican Aviation Inc · Brooksville, FLS/N 34-7250025N1040ZDonnelly Jeff E · Pembroke, MABuilt 2006 · S/N 3232062N1041CHelzer Timothy · Tucson, AZBuilt 2003 · S/N 270321N1041HCentury Flight Systems Inc · Mineral Wells, TXBuilt 1977 · S/N 32R-7780125N1042DCarson Roger K · Anthem, AZBuilt 2016 · S/N 80189N1042PMcalpine David B · Fort Worth, TXBuilt 1986 · S/N 64-18123N1042UShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1971 · S/N 34-7250026N1042XN1042x LLC · Papillion, NEBuilt 1975 · S/N 28R-7535223N1043JLanmon Herman Jr · Hamilton, TXBuilt 1974 · S/N 127N1043QRegistered aircraftBuilt 1977 · S/N 28R-7737025N1043XAustin Security Corp · Battleboro, NCBuilt 1975 · S/N 28R-7535224N1044JNagasaka Bruce J · Weiser, IDBuilt 1973 · S/N 44N1044LFitch Mark · Anchorage, AKBuilt 1996 · S/N 25009CN1044NMaule Flight Inc · Moultrie, GABuilt 1996 · S/N 25006CN1045Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020177N10457Six Ten Ventures LLC · Cedar Hill, TXBuilt 2003 · S/N 20608194N1045LBernard Robert J · Millbury, MABuilt 1974 · S/N 638N1045YRovers Bradley S · Chazy, NYBuilt 2005 · S/N 18281571N1046ERisk Indemnification Professionals LLC · Boston, MABuilt 1977 · S/N 296-77N10475Lissow William M · New Port Richey, FLBuilt 1967 · S/N 67-18368N1047JFirst Flight Investments LLC · Bartow, FLBuilt 1973 · S/N 47N1047UStueve'S Certified Organic Dairy · Oakdale, CABuilt 1998 · S/N 23043CN1048DDumbravo Dustin C · Yorktown, VABuilt 2001 · S/N 27-0315N1048LSparrow Thomas E · Hawley, MNBuilt 1974 · S/N 641N1049JLoxley Jason C · Virginia, ILBuilt 1972 · S/N 49N1049TRoberts Kevin C · Athens, GABuilt 2003 · S/N 27-0319N1049XValleyside Farm LLC · Woodstock, CTFirst renewal noticeBuilt 1975 · S/N 32-7540132N104AAMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881573N104ABPeterson Kevin D · Peoria, AZBuilt 1998 · S/N 18280280N104ALDinardi Allen J · Jacksonville, ORBuilt 2010 · S/N 40369N104AZJarrell Rodney M · Phoenix, AZBuilt 2014 · S/N 41226N104BABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-235N104BCHoudek Todd L · Roseburg, ORBuilt 1978 · S/N 7-0162N104BKCharlie Alpha Bravo LLC · Spring Hill, KSBuilt 2012 · S/N 40125N104BRBelsaas Richard A · Rapid City, SDBuilt 2007 · S/N 40373N104CDOlson Timothy D · Elk Mound, WIBuilt 2006 · S/N 40170N104CPN7293l LLC · Waxahachie, TXBuilt 1966 · S/N 30-1276N104DFHayton Thomas M · Arcadia, OKBuilt 1975 · S/N 2098N104DHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881999N104DPMajul Enterprises Inc · Saint Petersburg, FLS/N 3340N104EHaas Bruce F · Lynden, WAS/N 586N104EDEdwards Aero Club · Edwards Afb, CABuilt 2000 · S/N 172S8484N104EEWestfall Benjamin C · Coeur D Alene, IDBuilt 2019 · S/N 001N104EPEarwood Edward A · Sonora, TXBuilt 2012 · S/N 40820N104EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2007 · S/N 2844135
Back to AD 2002-26-01