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.

N3937ZBundy Jerrian M · Anchorage, AKBuilt 1962 · S/N 18-7783N3938PSwoboda Matthias W · Green Bay, WIBuilt 1956 · S/N 22-3613N3938ZCooper Donald A · Casper, WYBuilt 1962 · S/N 18-7784N3939MMclaughlin Scott A · Defiance, IABuilt 1947 · S/N 12-2591N3939ZCarnine Daniel · Angora, NEBuilt 1962 · S/N 18-7785N3940ZGrasser Edward K · Palmer, AKBuilt 1963 · S/N 18-7786N3941MHilterbrand Drew S · Ninilchik, AKBuilt 1947 · S/N 12-2832N3942MKraft Duane J · Timber Lake, SDBuilt 1947 · S/N 12-2593N3942ZHigh Exposure Inc · Wilmington, DEBuilt 1962 · S/N 18-7867N3944MHebert Troxell S · Delta Jct, AKBuilt 1947 · S/N 12-2834N3944ZTasch Kenneth O · Chilton, WIBuilt 1962 · S/N 18-7801N3945PLiedtka Thomas M · Stevensville, MTBuilt 1956 · S/N 22-3620N3945ZKramer Thomas K Trustee · Anchorage, AKS/N 18-7802N3947PGilger Douglas D II · Boyes, MTBuilt 1956 · S/N 22-3622N3947ZVan Winkle James L · Wood Lake, NEBuilt 1962 · S/N 18-7805N3948PMoore Roger D · Lubbock, TXBuilt 1956 · S/N 22-3623N3948ZLiedtka Mark T · Stevensville, MTBuilt 1962 · S/N 18-7806N3949PGriggs Luz V · Goddard, KSBuilt 1956 · S/N 22-3626N3949ZBarrickman William A · Anchorage, AKBuilt 1962 · S/N 18-7807N3951PDuncan Kyle A · Whiteville, NCBuilt 1956 · S/N 22-3628N3952ZAtkins Ray H · Cantwell, AKBuilt 1962 · S/N 18-7810N3953ZMoore David W · Wasilla, AKBuilt 1962 · S/N 18-7812N3954PUecker Garrett J · Holdrege, NEBuilt 1956 · S/N 22-3631N3954ZThompson Charles M · Pierre, SDBuilt 1962 · S/N 18-7813N3955PBent Prop Club LLC · Waverly, IAS/N 22-3633N3955ZSipperley Bradford L · Fairbanks, AKBuilt 1962 · S/N 18-7815N3956PWheels Up LLC · Evansville, INBuilt 1956 · S/N 22-3634N3957MCarnahan Thomas L · Wasilla, AKBuilt 1947 · S/N 12-2856N3957ZAlsworth Leon R · Port Alsworth, AKBuilt 1962 · S/N 18-7818N3958PHoward Kevin B · Plymouth, MIBuilt 1956 · S/N 22-3636N3958ZWelstad Blaine L · Newburg, NDBuilt 1962 · S/N 18-7819N3959ZDld Corp · Ogden, UTBuilt 1962 · S/N 18-7821N3960MBales Gregory W · Enterprise, ORBuilt 1947 · S/N 12-2843N3961PMcquivey David · St George, UTS/N 22-3639N3963ZMusgrove Jimmy Wayne · Delta Junction, AKBuilt 1962 · S/N 18-7826N3964PWard Scot · Belgrade, MTBuilt 1956 · S/N 22-3644N3965PSlaughter Don Wayne · Farmville, NCFirst renewal noticeBuilt 1956 · S/N 22-3645N3965ZHarmon James E · Eagle River, AKBuilt 1962 · S/N 18-7850N3966ZLorence James E · Glennallen, AKBuilt 1962 · S/N 18-7852N3967ZDestination Alaska Air Service LLC · Homer, AKS/N 18-7857N3969BReid Brian M · Boise, IDBuilt 1946 · S/N 12-278N396LJJohnson Jeffrey L · Fargo, NDBuilt 1976 · S/N 18-7709002N3971MAllen Richard P · Southampton, NJBuilt 1947 · S/N 12-2599N3971PIsaak James A · Soldotna, AKBuilt 1956 · S/N 18-4762N3972MIntricate Bay Operating LLC · Saylorsburg, PAS/N 12-2900N3972PSc Super Cub LLC · Rosharon, TXBuilt 1956 · S/N 18-4763N3975ZKnefley Michael J · Ulysses, PAS/N 18-7914N3976MDickinson William S · Garysburg, NCS/N 12-2859N3977PPetrides Christopher James · Honolulu, HIBuilt 1956 · S/N 18-4768N3978MSchrier Timothy M · Savage, MNBuilt 1947 · S/N 12-2901
Back to AD 99-01-05 R1