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.

N27053Hill Jeffry J Jr · Woodstock, ILBuilt 1940 · S/N 5-20N27059Confederate Air Inc · Tillar, ARS/N 5-22N27065Whatley Aviation Ltd · Flower Mound, TXBuilt 1940 · S/N 4331N27069Briard Ashley · Frazee, MNBuilt 1940 · S/N 4-1006N2706MEs LLC · Tulsa, OKBuilt 1946 · S/N 12-1209N2706PFraser William G · Berkley, MABuilt 1955 · S/N 22-3012N27070Bagley Paul S · Cumming, GABuilt 1940 · S/N 5-23N27078Martin Ronald P · Tehachapi, CABuilt 1940 · S/N 4-1009N27079Mincer Robert C · Middlesex, NYBuilt 1940 · S/N 4342N2707MKarpik Joseph Paul · Floodwood, MNBuilt 1946 · S/N 12-1210N27083Guilfoyle Glenn · Van Hornesville, NYBuilt 1940 · S/N 4-1013N27089Kansas Air LLC · Linn, KSS/N 4298N2708MKiceniuk Taras · Santa Paula, CAS/N 12-1211N27092Hawk Robert S · Argyle, TXBuilt 1940 · S/N 4350N27099Koepl Steven W · Post Falls, IDBuilt 1940 · S/N 4-1018N2709PRuble Marsha L · Aurora, ORBuilt 1955 · S/N 22-3015N270JSAubin Carol · Bangs, TXFirst renewal noticeBuilt 1940 · S/N 5-18N270TAChristie Ian A H · Limon, COS/N 18-2384N270WCState Of Alaska Dept Of Fish And Game · Palmer, AKBuilt 1954 · S/N 18-3920N27106Clements Marcelaine A D · Edgerton, WIBuilt 1940 · S/N 527N27120Albertson James M · Westville, FLS/N 4385N27129Rodenberg James D · Wolf Point, MTBuilt 1940 · S/N 5-31N2712MCardinal Adventures LLC · Green Bay, WIBuilt 1946 · S/N 12-1127N27132Osborne Brian D · Shoreline, WABuilt 1940 · S/N 4380N27135Barr Myron · Spanaway, WAFirst renewal noticeBuilt 1940 · S/N 4377N2713MBeacon West LLC · Billings, MTBuilt 1946 · S/N 12-1126N2714PGeller Glen C · Beaverton, ORBuilt 1955 · S/N 22-3020N27154Heekin Michael P · Hummelstown, PABuilt 1940 · S/N 4399N27159Murray Craig P · Hagaman, NYBuilt 1940 · S/N 5-38N2715PNefstead Charles R · Willmar, MNBuilt 1955 · S/N 22-3021N2716PNeno Richard J · Ithaca, NYBuilt 1957 · S/N 22-5280N27171Reyn/Craft Wildside Aviation LLC · Athens, ILS/N 5-39N2718MLibby Justin C · Anchorage, AKBuilt 1946 · S/N 12-1215N27198South Central Ozarks Flying Group LLC · Willow Springs, MOBuilt 1940 · S/N 5-45N2719MCenter Charles C · Wasilla, AKBuilt 1946 · S/N 12-1216N271CCL-Bird LLC · Hood River, ORBuilt 2000 · S/N 9918CCN271DLAg Flyers LLC · Fort Pierce, FLS/N 18-91N271TSmith James L · Asheville, NCS/N 18-2385N2720MCalderwood Kenneth E · Kenai, AKBuilt 1946 · S/N 12-1220N2720PLeguia Augusto A · Kathleen, GAS/N 22-3026N2722MInfinity Aviation LLC · Piedmont, SDBuilt 1946 · S/N 12-1133N2726PDehaan Nathan M · Bethel, AKBuilt 1955 · S/N 22-3032N2728PBrown James A · Fairbanks, AKBuilt 1955 · S/N 22-3034N27293Williams Steven C · Anchorage, AKBuilt 1954 · S/N 18-3367N272CCFarkas Jordan C · Anchorage, AKBuilt 2001 · S/N 9925CCN2732MEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1946 · S/N 12-1225N27347Cochran Douglas C · Saranac Lake, NYBuilt 1954 · S/N 18-4032N2734MGraves Dorel E · Danville, INBuilt 1946 · S/N 12-1226N2735MScott Chase · Anchorage, AKBuilt 1946 · S/N 12-1138N2735PTaylor William W Jr · Hudson Oaks, TXBuilt 1955 · S/N 22-3042
Back to AD 99-01-05 R1