OpenAirDocs.org
AD 2002-21-13

Registered aircraft · 579

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-21-13')
    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-21-13')
  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.

N3127VTyner Steven P Trustee · Lees Summit, MOBuilt 1947 · S/N D-552N3140VLayton Matthew K · Mesa, AZS/N D-569N3145VClonts Dale · Safford, AZBuilt 1947 · S/N D-575N3146VWittmeyer Jamie J · Wyomissing, PABuilt 1947 · S/N D-756N3147VRobb Steven G · Riverside, CABuilt 1947 · S/N D-577N3150VSanders John B · Knoxville, TNBuilt 1947 · S/N D-580N3159VHoogestraatcarl W · Bangor, PABuilt 1947 · S/N D-589N3164VDisdier David C · Vinita, OKBuilt 1947 · S/N D-595N3171VCarpenter Colt A · John Day, ORS/N D-604N3173VLae Media Group LLC · Gardner, KSBuilt 1947 · S/N D607N3178VHowell Larry A · Terrell, TXBuilt 1947 · S/N D-612N3181VSitkins Amber A · Ozark, MOBuilt 1947 · S/N D-616N3190VTop Flight LLC · Wilmington, DEBuilt 1947 · S/N D-626N3196VOpenshaw Charles M · Huggins, MOBuilt 1947 · S/N D-632N3203VGumar Sherko · Scottsdale, AZS/N D-640N3208VIrby Darrell L · Keller, TXS/N D-646N3212VIvy James III · Seligman, AZBuilt 1947 · S/N D-650N3222VRohsner Thomas A · Nacogdoches, TXBuilt 1947 · S/N D-800N3224VHerman Ira · Albuquerque, NMBuilt 1947 · S/N D-667N3233VSanchez Alfonso H · Albuquerque, NMBuilt 1947 · S/N D-676N3238VAltman Michael A · Austin, TXS/N D-682N3244VMalouf Jeannette D H · Palm Harbor, FLBuilt 1947 · S/N D-689N3255VAcker Timothy G · Gig Harbor, WABuilt 1947 · S/N D-702N3261VBaldwin Larry Lee · Clarinda, IABuilt 1947 · S/N D-708N3262VAbernathy Richard M · Overland Park, KSBuilt 1947 · S/N D-709N3268VObrien Joseph F IV · Pierson, FLBuilt 1947 · S/N D-716N3269VRegistered aircraftBuilt 1947 · S/N D-717N326TSShirley Terry L · Winnsboro, LAFirst renewal noticeBuilt 1948 · S/N D-1565N3271VRiley Daniel B · Valparaiso, INFirst renewal noticeBuilt 1947 · S/N D-720N3273VRoberts Alan P · Bolivar, MOBuilt 1947 · S/N D-722N3276VGrubbs Terry · Gregory, SDBuilt 1947 · S/N D-725N3288VSimmons Shawn Noral · Fort Rock, ORS/N D-739N3300VJacobsen Glenn D · Plano, ILBuilt 1947 · S/N D-759N3304VConklin Greg · Nevada City, CABuilt 1947 · S/N D-763N3306VHart Aviation LLC · Emory, TXS/N D-765N3307VAgogi Learning Systems LLC · Dahlonega, GABuilt 1947 · S/N D-766N3308VRobb Steven G · Riverside, CABuilt 1947 · S/N D-767N3309VArjad Henry · Irvine, CAS/N D-768N3317VMathews Thomas R · Indianapolis, INBuilt 1947 · S/N D-777N3320VFricke Albert G · Lomita, CABuilt 1947 · S/N D-780N3329VMcmahon Jeffrey J · Paris, KYFirst renewal noticeBuilt 1947 · S/N D-790N3333VBarreto David · Beavercreek, OHBuilt 1947 · S/N D-795N3337VStrong Don E Jr · Milano, TXS/N D-799N333KPGyarfas Nicholas · Lafayette, LABuilt 1948 · S/N D-1909N3342VRichards James D · Nucla, COBuilt 1947 · S/N D-805N3346VBarnd Dennis Allen · Manchester, OHBuilt 1947 · S/N D-810N3355VRyan Kevin · Bethel, OHBuilt 1947 · S/N D-819N3361VMatta Figueroa Eduardo · Chapman, KSBuilt 1947 · S/N D-827N3365VReffett John S · Eagle River, AKBuilt 1947 · S/N D-831N3380VCarney Francis P · Eloy, AZS/N D-848
Back to AD 2002-21-13