OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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:99-01-05-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:99-01-05-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.

N7540DVanhouten Eric · Tunkhannock, PAS/N 22-5270N7543DBerg Butch A · Duluth, MNBuilt 1957 · S/N 22-5274N7545KSnead Doug · Derby, KSBuilt 1950 · S/N 18-261N7547DHawkins Laurie M · Birch Run, MIBuilt 1957 · S/N 22-5278N754AKSarro Vincent P III · Wasilla, AKS/N 12-211N7550DBickers Kenneth N · Longmont, COBuilt 1957 · S/N 22-5281N7550KAmblin Antique Air Inc · Green Cove Springs, FLBuilt 1950 · S/N 18-266N7551DThibodeau Philip R · Newfields, NHS/N 22-5282N7551HDelta Management Corporation · Las Vegas, NVBuilt 1946 · S/N 12-418N7551LDe Jong Teunis Joshua · Maricopa, AZS/N 18-7509077N7555DHardwick James David · Midland, TXBuilt 1957 · S/N 22-5286N7555KDunbar Archie P · Whitewater, MTBuilt 1950 · S/N 18-270N7556ZUltra Ag Cropdusters LLC · Le Mars, IABuilt 1965 · S/N 25-3608N7557DRandolph David L · Adrian, MIBuilt 1957 · S/N 22-5288N7558DMaschuck Eric A · Elysburg, PABuilt 1957 · S/N 22-5289N7558KCudworth Jay P · Sheyenne, NDBuilt 1950 · S/N 18-273N7559DDelta Pacer LLC · New Iberia, LABuilt 1957 · S/N 22-5290N7559PSmith Joseph S · Renville, MNBuilt 1961 · S/N 18-7768N755SCWamberg Dodd D · Dover, NHBuilt 1955 · S/N 18-5253N7561DPatrick Hallett · Anchorage, AKBuilt 1957 · S/N 18-5838N7561HZurcher Michael W · Newburg, NDBuilt 1946 · S/N 12-430N7561KSumpter Carl W · Wasilla, AKBuilt 1950 · S/N 18-287N7562DRiek Ronald R · Woodville, WIS/N 18-5839N7562HGrigsby Guy P · Glenburn, NDS/N 12-431N7564DOtto Bryant C · Conway, ARBuilt 1957 · S/N 18-5846N7564KCameron James T · Seldovia, AKBuilt 1950 · S/N 18-279N7565KReeder Don W · Rathdrum, IDBuilt 1950 · S/N 18-280N7566KHorseshoe Bar Land & Livestock LLC · Gillette, WYBuilt 1950 · S/N 18-283N7567HGuidici Aidan G · San Antonio, TXS/N 12-437N7569DThiele Tamara L · Anchorage, AKBuilt 1957 · S/N 18-5854N7569HCompton Steven · East Northport, NYBuilt 1946 · S/N 12-439N7570HSearles Lewis A Jr · Grafton, OHBuilt 1946 · S/N 12-440N7570KStrub Henry J · Dillingham, AKBuilt 1950 · S/N 18-285N7570ZKingsley Kiman J · Miller, MOBuilt 1965 · S/N 25-3631N7571HChristman Christopher D · Chugiak, AKBuilt 1946 · S/N 12-441N7572HStark Jeffrey J · Fairbanks, AKBuilt 1946 · S/N 12-442N7573HSugden Richard M · Hallock, MNBuilt 1946 · S/N 12-444N7573KPeile Kelly · Lakeview, ORBuilt 1953 · S/N 18-290N7574DDixon Thomas R · Lance Creek, WYBuilt 1957 · S/N 18-5861N7574HMiller Thomas L · Ennis, MTBuilt 1946 · S/N 12-445N7574KPhair David E · Dixfield, MEBuilt 1950 · S/N 18-291N7574PMatark Corp · Pullman, WABuilt 1962 · S/N 18-7793N7575KLitzen Guide Service Inc · Kenai, AKBuilt 1950 · S/N 18-292N7576DGarner Joseph A · Healy, AKBuilt 1957 · S/N 18-5863N7576HSerbagi Casey R · Andover, MABuilt 1946 · S/N 12-447N7576KPetersen Jacob R · Wasilla, AKS/N 18-293N7577DMagnusson Dwayne D · Anchorage, AKBuilt 1958 · S/N 18-5864N7578ZSilent Flight LLC · Payette, IDBuilt 1965 · S/N 25-3651N7579DNutter Teri L · Glennallen, AKBuilt 1957 · S/N 18-5867N7579HDolansky Edwin J · Youngstown, NYBuilt 1946 · S/N 12-454
Back to AD 99-01-05 R1