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.

N4862YKohler Richard L · Moriarty, NMBuilt 1968 · S/N 25-4665N4863ARud Alexandra E · Clara City, MNBuilt 1956 · S/N 22-4022N4863ZIvy James H III · Seligman, AZBuilt 1961 · S/N 22-8439N4864MStrawhorn Marcus A · Indianapolis, INBuilt 1947 · S/N 11-382N4865HPrice Ronald W · Sonoma, CABuilt 1949 · S/N 17-165N4865MLawrence David D · Roanoke, VABuilt 1947 · S/N 11-383N4865ZSchroer Steven K · Columbus, INBuilt 1961 · S/N 22-8442N4866MHammons Gordon D · Wilson, WIBuilt 1947 · S/N 11-384N4867MReed Cameron C · Florala, ALBuilt 1947 · S/N 11-385N4868HBjoin Paul R · Janesville, WIBuilt 1948 · S/N 17-168N4868MOwens Steven B · Almo, KYBuilt 1947 · S/N 11387N4869ANevill Bernard L · Clare, MIBuilt 1956 · S/N 22-4029N4869MLaney Kristen V · Maiden, NCBuilt 1947 · S/N 11-388N4870HBeery Harvey Lee · Kelseyville, CABuilt 1948 · S/N 17-155N4870MMoore Robert A · Sherwood, ARBuilt 1947 · S/N 11-389N4871BMeise Fred Walter · Moses Lake, WAS/N 18-4967N4871MJokhy Michael P · Wasilla, AKS/N 11-391N4872AIdaho Wool Growers Assn · Boise, IDFirst renewal noticeS/N 18-4969N4873APapp Jacob R · Fort Edward, NYS/N 18-4971N4873MParsons Anthony C · Sweetwater, TNBuilt 1947 · S/N 11-390N4873YCherry Hill Aviation Inc · Freetown, INBuilt 1968 · S/N 25-4675N4875ZRice Gary W · San Antonio, TXBuilt 1961 · S/N 22-8454N4876HWhitmore Keith A · Alexandria, LAS/N 17-175N4876MJones Derick · Moultonborough, NHBuilt 1947 · S/N 11-394N4877MHorton Thomas James · Salem, WIBuilt 1947 · S/N 11405N4878AMallek Edward J · Fairbanks, AKBuilt 1956 · S/N 18-4977N4879HMichel Paul J · O Brien, FLBuilt 1948 · S/N 17-178N4879ZRobert P Brown Inc · Beatty, ORS/N 22-8460N4880MAlarado Aviation LLC · Chugiak, AKBuilt 1947 · S/N 11-408N4881AAmstrup Jeremy T · Fairbanks, AKS/N 18-4981N4881HGbq LLC · New Prague, MNBuilt 1949 · S/N 17-180N4882AWilliams Donald B · Wingate, NCS/N 18-4982N4882HBurrell Steven L · Lumberton, MSBuilt 1948 · S/N 17-181N4883HThissen Gary L · Mankato, MNBuilt 1948 · S/N 17-182N4884AGarfield Joe T · Morgan, UTBuilt 1956 · S/N 18-4985N4885MRiggin Flight Service Inc · Madison, SDBuilt 1947 · S/N 11-410N4885ZReed Michael D · Parsons, KSBuilt 1961 · S/N 22-8467N4886ACook Timothy D · Ashville, NYBuilt 1956 · S/N 18-4987N4886HWinkler Warren · North Port, FLBuilt 1948 · S/N 17-186N4886MPayne William E · Elizabeth, COBuilt 1947 · S/N 11411N4888MKissenger Richard G · Centre Hall, PABuilt 1947 · S/N 11-412N4888ZFrancom Jeffery S · Malad City, IDS/N 22-8470N488XHSchulze Thomas A · Bloomville, OHS/N 4-1525N4890PSale Reported · Willow, AKSale reportedBuilt 1961 · S/N 18-7762N4891MRich Jeffrey P · Graham, NCBuilt 1947 · S/N 11-415N4894AHagenston Arthur J · Fairbanks, AKBuilt 1956 · S/N 18-4996N4895AHigh Exposure Inc · Wilmington, DEBuilt 1956 · S/N 18-4997N4895HVon Bernewitz David Alfred · Myersville, MDFirst renewal noticeBuilt 1948 · S/N 17-196N4897MCauv LLC · Cincinnati, OHBuilt 1947 · S/N 11-423N4897YKnutson Wayne R · Tioga, NDBuilt 1968 · S/N 25-4704
Back to AD 99-01-05 R1