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.

N723CCavner Hudson A · Port Alsworth, AKS/N 18-1150N7241DFrisby James A · Palmer, AKBuilt 1957 · S/N 22-5262N7242ZHamilton Randel L · Quitaque, TXBuilt 1965 · S/N 25-3167N7243VRobarge Chad Steven · Duluth, MNBuilt 1947 · S/N 123238N72448Clay Jason I · Imperial Beach, CABuilt 1957 · S/N 185841N72454Dawson Adam J · Eveleth, MNBuilt 1952 · S/N 18-1715N7245KKnuckles Dennis P Trustee · Custer, SDBuilt 1950 · S/N 18-140N7247DTodey Mark A · Rathburn, IABuilt 1957 · S/N 22-5073N7247KLangley Preston B · Warwick, NDBuilt 1950 · S/N 18-142N7248DLeeuw Timothy P · Dillon, MTBuilt 1957 · S/N 22-5074N7248KHarnisch Brandon R · Shelton, WABuilt 1950 · S/N 18-134N7248ZAerial Banners Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3177N7249DHansen Larry G · Alliance, NEBuilt 1957 · S/N 22-5075N7250DTrump Roger L · Greenville, OHBuilt 1957 · S/N 22-5076N7252DCox Craig A · Spencerville, OHS/N 22-5078N7252KEgan Bailey J · Forsyth, MTBuilt 1950 · S/N 18-147N7252ZAerial Banners Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3184N7254KCook Tim L · Eagle River, AKBuilt 1950 · S/N 18-149N7255ZCentral Ms Soaring Society LLC · Brandon, MSS/N 25-3189N72573Hunter Tim W · Meadville, PABuilt 1954 · S/N 18-2772N7257DArctic Aero LLC · North Pole, AKBuilt 1957 · S/N 22-5084N7258DVandemerwe Rilyn Grant · Durango, COBuilt 1957 · S/N 22-5085N7259KLavigne Richard P · Ranier, MNBuilt 1950 · S/N 18-153N726Veerhusen Daniel F · Homer, AKS/N 18-8309021N7263ZAnderson Daniel A · Overly, NDBuilt 1965 · S/N 25-3200N7265DThomas Les L · Jordan, MTS/N 18-5673N7265KSale Reported · Phoenix, AZSale reported, canceledBuilt 1950 · S/N 18-158N7268DLarsen Daniel R · Kenai, AKBuilt 1957 · S/N 18-5676N726JVGill James J · Anchorage, AKBuilt 1978 · S/N 18-7809088N7270DYoung Evan G · Anchorage, AKBuilt 1957 · S/N 18-5678N7271DCape May Aerial Advertising LLC · Cape May Ch, NJBuilt 1957 · S/N 18-5679N7273DWheatland Aviation LLC · Clark, SDBuilt 1957 · S/N 18-5681N7273KPetik Neil · Barney, NDBuilt 1950 · S/N 18-182N7276DDolfi Ricky Jr · Palmer, AKS/N 18-5685N7276KSaunders Timothy S · Utopia, TXBuilt 1950 · S/N 18-184N7277KBaker Thomas A · Tijeras, NMBuilt 1950 · S/N 18-183N7278DAugustin Caleb J · Madison, ALS/N 18-5691N7278KHolden Daniel N · Anacortes, WABuilt 1950 · S/N 18-185N7279KRaven Wings LLC · Talkeetna, AKBuilt 1950 · S/N 18-187N727DBKeating John C · Prosper, TXBuilt 1954 · S/N 18-4119N727TDLean Aviation LLC · Saint Augustine, FLBuilt 1970 · S/N 18-8909N7280DLavin Gregory S · Chugiak, AKBuilt 1957 · S/N 18-5693N7281DMartin Michael J · Anchorage, AKBuilt 1957 · S/N 18-5695N7282ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1965 · S/N 25-3222N7283KTuttle Jeffery D · Victoria, TXBuilt 1950 · S/N 18-195N7287KClapp Carl W · Edmonds, WAS/N 18-199N7287ZQuality Aviation Inc · Marana, AZBuilt 1965 · S/N 25-3229N7288KAgha Thanoon J · Anchorage, AKBuilt 1950 · S/N 18-201N7289KIberlin Christian J · Gillette, WYBuilt 1950 · S/N 18-200N7289ZWerth John F · Hays, KSBuilt 1965 · S/N 25-3232
Back to AD 99-01-05 R1