OpenAirDocs.org
AD 77-13-21

Registered aircraft · 3,192

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.

N1018TLeon J Hapka · Halma, MNS/N 24-4884N101DHLarson David R · Boerne, TXBuilt 1960 · S/N 24-1833N1020HHw Barnhouse Inc · Vero Beach, FLBuilt 1968 · S/N 30-1569N103HPMcfarland Natalie · Roseburg, ORBuilt 1965 · S/N 24-4153N103PGHnd Operations LLC · Henderson, NVBuilt 1969 · S/N 30-1858N104CPN7293l LLC · Waxahachie, TXBuilt 1966 · S/N 30-1276N106JLinder Michael A · Arvada, COBuilt 1961 · S/N 24-2668N1070BCurtis Julia A · Holladay, UTBuilt 1964 · S/N 24-3620N10816Van Der Merwe Coenraad · Traverse City, MIBuilt 1968 · S/N 244753N108SGVahsholtz Matthew James · Conroe, TXBuilt 1958 · S/N 24-149N10MAPatterson Casey Paul · Kinston, ALS/N 24-4180N10NWLinzey David Wayne · Boone, NCBuilt 1963 · S/N 24-3548N10SGBranyan Tyson E · Cushing, OKBuilt 1960 · S/N 24-2112N1100LRaider Aviation LLC · Lubbock, TXS/N 30-12N110LFComanche Flyer Foundation Inc · Blaine, WAS/N 24-695N110LLFlight Level 7 Inc · Wilmington, DEBuilt 1971 · S/N 39-89N110WWTorba Jacob · Citrus Heights, CABuilt 1969 · S/N 30-1846N1111HBielamowicz John Kolbe · Waxahachie, TXBuilt 1964 · S/N 30-427N11151Kowest Aviation LLC · Enid, OKBuilt 1959 · S/N 24-1631N111EWimpy Scott · Griffin, GAS/N 24-4210N111LFZimmerman Leland · Center, COBuilt 1959 · S/N 24-1023N111PLColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1969 · S/N 301929N111SEKeith Fischer · Gig Harbor, WABuilt 1966 · S/N 24-4462N111SLKaehlert Lottie DBA · Rifle, COS/N 24-2532N112WSEdgeington Randall K · Riverton, WYBuilt 1961 · S/N 24-2765N1147N7371y LLC · Waterford, MIBuilt 1964 · S/N 30-423N114CDNorwest Ventures LLC · Santa Cruz, CABuilt 1963 · S/N 30-37N114RSLuggelle Michael · Hull, MABuilt 1966 · S/N 30-1094N114XTaft Plumbing Co Inc · Taft, CABuilt 1961 · S/N 24-2698N1188YSkylark Flight Training LLC · Panama City, FLBuilt 1964 · S/N 30-403N118BLEdge Aviation LLC · Hawthorne, FLBuilt 1965 · S/N 30-913N119EAce Aeromotive Inc · Miami, FLBuilt 1958 · S/N 24-532N11CGComanche 260b-N11cg · Pomeroy, WABuilt 1966 · S/N 24-4434N11CVStoots Christa M · Tucson, AZS/N 24-4130N11KYKlad-Air LLC · Catlett, VABuilt 1966 · S/N 30-1181N11PYCuller John T · Arvada, COBuilt 1964 · S/N 30-533N11QTAv8rs LLC · Sugar Valley, GABuilt 1968 · S/N 30-1780N11YYAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1967 · S/N 30-1573N1206APelham Aircraft LLC · Dallas, TXBuilt 1966 · S/N 301206N120SGlenn Robert · Boulder, COBuilt 1958 · S/N 24-125N12134Everson Corey A · Madison, ALBuilt 1964 · S/N 24-3598N1220ZColumbus State Community College · Columbus, OHBuilt 1959 · S/N 24-800N1223Munning Joseph H Md · Jasper, INBuilt 1961 · S/N 24-2906N1236Entwistle Brian V · Knoxville, TNS/N 30-1167N123HMComanche Air LLC · Mokena, ILBuilt 1961 · S/N 24-2912N123LMMccleary Bryan W · Marion, OHBuilt 1967 · S/N 24-4669N123MKSolomon Steven · Cherry Hill, NJBuilt 1965 · S/N 26-141N124NREckhoff Daniel · Ramsey, MNBuilt 1960 · S/N 24-1839N126HJPeterson Charles William · Midway City, CABuilt 1969 · S/N 24-4878N126MAWinter Kristin A · Spring Lake Park, MNBuilt 1969 · S/N 30-1865
Back to AD 77-13-21