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.

N5240CHardy Pete · Pearland, TXS/N D-2631N5245NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1947 · S/N D-109N5246CMenzimer David · Snohomish, WAS/N D-2638N5247CFoushee Michael J · Columbus, INBuilt 1950 · S/N D-2639N5250CHodges John J · Cleburne, TXBuilt 1950 · S/N D-2642N5256CFortier Stanley · Chico, CABuilt 1950 · S/N D-2648N5260CTerlizzi Jacob Daniel · Vine Grove, KYBuilt 1950 · S/N D-2652N5263CMangu Ionel · Albuquerque, NMBuilt 1950 · S/N D-2655N5267COlson Derald G · Casa Grande, AZBuilt 1950 · S/N D-2660N526BPutnam Michael C · Topeka, KSBuilt 1948 · S/N D-1541N5270CLohr David C · Wrightwood, CABuilt 1950 · S/N D-2664N5271CSale Reported · Davis, CASale reported, pending cancellationBuilt 1951 · S/N D-2665N5272CDiehl Ross E · Chino, CABuilt 1951 · S/N D-2666N5278CMoore Louis · Rutland, VTBuilt 1951 · S/N D-2672N5282COrr Kent C · Kearney, NES/N D-2676N5285CElkins Quentin D · Andersonville, TNBuilt 1951 · S/N D-2679N532BWeinreich Mark W · River Falls, WIBuilt 1948 · S/N D-1547N537BN537b LLC · Crowley, LAFirst renewal noticeBuilt 1948 · S/N D-1553N542GHHepner G L · New Port Richey, FLBuilt 1947 · S/N D-1067N545AEelkema Peter C · Mckenzie Bridge, ORFirst renewal noticeBuilt 1949 · S/N D-2197N548BCopass Benjamin Jay · Fountain Run, KYBuilt 1948 · S/N D-1566N549BWhite Judy C · Fall City, WABuilt 1948 · S/N D-1479N553BJ M Thomas & Assoc Inc · Panama City Beach, FLBuilt 1948 · S/N D-1571N554BDaniel James W · Somis, CABuilt 1948 · S/N D-1572N555RSmathers John R · Flowery Branch, GABuilt 1950 · S/N D-2295N55WRussell Richard · San Jose, CAS/N D-1969N577BKrueger Hendrik · Rockport, TXBuilt 1948 · S/N D-1596N579DLee David · Palm Springs, CAS/N D-369N57FWilliams John E · Oak Ridge, TNBuilt 1948 · S/N D-1273N582BSievers Gilbert H · Medina, OHBuilt 1948 · S/N D-1601N589BRyanns Hangar LLC · Sparta, MOS/N D-1608N590BFolds James W · Tifton, GABuilt 1948 · S/N D-1609N594BBaxter Derec L · Chatham, ILBuilt 1948 · S/N D-1615N598BMeeks Howard S · Lompoc, CABuilt 1948 · S/N D-1619N600VRAutry Technology Center · Enid, OKS/N D-2159N602BMeyer Charles H · Stratford, CABuilt 1948 · S/N D-1623N607BKovas Dale K · New Carlisle, INBuilt 1948 · S/N D-1628N60KTTalhelm Timothy A · Flushing, MIBuilt 1948 · S/N D-1912N6191YChisum Robert · Lorenzo, TXS/N D-27N62384Watson James E Jr · Victor, COBuilt 1948 · S/N D-1917N651BBGooch Kelcy J · Ridgeland, MSBuilt 1950 · S/N D-2586N654BCannon Rick A · Langley, WABuilt 1948 · S/N D-1653N655BCritical Craft Technologies LLC · Charlotte Hall, MDBuilt 1948 · S/N D-1654N660BConlin Michael T · Pawleys Island, SCBuilt 1948 · S/N D-1661N661BYork Robert A · Dillsburg, PABuilt 1947 · S/N D-1662N666BLisa Beach Inc · La Porte, TXBuilt 1948 · S/N D-1667N668BJordan Thomas G · Saint Helena, CAFirst renewal noticeBuilt 1948 · S/N D-1669N66PDHaines Christopher B · Fort Worth, TXBuilt 1949 · S/N D-1938N672BPlane Fun Inc Trustee · Snellville, GABuilt 1948 · S/N D-1673N674BAtkins Mitchell · Jackson, MIBuilt 1948 · S/N D-1675
Back to AD 2002-21-13