OpenAirDocs.org
AD 76-23-03 R1

Registered aircraft · 559

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:76-23-03-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:76-23-03-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.

N6574VHandke Robert C · Atchison, KSBuilt 1969 · S/N 30250N6575VGreeson Albert O · Moscow, KSBuilt 1970 · S/N 32-22N6580VStassen Andrew R · Concord, CABuilt 1969 · S/N 32-16N6582VMonroe Robert Sean · Oceanside, CABuilt 1969 · S/N 30256N6583VLedger William V Jr · Shreveport, LABuilt 1969 · S/N 32-20N6588VIsom Stephen R · Eagle, COBuilt 1970 · S/N 30265N6591VEpic Air Power LLC · Newark, DES/N 32-29N6597VGold Air LLC · Woodland Hills, CABuilt 1970 · S/N 32-24N65JKAmerican Aircraft & Marine LLC · Indianapolis, INBuilt 1973 · S/N 74-30641N6600VLeahy Thomas J · Marblehead, OHBuilt 1970 · S/N 30261N6601VJofredo Corp · Zephyrhills, FLBuilt 1970 · S/N 30294N6603VCmbb Enterprises LLC · Plainview, TXBuilt 1970 · S/N 30275N6604VKidd Clifford L · Monahans, TXS/N 30267N6605VWaller Earl D · Wyoming, DEBuilt 1970 · S/N 30280N6607VGlovier George G · Pocomoke City, MDBuilt 1970 · S/N 30262N6622VBetts Miley · Highlands Ranch, COBuilt 1970 · S/N 30270N6625VHarais James W · Novato, CABuilt 1970 · S/N 30285N6632VKlamecki Alan P · Phoenix, AZBuilt 1970 · S/N 30300N6635VBerger Aerospace LLC · Tomball, TXS/N 30302N6636VMoss Herman D · Centreville, VABuilt 1970 · S/N 32-32N6639VWaiwood Michael · Strongsville, OHBuilt 1970 · S/N 30298N6642VCasey Joseph · Buffalo, WYBuilt 1970 · S/N 30297N6643VSullivan Hal N Administrator · Paducah, KYBuilt 1970 · S/N 30283N6644VHeminger Rex A · Colleyville, TXBuilt 1970 · S/N 30281N6645VBrown Christopher C · Sheridan, WYBuilt 1970 · S/N 30309N6646VBelush Richard · Columbus, INBuilt 1970 · S/N 30292N6650VHarris Willis J · Letts, IABuilt 1966 · S/N 30001N6651VDunbar Stephen E Trustee · Broken Arrow, OKBuilt 1966 · S/N 30003N6652VLaughlin David E · Rapid City, SDS/N 30005N6662VOlson Larry L · Timmonsville, SCBuilt 1967 · S/N 30026N6665VBetts Miley F · Highlands Ranch, COBuilt 1967 · S/N 30035N666RREllis James F · Culver City, CABuilt 1973 · S/N 74-30632N666RSLoney James A Trustee · West Chesterfield, NHBuilt 1979 · S/N 79-30936N6670VCollum Aviation LLC · Milton, FLS/N 30021N6675VBrazier Glen A · Greenbush, MNBuilt 1967 · S/N 30033N6677VFandrich Abraham L · Clancy, MTS/N 30020N6685VHeirborne LLC · Kansas City, MOS/N 30041N6686VRegistered aircraftBuilt 1967 · S/N 30050N6687VOsterberg Douglas L · Neenah, WIBuilt 1967 · S/N 30029N6688VBesch Marvin Eugene II · Redmond, WABuilt 1967 · S/N 30017N6689VSchafer Daniel B J · Plainview, TXBuilt 1967 · S/N 30039N6694VNieting James · Minnetonka, MNBuilt 1967 · S/N 30012N6696VMccollough William B · Murrells Inlet, SCS/N 30008N6697VCleveland Lorne T · Tyler, TXS/N 30006N66HSAlbertson Jon E · Helena, MTBuilt 1973 · S/N 73-30595N6703VVanias Polychronis · Leroy, MIBuilt 1970 · S/N 30282N6706VThompson Timothy · Prosser, WAS/N 30332N6709VBlanton Keith O · Collinsville, OKBuilt 1970 · S/N 30310N6712VBainer Kyle W · Cottage Grove, WIBuilt 1970 · S/N 30307N678MJPiasa LLC · Pacific, MOBuilt 1979 · S/N 79-30941
Back to AD 76-23-03 R1