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.

N8998PMoore Jeffrey · Oceanside, CABuilt 1966 · S/N 24-4459N8999PBednorski Craig A Trustee · Grass Valley, CABuilt 1966 · S/N 24-4376N89GBHerrington Kevin · Honey Grove, TXS/N 24-4779N89HHStrissel Christopher A · Hilton Head Island, SCBuilt 1971 · S/N 28R-7135225N89MJAustin Dallas V · Lillington, NCS/N 32R-7780276N89SDState Of South Dakota · Pierre, SDBuilt 1979 · S/N 34-8070089N89SPSky'S The Limit Flying Club Inc · Findlay, OHBuilt 1976 · S/N 28R-7635218N8FTop Flight Aviation Inc · Corona, CAS/N 30-1312N8FNValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N 28R-7837272N8HNSol Property Group LLC · Rosenberg, TXBuilt 1975 · S/N 28R-7535277N8LBHill Mark Daniel · Magnolia, TXBuilt 1969 · S/N 30-1788N8MZSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 301648N8PXFly Casual LLC · Sacramento, CABuilt 1972 · S/N 39-144N8TDCaldwell Henry H Jr · Las Vegas, NVS/N 34-7770257N9004PFlying R Aviation LLC · Cherokee, IAS/N 24-4465N9005PKasakoff Lloyd · Diamond Bar, CAS/N 24-4466N9006FSeasky27 Productions LLC · Forked River, NJBuilt 1976 · S/N 32R-7780121N9006PSage Building Construction Inc · Roosevelt, UTBuilt 1966 · S/N 24-4467N9007PKoval Andor A · Yerington, NVBuilt 1966 · S/N 24-4468N9008PStarnes William H · Eureka Springs, ARBuilt 1966 · S/N 24-4469N900DCRognerud Edward J · Rosemount, MNBuilt 1970 · S/N 39-20N900DDN900dd Inc · Ramona, CAS/N 34-7970270N900GPPerkins E G Jr · Greenwood, MSBuilt 1966 · S/N 24-4464N900JLRed Baron LLC · Pooler, GAS/N 32R-7680181N900PHSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-30302N9011CParios Vasilios · Northfield, MAS/N 28R-7803243N9012KDerbyshire William · Davie, FLBuilt 1977 · S/N 28R-7803057N9013PRegistered aircraftBuilt 1966 · S/N 24-4474N9014PSherback Michael A · Mountain View, CABuilt 1965 · S/N 24-4475N9016PRegistered aircraftBuilt 1966 · S/N 24-4477N9019PReeves Robert Lincoln · Charlotte, NCBuilt 1966 · S/N 24-4480N901BBVisual Group Inc · Tampa, FLBuilt 1974 · S/N 28R-7435256N901BWKraft Tyrone H · Timber Lake, SDBuilt 1976 · S/N 32R-7680451N901EGK Mcdaniel LLC · Mesa, AZBuilt 1977 · S/N 34-7770426N901KASpiegel Richard J · Sun City, AZBuilt 1973 · S/N 34-7450045N9020PLindsay Terry M · West Hills, CABuilt 1966 · S/N 24-4482N9021PFontenot Monty Jason · Aiken, SCBuilt 1966 · S/N 24-4483N9022KRyczek Walter Alan · Huntersville, NCBuilt 1977 · S/N 28R-7803059N9022PAcc Air Charter Company · Wilmington, DEBuilt 1966 · S/N 24-4484N9023PHand Joseph Michael · Sheboygan Falls, WIBuilt 1966 · S/N 24-4485N9024PBlue Skies Above LLC · Bogart, GABuilt 1966 · S/N 24-4486N9025PIdeation Machine LLC · Las Vegas, NVS/N 24-4487N9028PBray Nick R Trustee · China Spring, TXBuilt 1966 · S/N 24-4490N9029PEzzell Stephen Mark · Statesville, NCS/N 24-4491N9030PPaso Rio LLC · Bouse, AZS/N 24-4492N9033PMiddletown LLC · Chandler, AZBuilt 1966 · S/N 24-4495N9034PNational Test Pilot School · Mojave, CABuilt 1966 · S/N 24-4496N9037PJack Ryan Aviation · Woodcliff Lake, NJS/N 24-4500N9042PWt Del Pl LLC · Newark, DEBuilt 1966 · S/N 24-4505N90496Palmetto Aviation Of Charleston LLC · Johns Island, SCBuilt 1977 · S/N 32R-7780353
Back to AD 97-01-01 R1