OpenAirDocs.org
AD 91-21-01 R1

Registered aircraft · 5,086

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

N9344PWheeler R Tyson · Frederick, MDBuilt 1969 · S/N 24-4843N9345PRegistration Pending · Gilbert, AZRegistration pendingBuilt 1969 · S/N 24-4844N9347PRegistered aircraftBuilt 1969 · S/N 24-4846N93486Ablamis Roger · Los Gatos, CABuilt 1973 · S/N 73-31062N934PHRossell Holdings LLC · Astoria, ORBuilt 1974 · S/N 32-7540059N93505Clark Roger D · Lubbock, TXBuilt 1973 · S/N 73-32-120N9353PSmith Evan B · Mechanicsville, VABuilt 1969 · S/N 24-4854N93541Gibbs Frederick L · Flagstaff, AZBuilt 1973 · S/N 73-32-126N93554Pittman Randy L · Morris, ILBuilt 1973 · S/N 74-31074N9356PMente Charles · Homestead, FLBuilt 1969 · S/N 24-4856N93570Huffaker Kenneth Scott · Post, TXBuilt 1973 · S/N 73-32-116N9358PJeneson Tim · Ketchum, IDBuilt 1969 · S/N 24-4858N9359PCarter James D · Carlton, TXBuilt 1969 · S/N 24-4859N93600Babcock Barry B · Monument, COS/N 73-31061N93657Jewett Lucas D · Helena, MTS/N 76-31123N9369PLoadstone Aviation LLC · Billings, MTBuilt 1969 · S/N 24-4869N93710Obrian Brandon · Travelers Rest, SCS/N 73-32-121N9372PBeery Milo A · Clarinda, IABuilt 1969 · S/N 24-4872N9373PLeff Benjamin Franklin · Cedar Park, TXBuilt 1969 · S/N 24-4873N9379PAerodata Inc · Edgewater, MDBuilt 1969 · S/N 24-4880N9380KResource And Management Group Ltd · Cheyenne, WYFirst renewal noticeBuilt 1976 · S/N 32R-7680211N9380PEchelmeier Stanton M · Fort Payne, ALBuilt 1969 · S/N 24-4881N9381PSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-4882N9382PRegistered aircraftBuilt 1969 · S/N 24-4883N9383RSmith Casey B · Springer, OKS/N 905-14N9384PDarling Rob K Dds · Venice, FLBuilt 1969 · S/N 24-4885N9385CRobinson Steven Christopher · Enid, OKS/N 32R-7885046N9386PWilson Jay · Omro, WIBuilt 1969 · S/N 24-4887N938PMD & B Aviation LLC · Stroudsburg, PABuilt 1983 · S/N 31-8452013N9390PFlaherty Stephen · El Paso, TXBuilt 1969 · S/N 24-4891N9391PRusty Ventures LLC · Watertown, SDS/N 24-4893N9392KDevils Lake Aero LLC · Devils Lake, NDBuilt 1976 · S/N 32R-7680219N9393PBoucher Bobbi · Fredericksburg, VABuilt 1969 · S/N 24-4895N9394PS A Freight International Inc · San Antonio, TXBuilt 1969 · S/N 24-4897N9395PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1969 · S/N 24-4898N9396PTrom Michael S · Lake Ozark, MOBuilt 1969 · S/N 24-4899N9397PStarritt Mark C · Hollister, CABuilt 1969 · S/N 24-4901N9398PS & T Aviation LLC · Meriden, IABuilt 1969 · S/N 24-4902N939CAMcs Aviation LLC · Larned, KSBuilt 1965 · S/N 24-4222N93CDDe Leon Jonas · New York, NYBuilt 1993 · S/N 27-0153N93PNHawkins Steven L · Grand Prairie, TXBuilt 1974 · S/N 32-7440091N93RJStamm David · Lake Almanor, CAS/N 4622130N93VBSky Blue Inc · Wilmington, DEBuilt 1978 · S/N 32R-7887176N9400PKoretsky Aviation LLC · Fairless Hills, PABuilt 1969 · S/N 24-4904N9402PSteinberg Franklyn C III · Flemington, NJBuilt 1969 · S/N 24-4907N9407PHoefle Aviation Inc · Wilmington, DEBuilt 1969 · S/N 24-4912N9409PDormond Brent C · Glendale, CABuilt 1969 · S/N 24-4914N9411PHomsi Joseph · Dover, NJBuilt 1970 · S/N 24-4916N9412PJ L Darr And Son Inc · High Point, NCBuilt 1969 · S/N 24-4917N9419PGreene Joseph B · Shafer, MNBuilt 1969 · S/N 24-4925
Back to AD 91-21-01 R1