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.

N8174PIglewski Rudolph Daniel II · Apache Junction, AZBuilt 1963 · S/N 24-3430N8174RAngel Aviation Inc · Peoria, AZBuilt 1980 · S/N 34-8070157N8174SCs74s LLC · Naples, FLBuilt 1980 · S/N 34-8070166N8174YStansbury Todd V · Centennial, COS/N 30-1289N8175CYates Trucking Inc · Quartz Hill, CABuilt 1975 · S/N 28R-7635132N8175PCunningham James L · Tucson, AZBuilt 1963 · S/N 24-3431N8176PHundley Jeffrey S · Parker, COBuilt 1963 · S/N 24-3432N817KBaquero Eric P · New Castle, COBuilt 1963 · S/N 24-3445N8180PGriffin Robert · Middletown, DES/N 24-3436N8180YG2g Aviation LLC · Wray, COBuilt 1966 · S/N 30-1296N8181PTascosa Trail Inc · Gruver, TXBuilt 1963 · S/N 24-3437N8182PFaulkner Ronnie L · Mount Ida, ARBuilt 1963 · S/N 24-3439N8184CRouse Michael R · Wilson, NCBuilt 1975 · S/N 28R-7635133N8186FN8186f Inc · Danville, INBuilt 1976 · S/N 32R-7780088N8186MNelson Justin S · Farr West, UTBuilt 1980 · S/N 348070179N8186RKarmic Aviation 1 LLC · Grand Rapids, MIBuilt 1980 · S/N 34-8070180N8186YHeiter Aviation Services LLC · Leesburg, INS/N 30-1303N8187PKlein Dale A · Mandan, NDBuilt 1963 · S/N 24-3443N8187YWhite Jack S · Boone, NCFirst renewal noticeBuilt 1966 · S/N 30-1304N8188PPurdy Bryan T · Bryant, ARBuilt 1963 · S/N 24-3444N8188XClark Anthony · Augusta, KSBuilt 1980 · S/N 34-8070182N8188YFly Anytime LLC · Kankakee, ILBuilt 1966 · S/N 30-1305N818YInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 30-1458N8191LAlton Aviation LLC · Daytona Beach, FLS/N 34-8070192N8191PN8191p LLC · Snowflake, AZS/N 24-3447N8192YPlane Fun Inc Tr Trustee · Snellville, GABuilt 1966 · S/N 30-1309N8193PFlying Crooner LLC · Orlando, FLBuilt 1963 · S/N 24-3449N8194PMarrs Walter Scott · Chino, CAS/N 24-3450N8195PBoddington Aviation LLC · Portland, TXBuilt 1963 · S/N 24-3451N8195ZWilliams Jason A · Cypress, TXS/N 34-8070212N8196PWorkman Randy · Tipp City, OHBuilt 1963 · S/N 24-3270N8197YTyer Larry E Jr · Newnan, GABuilt 1966 · S/N 30-1316N8198YRoss Brian L · Eagle River, WIBuilt 1966 · S/N 30-1317N819PDVah Aircraft Sales LLC · Pompton Beach, NJS/N 34-8070048N819RKWheels Up Aviation II Inc · Arlington Heights, ILBuilt 1977 · S/N 34-7770347N81DZAcceler8 Aviation LLC · Livermore, CABuilt 1978 · S/N 34-7870325N81LLJma Aviation LLC · Lakin, KSBuilt 1959 · S/N 24-1338N81MDTt Twins LLC · Fayetteville, GABuilt 1964 · S/N 30-512N81THStrand Christian P · Grand Rapids, MIBuilt 1978 · S/N 34-7870178N8200PSix Five Papa Inc · Temple, NHBuilt 1963 · S/N 24-3452N8201YTorqmation Inc · Houston, TXS/N 30-1320N8203PDell John J · Saint Clair Shores, MIBuilt 1963 · S/N 24-3455N8203YMn98 LLC · Belview, MNBuilt 1966 · S/N 30-1322N8204YBlue Steele LLC · Barnegat, NJBuilt 1966 · S/N 30-1324N8206PMente Charles E · Ocala, FLS/N 24-3458N8206YBauer Electric Inc · Winona, MNBuilt 1966 · S/N 30-1331N8207YTwinkie Air LLC · Colville, WAS/N 30-1333N8208PGallacher Edwin T · Salt Lake City, UTBuilt 1963 · S/N 24-3460N8208YAirswiss Inc · Wilmington, DEBuilt 1966 · S/N 30-1334N8209PFox Black Enterprises Inc · Kilmarnock, VABuilt 1963 · S/N 24-3461
Back to AD 97-01-01 R1