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.

N5844HMccoy David L · Bear Creek, WIS/N 16-463N5844ZJohnk Willi C II · Donalds, SCBuilt 1963 · S/N 22-9698N5846HTop Flight Detail LLC · Middlebury, INS/N 16-465N5848HWhite Terry W · Saint Joseph, MIBuilt 1949 · S/N 16-467N5850ZMiller Helen J · Springfield, OHBuilt 1963 · S/N 22-9705N5851DRubbert Lorin E · Reynolds, NDBuilt 1956 · S/N 22-4530N5851ZBurklund Joel H · Minneapolis, MNBuilt 1963 · S/N 22-9706N5852DPierce Stephan L · Graham, TXS/N 22-4531N5852HKelley Don Lee · Loon Lake, WABuilt 1949 · S/N 16-462N5852ZTuttle James R · Cherryvale, KSS/N 22-9708N5853DHapka Leon J · Halma, MNBuilt 1956 · S/N 22-4532N5854DPro West Air LLC · West Point, UTS/N 22-4533N5855DMiller Justin · Boaz, ALBuilt 1956 · S/N 22-4534N5855HNortheast Cub LLC · Hudson, NYS/N 16-473N5856DStephen George · Land O Lakes, WIBuilt 1956 · S/N 22-4535N5856HWaco West Inc · Dover, DEFirst renewal noticeBuilt 1949 · S/N 16-474N5856ZHankins Jon A · Fort Mohave, AZBuilt 1963 · S/N 22-9712N5858HKoch Michael R · Nemo, SDBuilt 1949 · S/N 16-478N5859ZInternational Air Services Inc Trustee · Carson City, NVBuilt 1963 · S/N 22-9716N5860DMunnerlyn Richard L · Sherwood, ARBuilt 1956 · S/N 22-4539N5861DCash David L · Owasso, OKBuilt 1956 · S/N 22-4540N5862ZBitton Robert L · Corbett, ORBuilt 1963 · S/N 22-9719N5863ZGarner James H III · Sun Lakes, AZBuilt 1963 · S/N 22-9720N5864ZPeterson Josh · Paso Robles, CAS/N 22-9722N5865DWalter John Edward · Wewoka, OKS/N 22-4544N5866DCheuvront Jevon · Seminole, TXBuilt 1956 · S/N 22-4545N5866HOsmundson John C · Tenino, WAS/N 16-485N5867ZDraughon Charles V · Easley, SCBuilt 1963 · S/N 22-9730N5868DObritsch Monte R · Malcolm, NEBuilt 1956 · S/N 22-4547N5868HStein John R · Central Lake, MIBuilt 1949 · S/N 16-487N5869DDorsch Zachary William · Nampa, IDS/N 22-4548N5871ZJohnson Nathan P · Rapid City, SDBuilt 1963 · S/N 22-9729N5872ZCollins James T · Blossvale, NYBuilt 1963 · S/N 22-9728N5873ZSchramm Thomas L · South Rockwood, MIBuilt 1963 · S/N 22-9731N5874DFeuerborn Ethan T · Boise, IDBuilt 1960 · S/N 187453N5874HKing William A · Adams Run, SCS/N 16-494N5874ZGodbey Patrick · St Simons Island, GABuilt 1963 · S/N 22-9732N5875HPresten Eric A · Vineburg, CABuilt 1949 · S/N 16-493N5875ZReed John F · Bemus Point, NYBuilt 1963 · S/N 22-9733N5876DKirkendall James · N Richlnd Hls, TXBuilt 1956 · S/N 22-4557N5876ZDraper Scott · Rutland, VTBuilt 1963 · S/N 22-9736N5878HDelaware Taildraggers LLC · Hancock, NYBuilt 1949 · S/N 16-495N5879HParlin Larrol L · Friday Harbor, WABuilt 1949 · S/N 16-497N587PAVan Hatten Michael Sr · Fairbanks, AKBuilt 1989 · S/N 1809033N587TPPockrus Pat B · Mineral Wells, TXBuilt 1958 · S/N 22-587N5881DKanooth Michael L · Washougal, WABuilt 1956 · S/N 18-5305N5881HGazda Jerry V · Granbury, TXBuilt 1949 · S/N 16-501N5883ZMckernan Thomas H · Gabriels, NYBuilt 1963 · S/N 22-9745N5884DMcmahan Johnny W · Gakona, AKBuilt 1956 · S/N 18-5308N5885DConatser Shawn C · Fairbanks, AKBuilt 1956 · S/N 18-5309
Back to AD 99-01-05 R1