OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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:97-01-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:97-01-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.

N9380CKillion Jerry · Lubbock, TXBuilt 1978 · S/N 28R-7803256N9380KResource 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-4882N9382NGarapati Prasad S · Mount Airy, MDBuilt 1969 · S/N 28R-35091N9382PRegistered aircraftBuilt 1969 · S/N 24-4883N9383NHall John G · Morrilton, ARBuilt 1969 · S/N 28R-35092N9384PDarling Rob K Dds · Venice, FLBuilt 1969 · S/N 24-4885N9386NMays David J · Lincolnton, NCBuilt 1969 · S/N 28R-35096N9386PWilson Jay · Omro, WIBuilt 1969 · S/N 24-4887N9390NDenison Flying Club LLC · Denison, IABuilt 1969 · S/N 28R-35100N9390PFlaherty 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-7680219N9392NWilder Bradley Alton · Cypress, TXBuilt 1969 · S/N 28R-35102N9393PBoucher Bobbi · Fredericksburg, VABuilt 1969 · S/N 24-4895N9394NWeller James Alan · Barnesville, GABuilt 1969 · S/N 28R-35104N9394PS 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-4901N9398NCraige Danny D Trustee · Durant, OKBuilt 1969 · S/N 28R-35109N9398PS & T Aviation LLC · Meriden, IABuilt 1969 · S/N 24-4902N9399NYankcub LLC · North Charleston, SCBuilt 1969 · S/N 28R-35110N939AZAz2025 LLC · Miami, FLBuilt 1972 · S/N 34-7250168N939CAMcs Aviation LLC · Larned, KSBuilt 1965 · S/N 24-4222N93BDColeman William R · Jasper, ARBuilt 1967 · S/N 30-1433N93CCRps Aviation Group LLC · Slinger, WIBuilt 1977 · S/N 28R-7803157N93JNPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1980 · S/N 34-8070175N93TJSale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 28R-35026N93WABranciforte Louis N · Watsonville, CABuilt 1977 · S/N 34-7770390N9400PKoretsky Aviation LLC · Fairless Hills, PABuilt 1969 · S/N 24-4904N9401CRegistered aircraftBuilt 1978 · S/N 28R-7837197N9401NJanes Charles Dale · Cleburne, TXBuilt 1969 · S/N 28R-35112N9402PSteinberg Franklyn C III · Flemington, NJBuilt 1969 · S/N 24-4907N9404N9404n LLC · Brush Prairie, WABuilt 1969 · S/N 28R-35115N9407PHoefle Aviation Inc · Wilmington, DEBuilt 1969 · S/N 24-4912N9408NCope Parrish B · Lemoore, CABuilt 1969 · S/N 28R-35120N9409PDormond Brent C · Glendale, CABuilt 1969 · S/N 24-4914N940TCMusser John R · Freeport, ILBuilt 1975 · S/N 28R-7535320N9411NFeicht Robert E · Rincon, GABuilt 1969 · S/N 28R-35123N9411PHomsi Joseph · Dover, NJBuilt 1970 · S/N 24-4916N9412PJ L Darr And Son Inc · High Point, NCBuilt 1969 · S/N 24-4917N9413NMartin Bernard · Maricopa, AZBuilt 1969 · S/N 28R-35126N9414PRegistered aircraftBuilt 1969 · S/N 24-4919N9415NSky Bound LLC · Wyoming, MIBuilt 1969 · S/N 28R-35127N9417KWest Bend Air Inc · West Bend, WIBuilt 1976 · S/N 28R-7635236N9417NPrescott Milton B Jr · Glendive, MTBuilt 1969 · S/N 28R-35129N9419PGreene Joseph B · Shafer, MNBuilt 1969 · S/N 24-4925N941NZCumplido Luis · Rumford, RIBuilt 1977 · S/N 28R-7737172
Back to AD 97-01-01 R1