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.

N8487YAviation Safety Dynamics LLC · Richmond, TXBuilt 1967 · S/N 30-1650N8489FRegistration Pending · San Diego, CARegistration pendingBuilt 1976 · S/N 34-7770088N8489YSorbi Aviation Inc · El Cajon, CABuilt 1967 · S/N 30-1652N8491PHansen Jed D · Clark, SDBuilt 1965 · S/N 26-70N8492YGaipa Timothy A · Saint Joseph, MIBuilt 1967 · S/N 30-1655N8493CPlante Matthew · Blackstone, MABuilt 1976 · S/N 32R-7680118N8493PKeystone Flyer LLC · Avon, INS/N 26-73N8495CMtl Inc · Sparta, TNBuilt 1976 · S/N 32R-7680119N8496YOsiol Russell E · Chicago, ILS/N 30-1297N8497PCrotts Leigh O · Peoria, AZBuilt 1964 · S/N 26-77N8498FJones Teddy · Sevierville, TNS/N 32R-7780105N8498PMiller Marc D Trustee · Tempe, AZBuilt 1964 · S/N 26-78N8499FArrow Inc · Rockford, MIBuilt 1976 · S/N 32R-7780106N849BTPeacock Group LLC · Clermont, FLBuilt 1974 · S/N 28R-7535095N84ARArc Aviation LLC · Auburn, ALBuilt 1977 · S/N 28R-7737099N84JPNichols John E · Bogalusa, LABuilt 1964 · S/N 26-67N84JSKocak Robert G Jr · Peoria, AZBuilt 1966 · S/N 30-1222N84TDBailey Dennis · Kernersville, NCBuilt 1969 · S/N 30-1951N84VKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-1492N8502VAngel Aviation Inc · Peoria, AZBuilt 1973 · S/N 34-7350252N8503YRoberti John O · Barre, VTBuilt 1967 · S/N 30-1662N8505YCli Aerospace LLC · Appleton, WIBuilt 1968 · S/N 30-1665N8506YWilliams Russell D · Rehoboth Beach, DEBuilt 1967 · S/N 30-1666N8507YWhiteley Robert L · Pittsburg, CABuilt 1967 · S/N 30-1667N8508CHobart Aviation Inc · Akron, OHBuilt 1976 · S/N 28R-7635164N8509PWalsh Robert A · Katy, TXBuilt 1964 · S/N 26-89N850NCRegistered aircraftBuilt 2002 · S/N 2844074N850PIftikhar Naveed · Tempe, AZBuilt 1979 · S/N 34-7970422N8510FSkyline Utilities Inc · Brainerd, MNBuilt 1976 · S/N 34-7770089N8511PWiebe Aron F · Seminole, TXBuilt 1965 · S/N 26-91N8512YSager Garrett · Fort Worth, TXBuilt 1967 · S/N 30-1672N8513CBranscome Julius L · Woodbridge, VABuilt 1976 · S/N 32R-7680121N8513YCrane Douglas Gordon · Coquille, ORBuilt 1967 · S/N 30-1673N8514CSpirit Air Inc · Salmon, IDBuilt 1976 · S/N 34-7670147N8514YMcnally Rodney · Sonora, CABuilt 1967 · S/N 30-1675N8515PJohnson Gary Paul · West Jordan, UTBuilt 1964 · S/N 26-52N8515YPiper Aviation Museum Foundation · Lock Haven, PABuilt 1967 · S/N 30-1676N8519PHubbard William A · Blair, OKS/N 26-99N8520PJones Terry W · Houston, TXBuilt 1965 · S/N 26-100N8523YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1684N8525PThorstenson Joseph · Norwalk, CTBuilt 1965 · S/N 26-105N8526PFisher Robin D · Corona, CABuilt 1964 · S/N 26-106N8526YCarlile John D · The Villages, FLBuilt 1968 · S/N 30-1687N8527YHatbright Farm LLC · Wilmington, DEBuilt 1968 · S/N 30-1688N8528YYoung David A · Lakeland, FLBuilt 1968 · S/N 30-1689N852ATWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250258N8530YMouat Michael W · Hemet, CABuilt 1968 · S/N 30-1691N8533PJacobs Aviation LLC · Mount Juliet, TNS/N 26-114N8535EAmerican Compressor Flight Inc · Santa Fe Springs, CABuilt 1976 · S/N 32R-7680150N8535PSecond Life Flight Inc · Delray Beach, FLBuilt 1964 · S/N 26-116
Back to AD 97-01-01 R1