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.

N82346Ross Douglas · Front Royal, VAS/N 18-7709162N82351Stasak Michael P Trustee · Sterling, AKBuilt 1977 · S/N 18-7709145N82353Billingsley Lowe J · Absarokee, MTBuilt 1978 · S/N 18-7809178N82368Williams Frank · Kerrville, TXBuilt 1977 · S/N 18-7709149N82371Texas Bar Triangle LLC Plane Series · Mason, TXS/N 18-7709148N8237CKieszkowski Joseph S · Stilwell, KSFirst renewal noticeBuilt 1954 · S/N 22-2323N82388Stephens Grant A · Palmer, AKBuilt 1977 · S/N 18-7709151N82391Trester Boyd H · Sentinel Butte, NDBuilt 1977 · S/N 18-7709152N82398Irwin Jeffrey C · Poland, NYBuilt 1977 · S/N 18-7709154N82405Womack Bert E · Anchorage, AKBuilt 1979 · S/N 18-7909096N8240CLewis Jonathan · Hadley, MABuilt 1954 · S/N 22-2326N8240PForsgren Keith · Wasilla, AKBuilt 1963 · S/N 18-8045N82422Bishop Boyd · Gillette, WYBuilt 1979 · S/N 18-7909098N82424Skow Perry M · Harrison, IDS/N 18-7709163N82443Dolat Jacqueline M · Kenai, AKBuilt 1977 · S/N 18-7709166N82448Fejes Guide Service Ltd · Anchorage, AKBuilt 1979 · S/N 18-7909099N82452Snyder Matthew A · Tok, AKS/N 18-7809139N82453Zimmerman Tyler J · Sterling, AKBuilt 1978 · S/N 18-7809179N82464Guthrie Richard A · Anchorage, AKBuilt 1978 · S/N 18-7809142N82474Lundberg John Arthur · Palos Verdes Est, CAS/N 18-7809146N82479Cairns Douglas S · Bozeman, MTBuilt 1977 · S/N 18-7709155N82481Bickman Jim W · Eagle River, AKBuilt 1978 · S/N 18-7809145N82486Edwards Hillary M · Katy, TXS/N 18-7709156N8248CFisher Charlton Dru · Houston, TXBuilt 1954 · S/N 22-2334N82491Mcmahan Bryan W · Gakona, AKBuilt 1976 · S/N 18-7809180N82493Gila Aviation Co LLC · Whitefish, MTBuilt 1977 · S/N 18-7709167N8249CGifford Steven K · Buskirk, NYBuilt 1954 · S/N 22-2351N824JTRenfro Jacqueline L · Bethel, AKBuilt 1957 · S/N 18-6040N82502Christofferson Kevin · Fruita, COBuilt 1977 · S/N 18-7709169N82504Pentecost Benjamin I · Puyallup, WABuilt 1978 · S/N 18-7809181N82505Kunkle Christopher · Santa Ynez, CABuilt 1978 · S/N 18-7809182N82508Jones Matthew B · Wasilla, AKBuilt 1978 · S/N 18-7809183N8250CAcme Cub Training Inc · Anchorage, AKS/N 18-3674N82518Zeafla Randall Reis · Elizabethtown, KYBuilt 1978 · S/N 18-7809184N82520Newman Scott W · Healdsburg, CABuilt 1977 · S/N 18-7709170N82526Verbridge Gary · Williamson, NYFirst renewal noticeBuilt 1977 · S/N 25-7756052N8252CRoberts Dave C · Wibaux, MTBuilt 1954 · S/N 18-3677N8252PMontgomery Daniel G · Wasilla, AKBuilt 1963 · S/N 18-8035N82530Flowers Christopher L · Anchorage, AKBuilt 1978 · S/N 18-7809187N82544Cronquist Korey J · Wasilla, AKBuilt 1979 · S/N 18-7909001N82547Jeffries Aviation LLC · Kalispell, MTS/N 18-7909003N82555Landeis Keith · Mandan, NDS/N 18-7909006N82563Registered aircraftBuilt 1977 · S/N 18-7709014N82566Low James E · Fairbanks, AKBuilt 1978 · S/N 18-7909008N82577Sale Reported · Wasilla, AKSale reportedBuilt 1978 · S/N 18-7909009N82591Cornia Mike D · Wasilla, AKBuilt 1978 · S/N 18-7909010N82598Foothill Aviation LLC · Iliamna, AKBuilt 1978 · S/N 18-7909012N82600Hendrickson Ryan H · Gunnison, UTBuilt 1978 · S/N 18-7909013N82613Wammen Ranch Llp · Reva, SDS/N 18-7909015N82617Cooper Holly B · Friendswood, TXBuilt 1978 · S/N 18-7909017
Back to AD 99-01-05 R1