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.

N7086BHebert Wesley · Everett, WABuilt 1956 · S/N 18-5168N7087DRecknagel Martin D · Delta Junction, AKBuilt 1957 · S/N 18-5575N7087ZCochrane Aaron W · Lake Bronson, MNBuilt 1964 · S/N 25-2872N7088BParker John J · Monroe, ORBuilt 1956 · S/N 18-5170N70897International Air Services Inc Trustee · Carson City, NVS/N 17984N7089BPurkinje Ltd LLC · Wilmington, DEBuilt 1956 · S/N 18-5172N7089KMz Aviation LLC · Mason, OHBuilt 1950 · S/N 20-194N7089ZAzskyad LLC · Avondale, AZBuilt 1964 · S/N 25-2875N7090KUlibarri Christopher G · Abilene, TXBuilt 1950 · S/N 20-198N7090ZSales Joe H · Seminole, TXBuilt 1964 · S/N 25-2876N70914Schumacher Bradley R · Elma, NYBuilt 1946 · S/N 17934N7092ZHollister Soaring Center LLC · Hollister, CABuilt 1964 · S/N 25-2879N7093BBackcountry Aviation LLC · Berthoud, COFirst renewal noticeBuilt 1957 · S/N 18-5176N7093KMoyers Tommy E · Portland, ARBuilt 1950 · S/N 20-199N7093ZMid Continent Aircraft Corp · Hayti, MOBuilt 1964 · S/N 25-2880N70940Payne Ronald J II · Wasilla, AKS/N 18-7909188N7094DPotter Kent · Laurel, MTBuilt 1957 · S/N 18-5584N7096DPolecat Bottoms LLC · Jenks, OKS/N 18-5586N7098KHensley Roger A · Rosamond, CAS/N 20-206N7099KLach Richard · Weldon, CAS/N 20-207N7099YSparks Richard A · Wasilla, AKS/N 18-8135N70BTBurg Robert L · Fairbanks, AKBuilt 1974 · S/N 18-7409098N70LMIrving Mark S · Cordova, AKBuilt 1946 · S/N 12-490N71014Hofmann John M · Columbus, WIBuilt 1946 · S/N 18030N7106BSlaughter D Wayne · Farmsville, NCBuilt 1956 · S/N 22-4325N7106DHarris & Associates Inc · Scottsdale, AZBuilt 1957 · S/N 22-4964N7106KClark Patrick C · Charlotte, NCBuilt 1950 · S/N 18-322N7108DWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1957 · S/N 22-4966N7108HLindsey Roy W · Quinlan, TXBuilt 1946 · S/N 20362N7109BEastin Toby M · Jefferson City, MOBuilt 1956 · S/N 22-4326N7109KSheffield Vana Riggs Executrix · Amarillo, TXS/N 18-328N7110BSeven-Eleven Brick Inc · Dalton, MNBuilt 1956 · S/N 22-4327N7111DKeyt Jeffrey D · New Providence, NJBuilt 1957 · S/N 22-4969N7112KHamann Hunter R · Spokane, WABuilt 1950 · S/N 18-329N7112MHardy Russell E · North Pole, AKS/N 122192N7113DN7113d LLC · Ardmore, OKBuilt 1957 · S/N 22-4971N7113KSavland Andy M · Hoonah, AKBuilt 1950 · S/N 18-332N7114BShore Brian R · Carmichael, CABuilt 1956 · S/N 22-4331N7114DPierce Brian L · Grants Pass, ORBuilt 1957 · S/N 22-4972N7114ZSchwend Brian · Forsyth, MTBuilt 1964 · S/N 25-2909N7115KHuseby Terry L · Hulett, WYBuilt 1950 · S/N 18-333N7116DSeelinger Donald P · Seldovia, AKBuilt 1957 · S/N 22-4976N7117BSale Reported · Chelsea, MISale reportedBuilt 1956 · S/N 22-4334N7117KKlutsch Joseph R · King Salmon, AKS/N 18-340N7119BDelaney Patrick J · Marion, TXBuilt 1956 · S/N 22-4336N711CSHodack Steven J · Burton, MIS/N 11-687N711TSStarr William E · Eagle River, AKBuilt 1976 · S/N 18-7609046N7120DWeiss James R · Westlake, OHBuilt 1957 · S/N 22-4980N7121DBohrman Robert C · New Berlin, WIBuilt 1957 · S/N 22-4981N7121PLecren Douglas · Wasilla, AKBuilt 1958 · S/N 18-7121
Back to AD 99-01-05 R1