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.

N4936ZDomeyer Daylen K · Cincinnati, OHS/N 22-8528N49387Old Aire LLC · Bellingham, WAS/N 5-1493N4938MAbel William F · Billings, MTBuilt 1947 · S/N 11-1610N4938YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4738N4939HMassas LLC · Fairbanks, AKBuilt 1948 · S/N 11-814N4942MVold Steven A Trustee · Billings, MTBuilt 1948 · S/N 11-549N4943HRohl Richard · Euclid, OHBuilt 1948 · S/N 11-819N4943ZBlackford Robert G · Mt Airy, MDBuilt 1961 · S/N 22-8538N4944ZHoppes Larry J · Springville, INBuilt 1961 · S/N 22-8540N4945ZWillis James · Pelham, ALBuilt 1961 · S/N 22-8541N4947ZSatreaas Kenneth A · Verona, NDBuilt 1961 · S/N 22-8543N4948Andersen Bret E · Chugiak, AKBuilt 1969 · S/N 18-8745N4948ZSenn Joshua · Depauw, INBuilt 1961 · S/N 22-8545N4949MCorben Sport Planes Museum LLC · Toccoa, GAS/N 20-640N4949ZPeeples Ryan · Folkston, GABuilt 1961 · S/N 22-8546N49500Chain Steven R · Cottonwood, CABuilt 1942 · S/N G-3N4950MMerimont Aviation LLC · Dyersburg, TNBuilt 1948 · S/N 11-435N4951MNicholson Daniel L · Painesville, OHBuilt 1948 · S/N 11-436N4952HLeyva Gregory G · Wilbur, WABuilt 1948 · S/N 11-827N4953HRay Jonas R · Lakebay, WABuilt 1948 · S/N 11-818N4955MBlake Clark D · Belle Fourche, SDS/N 11-440N4955ZSmetana Arthur E · Elmwood Park, NJBuilt 1961 · S/N 22-8561N4956HNewton Donald H · Lewistown, MTFirst renewal noticeS/N 11-830N4957EKuckkahn Dale P · Lake Tomahawk, WIS/N 22-4222N4957GSanford Mark J · Ithaca, NYBuilt 1947 · S/N 11-9N4957HHalsted Barry J Trustee · Sequim, WABuilt 1948 · S/N 11-831N4957MHarris Lloyd A · Bozeman, MTBuilt 1948 · S/N 11-443N4958HWeil Susan L · Minden, NVBuilt 1948 · S/N 11-832N4958ZDacy Roy Wayne · Kingsland, TXBuilt 1961 · S/N 22-8560N4959MDowns M Todd · Stephenville, TXBuilt 1948 · S/N 11444N495TMMacdonald Kenneth A · Willow, AKBuilt 1980 · S/N 18-8109001N4960HPadden Kelly R · Ludlow, SDS/N 11-834N4960ZTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1961 · S/N 22-8562N4961HMarquart Ricky L · Lakota, NDBuilt 1948 · S/N 11-835N4961MBarnette James S · Queenstown, MDS/N 11-447N4961YSprenger Michael T · Hawley, MNBuilt 1973 · S/N 18-7309020N49621Albertson James M · Westville, FLS/N G-189N4962MRegistration Pending · Beeville, TXRegistration pendingBuilt 1948 · S/N 11-448N4964MStone Douglas R · Northborough, MABuilt 1948 · S/N 11-450N4964YFowler Larry K · Harrison, ARBuilt 1968 · S/N 25-4676N4964ZYoung Jimmy D · Watson, ARBuilt 1961 · S/N 22-8567N4965MClark Ernest Edgar · Spearfish, SDBuilt 1948 · S/N 11-451N4966HMeyer Chester A · Ekalaka, MTBuilt 1948 · S/N 11-840N4966MMedearis Jeff · Plevna, MTS/N 11-452N4966YSchmitt Rudy · Brookshire, TXBuilt 1968 · S/N 25-4767N4966ZIberlin John P · Gillette, WYBuilt 1961 · S/N 22-8573N4967MPietsch Warren A · Minot, NDBuilt 1948 · S/N 11-453N4968MAerial Crop Care Company · Hebron, NDBuilt 1948 · S/N 11-455N4968ZGomm Bruce J · Shawano, WIBuilt 1961 · S/N 22-8572N4969MMotes James T · Winston, GABuilt 1948 · S/N 11-456
Back to AD 99-01-05 R1