OpenAirDocs.org
AD 77-13-21

Registered aircraft · 3,193

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:77-13-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
  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.

N5008PThree Chicks Aviation LLC · Benton, LAS/N 24-11N500AVInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 24-4805N500PFord Charles D · Clifton, TNS/N 24-341N5014PSky Valley Aviation LLC · Waverly, IAS/N 24-17N5017PPineapple Air LLC · Wilmington, DEBuilt 1957 · S/N 24-20N501REIndependence Aerospace LLC · Kennesaw, GABuilt 1963 · S/N 30-194N5020PThurston Steven C · Salisbury, NCBuilt 1958 · S/N 24-23N5029PJordan Walter B · Chehalis, WABuilt 1958 · S/N 2432N502DWSolamich Aviation LLC · Huntley, ILBuilt 1971 · S/N 39-124N5034PNeufeld William J · Bostwick, FLBuilt 1958 · S/N 24-37N503JALiem David H · Brea, CABuilt 1965 · S/N 24-4165N5045PMccarty Paul S · Wichita, KSBuilt 1958 · S/N 24-49N5048PBrown Mark E · Charlotte, NCBuilt 1958 · S/N 24-52N5050PBoucher Bobbi · Fredericksburg, VAS/N 24-54N5051PGrorud James R · Milbank, SDBuilt 1958 · S/N 24-55N5058PBakeman Michael G · Sturgis, MIBuilt 1958 · S/N 24-507N505BJLa Beau Lawrence O · San Angelo, TXBuilt 1961 · S/N 24-2331N505GAlford Robert S · Columbus, GARegistration revokedBuilt 1964 · S/N 30-251N5065PVeal Ted W · Homer, AKS/N 24-71N5066PDelaware Aviation LLC · Sidney, NYBuilt 1958 · S/N 24-72N5074PShingledecker Robert K II · Ozark, ARBuilt 1958 · S/N 24-80N5078PPutnam Andrew L · New Limerick, MEBuilt 1958 · S/N 24-84N5088CMike Golf Holdings LLC · Pinellas Park, FLBuilt 1964 · S/N 30-497N5088PKesser Gilbert M · Culpeper, VABuilt 1958 · S/N 24-94N5091PSpicuzza Robert A · Waterford, MIBuilt 1958 · S/N 24-100N5093PAir Chutney LLC · Waynesboro, VABuilt 1958 · S/N 24-102N5099PSelinger Richard L · Murrieta, CABuilt 1958 · S/N 24-109N50TDPa-30 LLC · Appleton, WIBuilt 1965 · S/N 30-827N5100PHuntcliff Air Services LLC · Atlanta, GABuilt 1958 · S/N 24-105N5107PStranton Air LLC · Harvard, ILS/N 24-117N5114PParris David T · Virginia Beach, VABuilt 1958 · S/N 24-126N5115PSmith James Kelly · Newark, OHBuilt 1958 · S/N 24-127N5117PMarsteller Michael A · Lugoff, SCBuilt 1959 · S/N 24-130N5118PMeng Marvin Allen Jr · Edwardsville, ILBuilt 1958 · S/N 24-131N5126PElie Jonathan · Hopewell Junction, NYBuilt 1958 · S/N 24-139N5128PSchafer David · Northport, ALBuilt 1958 · S/N 24-141N5130PWhite Guy B · Waxahachie, TXBuilt 1958 · S/N 24-143N5132PMccormick Geoffrey D · Goodyear, AZBuilt 1958 · S/N 24-145N5136PDunn James F · Salem, INBuilt 1958 · S/N 24-150N5137PFrancis Himanshu Raj · Blythewood, SCBuilt 1958 · S/N 24-151N5141PWest Texas Weather Modification Association · San Angelo, TXBuilt 1958 · S/N 24-156N5142PBritz Store Equipment Inc · Buckman, MNBuilt 1958 · S/N 24-157N5143PUnusual Attitudes LLC · Bates City, MOBuilt 1958 · S/N 24-159N5147PDunn Paul S Trustee · Santa Fe, NMBuilt 1958 · S/N 24-163N5148PRegistered aircraftBuilt 1958 · S/N 24-164N5150PPeterson Richard A · Entiat, WABuilt 1958 · S/N 24-166N5151PHone Ryan L · West Richland, WABuilt 1958 · S/N 24-167N5153PCjl Aviation LLC · Dover, DEBuilt 1958 · S/N 24-169N5154PPerry Billy C · Newburgh, INBuilt 1958 · S/N 24-170N515SRegistration Pending · Azle, TXRegistration pending, pending cancellationS/N 24-3609
Back to AD 77-13-21